healthdata-gov/covid19-diagnostic-laboratory-testing-pcr-testing-j8mb-icvb
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

COVID-19 Diagnostic Laboratory Testing (PCR Testing) Time Series

<br>This time series dataset includes viral COVID-19 laboratory test Polymerase chain reaction (PCR) results from over 1,000 U.S. laboratories and testing locations including commercial and reference laboratories, public health laboratories, hospital laboratories, and other testing locations. Data are reported to state and jurisdictional health departments in accordance with applicable state or local law and in accordance with the Coronavirus Aid, Relief, and Economic Security (CARES) Act (<a href="https://www.hhs.gov/sites/default/files/covid-19-laboratory-data-reporting-guidance.pdf">CARES Act Section 18115</a>).</br>

<br>Data are <b>provisional and subject to change</b>.</br>

<br>Data presented here is representative of diagnostic specimens being tested - not individual people - and excludes serology tests where possible. Data presented might not represent the most current counts for the most recent 3 days due to the time it takes to report testing information. The data may also not include results from all potential testing sites within the jurisdiction (e.g., non-laboratory or point of care test sites) and therefore reflect the majority, but not all, of COVID-19 testing being conducted in the United States.</br>

<br><b>Sources:</b> CDC COVID-19 Electronic Laboratory Reporting (CELR), Commercial Laboratories, State Public Health Labs, In-House Hospital Labs</br>

<br>Data for each state is sourced from either data submitted directly by the state health department via COVID-19 electronic laboratory reporting (CELR), or a combination of commercial labs, public health labs, and in-house hospital labs. Data is taken from CELR for states that either submit line level data or submit aggregate counts which do not include serology tests.</br>

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-diagnostic-laboratory-testing-pcr-testing-j8mb-icvb\".\"covid19_diagnostic_laboratory_testing_pcr_testing\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_diagnostic_laboratory_testing_pcr_testing
     
     
     
     
     
Upstream Metadata