pa-gov/covid19-cases-by-zip-code-current-health-tsf6-pnaf
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 5 days ago
Indexed 22 minutes ago

COVID-19 Cases by Zip Code Current Health

Aggregate cases (confirmed and probable) of COVID-19. Counts represent the number of unique people, not the number of tests. <br>

For cases, the ZIP code represents the best residential address received around the time they were first identified as a case. Persons with no known residential address are not included. <br>

<B>Only valid PA ZIP codes are included. </B> <br>

Aggregate counts of 1 through 4 for each zip code are suppressed to help protect confidentiality and are displayed as null/blank.

Prior Dataset was titled - COVID-19 Cases and Persons Testing Negative by PCR by Zip Code Current Health. We are not reporting Negative testing anymore.

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-cases-by-zip-code-current-health-tsf6-pnaf\".\"covid19_cases_by_zip_code_current_health\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_cases_by_zip_code_current_health
     
     
     
     
     
Upstream Metadata