Countries

CountryName
United States
Canada
Mexico
France
Germany

Regions

RegionNameCountryId
(→ Countries.id)
Northeast1
Southwest1
Central1
Atlantic1

Cities

CityNameRegionId
(→ Regions.id)
New York1
Los Angeles2
Chicago3
Houston4

Populations

CityIdYearTotalPopulation
(→ Cities.id)
120008000000
120108396000
120208960000

AgeDemographics

CityIdYearMedianAgeAgeRangePopulationGroup
(→ Cities.id)
120003518-34Young Adults
120103735-44Adults
120203945-54Older Adults

Ethnicity

CityIdYearWhitePercentageBlackOrAfricanAmericanPercentageAsianPercentageHispanicOrLatinoPercentage
(→ Cities.id)
1200060151020
1201061161122
1202062171223