ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
560 rows where deaths = 34 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Pipestone 86
- Mower 43
- Rock 38
- Koochiching 36
- Freeborn 33
- Meeker 30
- Todd 24
- Redwood 23
- Scott 23
- Waseca 23
- Brown 21
- Cass 21
- Blue Earth 18
- Cottonwood 16
- Pennington 15
- Roseau 11
- Carver 10
- Martin 9
- Hubbard 8
- Kanabec 7
- Olmsted 7
- Steele 6
- Goodhue 4
- Lyon 4
- McLeod 4
- Renville 4
- Chippewa 3
- Crow Wing 3
- Morrison 3
- Hennepin 2
- …
state 1
- Minnesota · 560 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500963 | 2500963 | 2022-05-13 | Pipestone | Minnesota | 27117 | 2013 | 34 |
2500971 | 2500971 | 2022-05-13 | Rock | Minnesota | 27133 | 2348 | 34 |
2497705 | 2497705 | 2022-05-12 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2497713 | 2497713 | 2022-05-12 | Rock | Minnesota | 27133 | 2346 | 34 |
2494447 | 2494447 | 2022-05-11 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2494455 | 2494455 | 2022-05-11 | Rock | Minnesota | 27133 | 2344 | 34 |
2491189 | 2491189 | 2022-05-10 | Pipestone | Minnesota | 27117 | 2012 | 34 |
2491197 | 2491197 | 2022-05-10 | Rock | Minnesota | 27133 | 2344 | 34 |
2487932 | 2487932 | 2022-05-09 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2487940 | 2487940 | 2022-05-09 | Rock | Minnesota | 27133 | 2343 | 34 |
2484674 | 2484674 | 2022-05-08 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2484682 | 2484682 | 2022-05-08 | Rock | Minnesota | 27133 | 2343 | 34 |
2481416 | 2481416 | 2022-05-07 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2481424 | 2481424 | 2022-05-07 | Rock | Minnesota | 27133 | 2343 | 34 |
2478158 | 2478158 | 2022-05-06 | Pipestone | Minnesota | 27117 | 2011 | 34 |
2478166 | 2478166 | 2022-05-06 | Rock | Minnesota | 27133 | 2343 | 34 |
2474900 | 2474900 | 2022-05-05 | Pipestone | Minnesota | 27117 | 2008 | 34 |
2474908 | 2474908 | 2022-05-05 | Rock | Minnesota | 27133 | 2340 | 34 |
2471643 | 2471643 | 2022-05-04 | Pipestone | Minnesota | 27117 | 2008 | 34 |
2471651 | 2471651 | 2022-05-04 | Rock | Minnesota | 27133 | 2339 | 34 |
2468387 | 2468387 | 2022-05-03 | Pipestone | Minnesota | 27117 | 2008 | 34 |
2468395 | 2468395 | 2022-05-03 | Rock | Minnesota | 27133 | 2339 | 34 |
2465132 | 2465132 | 2022-05-02 | Pipestone | Minnesota | 27117 | 2005 | 34 |
2465140 | 2465140 | 2022-05-02 | Rock | Minnesota | 27133 | 2338 | 34 |
2461876 | 2461876 | 2022-05-01 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2461884 | 2461884 | 2022-05-01 | Rock | Minnesota | 27133 | 2336 | 34 |
2458620 | 2458620 | 2022-04-30 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2458628 | 2458628 | 2022-04-30 | Rock | Minnesota | 27133 | 2336 | 34 |
2455364 | 2455364 | 2022-04-29 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2455372 | 2455372 | 2022-04-29 | Rock | Minnesota | 27133 | 2336 | 34 |
2452108 | 2452108 | 2022-04-28 | Pipestone | Minnesota | 27117 | 2002 | 34 |
2452116 | 2452116 | 2022-04-28 | Rock | Minnesota | 27133 | 2336 | 34 |
2448852 | 2448852 | 2022-04-27 | Pipestone | Minnesota | 27117 | 2000 | 34 |
2448860 | 2448860 | 2022-04-27 | Rock | Minnesota | 27133 | 2333 | 34 |
2445596 | 2445596 | 2022-04-26 | Pipestone | Minnesota | 27117 | 1991 | 34 |
2445604 | 2445604 | 2022-04-26 | Rock | Minnesota | 27133 | 2333 | 34 |
2442340 | 2442340 | 2022-04-25 | Pipestone | Minnesota | 27117 | 1991 | 34 |
2442348 | 2442348 | 2022-04-25 | Rock | Minnesota | 27133 | 2332 | 34 |
2439084 | 2439084 | 2022-04-24 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2439092 | 2439092 | 2022-04-24 | Rock | Minnesota | 27133 | 2332 | 34 |
2435828 | 2435828 | 2022-04-23 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2435836 | 2435836 | 2022-04-23 | Rock | Minnesota | 27133 | 2332 | 34 |
2432572 | 2432572 | 2022-04-22 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2432580 | 2432580 | 2022-04-22 | Rock | Minnesota | 27133 | 2332 | 34 |
2429316 | 2429316 | 2022-04-21 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2429324 | 2429324 | 2022-04-21 | Rock | Minnesota | 27133 | 2332 | 34 |
2426060 | 2426060 | 2022-04-20 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2426068 | 2426068 | 2022-04-20 | Rock | Minnesota | 27133 | 2332 | 34 |
2422804 | 2422804 | 2022-04-19 | Pipestone | Minnesota | 27117 | 1990 | 34 |
2422812 | 2422812 | 2022-04-19 | Rock | Minnesota | 27133 | 2331 | 34 |
2419548 | 2419548 | 2022-04-18 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2419556 | 2419556 | 2022-04-18 | Rock | Minnesota | 27133 | 2331 | 34 |
2416292 | 2416292 | 2022-04-17 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2416300 | 2416300 | 2022-04-17 | Rock | Minnesota | 27133 | 2331 | 34 |
2413036 | 2413036 | 2022-04-16 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2413044 | 2413044 | 2022-04-16 | Rock | Minnesota | 27133 | 2331 | 34 |
2409780 | 2409780 | 2022-04-15 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2409788 | 2409788 | 2022-04-15 | Rock | Minnesota | 27133 | 2331 | 34 |
2406524 | 2406524 | 2022-04-14 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2406532 | 2406532 | 2022-04-14 | Rock | Minnesota | 27133 | 2331 | 34 |
2403268 | 2403268 | 2022-04-13 | Pipestone | Minnesota | 27117 | 1989 | 34 |
2403276 | 2403276 | 2022-04-13 | Rock | Minnesota | 27133 | 2331 | 34 |
2400014 | 2400014 | 2022-04-12 | Pipestone | Minnesota | 27117 | 1988 | 34 |
2400022 | 2400022 | 2022-04-12 | Rock | Minnesota | 27133 | 2330 | 34 |
2396758 | 2396758 | 2022-04-11 | Pipestone | Minnesota | 27117 | 1988 | 34 |
2396766 | 2396766 | 2022-04-11 | Rock | Minnesota | 27133 | 2330 | 34 |
2393503 | 2393503 | 2022-04-10 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2393511 | 2393511 | 2022-04-10 | Rock | Minnesota | 27133 | 2330 | 34 |
2390247 | 2390247 | 2022-04-09 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2390255 | 2390255 | 2022-04-09 | Rock | Minnesota | 27133 | 2330 | 34 |
2386991 | 2386991 | 2022-04-08 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2386999 | 2386999 | 2022-04-08 | Rock | Minnesota | 27133 | 2330 | 34 |
2383736 | 2383736 | 2022-04-07 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2383744 | 2383744 | 2022-04-07 | Rock | Minnesota | 27133 | 2329 | 34 |
2380481 | 2380481 | 2022-04-06 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2380489 | 2380489 | 2022-04-06 | Rock | Minnesota | 27133 | 2328 | 34 |
2377226 | 2377226 | 2022-04-05 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2373974 | 2373974 | 2022-04-04 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2370721 | 2370721 | 2022-04-03 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2367468 | 2367468 | 2022-04-02 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2364215 | 2364215 | 2022-04-01 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2360961 | 2360961 | 2022-03-31 | Pipestone | Minnesota | 27117 | 1986 | 34 |
2357707 | 2357707 | 2022-03-30 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2354454 | 2354454 | 2022-03-29 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2351202 | 2351202 | 2022-03-28 | Pipestone | Minnesota | 27117 | 1985 | 34 |
2347949 | 2347949 | 2022-03-27 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2344696 | 2344696 | 2022-03-26 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2341443 | 2341443 | 2022-03-25 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2338190 | 2338190 | 2022-03-24 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2334936 | 2334936 | 2022-03-23 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2331682 | 2331682 | 2022-03-22 | Pipestone | Minnesota | 27117 | 1983 | 34 |
2328430 | 2328430 | 2022-03-21 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2325177 | 2325177 | 2022-03-20 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2321923 | 2321923 | 2022-03-19 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2318669 | 2318669 | 2022-03-18 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2315416 | 2315416 | 2022-03-17 | Pipestone | Minnesota | 27117 | 1982 | 34 |
2312163 | 2312163 | 2022-03-16 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2308910 | 2308910 | 2022-03-15 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2305659 | 2305659 | 2022-03-14 | Pipestone | Minnesota | 27117 | 1981 | 34 |
2302407 | 2302407 | 2022-03-13 | Pipestone | Minnesota | 27117 | 1981 | 34 |
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);