ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 102 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
866609 | 866609 | 2020-12-26 | Cook | Minnesota | 27031 | 102 | 0 |
863364 | 863364 | 2020-12-25 | Cook | Minnesota | 27031 | 102 | 0 |
860119 | 860119 | 2020-12-24 | Cook | Minnesota | 27031 | 102 | 0 |
856874 | 856874 | 2020-12-23 | Cook | Minnesota | 27031 | 102 | 0 |
788742 | 788742 | 2020-12-02 | Lake of the Woods | Minnesota | 27077 | 102 | 1 |
785497 | 785497 | 2020-12-01 | Lake of the Woods | Minnesota | 27077 | 102 | 1 |
736852 | 736852 | 2020-11-16 | Traverse | Minnesota | 27155 | 102 | 0 |
733606 | 733606 | 2020-11-15 | Traverse | Minnesota | 27155 | 102 | 0 |
675173 | 675173 | 2020-10-28 | Grant | Minnesota | 27051 | 102 | 4 |
626560 | 626560 | 2020-10-13 | Wilkin | Minnesota | 27167 | 102 | 4 |
623318 | 623318 | 2020-10-12 | Wilkin | Minnesota | 27167 | 102 | 3 |
555211 | 555211 | 2020-09-21 | Lincoln | Minnesota | 27081 | 102 | 0 |
551973 | 551973 | 2020-09-20 | Lincoln | Minnesota | 27081 | 102 | 0 |
526095 | 526095 | 2020-09-12 | Pennington | Minnesota | 27113 | 102 | 1 |
526106 | 526106 | 2020-09-12 | Roseau | Minnesota | 27135 | 102 | 0 |
522859 | 522859 | 2020-09-11 | Pennington | Minnesota | 27113 | 102 | 1 |
519622 | 519622 | 2020-09-10 | Pennington | Minnesota | 27113 | 102 | 1 |
516387 | 516387 | 2020-09-09 | Pennington | Minnesota | 27113 | 102 | 1 |
513153 | 513153 | 2020-09-08 | Pennington | Minnesota | 27113 | 102 | 1 |
487278 | 487278 | 2020-08-31 | Mille Lacs | Minnesota | 27095 | 102 | 3 |
480828 | 480828 | 2020-08-29 | Rock | Minnesota | 27133 | 102 | 0 |
445286 | 445286 | 2020-08-18 | Morrison | Minnesota | 27097 | 102 | 1 |
390505 | 390505 | 2020-08-01 | Isanti | Minnesota | 27059 | 102 | 0 |
387288 | 387288 | 2020-07-31 | Isanti | Minnesota | 27059 | 102 | 0 |
384070 | 384070 | 2020-07-30 | Isanti | Minnesota | 27059 | 102 | 0 |
348754 | 348754 | 2020-07-19 | Carlton | Minnesota | 27017 | 102 | 0 |
335997 | 335997 | 2020-07-15 | McLeod | Minnesota | 27085 | 102 | 0 |
332804 | 332804 | 2020-07-14 | McLeod | Minnesota | 27085 | 102 | 0 |
316904 | 316904 | 2020-07-09 | Otter Tail | Minnesota | 27111 | 102 | 1 |
313688 | 313688 | 2020-07-08 | Chisago | Minnesota | 27025 | 102 | 1 |
310518 | 310518 | 2020-07-07 | Chisago | Minnesota | 27025 | 102 | 1 |
291549 | 291549 | 2020-07-01 | Crow Wing | Minnesota | 27035 | 102 | 12 |
288398 | 288398 | 2020-06-30 | Crow Wing | Minnesota | 27035 | 102 | 12 |
285248 | 285248 | 2020-06-29 | Crow Wing | Minnesota | 27035 | 102 | 12 |
282103 | 282103 | 2020-06-28 | Crow Wing | Minnesota | 27035 | 102 | 12 |
257020 | 257020 | 2020-06-20 | Goodhue | Minnesota | 27049 | 102 | 7 |
185890 | 185890 | 2020-05-28 | Freeborn | Minnesota | 27047 | 102 | 0 |
152546 | 152546 | 2020-05-17 | St. Louis | Minnesota | 27137 | 102 | 13 |
131574 | 131574 | 2020-05-10 | Wright | Minnesota | 27171 | 102 | 1 |
128564 | 128564 | 2020-05-09 | Rice | Minnesota | 27131 | 102 | 1 |
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);