ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where fips = 27165 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 |
---|---|---|---|---|---|---|---|
2500988 | 2500988 | 2022-05-13 | Watonwan | Minnesota | 27165 | 2990 | 23 |
2497730 | 2497730 | 2022-05-12 | Watonwan | Minnesota | 27165 | 2988 | 23 |
2494472 | 2494472 | 2022-05-11 | Watonwan | Minnesota | 27165 | 2988 | 23 |
2491214 | 2491214 | 2022-05-10 | Watonwan | Minnesota | 27165 | 2988 | 23 |
2487957 | 2487957 | 2022-05-09 | Watonwan | Minnesota | 27165 | 2986 | 23 |
2484699 | 2484699 | 2022-05-08 | Watonwan | Minnesota | 27165 | 2986 | 23 |
2481441 | 2481441 | 2022-05-07 | Watonwan | Minnesota | 27165 | 2986 | 23 |
2478183 | 2478183 | 2022-05-06 | Watonwan | Minnesota | 27165 | 2986 | 23 |
2474925 | 2474925 | 2022-05-05 | Watonwan | Minnesota | 27165 | 2987 | 23 |
2471668 | 2471668 | 2022-05-04 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2468412 | 2468412 | 2022-05-03 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2465157 | 2465157 | 2022-05-02 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2461901 | 2461901 | 2022-05-01 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2458645 | 2458645 | 2022-04-30 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2455389 | 2455389 | 2022-04-29 | Watonwan | Minnesota | 27165 | 2984 | 23 |
2452133 | 2452133 | 2022-04-28 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2448877 | 2448877 | 2022-04-27 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2445621 | 2445621 | 2022-04-26 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2442365 | 2442365 | 2022-04-25 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2439109 | 2439109 | 2022-04-24 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2435853 | 2435853 | 2022-04-23 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2432597 | 2432597 | 2022-04-22 | Watonwan | Minnesota | 27165 | 2983 | 23 |
2429341 | 2429341 | 2022-04-21 | Watonwan | Minnesota | 27165 | 2980 | 23 |
2426085 | 2426085 | 2022-04-20 | Watonwan | Minnesota | 27165 | 2980 | 23 |
2422829 | 2422829 | 2022-04-19 | Watonwan | Minnesota | 27165 | 2980 | 23 |
2419573 | 2419573 | 2022-04-18 | Watonwan | Minnesota | 27165 | 2980 | 23 |
2416317 | 2416317 | 2022-04-17 | Watonwan | Minnesota | 27165 | 2979 | 23 |
2413061 | 2413061 | 2022-04-16 | Watonwan | Minnesota | 27165 | 2979 | 23 |
2409805 | 2409805 | 2022-04-15 | Watonwan | Minnesota | 27165 | 2979 | 23 |
2406549 | 2406549 | 2022-04-14 | Watonwan | Minnesota | 27165 | 2979 | 23 |
2403293 | 2403293 | 2022-04-13 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2400039 | 2400039 | 2022-04-12 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2396783 | 2396783 | 2022-04-11 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2393528 | 2393528 | 2022-04-10 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2390272 | 2390272 | 2022-04-09 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2387016 | 2387016 | 2022-04-08 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2383761 | 2383761 | 2022-04-07 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2380506 | 2380506 | 2022-04-06 | Watonwan | Minnesota | 27165 | 2978 | 23 |
2377251 | 2377251 | 2022-04-05 | Watonwan | Minnesota | 27165 | 2977 | 23 |
2373999 | 2373999 | 2022-04-04 | Watonwan | Minnesota | 27165 | 2977 | 23 |
2370746 | 2370746 | 2022-04-03 | Watonwan | Minnesota | 27165 | 2976 | 23 |
2367493 | 2367493 | 2022-04-02 | Watonwan | Minnesota | 27165 | 2976 | 23 |
2364240 | 2364240 | 2022-04-01 | Watonwan | Minnesota | 27165 | 2976 | 23 |
2360986 | 2360986 | 2022-03-31 | Watonwan | Minnesota | 27165 | 2976 | 23 |
2357732 | 2357732 | 2022-03-30 | Watonwan | Minnesota | 27165 | 2974 | 23 |
2354479 | 2354479 | 2022-03-29 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2351227 | 2351227 | 2022-03-28 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2347974 | 2347974 | 2022-03-27 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2344721 | 2344721 | 2022-03-26 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2341468 | 2341468 | 2022-03-25 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2338215 | 2338215 | 2022-03-24 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2334961 | 2334961 | 2022-03-23 | Watonwan | Minnesota | 27165 | 2973 | 23 |
2331707 | 2331707 | 2022-03-22 | Watonwan | Minnesota | 27165 | 2971 | 23 |
2328455 | 2328455 | 2022-03-21 | Watonwan | Minnesota | 27165 | 2969 | 23 |
2325202 | 2325202 | 2022-03-20 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2321948 | 2321948 | 2022-03-19 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2318694 | 2318694 | 2022-03-18 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2315441 | 2315441 | 2022-03-17 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2312188 | 2312188 | 2022-03-16 | Watonwan | Minnesota | 27165 | 2966 | 23 |
2308935 | 2308935 | 2022-03-15 | Watonwan | Minnesota | 27165 | 2963 | 23 |
2305684 | 2305684 | 2022-03-14 | Watonwan | Minnesota | 27165 | 2961 | 23 |
2302432 | 2302432 | 2022-03-13 | Watonwan | Minnesota | 27165 | 2962 | 23 |
2299180 | 2299180 | 2022-03-12 | Watonwan | Minnesota | 27165 | 2962 | 23 |
2295928 | 2295928 | 2022-03-11 | Watonwan | Minnesota | 27165 | 2962 | 23 |
2292676 | 2292676 | 2022-03-10 | Watonwan | Minnesota | 27165 | 2949 | 23 |
2289424 | 2289424 | 2022-03-09 | Watonwan | Minnesota | 27165 | 2943 | 23 |
2286173 | 2286173 | 2022-03-08 | Watonwan | Minnesota | 27165 | 2941 | 23 |
2282921 | 2282921 | 2022-03-07 | Watonwan | Minnesota | 27165 | 2941 | 23 |
2279668 | 2279668 | 2022-03-06 | Watonwan | Minnesota | 27165 | 2925 | 23 |
2276415 | 2276415 | 2022-03-05 | Watonwan | Minnesota | 27165 | 2925 | 23 |
2273162 | 2273162 | 2022-03-04 | Watonwan | Minnesota | 27165 | 2925 | 23 |
2269910 | 2269910 | 2022-03-03 | Watonwan | Minnesota | 27165 | 2925 | 23 |
2266657 | 2266657 | 2022-03-02 | Watonwan | Minnesota | 27165 | 2922 | 23 |
2263406 | 2263406 | 2022-03-01 | Watonwan | Minnesota | 27165 | 2921 | 23 |
2260155 | 2260155 | 2022-02-28 | Watonwan | Minnesota | 27165 | 2917 | 22 |
2256904 | 2256904 | 2022-02-27 | Watonwan | Minnesota | 27165 | 2912 | 22 |
2253653 | 2253653 | 2022-02-26 | Watonwan | Minnesota | 27165 | 2912 | 22 |
2250402 | 2250402 | 2022-02-25 | Watonwan | Minnesota | 27165 | 2912 | 22 |
2247151 | 2247151 | 2022-02-24 | Watonwan | Minnesota | 27165 | 2910 | 22 |
2243900 | 2243900 | 2022-02-23 | Watonwan | Minnesota | 27165 | 2904 | 22 |
2240649 | 2240649 | 2022-02-22 | Watonwan | Minnesota | 27165 | 2898 | 22 |
2237398 | 2237398 | 2022-02-21 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2234147 | 2234147 | 2022-02-20 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2230896 | 2230896 | 2022-02-19 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2227645 | 2227645 | 2022-02-18 | Watonwan | Minnesota | 27165 | 2890 | 22 |
2224394 | 2224394 | 2022-02-17 | Watonwan | Minnesota | 27165 | 2874 | 22 |
2221143 | 2221143 | 2022-02-16 | Watonwan | Minnesota | 27165 | 2864 | 22 |
2217892 | 2217892 | 2022-02-15 | Watonwan | Minnesota | 27165 | 2858 | 22 |
2214641 | 2214641 | 2022-02-14 | Watonwan | Minnesota | 27165 | 2837 | 22 |
2211389 | 2211389 | 2022-02-13 | Watonwan | Minnesota | 27165 | 2818 | 22 |
2208136 | 2208136 | 2022-02-12 | Watonwan | Minnesota | 27165 | 2818 | 22 |
2204883 | 2204883 | 2022-02-11 | Watonwan | Minnesota | 27165 | 2818 | 22 |
2201630 | 2201630 | 2022-02-10 | Watonwan | Minnesota | 27165 | 2806 | 22 |
2198376 | 2198376 | 2022-02-09 | Watonwan | Minnesota | 27165 | 2786 | 22 |
2195122 | 2195122 | 2022-02-08 | Watonwan | Minnesota | 27165 | 2774 | 22 |
2191868 | 2191868 | 2022-02-07 | Watonwan | Minnesota | 27165 | 2735 | 22 |
2188615 | 2188615 | 2022-02-06 | Watonwan | Minnesota | 27165 | 2720 | 22 |
2185362 | 2185362 | 2022-02-05 | Watonwan | Minnesota | 27165 | 2720 | 22 |
2182110 | 2182110 | 2022-02-04 | Watonwan | Minnesota | 27165 | 2720 | 22 |
2178858 | 2178858 | 2022-02-03 | Watonwan | Minnesota | 27165 | 2707 | 22 |
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);