ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 55059 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 |
---|---|---|---|---|---|---|---|
2502767 | 2502767 | 2022-05-13 | Kenosha | Wisconsin | 55059 | 45275 | 631 |
2499509 | 2499509 | 2022-05-12 | Kenosha | Wisconsin | 55059 | 45207 | 631 |
2496251 | 2496251 | 2022-05-11 | Kenosha | Wisconsin | 55059 | 45128 | 631 |
2492993 | 2492993 | 2022-05-10 | Kenosha | Wisconsin | 55059 | 45071 | 631 |
2489735 | 2489735 | 2022-05-09 | Kenosha | Wisconsin | 55059 | 45025 | 631 |
2486478 | 2486478 | 2022-05-08 | Kenosha | Wisconsin | 55059 | 44880 | 631 |
2483220 | 2483220 | 2022-05-07 | Kenosha | Wisconsin | 55059 | 44880 | 631 |
2479962 | 2479962 | 2022-05-06 | Kenosha | Wisconsin | 55059 | 44880 | 631 |
2476704 | 2476704 | 2022-05-05 | Kenosha | Wisconsin | 55059 | 44784 | 631 |
2473446 | 2473446 | 2022-05-04 | Kenosha | Wisconsin | 55059 | 44727 | 630 |
2470189 | 2470189 | 2022-05-03 | Kenosha | Wisconsin | 55059 | 44680 | 627 |
2466933 | 2466933 | 2022-05-02 | Kenosha | Wisconsin | 55059 | 44645 | 627 |
2463678 | 2463678 | 2022-05-01 | Kenosha | Wisconsin | 55059 | 44577 | 627 |
2460422 | 2460422 | 2022-04-30 | Kenosha | Wisconsin | 55059 | 44577 | 627 |
2457166 | 2457166 | 2022-04-29 | Kenosha | Wisconsin | 55059 | 44577 | 627 |
2453910 | 2453910 | 2022-04-28 | Kenosha | Wisconsin | 55059 | 44536 | 627 |
2450654 | 2450654 | 2022-04-27 | Kenosha | Wisconsin | 55059 | 44506 | 627 |
2447398 | 2447398 | 2022-04-26 | Kenosha | Wisconsin | 55059 | 44476 | 627 |
2444142 | 2444142 | 2022-04-25 | Kenosha | Wisconsin | 55059 | 44451 | 627 |
2440886 | 2440886 | 2022-04-24 | Kenosha | Wisconsin | 55059 | 44381 | 627 |
2437630 | 2437630 | 2022-04-23 | Kenosha | Wisconsin | 55059 | 44381 | 627 |
2434374 | 2434374 | 2022-04-22 | Kenosha | Wisconsin | 55059 | 44381 | 627 |
2431118 | 2431118 | 2022-04-21 | Kenosha | Wisconsin | 55059 | 44360 | 626 |
2427862 | 2427862 | 2022-04-20 | Kenosha | Wisconsin | 55059 | 44333 | 626 |
2424606 | 2424606 | 2022-04-19 | Kenosha | Wisconsin | 55059 | 44303 | 626 |
2421350 | 2421350 | 2022-04-18 | Kenosha | Wisconsin | 55059 | 44292 | 626 |
2418094 | 2418094 | 2022-04-17 | Kenosha | Wisconsin | 55059 | 44255 | 626 |
2414838 | 2414838 | 2022-04-16 | Kenosha | Wisconsin | 55059 | 44255 | 626 |
2411582 | 2411582 | 2022-04-15 | Kenosha | Wisconsin | 55059 | 44255 | 626 |
2408326 | 2408326 | 2022-04-14 | Kenosha | Wisconsin | 55059 | 44236 | 626 |
2405070 | 2405070 | 2022-04-13 | Kenosha | Wisconsin | 55059 | 44208 | 626 |
2401815 | 2401815 | 2022-04-12 | Kenosha | Wisconsin | 55059 | 44194 | 624 |
2398560 | 2398560 | 2022-04-11 | Kenosha | Wisconsin | 55059 | 44177 | 624 |
2395305 | 2395305 | 2022-04-10 | Kenosha | Wisconsin | 55059 | 44122 | 625 |
2392049 | 2392049 | 2022-04-09 | Kenosha | Wisconsin | 55059 | 44122 | 625 |
2388793 | 2388793 | 2022-04-08 | Kenosha | Wisconsin | 55059 | 44122 | 625 |
2385538 | 2385538 | 2022-04-07 | Kenosha | Wisconsin | 55059 | 44069 | 624 |
2382283 | 2382283 | 2022-04-06 | Kenosha | Wisconsin | 55059 | 44010 | 624 |
2379028 | 2379028 | 2022-04-05 | Kenosha | Wisconsin | 55059 | 43969 | 624 |
2375774 | 2375774 | 2022-04-04 | Kenosha | Wisconsin | 55059 | 43957 | 624 |
2372522 | 2372522 | 2022-04-03 | Kenosha | Wisconsin | 55059 | 43935 | 624 |
2369269 | 2369269 | 2022-04-02 | Kenosha | Wisconsin | 55059 | 43935 | 624 |
2366016 | 2366016 | 2022-04-01 | Kenosha | Wisconsin | 55059 | 43935 | 624 |
2362763 | 2362763 | 2022-03-31 | Kenosha | Wisconsin | 55059 | 43928 | 623 |
2359509 | 2359509 | 2022-03-30 | Kenosha | Wisconsin | 55059 | 43921 | 623 |
2356255 | 2356255 | 2022-03-29 | Kenosha | Wisconsin | 55059 | 43909 | 623 |
2353002 | 2353002 | 2022-03-28 | Kenosha | Wisconsin | 55059 | 43899 | 623 |
2349750 | 2349750 | 2022-03-27 | Kenosha | Wisconsin | 55059 | 43868 | 621 |
2346497 | 2346497 | 2022-03-26 | Kenosha | Wisconsin | 55059 | 43868 | 621 |
2343244 | 2343244 | 2022-03-25 | Kenosha | Wisconsin | 55059 | 43868 | 621 |
2339991 | 2339991 | 2022-03-24 | Kenosha | Wisconsin | 55059 | 43858 | 621 |
2336738 | 2336738 | 2022-03-23 | Kenosha | Wisconsin | 55059 | 43852 | 620 |
2333484 | 2333484 | 2022-03-22 | Kenosha | Wisconsin | 55059 | 43842 | 620 |
2330230 | 2330230 | 2022-03-21 | Kenosha | Wisconsin | 55059 | 43832 | 619 |
2326978 | 2326978 | 2022-03-20 | Kenosha | Wisconsin | 55059 | 43812 | 619 |
2323725 | 2323725 | 2022-03-19 | Kenosha | Wisconsin | 55059 | 43812 | 619 |
2320471 | 2320471 | 2022-03-18 | Kenosha | Wisconsin | 55059 | 43812 | 619 |
2317217 | 2317217 | 2022-03-17 | Kenosha | Wisconsin | 55059 | 43795 | 619 |
2313964 | 2313964 | 2022-03-16 | Kenosha | Wisconsin | 55059 | 43786 | 619 |
2310711 | 2310711 | 2022-03-15 | Kenosha | Wisconsin | 55059 | 43773 | 619 |
2307458 | 2307458 | 2022-03-14 | Kenosha | Wisconsin | 55059 | 43759 | 618 |
2304207 | 2304207 | 2022-03-13 | Kenosha | Wisconsin | 55059 | 43747 | 616 |
2300955 | 2300955 | 2022-03-12 | Kenosha | Wisconsin | 55059 | 43747 | 616 |
2297703 | 2297703 | 2022-03-11 | Kenosha | Wisconsin | 55059 | 43747 | 616 |
2294451 | 2294451 | 2022-03-10 | Kenosha | Wisconsin | 55059 | 43745 | 616 |
2291199 | 2291199 | 2022-03-09 | Kenosha | Wisconsin | 55059 | 43732 | 615 |
2287947 | 2287947 | 2022-03-08 | Kenosha | Wisconsin | 55059 | 43718 | 614 |
2284695 | 2284695 | 2022-03-07 | Kenosha | Wisconsin | 55059 | 43707 | 614 |
2281443 | 2281443 | 2022-03-06 | Kenosha | Wisconsin | 55059 | 43678 | 614 |
2278190 | 2278190 | 2022-03-05 | Kenosha | Wisconsin | 55059 | 43678 | 614 |
2274937 | 2274937 | 2022-03-04 | Kenosha | Wisconsin | 55059 | 43678 | 614 |
2271684 | 2271684 | 2022-03-03 | Kenosha | Wisconsin | 55059 | 43656 | 613 |
2268432 | 2268432 | 2022-03-02 | Kenosha | Wisconsin | 55059 | 43640 | 613 |
2265179 | 2265179 | 2022-03-01 | Kenosha | Wisconsin | 55059 | 43624 | 611 |
2261929 | 2261929 | 2022-02-28 | Kenosha | Wisconsin | 55059 | 43616 | 611 |
2258678 | 2258678 | 2022-02-27 | Kenosha | Wisconsin | 55059 | 43587 | 608 |
2255427 | 2255427 | 2022-02-26 | Kenosha | Wisconsin | 55059 | 43587 | 608 |
2252176 | 2252176 | 2022-02-25 | Kenosha | Wisconsin | 55059 | 43587 | 608 |
2248925 | 2248925 | 2022-02-24 | Kenosha | Wisconsin | 55059 | 43574 | 608 |
2245674 | 2245674 | 2022-02-23 | Kenosha | Wisconsin | 55059 | 43547 | 608 |
2242423 | 2242423 | 2022-02-22 | Kenosha | Wisconsin | 55059 | 43513 | 605 |
2239172 | 2239172 | 2022-02-21 | Kenosha | Wisconsin | 55059 | 43506 | 602 |
2235921 | 2235921 | 2022-02-20 | Kenosha | Wisconsin | 55059 | 43450 | 602 |
2232670 | 2232670 | 2022-02-19 | Kenosha | Wisconsin | 55059 | 43450 | 602 |
2229419 | 2229419 | 2022-02-18 | Kenosha | Wisconsin | 55059 | 43450 | 602 |
2226168 | 2226168 | 2022-02-17 | Kenosha | Wisconsin | 55059 | 43424 | 600 |
2222917 | 2222917 | 2022-02-16 | Kenosha | Wisconsin | 55059 | 43379 | 598 |
2219666 | 2219666 | 2022-02-15 | Kenosha | Wisconsin | 55059 | 43346 | 597 |
2216416 | 2216416 | 2022-02-14 | Kenosha | Wisconsin | 55059 | 43315 | 596 |
2213165 | 2213165 | 2022-02-13 | Kenosha | Wisconsin | 55059 | 43235 | 595 |
2209912 | 2209912 | 2022-02-12 | Kenosha | Wisconsin | 55059 | 43235 | 595 |
2206659 | 2206659 | 2022-02-11 | Kenosha | Wisconsin | 55059 | 43235 | 595 |
2203406 | 2203406 | 2022-02-10 | Kenosha | Wisconsin | 55059 | 43185 | 593 |
2200152 | 2200152 | 2022-02-09 | Kenosha | Wisconsin | 55059 | 43116 | 590 |
2196898 | 2196898 | 2022-02-08 | Kenosha | Wisconsin | 55059 | 43076 | 588 |
2193643 | 2193643 | 2022-02-07 | Kenosha | Wisconsin | 55059 | 43036 | 582 |
2190390 | 2190390 | 2022-02-06 | Kenosha | Wisconsin | 55059 | 42866 | 582 |
2187137 | 2187137 | 2022-02-05 | Kenosha | Wisconsin | 55059 | 42866 | 582 |
2183884 | 2183884 | 2022-02-04 | Kenosha | Wisconsin | 55059 | 42866 | 582 |
2180632 | 2180632 | 2022-02-03 | Kenosha | Wisconsin | 55059 | 42780 | 580 |
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);