← Charles Gannsen Research / Check the data

Web copy of data/README.md, the file the book cites at https://charles-research.netlify.app/data/README.md; that address forwards to this page.

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.FileWhat it isRowsHow read
D1leads.csv (generated from leads.json)Every boy baptized at Trendelburg, Deisel and Friedrichsfeld born 1833–41, followed forward412pages
D1bboy-fates-1833-41.csvD1 with the fate group of each boy (chart and table in the book)412pages
D2lagis-releases-eight-villages.csvLAGIS "Hessische Auswanderer" entries for the eight villages of today’s Trendelburg, 1832–661,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
D2achain-migration-by-period.csvShare of those released who followed an earlier emigrant of the same surname and village5derived from D2
D2bfamily-chains-3plus-years.csvVillage surnames released in three or more different years28derived from D2
D3village-emigrant-destinations.csv (own README)Where the emigrant parties of the three villages settled44by row
D4ship-arrivals.csvVillage parties found on passenger lists, 1848–6579 (73 main, 6 neighboring towns)by row (coverage)
D5charles-manifest-sweeps.mdPassenger lists and indexes searched for Charles; all negative—by row
D6surname-forms.csvEach record giving Charles's surname, 1862–190357pages
D7census1870_read_log.csvPages of the 1870 St. Louis census read line by line3,353 (3,351 pages + 2 index passes)pages
D8stl-search-log-candidates.csv, stl-search-log.csvSt. Louis searches for the boys and for the emigrant parties, with control searches1,076; 121index
D9search-coverage.csvParish registers searched for Charles's baptism46 rows, 57 placesby 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
D11stlouis-kurhessian-marriages-1850-80.csvKurhessian marriage entries, St. Marcus, Holy Ghost and St. Peter's104pages
D12charles-family-sponsors-1866-81.csvWitnesses at Charles's wedding and godparents of his children17pages

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.