ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Door", fips = 55029 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502752 | 2502752 | 2022-05-13 | Door | Wisconsin | 55029 | 7097 | 71 |
2499494 | 2499494 | 2022-05-12 | Door | Wisconsin | 55029 | 7085 | 71 |
2496236 | 2496236 | 2022-05-11 | Door | Wisconsin | 55029 | 7072 | 71 |
2492978 | 2492978 | 2022-05-10 | Door | Wisconsin | 55029 | 7064 | 71 |
2489720 | 2489720 | 2022-05-09 | Door | Wisconsin | 55029 | 7055 | 71 |
2486463 | 2486463 | 2022-05-08 | Door | Wisconsin | 55029 | 7042 | 71 |
2483205 | 2483205 | 2022-05-07 | Door | Wisconsin | 55029 | 7042 | 71 |
2479947 | 2479947 | 2022-05-06 | Door | Wisconsin | 55029 | 7042 | 71 |
2476689 | 2476689 | 2022-05-05 | Door | Wisconsin | 55029 | 7029 | 71 |
2473431 | 2473431 | 2022-05-04 | Door | Wisconsin | 55029 | 7021 | 71 |
2470174 | 2470174 | 2022-05-03 | Door | Wisconsin | 55029 | 7011 | 71 |
2466918 | 2466918 | 2022-05-02 | Door | Wisconsin | 55029 | 7010 | 71 |
2463663 | 2463663 | 2022-05-01 | Door | Wisconsin | 55029 | 6999 | 71 |
2460407 | 2460407 | 2022-04-30 | Door | Wisconsin | 55029 | 6999 | 71 |
2457151 | 2457151 | 2022-04-29 | Door | Wisconsin | 55029 | 6999 | 71 |
2453895 | 2453895 | 2022-04-28 | Door | Wisconsin | 55029 | 6989 | 71 |
2450639 | 2450639 | 2022-04-27 | Door | Wisconsin | 55029 | 6984 | 71 |
2447383 | 2447383 | 2022-04-26 | Door | Wisconsin | 55029 | 6983 | 71 |
2444127 | 2444127 | 2022-04-25 | Door | Wisconsin | 55029 | 6980 | 71 |
2440871 | 2440871 | 2022-04-24 | Door | Wisconsin | 55029 | 6975 | 71 |
2437615 | 2437615 | 2022-04-23 | Door | Wisconsin | 55029 | 6975 | 71 |
2434359 | 2434359 | 2022-04-22 | Door | Wisconsin | 55029 | 6975 | 71 |
2431103 | 2431103 | 2022-04-21 | Door | Wisconsin | 55029 | 6977 | 71 |
2427847 | 2427847 | 2022-04-20 | Door | Wisconsin | 55029 | 6975 | 71 |
2424591 | 2424591 | 2022-04-19 | Door | Wisconsin | 55029 | 6974 | 71 |
2421335 | 2421335 | 2022-04-18 | Door | Wisconsin | 55029 | 6972 | 71 |
2418079 | 2418079 | 2022-04-17 | Door | Wisconsin | 55029 | 6967 | 71 |
2414823 | 2414823 | 2022-04-16 | Door | Wisconsin | 55029 | 6967 | 71 |
2411567 | 2411567 | 2022-04-15 | Door | Wisconsin | 55029 | 6967 | 71 |
2408311 | 2408311 | 2022-04-14 | Door | Wisconsin | 55029 | 6964 | 71 |
2405055 | 2405055 | 2022-04-13 | Door | Wisconsin | 55029 | 6961 | 71 |
2401800 | 2401800 | 2022-04-12 | Door | Wisconsin | 55029 | 6960 | 71 |
2398545 | 2398545 | 2022-04-11 | Door | Wisconsin | 55029 | 6957 | 71 |
2395290 | 2395290 | 2022-04-10 | Door | Wisconsin | 55029 | 6953 | 71 |
2392034 | 2392034 | 2022-04-09 | Door | Wisconsin | 55029 | 6953 | 71 |
2388778 | 2388778 | 2022-04-08 | Door | Wisconsin | 55029 | 6953 | 71 |
2385523 | 2385523 | 2022-04-07 | Door | Wisconsin | 55029 | 6950 | 71 |
2382268 | 2382268 | 2022-04-06 | Door | Wisconsin | 55029 | 6950 | 71 |
2379013 | 2379013 | 2022-04-05 | Door | Wisconsin | 55029 | 6949 | 71 |
2375759 | 2375759 | 2022-04-04 | Door | Wisconsin | 55029 | 6948 | 71 |
2372507 | 2372507 | 2022-04-03 | Door | Wisconsin | 55029 | 6945 | 71 |
2369254 | 2369254 | 2022-04-02 | Door | Wisconsin | 55029 | 6945 | 71 |
2366001 | 2366001 | 2022-04-01 | Door | Wisconsin | 55029 | 6945 | 71 |
2362748 | 2362748 | 2022-03-31 | Door | Wisconsin | 55029 | 6943 | 71 |
2359494 | 2359494 | 2022-03-30 | Door | Wisconsin | 55029 | 6941 | 71 |
2356240 | 2356240 | 2022-03-29 | Door | Wisconsin | 55029 | 6935 | 71 |
2352987 | 2352987 | 2022-03-28 | Door | Wisconsin | 55029 | 6935 | 71 |
2349735 | 2349735 | 2022-03-27 | Door | Wisconsin | 55029 | 6933 | 69 |
2346482 | 2346482 | 2022-03-26 | Door | Wisconsin | 55029 | 6933 | 69 |
2343229 | 2343229 | 2022-03-25 | Door | Wisconsin | 55029 | 6933 | 69 |
2339976 | 2339976 | 2022-03-24 | Door | Wisconsin | 55029 | 6933 | 69 |
2336723 | 2336723 | 2022-03-23 | Door | Wisconsin | 55029 | 6931 | 69 |
2333469 | 2333469 | 2022-03-22 | Door | Wisconsin | 55029 | 6930 | 69 |
2330215 | 2330215 | 2022-03-21 | Door | Wisconsin | 55029 | 6929 | 69 |
2326963 | 2326963 | 2022-03-20 | Door | Wisconsin | 55029 | 6928 | 69 |
2323710 | 2323710 | 2022-03-19 | Door | Wisconsin | 55029 | 6928 | 69 |
2320456 | 2320456 | 2022-03-18 | Door | Wisconsin | 55029 | 6928 | 69 |
2317202 | 2317202 | 2022-03-17 | Door | Wisconsin | 55029 | 6928 | 69 |
2313949 | 2313949 | 2022-03-16 | Door | Wisconsin | 55029 | 6927 | 69 |
2310696 | 2310696 | 2022-03-15 | Door | Wisconsin | 55029 | 6926 | 68 |
2307443 | 2307443 | 2022-03-14 | Door | Wisconsin | 55029 | 6924 | 67 |
2304192 | 2304192 | 2022-03-13 | Door | Wisconsin | 55029 | 6924 | 65 |
2300940 | 2300940 | 2022-03-12 | Door | Wisconsin | 55029 | 6924 | 65 |
2297688 | 2297688 | 2022-03-11 | Door | Wisconsin | 55029 | 6924 | 65 |
2294436 | 2294436 | 2022-03-10 | Door | Wisconsin | 55029 | 6923 | 64 |
2291184 | 2291184 | 2022-03-09 | Door | Wisconsin | 55029 | 6920 | 63 |
2287932 | 2287932 | 2022-03-08 | Door | Wisconsin | 55029 | 6918 | 62 |
2284680 | 2284680 | 2022-03-07 | Door | Wisconsin | 55029 | 6916 | 60 |
2281428 | 2281428 | 2022-03-06 | Door | Wisconsin | 55029 | 6916 | 60 |
2278175 | 2278175 | 2022-03-05 | Door | Wisconsin | 55029 | 6916 | 60 |
2274922 | 2274922 | 2022-03-04 | Door | Wisconsin | 55029 | 6916 | 60 |
2271669 | 2271669 | 2022-03-03 | Door | Wisconsin | 55029 | 6913 | 60 |
2268417 | 2268417 | 2022-03-02 | Door | Wisconsin | 55029 | 6911 | 59 |
2265164 | 2265164 | 2022-03-01 | Door | Wisconsin | 55029 | 6911 | 58 |
2261914 | 2261914 | 2022-02-28 | Door | Wisconsin | 55029 | 6907 | 58 |
2258663 | 2258663 | 2022-02-27 | Door | Wisconsin | 55029 | 6903 | 58 |
2255412 | 2255412 | 2022-02-26 | Door | Wisconsin | 55029 | 6903 | 58 |
2252161 | 2252161 | 2022-02-25 | Door | Wisconsin | 55029 | 6903 | 58 |
2248910 | 2248910 | 2022-02-24 | Door | Wisconsin | 55029 | 6901 | 58 |
2245659 | 2245659 | 2022-02-23 | Door | Wisconsin | 55029 | 6899 | 58 |
2242408 | 2242408 | 2022-02-22 | Door | Wisconsin | 55029 | 6895 | 58 |
2239157 | 2239157 | 2022-02-21 | Door | Wisconsin | 55029 | 6895 | 58 |
2235906 | 2235906 | 2022-02-20 | Door | Wisconsin | 55029 | 6889 | 57 |
2232655 | 2232655 | 2022-02-19 | Door | Wisconsin | 55029 | 6889 | 57 |
2229404 | 2229404 | 2022-02-18 | Door | Wisconsin | 55029 | 6889 | 57 |
2226153 | 2226153 | 2022-02-17 | Door | Wisconsin | 55029 | 6883 | 57 |
2222902 | 2222902 | 2022-02-16 | Door | Wisconsin | 55029 | 6877 | 57 |
2219651 | 2219651 | 2022-02-15 | Door | Wisconsin | 55029 | 6874 | 57 |
2216401 | 2216401 | 2022-02-14 | Door | Wisconsin | 55029 | 6869 | 57 |
2213150 | 2213150 | 2022-02-13 | Door | Wisconsin | 55029 | 6854 | 57 |
2209897 | 2209897 | 2022-02-12 | Door | Wisconsin | 55029 | 6854 | 57 |
2206644 | 2206644 | 2022-02-11 | Door | Wisconsin | 55029 | 6854 | 57 |
2203391 | 2203391 | 2022-02-10 | Door | Wisconsin | 55029 | 6843 | 57 |
2200137 | 2200137 | 2022-02-09 | Door | Wisconsin | 55029 | 6837 | 56 |
2196883 | 2196883 | 2022-02-08 | Door | Wisconsin | 55029 | 6832 | 56 |
2193628 | 2193628 | 2022-02-07 | Door | Wisconsin | 55029 | 6818 | 55 |
2190375 | 2190375 | 2022-02-06 | Door | Wisconsin | 55029 | 6794 | 55 |
2187122 | 2187122 | 2022-02-05 | Door | Wisconsin | 55029 | 6794 | 55 |
2183869 | 2183869 | 2022-02-04 | Door | Wisconsin | 55029 | 6794 | 55 |
2180617 | 2180617 | 2022-02-03 | Door | Wisconsin | 55029 | 6779 | 55 |
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);