ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,656 rows where deaths = 4 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Big Stone 231
- Lake of the Woods 137
- Dodge 115
- Watonwan 110
- Cook 86
- Polk 84
- Grant 78
- Red Lake 58
- Otter Tail 49
- Martin 42
- Sibley 40
- Wilkin 37
- Lincoln 36
- Scott 35
- Freeborn 34
- Wabasha 31
- Lyon 28
- Koochiching 27
- Becker 24
- Cass 22
- McLeod 21
- Le Sueur 18
- Carver 16
- Houston 14
- Mahnomen 14
- Sherburne 13
- Wright 13
- Renville 12
- Traverse 12
- Benton 11
- …
state 1
- Minnesota · 1,656 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500920 | 2500920 | 2022-05-13 | Cook | Minnesota | 27031 | 594 | 4 |
2497662 | 2497662 | 2022-05-12 | Cook | Minnesota | 27031 | 592 | 4 |
2494404 | 2494404 | 2022-05-11 | Cook | Minnesota | 27031 | 590 | 4 |
2491146 | 2491146 | 2022-05-10 | Cook | Minnesota | 27031 | 586 | 4 |
2487889 | 2487889 | 2022-05-09 | Cook | Minnesota | 27031 | 581 | 4 |
2484631 | 2484631 | 2022-05-08 | Cook | Minnesota | 27031 | 579 | 4 |
2481373 | 2481373 | 2022-05-07 | Cook | Minnesota | 27031 | 579 | 4 |
2478115 | 2478115 | 2022-05-06 | Cook | Minnesota | 27031 | 579 | 4 |
2474857 | 2474857 | 2022-05-05 | Cook | Minnesota | 27031 | 579 | 4 |
2471600 | 2471600 | 2022-05-04 | Cook | Minnesota | 27031 | 577 | 4 |
2468344 | 2468344 | 2022-05-03 | Cook | Minnesota | 27031 | 574 | 4 |
2465089 | 2465089 | 2022-05-02 | Cook | Minnesota | 27031 | 571 | 4 |
2461833 | 2461833 | 2022-05-01 | Cook | Minnesota | 27031 | 571 | 4 |
2458577 | 2458577 | 2022-04-30 | Cook | Minnesota | 27031 | 571 | 4 |
2455321 | 2455321 | 2022-04-29 | Cook | Minnesota | 27031 | 571 | 4 |
2452065 | 2452065 | 2022-04-28 | Cook | Minnesota | 27031 | 570 | 4 |
2448809 | 2448809 | 2022-04-27 | Cook | Minnesota | 27031 | 565 | 4 |
2445553 | 2445553 | 2022-04-26 | Cook | Minnesota | 27031 | 565 | 4 |
2442297 | 2442297 | 2022-04-25 | Cook | Minnesota | 27031 | 563 | 4 |
2439041 | 2439041 | 2022-04-24 | Cook | Minnesota | 27031 | 562 | 4 |
2435785 | 2435785 | 2022-04-23 | Cook | Minnesota | 27031 | 562 | 4 |
2432529 | 2432529 | 2022-04-22 | Cook | Minnesota | 27031 | 562 | 4 |
2429273 | 2429273 | 2022-04-21 | Cook | Minnesota | 27031 | 562 | 4 |
2426017 | 2426017 | 2022-04-20 | Cook | Minnesota | 27031 | 561 | 4 |
2422761 | 2422761 | 2022-04-19 | Cook | Minnesota | 27031 | 561 | 4 |
2419505 | 2419505 | 2022-04-18 | Cook | Minnesota | 27031 | 559 | 4 |
2416249 | 2416249 | 2022-04-17 | Cook | Minnesota | 27031 | 558 | 4 |
2412993 | 2412993 | 2022-04-16 | Cook | Minnesota | 27031 | 558 | 4 |
2409737 | 2409737 | 2022-04-15 | Cook | Minnesota | 27031 | 558 | 4 |
2406481 | 2406481 | 2022-04-14 | Cook | Minnesota | 27031 | 556 | 4 |
2403225 | 2403225 | 2022-04-13 | Cook | Minnesota | 27031 | 555 | 4 |
2399971 | 2399971 | 2022-04-12 | Cook | Minnesota | 27031 | 554 | 4 |
2396715 | 2396715 | 2022-04-11 | Cook | Minnesota | 27031 | 554 | 4 |
2393460 | 2393460 | 2022-04-10 | Cook | Minnesota | 27031 | 554 | 4 |
2390204 | 2390204 | 2022-04-09 | Cook | Minnesota | 27031 | 554 | 4 |
2386948 | 2386948 | 2022-04-08 | Cook | Minnesota | 27031 | 554 | 4 |
2383693 | 2383693 | 2022-04-07 | Cook | Minnesota | 27031 | 554 | 4 |
2380438 | 2380438 | 2022-04-06 | Cook | Minnesota | 27031 | 554 | 4 |
2377183 | 2377183 | 2022-04-05 | Cook | Minnesota | 27031 | 554 | 4 |
2373931 | 2373931 | 2022-04-04 | Cook | Minnesota | 27031 | 554 | 4 |
2370678 | 2370678 | 2022-04-03 | Cook | Minnesota | 27031 | 554 | 4 |
2367425 | 2367425 | 2022-04-02 | Cook | Minnesota | 27031 | 554 | 4 |
2364172 | 2364172 | 2022-04-01 | Cook | Minnesota | 27031 | 554 | 4 |
2360918 | 2360918 | 2022-03-31 | Cook | Minnesota | 27031 | 554 | 4 |
2357664 | 2357664 | 2022-03-30 | Cook | Minnesota | 27031 | 553 | 4 |
2354411 | 2354411 | 2022-03-29 | Cook | Minnesota | 27031 | 552 | 4 |
2351159 | 2351159 | 2022-03-28 | Cook | Minnesota | 27031 | 551 | 4 |
2347906 | 2347906 | 2022-03-27 | Cook | Minnesota | 27031 | 551 | 4 |
2344653 | 2344653 | 2022-03-26 | Cook | Minnesota | 27031 | 551 | 4 |
2341400 | 2341400 | 2022-03-25 | Cook | Minnesota | 27031 | 551 | 4 |
2338147 | 2338147 | 2022-03-24 | Cook | Minnesota | 27031 | 550 | 4 |
2334893 | 2334893 | 2022-03-23 | Cook | Minnesota | 27031 | 550 | 4 |
2331639 | 2331639 | 2022-03-22 | Cook | Minnesota | 27031 | 549 | 4 |
2328387 | 2328387 | 2022-03-21 | Cook | Minnesota | 27031 | 548 | 4 |
2325134 | 2325134 | 2022-03-20 | Cook | Minnesota | 27031 | 548 | 4 |
2321880 | 2321880 | 2022-03-19 | Cook | Minnesota | 27031 | 548 | 4 |
2318626 | 2318626 | 2022-03-18 | Cook | Minnesota | 27031 | 548 | 4 |
2315373 | 2315373 | 2022-03-17 | Cook | Minnesota | 27031 | 548 | 4 |
2312120 | 2312120 | 2022-03-16 | Cook | Minnesota | 27031 | 548 | 4 |
2308867 | 2308867 | 2022-03-15 | Cook | Minnesota | 27031 | 548 | 4 |
2305616 | 2305616 | 2022-03-14 | Cook | Minnesota | 27031 | 550 | 4 |
2302364 | 2302364 | 2022-03-13 | Cook | Minnesota | 27031 | 549 | 4 |
2299112 | 2299112 | 2022-03-12 | Cook | Minnesota | 27031 | 549 | 4 |
2295860 | 2295860 | 2022-03-11 | Cook | Minnesota | 27031 | 549 | 4 |
2292608 | 2292608 | 2022-03-10 | Cook | Minnesota | 27031 | 545 | 4 |
2289356 | 2289356 | 2022-03-09 | Cook | Minnesota | 27031 | 545 | 4 |
2286105 | 2286105 | 2022-03-08 | Cook | Minnesota | 27031 | 545 | 4 |
2282853 | 2282853 | 2022-03-07 | Cook | Minnesota | 27031 | 545 | 4 |
2279600 | 2279600 | 2022-03-06 | Cook | Minnesota | 27031 | 542 | 4 |
2276347 | 2276347 | 2022-03-05 | Cook | Minnesota | 27031 | 542 | 4 |
2273094 | 2273094 | 2022-03-04 | Cook | Minnesota | 27031 | 542 | 4 |
2269842 | 2269842 | 2022-03-03 | Cook | Minnesota | 27031 | 541 | 4 |
2266589 | 2266589 | 2022-03-02 | Cook | Minnesota | 27031 | 541 | 4 |
2263338 | 2263338 | 2022-03-01 | Cook | Minnesota | 27031 | 540 | 4 |
2260087 | 2260087 | 2022-02-28 | Cook | Minnesota | 27031 | 540 | 4 |
2256836 | 2256836 | 2022-02-27 | Cook | Minnesota | 27031 | 539 | 4 |
2253585 | 2253585 | 2022-02-26 | Cook | Minnesota | 27031 | 539 | 4 |
2250334 | 2250334 | 2022-02-25 | Cook | Minnesota | 27031 | 539 | 4 |
2247083 | 2247083 | 2022-02-24 | Cook | Minnesota | 27031 | 538 | 4 |
2243832 | 2243832 | 2022-02-23 | Cook | Minnesota | 27031 | 535 | 4 |
2240581 | 2240581 | 2022-02-22 | Cook | Minnesota | 27031 | 533 | 4 |
2237330 | 2237330 | 2022-02-21 | Cook | Minnesota | 27031 | 533 | 4 |
2234079 | 2234079 | 2022-02-20 | Cook | Minnesota | 27031 | 533 | 4 |
2230828 | 2230828 | 2022-02-19 | Cook | Minnesota | 27031 | 533 | 4 |
2227577 | 2227577 | 2022-02-18 | Cook | Minnesota | 27031 | 533 | 4 |
2224326 | 2224326 | 2022-02-17 | Cook | Minnesota | 27031 | 532 | 4 |
1921960 | 1921960 | 2021-11-16 | Lake of the Woods | Minnesota | 27077 | 503 | 4 |
1918710 | 1918710 | 2021-11-15 | Lake of the Woods | Minnesota | 27077 | 501 | 4 |
1915460 | 1915460 | 2021-11-14 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1912210 | 1912210 | 2021-11-13 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1908960 | 1908960 | 2021-11-12 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1905711 | 1905711 | 2021-11-11 | Lake of the Woods | Minnesota | 27077 | 500 | 4 |
1902462 | 1902462 | 2021-11-10 | Lake of the Woods | Minnesota | 27077 | 499 | 4 |
1899212 | 1899212 | 2021-11-09 | Lake of the Woods | Minnesota | 27077 | 498 | 4 |
1895962 | 1895962 | 2021-11-08 | Lake of the Woods | Minnesota | 27077 | 497 | 4 |
1892712 | 1892712 | 2021-11-07 | Lake of the Woods | Minnesota | 27077 | 497 | 4 |
1889462 | 1889462 | 2021-11-06 | Lake of the Woods | Minnesota | 27077 | 497 | 4 |
1886212 | 1886212 | 2021-11-05 | Lake of the Woods | Minnesota | 27077 | 497 | 4 |
1882963 | 1882963 | 2021-11-04 | Lake of the Woods | Minnesota | 27077 | 497 | 4 |
1879714 | 1879714 | 2021-11-03 | Lake of the Woods | Minnesota | 27077 | 497 | 4 |
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);