Housing Median Sales Prices 2002 - 2021

Median sales prices for various type of residential properties based on arms length, market rate sales. The data used to develop median prices comes from records filed at the South Middlesex Registry of Deeds. City staff analyze the records to identify arms-length sales. Arms-length sales are real-estate transactions in which two or more unrelated and unaffiliated parties agree to do business, acting independently and in their self-interest. Statistics drawn from only arms-length transactions are thought to best represent the true value of a property and state of the market.

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-median-sales-prices-2002-2021-9nnq-4isb\".\"housing_median_sales_prices_2002_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.