Countries
| CountryName |
| United States |
| Canada |
| Mexico |
| France |
| Germany |
Regions
| RegionName | CountryId |
| (→ Countries.id) |
| Northeast | 1 |
| Southwest | 1 |
| Central | 1 |
| Atlantic | 1 |
Cities
| CityName | RegionId |
| (→ Regions.id) |
| New York | 1 |
| Los Angeles | 2 |
| Chicago | 3 |
| Houston | 4 |
Populations
| CityId | Year | TotalPopulation |
| (→ Cities.id) | | |
| 1 | 2000 | 8000000 |
| 1 | 2010 | 8396000 |
| 1 | 2020 | 8960000 |
AgeDemographics
| CityId | Year | MedianAge | AgeRange | PopulationGroup |
| (→ Cities.id) | | | | |
| 1 | 2000 | 35 | 18-34 | Young Adults |
| 1 | 2010 | 37 | 35-44 | Adults |
| 1 | 2020 | 39 | 45-54 | Older Adults |
Ethnicity
| CityId | Year | WhitePercentage | BlackOrAfricanAmericanPercentage | AsianPercentage | HispanicOrLatinoPercentage |
| (→ Cities.id) | | | | | |
| 1 | 2000 | 60 | 15 | 10 | 20 |
| 1 | 2010 | 61 | 16 | 11 | 22 |
| 1 | 2020 | 62 | 17 | 12 | 23 |