Icon for Socrata external plugin
Open repository in Console
Updated 2 months ago
Indexed 2 hours ago

Housing Database Project Level Files - Inactive Included

The NYC Department of City Planning’s (DCP) Housing Database contains all NYC Department of Buildings (DOB)-approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010, this version also includes inactive jobs. It includes all three construction job types that add or remove residential units: new buildings, major alterations, and demolitions, and can be used to determine the change in legal housing units across time and space. Records in the Housing Database are geocoded to the greatest level of precision possible, subject to numerous quality assurance and control checks, recoded for usability, and joined to other housing data sources relevant to city planners and analysts.

There are two versions of the project level Housing Database:

1) HousingDB_post2010 - all active and completed jobs

2) HousingDB_post2010_inactive_included - all active, completed jobs and inactive jobs (includes withdrawn, stalled, or duplicate jobs)

Data are updated semiannually, at the end of the second and fourth quarters of each year.

Please see DCP’s annual Housing Production Snapshot summarizing findings from the 22Q4 data release <a href="">here</a>. Additional Housing and Economic analyses are also <a href="">available</a>.

All previously released versions of this data are available at <a href="">BYTES of the BIG APPLE- Archive</a>.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/housing-database-project-level-files-inactive-br6q-ssj3\".\"housing_database_project_level_files_inactive\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • housing_database_project_level_files_inactive
Upstream Metadata