ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 246 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
- Cook 7
- Carlton 2
- Unknown 2
- Crow Wing 1
- Lac qui Parle 1
- Le Sueur 1
- Olmsted 1
- Pennington 1
- Polk 1
- Sherburne 1
- Yellow Medicine 1
state 1
- Minnesota · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1853699 | 1853699 | 2021-10-26 | Cook | Minnesota | 27031 | 246 | 0 |
1847200 | 1847200 | 2021-10-24 | Cook | Minnesota | 27031 | 246 | 0 |
1843950 | 1843950 | 2021-10-23 | Cook | Minnesota | 27031 | 246 | 0 |
1840700 | 1840700 | 2021-10-22 | Cook | Minnesota | 27031 | 246 | 0 |
1837451 | 1837451 | 2021-10-21 | Cook | Minnesota | 27031 | 246 | 0 |
1834202 | 1834202 | 2021-10-20 | Cook | Minnesota | 27031 | 246 | 0 |
1830953 | 1830953 | 2021-10-19 | Cook | Minnesota | 27031 | 246 | 0 |
736811 | 736811 | 2020-11-16 | Lac qui Parle | Minnesota | 27073 | 246 | 3 |
697907 | 697907 | 2020-11-04 | Pennington | Minnesota | 27113 | 246 | 2 |
671983 | 671983 | 2020-10-27 | Unknown | Minnesota | 246 | 53 | |
626563 | 626563 | 2020-10-13 | Yellow Medicine | Minnesota | 27173 | 246 | 4 |
613586 | 613586 | 2020-10-09 | Unknown | Minnesota | 246 | 53 | |
561653 | 561653 | 2020-09-23 | Carlton | Minnesota | 27017 | 246 | 1 |
558416 | 558416 | 2020-09-22 | Carlton | Minnesota | 27017 | 246 | 1 |
532570 | 532570 | 2020-09-14 | Polk | Minnesota | 27119 | 246 | 4 |
435599 | 435599 | 2020-08-15 | Le Sueur | Minnesota | 27079 | 246 | 1 |
425900 | 425900 | 2020-08-12 | Crow Wing | Minnesota | 27035 | 246 | 14 |
198196 | 198196 | 2020-06-01 | Sherburne | Minnesota | 27141 | 246 | 2 |
93760 | 93760 | 2020-04-27 | Olmsted | Minnesota | 27109 | 246 | 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);