Colnbrook One-Place Study

History of a village on an important road.

Print Bookmark

Statistics


Surnames

Overview - Surnames - Occupations - DNA Matches - By Period
Filter By -


Exact surname match:
Enter a place and/or surname or choose from dropdown menu.
 Collapse Filter
Matches: 826 to 850 of 1555 Surnames

«Prev «1 ... 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 ... 63» Next»

An error has occurred in the TNG software. What to do:

If you just installed an upgrade, you might have skipped part of the installation instructions. Go back to the upgrade readme page reread the instructions. Pay special attention to the database structure step.

If you just installed TNG for the first time, you might still need to create the database tables. Return to the readme.html page to find that step.

If you are the site owner, you may contact TNG support for further assistance with this problem. Please copy the query below and paste it into your message.



Query: SELECT lastname, YEAR( deathdatetr ) - YEAR( birthdatetr ) AS yearsold, DAYOFYEAR( deathdatetr ) - DAYOFYEAR( birthdatetr ) AS daysold, IF(DAYOFYEAR(deathdatetr) and DAYOFYEAR(birthdatetr),TO_DAYS(deathdatetr) - TO_DAYS(birthdatetr),(YEAR(deathdatetr) - YEAR(birthdatetr)) * 365) as totaldays FROM tng_people WHERE lastname = ""Unnamed"" AND birthdatetr != '0000-00-00' AND deathdatetr != '0000-00-00' AND birthdate not like 'AFT%' AND deathdate not like 'AFT%' AND birthdate not like 'BEF%' AND deathdate not like 'BEF%' AND birthdate not like 'ABT%' AND deathdate not like 'ABT%' AND birthdate not like 'BET%' AND deathdate not like 'BET%' AND birthdate not like 'CAL%' AND deathdate not like 'CAL%' ORDER BY totaldays DESC

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Unnamed"" AND birthdatetr != '0000-00-00' AND deathdatetr != '0000-00-00' AN' at line 5
 Surnames    Total Individuals  (7201)  Total Males   Total Females   Total Unknown Gender   Earliest Birth   Latest Birth   Average Lifespan 
 Thorn  2   (0.03%)  0      2   (100%)   0      1839    1839    N/A 
 Tillyer  2   (0.03%)  1   (50%)   1   (50%)   0      1816    1816    N/A 
 Tonks  2   (0.03%)  2   (100%)   0      0      1850    1850    N/A 
 Townsend  2   (0.03%)  2   (100%)   0      0      N/A   N/A   N/A 
 Wadley  2   (0.03%)  0      2   (100%)   0      1806    1813    N/A 
 Wainwright  2   (0.03%)  0      2   (100%)   0      1814    1839    N/A 
 Walton  2   (0.03%)  1   (50%)   1   (50%)   0      1818    1858    N/A 
 Ward  2   (0.03%)  1   (50%)   1   (50%)   0      N/A   N/A   N/A 
 Warrington  2   (0.03%)  1   (50%)   1   (50%)   0      N/A   N/A   N/A 
 Weekley  2   (0.03%)  1   (50%)   1   (50%)   0      1721    1721    62 years, 0 days 
 Willats  2   (0.03%)  1   (50%)   1   (50%)   0      1876    1876    N/A 
 Wooderson  2   (0.03%)  2   (100%)   0      0      1823    1823    N/A 
 Woodman  2   (0.03%)  0      2   (100%)   0      1844    1844    N/A 
 Yates  2   (0.03%)  0      2   (100%)   0      1786    1786    64 years, 0 days 
 Yelland  2   (0.03%)  1   (50%)   1   (50%)   0      N/A   N/A   N/A 
 Yeoman  2   (0.03%)  1   (50%)   1   (50%)   0      N/A   N/A   N/A 
 Youngs  2   (0.03%)  2   (100%)   0      0      1793    1793    80 years, 0 days 
  Brister  1   (0.01%)  1   (100%)   0      0      N/A   N/A   N/A 
 "Unnamed"  1   (0.01%)  1   (100%)   0      0      1815    1815