Metrics

Metrics Table

The Metrics (or “Master”) table contains raw and derived demographic values at the geography level, including population totals, income figures, and education counts. These are unnormalized values often used as the starting point for analysis.

📌 Note: The Metrics table always includes all geographic columns such as StateFIPS, CountyName, TractFIPS, ZipCode, etc., so you don’t need to join separately to access names or locations.

Use when:

• You want to build your own ratios, comparisons, or metrics.
• You need absolute counts (e.g., total households, number of children under 5).
• You're preparing features for machine learning models that require raw data.
• You plan to calculate custom benchmarks or re-aggregate to larger areas.

---

Table Linking

All three tables — Metrics, Percentages, and Percentiles — can be joined using a shared primary key depending on the geography level:

• BlockGroupID for block group-level data
• StateCountyTractID for tracts
• ZipCode for ZIP-level data
• StateCountyID for counties
• MSA_ID for metro areas
• StateFIPS for state-level data

This makes it easy to pull in raw values, normalized percentages, and national percentiles side-by-side in your analysis or app.

---

Field Summary

Field	Type	Example	Description
TOTAL_POPULATION	FLOAT	1993	Total number of people in the geography.
TOTAL_HOUSEHOLDS	FLOAT	681	Total number of households.
MEDIAN_AGE	FLOAT	43.4	Median age of all residents.
FEMALE_POPULATION	FLOAT	967	Total female population.
MALE_POPULATION	FLOAT	1026	Total male population.
POPULATION_DENSITY	FIXED DECIMAL	2720.08	Population per square mile.
MEDIAN_HOUSEHOLD_INCOME	FLOAT	194850	Median income of all households.
TOTAL_INCOME	FLOAT	142189400	Aggregate total income of the area.
GINI_INDEX	FLOAT	0.282757	Measure of income inequality (0 = perfect equality, 1 = perfect inequality).
POP_ABOVE_POVERTY_LEVEL	FLOAT	1961	Population above the poverty threshold.
POP_BELOW_POVERTY_LEVEL	FLOAT	18	Population below the poverty threshold.
HOUSEHOLD_INCOME_LESS_THAN_30K	FLOAT	14	Households earning under $30,000.
HOUSEHOLD_INCOME_30K_TO_59K	FLOAT	33	Households earning between $30,000–$59,999.
HOUSEHOLD_INCOME_60K_TO_99K	FLOAT	58	Households earning between $60,000–$99,999.
HOUSEHOLD_INCOME_100K_TO_149K	FLOAT	125	Households earning between $100,000–$149,999.
HOUSEHOLD_INCOME_150K_AND_ABOVE	FLOAT	451	Households earning $150,000 and above.
HISPANIC_LATINO	FLOAT	67	People of Hispanic or Latino origin.
BLACK_AFRICAN_AMERICAN	FLOAT	298	Black or African American alone population.
WHITE	FLOAT	1527	White alone population.
CHILDREN_PER_HOUSEHOLD	FIXED DECIMAL	0.8	Average children per household.
DEGREE_HOLDERS	FLOAT	1255	People with a bachelor’s degree or higher.
MEDIAN_PROPERTY_VALUE	FLOAT	393400	Median property value in the area.
COMMUTE_WORK_FROM_HOME	FLOAT	187	Number of individuals who work from home.
TRAVEL_TIME_TO_WORK_20_TO_40_MINS	FLOAT	166	Commuters with travel time between 20–40 minutes.
WITH_HEALTH_INSURANCE	FLOAT	1940	People covered by any type of health insurance.
WITHOUT_HEALTH_INSURANCE	FLOAT	36	People not covered by any health insurance.
INTERNET_VIA_CELL_DATA_PLAN	FLOAT	645	Households using a cellular data plan for internet.
CITIZENS_VOTING_AGE	FLOAT	1416	Citizens of voting age (18+).