ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Winona" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500990 | 2500990 | 2022-05-13 | Winona | Minnesota | 27169 | 13109 | 72 |
2497732 | 2497732 | 2022-05-12 | Winona | Minnesota | 27169 | 13076 | 72 |
2494474 | 2494474 | 2022-05-11 | Winona | Minnesota | 27169 | 13061 | 72 |
2491216 | 2491216 | 2022-05-10 | Winona | Minnesota | 27169 | 13042 | 72 |
2487959 | 2487959 | 2022-05-09 | Winona | Minnesota | 27169 | 12993 | 72 |
2484701 | 2484701 | 2022-05-08 | Winona | Minnesota | 27169 | 12987 | 72 |
2481443 | 2481443 | 2022-05-07 | Winona | Minnesota | 27169 | 12987 | 72 |
2478185 | 2478185 | 2022-05-06 | Winona | Minnesota | 27169 | 12987 | 72 |
2474927 | 2474927 | 2022-05-05 | Winona | Minnesota | 27169 | 12960 | 72 |
2471670 | 2471670 | 2022-05-04 | Winona | Minnesota | 27169 | 12937 | 72 |
2468414 | 2468414 | 2022-05-03 | Winona | Minnesota | 27169 | 12925 | 72 |
2465159 | 2465159 | 2022-05-02 | Winona | Minnesota | 27169 | 12901 | 72 |
2461903 | 2461903 | 2022-05-01 | Winona | Minnesota | 27169 | 12879 | 72 |
2458647 | 2458647 | 2022-04-30 | Winona | Minnesota | 27169 | 12879 | 72 |
2455391 | 2455391 | 2022-04-29 | Winona | Minnesota | 27169 | 12879 | 72 |
2452135 | 2452135 | 2022-04-28 | Winona | Minnesota | 27169 | 12859 | 72 |
2448879 | 2448879 | 2022-04-27 | Winona | Minnesota | 27169 | 12853 | 72 |
2445623 | 2445623 | 2022-04-26 | Winona | Minnesota | 27169 | 12842 | 72 |
2442367 | 2442367 | 2022-04-25 | Winona | Minnesota | 27169 | 12815 | 72 |
2439111 | 2439111 | 2022-04-24 | Winona | Minnesota | 27169 | 12801 | 72 |
2435855 | 2435855 | 2022-04-23 | Winona | Minnesota | 27169 | 12801 | 72 |
2432599 | 2432599 | 2022-04-22 | Winona | Minnesota | 27169 | 12801 | 72 |
2429343 | 2429343 | 2022-04-21 | Winona | Minnesota | 27169 | 12786 | 72 |
2426087 | 2426087 | 2022-04-20 | Winona | Minnesota | 27169 | 12779 | 72 |
2422831 | 2422831 | 2022-04-19 | Winona | Minnesota | 27169 | 12769 | 72 |
2419575 | 2419575 | 2022-04-18 | Winona | Minnesota | 27169 | 12756 | 72 |
2416319 | 2416319 | 2022-04-17 | Winona | Minnesota | 27169 | 12750 | 72 |
2413063 | 2413063 | 2022-04-16 | Winona | Minnesota | 27169 | 12750 | 72 |
2409807 | 2409807 | 2022-04-15 | Winona | Minnesota | 27169 | 12750 | 72 |
2406551 | 2406551 | 2022-04-14 | Winona | Minnesota | 27169 | 12746 | 72 |
2403295 | 2403295 | 2022-04-13 | Winona | Minnesota | 27169 | 12727 | 72 |
2400041 | 2400041 | 2022-04-12 | Winona | Minnesota | 27169 | 12722 | 72 |
2396785 | 2396785 | 2022-04-11 | Winona | Minnesota | 27169 | 12703 | 72 |
2393530 | 2393530 | 2022-04-10 | Winona | Minnesota | 27169 | 12701 | 72 |
2390274 | 2390274 | 2022-04-09 | Winona | Minnesota | 27169 | 12701 | 72 |
2387018 | 2387018 | 2022-04-08 | Winona | Minnesota | 27169 | 12701 | 72 |
2383763 | 2383763 | 2022-04-07 | Winona | Minnesota | 27169 | 12690 | 72 |
2380508 | 2380508 | 2022-04-06 | Winona | Minnesota | 27169 | 12684 | 72 |
2377253 | 2377253 | 2022-04-05 | Winona | Minnesota | 27169 | 12681 | 72 |
2374001 | 2374001 | 2022-04-04 | Winona | Minnesota | 27169 | 12663 | 72 |
2370748 | 2370748 | 2022-04-03 | Winona | Minnesota | 27169 | 12659 | 72 |
2367495 | 2367495 | 2022-04-02 | Winona | Minnesota | 27169 | 12659 | 72 |
2364242 | 2364242 | 2022-04-01 | Winona | Minnesota | 27169 | 12659 | 72 |
2360988 | 2360988 | 2022-03-31 | Winona | Minnesota | 27169 | 12656 | 72 |
2357734 | 2357734 | 2022-03-30 | Winona | Minnesota | 27169 | 12654 | 72 |
2354481 | 2354481 | 2022-03-29 | Winona | Minnesota | 27169 | 12649 | 72 |
2351229 | 2351229 | 2022-03-28 | Winona | Minnesota | 27169 | 12647 | 72 |
2347976 | 2347976 | 2022-03-27 | Winona | Minnesota | 27169 | 12644 | 72 |
2344723 | 2344723 | 2022-03-26 | Winona | Minnesota | 27169 | 12644 | 72 |
2341470 | 2341470 | 2022-03-25 | Winona | Minnesota | 27169 | 12644 | 72 |
2338217 | 2338217 | 2022-03-24 | Winona | Minnesota | 27169 | 12638 | 72 |
2334963 | 2334963 | 2022-03-23 | Winona | Minnesota | 27169 | 12634 | 72 |
2331709 | 2331709 | 2022-03-22 | Winona | Minnesota | 27169 | 12631 | 72 |
2328457 | 2328457 | 2022-03-21 | Winona | Minnesota | 27169 | 12625 | 72 |
2325204 | 2325204 | 2022-03-20 | Winona | Minnesota | 27169 | 12622 | 72 |
2321950 | 2321950 | 2022-03-19 | Winona | Minnesota | 27169 | 12622 | 72 |
2318696 | 2318696 | 2022-03-18 | Winona | Minnesota | 27169 | 12622 | 72 |
2315443 | 2315443 | 2022-03-17 | Winona | Minnesota | 27169 | 12610 | 72 |
2312190 | 2312190 | 2022-03-16 | Winona | Minnesota | 27169 | 12606 | 72 |
2308937 | 2308937 | 2022-03-15 | Winona | Minnesota | 27169 | 12600 | 71 |
2305686 | 2305686 | 2022-03-14 | Winona | Minnesota | 27169 | 12594 | 71 |
2302434 | 2302434 | 2022-03-13 | Winona | Minnesota | 27169 | 12592 | 71 |
2299182 | 2299182 | 2022-03-12 | Winona | Minnesota | 27169 | 12592 | 71 |
2295930 | 2295930 | 2022-03-11 | Winona | Minnesota | 27169 | 12592 | 71 |
2292678 | 2292678 | 2022-03-10 | Winona | Minnesota | 27169 | 12466 | 71 |
2289426 | 2289426 | 2022-03-09 | Winona | Minnesota | 27169 | 12465 | 71 |
2286175 | 2286175 | 2022-03-08 | Winona | Minnesota | 27169 | 12459 | 71 |
2282923 | 2282923 | 2022-03-07 | Winona | Minnesota | 27169 | 12428 | 71 |
2279670 | 2279670 | 2022-03-06 | Winona | Minnesota | 27169 | 12423 | 71 |
2276417 | 2276417 | 2022-03-05 | Winona | Minnesota | 27169 | 12423 | 71 |
2273164 | 2273164 | 2022-03-04 | Winona | Minnesota | 27169 | 12423 | 71 |
2269912 | 2269912 | 2022-03-03 | Winona | Minnesota | 27169 | 12407 | 71 |
2266659 | 2266659 | 2022-03-02 | Winona | Minnesota | 27169 | 12392 | 71 |
2263408 | 2263408 | 2022-03-01 | Winona | Minnesota | 27169 | 12387 | 71 |
2260157 | 2260157 | 2022-02-28 | Winona | Minnesota | 27169 | 12359 | 71 |
2256906 | 2256906 | 2022-02-27 | Winona | Minnesota | 27169 | 12339 | 71 |
2253655 | 2253655 | 2022-02-26 | Winona | Minnesota | 27169 | 12339 | 71 |
2250404 | 2250404 | 2022-02-25 | Winona | Minnesota | 27169 | 12339 | 71 |
2247153 | 2247153 | 2022-02-24 | Winona | Minnesota | 27169 | 12327 | 71 |
2243902 | 2243902 | 2022-02-23 | Winona | Minnesota | 27169 | 12309 | 70 |
2240651 | 2240651 | 2022-02-22 | Winona | Minnesota | 27169 | 12233 | 70 |
2237400 | 2237400 | 2022-02-21 | Winona | Minnesota | 27169 | 12202 | 70 |
2234149 | 2234149 | 2022-02-20 | Winona | Minnesota | 27169 | 12202 | 70 |
2230898 | 2230898 | 2022-02-19 | Winona | Minnesota | 27169 | 12202 | 70 |
2227647 | 2227647 | 2022-02-18 | Winona | Minnesota | 27169 | 12202 | 70 |
2224396 | 2224396 | 2022-02-17 | Winona | Minnesota | 27169 | 12115 | 69 |
2221145 | 2221145 | 2022-02-16 | Winona | Minnesota | 27169 | 12102 | 69 |
2217894 | 2217894 | 2022-02-15 | Winona | Minnesota | 27169 | 12090 | 69 |
2214643 | 2214643 | 2022-02-14 | Winona | Minnesota | 27169 | 12021 | 69 |
2211391 | 2211391 | 2022-02-13 | Winona | Minnesota | 27169 | 11969 | 69 |
2208138 | 2208138 | 2022-02-12 | Winona | Minnesota | 27169 | 11969 | 69 |
2204885 | 2204885 | 2022-02-11 | Winona | Minnesota | 27169 | 11969 | 69 |
2201632 | 2201632 | 2022-02-10 | Winona | Minnesota | 27169 | 11924 | 69 |
2198378 | 2198378 | 2022-02-09 | Winona | Minnesota | 27169 | 11897 | 69 |
2195124 | 2195124 | 2022-02-08 | Winona | Minnesota | 27169 | 11843 | 69 |
2191870 | 2191870 | 2022-02-07 | Winona | Minnesota | 27169 | 11712 | 68 |
2188617 | 2188617 | 2022-02-06 | Winona | Minnesota | 27169 | 11625 | 68 |
2185364 | 2185364 | 2022-02-05 | Winona | Minnesota | 27169 | 11625 | 68 |
2182112 | 2182112 | 2022-02-04 | Winona | Minnesota | 27169 | 11625 | 68 |
2178860 | 2178860 | 2022-02-03 | Winona | Minnesota | 27169 | 11580 | 67 |
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);