ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,028 rows where deaths = 1 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Iron 209
- Jackson 202
- Bayfield 192
- Marquette 174
- Juneau 160
- Columbia 127
- Manitowoc 125
- Rusk 124
- Burnett 106
- Kewaunee 105
- Monroe 99
- Marathon 96
- Green 82
- Wood 80
- Waupaca 75
- Adams 62
- Buffalo 61
- Winnebago 51
- Lincoln 49
- Polk 48
- Douglas 47
- Dodge 46
- La Crosse 46
- Dunn 45
- Sawyer 45
- Langlade 43
- Ashland 42
- Calumet 31
- Vilas 31
- Marinette 29
- …
state 1
- Wisconsin · 3,028 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
784055 | 784055 | 2020-11-30 | Douglas | Wisconsin | 55031 | 2160 | 1 |
780810 | 780810 | 2020-11-29 | Douglas | Wisconsin | 55031 | 2140 | 1 |
777564 | 777564 | 2020-11-28 | Douglas | Wisconsin | 55031 | 2105 | 1 |
774319 | 774319 | 2020-11-27 | Douglas | Wisconsin | 55031 | 2057 | 1 |
771074 | 771074 | 2020-11-26 | Douglas | Wisconsin | 55031 | 2005 | 1 |
767828 | 767828 | 2020-11-25 | Douglas | Wisconsin | 55031 | 1959 | 1 |
764583 | 764583 | 2020-11-24 | Douglas | Wisconsin | 55031 | 1912 | 1 |
761338 | 761338 | 2020-11-23 | Douglas | Wisconsin | 55031 | 1871 | 1 |
758093 | 758093 | 2020-11-22 | Douglas | Wisconsin | 55031 | 1822 | 1 |
754846 | 754846 | 2020-11-21 | Douglas | Wisconsin | 55031 | 1723 | 1 |
751600 | 751600 | 2020-11-20 | Douglas | Wisconsin | 55031 | 1628 | 1 |
748354 | 748354 | 2020-11-19 | Douglas | Wisconsin | 55031 | 1505 | 1 |
745108 | 745108 | 2020-11-18 | Douglas | Wisconsin | 55031 | 1441 | 1 |
741861 | 741861 | 2020-11-17 | Douglas | Wisconsin | 55031 | 1419 | 1 |
738614 | 738614 | 2020-11-16 | Douglas | Wisconsin | 55031 | 1368 | 1 |
738645 | 738645 | 2020-11-16 | Pepin | Wisconsin | 55091 | 365 | 1 |
735370 | 735370 | 2020-11-15 | Douglas | Wisconsin | 55031 | 1329 | 1 |
735401 | 735401 | 2020-11-15 | Pepin | Wisconsin | 55091 | 364 | 1 |
732124 | 732124 | 2020-11-14 | Douglas | Wisconsin | 55031 | 1304 | 1 |
732155 | 732155 | 2020-11-14 | Pepin | Wisconsin | 55091 | 330 | 1 |
728879 | 728879 | 2020-11-13 | Douglas | Wisconsin | 55031 | 1267 | 1 |
728880 | 728880 | 2020-11-13 | Dunn | Wisconsin | 55033 | 1908 | 1 |
728910 | 728910 | 2020-11-13 | Pepin | Wisconsin | 55091 | 321 | 1 |
725636 | 725636 | 2020-11-12 | Douglas | Wisconsin | 55031 | 1185 | 1 |
725637 | 725637 | 2020-11-12 | Dunn | Wisconsin | 55033 | 1817 | 1 |
725667 | 725667 | 2020-11-12 | Pepin | Wisconsin | 55091 | 304 | 1 |
722393 | 722393 | 2020-11-11 | Douglas | Wisconsin | 55031 | 1152 | 1 |
722394 | 722394 | 2020-11-11 | Dunn | Wisconsin | 55033 | 1779 | 1 |
722424 | 722424 | 2020-11-11 | Pepin | Wisconsin | 55091 | 293 | 1 |
719150 | 719150 | 2020-11-10 | Douglas | Wisconsin | 55031 | 1106 | 1 |
719151 | 719151 | 2020-11-10 | Dunn | Wisconsin | 55033 | 1708 | 1 |
715903 | 715903 | 2020-11-09 | Crawford | Wisconsin | 55023 | 513 | 1 |
715907 | 715907 | 2020-11-09 | Douglas | Wisconsin | 55031 | 1056 | 1 |
715908 | 715908 | 2020-11-09 | Dunn | Wisconsin | 55033 | 1677 | 1 |
715931 | 715931 | 2020-11-09 | Menominee | Wisconsin | 55078 | 410 | 1 |
712659 | 712659 | 2020-11-08 | Crawford | Wisconsin | 55023 | 501 | 1 |
712663 | 712663 | 2020-11-08 | Douglas | Wisconsin | 55031 | 1052 | 1 |
712664 | 712664 | 2020-11-08 | Dunn | Wisconsin | 55033 | 1636 | 1 |
712680 | 712680 | 2020-11-08 | Lafayette | Wisconsin | 55065 | 722 | 1 |
712687 | 712687 | 2020-11-08 | Menominee | Wisconsin | 55078 | 407 | 1 |
709415 | 709415 | 2020-11-07 | Crawford | Wisconsin | 55023 | 494 | 1 |
709419 | 709419 | 2020-11-07 | Douglas | Wisconsin | 55031 | 1041 | 1 |
709420 | 709420 | 2020-11-07 | Dunn | Wisconsin | 55033 | 1599 | 1 |
709436 | 709436 | 2020-11-07 | Lafayette | Wisconsin | 55065 | 696 | 1 |
709443 | 709443 | 2020-11-07 | Menominee | Wisconsin | 55078 | 403 | 1 |
709458 | 709458 | 2020-11-07 | Rusk | Wisconsin | 55107 | 395 | 1 |
706171 | 706171 | 2020-11-06 | Crawford | Wisconsin | 55023 | 473 | 1 |
706175 | 706175 | 2020-11-06 | Douglas | Wisconsin | 55031 | 1004 | 1 |
706176 | 706176 | 2020-11-06 | Dunn | Wisconsin | 55033 | 1545 | 1 |
706192 | 706192 | 2020-11-06 | Lafayette | Wisconsin | 55065 | 670 | 1 |
706199 | 706199 | 2020-11-06 | Menominee | Wisconsin | 55078 | 388 | 1 |
706214 | 706214 | 2020-11-06 | Rusk | Wisconsin | 55107 | 353 | 1 |
702928 | 702928 | 2020-11-05 | Crawford | Wisconsin | 55023 | 457 | 1 |
702932 | 702932 | 2020-11-05 | Douglas | Wisconsin | 55031 | 953 | 1 |
702933 | 702933 | 2020-11-05 | Dunn | Wisconsin | 55033 | 1484 | 1 |
702949 | 702949 | 2020-11-05 | Lafayette | Wisconsin | 55065 | 646 | 1 |
702956 | 702956 | 2020-11-05 | Menominee | Wisconsin | 55078 | 377 | 1 |
702971 | 702971 | 2020-11-05 | Rusk | Wisconsin | 55107 | 340 | 1 |
699685 | 699685 | 2020-11-04 | Crawford | Wisconsin | 55023 | 436 | 1 |
699689 | 699689 | 2020-11-04 | Douglas | Wisconsin | 55031 | 939 | 1 |
699690 | 699690 | 2020-11-04 | Dunn | Wisconsin | 55033 | 1422 | 1 |
699706 | 699706 | 2020-11-04 | Lafayette | Wisconsin | 55065 | 632 | 1 |
699713 | 699713 | 2020-11-04 | Menominee | Wisconsin | 55078 | 359 | 1 |
699728 | 699728 | 2020-11-04 | Rusk | Wisconsin | 55107 | 317 | 1 |
696441 | 696441 | 2020-11-03 | Crawford | Wisconsin | 55023 | 419 | 1 |
696445 | 696445 | 2020-11-03 | Douglas | Wisconsin | 55031 | 893 | 1 |
696446 | 696446 | 2020-11-03 | Dunn | Wisconsin | 55033 | 1330 | 1 |
696462 | 696462 | 2020-11-03 | Lafayette | Wisconsin | 55065 | 625 | 1 |
696469 | 696469 | 2020-11-03 | Menominee | Wisconsin | 55078 | 355 | 1 |
696484 | 696484 | 2020-11-03 | Rusk | Wisconsin | 55107 | 304 | 1 |
693199 | 693199 | 2020-11-02 | Crawford | Wisconsin | 55023 | 408 | 1 |
693203 | 693203 | 2020-11-02 | Douglas | Wisconsin | 55031 | 870 | 1 |
693204 | 693204 | 2020-11-02 | Dunn | Wisconsin | 55033 | 1291 | 1 |
693220 | 693220 | 2020-11-02 | Lafayette | Wisconsin | 55065 | 614 | 1 |
693242 | 693242 | 2020-11-02 | Rusk | Wisconsin | 55107 | 275 | 1 |
689955 | 689955 | 2020-11-01 | Crawford | Wisconsin | 55023 | 396 | 1 |
689959 | 689959 | 2020-11-01 | Douglas | Wisconsin | 55031 | 848 | 1 |
689960 | 689960 | 2020-11-01 | Dunn | Wisconsin | 55033 | 1241 | 1 |
689976 | 689976 | 2020-11-01 | Lafayette | Wisconsin | 55065 | 611 | 1 |
689998 | 689998 | 2020-11-01 | Rusk | Wisconsin | 55107 | 263 | 1 |
686710 | 686710 | 2020-10-31 | Crawford | Wisconsin | 55023 | 381 | 1 |
686714 | 686714 | 2020-10-31 | Douglas | Wisconsin | 55031 | 846 | 1 |
686715 | 686715 | 2020-10-31 | Dunn | Wisconsin | 55033 | 1222 | 1 |
686725 | 686725 | 2020-10-31 | Jackson | Wisconsin | 55053 | 598 | 1 |
686731 | 686731 | 2020-10-31 | Lafayette | Wisconsin | 55065 | 600 | 1 |
686753 | 686753 | 2020-10-31 | Rusk | Wisconsin | 55107 | 253 | 1 |
683467 | 683467 | 2020-10-30 | Crawford | Wisconsin | 55023 | 374 | 1 |
683472 | 683472 | 2020-10-30 | Dunn | Wisconsin | 55033 | 1170 | 1 |
683480 | 683480 | 2020-10-30 | Iowa | Wisconsin | 55049 | 552 | 1 |
683482 | 683482 | 2020-10-30 | Jackson | Wisconsin | 55053 | 572 | 1 |
683488 | 683488 | 2020-10-30 | Lafayette | Wisconsin | 55065 | 585 | 1 |
683510 | 683510 | 2020-10-30 | Rusk | Wisconsin | 55107 | 244 | 1 |
680224 | 680224 | 2020-10-29 | Crawford | Wisconsin | 55023 | 354 | 1 |
680229 | 680229 | 2020-10-29 | Dunn | Wisconsin | 55033 | 1141 | 1 |
680237 | 680237 | 2020-10-29 | Iowa | Wisconsin | 55049 | 527 | 1 |
680239 | 680239 | 2020-10-29 | Jackson | Wisconsin | 55053 | 552 | 1 |
680245 | 680245 | 2020-10-29 | Lafayette | Wisconsin | 55065 | 571 | 1 |
680267 | 680267 | 2020-10-29 | Rusk | Wisconsin | 55107 | 236 | 1 |
676981 | 676981 | 2020-10-28 | Crawford | Wisconsin | 55023 | 347 | 1 |
676985 | 676985 | 2020-10-28 | Douglas | Wisconsin | 55031 | 786 | 1 |
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);