ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
766 rows where county = "Pine" 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 |
---|---|---|---|---|---|---|---|
2500962 | 2500962 | 2022-05-13 | Pine | Minnesota | 27115 | 7175 | 67 |
2497704 | 2497704 | 2022-05-12 | Pine | Minnesota | 27115 | 7166 | 67 |
2494446 | 2494446 | 2022-05-11 | Pine | Minnesota | 27115 | 7155 | 67 |
2491188 | 2491188 | 2022-05-10 | Pine | Minnesota | 27115 | 7142 | 67 |
2487931 | 2487931 | 2022-05-09 | Pine | Minnesota | 27115 | 7128 | 67 |
2484673 | 2484673 | 2022-05-08 | Pine | Minnesota | 27115 | 7111 | 67 |
2481415 | 2481415 | 2022-05-07 | Pine | Minnesota | 27115 | 7111 | 67 |
2478157 | 2478157 | 2022-05-06 | Pine | Minnesota | 27115 | 7111 | 67 |
2474899 | 2474899 | 2022-05-05 | Pine | Minnesota | 27115 | 7097 | 67 |
2471642 | 2471642 | 2022-05-04 | Pine | Minnesota | 27115 | 7084 | 67 |
2468386 | 2468386 | 2022-05-03 | Pine | Minnesota | 27115 | 7077 | 67 |
2465131 | 2465131 | 2022-05-02 | Pine | Minnesota | 27115 | 7069 | 67 |
2461875 | 2461875 | 2022-05-01 | Pine | Minnesota | 27115 | 7057 | 67 |
2458619 | 2458619 | 2022-04-30 | Pine | Minnesota | 27115 | 7057 | 67 |
2455363 | 2455363 | 2022-04-29 | Pine | Minnesota | 27115 | 7057 | 67 |
2452107 | 2452107 | 2022-04-28 | Pine | Minnesota | 27115 | 7050 | 67 |
2448851 | 2448851 | 2022-04-27 | Pine | Minnesota | 27115 | 7044 | 67 |
2445595 | 2445595 | 2022-04-26 | Pine | Minnesota | 27115 | 7036 | 67 |
2442339 | 2442339 | 2022-04-25 | Pine | Minnesota | 27115 | 7032 | 67 |
2439083 | 2439083 | 2022-04-24 | Pine | Minnesota | 27115 | 7030 | 67 |
2435827 | 2435827 | 2022-04-23 | Pine | Minnesota | 27115 | 7030 | 67 |
2432571 | 2432571 | 2022-04-22 | Pine | Minnesota | 27115 | 7030 | 67 |
2429315 | 2429315 | 2022-04-21 | Pine | Minnesota | 27115 | 7026 | 67 |
2426059 | 2426059 | 2022-04-20 | Pine | Minnesota | 27115 | 7025 | 67 |
2422803 | 2422803 | 2022-04-19 | Pine | Minnesota | 27115 | 7023 | 67 |
2419547 | 2419547 | 2022-04-18 | Pine | Minnesota | 27115 | 7020 | 67 |
2416291 | 2416291 | 2022-04-17 | Pine | Minnesota | 27115 | 7018 | 67 |
2413035 | 2413035 | 2022-04-16 | Pine | Minnesota | 27115 | 7018 | 67 |
2409779 | 2409779 | 2022-04-15 | Pine | Minnesota | 27115 | 7018 | 67 |
2406523 | 2406523 | 2022-04-14 | Pine | Minnesota | 27115 | 7018 | 67 |
2403267 | 2403267 | 2022-04-13 | Pine | Minnesota | 27115 | 7016 | 67 |
2400013 | 2400013 | 2022-04-12 | Pine | Minnesota | 27115 | 7011 | 67 |
2396757 | 2396757 | 2022-04-11 | Pine | Minnesota | 27115 | 7005 | 67 |
2393502 | 2393502 | 2022-04-10 | Pine | Minnesota | 27115 | 7004 | 67 |
2390246 | 2390246 | 2022-04-09 | Pine | Minnesota | 27115 | 7004 | 67 |
2386990 | 2386990 | 2022-04-08 | Pine | Minnesota | 27115 | 7004 | 67 |
2383735 | 2383735 | 2022-04-07 | Pine | Minnesota | 27115 | 7002 | 67 |
2380480 | 2380480 | 2022-04-06 | Pine | Minnesota | 27115 | 7001 | 67 |
2377225 | 2377225 | 2022-04-05 | Pine | Minnesota | 27115 | 6998 | 67 |
2373973 | 2373973 | 2022-04-04 | Pine | Minnesota | 27115 | 6996 | 67 |
2370720 | 2370720 | 2022-04-03 | Pine | Minnesota | 27115 | 6993 | 67 |
2367467 | 2367467 | 2022-04-02 | Pine | Minnesota | 27115 | 6993 | 67 |
2364214 | 2364214 | 2022-04-01 | Pine | Minnesota | 27115 | 6993 | 67 |
2360960 | 2360960 | 2022-03-31 | Pine | Minnesota | 27115 | 6991 | 67 |
2357706 | 2357706 | 2022-03-30 | Pine | Minnesota | 27115 | 6990 | 67 |
2354453 | 2354453 | 2022-03-29 | Pine | Minnesota | 27115 | 6990 | 67 |
2351201 | 2351201 | 2022-03-28 | Pine | Minnesota | 27115 | 6988 | 67 |
2347948 | 2347948 | 2022-03-27 | Pine | Minnesota | 27115 | 6987 | 67 |
2344695 | 2344695 | 2022-03-26 | Pine | Minnesota | 27115 | 6987 | 67 |
2341442 | 2341442 | 2022-03-25 | Pine | Minnesota | 27115 | 6987 | 67 |
2338189 | 2338189 | 2022-03-24 | Pine | Minnesota | 27115 | 6987 | 67 |
2334935 | 2334935 | 2022-03-23 | Pine | Minnesota | 27115 | 6984 | 67 |
2331681 | 2331681 | 2022-03-22 | Pine | Minnesota | 27115 | 6984 | 67 |
2328429 | 2328429 | 2022-03-21 | Pine | Minnesota | 27115 | 6983 | 67 |
2325176 | 2325176 | 2022-03-20 | Pine | Minnesota | 27115 | 6981 | 67 |
2321922 | 2321922 | 2022-03-19 | Pine | Minnesota | 27115 | 6981 | 67 |
2318668 | 2318668 | 2022-03-18 | Pine | Minnesota | 27115 | 6981 | 67 |
2315415 | 2315415 | 2022-03-17 | Pine | Minnesota | 27115 | 6981 | 67 |
2312162 | 2312162 | 2022-03-16 | Pine | Minnesota | 27115 | 6980 | 66 |
2308909 | 2308909 | 2022-03-15 | Pine | Minnesota | 27115 | 6976 | 66 |
2305658 | 2305658 | 2022-03-14 | Pine | Minnesota | 27115 | 6975 | 66 |
2302406 | 2302406 | 2022-03-13 | Pine | Minnesota | 27115 | 6974 | 66 |
2299154 | 2299154 | 2022-03-12 | Pine | Minnesota | 27115 | 6974 | 66 |
2295902 | 2295902 | 2022-03-11 | Pine | Minnesota | 27115 | 6974 | 66 |
2292650 | 2292650 | 2022-03-10 | Pine | Minnesota | 27115 | 6947 | 66 |
2289398 | 2289398 | 2022-03-09 | Pine | Minnesota | 27115 | 6945 | 66 |
2286147 | 2286147 | 2022-03-08 | Pine | Minnesota | 27115 | 6943 | 66 |
2282895 | 2282895 | 2022-03-07 | Pine | Minnesota | 27115 | 6938 | 66 |
2279642 | 2279642 | 2022-03-06 | Pine | Minnesota | 27115 | 6937 | 66 |
2276389 | 2276389 | 2022-03-05 | Pine | Minnesota | 27115 | 6937 | 66 |
2273136 | 2273136 | 2022-03-04 | Pine | Minnesota | 27115 | 6937 | 66 |
2269884 | 2269884 | 2022-03-03 | Pine | Minnesota | 27115 | 6936 | 66 |
2266631 | 2266631 | 2022-03-02 | Pine | Minnesota | 27115 | 6934 | 64 |
2263380 | 2263380 | 2022-03-01 | Pine | Minnesota | 27115 | 6936 | 64 |
2260129 | 2260129 | 2022-02-28 | Pine | Minnesota | 27115 | 6929 | 64 |
2256878 | 2256878 | 2022-02-27 | Pine | Minnesota | 27115 | 6924 | 62 |
2253627 | 2253627 | 2022-02-26 | Pine | Minnesota | 27115 | 6924 | 62 |
2250376 | 2250376 | 2022-02-25 | Pine | Minnesota | 27115 | 6924 | 62 |
2247125 | 2247125 | 2022-02-24 | Pine | Minnesota | 27115 | 6920 | 62 |
2243874 | 2243874 | 2022-02-23 | Pine | Minnesota | 27115 | 6919 | 61 |
2240623 | 2240623 | 2022-02-22 | Pine | Minnesota | 27115 | 6898 | 61 |
2237372 | 2237372 | 2022-02-21 | Pine | Minnesota | 27115 | 6886 | 61 |
2234121 | 2234121 | 2022-02-20 | Pine | Minnesota | 27115 | 6886 | 61 |
2230870 | 2230870 | 2022-02-19 | Pine | Minnesota | 27115 | 6886 | 61 |
2227619 | 2227619 | 2022-02-18 | Pine | Minnesota | 27115 | 6886 | 61 |
2224368 | 2224368 | 2022-02-17 | Pine | Minnesota | 27115 | 6860 | 61 |
2221117 | 2221117 | 2022-02-16 | Pine | Minnesota | 27115 | 6855 | 61 |
2217866 | 2217866 | 2022-02-15 | Pine | Minnesota | 27115 | 6847 | 61 |
2214615 | 2214615 | 2022-02-14 | Pine | Minnesota | 27115 | 6822 | 60 |
2211363 | 2211363 | 2022-02-13 | Pine | Minnesota | 27115 | 6778 | 60 |
2208110 | 2208110 | 2022-02-12 | Pine | Minnesota | 27115 | 6778 | 60 |
2204857 | 2204857 | 2022-02-11 | Pine | Minnesota | 27115 | 6778 | 60 |
2201604 | 2201604 | 2022-02-10 | Pine | Minnesota | 27115 | 6759 | 60 |
2198350 | 2198350 | 2022-02-09 | Pine | Minnesota | 27115 | 6726 | 59 |
2195096 | 2195096 | 2022-02-08 | Pine | Minnesota | 27115 | 6699 | 59 |
2191842 | 2191842 | 2022-02-07 | Pine | Minnesota | 27115 | 6646 | 59 |
2188589 | 2188589 | 2022-02-06 | Pine | Minnesota | 27115 | 6617 | 59 |
2185336 | 2185336 | 2022-02-05 | Pine | Minnesota | 27115 | 6617 | 59 |
2182084 | 2182084 | 2022-02-04 | Pine | Minnesota | 27115 | 6617 | 59 |
2178832 | 2178832 | 2022-02-03 | Pine | Minnesota | 27115 | 6593 | 59 |
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);