From a 500-row sample across 6 columns.
extract_date| extract_date | specimen_date | number_tested | number_confirmed | number_hospitalized | number_deaths |
|---|---|---|---|---|---|
| 2020-03-31T00:00:00.000 | 2020-01-29T00:00:00.000 | 1 | 0 | 0 | 0 |
| 2020-03-31T00:00:00.000 | 2020-02-02T00:00:00.000 | 2 | 0 | 0 | 0 |
| 2020-03-31T00:00:00.000 | 2020-02-04T00:00:00.000 | 1 | 0 | 0 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
extract_date | datetime | Date of extraction from live disease surveillance database | 0% | 2021-10-01T00:00:00.0002021-09-29T00:00:00.0002021-09-30T00:00:00.000 |
specimen_date | datetime | Date of specimen collection, equivalent to diagnosis date | 0% | 2020-03-25T00:00:00.0002020-03-28T00:00:00.0002020-03-20T00:00:00.000 |
number_tested | integer | Count of NYC residents newly tested for SARS-CoV-2 | 0% | 124 |
number_confirmed | integer | Count of patients tested who were confirmed to be COVID-19 cases | 0% |
GET /api/datasets/cwmx-mvra GET /api/datasets/cwmx-mvra/quality GET /api/datasets/cwmx-mvra/related GET /api/columns?dataset=cwmx-mvra
| 0 |
| 2020-03-31T00:00:00.000 | 2020-02-05T00:00:00.000 | 1 | 0 | 0 | 0 |
| 2020-03-31T00:00:00.000 | 2020-02-08T00:00:00.000 | 1 | 0 | 0 | 0 |
| 2020-03-31T00:00:00.000 | 2020-02-23T00:00:00.000 | 1 | 1 | 1 | 0 |
| 2020-03-31T00:00:00.000 | 2020-02-26T00:00:00.000 | 1 | 0 | 0 | 0 |
| 2020-03-31T00:00:00.000 | 2020-02-27T00:00:00.000 | 2 | 0 | 0 | 1 |
| 2020-03-31T00:00:00.000 | 2020-02-29T00:00:00.000 | 3 | 1 | 0 | 0 |
| 2020-03-31T00:00:00.000 | 2020-03-01T00:00:00.000 | 1 | 0 | 0 | 0 |
012number_hospitalized | integer | Count of confirmed COVID-19 cases among patients ever hospitalized | 0% | 0133 |
number_deaths | integer | Count of confirmed COVID-19 cases among patients who died | 0% | 012 |