Bericht: Vorfahren in Connecticut

         Beschreibung: Familienmitglieder die in Connecticut geboren wurden oder gestorben sind.

SQL: SELECT tng_people.living, tng_people.private, lnprefix, prefix, suffix, title, tng_people.branch, birthdate, birthdatetr, altbirthdate, altbirthdatetr, deathdate, deathdatetr,lastname, firstname,birthdate,birthplace,deathdate,deathplace,(if(sex='M',families1.wife,families2.husband)) as spouse, tng_people.personID, tng_people.gedcom, nameorder FROM (tng_people ) LEFT JOIN tng_families AS families1 ON (tng_people.gedcom = families1.gedcom AND tng_people.personID = families1.husband ) LEFT JOIN tng_families AS families2 ON (tng_people.gedcom = families2.gedcom AND tng_people.personID = families2.wife ) WHERE ((birthplace LIKE "%Connecticut%" OR deathplace LIKE "%Connecticut%") AND (tng_people.private != 1)) AND tng_people.gedcom = "0001" ORDER BY lastname

Treffer 1 bis 6 von 6

#	Nachname, Taufnamen	Geburtsdatum	Geburtsort	Sterbedatum	Sterbeort	Partner-Name
1	Foram, William E.	1880	Connecticut, USA			Schillinger, Pauline
2	Kierspe, Grace W.	31 Mrz 1890	Waterbury, New Haven Co, Connecticut, USA	1970	Queens Co, New York City, New York State, USA	Steup, Paul George
3	Kilcoyne, John F. jr.	1 Feb 1924	Brooklyn, Kings Co, New York City, New York State, USA	29 Feb 2016	Enfield, Hartford Co, Connecticut, USA	Muccio, Ruth
4	Schulze, Eldor Paul	26 Mrz 1905	Middletown, Middlesex Co, Connecticut, USA
5	Steup, Grace C.	um 1909	Norwalk, Fairfield Co, Connecticut, USA			Donahue, William F.
6	Steup, Katherine Alwine	9 Jan 1914	Bridgeport, Fairfield Co, Connecticut, USA			Thiele, n.n.

Diese Website läuft mit The Next Generation of Genealogy Sitebuilding v. 14.0.3, programmiert von Darrin Lythgoe © 2001-2025.

Betreut von Admin - Bei Steup's.