pa-gov/covid19-aggregate-death-data-current-weekly-county-fbgu-sqgp
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 18 hours ago
Indexed 3 hours ago

COVID-19 Aggregate Death Data Current Weekly County Health

This dataset contains aggregate death data at the state and county level for Pennsylvania residents. The data are displayed by county, date, death counts, averages, rates based on population. Pennsylvania statewide numbers are listed with Pennsylvania named as the county for the statewide totals. Do not add up the entire file (all rows) or counts will be duplicated.

Data will be updated midafternoon each Wednesday.

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 \"pa-gov/covid19-aggregate-death-data-current-weekly-county-fbgu-sqgp\".\"covid19_aggregate_death_data_current_weekly_county\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_aggregate_death_data_current_weekly_county
     
     
     
     
     
Upstream Metadata