Housing Database by 2020 CDTA

Net change in housing units arising from new buildings, demolitions, or alterations for specified geography (Census Block, Census Tract, City Council district, Community District, Community District Tabulation Area (CDTA), Neighborhood Tabulation Area (NTA). These tables are aggregated from the DCP Housing Database, which is derived from Department of Buildings (DOB)-approved housing construction and demolition jobs filed or completed in NYC since January 1, 2010. Net housing unit change is calculated as the sum of 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. <br>

<b>NOTE: Housing Database by PUMA has been sunset as of the 20q4 release. Anyone looking for housing database at the PUMA level should use the Housing Database by 2020 CDTA dataset, which is a similar geography but not an exact equivalent.</b><br>

All previously released versions of this data are available at the <a target="_blank" href="https://www1.nyc.gov/site/planning/data-maps/open-data/bytes-archive.page?sorts%5byear%5d=0">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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofnewyork-us/housing-database-by-2020-cdta-48dt-mn3z\".\"housing_database_by_2020_cdta\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.