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:
Average positivity rate by month:
States with the highest testing rate per 100,000 in the last week:
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.
Last updated