JEM Genealogy
Ornes Moore Motley Echols Edwards Fackler Parsons Reynolds Smith Brown Bruce Munger Beer Kern Viele Nims Baker Bondurant Von Krogh Magnus Munthe and others
First Name:  Last Name: 
[Advanced Search]  [Surnames]
Home Search Login  
Share Print Bookmark
You are currently anonymous

Statistics


Surnames

Overview - Surnames - By Period - Veterans
Filter By -


Exact surname match:
Enter a place and/or surname or choose from dropdown menu.
 Collapse Filter
Matches: 6651 to 6700 of 7375 Surnames

«Prev «1 ... 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 ... 148» 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 = "Powhatan ("Royal blood line")" 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 'Royal blood line")" AND birthdatetr != '0000-00-00' AND deathdatetr != '0000-0' at line 5
 Surnames    Total Individuals  (54940)  Total Males   Total Females   Total Unknown Gender   Earliest Birth   Latest Birth   Average Lifespan 
 Denzy  1   (0%)  0      1   (100%)   0      1565    1565    59 years, 0 days 
 Rootes  1   (0%)  0      1   (100%)   0      1800    1800    35 years, 49 days 
 of Huntingdon  1   (0%)  0      1   (100%)   0      1072    1072    58 years, 0 days 
 Thomasdatter Fincke  1   (0%)  0      1   (100%)   0      1595    1595    69 years, 259 days 
 Fitzhugh (Henry)  1   (0%)  0      1   (100%)   0      1734    1734    5 years, 189 days 
 Groves  1   (0%)  0      1   (100%)   0      1812    1812    N/A 
 Moon 1st Lieut. 14th Va.  1   (0%)  1   (100%)   0      0      1756    1756    40 years, 0 days 
 Jacobsen Qvislin  1   (0%)  1   (100%)   0      0      1733    1733    N/A 
 Yaroslavna  1   (0%)  0      1   (100%)   0      1036    1036    53 years, 0 days 
 Vijdt  1   (0%)  0      1   (100%)   0      1575    1575    55 years, 0 days 
 Tillisch  1   (0%)  1   (100%)   0      0      1720    1720    41 years, 134 days 
 Poulitier  1   (0%)  0      1   (100%)   0      1558    1558    57 years, 0 days 
 Harrelson (Haralson)  1   (0%)  0      1   (100%)   0      1694    1694    48 years, 0 days 
 Daubenhyer  1   (0%)  0      1   (100%)   0      1839    1839    34 years, 0 days 
 Tony  1   (0%)  0      1   (100%)   0      1869    1869    N/A 
 Gast  1   (0%)  0      1   (100%)   0      1894    1894    N/A 
 Martyn  1   (0%)  0      1   (100%)   0      1574    1574    41 years, 165 days 
 Brynjulvsson  1   (0%)  1   (100%)   0      0      1575    1575    N/A 
 Wettermann  1   (0%)  0      1   (100%)   0      1645    1645    62 years, 0 days 
 Bale  1   (0%)  0      1   (100%)   0      1685    1685    70 years, 0 days 
 Whitford  1   (0%)  0      1   (100%)   0      1691    1691    67 years, 68 days 
 Sjødin  1   (0%)  1   (100%)   0      0      1920    1920    77 years, 173 days 
 Terriot  1   (0%)  0      1   (100%)   0      1650    1650    63 years, 0 days 
 Haymes  1   (0%)  0      1   (100%)   0      1928    1928    68 years, 45 days 
 Eitinear  1   (0%)  1   (100%)   0      0      1792    1792    85 years, 36 days 
 Wallfurlong  1   (0%)  0      1   (100%)   0      N/A   N/A   N/A 
 Wolcott  1   (0%)  0      1   (100%)   0      1662    1662    43 years, 164 days 
 Powhatan ("Royal blood line")  1   (0%)  0      1   (100%)   0      1590    1590