ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
396 rows where deaths = 47 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2334889 | 2334889 | 2022-03-23 | Chippewa | Minnesota | 27023 | 3067 | 47 |
2331635 | 2331635 | 2022-03-22 | Chippewa | Minnesota | 27023 | 3067 | 47 |
2328383 | 2328383 | 2022-03-21 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2325130 | 2325130 | 2022-03-20 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2321876 | 2321876 | 2022-03-19 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2318622 | 2318622 | 2022-03-18 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2315369 | 2315369 | 2022-03-17 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2312116 | 2312116 | 2022-03-16 | Chippewa | Minnesota | 27023 | 3066 | 47 |
2308863 | 2308863 | 2022-03-15 | Chippewa | Minnesota | 27023 | 3065 | 47 |
2305612 | 2305612 | 2022-03-14 | Chippewa | Minnesota | 27023 | 3065 | 47 |
2302360 | 2302360 | 2022-03-13 | Chippewa | Minnesota | 27023 | 3064 | 47 |
2299108 | 2299108 | 2022-03-12 | Chippewa | Minnesota | 27023 | 3064 | 47 |
2295856 | 2295856 | 2022-03-11 | Chippewa | Minnesota | 27023 | 3064 | 47 |
2292604 | 2292604 | 2022-03-10 | Chippewa | Minnesota | 27023 | 3062 | 47 |
2289352 | 2289352 | 2022-03-09 | Chippewa | Minnesota | 27023 | 3057 | 47 |
2286101 | 2286101 | 2022-03-08 | Chippewa | Minnesota | 27023 | 3054 | 47 |
2282849 | 2282849 | 2022-03-07 | Chippewa | Minnesota | 27023 | 3046 | 47 |
2279596 | 2279596 | 2022-03-06 | Chippewa | Minnesota | 27023 | 3044 | 47 |
2276343 | 2276343 | 2022-03-05 | Chippewa | Minnesota | 27023 | 3044 | 47 |
2273090 | 2273090 | 2022-03-04 | Chippewa | Minnesota | 27023 | 3044 | 47 |
2269838 | 2269838 | 2022-03-03 | Chippewa | Minnesota | 27023 | 3042 | 47 |
2266585 | 2266585 | 2022-03-02 | Chippewa | Minnesota | 27023 | 3037 | 47 |
2263334 | 2263334 | 2022-03-01 | Chippewa | Minnesota | 27023 | 3033 | 47 |
2260083 | 2260083 | 2022-02-28 | Chippewa | Minnesota | 27023 | 3029 | 47 |
2256832 | 2256832 | 2022-02-27 | Chippewa | Minnesota | 27023 | 3028 | 47 |
2253581 | 2253581 | 2022-02-26 | Chippewa | Minnesota | 27023 | 3028 | 47 |
2250330 | 2250330 | 2022-02-25 | Chippewa | Minnesota | 27023 | 3028 | 47 |
2247079 | 2247079 | 2022-02-24 | Chippewa | Minnesota | 27023 | 3022 | 47 |
2243828 | 2243828 | 2022-02-23 | Chippewa | Minnesota | 27023 | 3018 | 47 |
2240577 | 2240577 | 2022-02-22 | Chippewa | Minnesota | 27023 | 3002 | 47 |
2237326 | 2237326 | 2022-02-21 | Chippewa | Minnesota | 27023 | 3000 | 47 |
2234075 | 2234075 | 2022-02-20 | Chippewa | Minnesota | 27023 | 3000 | 47 |
2230824 | 2230824 | 2022-02-19 | Chippewa | Minnesota | 27023 | 3000 | 47 |
2227573 | 2227573 | 2022-02-18 | Chippewa | Minnesota | 27023 | 3000 | 47 |
2224322 | 2224322 | 2022-02-17 | Chippewa | Minnesota | 27023 | 2982 | 47 |
2221071 | 2221071 | 2022-02-16 | Chippewa | Minnesota | 27023 | 2979 | 47 |
2217820 | 2217820 | 2022-02-15 | Chippewa | Minnesota | 27023 | 2972 | 47 |
2217848 | 2217848 | 2022-02-15 | Le Sueur | Minnesota | 27079 | 6275 | 47 |
2214597 | 2214597 | 2022-02-14 | Le Sueur | Minnesota | 27079 | 6253 | 47 |
2211345 | 2211345 | 2022-02-13 | Le Sueur | Minnesota | 27079 | 6233 | 47 |
2208092 | 2208092 | 2022-02-12 | Le Sueur | Minnesota | 27079 | 6233 | 47 |
2204839 | 2204839 | 2022-02-11 | Le Sueur | Minnesota | 27079 | 6233 | 47 |
2201586 | 2201586 | 2022-02-10 | Le Sueur | Minnesota | 27079 | 6226 | 47 |
2198332 | 2198332 | 2022-02-09 | Le Sueur | Minnesota | 27079 | 6204 | 47 |
2195078 | 2195078 | 2022-02-08 | Le Sueur | Minnesota | 27079 | 6172 | 47 |
2191824 | 2191824 | 2022-02-07 | Le Sueur | Minnesota | 27079 | 6119 | 47 |
2188571 | 2188571 | 2022-02-06 | Le Sueur | Minnesota | 27079 | 6086 | 47 |
2185318 | 2185318 | 2022-02-05 | Le Sueur | Minnesota | 27079 | 6086 | 47 |
2182066 | 2182066 | 2022-02-04 | Le Sueur | Minnesota | 27079 | 6086 | 47 |
2178814 | 2178814 | 2022-02-03 | Le Sueur | Minnesota | 27079 | 6075 | 47 |
2175562 | 2175562 | 2022-02-02 | Le Sueur | Minnesota | 27079 | 6062 | 47 |
2172309 | 2172309 | 2022-02-01 | Le Sueur | Minnesota | 27079 | 6032 | 47 |
2172350 | 2172350 | 2022-02-01 | Wadena | Minnesota | 27159 | 3858 | 47 |
2169056 | 2169056 | 2022-01-31 | Le Sueur | Minnesota | 27079 | 5956 | 47 |
2169097 | 2169097 | 2022-01-31 | Wadena | Minnesota | 27159 | 3811 | 47 |
2165801 | 2165801 | 2022-01-30 | Le Sueur | Minnesota | 27079 | 5900 | 47 |
2165842 | 2165842 | 2022-01-30 | Wadena | Minnesota | 27159 | 3772 | 47 |
2162546 | 2162546 | 2022-01-29 | Le Sueur | Minnesota | 27079 | 5900 | 47 |
2162587 | 2162587 | 2022-01-29 | Wadena | Minnesota | 27159 | 3772 | 47 |
2159291 | 2159291 | 2022-01-28 | Le Sueur | Minnesota | 27079 | 5900 | 47 |
2159332 | 2159332 | 2022-01-28 | Wadena | Minnesota | 27159 | 3772 | 47 |
2156037 | 2156037 | 2022-01-27 | Le Sueur | Minnesota | 27079 | 5857 | 47 |
2156078 | 2156078 | 2022-01-27 | Wadena | Minnesota | 27159 | 3720 | 47 |
2152825 | 2152825 | 2022-01-26 | Wadena | Minnesota | 27159 | 3663 | 47 |
2149573 | 2149573 | 2022-01-25 | Wadena | Minnesota | 27159 | 3639 | 47 |
2146321 | 2146321 | 2022-01-24 | Wadena | Minnesota | 27159 | 3583 | 47 |
2143066 | 2143066 | 2022-01-23 | Wadena | Minnesota | 27159 | 3564 | 47 |
2139811 | 2139811 | 2022-01-22 | Wadena | Minnesota | 27159 | 3564 | 47 |
2136555 | 2136555 | 2022-01-21 | Wadena | Minnesota | 27159 | 3564 | 47 |
2133303 | 2133303 | 2022-01-20 | Wadena | Minnesota | 27159 | 3513 | 47 |
2126789 | 2126789 | 2022-01-18 | Steele | Minnesota | 27147 | 8160 | 47 |
2123537 | 2123537 | 2022-01-17 | Steele | Minnesota | 27147 | 8117 | 47 |
2120285 | 2120285 | 2022-01-16 | Steele | Minnesota | 27147 | 8117 | 47 |
2117033 | 2117033 | 2022-01-15 | Steele | Minnesota | 27147 | 8117 | 47 |
2113782 | 2113782 | 2022-01-14 | Steele | Minnesota | 27147 | 8117 | 47 |
2087730 | 2087730 | 2022-01-06 | Kanabec | Minnesota | 27065 | 2873 | 47 |
2084478 | 2084478 | 2022-01-05 | Kanabec | Minnesota | 27065 | 2861 | 47 |
2038998 | 2038998 | 2021-12-22 | Pine | Minnesota | 27115 | 5581 | 47 |
2035748 | 2035748 | 2021-12-21 | Pine | Minnesota | 27115 | 5565 | 47 |
2032498 | 2032498 | 2021-12-20 | Pine | Minnesota | 27115 | 5528 | 47 |
2029247 | 2029247 | 2021-12-19 | Pine | Minnesota | 27115 | 5505 | 47 |
2029253 | 2029253 | 2021-12-19 | Redwood | Minnesota | 27127 | 2955 | 47 |
2025996 | 2025996 | 2021-12-18 | Pine | Minnesota | 27115 | 5505 | 47 |
2026002 | 2026002 | 2021-12-18 | Redwood | Minnesota | 27127 | 2955 | 47 |
2022745 | 2022745 | 2021-12-17 | Pine | Minnesota | 27115 | 5505 | 47 |
2022751 | 2022751 | 2021-12-17 | Redwood | Minnesota | 27127 | 2955 | 47 |
2019494 | 2019494 | 2021-12-16 | Pine | Minnesota | 27115 | 5487 | 47 |
2019500 | 2019500 | 2021-12-16 | Redwood | Minnesota | 27127 | 2949 | 47 |
2016250 | 2016250 | 2021-12-15 | Redwood | Minnesota | 27127 | 2940 | 47 |
1993454 | 1993454 | 2021-12-08 | Freeborn | Minnesota | 27047 | 5889 | 47 |
1990203 | 1990203 | 2021-12-07 | Freeborn | Minnesota | 27047 | 5854 | 47 |
1986953 | 1986953 | 2021-12-06 | Freeborn | Minnesota | 27047 | 5743 | 47 |
1983703 | 1983703 | 2021-12-05 | Freeborn | Minnesota | 27047 | 5699 | 47 |
1980453 | 1980453 | 2021-12-04 | Freeborn | Minnesota | 27047 | 5699 | 47 |
1977203 | 1977203 | 2021-12-03 | Freeborn | Minnesota | 27047 | 5699 | 47 |
1973953 | 1973953 | 2021-12-02 | Freeborn | Minnesota | 27047 | 5648 | 47 |
1951224 | 1951224 | 2021-11-25 | Mower | Minnesota | 27099 | 7202 | 47 |
1947973 | 1947973 | 2021-11-24 | Mower | Minnesota | 27099 | 7202 | 47 |
1938172 | 1938172 | 2021-11-21 | Aitkin | Minnesota | 27001 | 2107 | 47 |
1934922 | 1934922 | 2021-11-20 | Aitkin | Minnesota | 27001 | 2107 | 47 |
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);