COVID Hotels and Respite Homeless Shelters and General County Populations Demographics
Compares demographic characteristics of COVID respite and hotel shelters operating March 2020 to June 2022 with all single adults in shelters and total homeless population from the point-in-time count on 1/23/2020 and total county population from the US Census American Community Survey for 2018. Multiracial American Indians are counted in "American Indian" for the respite and hotel shelters and singles shelters whereas all multiracial persons in other data sets are counted in the category "Multiracial".
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 \"ramseycounty-us/covid-hotels-and-respite-homeless-shelters-and-4cp3-ac92\".\"covid_hotels_and_respite_homeless_shelters_and\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.