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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 55025 826
- 55093 793
- 55133 792
- 55039 791
- 55117 790
- 55079 789
- 55101 789
- 55139 789
- 55141 787
- 55087 786
- 55059 785
- 55131 785
- 55009 784
- 55063 784
- 55127 784
- 55007 783
- 55015 783
- 55021 783
- 55035 783
- 55089 783
- 55109 783
- 55111 783
- 55017 782
- 55031 782
- 55033 782
- 55045 782
- 55055 782
- 55073 782
- 55105 782
- 55027 779
- …
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 826
- Pierce 793
- Waukesha 792
- Fond du Lac 791
- Sheboygan 790
- Milwaukee 789
- Racine 789
- Winnebago 789
- Wood 787
- Outagamie 786
- Kenosha 785
- Washington 785
- Brown 784
- La Crosse 784
- Walworth 784
- Bayfield 783
- Calumet 783
- Columbia 783
- Eau Claire 783
- Ozaukee 783
- Sauk 783
- St. Croix 783
- Chippewa 782
- Douglas 782
- Dunn 782
- Green 782
- Jefferson 782
- Marathon 782
- Rock 782
- Dodge 779
- …
state 1
- Wisconsin · 55,793 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496278 | 2496278 | 2022-05-11 | Sawyer | Wisconsin | 55113 | 4621 | 62 |
2496279 | 2496279 | 2022-05-11 | Shawano | Wisconsin | 55115 | 11950 | 152 |
2496280 | 2496280 | 2022-05-11 | Sheboygan | Wisconsin | 55117 | 33000 | 320 |
2496281 | 2496281 | 2022-05-11 | St. Croix | Wisconsin | 55109 | 25553 | 149 |
2496282 | 2496282 | 2022-05-11 | Taylor | Wisconsin | 55119 | 4879 | 72 |
2496283 | 2496283 | 2022-05-11 | Trempealeau | Wisconsin | 55121 | 8532 | 65 |
2496284 | 2496284 | 2022-05-11 | Vernon | Wisconsin | 55123 | 6231 | 98 |
2496285 | 2496285 | 2022-05-11 | Vilas | Wisconsin | 55125 | 5262 | 89 |
2496286 | 2496286 | 2022-05-11 | Walworth | Wisconsin | 55127 | 27254 | 280 |
2496287 | 2496287 | 2022-05-11 | Washburn | Wisconsin | 55129 | 4068 | 46 |
2496288 | 2496288 | 2022-05-11 | Washington | Wisconsin | 55131 | 38864 | 342 |
2496289 | 2496289 | 2022-05-11 | Waukesha | Wisconsin | 55133 | 115411 | 1093 |
2496290 | 2496290 | 2022-05-11 | Waupaca | Wisconsin | 55135 | 13786 | 252 |
2496291 | 2496291 | 2022-05-11 | Waushara | Wisconsin | 55137 | 6499 | 87 |
2496292 | 2496292 | 2022-05-11 | Winnebago | Wisconsin | 55139 | 52898 | 381 |
2496293 | 2496293 | 2022-05-11 | Wood | Wisconsin | 55141 | 21401 | 233 |
2492964 | 2492964 | 2022-05-10 | Adams | Wisconsin | 55001 | 4706 | 61 |
2492965 | 2492965 | 2022-05-10 | Ashland | Wisconsin | 55003 | 3340 | 36 |
2492966 | 2492966 | 2022-05-10 | Barron | Wisconsin | 55005 | 13704 | 144 |
2492967 | 2492967 | 2022-05-10 | Bayfield | Wisconsin | 55007 | 3402 | 41 |
2492968 | 2492968 | 2022-05-10 | Brown | Wisconsin | 55009 | 85368 | 556 |
2492969 | 2492969 | 2022-05-10 | Buffalo | Wisconsin | 55011 | 3592 | 12 |
2492970 | 2492970 | 2022-05-10 | Burnett | Wisconsin | 55013 | 4038 | 43 |
2492971 | 2492971 | 2022-05-10 | Calumet | Wisconsin | 55015 | 14717 | 121 |
2492972 | 2492972 | 2022-05-10 | Chippewa | Wisconsin | 55017 | 19035 | 187 |
2492973 | 2492973 | 2022-05-10 | Clark | Wisconsin | 55019 | 7678 | 122 |
2492974 | 2492974 | 2022-05-10 | Columbia | Wisconsin | 55021 | 15722 | 128 |
2492975 | 2492975 | 2022-05-10 | Crawford | Wisconsin | 55023 | 4281 | 28 |
2492976 | 2492976 | 2022-05-10 | Dane | Wisconsin | 55025 | 133070 | 515 |
2492977 | 2492977 | 2022-05-10 | Dodge | Wisconsin | 55027 | 27493 | 339 |
2492978 | 2492978 | 2022-05-10 | Door | Wisconsin | 55029 | 7064 | 71 |
2492979 | 2492979 | 2022-05-10 | Douglas | Wisconsin | 55031 | 11891 | 79 |
2492980 | 2492980 | 2022-05-10 | Dunn | Wisconsin | 55033 | 13570 | 75 |
2492981 | 2492981 | 2022-05-10 | Eau Claire | Wisconsin | 55035 | 31132 | 187 |
2492982 | 2492982 | 2022-05-10 | Florence | Wisconsin | 55037 | 1090 | 17 |
2492983 | 2492983 | 2022-05-10 | Fond du Lac | Wisconsin | 55039 | 32372 | 277 |
2492984 | 2492984 | 2022-05-10 | Forest | Wisconsin | 55041 | 2686 | 52 |
2492985 | 2492985 | 2022-05-10 | Grant | Wisconsin | 55043 | 12896 | 145 |
2492986 | 2492986 | 2022-05-10 | Green | Wisconsin | 55045 | 9469 | 54 |
2492987 | 2492987 | 2022-05-10 | Green Lake | Wisconsin | 55047 | 5236 | 63 |
2492988 | 2492988 | 2022-05-10 | Iowa | Wisconsin | 55049 | 5394 | 28 |
2492989 | 2492989 | 2022-05-10 | Iron | Wisconsin | 55051 | 1481 | 47 |
2492990 | 2492990 | 2022-05-10 | Jackson | Wisconsin | 55053 | 5719 | 43 |
2492991 | 2492991 | 2022-05-10 | Jefferson | Wisconsin | 55055 | 21923 | 242 |
2492992 | 2492992 | 2022-05-10 | Juneau | Wisconsin | 55057 | 7808 | 68 |
2492993 | 2492993 | 2022-05-10 | Kenosha | Wisconsin | 55059 | 45071 | 631 |
2492994 | 2492994 | 2022-05-10 | Kewaunee | Wisconsin | 55061 | 5913 | 59 |
2492995 | 2492995 | 2022-05-10 | La Crosse | Wisconsin | 55063 | 35708 | 186 |
2492996 | 2492996 | 2022-05-10 | Lafayette | Wisconsin | 55065 | 3714 | 26 |
2492997 | 2492997 | 2022-05-10 | Langlade | Wisconsin | 55067 | 5274 | 92 |
2492998 | 2492998 | 2022-05-10 | Lincoln | Wisconsin | 55069 | 7145 | 148 |
2492999 | 2492999 | 2022-05-10 | Manitowoc | Wisconsin | 55071 | 20730 | 189 |
2493000 | 2493000 | 2022-05-10 | Marathon | Wisconsin | 55073 | 40111 | 490 |
2493001 | 2493001 | 2022-05-10 | Marinette | Wisconsin | 55075 | 11723 | 126 |
2493002 | 2493002 | 2022-05-10 | Marquette | Wisconsin | 55077 | 3855 | 61 |
2493003 | 2493003 | 2022-05-10 | Menominee | Wisconsin | 55078 | 1973 | 14 |
2493004 | 2493004 | 2022-05-10 | Milwaukee | Wisconsin | 55079 | 275957 | 2290 |
2493005 | 2493005 | 2022-05-10 | Monroe | Wisconsin | 55081 | 12244 | 91 |
2493006 | 2493006 | 2022-05-10 | Oconto | Wisconsin | 55083 | 11496 | 120 |
2493007 | 2493007 | 2022-05-10 | Oneida | Wisconsin | 55085 | 8576 | 139 |
2493008 | 2493008 | 2022-05-10 | Outagamie | Wisconsin | 55087 | 55129 | 406 |
2493009 | 2493009 | 2022-05-10 | Ozaukee | Wisconsin | 55089 | 22989 | 186 |
2493010 | 2493010 | 2022-05-10 | Pepin | Wisconsin | 55091 | 1994 | 18 |
2493011 | 2493011 | 2022-05-10 | Pierce | Wisconsin | 55093 | 11824 | 73 |
2493012 | 2493012 | 2022-05-10 | Polk | Wisconsin | 55095 | 12645 | 122 |
2493013 | 2493013 | 2022-05-10 | Portage | Wisconsin | 55097 | 18400 | 161 |
2493014 | 2493014 | 2022-05-10 | Price | Wisconsin | 55099 | 3275 | 33 |
2493015 | 2493015 | 2022-05-10 | Racine | Wisconsin | 55101 | 57363 | 690 |
2493016 | 2493016 | 2022-05-10 | Richland | Wisconsin | 55103 | 3969 | 48 |
2493017 | 2493017 | 2022-05-10 | Rock | Wisconsin | 55105 | 44050 | 395 |
2493018 | 2493018 | 2022-05-10 | Rusk | Wisconsin | 55107 | 3458 | 55 |
2493019 | 2493019 | 2022-05-10 | Sauk | Wisconsin | 55111 | 16376 | 136 |
2493020 | 2493020 | 2022-05-10 | Sawyer | Wisconsin | 55113 | 4607 | 62 |
2493021 | 2493021 | 2022-05-10 | Shawano | Wisconsin | 55115 | 11918 | 152 |
2493022 | 2493022 | 2022-05-10 | Sheboygan | Wisconsin | 55117 | 32963 | 319 |
2493023 | 2493023 | 2022-05-10 | St. Croix | Wisconsin | 55109 | 25505 | 149 |
2493024 | 2493024 | 2022-05-10 | Taylor | Wisconsin | 55119 | 4875 | 72 |
2493025 | 2493025 | 2022-05-10 | Trempealeau | Wisconsin | 55121 | 8517 | 64 |
2493026 | 2493026 | 2022-05-10 | Vernon | Wisconsin | 55123 | 6212 | 98 |
2493027 | 2493027 | 2022-05-10 | Vilas | Wisconsin | 55125 | 5256 | 89 |
2493028 | 2493028 | 2022-05-10 | Walworth | Wisconsin | 55127 | 27224 | 280 |
2493029 | 2493029 | 2022-05-10 | Washburn | Wisconsin | 55129 | 4058 | 46 |
2493030 | 2493030 | 2022-05-10 | Washington | Wisconsin | 55131 | 38788 | 342 |
2493031 | 2493031 | 2022-05-10 | Waukesha | Wisconsin | 55133 | 115197 | 1093 |
2493032 | 2493032 | 2022-05-10 | Waupaca | Wisconsin | 55135 | 13774 | 252 |
2493033 | 2493033 | 2022-05-10 | Waushara | Wisconsin | 55137 | 6491 | 87 |
2493034 | 2493034 | 2022-05-10 | Winnebago | Wisconsin | 55139 | 52819 | 381 |
2493035 | 2493035 | 2022-05-10 | Wood | Wisconsin | 55141 | 21360 | 233 |
2489706 | 2489706 | 2022-05-09 | Adams | Wisconsin | 55001 | 4705 | 61 |
2489707 | 2489707 | 2022-05-09 | Ashland | Wisconsin | 55003 | 3340 | 36 |
2489708 | 2489708 | 2022-05-09 | Barron | Wisconsin | 55005 | 13685 | 144 |
2489709 | 2489709 | 2022-05-09 | Bayfield | Wisconsin | 55007 | 3395 | 40 |
2489710 | 2489710 | 2022-05-09 | Brown | Wisconsin | 55009 | 85261 | 556 |
2489711 | 2489711 | 2022-05-09 | Buffalo | Wisconsin | 55011 | 3588 | 12 |
2489712 | 2489712 | 2022-05-09 | Burnett | Wisconsin | 55013 | 4033 | 43 |
2489713 | 2489713 | 2022-05-09 | Calumet | Wisconsin | 55015 | 14710 | 121 |
2489714 | 2489714 | 2022-05-09 | Chippewa | Wisconsin | 55017 | 19022 | 186 |
2489715 | 2489715 | 2022-05-09 | Clark | Wisconsin | 55019 | 7670 | 122 |
2489716 | 2489716 | 2022-05-09 | Columbia | Wisconsin | 55021 | 15704 | 128 |
2489717 | 2489717 | 2022-05-09 | Crawford | Wisconsin | 55023 | 4276 | 28 |
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);