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

Browse percentage fields

Show allShowing 10 of 76

Column Name	Data 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.

Page 1 of 8