ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 55065 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 |
---|---|---|---|---|---|---|---|
2502770 | 2502770 | 2022-05-13 | Lafayette | Wisconsin | 55065 | 3731 | 26 |
2499512 | 2499512 | 2022-05-12 | Lafayette | Wisconsin | 55065 | 3727 | 26 |
2496254 | 2496254 | 2022-05-11 | Lafayette | Wisconsin | 55065 | 3720 | 26 |
2492996 | 2492996 | 2022-05-10 | Lafayette | Wisconsin | 55065 | 3714 | 26 |
2489738 | 2489738 | 2022-05-09 | Lafayette | Wisconsin | 55065 | 3707 | 25 |
2486481 | 2486481 | 2022-05-08 | Lafayette | Wisconsin | 55065 | 3702 | 25 |
2483223 | 2483223 | 2022-05-07 | Lafayette | Wisconsin | 55065 | 3702 | 25 |
2479965 | 2479965 | 2022-05-06 | Lafayette | Wisconsin | 55065 | 3702 | 25 |
2476707 | 2476707 | 2022-05-05 | Lafayette | Wisconsin | 55065 | 3701 | 25 |
2473449 | 2473449 | 2022-05-04 | Lafayette | Wisconsin | 55065 | 3699 | 25 |
2470192 | 2470192 | 2022-05-03 | Lafayette | Wisconsin | 55065 | 3698 | 24 |
2466936 | 2466936 | 2022-05-02 | Lafayette | Wisconsin | 55065 | 3697 | 24 |
2463681 | 2463681 | 2022-05-01 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2460425 | 2460425 | 2022-04-30 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2457169 | 2457169 | 2022-04-29 | Lafayette | Wisconsin | 55065 | 3688 | 24 |
2453913 | 2453913 | 2022-04-28 | Lafayette | Wisconsin | 55065 | 3686 | 24 |
2450657 | 2450657 | 2022-04-27 | Lafayette | Wisconsin | 55065 | 3682 | 24 |
2447401 | 2447401 | 2022-04-26 | Lafayette | Wisconsin | 55065 | 3682 | 24 |
2444145 | 2444145 | 2022-04-25 | Lafayette | Wisconsin | 55065 | 3681 | 24 |
2440889 | 2440889 | 2022-04-24 | Lafayette | Wisconsin | 55065 | 3673 | 24 |
2437633 | 2437633 | 2022-04-23 | Lafayette | Wisconsin | 55065 | 3673 | 24 |
2434377 | 2434377 | 2022-04-22 | Lafayette | Wisconsin | 55065 | 3673 | 24 |
2431121 | 2431121 | 2022-04-21 | Lafayette | Wisconsin | 55065 | 3672 | 24 |
2427865 | 2427865 | 2022-04-20 | Lafayette | Wisconsin | 55065 | 3665 | 24 |
2424609 | 2424609 | 2022-04-19 | Lafayette | Wisconsin | 55065 | 3661 | 24 |
2421353 | 2421353 | 2022-04-18 | Lafayette | Wisconsin | 55065 | 3660 | 24 |
2418097 | 2418097 | 2022-04-17 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2414841 | 2414841 | 2022-04-16 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2411585 | 2411585 | 2022-04-15 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2408329 | 2408329 | 2022-04-14 | Lafayette | Wisconsin | 55065 | 3659 | 24 |
2405073 | 2405073 | 2022-04-13 | Lafayette | Wisconsin | 55065 | 3656 | 24 |
2401818 | 2401818 | 2022-04-12 | Lafayette | Wisconsin | 55065 | 3640 | 24 |
2398563 | 2398563 | 2022-04-11 | Lafayette | Wisconsin | 55065 | 3639 | 22 |
2395308 | 2395308 | 2022-04-10 | Lafayette | Wisconsin | 55065 | 3637 | 22 |
2392052 | 2392052 | 2022-04-09 | Lafayette | Wisconsin | 55065 | 3637 | 22 |
2388796 | 2388796 | 2022-04-08 | Lafayette | Wisconsin | 55065 | 3637 | 22 |
2385541 | 2385541 | 2022-04-07 | Lafayette | Wisconsin | 55065 | 3637 | 22 |
2382286 | 2382286 | 2022-04-06 | Lafayette | Wisconsin | 55065 | 3632 | 22 |
2379031 | 2379031 | 2022-04-05 | Lafayette | Wisconsin | 55065 | 3632 | 22 |
2375777 | 2375777 | 2022-04-04 | Lafayette | Wisconsin | 55065 | 3631 | 22 |
2372525 | 2372525 | 2022-04-03 | Lafayette | Wisconsin | 55065 | 3630 | 22 |
2369272 | 2369272 | 2022-04-02 | Lafayette | Wisconsin | 55065 | 3630 | 22 |
2366019 | 2366019 | 2022-04-01 | Lafayette | Wisconsin | 55065 | 3630 | 22 |
2362766 | 2362766 | 2022-03-31 | Lafayette | Wisconsin | 55065 | 3630 | 22 |
2359512 | 2359512 | 2022-03-30 | Lafayette | Wisconsin | 55065 | 3630 | 22 |
2356258 | 2356258 | 2022-03-29 | Lafayette | Wisconsin | 55065 | 3628 | 22 |
2353005 | 2353005 | 2022-03-28 | Lafayette | Wisconsin | 55065 | 3626 | 22 |
2349753 | 2349753 | 2022-03-27 | Lafayette | Wisconsin | 55065 | 3625 | 22 |
2346500 | 2346500 | 2022-03-26 | Lafayette | Wisconsin | 55065 | 3625 | 22 |
2343247 | 2343247 | 2022-03-25 | Lafayette | Wisconsin | 55065 | 3625 | 22 |
2339994 | 2339994 | 2022-03-24 | Lafayette | Wisconsin | 55065 | 3623 | 22 |
2336741 | 2336741 | 2022-03-23 | Lafayette | Wisconsin | 55065 | 3623 | 22 |
2333487 | 2333487 | 2022-03-22 | Lafayette | Wisconsin | 55065 | 3622 | 22 |
2330233 | 2330233 | 2022-03-21 | Lafayette | Wisconsin | 55065 | 3622 | 22 |
2326981 | 2326981 | 2022-03-20 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2323728 | 2323728 | 2022-03-19 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2320474 | 2320474 | 2022-03-18 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2317220 | 2317220 | 2022-03-17 | Lafayette | Wisconsin | 55065 | 3620 | 22 |
2313967 | 2313967 | 2022-03-16 | Lafayette | Wisconsin | 55065 | 3619 | 22 |
2310714 | 2310714 | 2022-03-15 | Lafayette | Wisconsin | 55065 | 3618 | 22 |
2307461 | 2307461 | 2022-03-14 | Lafayette | Wisconsin | 55065 | 3615 | 22 |
2304210 | 2304210 | 2022-03-13 | Lafayette | Wisconsin | 55065 | 3613 | 22 |
2300958 | 2300958 | 2022-03-12 | Lafayette | Wisconsin | 55065 | 3613 | 22 |
2297706 | 2297706 | 2022-03-11 | Lafayette | Wisconsin | 55065 | 3613 | 22 |
2294454 | 2294454 | 2022-03-10 | Lafayette | Wisconsin | 55065 | 3612 | 22 |
2291202 | 2291202 | 2022-03-09 | Lafayette | Wisconsin | 55065 | 3610 | 22 |
2287950 | 2287950 | 2022-03-08 | Lafayette | Wisconsin | 55065 | 3608 | 22 |
2284698 | 2284698 | 2022-03-07 | Lafayette | Wisconsin | 55065 | 3607 | 22 |
2281446 | 2281446 | 2022-03-06 | Lafayette | Wisconsin | 55065 | 3603 | 22 |
2278193 | 2278193 | 2022-03-05 | Lafayette | Wisconsin | 55065 | 3603 | 22 |
2274940 | 2274940 | 2022-03-04 | Lafayette | Wisconsin | 55065 | 3603 | 22 |
2271687 | 2271687 | 2022-03-03 | Lafayette | Wisconsin | 55065 | 3602 | 22 |
2268435 | 2268435 | 2022-03-02 | Lafayette | Wisconsin | 55065 | 3601 | 22 |
2265182 | 2265182 | 2022-03-01 | Lafayette | Wisconsin | 55065 | 3600 | 22 |
2261932 | 2261932 | 2022-02-28 | Lafayette | Wisconsin | 55065 | 3599 | 22 |
2258681 | 2258681 | 2022-02-27 | Lafayette | Wisconsin | 55065 | 3596 | 22 |
2255430 | 2255430 | 2022-02-26 | Lafayette | Wisconsin | 55065 | 3596 | 22 |
2252179 | 2252179 | 2022-02-25 | Lafayette | Wisconsin | 55065 | 3596 | 22 |
2248928 | 2248928 | 2022-02-24 | Lafayette | Wisconsin | 55065 | 3595 | 22 |
2245677 | 2245677 | 2022-02-23 | Lafayette | Wisconsin | 55065 | 3590 | 21 |
2242426 | 2242426 | 2022-02-22 | Lafayette | Wisconsin | 55065 | 3583 | 21 |
2239175 | 2239175 | 2022-02-21 | Lafayette | Wisconsin | 55065 | 3580 | 21 |
2235924 | 2235924 | 2022-02-20 | Lafayette | Wisconsin | 55065 | 3576 | 21 |
2232673 | 2232673 | 2022-02-19 | Lafayette | Wisconsin | 55065 | 3576 | 21 |
2229422 | 2229422 | 2022-02-18 | Lafayette | Wisconsin | 55065 | 3576 | 21 |
2226171 | 2226171 | 2022-02-17 | Lafayette | Wisconsin | 55065 | 3568 | 21 |
2222920 | 2222920 | 2022-02-16 | Lafayette | Wisconsin | 55065 | 3567 | 21 |
2219669 | 2219669 | 2022-02-15 | Lafayette | Wisconsin | 55065 | 3563 | 21 |
2216419 | 2216419 | 2022-02-14 | Lafayette | Wisconsin | 55065 | 3557 | 21 |
2213168 | 2213168 | 2022-02-13 | Lafayette | Wisconsin | 55065 | 3547 | 21 |
2209915 | 2209915 | 2022-02-12 | Lafayette | Wisconsin | 55065 | 3547 | 21 |
2206662 | 2206662 | 2022-02-11 | Lafayette | Wisconsin | 55065 | 3547 | 21 |
2203409 | 2203409 | 2022-02-10 | Lafayette | Wisconsin | 55065 | 3541 | 21 |
2200155 | 2200155 | 2022-02-09 | Lafayette | Wisconsin | 55065 | 3534 | 21 |
2196901 | 2196901 | 2022-02-08 | Lafayette | Wisconsin | 55065 | 3520 | 21 |
2193646 | 2193646 | 2022-02-07 | Lafayette | Wisconsin | 55065 | 3510 | 21 |
2190393 | 2190393 | 2022-02-06 | Lafayette | Wisconsin | 55065 | 3500 | 21 |
2187140 | 2187140 | 2022-02-05 | Lafayette | Wisconsin | 55065 | 3500 | 21 |
2183887 | 2183887 | 2022-02-04 | Lafayette | Wisconsin | 55065 | 3500 | 21 |
2180635 | 2180635 | 2022-02-03 | Lafayette | Wisconsin | 55065 | 3487 | 20 |
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);