ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
532 rows where deaths = 22 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Crawford 62
- Burnett 61
- Green Lake 58
- Lafayette 47
- Green 43
- Sawyer 24
- Bayfield 23
- Richland 20
- Dane 16
- Washburn 16
- St. Croix 14
- Juneau 12
- Jackson 11
- Forest 9
- Price 9
- Winnebago 9
- Portage 7
- Vernon 7
- Dunn 6
- Trempealeau 6
- Calumet 5
- Door 5
- Kenosha 5
- Kewaunee 5
- Ashland 4
- Oconto 4
- Polk 4
- Langlade 3
- Marinette 3
- Racine 3
- …
state 1
- Wisconsin · 532 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
2086324 | 2086324 | 2022-01-05 | Price | Wisconsin | 55099 | 2613 | 22 |
2083072 | 2083072 | 2022-01-04 | Price | Wisconsin | 55099 | 2586 | 22 |
2079820 | 2079820 | 2022-01-03 | Price | Wisconsin | 55099 | 2579 | 22 |
2076568 | 2076568 | 2022-01-02 | Price | Wisconsin | 55099 | 2560 | 22 |
2073317 | 2073317 | 2022-01-01 | Price | Wisconsin | 55099 | 2560 | 22 |
2070066 | 2070066 | 2021-12-31 | Price | Wisconsin | 55099 | 2560 | 22 |
2066815 | 2066815 | 2021-12-30 | Price | Wisconsin | 55099 | 2552 | 22 |
2063565 | 2063565 | 2021-12-29 | Price | Wisconsin | 55099 | 2532 | 22 |
2060315 | 2060315 | 2021-12-28 | Price | Wisconsin | 55099 | 2521 | 22 |
1975758 | 1975758 | 2021-12-02 | Ashland | Wisconsin | 55003 | 2142 | 22 |
1972509 | 1972509 | 2021-12-01 | Ashland | Wisconsin | 55003 | 2125 | 22 |
1969259 | 1969259 | 2021-11-30 | Ashland | Wisconsin | 55003 | 2097 | 22 |
1966009 | 1966009 | 2021-11-29 | Ashland | Wisconsin | 55003 | 2091 | 22 |
1904262 | 1904262 | 2021-11-10 | Crawford | Wisconsin | 55023 | 2451 | 22 |
1901012 | 1901012 | 2021-11-09 | Crawford | Wisconsin | 55023 | 2434 | 22 |
1897762 | 1897762 | 2021-11-08 | Crawford | Wisconsin | 55023 | 2427 | 22 |
1894512 | 1894512 | 2021-11-07 | Crawford | Wisconsin | 55023 | 2411 | 22 |
1891262 | 1891262 | 2021-11-06 | Crawford | Wisconsin | 55023 | 2411 | 22 |
1888012 | 1888012 | 2021-11-05 | Crawford | Wisconsin | 55023 | 2411 | 22 |
1884762 | 1884762 | 2021-11-04 | Crawford | Wisconsin | 55023 | 2405 | 22 |
1881513 | 1881513 | 2021-11-03 | Crawford | Wisconsin | 55023 | 2382 | 22 |
1878264 | 1878264 | 2021-11-02 | Crawford | Wisconsin | 55023 | 2376 | 22 |
1875015 | 1875015 | 2021-11-01 | Crawford | Wisconsin | 55023 | 2367 | 22 |
1871766 | 1871766 | 2021-10-31 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1868517 | 1868517 | 2021-10-30 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1865268 | 1865268 | 2021-10-29 | Crawford | Wisconsin | 55023 | 2345 | 22 |
1862019 | 1862019 | 2021-10-28 | Crawford | Wisconsin | 55023 | 2328 | 22 |
1858770 | 1858770 | 2021-10-27 | Crawford | Wisconsin | 55023 | 2326 | 22 |
1855521 | 1855521 | 2021-10-26 | Crawford | Wisconsin | 55023 | 2315 | 22 |
1852272 | 1852272 | 2021-10-25 | Crawford | Wisconsin | 55023 | 2310 | 22 |
1849022 | 1849022 | 2021-10-24 | Crawford | Wisconsin | 55023 | 2285 | 22 |
1845772 | 1845772 | 2021-10-23 | Crawford | Wisconsin | 55023 | 2285 | 22 |
1842522 | 1842522 | 2021-10-22 | Crawford | Wisconsin | 55023 | 2285 | 22 |
1839273 | 1839273 | 2021-10-21 | Crawford | Wisconsin | 55023 | 2276 | 22 |
1836024 | 1836024 | 2021-10-20 | Crawford | Wisconsin | 55023 | 2269 | 22 |
1832775 | 1832775 | 2021-10-19 | Crawford | Wisconsin | 55023 | 2259 | 22 |
1829526 | 1829526 | 2021-10-18 | Crawford | Wisconsin | 55023 | 2253 | 22 |
1829567 | 1829567 | 2021-10-18 | Richland | Wisconsin | 55103 | 2121 | 22 |
1826277 | 1826277 | 2021-10-17 | Crawford | Wisconsin | 55023 | 2245 | 22 |
1826318 | 1826318 | 2021-10-17 | Richland | Wisconsin | 55103 | 2110 | 22 |
1823028 | 1823028 | 2021-10-16 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1823069 | 1823069 | 2021-10-16 | Richland | Wisconsin | 55103 | 2063 | 22 |
1819779 | 1819779 | 2021-10-15 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1819820 | 1819820 | 2021-10-15 | Richland | Wisconsin | 55103 | 2063 | 22 |
1816530 | 1816530 | 2021-10-14 | Crawford | Wisconsin | 55023 | 2228 | 22 |
1816571 | 1816571 | 2021-10-14 | Richland | Wisconsin | 55103 | 2063 | 22 |
1813282 | 1813282 | 2021-10-13 | Crawford | Wisconsin | 55023 | 2218 | 22 |
1813323 | 1813323 | 2021-10-13 | Richland | Wisconsin | 55103 | 2043 | 22 |
1810033 | 1810033 | 2021-10-12 | Crawford | Wisconsin | 55023 | 2201 | 22 |
1810074 | 1810074 | 2021-10-12 | Richland | Wisconsin | 55103 | 2032 | 22 |
1806784 | 1806784 | 2021-10-11 | Crawford | Wisconsin | 55023 | 2191 | 22 |
1806825 | 1806825 | 2021-10-11 | Richland | Wisconsin | 55103 | 2021 | 22 |
1803533 | 1803533 | 2021-10-10 | Crawford | Wisconsin | 55023 | 2172 | 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);