📄 All-in-One 650+ US Cities Social Data (2010–2024) — Product Description
Overview
This package provides a complete, research-ready dataset of 677 U.S. cities (population ≥65,000), harmonized and formatted for direct analysis or visualization. Covering 2010–2024, it offers unparalleled insight into local social and living conditions — the ideal resource for journalists, researchers, policymakers, housing advocates, and data enthusiasts.
Each city package includes standardized Excel datasets and clean chart exports, bundled into a comprehensive All-in-One archive.
Data Coverage
Social & Living Indicators (2010–2024):
Median household income 💵
Median gross rent 🏠
Median home value 🏡
Rent burden (% of households spending ≥30% income on rent) 📉
Poverty rate (% of population below poverty line) 📊
Unemployment rate 📉
High school enrollment & graduation rates 🎓
College enrollment & graduation rates 🎓
Population 👥
What You Get
✅ Excel Workbooks (XLSX) — clean, city-level datasets for every year available (2010–2024).
✅ PNG Charts — publication-ready visuals for percent indicators, population, income, rent, and home value.
✅ ZIP Archives per City — tidy packages containing both data and charts.
✅ Master All-in-One ZIP — the entire 677-city dataset in one download.
✅ README & Methodology — full documentation of sources, methods, and caveats.
Sources
U.S. Census Bureau – American Community Survey (ACS), 1-Year Estimates (2010–2024)
B19013: Median Household Income
B25064: Median Gross Rent
B25077: Median Home Value
B17001: Poverty Status by Age
S1401: School Enrollment
S1501: Educational Attainment
Bureau of Labor Statistics (BLS) – Local Area Unemployment Statistics (2010–2024)
HUD CHAS (Comprehensive Housing Affordability Strategy) — Rent burden metrics
Puerto Rico ACS — for qualifying PR municipalities
Methods
Population Threshold: Cities included only if population ≥65,000 in ACS 1-Year estimates.
Standardization: Data harmonized across years; missing years may occur when cities fell below 65k threshold.
Indicators: Percent variables calculated directly from ACS/BLS tables.
Outputs:
Each city ZIP contains /data/ (Excel) and /charts/ (PNG).
All-in-One master archive aggregates 677 city ZIPs.
Automation: Data pulled and processed with Apps Script + Python pipelines for reproducibility.
Notes & Caveats
West Virginia and Vermont are excluded (no qualifying ≥65k cities).
Some cities appear partway (when they first pass 65k population).
Margins of error (MOEs) not included — consult ACS tables for official reliability.
Data is standardized but not adjusted for inflation or cost-of-living differences.
Provided as-is, based on best-available government data.
Format
👉 Excel (XLSX), PNG Charts, and ZIP Bundles — ready for direct use in Excel, R, Python, Google Sheets, Tableau, or Datawrapper.
Citation
If you use this package, please cite:
StateFinance.org – US Cities Social Data Package (2010–2024), compiled from U.S. Census Bureau ACS, BLS LAUS, and HUD CHAS data.