ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55,993 rows where state = "Wisconsin" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 55025 829
- 55093 796
- 55039 794
- 55133 794
- 55079 792
- 55101 792
- 55117 792
- 55139 791
- 55087 789
- 55141 789
- 55059 788
- 55009 787
- 55063 787
- 55131 787
- 55007 786
- 55015 786
- 55021 786
- 55035 786
- 55089 786
- 55111 786
- 55127 786
- 55017 785
- 55031 785
- 55033 785
- 55045 785
- 55055 785
- 55073 785
- 55105 785
- 55109 785
- 55027 782
- …
date (date) >30 ✖
- 2020-06-10 73
- 2020-06-11 73
- 2020-06-12 73
- 2020-06-13 73
- 2020-06-14 73
- 2020-06-15 73
- 2020-06-16 73
- 2020-06-17 73
- 2020-06-18 73
- 2020-06-19 73
- 2020-06-20 73
- 2020-06-21 73
- 2020-06-22 73
- 2020-06-23 73
- 2020-06-24 73
- 2020-06-25 73
- 2020-06-26 73
- 2020-06-27 73
- 2020-06-28 73
- 2020-06-29 73
- 2020-06-30 73
- 2020-07-01 73
- 2020-07-02 73
- 2020-07-03 73
- 2020-07-04 73
- 2020-07-05 73
- 2020-07-06 73
- 2020-07-07 73
- 2020-07-08 73
- 2020-07-09 73
- …
county >30
- Dane 829
- Pierce 796
- Fond du Lac 794
- Waukesha 794
- Milwaukee 792
- Racine 792
- Sheboygan 792
- Winnebago 791
- Outagamie 789
- Wood 789
- Kenosha 788
- Brown 787
- La Crosse 787
- Washington 787
- Bayfield 786
- Calumet 786
- Columbia 786
- Eau Claire 786
- Ozaukee 786
- Sauk 786
- Walworth 786
- Chippewa 785
- Douglas 785
- Dunn 785
- Green 785
- Jefferson 785
- Marathon 785
- Rock 785
- St. Croix 785
- Dodge 782
- …
state 1
- Wisconsin · 55,993 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
79 | 79 | 2020-02-05 | Dane | Wisconsin | 55025 | 1 | 0 |
88 | 88 | 2020-02-06 | Dane | Wisconsin | 55025 | 1 | 0 |
97 | 97 | 2020-02-07 | Dane | Wisconsin | 55025 | 1 | 0 |
106 | 106 | 2020-02-08 | Dane | Wisconsin | 55025 | 1 | 0 |
115 | 115 | 2020-02-09 | Dane | Wisconsin | 55025 | 1 | 0 |
125 | 125 | 2020-02-10 | Dane | Wisconsin | 55025 | 1 | 0 |
135 | 135 | 2020-02-11 | Dane | Wisconsin | 55025 | 1 | 0 |
146 | 146 | 2020-02-12 | Dane | Wisconsin | 55025 | 1 | 0 |
157 | 157 | 2020-02-13 | Dane | Wisconsin | 55025 | 1 | 0 |
168 | 168 | 2020-02-14 | Dane | Wisconsin | 55025 | 1 | 0 |
179 | 179 | 2020-02-15 | Dane | Wisconsin | 55025 | 1 | 0 |
190 | 190 | 2020-02-16 | Dane | Wisconsin | 55025 | 1 | 0 |
202 | 202 | 2020-02-17 | Dane | Wisconsin | 55025 | 1 | 0 |
214 | 214 | 2020-02-18 | Dane | Wisconsin | 55025 | 1 | 0 |
226 | 226 | 2020-02-19 | Dane | Wisconsin | 55025 | 1 | 0 |
239 | 239 | 2020-02-20 | Dane | Wisconsin | 55025 | 1 | 0 |
253 | 253 | 2020-02-21 | Dane | Wisconsin | 55025 | 1 | 0 |
267 | 267 | 2020-02-22 | Dane | Wisconsin | 55025 | 1 | 0 |
281 | 281 | 2020-02-23 | Dane | Wisconsin | 55025 | 1 | 0 |
297 | 297 | 2020-02-24 | Dane | Wisconsin | 55025 | 1 | 0 |
314 | 314 | 2020-02-25 | Dane | Wisconsin | 55025 | 1 | 0 |
334 | 334 | 2020-02-26 | Dane | Wisconsin | 55025 | 1 | 0 |
354 | 354 | 2020-02-27 | Dane | Wisconsin | 55025 | 1 | 0 |
376 | 376 | 2020-02-28 | Dane | Wisconsin | 55025 | 1 | 0 |
398 | 398 | 2020-02-29 | Dane | Wisconsin | 55025 | 1 | 0 |
425 | 425 | 2020-03-01 | Dane | Wisconsin | 55025 | 1 | 0 |
458 | 458 | 2020-03-02 | Dane | Wisconsin | 55025 | 1 | 0 |
493 | 493 | 2020-03-03 | Dane | Wisconsin | 55025 | 1 | 0 |
532 | 532 | 2020-03-04 | Dane | Wisconsin | 55025 | 1 | 0 |
581 | 581 | 2020-03-05 | Dane | Wisconsin | 55025 | 1 | 0 |
655 | 655 | 2020-03-06 | Dane | Wisconsin | 55025 | 1 | 0 |
750 | 750 | 2020-03-07 | Dane | Wisconsin | 55025 | 1 | 0 |
863 | 863 | 2020-03-08 | Dane | Wisconsin | 55025 | 1 | 0 |
994 | 994 | 2020-03-09 | Dane | Wisconsin | 55025 | 1 | 0 |
995 | 995 | 2020-03-09 | Pierce | Wisconsin | 55093 | 1 | 0 |
1159 | 1159 | 2020-03-10 | Dane | Wisconsin | 55025 | 2 | 0 |
1160 | 1160 | 2020-03-10 | Pierce | Wisconsin | 55093 | 1 | 0 |
1360 | 1360 | 2020-03-11 | Dane | Wisconsin | 55025 | 2 | 0 |
1361 | 1361 | 2020-03-11 | Fond du Lac | Wisconsin | 55039 | 2 | 0 |
1362 | 1362 | 2020-03-11 | Pierce | Wisconsin | 55093 | 1 | 0 |
1363 | 1363 | 2020-03-11 | Waukesha | Wisconsin | 55133 | 1 | 0 |
1615 | 1615 | 2020-03-12 | Dane | Wisconsin | 55025 | 4 | 0 |
1616 | 1616 | 2020-03-12 | Fond du Lac | Wisconsin | 55039 | 2 | 0 |
1617 | 1617 | 2020-03-12 | Pierce | Wisconsin | 55093 | 1 | 0 |
1618 | 1618 | 2020-03-12 | Waukesha | Wisconsin | 55133 | 1 | 0 |
1926 | 1926 | 2020-03-13 | Dane | Wisconsin | 55025 | 5 | 0 |
1927 | 1927 | 2020-03-13 | Fond du Lac | Wisconsin | 55039 | 6 | 0 |
1928 | 1928 | 2020-03-13 | Milwaukee | Wisconsin | 55079 | 2 | 0 |
1929 | 1929 | 2020-03-13 | Pierce | Wisconsin | 55093 | 1 | 0 |
1930 | 1930 | 2020-03-13 | Racine | Wisconsin | 55101 | 1 | 0 |
1931 | 1931 | 2020-03-13 | Sheboygan | Wisconsin | 55117 | 3 | 0 |
1932 | 1932 | 2020-03-13 | Waukesha | Wisconsin | 55133 | 1 | 0 |
2300 | 2300 | 2020-03-14 | Dane | Wisconsin | 55025 | 6 | 0 |
2301 | 2301 | 2020-03-14 | Fond du Lac | Wisconsin | 55039 | 6 | 0 |
2302 | 2302 | 2020-03-14 | Milwaukee | Wisconsin | 55079 | 6 | 0 |
2303 | 2303 | 2020-03-14 | Pierce | Wisconsin | 55093 | 1 | 0 |
2304 | 2304 | 2020-03-14 | Racine | Wisconsin | 55101 | 1 | 0 |
2305 | 2305 | 2020-03-14 | Sheboygan | Wisconsin | 55117 | 3 | 0 |
2306 | 2306 | 2020-03-14 | Waukesha | Wisconsin | 55133 | 3 | 0 |
2307 | 2307 | 2020-03-14 | Winnebago | Wisconsin | 55139 | 1 | 0 |
2729 | 2729 | 2020-03-15 | Dane | Wisconsin | 55025 | 6 | 0 |
2730 | 2730 | 2020-03-15 | Fond du Lac | Wisconsin | 55039 | 11 | 0 |
2731 | 2731 | 2020-03-15 | Milwaukee | Wisconsin | 55079 | 7 | 0 |
2732 | 2732 | 2020-03-15 | Pierce | Wisconsin | 55093 | 1 | 0 |
2733 | 2733 | 2020-03-15 | Racine | Wisconsin | 55101 | 1 | 0 |
2734 | 2734 | 2020-03-15 | Sheboygan | Wisconsin | 55117 | 3 | 0 |
2735 | 2735 | 2020-03-15 | Waukesha | Wisconsin | 55133 | 3 | 0 |
2736 | 2736 | 2020-03-15 | Winnebago | Wisconsin | 55139 | 1 | 0 |
3203 | 3203 | 2020-03-16 | Dane | Wisconsin | 55025 | 10 | 0 |
3204 | 3204 | 2020-03-16 | Fond du Lac | Wisconsin | 55039 | 11 | 0 |
3205 | 3205 | 2020-03-16 | Milwaukee | Wisconsin | 55079 | 13 | 0 |
3206 | 3206 | 2020-03-16 | Outagamie | Wisconsin | 55087 | 1 | 0 |
3207 | 3207 | 2020-03-16 | Pierce | Wisconsin | 55093 | 1 | 0 |
3208 | 3208 | 2020-03-16 | Racine | Wisconsin | 55101 | 1 | 0 |
3209 | 3209 | 2020-03-16 | Sheboygan | Wisconsin | 55117 | 3 | 0 |
3210 | 3210 | 2020-03-16 | Waukesha | Wisconsin | 55133 | 3 | 0 |
3211 | 3211 | 2020-03-16 | Winnebago | Wisconsin | 55139 | 3 | 0 |
3212 | 3212 | 2020-03-16 | Wood | Wisconsin | 55141 | 1 | 0 |
3746 | 3746 | 2020-03-17 | Dane | Wisconsin | 55025 | 19 | 0 |
3747 | 3747 | 2020-03-17 | Fond du Lac | Wisconsin | 55039 | 11 | 0 |
3748 | 3748 | 2020-03-17 | Kenosha | Wisconsin | 55059 | 4 | 0 |
3749 | 3749 | 2020-03-17 | Milwaukee | Wisconsin | 55079 | 24 | 0 |
3750 | 3750 | 2020-03-17 | Outagamie | Wisconsin | 55087 | 1 | 0 |
3751 | 3751 | 2020-03-17 | Pierce | Wisconsin | 55093 | 1 | 0 |
3752 | 3752 | 2020-03-17 | Racine | Wisconsin | 55101 | 1 | 0 |
3753 | 3753 | 2020-03-17 | Sheboygan | Wisconsin | 55117 | 3 | 0 |
3754 | 3754 | 2020-03-17 | Waukesha | Wisconsin | 55133 | 4 | 0 |
3755 | 3755 | 2020-03-17 | Winnebago | Wisconsin | 55139 | 3 | 0 |
3756 | 3756 | 2020-03-17 | Wood | Wisconsin | 55141 | 1 | 0 |
4382 | 4382 | 2020-03-18 | Brown | Wisconsin | 55009 | 1 | 0 |
4383 | 4383 | 2020-03-18 | Dane | Wisconsin | 55025 | 23 | 0 |
4384 | 4384 | 2020-03-18 | Fond du Lac | Wisconsin | 55039 | 12 | 0 |
4385 | 4385 | 2020-03-18 | Kenosha | Wisconsin | 55059 | 4 | 0 |
4386 | 4386 | 2020-03-18 | La Crosse | Wisconsin | 55063 | 1 | 0 |
4387 | 4387 | 2020-03-18 | Milwaukee | Wisconsin | 55079 | 47 | 0 |
4388 | 4388 | 2020-03-18 | Outagamie | Wisconsin | 55087 | 1 | 0 |
4389 | 4389 | 2020-03-18 | Pierce | Wisconsin | 55093 | 1 | 0 |
4390 | 4390 | 2020-03-18 | Racine | Wisconsin | 55101 | 1 | 0 |
4391 | 4391 | 2020-03-18 | Sheboygan | Wisconsin | 55117 | 4 | 0 |
4392 | 4392 | 2020-03-18 | Washington | Wisconsin | 55131 | 2 | 0 |
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);