search

nytimes / covid-19-data

A repository of data on coronavirus cases and deaths in the U.S.
https://www.nytimes.com/interactive/2020/us/coronavirus-us-cases.html
Other
6.99k stars 3.46k forks source link

Daily count #23

Closed alexgenaud closed 4 years ago

alexgenaud commented 4 years ago

Could it be possible to show the confirmed cases and deaths (new or cumulative) by date?

... like the Johns Hopkins data. For example:

https://github.com/CSSEGISandData/COVID-19/blob/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv

thoughtafter commented 4 years ago

Are you suggesting a new dataset or a change to an existing dataset?

cullylarson commented 4 years ago

The dataset already includes cumulative cases and deaths. To get new cases, just subtract the values between days. Or am I misunderstanding the request?

cipriancraciun commented 4 years ago

@cullylarson the original poster asks for a pivoted table (i.e. a single location is a single row, and each the dates are columns). NY Times provides a "normal' (SQL like) data table.

@alexgenaud I have been working with the JHU dataset for a week now, and I can say that the pivoted table format is a mess, thus I hope NY Times team doesn't make the same mistake as JHU did...

albertsun commented 4 years ago

@alexgenaud the data we've released already has one row for each date and each geography.

If you are indeed asking for it to be formatted with individual dates as columns, then @cipriancraciun's suggestion is correct, you could create that format by creating a pivot table in your favorite spreadsheet tool.