ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
14 rows where cases = 629 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 14
county 14
- Big Stone 1
- Blue Earth 1
- Carlton 1
- Clearwater 1
- Isanti 1
- Koochiching 1
- Lake 1
- Lake of the Woods 1
- McLeod 1
- Morrison 1
- Sherburne 1
- Traverse 1
- Watonwan 1
- Wilkin 1
state 1
- Minnesota · 14 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2133261 | 2133261 | 2022-01-20 | Lake of the Woods | Minnesota | 27077 | 629 | 5 |
2061765 | 2061765 | 2021-12-29 | Traverse | Minnesota | 27155 | 629 | 8 |
1668499 | 1668499 | 2021-08-30 | Big Stone | Minnesota | 27011 | 629 | 4 |
1132773 | 1132773 | 2021-03-18 | Koochiching | Minnesota | 27071 | 629 | 11 |
951057 | 951057 | 2021-01-21 | Wilkin | Minnesota | 27167 | 629 | 9 |
934782 | 934782 | 2021-01-16 | Lake | Minnesota | 27075 | 629 | 15 |
850383 | 850383 | 2020-12-21 | Clearwater | Minnesota | 27029 | 629 | 12 |
717395 | 717395 | 2020-11-10 | Watonwan | Minnesota | 27165 | 629 | 4 |
694616 | 694616 | 2020-11-03 | Carlton | Minnesota | 27017 | 629 | 3 |
684906 | 684906 | 2020-10-31 | Isanti | Minnesota | 27059 | 629 | 7 |
681679 | 681679 | 2020-10-30 | McLeod | Minnesota | 27085 | 629 | 4 |
649243 | 649243 | 2020-10-20 | Morrison | Minnesota | 27097 | 629 | 6 |
390545 | 390545 | 2020-08-01 | Sherburne | Minnesota | 27141 | 629 | 7 |
335959 | 335959 | 2020-07-15 | Blue Earth | Minnesota | 27013 | 629 | 2 |
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);