COVID-19 Community Vulnerability Crosswalk - Crosswalk by Census Tract

This crosswalk weighs communities down to the census tract with COVID-19 data, considering disease morbidity and mortality, as well as social and economic contextual data. To do this, this spreadsheet crosswalks four key open datasets: Hardest Hit Area, Low Income Area, Tribal Community, and Rural Community, and uses the FCC's scoring methodology to weigh them to provide an evaluation of the most vulnerable communities in the country.

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 \"healthdata-gov/covid19-community-vulnerability-crosswalk-x2y5-9muu\".\"covid19_community_vulnerability_crosswalk\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.