ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where deaths = 117 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500914 | 2500914 | 2022-05-13 | Carver | Minnesota | 27019 | 27480 | 117 |
2500925 | 2500925 | 2022-05-13 | Douglas | Minnesota | 27041 | 11106 | 117 |
2500934 | 2500934 | 2022-05-13 | Isanti | Minnesota | 27059 | 10263 | 117 |
2497656 | 2497656 | 2022-05-12 | Carver | Minnesota | 27019 | 27427 | 117 |
2497676 | 2497676 | 2022-05-12 | Isanti | Minnesota | 27059 | 10246 | 117 |
2494398 | 2494398 | 2022-05-11 | Carver | Minnesota | 27019 | 27382 | 117 |
2494418 | 2494418 | 2022-05-11 | Isanti | Minnesota | 27059 | 10237 | 117 |
2491140 | 2491140 | 2022-05-10 | Carver | Minnesota | 27019 | 27353 | 117 |
2491160 | 2491160 | 2022-05-10 | Isanti | Minnesota | 27059 | 10230 | 117 |
2487883 | 2487883 | 2022-05-09 | Carver | Minnesota | 27019 | 27244 | 117 |
2487903 | 2487903 | 2022-05-09 | Isanti | Minnesota | 27059 | 10195 | 117 |
2484625 | 2484625 | 2022-05-08 | Carver | Minnesota | 27019 | 27200 | 117 |
2484645 | 2484645 | 2022-05-08 | Isanti | Minnesota | 27059 | 10182 | 117 |
2481367 | 2481367 | 2022-05-07 | Carver | Minnesota | 27019 | 27200 | 117 |
2481387 | 2481387 | 2022-05-07 | Isanti | Minnesota | 27059 | 10182 | 117 |
2478109 | 2478109 | 2022-05-06 | Carver | Minnesota | 27019 | 27200 | 117 |
2478129 | 2478129 | 2022-05-06 | Isanti | Minnesota | 27059 | 10182 | 117 |
2474851 | 2474851 | 2022-05-05 | Carver | Minnesota | 27019 | 27165 | 117 |
2474871 | 2474871 | 2022-05-05 | Isanti | Minnesota | 27059 | 10173 | 117 |
2471594 | 2471594 | 2022-05-04 | Carver | Minnesota | 27019 | 27129 | 117 |
2471614 | 2471614 | 2022-05-04 | Isanti | Minnesota | 27059 | 10164 | 117 |
2468338 | 2468338 | 2022-05-03 | Carver | Minnesota | 27019 | 27065 | 117 |
2468358 | 2468358 | 2022-05-03 | Isanti | Minnesota | 27059 | 10158 | 117 |
2465083 | 2465083 | 2022-05-02 | Carver | Minnesota | 27019 | 27010 | 117 |
2465103 | 2465103 | 2022-05-02 | Isanti | Minnesota | 27059 | 10152 | 117 |
2461827 | 2461827 | 2022-05-01 | Carver | Minnesota | 27019 | 26982 | 117 |
2461847 | 2461847 | 2022-05-01 | Isanti | Minnesota | 27059 | 10147 | 117 |
2458571 | 2458571 | 2022-04-30 | Carver | Minnesota | 27019 | 26982 | 117 |
2458591 | 2458591 | 2022-04-30 | Isanti | Minnesota | 27059 | 10147 | 117 |
2455315 | 2455315 | 2022-04-29 | Carver | Minnesota | 27019 | 26982 | 117 |
2455335 | 2455335 | 2022-04-29 | Isanti | Minnesota | 27059 | 10147 | 117 |
2452059 | 2452059 | 2022-04-28 | Carver | Minnesota | 27019 | 26948 | 117 |
2452079 | 2452079 | 2022-04-28 | Isanti | Minnesota | 27059 | 10141 | 117 |
2448823 | 2448823 | 2022-04-27 | Isanti | Minnesota | 27059 | 10131 | 117 |
2445567 | 2445567 | 2022-04-26 | Isanti | Minnesota | 27059 | 10128 | 117 |
2442311 | 2442311 | 2022-04-25 | Isanti | Minnesota | 27059 | 10114 | 117 |
2439055 | 2439055 | 2022-04-24 | Isanti | Minnesota | 27059 | 10114 | 117 |
2435799 | 2435799 | 2022-04-23 | Isanti | Minnesota | 27059 | 10114 | 117 |
2432543 | 2432543 | 2022-04-22 | Isanti | Minnesota | 27059 | 10114 | 117 |
2429287 | 2429287 | 2022-04-21 | Isanti | Minnesota | 27059 | 10109 | 117 |
2426031 | 2426031 | 2022-04-20 | Isanti | Minnesota | 27059 | 10102 | 117 |
2422775 | 2422775 | 2022-04-19 | Isanti | Minnesota | 27059 | 10092 | 117 |
2419519 | 2419519 | 2022-04-18 | Isanti | Minnesota | 27059 | 10088 | 117 |
2416263 | 2416263 | 2022-04-17 | Isanti | Minnesota | 27059 | 10085 | 117 |
2413007 | 2413007 | 2022-04-16 | Isanti | Minnesota | 27059 | 10085 | 117 |
2409751 | 2409751 | 2022-04-15 | Isanti | Minnesota | 27059 | 10085 | 117 |
2406495 | 2406495 | 2022-04-14 | Isanti | Minnesota | 27059 | 10083 | 117 |
2403239 | 2403239 | 2022-04-13 | Isanti | Minnesota | 27059 | 10081 | 117 |
2399985 | 2399985 | 2022-04-12 | Isanti | Minnesota | 27059 | 10080 | 117 |
2396729 | 2396729 | 2022-04-11 | Isanti | Minnesota | 27059 | 10079 | 117 |
2393474 | 2393474 | 2022-04-10 | Isanti | Minnesota | 27059 | 10076 | 117 |
2390218 | 2390218 | 2022-04-09 | Isanti | Minnesota | 27059 | 10076 | 117 |
2386962 | 2386962 | 2022-04-08 | Isanti | Minnesota | 27059 | 10076 | 117 |
2383707 | 2383707 | 2022-04-07 | Isanti | Minnesota | 27059 | 10070 | 117 |
2380452 | 2380452 | 2022-04-06 | Isanti | Minnesota | 27059 | 10070 | 117 |
2377197 | 2377197 | 2022-04-05 | Isanti | Minnesota | 27059 | 10069 | 117 |
2373945 | 2373945 | 2022-04-04 | Isanti | Minnesota | 27059 | 10069 | 117 |
2370692 | 2370692 | 2022-04-03 | Isanti | Minnesota | 27059 | 10068 | 117 |
2367439 | 2367439 | 2022-04-02 | Isanti | Minnesota | 27059 | 10068 | 117 |
2364186 | 2364186 | 2022-04-01 | Isanti | Minnesota | 27059 | 10068 | 117 |
2360932 | 2360932 | 2022-03-31 | Isanti | Minnesota | 27059 | 10068 | 117 |
2357678 | 2357678 | 2022-03-30 | Isanti | Minnesota | 27059 | 10068 | 117 |
2354425 | 2354425 | 2022-03-29 | Isanti | Minnesota | 27059 | 10066 | 117 |
2351173 | 2351173 | 2022-03-28 | Isanti | Minnesota | 27059 | 10065 | 117 |
2347920 | 2347920 | 2022-03-27 | Isanti | Minnesota | 27059 | 10063 | 117 |
2344667 | 2344667 | 2022-03-26 | Isanti | Minnesota | 27059 | 10063 | 117 |
2341414 | 2341414 | 2022-03-25 | Isanti | Minnesota | 27059 | 10063 | 117 |
2338161 | 2338161 | 2022-03-24 | Isanti | Minnesota | 27059 | 10063 | 117 |
2334907 | 2334907 | 2022-03-23 | Isanti | Minnesota | 27059 | 10063 | 117 |
2331653 | 2331653 | 2022-03-22 | Isanti | Minnesota | 27059 | 10062 | 117 |
2328401 | 2328401 | 2022-03-21 | Isanti | Minnesota | 27059 | 10060 | 117 |
2325148 | 2325148 | 2022-03-20 | Isanti | Minnesota | 27059 | 10059 | 117 |
2321894 | 2321894 | 2022-03-19 | Isanti | Minnesota | 27059 | 10059 | 117 |
2318640 | 2318640 | 2022-03-18 | Isanti | Minnesota | 27059 | 10059 | 117 |
2315387 | 2315387 | 2022-03-17 | Isanti | Minnesota | 27059 | 10060 | 117 |
2282850 | 2282850 | 2022-03-07 | Chisago | Minnesota | 27025 | 14407 | 117 |
2279597 | 2279597 | 2022-03-06 | Chisago | Minnesota | 27025 | 14403 | 117 |
2276344 | 2276344 | 2022-03-05 | Chisago | Minnesota | 27025 | 14403 | 117 |
2273091 | 2273091 | 2022-03-04 | Chisago | Minnesota | 27025 | 14403 | 117 |
2269839 | 2269839 | 2022-03-03 | Chisago | Minnesota | 27025 | 14396 | 117 |
2266586 | 2266586 | 2022-03-02 | Chisago | Minnesota | 27025 | 14388 | 117 |
2214571 | 2214571 | 2022-02-14 | Clay | Minnesota | 27027 | 18792 | 117 |
2211319 | 2211319 | 2022-02-13 | Clay | Minnesota | 27027 | 18613 | 117 |
2208066 | 2208066 | 2022-02-12 | Clay | Minnesota | 27027 | 18613 | 117 |
2204813 | 2204813 | 2022-02-11 | Clay | Minnesota | 27027 | 18613 | 117 |
2201560 | 2201560 | 2022-02-10 | Clay | Minnesota | 27027 | 18525 | 117 |
2198306 | 2198306 | 2022-02-09 | Clay | Minnesota | 27027 | 18418 | 117 |
2195052 | 2195052 | 2022-02-08 | Clay | Minnesota | 27027 | 18291 | 117 |
2191798 | 2191798 | 2022-02-07 | Clay | Minnesota | 27027 | 18072 | 117 |
2188545 | 2188545 | 2022-02-06 | Clay | Minnesota | 27027 | 17915 | 117 |
2185292 | 2185292 | 2022-02-05 | Clay | Minnesota | 27027 | 17915 | 117 |
2182040 | 2182040 | 2022-02-04 | Clay | Minnesota | 27027 | 17915 | 117 |
2178788 | 2178788 | 2022-02-03 | Clay | Minnesota | 27027 | 17804 | 117 |
2087728 | 2087728 | 2022-01-06 | Itasca | Minnesota | 27061 | 8572 | 117 |
2061721 | 2061721 | 2021-12-29 | Kandiyohi | Minnesota | 27067 | 10514 | 117 |
2058472 | 2058472 | 2021-12-28 | Kandiyohi | Minnesota | 27067 | 10506 | 117 |
2055223 | 2055223 | 2021-12-27 | Kandiyohi | Minnesota | 27067 | 10453 | 117 |
1925226 | 1925226 | 2021-11-17 | Otter Tail | Minnesota | 27111 | 9292 | 117 |
1921977 | 1921977 | 2021-11-16 | Otter Tail | Minnesota | 27111 | 9249 | 117 |
1905677 | 1905677 | 2021-11-11 | Benton | Minnesota | 27009 | 8202 | 117 |
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);