​​

                                                            Data Last Updated: 9/18/2025

​

📦 Budget & Social/Living Data Report Packages  

 

Each package includes:
   📑 Visual PDF Report — Budget trends (2012–2023) and social/living trends (2010–2024), with a clear breakdown of the                    most recent year.
   📊 Shares XLSX — Spending by category as % of total budget (0–1 scale, 2012–2023).
   💵 Amounts XLSX — Dollar spending by category (2012–2023).
   🏠 Living Data XLSX + Charts — Median income, rent, home value, rent burden, poverty, unemployment,                                         education attainment, education enrollment, population & homelessness (2010–2024) — with ready-to-use charts.
   📘 README & Methodology — Documentation on sources, harmonization, and caveats.

 

Harmonized budget schema (2012–2023):
   🎓 Education
   🧑‍🤝‍🧑 Public Welfare
   🏥 Health & Hospitals
   🛣 Highways
   🚔 Police Protection
   🏛 Corrections
   🌲 Natural Resources
   🏞 Parks & Recreation
   📂 Financial Administration
   💳 Interest on Debt
   ➕ Other

    - Note on Shares: Functional budget shares are rounded to one decimal place. As a result, totals may not equal exactly 100%.          This rounding convention follows common statistical reporting standards. Nominal dollars: Dollar amounts are reported             in nominal terms (not inflation-adjusted).

​​

Why it matters:
With consistent budget data (2012–2023) plus social & living indicators (2010–2024), you can compare across years and states with confidence.

​

Harmonized social & living schema (2010–2024):

💵 Median Household Income
💰 Median Rent
🏡 Median Home Value
📊 Rent Burden (≥35% of income)
📉 Poverty Rate
📋 Unemployment Rate
🎓 Education Attainment
📚 Education Enrollment
👥 Population
🛏️ Homelessness

 - Social/living data excludes 2020 due to disruption of ACS data collection.

​

​

📦US Cities Social Data Packages

 

Each package includes:

   ✅ Excel Workbook (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.
   📘  README & Methodology — full documentation of sources, methods, and caveats.

​

Categories covered (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

   - 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.

​

 

📦 Crime Data Packages

 

Each package includes:
   📈 Counts XLSX + Rates Charts — annual counts xlsx and charts showing population-adjusted rates (per 100,000 residents)            for all categories for comparability across time and states.
   📘 README & Methodology — Documentation on sources, reporting changes, and caveats.

 

Categories covered (1979–2024):
   🔪 Violent Crime (total)
   🏚 Property Crime (total)
   ☠ Homicide
   ⚖ Rape (legacy & revised definitions)
   💰 Robbery
   👊 Aggravated Assault
   🔓 Burglary
   👜 Larceny-Theft
   🚗 Motor Vehicle Theft

   - Crime data important notes & limitations: SRS → NIBRS transition (circa 2021): agency participation and imputation              vary; some states show measurement breaks or increased volatility.

 

Why it matters:
With standardized state-level crime data (1979–2024), you can analyze long-term trends, make cross-state comparisons, and visualize public safety shifts over four decades.​

 

Ideal For:

   📰 Journalists — quick state snapshots for budget, social, and crime reporting
   🎓 Researchers & Educators — clean time-series inputs for analysis or teaching
   🏛 Policymakers — benchmarking peers & tracking fiscal, social, and safety trends
   📈 Data Enthusiasts — instant charts & insight without messy prep