ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where cases = 111 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 |
---|---|---|---|---|---|---|---|
921779 | 921779 | 2021-01-12 | Cook | Minnesota | 27031 | 111 | 0 |
918534 | 918534 | 2021-01-11 | Cook | Minnesota | 27031 | 111 | 0 |
915289 | 915289 | 2021-01-10 | Cook | Minnesota | 27031 | 111 | 0 |
688146 | 688146 | 2020-11-01 | Grant | Minnesota | 27051 | 111 | 5 |
665433 | 665433 | 2020-10-25 | Clearwater | Minnesota | 27029 | 111 | 0 |
655722 | 655722 | 2020-10-22 | Lake | Minnesota | 27075 | 111 | 0 |
613508 | 613508 | 2020-10-09 | Aitkin | Minnesota | 27001 | 111 | 1 |
613588 | 613588 | 2020-10-09 | Wadena | Minnesota | 27159 | 111 | 0 |
574638 | 574638 | 2020-09-27 | Hubbard | Minnesota | 27057 | 111 | 1 |
571407 | 571407 | 2020-09-26 | Lincoln | Minnesota | 27081 | 111 | 0 |
568165 | 568165 | 2020-09-25 | Lincoln | Minnesota | 27081 | 111 | 0 |
564907 | 564907 | 2020-09-24 | Fillmore | Minnesota | 27045 | 111 | 0 |
561667 | 561667 | 2020-09-23 | Fillmore | Minnesota | 27045 | 111 | 0 |
555193 | 555193 | 2020-09-21 | Fillmore | Minnesota | 27045 | 111 | 0 |
555206 | 555206 | 2020-09-21 | Koochiching | Minnesota | 27071 | 111 | 3 |
548769 | 548769 | 2020-09-19 | Swift | Minnesota | 27151 | 111 | 1 |
467914 | 467914 | 2020-08-25 | Wabasha | Minnesota | 27157 | 111 | 0 |
464685 | 464685 | 2020-08-24 | Wabasha | Minnesota | 27157 | 111 | 0 |
374394 | 374394 | 2020-07-27 | Becker | Minnesota | 27005 | 111 | 0 |
368051 | 368051 | 2020-07-25 | Waseca | Minnesota | 27161 | 111 | 0 |
364771 | 364771 | 2020-07-24 | Carlton | Minnesota | 27017 | 111 | 0 |
351990 | 351990 | 2020-07-20 | McLeod | Minnesota | 27085 | 111 | 0 |
348790 | 348790 | 2020-07-19 | McLeod | Minnesota | 27085 | 111 | 0 |
348803 | 348803 | 2020-07-19 | Pipestone | Minnesota | 27117 | 111 | 5 |
345564 | 345564 | 2020-07-18 | Dodge | Minnesota | 27039 | 111 | 0 |
345589 | 345589 | 2020-07-18 | McLeod | Minnesota | 27085 | 111 | 0 |
342364 | 342364 | 2020-07-17 | Dodge | Minnesota | 27039 | 111 | 0 |
329585 | 329585 | 2020-07-13 | Chisago | Minnesota | 27025 | 111 | 1 |
323258 | 323258 | 2020-07-11 | Otter Tail | Minnesota | 27111 | 111 | 1 |
320081 | 320081 | 2020-07-10 | Pine | Minnesota | 27115 | 111 | 0 |
316906 | 316906 | 2020-07-09 | Pine | Minnesota | 27115 | 111 | 0 |
275814 | 275814 | 2020-06-26 | Goodhue | Minnesota | 27049 | 111 | 8 |
244552 | 244552 | 2020-06-16 | Cottonwood | Minnesota | 27033 | 111 | 0 |
176792 | 176792 | 2020-05-25 | St. Louis | Minnesota | 27137 | 111 | 13 |
173749 | 173749 | 2020-05-24 | St. Louis | Minnesota | 27137 | 111 | 13 |
155562 | 155562 | 2020-05-18 | Steele | Minnesota | 27147 | 111 | 0 |
149476 | 149476 | 2020-05-16 | Carver | Minnesota | 27019 | 111 | 2 |
125556 | 125556 | 2020-05-08 | Martin | Minnesota | 27091 | 111 | 4 |
122574 | 122574 | 2020-05-07 | Martin | Minnesota | 27091 | 111 | 4 |
119600 | 119600 | 2020-05-06 | Martin | Minnesota | 27091 | 111 | 4 |
116640 | 116640 | 2020-05-05 | Martin | Minnesota | 27091 | 111 | 4 |
113759 | 113759 | 2020-05-04 | Martin | Minnesota | 27091 | 111 | 4 |
110880 | 110880 | 2020-05-03 | Martin | Minnesota | 27091 | 111 | 4 |
108009 | 108009 | 2020-05-02 | Martin | Minnesota | 27091 | 111 | 4 |
105144 | 105144 | 2020-05-01 | Martin | Minnesota | 27091 | 111 | 4 |
11530 | 11530 | 2020-03-25 | Hennepin | Minnesota | 27053 | 111 | 0 |
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);