ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,051 rows where deaths = 16 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Houston 135
- Jackson 95
- Wabasha 94
- Clearwater 68
- Lac qui Parle 60
- Murray 51
- Pennington 49
- Faribault 42
- Nobles 42
- Pine 33
- Winona 30
- Waseca 27
- Wilkin 24
- Marshall 22
- Crow Wing 19
- Steele 18
- Nicollet 17
- Itasca 16
- St. Louis 16
- Le Sueur 14
- Lake 12
- Mahnomen 12
- Martin 11
- Rock 11
- Roseau 11
- Koochiching 9
- Pipestone 9
- Fillmore 8
- Wright 8
- Pope 7
- …
state 1
- Minnesota · 1,051 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500955 | 2500955 | 2022-05-13 | Murray | Minnesota | 27101 | 2043 | 16 |
2500984 | 2500984 | 2022-05-13 | Wabasha | Minnesota | 27157 | 5795 | 16 |
2497697 | 2497697 | 2022-05-12 | Murray | Minnesota | 27101 | 2043 | 16 |
2497726 | 2497726 | 2022-05-12 | Wabasha | Minnesota | 27157 | 5783 | 16 |
2494439 | 2494439 | 2022-05-11 | Murray | Minnesota | 27101 | 2043 | 16 |
2494468 | 2494468 | 2022-05-11 | Wabasha | Minnesota | 27157 | 5773 | 16 |
2491181 | 2491181 | 2022-05-10 | Murray | Minnesota | 27101 | 2043 | 16 |
2491210 | 2491210 | 2022-05-10 | Wabasha | Minnesota | 27157 | 5769 | 16 |
2487924 | 2487924 | 2022-05-09 | Murray | Minnesota | 27101 | 2041 | 16 |
2487953 | 2487953 | 2022-05-09 | Wabasha | Minnesota | 27157 | 5749 | 16 |
2484666 | 2484666 | 2022-05-08 | Murray | Minnesota | 27101 | 2040 | 16 |
2484695 | 2484695 | 2022-05-08 | Wabasha | Minnesota | 27157 | 5738 | 16 |
2481408 | 2481408 | 2022-05-07 | Murray | Minnesota | 27101 | 2040 | 16 |
2481437 | 2481437 | 2022-05-07 | Wabasha | Minnesota | 27157 | 5738 | 16 |
2478150 | 2478150 | 2022-05-06 | Murray | Minnesota | 27101 | 2040 | 16 |
2478179 | 2478179 | 2022-05-06 | Wabasha | Minnesota | 27157 | 5738 | 16 |
2474892 | 2474892 | 2022-05-05 | Murray | Minnesota | 27101 | 2039 | 16 |
2474921 | 2474921 | 2022-05-05 | Wabasha | Minnesota | 27157 | 5722 | 16 |
2471635 | 2471635 | 2022-05-04 | Murray | Minnesota | 27101 | 2038 | 16 |
2471664 | 2471664 | 2022-05-04 | Wabasha | Minnesota | 27157 | 5714 | 16 |
2468379 | 2468379 | 2022-05-03 | Murray | Minnesota | 27101 | 2038 | 16 |
2468408 | 2468408 | 2022-05-03 | Wabasha | Minnesota | 27157 | 5703 | 16 |
2465124 | 2465124 | 2022-05-02 | Murray | Minnesota | 27101 | 2037 | 16 |
2465153 | 2465153 | 2022-05-02 | Wabasha | Minnesota | 27157 | 5691 | 16 |
2461868 | 2461868 | 2022-05-01 | Murray | Minnesota | 27101 | 2035 | 16 |
2461897 | 2461897 | 2022-05-01 | Wabasha | Minnesota | 27157 | 5685 | 16 |
2458612 | 2458612 | 2022-04-30 | Murray | Minnesota | 27101 | 2035 | 16 |
2458641 | 2458641 | 2022-04-30 | Wabasha | Minnesota | 27157 | 5685 | 16 |
2455356 | 2455356 | 2022-04-29 | Murray | Minnesota | 27101 | 2035 | 16 |
2455385 | 2455385 | 2022-04-29 | Wabasha | Minnesota | 27157 | 5685 | 16 |
2452100 | 2452100 | 2022-04-28 | Murray | Minnesota | 27101 | 2034 | 16 |
2452129 | 2452129 | 2022-04-28 | Wabasha | Minnesota | 27157 | 5678 | 16 |
2448844 | 2448844 | 2022-04-27 | Murray | Minnesota | 27101 | 2034 | 16 |
2448873 | 2448873 | 2022-04-27 | Wabasha | Minnesota | 27157 | 5668 | 16 |
2445588 | 2445588 | 2022-04-26 | Murray | Minnesota | 27101 | 2034 | 16 |
2445617 | 2445617 | 2022-04-26 | Wabasha | Minnesota | 27157 | 5661 | 16 |
2442332 | 2442332 | 2022-04-25 | Murray | Minnesota | 27101 | 2031 | 16 |
2442361 | 2442361 | 2022-04-25 | Wabasha | Minnesota | 27157 | 5647 | 16 |
2439076 | 2439076 | 2022-04-24 | Murray | Minnesota | 27101 | 2030 | 16 |
2439105 | 2439105 | 2022-04-24 | Wabasha | Minnesota | 27157 | 5636 | 16 |
2435820 | 2435820 | 2022-04-23 | Murray | Minnesota | 27101 | 2030 | 16 |
2435849 | 2435849 | 2022-04-23 | Wabasha | Minnesota | 27157 | 5636 | 16 |
2432564 | 2432564 | 2022-04-22 | Murray | Minnesota | 27101 | 2030 | 16 |
2432593 | 2432593 | 2022-04-22 | Wabasha | Minnesota | 27157 | 5636 | 16 |
2429308 | 2429308 | 2022-04-21 | Murray | Minnesota | 27101 | 2030 | 16 |
2429337 | 2429337 | 2022-04-21 | Wabasha | Minnesota | 27157 | 5618 | 16 |
2426052 | 2426052 | 2022-04-20 | Murray | Minnesota | 27101 | 2029 | 16 |
2426081 | 2426081 | 2022-04-20 | Wabasha | Minnesota | 27157 | 5607 | 16 |
2422796 | 2422796 | 2022-04-19 | Murray | Minnesota | 27101 | 2028 | 16 |
2422825 | 2422825 | 2022-04-19 | Wabasha | Minnesota | 27157 | 5606 | 16 |
2419540 | 2419540 | 2022-04-18 | Murray | Minnesota | 27101 | 2028 | 16 |
2419569 | 2419569 | 2022-04-18 | Wabasha | Minnesota | 27157 | 5594 | 16 |
2416284 | 2416284 | 2022-04-17 | Murray | Minnesota | 27101 | 2027 | 16 |
2416313 | 2416313 | 2022-04-17 | Wabasha | Minnesota | 27157 | 5589 | 16 |
2413028 | 2413028 | 2022-04-16 | Murray | Minnesota | 27101 | 2027 | 16 |
2413057 | 2413057 | 2022-04-16 | Wabasha | Minnesota | 27157 | 5589 | 16 |
2409772 | 2409772 | 2022-04-15 | Murray | Minnesota | 27101 | 2027 | 16 |
2409801 | 2409801 | 2022-04-15 | Wabasha | Minnesota | 27157 | 5589 | 16 |
2406516 | 2406516 | 2022-04-14 | Murray | Minnesota | 27101 | 2027 | 16 |
2406545 | 2406545 | 2022-04-14 | Wabasha | Minnesota | 27157 | 5583 | 16 |
2403260 | 2403260 | 2022-04-13 | Murray | Minnesota | 27101 | 2027 | 16 |
2403289 | 2403289 | 2022-04-13 | Wabasha | Minnesota | 27157 | 5583 | 16 |
2400006 | 2400006 | 2022-04-12 | Murray | Minnesota | 27101 | 2027 | 16 |
2400035 | 2400035 | 2022-04-12 | Wabasha | Minnesota | 27157 | 5579 | 16 |
2396750 | 2396750 | 2022-04-11 | Murray | Minnesota | 27101 | 2027 | 16 |
2396779 | 2396779 | 2022-04-11 | Wabasha | Minnesota | 27157 | 5570 | 16 |
2393495 | 2393495 | 2022-04-10 | Murray | Minnesota | 27101 | 2027 | 16 |
2393524 | 2393524 | 2022-04-10 | Wabasha | Minnesota | 27157 | 5569 | 16 |
2390239 | 2390239 | 2022-04-09 | Murray | Minnesota | 27101 | 2027 | 16 |
2390268 | 2390268 | 2022-04-09 | Wabasha | Minnesota | 27157 | 5569 | 16 |
2386983 | 2386983 | 2022-04-08 | Murray | Minnesota | 27101 | 2027 | 16 |
2387012 | 2387012 | 2022-04-08 | Wabasha | Minnesota | 27157 | 5569 | 16 |
2383728 | 2383728 | 2022-04-07 | Murray | Minnesota | 27101 | 2027 | 16 |
2383757 | 2383757 | 2022-04-07 | Wabasha | Minnesota | 27157 | 5569 | 16 |
2380473 | 2380473 | 2022-04-06 | Murray | Minnesota | 27101 | 2026 | 16 |
2380502 | 2380502 | 2022-04-06 | Wabasha | Minnesota | 27157 | 5568 | 16 |
2377218 | 2377218 | 2022-04-05 | Murray | Minnesota | 27101 | 2026 | 16 |
2377247 | 2377247 | 2022-04-05 | Wabasha | Minnesota | 27157 | 5568 | 16 |
2373966 | 2373966 | 2022-04-04 | Murray | Minnesota | 27101 | 2026 | 16 |
2373995 | 2373995 | 2022-04-04 | Wabasha | Minnesota | 27157 | 5567 | 16 |
2370713 | 2370713 | 2022-04-03 | Murray | Minnesota | 27101 | 2026 | 16 |
2370742 | 2370742 | 2022-04-03 | Wabasha | Minnesota | 27157 | 5564 | 16 |
2367460 | 2367460 | 2022-04-02 | Murray | Minnesota | 27101 | 2026 | 16 |
2367489 | 2367489 | 2022-04-02 | Wabasha | Minnesota | 27157 | 5564 | 16 |
2364207 | 2364207 | 2022-04-01 | Murray | Minnesota | 27101 | 2026 | 16 |
2364236 | 2364236 | 2022-04-01 | Wabasha | Minnesota | 27157 | 5564 | 16 |
2360953 | 2360953 | 2022-03-31 | Murray | Minnesota | 27101 | 2026 | 16 |
2360982 | 2360982 | 2022-03-31 | Wabasha | Minnesota | 27157 | 5564 | 16 |
2357699 | 2357699 | 2022-03-30 | Murray | Minnesota | 27101 | 2026 | 16 |
2357728 | 2357728 | 2022-03-30 | Wabasha | Minnesota | 27157 | 5561 | 16 |
2354446 | 2354446 | 2022-03-29 | Murray | Minnesota | 27101 | 2026 | 16 |
2354475 | 2354475 | 2022-03-29 | Wabasha | Minnesota | 27157 | 5560 | 16 |
2351194 | 2351194 | 2022-03-28 | Murray | Minnesota | 27101 | 2026 | 16 |
2351223 | 2351223 | 2022-03-28 | Wabasha | Minnesota | 27157 | 5554 | 16 |
2347941 | 2347941 | 2022-03-27 | Murray | Minnesota | 27101 | 2026 | 16 |
2347970 | 2347970 | 2022-03-27 | Wabasha | Minnesota | 27157 | 5552 | 16 |
2344688 | 2344688 | 2022-03-26 | Murray | Minnesota | 27101 | 2026 | 16 |
2344717 | 2344717 | 2022-03-26 | Wabasha | Minnesota | 27157 | 5552 | 16 |
2341435 | 2341435 | 2022-03-25 | Murray | Minnesota | 27101 | 2026 | 16 |
2341464 | 2341464 | 2022-03-25 | Wabasha | Minnesota | 27157 | 5552 | 16 |
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);