COVID-19 PCR Test Counts March 2020 - Current Statewide Health NO FURTHER UPDATES
<B> COVID-19 testing files will no longer be updated after 5/10/2023 </B>
This dataset contains the aggregate number of COVID-19 PCR test results reported to the Department of Health per day. It includes tests with positive, negative, and inconclusive results. If the same test result (identified by having the same patient, collection date, and result) was reported more than once (either accidentally or reported by both the ordering facility and the performing lab), it is counted only once in this data. Only tests performed on Pennsylvania residents are included. <br>
PCR (Polymerase Chain Reaction) tests detect the RNA genetic material in the COVID-19 virus. PCR tests can be performed on specimens collected in a variety of ways, most often from nasopharyngeal (NP), nasal, oral or throat swabs, or saliva collection.
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-pcr-test-counts-march-2020-current-r6ti-va88\".\"covid19_pcr_test_counts_march_2020_current\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.