Housing Stock and Residential Properties by Neighborhood: 2023

The data incorporates information on building permits, certificates of occupancy, lodging houses, and university owned housing, as well as Community Development Department information on the development pipeline. To assure equivalent treatment across the city, all apartment-style graduate student housing operated by local universities is included in the housing and property counts. These figures used here are a snap shot of the housing stock as of June 30, 2023.

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 \"cambridgema-gov/housing-stock-and-residential-properties-by-wiba-69ua\".\"housing_stock_and_residential_properties_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.