Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

COVID-19 Daily Counts of Cases, Hospitalizations, and Deaths

rc75-m7u3Health55 columns
Daily count of NYC residents who tested positive for SARS-CoV-2, who were hospitalized with COVID-19, and deaths among COVID-19 patients. Note that this dataset currently pulls from https://raw.githubusercontent.com/nychealth/coronavirus-data/master/trends/data-by-day.csv on a daily basis.
View on NYC Open Data↗

Quality

B88.3 / 100

From a 500-row sample across 55 columns.

completeness100/ 25% weight
consistency50/ 20% weight
accuracy97/ 20% weight
timeliness100/ 15% weight
usability95/ 20% weight

Related datasets

  • COVID-19 Outcomes by Testing Cohorts_Cases, Hospitalizations, and Deaths (Historical)0.43
  • SARS-CoV-2 concentrations measured in NYC Wastewater0.34
  • DOHMH COVID-19 Antibody-by-Borough0.34
  • DOHMH COVID-19 Antibody-by-Neighborhood Poverty0.30
  • Self-Reported Drinking Water Tank Inspection Results0.28
  • Rodent Inspection0.28
  • Modified Zip Code Tabulation Areas (MODZCTA)0.28
  • Open Streets Locations

Sample rows

date_of_interestcase_countprobable_case_counthospitalized_countdeath_countcase_count_7day_avgall_case_count_7day_avghosp_count_7day_avgdeath_count_7day_avgbx_case_countbx_probable_case_countbx_hospitalized_count
2020-02-29T00:00:00.00010100000000

Columns

55 queryable · 55 profiled

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

FieldTypeDescriptionNullValues
date_of_interestdatetimeDate of COVID-19 diagnosis (i.e., date of specimen collection), hospital admission, or death0%2021-09-11T00:00:00.0002020-04-19T00:00:00.0002025-03-16T00:00:00.000
case_countintegerCount of patients tested who were confirmed to be COVID-19 cases on date_of_interest0%140126283
probable_case_countinteger—0%940119
hospitalized_countintegerCount of COVID-19 patients who were hospitalized on date_of_interest0%18

Query this from your own app

GET /api/datasets/rc75-m7u3
GET /api/datasets/rc75-m7u3/quality
GET /api/datasets/rc75-m7u3/related
GET /api/columns?dataset=rc75-m7u3
0.27
2020-03-01T00:00:00.000
0
0
1
0
0
0
0
0
0
0
1
2020-03-02T00:00:00.00000200000000
2020-03-03T00:00:00.00010700000001
2020-03-04T00:00:00.00050200000000
2020-03-05T00:00:00.000301400000001
2020-03-06T00:00:00.00080803350201
2020-03-07T00:00:00.00070803360001
2020-03-08T00:00:00.0002101806680305
2020-03-09T00:00:00.0005703701515130407

Showing 12 of 55 columns. All of them are listed below.

25
22
death_countintegerCount of deaths occurring among confirmed COVID-19 cases on date_of_interest0%102
case_count_7day_avginteger—0%194132147
all_case_count_7day_avginteger—0%277197362
hosp_count_7day_avginteger—0%202132
death_count_7day_avginteger—0%124
bx_case_countinteger—0%223827
bx_probable_case_countinteger—0%875
bx_hospitalized_countinteger—0%345
bx_death_countinteger—0%012
bx_case_count_7day_avginteger—0%252627
bx_probable_case_count_7day_avginteger—0%15614
bx_all_case_count_7day_avginteger—0%374038
bx_hospitalized_count_7day_avginteger—0%548
bx_death_count_7day_avginteger—0%012
bk_case_countinteger—0%465948
bk_probable_case_countinteger—0%181912
bk_hospitalized_countinteger—0%759
bk_death_countinteger—0%012
bk_case_count_7day_avginteger—0%414236
bk_probable_case_count_7day_avginteger—0%192021
bk_all_case_count_7day_avginteger—0%575867
bk_hospitalized_count_7day_avginteger—0%875
bk_death_count_7day_avginteger—0%013
mn_case_countinteger—0%232538
mn_probable_case_countinteger—0%231825
mn_hospitalized_countinteger—0%352
mn_death_countinteger—0%012
mn_case_count_7day_avginteger—0%432242
mn_probable_case_count_7day_avginteger—0%32321
mn_all_case_count_7day_avginteger—0%446837
mn_hospitalized_count_7day_avginteger—0%453
mn_death_count_7day_avginteger—0%012
qn_case_countinteger—0%435169
qn_probable_case_countinteger—0%273523
qn_hospitalized_countinteger—0%576
qn_death_countinteger—0%012
qn_case_count_7day_avginteger—0%454158
qn_probable_case_count_7day_avginteger—0%242523
qn_all_case_count_7day_avginteger—0%636679
qn_hospitalized_count_7day_avginteger—0%764
qn_death_count_7day_avginteger—0%102
si_case_countinteger—0%8712
si_probable_case_countinteger—0%067
si_hospitalized_countinteger—0%123
si_death_countinteger—0%012
si_probable_case_count_7day_avginteger—0%791
si_case_count_7day_avginteger—0%9108
si_all_case_count_7day_avginteger—0%171915
si_hospitalized_count_7day_avginteger—0%123
si_death_count_7day_avginteger—0%012
incompletecategorical—0%061030of 2