HelpDatabase Reference › Ancestry_Ethnicity

Ancestry_Ethnicity Table

The Ancestry_Ethnicity table is a simple code-to-value lookup that maps A*’s internal ethnicity-region codes to display names. It is keyed by code, with the readable label in value.

This is the older ethnicity lookup. It is distinct from the newer region tables (Ancestry_EthnicityRegion and Ancestry_MatchEthnicityRegion), which carry per-match percentages and macro-region grouping. Ancestry_Ethnicity stores only the name behind a code.

Column Reference

ColumnTypeSourceDescription
codestring (PK)BundlerA*’s internal ethnicity-region code
valuestringBundlerHuman-readable region name for the code

How It’s Populated

Entries are upserted from A*’s bundled resource strings during gathering. The app reads each ethnicity.region.name.* property, using the suffix as the code and the property value as the display value.

Related Tables

  • Ancestry_EthnicityRegion — the newer region lookup with macro-region grouping and version.
  • Ancestry_MatchEthnicityRegion — per-match ethnicity percentages by region.