DOHMH Covid-19 Milestone Data: Percent of NYC residents tested who tested positive

7434-7ua6Health6 columns

This dataset shows daily citywide counts of persons tested by nucleic acid amplification tests (NAAT, also known as a molecular test; e.g. a PCR test) for SARS-CoV-2 , counts of persons with positive tests, and the percent positivity. Also included is a calculation of the average percent positivity over a 7-day period. NAAT tests work through direct detection of the virus’s genetic material, and typically involve collecting a nasal swab. These tests are highly accurate and recommended for diagnosing current COVID-19 infection. After specimen collection, molecular tests are processed in a laboratory, and results are electronically reported to the New York State (NYS) Electronic Clinical Laboratory Results System (ECLRS). Test results for NYC residents are then sent electronically to NYC DOHMH. There is typically a lag of a few days between when a specimen is collected and when a result is reported to NYC DOHMH. Data is sourced from electronic laboratory reporting from NYS ECLRS. All identifying health information is excluded from the dataset.

View on NYC Open Data

Quality

C72.0 / 100

From a 470-row sample across 6 columns.

completeness95/ 25% weight

consistency50/ 20% weight

accuracy97/ 20% weight

timeliness0/ 15% weight

usability95/ 20% weight

Related datasets

Sample rows

date	total_test	positive_test	percent_positive	percent_positive_7days_agg	uptdate
2021-05-22T00:00:00.000Z	20079	355	0.0177	0.0112	2021-06-12T23:30:11.000Z
2020-09-28T00:00:00.000Z	44355	543	0.0122	0.0151	2021-03-17T14:17:47.000Z
2020-03-05T00:00:00.000Z	65	4	0.0615	—

Columns

6 queryable · 6 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`date`	datetime	—	0%	`2021-04-08T00:00:00.000Z2020-07-09T00:00:00.000Z2020-07-10T00:00:00.000Z`
`total_test`	integer	—	0%	`736193254564489`
`positive_test`	integer	—	0%	`435406566`
`percent_positive`	float	—	0%	`0.01730.01720.0177`
`percent_positive_7days_agg`

Query this from your own app

GET /api/datasets/7434-7ua6
GET /api/datasets/7434-7ua6/quality
GET /api/datasets/7434-7ua6/related
GET /api/columns?dataset=7434-7ua6