NYC Housing
PLUTO, HPD violations, HPD affordable production. Three datasets that, joined, expose the gap between the city's production rhetoric and its delivered outcomes — the 27-month lease-up gap that suppresses affordable housing availability for years, the corporate-veil pattern that lets serial-offender landlords hide behind dozens of LLCs, and the upzoning literature that found density gains without rent relief. Live SoQL against the NYC Open Data Socrata portal.
Stories
Twenty-seven months in the Bronx
A 180-unit affordable building was complete in 2022. Eighteen months after the lottery had closed and the waitlist filled, no one had moved in. The lease-up bottleneck that suppresses affordable housing availability for years after construction is physically done.
Who owns this building?
Twelve buildings citywide generated more than 20 Class C — immediately hazardous — housing violations apiece since 2024. The named owner is always an LLC. The beneficial owner is always findable. The corporate-veil-piercing pattern at the heart of NYC tenant advocacy.
Datasets
PLUTO — every NYC tax lot
The Department of City Planning's Primary Land Use Tax Lot Output. ~860K tax lots, ~70 fields each — zoning district, land use, building class, year built, residential units, assessed value. The substrate beneath nearly every quantitative urban-policy paper written about NYC.
HPD Maintenance Code Violations
Every Housing Maintenance Code violation issued by HPD. Joins to PLUTO via BBL. The substrate beneath every "worst landlord" feature, the join key for tenant-advocacy tools that pierce LLC corporate-veil opacity to identify serial offenders.
HPD Affordable Housing Production
Every affordable housing project the city has financed under Housing New York and successor programs. Unit counts segmented by AMI band — what "affordable" actually means depends on which bands you include in the headline.