ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 104 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 24
county 24
- Cook 5
- Roseau 4
- Morrison 3
- Houston 2
- Pennington 2
- Blue Earth 1
- Chippewa 1
- Cottonwood 1
- Crow Wing 1
- Douglas 1
- Jackson 1
- Lac qui Parle 1
- Mahnomen 1
- McLeod 1
- Mille Lacs 1
- Murray 1
- Otter Tail 1
- Polk 1
- Pope 1
- Red Lake 1
- Rock 1
- Stevens 1
- Swift 1
- Unknown 1
state 1
- Minnesota · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
889325 | 889325 | 2021-01-02 | Cook | Minnesota | 27031 | 104 | 0 |
886079 | 886079 | 2021-01-01 | Cook | Minnesota | 27031 | 104 | 0 |
882834 | 882834 | 2020-12-31 | Cook | Minnesota | 27031 | 104 | 0 |
879589 | 879589 | 2020-12-30 | Cook | Minnesota | 27031 | 104 | 0 |
876344 | 876344 | 2020-12-29 | Cook | Minnesota | 27031 | 104 | 0 |
704399 | 704399 | 2020-11-06 | Red Lake | Minnesota | 27125 | 104 | 2 |
655727 | 655727 | 2020-10-22 | Mahnomen | Minnesota | 27087 | 104 | 1 |
620027 | 620027 | 2020-10-11 | Lac qui Parle | Minnesota | 27073 | 104 | 2 |
590874 | 590874 | 2020-10-02 | Pope | Minnesota | 27121 | 104 | 0 |
577925 | 577925 | 2020-09-28 | Stevens | Minnesota | 27149 | 104 | 1 |
545483 | 545483 | 2020-09-18 | Houston | Minnesota | 27055 | 104 | 0 |
545531 | 545531 | 2020-09-18 | Swift | Minnesota | 27151 | 104 | 1 |
539010 | 539010 | 2020-09-16 | Houston | Minnesota | 27055 | 104 | 0 |
539050 | 539050 | 2020-09-16 | Roseau | Minnesota | 27135 | 104 | 0 |
535802 | 535802 | 2020-09-15 | Pennington | Minnesota | 27113 | 104 | 1 |
535813 | 535813 | 2020-09-15 | Roseau | Minnesota | 27135 | 104 | 0 |
532567 | 532567 | 2020-09-14 | Pennington | Minnesota | 27113 | 104 | 1 |
532578 | 532578 | 2020-09-14 | Roseau | Minnesota | 27135 | 104 | 0 |
529306 | 529306 | 2020-09-13 | Jackson | Minnesota | 27063 | 104 | 1 |
529342 | 529342 | 2020-09-13 | Roseau | Minnesota | 27135 | 104 | 0 |
493745 | 493745 | 2020-09-02 | Mille Lacs | Minnesota | 27095 | 104 | 3 |
487297 | 487297 | 2020-08-31 | Rock | Minnesota | 27133 | 104 | 0 |
454968 | 454968 | 2020-08-21 | Morrison | Minnesota | 27097 | 104 | 1 |
451740 | 451740 | 2020-08-20 | Morrison | Minnesota | 27097 | 104 | 1 |
442060 | 442060 | 2020-08-17 | Morrison | Minnesota | 27097 | 104 | 1 |
416229 | 416229 | 2020-08-09 | Chippewa | Minnesota | 27023 | 104 | 1 |
361614 | 361614 | 2020-07-23 | Polk | Minnesota | 27119 | 104 | 3 |
358400 | 358400 | 2020-07-22 | Murray | Minnesota | 27101 | 104 | 0 |
355168 | 355168 | 2020-07-21 | Douglas | Minnesota | 27041 | 104 | 0 |
339193 | 339193 | 2020-07-16 | McLeod | Minnesota | 27085 | 104 | 0 |
320079 | 320079 | 2020-07-10 | Otter Tail | Minnesota | 27111 | 104 | 1 |
294703 | 294703 | 2020-07-02 | Crow Wing | Minnesota | 27035 | 104 | 12 |
235225 | 235225 | 2020-06-13 | Cottonwood | Minnesota | 27033 | 104 | 0 |
185944 | 185944 | 2020-05-28 | Unknown | Minnesota | 104 | 10 | |
164571 | 164571 | 2020-05-21 | Blue Earth | Minnesota | 27013 | 104 | 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);