ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
65 rows where cases = 43 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
733544 | 733544 | 2020-11-15 | Cook | Minnesota | 27031 | 43 | 0 |
655723 | 655723 | 2020-10-22 | Lake of the Woods | Minnesota | 27077 | 43 | 1 |
652478 | 652478 | 2020-10-21 | Lake of the Woods | Minnesota | 27077 | 43 | 1 |
620068 | 620068 | 2020-10-11 | Traverse | Minnesota | 27155 | 43 | 0 |
616826 | 616826 | 2020-10-10 | Traverse | Minnesota | 27155 | 43 | 0 |
613522 | 613522 | 2020-10-09 | Clearwater | Minnesota | 27029 | 43 | 0 |
613585 | 613585 | 2020-10-09 | Traverse | Minnesota | 27155 | 43 | 0 |
548730 | 548730 | 2020-09-19 | Lac qui Parle | Minnesota | 27073 | 43 | 0 |
519571 | 519571 | 2020-09-10 | Big Stone | Minnesota | 27011 | 43 | 0 |
516336 | 516336 | 2020-09-09 | Big Stone | Minnesota | 27011 | 43 | 0 |
509902 | 509902 | 2020-09-07 | Lake | Minnesota | 27075 | 43 | 0 |
480790 | 480790 | 2020-08-29 | Hubbard | Minnesota | 27057 | 43 | 0 |
458232 | 458232 | 2020-08-22 | Wilkin | Minnesota | 27167 | 43 | 3 |
454973 | 454973 | 2020-08-21 | Norman | Minnesota | 27107 | 43 | 0 |
455004 | 455004 | 2020-08-21 | Wilkin | Minnesota | 27167 | 43 | 3 |
451745 | 451745 | 2020-08-20 | Norman | Minnesota | 27107 | 43 | 0 |
448517 | 448517 | 2020-08-19 | Norman | Minnesota | 27107 | 43 | 0 |
445291 | 445291 | 2020-08-18 | Norman | Minnesota | 27107 | 43 | 0 |
442044 | 442044 | 2020-08-17 | Kanabec | Minnesota | 27065 | 43 | 3 |
442065 | 442065 | 2020-08-17 | Norman | Minnesota | 27107 | 43 | 0 |
396969 | 396969 | 2020-08-03 | Pope | Minnesota | 27121 | 43 | 0 |
380849 | 380849 | 2020-07-29 | Grant | Minnesota | 27051 | 43 | 1 |
377694 | 377694 | 2020-07-28 | Yellow Medicine | Minnesota | 27173 | 43 | 0 |
374402 | 374402 | 2020-07-27 | Cass | Minnesota | 27021 | 43 | 2 |
371190 | 371190 | 2020-07-26 | Cass | Minnesota | 27021 | 43 | 2 |
345619 | 345619 | 2020-07-18 | Swift | Minnesota | 27151 | 43 | 1 |
342367 | 342367 | 2020-07-17 | Fillmore | Minnesota | 27045 | 43 | 0 |
342419 | 342419 | 2020-07-17 | Swift | Minnesota | 27151 | 43 | 1 |
329651 | 329651 | 2020-07-13 | Wabasha | Minnesota | 27157 | 43 | 0 |
320028 | 320028 | 2020-07-10 | Beltrami | Minnesota | 27007 | 43 | 0 |
320032 | 320032 | 2020-07-10 | Brown | Minnesota | 27015 | 43 | 2 |
282155 | 282155 | 2020-06-28 | Sibley | Minnesota | 27143 | 43 | 2 |
247698 | 247698 | 2020-06-17 | Murray | Minnesota | 27101 | 43 | 0 |
244585 | 244585 | 2020-06-16 | Murray | Minnesota | 27101 | 43 | 0 |
241474 | 241474 | 2020-06-15 | Murray | Minnesota | 27101 | 43 | 0 |
238365 | 238365 | 2020-06-14 | Murray | Minnesota | 27101 | 43 | 0 |
235258 | 235258 | 2020-06-13 | Murray | Minnesota | 27101 | 43 | 0 |
232134 | 232134 | 2020-06-12 | Jackson | Minnesota | 27063 | 43 | 0 |
229030 | 229030 | 2020-06-11 | Jackson | Minnesota | 27063 | 43 | 0 |
225928 | 225928 | 2020-06-10 | Jackson | Minnesota | 27063 | 43 | 0 |
222828 | 222828 | 2020-06-09 | Isanti | Minnesota | 27059 | 43 | 0 |
216656 | 216656 | 2020-06-07 | McLeod | Minnesota | 27085 | 43 | 0 |
213568 | 213568 | 2020-06-06 | McLeod | Minnesota | 27085 | 43 | 0 |
207362 | 207362 | 2020-06-04 | Becker | Minnesota | 27005 | 43 | 0 |
188965 | 188965 | 2020-05-29 | Lyon | Minnesota | 27083 | 43 | 0 |
182850 | 182850 | 2020-05-27 | Le Sueur | Minnesota | 27079 | 43 | 1 |
173698 | 173698 | 2020-05-24 | Dodge | Minnesota | 27039 | 43 | 0 |
170656 | 170656 | 2020-05-23 | Dodge | Minnesota | 27039 | 43 | 0 |
170682 | 170682 | 2020-05-23 | Meeker | Minnesota | 27093 | 43 | 0 |
167624 | 167624 | 2020-05-22 | Goodhue | Minnesota | 27049 | 43 | 2 |
164639 | 164639 | 2020-05-21 | Unknown | Minnesota | 43 | 9 | |
158558 | 158558 | 2020-05-19 | Nicollet | Minnesota | 27103 | 43 | 3 |
149495 | 149495 | 2020-05-16 | Itasca | Minnesota | 27061 | 43 | 4 |
128524 | 128524 | 2020-05-09 | Freeborn | Minnesota | 27047 | 43 | 0 |
125530 | 125530 | 2020-05-08 | Cottonwood | Minnesota | 27033 | 43 | 0 |
122548 | 122548 | 2020-05-07 | Cottonwood | Minnesota | 27033 | 43 | 0 |
122589 | 122589 | 2020-05-07 | Polk | Minnesota | 27119 | 43 | 0 |
119615 | 119615 | 2020-05-06 | Polk | Minnesota | 27119 | 43 | 0 |
105184 | 105184 | 2020-05-01 | Wright | Minnesota | 27171 | 43 | 1 |
93750 | 93750 | 2020-04-27 | Martin | Minnesota | 27091 | 43 | 4 |
90929 | 90929 | 2020-04-26 | Martin | Minnesota | 27091 | 43 | 4 |
85316 | 85316 | 2020-04-24 | Pine | Minnesota | 27115 | 43 | 0 |
63086 | 63086 | 2020-04-16 | Clay | Minnesota | 27027 | 43 | 1 |
60364 | 60364 | 2020-04-15 | Clay | Minnesota | 27027 | 43 | 1 |
60410 | 60410 | 2020-04-15 | St. Louis | Minnesota | 27137 | 43 | 6 |
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);