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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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
- …
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 |
---|---|---|---|---|---|---|---|
502042 | 502042 | 2020-09-04 | Unknown | Wisconsin | 0 | 8 | |
505276 | 505276 | 2020-09-05 | Unknown | Wisconsin | 0 | 8 | |
508508 | 508508 | 2020-09-06 | Unknown | Wisconsin | 0 | 8 | |
511741 | 511741 | 2020-09-07 | Unknown | Wisconsin | 0 | 8 | |
514974 | 514974 | 2020-09-08 | Unknown | Wisconsin | 0 | 8 | |
518209 | 518209 | 2020-09-09 | Unknown | Wisconsin | 0 | 8 | |
521446 | 521446 | 2020-09-10 | Unknown | Wisconsin | 0 | 8 | |
524682 | 524682 | 2020-09-11 | Unknown | Wisconsin | 0 | 8 | |
527918 | 527918 | 2020-09-12 | Unknown | Wisconsin | 0 | 8 | |
531155 | 531155 | 2020-09-13 | Unknown | Wisconsin | 0 | 8 | |
534390 | 534390 | 2020-09-14 | Unknown | Wisconsin | 0 | 8 | |
537626 | 537626 | 2020-09-15 | Unknown | Wisconsin | 0 | 9 | |
540863 | 540863 | 2020-09-16 | Unknown | Wisconsin | 0 | 9 | |
544099 | 544099 | 2020-09-17 | Unknown | Wisconsin | 0 | 8 | |
547336 | 547336 | 2020-09-18 | Unknown | Wisconsin | 0 | 8 | |
550575 | 550575 | 2020-09-19 | Unknown | Wisconsin | 0 | 8 | |
553814 | 553814 | 2020-09-20 | Unknown | Wisconsin | 0 | 8 | |
557051 | 557051 | 2020-09-21 | Unknown | Wisconsin | 0 | 8 | |
560287 | 560287 | 2020-09-22 | Unknown | Wisconsin | 0 | 8 | |
563526 | 563526 | 2020-09-23 | Unknown | Wisconsin | 0 | 9 | |
566767 | 566767 | 2020-09-24 | Unknown | Wisconsin | 0 | 10 | |
570008 | 570008 | 2020-09-25 | Unknown | Wisconsin | 0 | 10 | |
573250 | 573250 | 2020-09-26 | Unknown | Wisconsin | 0 | 10 | |
576494 | 576494 | 2020-09-27 | Unknown | Wisconsin | 0 | 10 | |
579735 | 579735 | 2020-09-28 | Unknown | Wisconsin | 0 | 10 | |
582974 | 582974 | 2020-09-29 | Unknown | Wisconsin | 0 | 10 | |
586214 | 586214 | 2020-09-30 | Unknown | Wisconsin | 0 | 10 | |
589455 | 589455 | 2020-10-01 | Unknown | Wisconsin | 0 | 10 | |
592695 | 592695 | 2020-10-02 | Unknown | Wisconsin | 0 | 10 | |
595937 | 595937 | 2020-10-03 | Unknown | Wisconsin | 0 | 11 | |
599180 | 599180 | 2020-10-04 | Unknown | Wisconsin | 0 | 11 | |
602423 | 602423 | 2020-10-05 | Unknown | Wisconsin | 0 | 11 | |
605665 | 605665 | 2020-10-06 | Unknown | Wisconsin | 0 | 11 | |
608908 | 608908 | 2020-10-07 | Unknown | Wisconsin | 0 | 11 | |
612150 | 612150 | 2020-10-08 | Unknown | Wisconsin | 0 | 11 | |
615391 | 615391 | 2020-10-09 | Unknown | Wisconsin | 0 | 11 | |
618633 | 618633 | 2020-10-10 | Unknown | Wisconsin | 0 | 10 | |
621876 | 621876 | 2020-10-11 | Unknown | Wisconsin | 0 | 10 | |
625119 | 625119 | 2020-10-12 | Unknown | Wisconsin | 0 | 10 | |
628362 | 628362 | 2020-10-13 | Unknown | Wisconsin | 0 | 10 | |
631606 | 631606 | 2020-10-14 | Unknown | Wisconsin | 0 | 11 | |
634851 | 634851 | 2020-10-15 | Unknown | Wisconsin | 0 | 12 | |
638096 | 638096 | 2020-10-16 | Unknown | Wisconsin | 0 | 14 | |
641343 | 641343 | 2020-10-17 | Unknown | Wisconsin | 0 | 14 | |
644591 | 644591 | 2020-10-18 | Unknown | Wisconsin | 0 | 14 | |
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 |
1160 | 1160 | 2020-03-10 | Pierce | Wisconsin | 55093 | 1 | 0 |
1362 | 1362 | 2020-03-11 | Pierce | Wisconsin | 55093 | 1 | 0 |
1363 | 1363 | 2020-03-11 | Waukesha | Wisconsin | 55133 | 1 | 0 |
1617 | 1617 | 2020-03-12 | Pierce | Wisconsin | 55093 | 1 | 0 |
1618 | 1618 | 2020-03-12 | Waukesha | Wisconsin | 55133 | 1 | 0 |
1929 | 1929 | 2020-03-13 | Pierce | Wisconsin | 55093 | 1 | 0 |
1930 | 1930 | 2020-03-13 | Racine | Wisconsin | 55101 | 1 | 0 |
1932 | 1932 | 2020-03-13 | Waukesha | Wisconsin | 55133 | 1 | 0 |
2303 | 2303 | 2020-03-14 | Pierce | Wisconsin | 55093 | 1 | 0 |
2304 | 2304 | 2020-03-14 | Racine | Wisconsin | 55101 | 1 | 0 |
2307 | 2307 | 2020-03-14 | Winnebago | Wisconsin | 55139 | 1 | 0 |
2732 | 2732 | 2020-03-15 | Pierce | Wisconsin | 55093 | 1 | 0 |
2733 | 2733 | 2020-03-15 | Racine | Wisconsin | 55101 | 1 | 0 |
2736 | 2736 | 2020-03-15 | Winnebago | Wisconsin | 55139 | 1 | 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 |
3212 | 3212 | 2020-03-16 | Wood | Wisconsin | 55141 | 1 | 0 |
3750 | 3750 | 2020-03-17 | Outagamie | Wisconsin | 55087 | 1 | 0 |
3751 | 3751 | 2020-03-17 | Pierce | Wisconsin | 55093 | 1 | 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);