HCD Property Investments FY10-Q1 22

Address-level dataset of of properties receiving HCD services from July 1, 2009 - March 31, 2022 (FY10-Q1 22). Data was combined in June-July 2020 from multiple sources, including IDIS (HUD data and reimbursement system), tracking spreadsheets maintained by HCD managers, and WAPez (weatherization data system).

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 \"memphistn-gov/hcd-property-investments-fy10q1-22-62rn-kka3\".\"hcd_property_investments_fy10q1_22\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.