ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where county = "Watonwan", deaths = 5 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
863432 | 863432 | 2020-12-25 | Watonwan | Minnesota | 27165 | 1019 | 5 |
860187 | 860187 | 2020-12-24 | Watonwan | Minnesota | 27165 | 1019 | 5 |
856942 | 856942 | 2020-12-23 | Watonwan | Minnesota | 27165 | 1018 | 5 |
853697 | 853697 | 2020-12-22 | Watonwan | Minnesota | 27165 | 1021 | 5 |
850452 | 850452 | 2020-12-21 | Watonwan | Minnesota | 27165 | 1022 | 5 |
847207 | 847207 | 2020-12-20 | Watonwan | Minnesota | 27165 | 1018 | 5 |
843961 | 843961 | 2020-12-19 | Watonwan | Minnesota | 27165 | 1015 | 5 |
840716 | 840716 | 2020-12-18 | Watonwan | Minnesota | 27165 | 1009 | 5 |
837471 | 837471 | 2020-12-17 | Watonwan | Minnesota | 27165 | 1004 | 5 |
834225 | 834225 | 2020-12-16 | Watonwan | Minnesota | 27165 | 998 | 5 |
830978 | 830978 | 2020-12-15 | Watonwan | Minnesota | 27165 | 996 | 5 |
827732 | 827732 | 2020-12-14 | Watonwan | Minnesota | 27165 | 995 | 5 |
824485 | 824485 | 2020-12-13 | Watonwan | Minnesota | 27165 | 990 | 5 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);