hegnauer.family
hegnauer.family

Data

Take the data with you

The study’s public people, records and tree, as files a spreadsheet or a family-tree program can open. They are made fresh each time the site is updated.

Exported Records added up to 28 September 2026

  • CSV

    People

    2,098 people

    Everyone in the study who has died: names, sex, birth and death (or baptism and burial) with dates and places, line, family links as IDs, and their WikiTree, FamilySearch and Find a Grave numbers.

    Download 389 KB

    The 23 columns
    id
    The permanent H-number (H0001)
    name
    The name the study uses
    given_names
    Given names
    surname
    Surname at birth, as the study spells it
    suffix
    Jr., Sr. and the like
    sex
    M, F or U (not known)
    birth_event
    Birth, or Baptism where that is the earliest record
    birth_date
    As the study writes it: "8 Dec 1819", "about 1866", "before 1887"
    birth_place
    Place, region, country
    death_event
    Death, or Burial
    death_date
    As above
    death_place
    As above
    lifespan
    The short form the site shows ("1819–aft. 1890")
    line
    The family line, where one is assigned
    parent_ids
    H-numbers, separated by semicolons
    spouse_ids
    H-numbers, separated by semicolons
    child_ids
    H-numbers, separated by semicolons
    has_biography
    yes if the study has written up this life in full
    records
    How many records are linked to this person
    wikitree_id
    WikiTree ID, where there is one
    familysearch_id
    FamilySearch Family Tree ID
    findagrave_id
    Find a Grave memorial number
    url
    This person’s page

  • CSV

    Records

    6,524 records

    Every record in the archive: the name as written, the event, date and place, the source and collection, the person it is linked to and how firmly, the citation, and a link to the original.

    Download 3.5 MB

    The 21 columns
    id
    The permanent O-number (O01533)
    date
    As the record gives it
    year
    The year, for sorting
    name_as_written
    The name exactly as the clerk wrote it
    given
    Given names as written
    surname
    Surname as written: one of the name’s many spellings
    event
    Baptism, burial, census, obituary…
    category
    The archive’s grouping of events
    place_as_written
    The place as the record gives it
    place
    The same place, in the study’s standard form
    role
    The person’s part in the record (the one baptised, a parent, a witness…)
    source
    Where the record was found (FamilySearch, Newspapers.com…)
    collection
    The collection or database
    person_id
    The H-number of the person it is linked to, if any
    person_name
    That person’s name
    link_grade
    How firmly: confirmed, probable, possible, or unlinked
    original
    A link to the original, where there is one
    citation
    The source citation
    notes
    The study’s notes on the record
    added
    When the record joined the study
    url
    This record’s page

  • GEDCOM 5.5.1

    The tree

    2,098 people in 689 families

    The public tree for a genealogy program (Gramps, RootsMagic, Family Tree Maker, Legacy and most others): people, births and deaths, and families, each person pointing back to their page here.

    Download 811 KB

    What the file holds
    • INDI: each person, with name, sex, birth (or baptism) and death (or burial), and the links to their families.
    • FAM: each couple or lone parent, with the children and the marriage where the study has one.
    • Dates in GEDCOM’s own terms: ABT, BEF, AFT, BET … AND; anything unusual keeps the study’s wording in brackets.
    • Coordinates for places the study has pinned to a town or parish.
    • A source citation on every person, pointing to their page here with the evidence.

The IDs

Every person has an H-number (H0001) and every record an O-number (O01533). They are permanent: names get respelled and pages get renamed, but the numbers never change, so they are the safe way to join the files, or to point back to the study.

  • In the people file, parent_ids, spouse_ids and child_ids hold H-numbers, separated by semicolons.
  • In the records file, person_id is the H-number of the person the record is linked to.
  • In the GEDCOM, each person’s record ID is their H-number (@H0001@), and it is repeated as a reference number (REFN).
  • Every row ends with the address of its page, where the evidence is.

What is in them, and what isn’t

Living people are not in any file, not even as a surname, and nobody’s family links point to them. They can wait. How the study decides who is living is on the about page.

Dates and places are given as the study records them, qualifiers and all. A record’s link_grade says how sure the study is that it belongs to its person; the grades are explained here. The facts are only as good as their sources, so check the page before you build on one.

The files use UTF-8, so Graubünden and Zürich keep their umlauts; the CSVs open straight into Excel, Numbers or Google Sheets.

Using the data

Free to reuse with credit to the Hegnauer One-Name Study, hegnauer.family.

A citation with the date you downloaded the files is the kindest credit, since they change as the study grows:

Cite the data

Evidence Explained

Hegnauer One-Name Study, “Public data: people, records and tree (export of 28 September 2026),” hegnauer.family (https://hegnauer.family/data/ : accessed 28 September 2026).

Chicago (notes)

“Public data: people, records and tree (export of 28 September 2026),” hegnauer.family, Hegnauer One-Name Study, accessed September 28, 2026, https://hegnauer.family/data/.

The files are remade from the study at every update, so the citation carries the date you downloaded them.