ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
774 rows where county = "Traverse" 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 |
---|---|---|---|---|---|---|---|
2500982 | 2500982 | 2022-05-13 | Traverse | Minnesota | 27155 | 871 | 10 |
2497724 | 2497724 | 2022-05-12 | Traverse | Minnesota | 27155 | 870 | 10 |
2494466 | 2494466 | 2022-05-11 | Traverse | Minnesota | 27155 | 868 | 10 |
2491208 | 2491208 | 2022-05-10 | Traverse | Minnesota | 27155 | 864 | 10 |
2487951 | 2487951 | 2022-05-09 | Traverse | Minnesota | 27155 | 860 | 10 |
2484693 | 2484693 | 2022-05-08 | Traverse | Minnesota | 27155 | 860 | 10 |
2481435 | 2481435 | 2022-05-07 | Traverse | Minnesota | 27155 | 860 | 10 |
2478177 | 2478177 | 2022-05-06 | Traverse | Minnesota | 27155 | 860 | 10 |
2474919 | 2474919 | 2022-05-05 | Traverse | Minnesota | 27155 | 858 | 10 |
2471662 | 2471662 | 2022-05-04 | Traverse | Minnesota | 27155 | 858 | 10 |
2468406 | 2468406 | 2022-05-03 | Traverse | Minnesota | 27155 | 858 | 10 |
2465151 | 2465151 | 2022-05-02 | Traverse | Minnesota | 27155 | 858 | 10 |
2461895 | 2461895 | 2022-05-01 | Traverse | Minnesota | 27155 | 858 | 10 |
2458639 | 2458639 | 2022-04-30 | Traverse | Minnesota | 27155 | 858 | 10 |
2455383 | 2455383 | 2022-04-29 | Traverse | Minnesota | 27155 | 858 | 10 |
2452127 | 2452127 | 2022-04-28 | Traverse | Minnesota | 27155 | 858 | 10 |
2448871 | 2448871 | 2022-04-27 | Traverse | Minnesota | 27155 | 857 | 10 |
2445615 | 2445615 | 2022-04-26 | Traverse | Minnesota | 27155 | 857 | 10 |
2442359 | 2442359 | 2022-04-25 | Traverse | Minnesota | 27155 | 857 | 10 |
2439103 | 2439103 | 2022-04-24 | Traverse | Minnesota | 27155 | 857 | 10 |
2435847 | 2435847 | 2022-04-23 | Traverse | Minnesota | 27155 | 857 | 10 |
2432591 | 2432591 | 2022-04-22 | Traverse | Minnesota | 27155 | 857 | 10 |
2429335 | 2429335 | 2022-04-21 | Traverse | Minnesota | 27155 | 857 | 10 |
2426079 | 2426079 | 2022-04-20 | Traverse | Minnesota | 27155 | 857 | 10 |
2422823 | 2422823 | 2022-04-19 | Traverse | Minnesota | 27155 | 856 | 10 |
2419567 | 2419567 | 2022-04-18 | Traverse | Minnesota | 27155 | 856 | 10 |
2416311 | 2416311 | 2022-04-17 | Traverse | Minnesota | 27155 | 854 | 10 |
2413055 | 2413055 | 2022-04-16 | Traverse | Minnesota | 27155 | 854 | 10 |
2409799 | 2409799 | 2022-04-15 | Traverse | Minnesota | 27155 | 854 | 10 |
2406543 | 2406543 | 2022-04-14 | Traverse | Minnesota | 27155 | 854 | 10 |
2403287 | 2403287 | 2022-04-13 | Traverse | Minnesota | 27155 | 854 | 10 |
2400033 | 2400033 | 2022-04-12 | Traverse | Minnesota | 27155 | 853 | 10 |
2396777 | 2396777 | 2022-04-11 | Traverse | Minnesota | 27155 | 853 | 10 |
2393522 | 2393522 | 2022-04-10 | Traverse | Minnesota | 27155 | 851 | 10 |
2390266 | 2390266 | 2022-04-09 | Traverse | Minnesota | 27155 | 851 | 10 |
2387010 | 2387010 | 2022-04-08 | Traverse | Minnesota | 27155 | 851 | 10 |
2383755 | 2383755 | 2022-04-07 | Traverse | Minnesota | 27155 | 851 | 10 |
2380500 | 2380500 | 2022-04-06 | Traverse | Minnesota | 27155 | 851 | 10 |
2377245 | 2377245 | 2022-04-05 | Traverse | Minnesota | 27155 | 851 | 10 |
2373993 | 2373993 | 2022-04-04 | Traverse | Minnesota | 27155 | 850 | 10 |
2370740 | 2370740 | 2022-04-03 | Traverse | Minnesota | 27155 | 850 | 10 |
2367487 | 2367487 | 2022-04-02 | Traverse | Minnesota | 27155 | 850 | 10 |
2364234 | 2364234 | 2022-04-01 | Traverse | Minnesota | 27155 | 850 | 10 |
2360980 | 2360980 | 2022-03-31 | Traverse | Minnesota | 27155 | 850 | 10 |
2357726 | 2357726 | 2022-03-30 | Traverse | Minnesota | 27155 | 850 | 10 |
2354473 | 2354473 | 2022-03-29 | Traverse | Minnesota | 27155 | 850 | 10 |
2351221 | 2351221 | 2022-03-28 | Traverse | Minnesota | 27155 | 850 | 10 |
2347968 | 2347968 | 2022-03-27 | Traverse | Minnesota | 27155 | 850 | 10 |
2344715 | 2344715 | 2022-03-26 | Traverse | Minnesota | 27155 | 850 | 10 |
2341462 | 2341462 | 2022-03-25 | Traverse | Minnesota | 27155 | 850 | 10 |
2338209 | 2338209 | 2022-03-24 | Traverse | Minnesota | 27155 | 850 | 10 |
2334955 | 2334955 | 2022-03-23 | Traverse | Minnesota | 27155 | 851 | 10 |
2331701 | 2331701 | 2022-03-22 | Traverse | Minnesota | 27155 | 851 | 10 |
2328449 | 2328449 | 2022-03-21 | Traverse | Minnesota | 27155 | 850 | 10 |
2325196 | 2325196 | 2022-03-20 | Traverse | Minnesota | 27155 | 850 | 10 |
2321942 | 2321942 | 2022-03-19 | Traverse | Minnesota | 27155 | 850 | 10 |
2318688 | 2318688 | 2022-03-18 | Traverse | Minnesota | 27155 | 850 | 10 |
2315435 | 2315435 | 2022-03-17 | Traverse | Minnesota | 27155 | 850 | 10 |
2312182 | 2312182 | 2022-03-16 | Traverse | Minnesota | 27155 | 850 | 10 |
2308929 | 2308929 | 2022-03-15 | Traverse | Minnesota | 27155 | 850 | 10 |
2305678 | 2305678 | 2022-03-14 | Traverse | Minnesota | 27155 | 850 | 10 |
2302426 | 2302426 | 2022-03-13 | Traverse | Minnesota | 27155 | 850 | 10 |
2299174 | 2299174 | 2022-03-12 | Traverse | Minnesota | 27155 | 850 | 10 |
2295922 | 2295922 | 2022-03-11 | Traverse | Minnesota | 27155 | 850 | 10 |
2292670 | 2292670 | 2022-03-10 | Traverse | Minnesota | 27155 | 831 | 10 |
2289418 | 2289418 | 2022-03-09 | Traverse | Minnesota | 27155 | 828 | 10 |
2286167 | 2286167 | 2022-03-08 | Traverse | Minnesota | 27155 | 828 | 10 |
2282915 | 2282915 | 2022-03-07 | Traverse | Minnesota | 27155 | 828 | 10 |
2279662 | 2279662 | 2022-03-06 | Traverse | Minnesota | 27155 | 827 | 10 |
2276409 | 2276409 | 2022-03-05 | Traverse | Minnesota | 27155 | 827 | 10 |
2273156 | 2273156 | 2022-03-04 | Traverse | Minnesota | 27155 | 827 | 10 |
2269904 | 2269904 | 2022-03-03 | Traverse | Minnesota | 27155 | 826 | 10 |
2266651 | 2266651 | 2022-03-02 | Traverse | Minnesota | 27155 | 825 | 10 |
2263400 | 2263400 | 2022-03-01 | Traverse | Minnesota | 27155 | 824 | 10 |
2260149 | 2260149 | 2022-02-28 | Traverse | Minnesota | 27155 | 824 | 10 |
2256898 | 2256898 | 2022-02-27 | Traverse | Minnesota | 27155 | 823 | 10 |
2253647 | 2253647 | 2022-02-26 | Traverse | Minnesota | 27155 | 823 | 10 |
2250396 | 2250396 | 2022-02-25 | Traverse | Minnesota | 27155 | 823 | 10 |
2247145 | 2247145 | 2022-02-24 | Traverse | Minnesota | 27155 | 823 | 10 |
2243894 | 2243894 | 2022-02-23 | Traverse | Minnesota | 27155 | 822 | 10 |
2240643 | 2240643 | 2022-02-22 | Traverse | Minnesota | 27155 | 821 | 10 |
2237392 | 2237392 | 2022-02-21 | Traverse | Minnesota | 27155 | 818 | 10 |
2234141 | 2234141 | 2022-02-20 | Traverse | Minnesota | 27155 | 818 | 10 |
2230890 | 2230890 | 2022-02-19 | Traverse | Minnesota | 27155 | 818 | 10 |
2227639 | 2227639 | 2022-02-18 | Traverse | Minnesota | 27155 | 818 | 10 |
2224388 | 2224388 | 2022-02-17 | Traverse | Minnesota | 27155 | 813 | 10 |
2221137 | 2221137 | 2022-02-16 | Traverse | Minnesota | 27155 | 813 | 10 |
2217886 | 2217886 | 2022-02-15 | Traverse | Minnesota | 27155 | 810 | 10 |
2214635 | 2214635 | 2022-02-14 | Traverse | Minnesota | 27155 | 804 | 10 |
2211383 | 2211383 | 2022-02-13 | Traverse | Minnesota | 27155 | 797 | 10 |
2208130 | 2208130 | 2022-02-12 | Traverse | Minnesota | 27155 | 797 | 10 |
2204877 | 2204877 | 2022-02-11 | Traverse | Minnesota | 27155 | 797 | 10 |
2201624 | 2201624 | 2022-02-10 | Traverse | Minnesota | 27155 | 794 | 9 |
2198370 | 2198370 | 2022-02-09 | Traverse | Minnesota | 27155 | 788 | 9 |
2195116 | 2195116 | 2022-02-08 | Traverse | Minnesota | 27155 | 783 | 9 |
2191862 | 2191862 | 2022-02-07 | Traverse | Minnesota | 27155 | 770 | 9 |
2188609 | 2188609 | 2022-02-06 | Traverse | Minnesota | 27155 | 758 | 9 |
2185356 | 2185356 | 2022-02-05 | Traverse | Minnesota | 27155 | 758 | 9 |
2182104 | 2182104 | 2022-02-04 | Traverse | Minnesota | 27155 | 758 | 9 |
2178852 | 2178852 | 2022-02-03 | Traverse | Minnesota | 27155 | 752 | 9 |
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);