ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where deaths = 144 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
county 10
- Itasca 15
- Otter Tail 7
- Olmsted 5
- Anoka 3
- Crow Wing 2
- Dakota 1
- Rice 1
- Scott 1
- Washington 1
- Wright 1
state 1
- Minnesota · 37 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2357679 | 2357679 | 2022-03-30 | Itasca | Minnesota | 27061 | 10996 | 144 |
2354426 | 2354426 | 2022-03-29 | Itasca | Minnesota | 27061 | 10992 | 144 |
2351174 | 2351174 | 2022-03-28 | Itasca | Minnesota | 27061 | 10987 | 144 |
2347921 | 2347921 | 2022-03-27 | Itasca | Minnesota | 27061 | 10986 | 144 |
2344668 | 2344668 | 2022-03-26 | Itasca | Minnesota | 27061 | 10986 | 144 |
2341415 | 2341415 | 2022-03-25 | Itasca | Minnesota | 27061 | 10986 | 144 |
2338162 | 2338162 | 2022-03-24 | Itasca | Minnesota | 27061 | 10985 | 144 |
2334908 | 2334908 | 2022-03-23 | Itasca | Minnesota | 27061 | 10983 | 144 |
2331654 | 2331654 | 2022-03-22 | Itasca | Minnesota | 27061 | 10980 | 144 |
2328402 | 2328402 | 2022-03-21 | Itasca | Minnesota | 27061 | 10976 | 144 |
2325149 | 2325149 | 2022-03-20 | Itasca | Minnesota | 27061 | 10975 | 144 |
2321895 | 2321895 | 2022-03-19 | Itasca | Minnesota | 27061 | 10975 | 144 |
2318641 | 2318641 | 2022-03-18 | Itasca | Minnesota | 27061 | 10975 | 144 |
2315388 | 2315388 | 2022-03-17 | Itasca | Minnesota | 27061 | 10973 | 144 |
2312135 | 2312135 | 2022-03-16 | Itasca | Minnesota | 27061 | 10968 | 144 |
2103972 | 2103972 | 2022-01-11 | Crow Wing | Minnesota | 27035 | 12688 | 144 |
2104009 | 2104009 | 2022-01-11 | Olmsted | Minnesota | 27109 | 27729 | 144 |
2100721 | 2100721 | 2022-01-10 | Crow Wing | Minnesota | 27035 | 12438 | 144 |
2100758 | 2100758 | 2022-01-10 | Olmsted | Minnesota | 27109 | 26503 | 144 |
2097507 | 2097507 | 2022-01-09 | Olmsted | Minnesota | 27109 | 26053 | 144 |
2094255 | 2094255 | 2022-01-08 | Olmsted | Minnesota | 27109 | 26053 | 144 |
2091003 | 2091003 | 2022-01-07 | Olmsted | Minnesota | 27109 | 26053 | 144 |
2081249 | 2081249 | 2022-01-04 | Otter Tail | Minnesota | 27111 | 10627 | 144 |
2077997 | 2077997 | 2022-01-03 | Otter Tail | Minnesota | 27111 | 10576 | 144 |
2074746 | 2074746 | 2022-01-02 | Otter Tail | Minnesota | 27111 | 10556 | 144 |
2071495 | 2071495 | 2022-01-01 | Otter Tail | Minnesota | 27111 | 10556 | 144 |
2068244 | 2068244 | 2021-12-31 | Otter Tail | Minnesota | 27111 | 10556 | 144 |
2064993 | 2064993 | 2021-12-30 | Otter Tail | Minnesota | 27111 | 10556 | 144 |
2061743 | 2061743 | 2021-12-29 | Otter Tail | Minnesota | 27111 | 10534 | 144 |
1993496 | 1993496 | 2021-12-08 | Rice | Minnesota | 27131 | 11831 | 144 |
1720536 | 1720536 | 2021-09-15 | Scott | Minnesota | 27139 | 19489 | 144 |
1386087 | 1386087 | 2021-06-04 | Wright | Minnesota | 27171 | 16360 | 144 |
817992 | 817992 | 2020-12-11 | Washington | Minnesota | 27163 | 16452 | 144 |
704355 | 704355 | 2020-11-06 | Dakota | Minnesota | 27037 | 11938 | 144 |
629721 | 629721 | 2020-10-14 | Anoka | Minnesota | 27003 | 7548 | 144 |
626477 | 626477 | 2020-10-13 | Anoka | Minnesota | 27003 | 7485 | 144 |
623235 | 623235 | 2020-10-12 | Anoka | Minnesota | 27003 | 7372 | 144 |
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);