ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 407 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2103970 | 2103970 | 2022-01-11 | Cook | Minnesota | 27031 | 407 | 1 |
1694562 | 1694562 | 2021-09-07 | Traverse | Minnesota | 27155 | 407 | 5 |
1629574 | 1629574 | 2021-08-18 | Red Lake | Minnesota | 27125 | 407 | 7 |
1626327 | 1626327 | 2021-08-17 | Red Lake | Minnesota | 27125 | 407 | 7 |
1061359 | 1061359 | 2021-02-24 | Kittson | Minnesota | 27069 | 407 | 21 |
931542 | 931542 | 2021-01-15 | Mahnomen | Minnesota | 27087 | 407 | 7 |
928297 | 928297 | 2021-01-14 | Mahnomen | Minnesota | 27087 | 407 | 7 |
873137 | 873137 | 2020-12-28 | Norman | Minnesota | 27107 | 407 | 8 |
869892 | 869892 | 2020-12-27 | Norman | Minnesota | 27107 | 407 | 8 |
830900 | 830900 | 2020-12-15 | Big Stone | Minnesota | 27011 | 407 | 2 |
827654 | 827654 | 2020-12-14 | Big Stone | Minnesota | 27011 | 407 | 2 |
753019 | 753019 | 2020-11-21 | Clearwater | Minnesota | 27029 | 407 | 6 |
697917 | 697917 | 2020-11-04 | Rock | Minnesota | 27133 | 407 | 9 |
616797 | 616797 | 2020-10-10 | Morrison | Minnesota | 27097 | 407 | 3 |
561700 | 561700 | 2020-09-23 | Otter Tail | Minnesota | 27111 | 407 | 4 |
509904 | 509904 | 2020-09-07 | Le Sueur | Minnesota | 27079 | 407 | 2 |
474370 | 474370 | 2020-08-27 | Steele | Minnesota | 27147 | 407 | 2 |
368046 | 368046 | 2020-07-25 | Todd | Minnesota | 27153 | 407 | 2 |
364838 | 364838 | 2020-07-24 | Todd | Minnesota | 27153 | 407 | 2 |
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);