DOHMH Covid-19 Milestone Data: New Cases of Covid-19 (7 Day Average)

xwtc-hedqHealth9 columns

This dataset shows daily confirmed and probable cases of COVID-19 in New York City by date of specimen collection. Total cases has been calculated as the sum of daily confirmed and probable cases. Seven-day averages of confirmed, probable, and total cases are also included in the dataset. A person is classified as a confirmed COVID-19 case if they test positive with a nucleic acid amplification test (NAAT, also known as a molecular test; e.g. a PCR test). A probable case is a person who meets the following criteria with no positive molecular test on record: a) test positive with an antigen test, b) have symptoms and an exposure to a confirmed COVID-19 case, or c) died and their cause of death is listed as COVID-19 or similar. As of June 9, 2021, people who meet the definition of a confirmed or probable COVID-19 case >90 days after a previous positive test (date of first positive test) or probable COVID-19 onset date will be counted as a new case. Prior to June 9, 2021, new cases were counted ≥365 days after the first date of specimen collection or clinical diagnosis. Any person with a residence outside of NYC is not included in counts. Data is sourced from electronic laboratory reporting from the New York State Electronic Clinical Laboratory Reporting System to the NYC Health Department. All identifying health information is excluded from the dataset. These data are used to evaluate the overall number of confirmed and probable cases by day (seven day average) to track the trajectory of the pandemic. Cases are classified by the date that the case occurred. NYC COVID-19 data include people who live in NYC. Any person with a residence outside of NYC is not included.

View on NYC Open Data

Quality

D69.4 / 100

From a 277-row sample across 9 columns.

completeness77/ 25% weight

consistency56/ 20% weight

accuracy100/ 20% weight

timeliness0/ 15% weight

usability95/ 20% weight

Related datasets

Sample rows

date	confirmed_cases	probable_cases	total_cases	status	etldate
2020-10-01T00:00:00.000Z	614	82	696	Update	2021-03-30T15:23:10.000Z
2020-10-10T00:00:00.000Z	310	46	356	Update	2021-03-30T15:23:18.000Z
2020-10-11T00:00:00.000Z	281	50	331	Update	2021-03-30T15:23:17.000Z

Columns

9 queryable · 9 profiled

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

Field	Type	Description	Null	Values
`date`	datetime	—	0%	`2021-06-04T00:00:00.000Z2021-01-17T00:00:00.000Z2020-10-28T00:00:00.000Z`
`confirmed_cases`	integer	Count of confirmed cases by specimen collection date	0%	`28883728496`
`probable_cases`	integer	Count of probably cases by date of occurrence	0%	`11293473`
`total_cases`	integer	Sum of confirmed and probable cases	4%	`289714616391`

Query this from your own app

GET /api/datasets/xwtc-hedq
GET /api/datasets/xwtc-hedq/quality
GET /api/datasets/xwtc-hedq/related
GET /api/columns?dataset=xwtc-hedq