ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 27049 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 |
---|---|---|---|---|---|---|---|
2500929 | 2500929 | 2022-05-13 | Goodhue | Minnesota | 27049 | 13600 | 136 |
2497671 | 2497671 | 2022-05-12 | Goodhue | Minnesota | 27049 | 13565 | 136 |
2494413 | 2494413 | 2022-05-11 | Goodhue | Minnesota | 27049 | 13546 | 136 |
2491155 | 2491155 | 2022-05-10 | Goodhue | Minnesota | 27049 | 13536 | 136 |
2487898 | 2487898 | 2022-05-09 | Goodhue | Minnesota | 27049 | 13506 | 135 |
2484640 | 2484640 | 2022-05-08 | Goodhue | Minnesota | 27049 | 13483 | 135 |
2481382 | 2481382 | 2022-05-07 | Goodhue | Minnesota | 27049 | 13483 | 135 |
2478124 | 2478124 | 2022-05-06 | Goodhue | Minnesota | 27049 | 13483 | 135 |
2474866 | 2474866 | 2022-05-05 | Goodhue | Minnesota | 27049 | 13462 | 135 |
2471609 | 2471609 | 2022-05-04 | Goodhue | Minnesota | 27049 | 13436 | 134 |
2468353 | 2468353 | 2022-05-03 | Goodhue | Minnesota | 27049 | 13409 | 134 |
2465098 | 2465098 | 2022-05-02 | Goodhue | Minnesota | 27049 | 13373 | 134 |
2461842 | 2461842 | 2022-05-01 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2458586 | 2458586 | 2022-04-30 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2455330 | 2455330 | 2022-04-29 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2452074 | 2452074 | 2022-04-28 | Goodhue | Minnesota | 27049 | 13308 | 133 |
2448818 | 2448818 | 2022-04-27 | Goodhue | Minnesota | 27049 | 13283 | 133 |
2445562 | 2445562 | 2022-04-26 | Goodhue | Minnesota | 27049 | 13271 | 133 |
2442306 | 2442306 | 2022-04-25 | Goodhue | Minnesota | 27049 | 13234 | 133 |
2439050 | 2439050 | 2022-04-24 | Goodhue | Minnesota | 27049 | 13224 | 133 |
2435794 | 2435794 | 2022-04-23 | Goodhue | Minnesota | 27049 | 13224 | 133 |
2432538 | 2432538 | 2022-04-22 | Goodhue | Minnesota | 27049 | 13224 | 133 |
2429282 | 2429282 | 2022-04-21 | Goodhue | Minnesota | 27049 | 13209 | 131 |
2426026 | 2426026 | 2022-04-20 | Goodhue | Minnesota | 27049 | 13188 | 131 |
2422770 | 2422770 | 2022-04-19 | Goodhue | Minnesota | 27049 | 13177 | 131 |
2419514 | 2419514 | 2022-04-18 | Goodhue | Minnesota | 27049 | 13160 | 131 |
2416258 | 2416258 | 2022-04-17 | Goodhue | Minnesota | 27049 | 13152 | 131 |
2413002 | 2413002 | 2022-04-16 | Goodhue | Minnesota | 27049 | 13152 | 131 |
2409746 | 2409746 | 2022-04-15 | Goodhue | Minnesota | 27049 | 13152 | 131 |
2406490 | 2406490 | 2022-04-14 | Goodhue | Minnesota | 27049 | 13139 | 131 |
2403234 | 2403234 | 2022-04-13 | Goodhue | Minnesota | 27049 | 13125 | 131 |
2399980 | 2399980 | 2022-04-12 | Goodhue | Minnesota | 27049 | 13121 | 131 |
2396724 | 2396724 | 2022-04-11 | Goodhue | Minnesota | 27049 | 13105 | 131 |
2393469 | 2393469 | 2022-04-10 | Goodhue | Minnesota | 27049 | 13097 | 130 |
2390213 | 2390213 | 2022-04-09 | Goodhue | Minnesota | 27049 | 13097 | 130 |
2386957 | 2386957 | 2022-04-08 | Goodhue | Minnesota | 27049 | 13097 | 130 |
2383702 | 2383702 | 2022-04-07 | Goodhue | Minnesota | 27049 | 13092 | 130 |
2380447 | 2380447 | 2022-04-06 | Goodhue | Minnesota | 27049 | 13087 | 129 |
2377192 | 2377192 | 2022-04-05 | Goodhue | Minnesota | 27049 | 13077 | 129 |
2373940 | 2373940 | 2022-04-04 | Goodhue | Minnesota | 27049 | 13062 | 129 |
2370687 | 2370687 | 2022-04-03 | Goodhue | Minnesota | 27049 | 13056 | 129 |
2367434 | 2367434 | 2022-04-02 | Goodhue | Minnesota | 27049 | 13056 | 129 |
2364181 | 2364181 | 2022-04-01 | Goodhue | Minnesota | 27049 | 13056 | 129 |
2360927 | 2360927 | 2022-03-31 | Goodhue | Minnesota | 27049 | 13048 | 129 |
2357673 | 2357673 | 2022-03-30 | Goodhue | Minnesota | 27049 | 13044 | 129 |
2354420 | 2354420 | 2022-03-29 | Goodhue | Minnesota | 27049 | 13041 | 128 |
2351168 | 2351168 | 2022-03-28 | Goodhue | Minnesota | 27049 | 13025 | 128 |
2347915 | 2347915 | 2022-03-27 | Goodhue | Minnesota | 27049 | 13023 | 127 |
2344662 | 2344662 | 2022-03-26 | Goodhue | Minnesota | 27049 | 13023 | 127 |
2341409 | 2341409 | 2022-03-25 | Goodhue | Minnesota | 27049 | 13023 | 127 |
2338156 | 2338156 | 2022-03-24 | Goodhue | Minnesota | 27049 | 13017 | 127 |
2334902 | 2334902 | 2022-03-23 | Goodhue | Minnesota | 27049 | 13010 | 127 |
2331648 | 2331648 | 2022-03-22 | Goodhue | Minnesota | 27049 | 13005 | 127 |
2328396 | 2328396 | 2022-03-21 | Goodhue | Minnesota | 27049 | 12989 | 127 |
2325143 | 2325143 | 2022-03-20 | Goodhue | Minnesota | 27049 | 12980 | 127 |
2321889 | 2321889 | 2022-03-19 | Goodhue | Minnesota | 27049 | 12980 | 127 |
2318635 | 2318635 | 2022-03-18 | Goodhue | Minnesota | 27049 | 12980 | 127 |
2315382 | 2315382 | 2022-03-17 | Goodhue | Minnesota | 27049 | 12972 | 127 |
2312129 | 2312129 | 2022-03-16 | Goodhue | Minnesota | 27049 | 12962 | 127 |
2308876 | 2308876 | 2022-03-15 | Goodhue | Minnesota | 27049 | 12946 | 127 |
2305625 | 2305625 | 2022-03-14 | Goodhue | Minnesota | 27049 | 12940 | 127 |
2302373 | 2302373 | 2022-03-13 | Goodhue | Minnesota | 27049 | 12931 | 127 |
2299121 | 2299121 | 2022-03-12 | Goodhue | Minnesota | 27049 | 12931 | 127 |
2295869 | 2295869 | 2022-03-11 | Goodhue | Minnesota | 27049 | 12931 | 127 |
2292617 | 2292617 | 2022-03-10 | Goodhue | Minnesota | 27049 | 12883 | 126 |
2289365 | 2289365 | 2022-03-09 | Goodhue | Minnesota | 27049 | 12874 | 126 |
2286114 | 2286114 | 2022-03-08 | Goodhue | Minnesota | 27049 | 12869 | 126 |
2282862 | 2282862 | 2022-03-07 | Goodhue | Minnesota | 27049 | 12851 | 126 |
2279609 | 2279609 | 2022-03-06 | Goodhue | Minnesota | 27049 | 12841 | 126 |
2276356 | 2276356 | 2022-03-05 | Goodhue | Minnesota | 27049 | 12841 | 126 |
2273103 | 2273103 | 2022-03-04 | Goodhue | Minnesota | 27049 | 12841 | 126 |
2269851 | 2269851 | 2022-03-03 | Goodhue | Minnesota | 27049 | 12828 | 126 |
2266598 | 2266598 | 2022-03-02 | Goodhue | Minnesota | 27049 | 12820 | 126 |
2263347 | 2263347 | 2022-03-01 | Goodhue | Minnesota | 27049 | 12819 | 125 |
2260096 | 2260096 | 2022-02-28 | Goodhue | Minnesota | 27049 | 12793 | 125 |
2256845 | 2256845 | 2022-02-27 | Goodhue | Minnesota | 27049 | 12776 | 123 |
2253594 | 2253594 | 2022-02-26 | Goodhue | Minnesota | 27049 | 12776 | 123 |
2250343 | 2250343 | 2022-02-25 | Goodhue | Minnesota | 27049 | 12776 | 123 |
2247092 | 2247092 | 2022-02-24 | Goodhue | Minnesota | 27049 | 12761 | 122 |
2243841 | 2243841 | 2022-02-23 | Goodhue | Minnesota | 27049 | 12736 | 121 |
2240590 | 2240590 | 2022-02-22 | Goodhue | Minnesota | 27049 | 12684 | 120 |
2237339 | 2237339 | 2022-02-21 | Goodhue | Minnesota | 27049 | 12658 | 120 |
2234088 | 2234088 | 2022-02-20 | Goodhue | Minnesota | 27049 | 12658 | 120 |
2230837 | 2230837 | 2022-02-19 | Goodhue | Minnesota | 27049 | 12658 | 120 |
2227586 | 2227586 | 2022-02-18 | Goodhue | Minnesota | 27049 | 12658 | 120 |
2224335 | 2224335 | 2022-02-17 | Goodhue | Minnesota | 27049 | 12627 | 120 |
2221084 | 2221084 | 2022-02-16 | Goodhue | Minnesota | 27049 | 12608 | 120 |
2217833 | 2217833 | 2022-02-15 | Goodhue | Minnesota | 27049 | 12592 | 120 |
2214582 | 2214582 | 2022-02-14 | Goodhue | Minnesota | 27049 | 12525 | 120 |
2211330 | 2211330 | 2022-02-13 | Goodhue | Minnesota | 27049 | 12478 | 119 |
2208077 | 2208077 | 2022-02-12 | Goodhue | Minnesota | 27049 | 12478 | 119 |
2204824 | 2204824 | 2022-02-11 | Goodhue | Minnesota | 27049 | 12478 | 119 |
2201571 | 2201571 | 2022-02-10 | Goodhue | Minnesota | 27049 | 12428 | 119 |
2198317 | 2198317 | 2022-02-09 | Goodhue | Minnesota | 27049 | 12388 | 118 |
2195063 | 2195063 | 2022-02-08 | Goodhue | Minnesota | 27049 | 12352 | 118 |
2191809 | 2191809 | 2022-02-07 | Goodhue | Minnesota | 27049 | 12243 | 116 |
2188556 | 2188556 | 2022-02-06 | Goodhue | Minnesota | 27049 | 12187 | 116 |
2185303 | 2185303 | 2022-02-05 | Goodhue | Minnesota | 27049 | 12187 | 116 |
2182051 | 2182051 | 2022-02-04 | Goodhue | Minnesota | 27049 | 12187 | 116 |
2178799 | 2178799 | 2022-02-03 | Goodhue | Minnesota | 27049 | 12123 | 116 |
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);