← Charles Gannsen Research / Check the data
The data behind Charles Gannsen and His Family
Compiled by Jed S. Johnson. Version of 3 November 2026. These are the datasets described in the book's appendix "The Data Behind This Book" (D1–D12). Each is a plain UTF-8 CSV (or Markdown for D5), one row per record, and every row names the original record it comes from.
How read. "pages" (or [pages], "read in the pages") means every entry was read in the image of the original. "index" (or [index], "index only") means the entry comes from a name index or an abstract: a pointer, never proof that a record does not exist.
Grades. The book's four grade words: proven; very probably; probably; possibly. "Landing only" means an arrival was found and nothing later in America is tied to it.
Privacy. No living person appears in these files. Every dataset ends before 1904, except the names database, which is not offered here (see D10).
How to cite. Jed Johnson, comp., "[dataset title]," dataset, version of [date], in Charles Gannsen and His Family, appendix "The Data Behind This Book," dataset D[n]; file at https://charles-research.netlify.app/data/[file]. When you use one entry, cite its original record too.
| No. | File | What it is | Rows | How read |
|---|---|---|---|---|
| D1 | leads.csv (generated from leads.json) | Every boy baptized at Trendelburg, Deisel and Friedrichsfeld born 1833–41, followed forward | 412 | pages |
| D1b | boy-fates-1833-41.csv | D1 with the fate group of each boy (chart and table in the book) | 412 | pages |
| D2 | lagis-releases-eight-villages.csv | LAGIS "Hessische Auswanderer" entries for the eight villages of today’s Trendelburg, 1832–66 | 1,314 entries; 794 people (one per village, surname, forenames and release year; 822 when the unnamed children listed under one head are counted by birth year; the charts and the chain table count each person once, from build 12) | index |
| D2a | chain-migration-by-period.csv | Share of those released who followed an earlier emigrant of the same surname and village | 5 | derived from D2 |
| D2b | family-chains-3plus-years.csv | Village surnames released in three or more different years | 28 | derived from D2 |
| D3 | village-emigrant-destinations.csv (own README) | Where the emigrant parties of the three villages settled | 44 | by row |
| D4 | ship-arrivals.csv | Village parties found on passenger lists, 1848–65 | 79 (73 main, 6 neighboring towns) | by row (coverage) |
| D5 | charles-manifest-sweeps.md | Passenger lists and indexes searched for Charles; all negative | — | by row |
| D6 | surname-forms.csv | Each record giving Charles's surname, 1862–1903 | 57 | pages |
| D7 | census1870_read_log.csv | Pages of the 1870 St. Louis census read line by line | 3,353 (3,351 pages + 2 index passes) | pages |
| D8 | stl-search-log-candidates.csv, stl-search-log.csv | St. Louis searches for the boys and for the emigrant parties, with control searches | 1,076; 121 | index |
| D9 | search-coverage.csv | Parish registers searched for Charles's baptism | 46 rows, 57 places | by row |
| D10 | (not offered; see names-database.html on the website) | Names database, ~101,000 rows, most from Klaus Kunze's published family books and the Dornette database | — | by row |
| D11 | stlouis-kurhessian-marriages-1850-80.csv | Kurhessian marriage entries, St. Marcus, Holy Ghost and St. Peter's | 104 | pages |
| D12 | charles-family-sponsors-1866-81.csv | Witnesses at Charles's wedding and godparents of his children | 17 | pages |
Fields
D1 leads.csv. id parish letters and number (TR, DE, FR); ring 0; parish; register Archion register; bild image; nro entry number; born date of birth; name as baptized (surname in capitals); parents; out_of_wedlock True/False; priority A–C (search order); status Died young / Eliminated / Probably traced / Untraced; record the record that settles him; next_action; settling_record; archion_url.
D1b boy-fates-1833-41.csv. id; parish; born; name; out_of_wedlock; ledger_status; fate_group (died in childhood; stayed in Germany, at home or place not named; moved to a named German town or Prussia; emigrated overseas; probably traced (still open); untraced (still open)); record; archive_reference. Fate groups come from keyword rules on record with seven hand corrections (TR-105, TR-330, DE-305, TR-153, DE-487, FR-43, FR-76), in figs_data_charts.py. "Stayed" includes boys who died as adults in Germany.
D2 lagis-releases-eight-villages.csv. lagis_id; entry_as_indexed; village; release_year; born (YYYY-00-00 when only the year is given); trade; destination; party (alone or "Auswanderung mit Familie"); partner; family; means (unitless as indexed); archive_reference (HStAM Best. 180 Hofgeismar Nr.); page; dependent (yes = listed under a head); person_key (village | surname | forenames, in one standard spelling | year). One person = one person_key with one year of birth. Releases are permissions to leave, not proven departures; some 1858–60 volumes are missing.
D2a. period; people; followers_loose, pct_loose (an earlier release of the same surname from the same village); followers_strict, pct_strict (one at least two years earlier, under another first forename); Kurhessen_pct_Wegge1998 (Wegge, J. Econ. Hist. 58 (1998): 973).
D4 ship-arrivals.csv. Original columns: party_id; surname; members; village; release_year; ship; departure_port; arrival_port; arrival_date; manifest_ages_or_trades; age_or_trade_matches_release_index; traveled_with_other_villagers; grade (old free text, kept); how_read; source_file; notes; n_people; voyage_key (ship|date|port); scope (named village / adjacent). Added 2 Nov 2026: placement_grade (proven / very probably / probably / possibly / landing only / none stated); coverage ([pages] when the list was read in the image, else [index]); charles_note; grade_review, grade_review_note (14 rows whose old wording needed judgment).
D6 surname-forms.csv. year; form; family (Ga-, Go-, K-/C-, J-, Johnson); type (his own hand; newspaper notice; church register; census and federal records; city directory); record; src; grade (directory lines only).
D7, D8, D9. Column names are as in the files; see the book's appendix for definitions.
D11. register; years; img; date (with entry number); persons; heimath (home places as written; [?] = uncertain reading); kreis (district of the first Kurhessian party, by first place name); source (session log); read.
D12. event; date; person_as_written; role; identification_grade_per_ext64; origin; kurhessian; source.
Regenerating
scripts/figs_data_charts.py (the three charts and the fate groups), scripts/normalize_ship_grades.py (D4 added columns), scripts/make_data_staged.py (D1b, D2 and the copies). scripts/check_research_tables.py reruns them when their inputs change.