ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 195 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 18
county 18
- Lake of the Woods 4
- Cottonwood 2
- Benton 1
- Big Stone 1
- Brown 1
- Houston 1
- Jackson 1
- Kanabec 1
- Mille Lacs 1
- Morrison 1
- Pennington 1
- Pine 1
- Pope 1
- Renville 1
- Rock 1
- Sibley 1
- Traverse 1
- Wilkin 1
state 1
- Minnesota · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
954256 | 954256 | 2021-01-22 | Lake of the Woods | Minnesota | 27077 | 195 | 1 |
951011 | 951011 | 2021-01-21 | Lake of the Woods | Minnesota | 27077 | 195 | 1 |
947765 | 947765 | 2021-01-20 | Lake of the Woods | Minnesota | 27077 | 195 | 1 |
944518 | 944518 | 2021-01-19 | Lake of the Woods | Minnesota | 27077 | 195 | 1 |
843955 | 843955 | 2020-12-19 | Traverse | Minnesota | 27155 | 195 | 2 |
710908 | 710908 | 2020-11-08 | Wilkin | Minnesota | 27167 | 195 | 4 |
701100 | 701100 | 2020-11-05 | Big Stone | Minnesota | 27011 | 195 | 1 |
701155 | 701155 | 2020-11-05 | Pope | Minnesota | 27121 | 195 | 0 |
668719 | 668719 | 2020-10-26 | Pennington | Minnesota | 27113 | 195 | 1 |
658957 | 658957 | 2020-10-23 | Houston | Minnesota | 27055 | 195 | 1 |
658962 | 658962 | 2020-10-23 | Kanabec | Minnesota | 27065 | 195 | 10 |
645982 | 645982 | 2020-10-19 | Jackson | Minnesota | 27063 | 195 | 1 |
613572 | 613572 | 2020-10-09 | Renville | Minnesota | 27129 | 195 | 9 |
607090 | 607090 | 2020-10-07 | Rock | Minnesota | 27133 | 195 | 1 |
603828 | 603828 | 2020-10-06 | Mille Lacs | Minnesota | 27095 | 195 | 3 |
574617 | 574617 | 2020-09-27 | Brown | Minnesota | 27015 | 195 | 2 |
574680 | 574680 | 2020-09-27 | Sibley | Minnesota | 27143 | 195 | 3 |
548742 | 548742 | 2020-09-19 | Morrison | Minnesota | 27097 | 195 | 1 |
539040 | 539040 | 2020-09-16 | Pine | Minnesota | 27115 | 195 | 0 |
471081 | 471081 | 2020-08-26 | Cottonwood | Minnesota | 27033 | 195 | 0 |
467851 | 467851 | 2020-08-25 | Cottonwood | Minnesota | 27033 | 195 | 0 |
247653 | 247653 | 2020-06-17 | Benton | Minnesota | 27009 | 195 | 3 |
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);