Emergency Temporary Shelters - Limited Stay Exits - By Shelter and Date

Under <a href="https://chicityclerkelms.chicago.gov/Matter/?matterId=6DEAA6D8-D0E6-EE11-904C-001DD806E058" target="_blank">SO2024-0008386</a>, passed by City Council on 4/17/2024, the Department of Family and Support Services publishes data on the City-operated and City-funded emergency new arrivals shelters. This series of datasets contains data related to the <a href="https://www.chicago.gov/city/en/sites/texas-new-arrivals/home/faqs.html" target="_blank">Limited Stay Policy</a>. This dataset shows the total number of migrants who exited each shelter under this policy, each day.

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 \"cityofchicago/emergency-temporary-shelters-limited-stay-exits-by-hfse-pzih\".\"emergency_temporary_shelters_limited_stay_exits_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.