Dataset: New York State Statewide COVID-19 Testing

About this Dataset

New York State Statewide COVID-19 Testing

Context

New York State Statewide COVID-19 Testing

Content

This dataset includes information on the number of tests of individuals for COVID-19 infection performed in New York State beginning March 1, 2020, when the first case of COVID-19 was identified in the state. The primary goal of publishing this dataset is to provide users timely information about local disease spread and reporting of positive cases. The data will be updated daily, reflecting tests completed by 12:00 am (midnight) the day of the update (i.e., all tests completed by the end of the day on the day before the update).

Reporting of SARS-CoV2 laboratory testing results is mandated under Part 2 of the New York State Sanitary Code. Clinical laboratories, as defined in Public Health Law (PHL) § 571 electronically report test results to the New York State Department of Health (DOH) via the Electronic Clinical Laboratory Reporting System (ECLRS). The DOH Division of Epidemiology’s Bureau of Surveillance and Data System (BSDS) monitors the reporting and ensures that all positives and negatives are accurate. Test counts reflect those completed on an individual each day. A person may have multiple specimens tested on one day, these would be counted one time, i.e., if two specimens are collected from an individual at the same time and then evaluated, the outcome of the evaluation of those two samples to diagnose the individual is counted as a single test of one person, even though the specimens may be tested separately. Conversely, if an individual is tested on more than one day, the data will show two tests of an individual, one for each date the person was tested.

Test counts are assigned to a county based on this order of preference:

the patient’s address;
the ordering healthcare provider’s address;
the ordering facility’s address.

Additional information

Data Provided by

New York State Department of Health

Dataset Owner

Open Data NY - DOH

Acknowledgements

Thanks to health.data.ny.gov.

Dataset Owner:

Bureau of Surveillance and Data Systems, Division of Epidemiology, Center for Community Health

Tables

New York State Statewide Covid 19 Testing

@kaggle.muhakabartay_new_york_state_statewide_covid19_testing.new_york_state_statewide_covid_19_testing

89.23 KB
7998 rows
6 columns


CREATE TABLE new_york_state_statewide_covid_19_testing (
  "test_date" TIMESTAMP,
  "county" VARCHAR,
  "new_positives" BIGINT,
  "cumulative_number_of_positives" BIGINT,
  "total_number_of_tests_performed" BIGINT,
  "cumulative_number_of_tests_performed" BIGINT
);