COVID-19 Cases by Zip Code Current Health NO FURTHER UPDATES
Weekly updates have finished.
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-no-tsf6-pnaf\".\"covid19_cases_by_zip_code_current_health_no\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.