Median Rent by Borough, 2024 (USD/month)
Manhattan maintains the highest monthly rent while Staten Island remains most affordable.
Source: NYC Open Data · Period: 2024 · View diagnostics
Independent Research
A data-driven exploration of how rents and wages moved in tandem — or didn't.
New York is my family's home and my testing ground for honest analysis. As a backend engineer and data analyst, I wanted to move past headlines and measure how rents, wages, and neighborhood change actually moved together from 2010 to 2024. Using public NYC sources (housing, permits/rezonings), BLS wages, and ACS, I built a reproducible pipeline to clean, join, and quality-check the data. The goal is decision-ready insight: which areas saw affordability pressure rise fastest, when the curve changed direction, and which signals a renter, planner, or team should watch next.
The rebound after the Great Recession and the pandemic surge never reset rents. Prices eased only briefly while wages moved slower, especially in subway-rich areas that stayed desirable.
Analyzing 14 years of borough-level data across five NYC boroughs.
From raw feeds to comparable borough signals
ACS one-year tables for income, NYC Open Data housing feeds for rent medians, BLS wage files, DOB permits, and DCP rezonings.
Inflation-adjusted all rents to 2024 dollars, trimmed outliers, harmonized tract-to-borough lookups, and filled short gaps with rolling medians.
Built a transit proximity index, zoning change counts, and inflation-aware wage bands to link spatial and temporal shifts.
Reconciled figures against NYC Housing and Vacancy Survey, ran regression diagnostics, and flagged borough-year anomalies for manual review.
Rents represent median asking rent per month; incomes are median household in nominal terms before CPI adjustment; transit index ranges 0–100; latest five years anchor modeling.
Four views that anchor the narrative
Manhattan maintains the highest monthly rent while Staten Island remains most affordable.
Source: NYC Open Data · Period: 2024 · View diagnostics
Each borough shows a steady climb with Brooklyn and Queens accelerating fastest after 2012.
Source: NYC Open Data · Period: 2010–2024 · View diagnostics
Rent tracks income, but high-transit borough-years sit above the trend, tightening budgets.
Source: ACS + MTA + NYC Open Data · Period: 2010–2024 · View diagnostics
Two major rent spikes frame the period—the post-recession run-up and the 2021 rebound.
Source: NYC Open Data · Period: 2011–2024 · View diagnostics
| Source | Link | Period | Granularity | License | Notes | 
|---|---|---|---|---|---|
| NYC Open Data: Housing Indicators | Portal | 2010–2024 | Borough, annual | Open Data Commons | Median asking rent and unit counts. | 
| ACS 1-year Estimates (Table B19013) | data.census.gov | 2010–2024 | Borough, annual | Public domain | Median household income, CPI-adjusted. | 
| Bureau of Labor Statistics QCEW | bls.gov/cew | 2015–2024 | City, quarterly | Public domain | Average wages, converted to borough-weighted estimates. | 
| MTA GTFS feeds | new.mta.info/developers | 2010–2024 | Station, weekly | Open Government | Transit proximity index inputs. | 
| NYC Department of Buildings Permits | nyc.gov/buildings | 2010–2024 | Permit, daily | Open Data Commons | Filtered for residential change signals. | 
A fast tour through the pipeline, tools, and decisions that shaped this analysis.
Borough-level tract reconciliation: ACS and NYC Open Data ship incompatible geography keys. I built a lookup that maps tract IDs to boroughs with 99.8% coverage and flags outlier geos like airports and parks.
Result: Continuous year-over-year comparisons without manual patching.