ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

754 rows where county = "Chippewa", fips = 27023 and state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Minnesota · 754 ✖

fips 1

  • 27023 · 754 ✖

county 1

  • Chippewa · 754 ✖
Link rowid date ▲ county state fips cases deaths
2500916 2500916 2022-05-13 Chippewa Minnesota 27023 3128 48
2497658 2497658 2022-05-12 Chippewa Minnesota 27023 3119 48
2494400 2494400 2022-05-11 Chippewa Minnesota 27023 3115 48
2491142 2491142 2022-05-10 Chippewa Minnesota 27023 3112 48
2487885 2487885 2022-05-09 Chippewa Minnesota 27023 3105 48
2484627 2484627 2022-05-08 Chippewa Minnesota 27023 3102 48
2481369 2481369 2022-05-07 Chippewa Minnesota 27023 3102 48
2478111 2478111 2022-05-06 Chippewa Minnesota 27023 3102 48
2474853 2474853 2022-05-05 Chippewa Minnesota 27023 3098 48
2471596 2471596 2022-05-04 Chippewa Minnesota 27023 3097 48
2468340 2468340 2022-05-03 Chippewa Minnesota 27023 3094 48
2465085 2465085 2022-05-02 Chippewa Minnesota 27023 3093 48
2461829 2461829 2022-05-01 Chippewa Minnesota 27023 3092 48
2458573 2458573 2022-04-30 Chippewa Minnesota 27023 3092 48
2455317 2455317 2022-04-29 Chippewa Minnesota 27023 3092 48
2452061 2452061 2022-04-28 Chippewa Minnesota 27023 3091 48
2448805 2448805 2022-04-27 Chippewa Minnesota 27023 3090 48
2445549 2445549 2022-04-26 Chippewa Minnesota 27023 3085 48
2442293 2442293 2022-04-25 Chippewa Minnesota 27023 3083 48
2439037 2439037 2022-04-24 Chippewa Minnesota 27023 3083 48
2435781 2435781 2022-04-23 Chippewa Minnesota 27023 3083 48
2432525 2432525 2022-04-22 Chippewa Minnesota 27023 3083 48
2429269 2429269 2022-04-21 Chippewa Minnesota 27023 3081 48
2426013 2426013 2022-04-20 Chippewa Minnesota 27023 3080 48
2422757 2422757 2022-04-19 Chippewa Minnesota 27023 3080 48
2419501 2419501 2022-04-18 Chippewa Minnesota 27023 3077 48
2416245 2416245 2022-04-17 Chippewa Minnesota 27023 3077 48
2412989 2412989 2022-04-16 Chippewa Minnesota 27023 3077 48
2409733 2409733 2022-04-15 Chippewa Minnesota 27023 3077 48
2406477 2406477 2022-04-14 Chippewa Minnesota 27023 3077 48
2403221 2403221 2022-04-13 Chippewa Minnesota 27023 3073 48
2399967 2399967 2022-04-12 Chippewa Minnesota 27023 3073 48
2396711 2396711 2022-04-11 Chippewa Minnesota 27023 3073 48
2393456 2393456 2022-04-10 Chippewa Minnesota 27023 3071 48
2390200 2390200 2022-04-09 Chippewa Minnesota 27023 3071 48
2386944 2386944 2022-04-08 Chippewa Minnesota 27023 3071 48
2383689 2383689 2022-04-07 Chippewa Minnesota 27023 3071 48
2380434 2380434 2022-04-06 Chippewa Minnesota 27023 3069 48
2377179 2377179 2022-04-05 Chippewa Minnesota 27023 3068 48
2373927 2373927 2022-04-04 Chippewa Minnesota 27023 3067 48
2370674 2370674 2022-04-03 Chippewa Minnesota 27023 3067 48
2367421 2367421 2022-04-02 Chippewa Minnesota 27023 3067 48
2364168 2364168 2022-04-01 Chippewa Minnesota 27023 3067 48
2360914 2360914 2022-03-31 Chippewa Minnesota 27023 3067 48
2357660 2357660 2022-03-30 Chippewa Minnesota 27023 3067 48
2354407 2354407 2022-03-29 Chippewa Minnesota 27023 3067 48
2351155 2351155 2022-03-28 Chippewa Minnesota 27023 3067 48
2347902 2347902 2022-03-27 Chippewa Minnesota 27023 3067 48
2344649 2344649 2022-03-26 Chippewa Minnesota 27023 3067 48
2341396 2341396 2022-03-25 Chippewa Minnesota 27023 3067 48
2338143 2338143 2022-03-24 Chippewa Minnesota 27023 3068 48
2334889 2334889 2022-03-23 Chippewa Minnesota 27023 3067 47
2331635 2331635 2022-03-22 Chippewa Minnesota 27023 3067 47
2328383 2328383 2022-03-21 Chippewa Minnesota 27023 3066 47
2325130 2325130 2022-03-20 Chippewa Minnesota 27023 3066 47
2321876 2321876 2022-03-19 Chippewa Minnesota 27023 3066 47
2318622 2318622 2022-03-18 Chippewa Minnesota 27023 3066 47
2315369 2315369 2022-03-17 Chippewa Minnesota 27023 3066 47
2312116 2312116 2022-03-16 Chippewa Minnesota 27023 3066 47
2308863 2308863 2022-03-15 Chippewa Minnesota 27023 3065 47
2305612 2305612 2022-03-14 Chippewa Minnesota 27023 3065 47
2302360 2302360 2022-03-13 Chippewa Minnesota 27023 3064 47
2299108 2299108 2022-03-12 Chippewa Minnesota 27023 3064 47
2295856 2295856 2022-03-11 Chippewa Minnesota 27023 3064 47
2292604 2292604 2022-03-10 Chippewa Minnesota 27023 3062 47
2289352 2289352 2022-03-09 Chippewa Minnesota 27023 3057 47
2286101 2286101 2022-03-08 Chippewa Minnesota 27023 3054 47
2282849 2282849 2022-03-07 Chippewa Minnesota 27023 3046 47
2279596 2279596 2022-03-06 Chippewa Minnesota 27023 3044 47
2276343 2276343 2022-03-05 Chippewa Minnesota 27023 3044 47
2273090 2273090 2022-03-04 Chippewa Minnesota 27023 3044 47
2269838 2269838 2022-03-03 Chippewa Minnesota 27023 3042 47
2266585 2266585 2022-03-02 Chippewa Minnesota 27023 3037 47
2263334 2263334 2022-03-01 Chippewa Minnesota 27023 3033 47
2260083 2260083 2022-02-28 Chippewa Minnesota 27023 3029 47
2256832 2256832 2022-02-27 Chippewa Minnesota 27023 3028 47
2253581 2253581 2022-02-26 Chippewa Minnesota 27023 3028 47
2250330 2250330 2022-02-25 Chippewa Minnesota 27023 3028 47
2247079 2247079 2022-02-24 Chippewa Minnesota 27023 3022 47
2243828 2243828 2022-02-23 Chippewa Minnesota 27023 3018 47
2240577 2240577 2022-02-22 Chippewa Minnesota 27023 3002 47
2237326 2237326 2022-02-21 Chippewa Minnesota 27023 3000 47
2234075 2234075 2022-02-20 Chippewa Minnesota 27023 3000 47
2230824 2230824 2022-02-19 Chippewa Minnesota 27023 3000 47
2227573 2227573 2022-02-18 Chippewa Minnesota 27023 3000 47
2224322 2224322 2022-02-17 Chippewa Minnesota 27023 2982 47
2221071 2221071 2022-02-16 Chippewa Minnesota 27023 2979 47
2217820 2217820 2022-02-15 Chippewa Minnesota 27023 2972 47
2214569 2214569 2022-02-14 Chippewa Minnesota 27023 2952 46
2211317 2211317 2022-02-13 Chippewa Minnesota 27023 2939 46
2208064 2208064 2022-02-12 Chippewa Minnesota 27023 2939 46
2204811 2204811 2022-02-11 Chippewa Minnesota 27023 2939 46
2201558 2201558 2022-02-10 Chippewa Minnesota 27023 2929 46
2198304 2198304 2022-02-09 Chippewa Minnesota 27023 2925 46
2195050 2195050 2022-02-08 Chippewa Minnesota 27023 2912 46
2191796 2191796 2022-02-07 Chippewa Minnesota 27023 2888 46
2188543 2188543 2022-02-06 Chippewa Minnesota 27023 2876 46
2185290 2185290 2022-02-05 Chippewa Minnesota 27023 2876 46
2182038 2182038 2022-02-04 Chippewa Minnesota 27023 2876 46
2178786 2178786 2022-02-03 Chippewa Minnesota 27023 2860 46

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);