cityofnewyork-us/covid19-outcomes-by-testing-cohorts-cases-cwmx-mvra

  • coronavirus
  • covid-19
  • sars-cov-2

COVID-19 Outcomes by Testing Cohorts: Cases, Hospitalizations, and Deaths

COVID-19 Outcomes by Testing Cohorts: Cases, Hospitalizations, and Deaths

The dataset shows outcomes (confirmed cases, hospitalizations, and deaths) for cohorts defined by each date of specimen collection (specimen_date).

For example, if a NYC resident tested positive for SARS-CoV-2 and was subsequently hospitalized, both events would show under the same specimen_date, indicating the date of specimen collection for the positive test and not the date of the hospitalization.

For a comparable dataset showing diagnosis dates for confirmed cases, admission dates for hospitalized patients, and death dates for decedents, see https://data.cityofnewyork.us/Health/COVID-19-Daily-Counts-of-Cases-Hospitalizations-an/rc75-m7u3

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
extract_dateextract_dateextract_dateCalendar dateDate of extraction from live disease surveillance database
specimen_datespecimen_datespecimen_dateCalendar dateDate of specimen collection, equivalent to diagnosis date
Number_testednumber_testednumber_testedNumberCount of NYC residents newly tested for SARS-CoV-2
Number_confirmednumber_confirmednumber_confirmedNumberCount of patients tested who were confirmed to be COVID-19 cases
Number_hospitalizednumber_hospitalizednumber_hospitalizedNumberCount of confirmed COVID-19 cases among patients ever hospitalized
Number_deathsnumber_deathsnumber_deathsNumberCount of confirmed COVID-19 cases among patients who died

Upstream Metadata