ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 197 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
853691 | 853691 | 2020-12-22 | Traverse | Minnesota | 27155 | 197 | 2 |
850446 | 850446 | 2020-12-21 | Traverse | Minnesota | 27155 | 197 | 2 |
762805 | 762805 | 2020-11-24 | Red Lake | Minnesota | 27125 | 197 | 3 |
746538 | 746538 | 2020-11-19 | Grant | Minnesota | 27051 | 197 | 6 |
701130 | 701130 | 2020-11-05 | Koochiching | Minnesota | 27071 | 197 | 5 |
681674 | 681674 | 2020-10-30 | Lincoln | Minnesota | 27081 | 197 | 0 |
662201 | 662201 | 2020-10-24 | Houston | Minnesota | 27055 | 197 | 1 |
607074 | 607074 | 2020-10-07 | Murray | Minnesota | 27101 | 197 | 3 |
555182 | 555182 | 2020-09-21 | Chippewa | Minnesota | 27023 | 197 | 1 |
526059 | 526059 | 2020-09-12 | Douglas | Minnesota | 27041 | 197 | 1 |
506661 | 506661 | 2020-09-06 | Isanti | Minnesota | 27059 | 197 | 0 |
483999 | 483999 | 2020-08-30 | Becker | Minnesota | 27005 | 197 | 2 |
480778 | 480778 | 2020-08-29 | Cottonwood | Minnesota | 27033 | 197 | 0 |
480792 | 480792 | 2020-08-29 | Itasca | Minnesota | 27061 | 197 | 12 |
480821 | 480821 | 2020-08-29 | Polk | Minnesota | 27119 | 197 | 4 |
477546 | 477546 | 2020-08-28 | Cottonwood | Minnesota | 27033 | 197 | 0 |
419463 | 419463 | 2020-08-10 | Goodhue | Minnesota | 27049 | 197 | 9 |
419484 | 419484 | 2020-08-10 | McLeod | Minnesota | 27085 | 197 | 0 |
419494 | 419494 | 2020-08-10 | Otter Tail | Minnesota | 27111 | 197 | 3 |
364847 | 364847 | 2020-07-24 | Winona | Minnesota | 27169 | 197 | 16 |
225920 | 225920 | 2020-06-10 | Freeborn | Minnesota | 27047 | 197 | 0 |
173753 | 173753 | 2020-05-24 | Todd | Minnesota | 27153 | 197 | 0 |
146524 | 146524 | 2020-05-15 | Rice | Minnesota | 27131 | 197 | 2 |
74148 | 74148 | 2020-04-20 | Olmsted | Minnesota | 27109 | 197 | 4 |
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);