COVID-19 Diagnostic Laboratory Testing Dataset

About the Dataset

The COVID-19 Diagnostic Laboratory Testing Dataset offers a comprehensive view of COVID-19 PCR testing conducted across the United States from March 2020 through June 2024. Sourced from official records, this dataset provides reliable and up-to-date information on testing trends, virus spread, and the impact of testing strategies over time. It is an invaluable resource for researchers, public health officials, and analysts seeking to understand the evolution of the COVID-19 pandemic in the United States.

Dataset Features

Comprehensive Coverage: Includes all reported PCR tests conducted across the U.S. during the pandemic period, from March 2020 to June 2024.
Time Series Analysis: Enables tracking and analyzing testing trends over more than four years, providing insights into the pandemic's evolution.
Geographical Insights: Data available at various geographic levels, allowing for localized analysis.
Daily Updates: Regularly updated to ensure access to the most current information.
Easy Integration: Provided in a flattened table format for easy querying and integration with other datasets.

Data Quality and Maintenance

Data Source: Official COVID-19 Diagnostic Laboratory Testing dataset, ensuring reliability and accuracy.
Update Frequency: Daily updates to maintain current and relevant information.
Quality Assurance: Rigorous data validation processes to ensure accuracy and consistency.
Historical Data: Preservation of historical data allows for trend analysis and retrospective studies.

Business Applications

Public Health Policy Development
Healthcare Resource Allocation
Epidemiological Research
Risk Assessment and Mitigation Strategies
Vaccine Distribution Planning
Economic Impact Analysis

Example Use Cases

Trend Analysis: Track testing rates and positivity trends over time to inform public health decisions.
Geographical Comparisons: Compare testing efforts and outcomes across different states or regions.
Healthcare Capacity Planning: Use testing data to predict and prepare for potential surges in hospitalizations.
Vaccine Efficacy Studies: Correlate vaccination rates with testing outcomes to assess vaccine effectiveness.
Policy Impact Assessment: Analyze how different testing strategies or public health measures affect case numbers.

Data Structure

The dataset is structured as a flattened table with the following key columns:

Report Date
State
FIPS Code
Total Test Results Reported
Total Positive Test Results Reported
Total Negative Test Results Reported
Number of Facilities Reporting
Total Tests Performed
Testing Rate per 100,000

Sample Queries

Here are some example SQL queries to get started with the dataset:

Total tests performed by state in the last 30 days:

SELECT State, SUM(Total_Tests_Performed) AS Total_Tests
FROM COVID19_Testing_Data
WHERE Report_Date >= DATEADD(day, -30, CURRENT_DATE())
GROUP BY State
ORDER BY Total_Tests DESC;

Average positivity rate by month:

SELECT 
    DATE_TRUNC('month', Report_Date) AS Month,
    AVG(Total_Positive_Test_Results_Reported / NULLIF(Total_Test_Results_Reported, 0)) * 100 AS Avg_Positivity_Rate
FROM COVID19_Testing_Data
GROUP BY Month
ORDER BY Month;

States with the highest testing rate per 100,000 in the last week:

SELECT State, AVG(Testing_Rate_per_100000) AS Avg_Testing_Rate
FROM COVID19_Testing_Data
WHERE Report_Date >= DATEADD(day, -7, CURRENT_DATE())
GROUP BY State
ORDER BY Avg_Testing_Rate DESC
LIMIT 10;

Support and Contact

For questions, support, or more information about the COVID-19 Diagnostic Laboratory Testing Dataset, please contact:

About Dataplex

Dataplex Consulting & Data Products is a comprehensive data consulting firm that empowers clients with reliable cloud data and analytics solutions. Our team of certified experts in data engineering and analytics offers tailored services to support data-driven enterprises. We provide high-quality data products available on various platforms including the Snowflake Marketplace, Datarade Marketplace, Databricks Marketplace, Google Analytics Hub, and SAP Datasphere.

PreviousCMS NPPES Provider Dataset NextFDA Device Dataset

Last updated 3 months ago

SELECT DATE_TRUNC('month', Report_Date) AS Month, AVG(Total_Positive_Test_Results_Reported / NULLIF(Total_Test_Results_Reported, 0)) * 100 AS Avg_Positivity_Rate FROM COVID19_Testing_Data GROUP BY Month ORDER BY Month;