Housing Foreclosures 2003 - 2022

Foreclosure is the process through which lenders recover the amount owed on a defaulted mortgage by selling or taking ownership of the property securing the loan. This data set tracks housing foreclosures at three points during the process: filing of a petition to foreclose, scheduling of a foreclosure auction, and filing of a foreclosure deed.

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-foreclosures-2003-2022-y82j-c2bw\".\"housing_foreclosures_2003_2022\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.