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 827
- 55093 795
- 55133 793
- 55039 792
- 55079 791
- 55101 791
- 55117 791
- 55139 790
- 55087 788
- 55141 788
- 55059 787
- 55063 786
- 55131 786
- 55009 785
- 55089 785
- 55111 785
- 55127 785
- 55007 784
- 55015 784
- 55021 784
- 55035 784
- 55073 784
- 55105 784
- 55109 784
- 55017 783
- 55031 783
- 55033 783
- 55045 783
- 55055 783
- 55027 780
- …
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 827
- Pierce 795
- Waukesha 793
- Fond du Lac 792
- Milwaukee 791
- Racine 791
- Sheboygan 791
- Winnebago 790
- Outagamie 788
- Wood 788
- Kenosha 787
- La Crosse 786
- Washington 786
- Brown 785
- Ozaukee 785
- Sauk 785
- Walworth 785
- Bayfield 784
- Calumet 784
- Columbia 784
- Eau Claire 784
- Marathon 784
- Rock 784
- St. Croix 784
- Chippewa 783
- Douglas 783
- Dunn 783
- Green 783
- Jefferson 783
- Dodge 780
- …
state 1
- Wisconsin · 55,893 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499508 | 2499508 | 2022-05-12 | Juneau | Wisconsin | 55057 | 7846 | 68 |
2499509 | 2499509 | 2022-05-12 | Kenosha | Wisconsin | 55059 | 45207 | 631 |
2499510 | 2499510 | 2022-05-12 | Kewaunee | Wisconsin | 55061 | 5922 | 59 |
2499511 | 2499511 | 2022-05-12 | La Crosse | Wisconsin | 55063 | 35922 | 186 |
2499512 | 2499512 | 2022-05-12 | Lafayette | Wisconsin | 55065 | 3727 | 26 |
2499513 | 2499513 | 2022-05-12 | Langlade | Wisconsin | 55067 | 5287 | 92 |
2499514 | 2499514 | 2022-05-12 | Lincoln | Wisconsin | 55069 | 7174 | 148 |
2499515 | 2499515 | 2022-05-12 | Manitowoc | Wisconsin | 55071 | 20776 | 189 |
2499516 | 2499516 | 2022-05-12 | Marathon | Wisconsin | 55073 | 40243 | 491 |
2499517 | 2499517 | 2022-05-12 | Marinette | Wisconsin | 55075 | 11750 | 127 |
2499518 | 2499518 | 2022-05-12 | Marquette | Wisconsin | 55077 | 3868 | 61 |
2499519 | 2499519 | 2022-05-12 | Menominee | Wisconsin | 55078 | 1980 | 14 |
2499520 | 2499520 | 2022-05-12 | Milwaukee | Wisconsin | 55079 | 276952 | 2291 |
2499521 | 2499521 | 2022-05-12 | Monroe | Wisconsin | 55081 | 12289 | 91 |
2499522 | 2499522 | 2022-05-12 | Oconto | Wisconsin | 55083 | 11513 | 120 |
2499523 | 2499523 | 2022-05-12 | Oneida | Wisconsin | 55085 | 8599 | 139 |
2499524 | 2499524 | 2022-05-12 | Outagamie | Wisconsin | 55087 | 55265 | 406 |
2499525 | 2499525 | 2022-05-12 | Ozaukee | Wisconsin | 55089 | 23109 | 186 |
2499526 | 2499526 | 2022-05-12 | Pepin | Wisconsin | 55091 | 1999 | 18 |
2499527 | 2499527 | 2022-05-12 | Pierce | Wisconsin | 55093 | 11864 | 73 |
2499528 | 2499528 | 2022-05-12 | Polk | Wisconsin | 55095 | 12677 | 122 |
2499529 | 2499529 | 2022-05-12 | Portage | Wisconsin | 55097 | 18449 | 161 |
2499530 | 2499530 | 2022-05-12 | Price | Wisconsin | 55099 | 3281 | 33 |
2499531 | 2499531 | 2022-05-12 | Racine | Wisconsin | 55101 | 57597 | 690 |
2499532 | 2499532 | 2022-05-12 | Richland | Wisconsin | 55103 | 3988 | 48 |
2499533 | 2499533 | 2022-05-12 | Rock | Wisconsin | 55105 | 44224 | 395 |
2499534 | 2499534 | 2022-05-12 | Rusk | Wisconsin | 55107 | 3464 | 55 |
2499535 | 2499535 | 2022-05-12 | Sauk | Wisconsin | 55111 | 16447 | 136 |
2499536 | 2499536 | 2022-05-12 | Sawyer | Wisconsin | 55113 | 4634 | 62 |
2499537 | 2499537 | 2022-05-12 | Shawano | Wisconsin | 55115 | 11974 | 152 |
2499538 | 2499538 | 2022-05-12 | Sheboygan | Wisconsin | 55117 | 33044 | 320 |
2499539 | 2499539 | 2022-05-12 | St. Croix | Wisconsin | 55109 | 25600 | 149 |
2499540 | 2499540 | 2022-05-12 | Taylor | Wisconsin | 55119 | 4883 | 72 |
2499541 | 2499541 | 2022-05-12 | Trempealeau | Wisconsin | 55121 | 8545 | 65 |
2499542 | 2499542 | 2022-05-12 | Vernon | Wisconsin | 55123 | 6238 | 98 |
2499543 | 2499543 | 2022-05-12 | Vilas | Wisconsin | 55125 | 5268 | 89 |
2499544 | 2499544 | 2022-05-12 | Walworth | Wisconsin | 55127 | 27295 | 281 |
2499545 | 2499545 | 2022-05-12 | Washburn | Wisconsin | 55129 | 4073 | 46 |
2499546 | 2499546 | 2022-05-12 | Washington | Wisconsin | 55131 | 38921 | 344 |
2499547 | 2499547 | 2022-05-12 | Waukesha | Wisconsin | 55133 | 115657 | 1093 |
2499548 | 2499548 | 2022-05-12 | Waupaca | Wisconsin | 55135 | 13807 | 252 |
2499549 | 2499549 | 2022-05-12 | Waushara | Wisconsin | 55137 | 6510 | 87 |
2499550 | 2499550 | 2022-05-12 | Winnebago | Wisconsin | 55139 | 52971 | 381 |
2499551 | 2499551 | 2022-05-12 | Wood | Wisconsin | 55141 | 21430 | 233 |
2496222 | 2496222 | 2022-05-11 | Adams | Wisconsin | 55001 | 4717 | 61 |
2496223 | 2496223 | 2022-05-11 | Ashland | Wisconsin | 55003 | 3348 | 36 |
2496224 | 2496224 | 2022-05-11 | Barron | Wisconsin | 55005 | 13722 | 144 |
2496225 | 2496225 | 2022-05-11 | Bayfield | Wisconsin | 55007 | 3409 | 41 |
2496226 | 2496226 | 2022-05-11 | Brown | Wisconsin | 55009 | 85472 | 556 |
2496227 | 2496227 | 2022-05-11 | Buffalo | Wisconsin | 55011 | 3598 | 12 |
2496228 | 2496228 | 2022-05-11 | Burnett | Wisconsin | 55013 | 4047 | 43 |
2496229 | 2496229 | 2022-05-11 | Calumet | Wisconsin | 55015 | 14723 | 121 |
2496230 | 2496230 | 2022-05-11 | Chippewa | Wisconsin | 55017 | 19057 | 187 |
2496231 | 2496231 | 2022-05-11 | Clark | Wisconsin | 55019 | 7680 | 122 |
2496232 | 2496232 | 2022-05-11 | Columbia | Wisconsin | 55021 | 15753 | 127 |
2496233 | 2496233 | 2022-05-11 | Crawford | Wisconsin | 55023 | 4286 | 28 |
2496234 | 2496234 | 2022-05-11 | Dane | Wisconsin | 55025 | 133471 | 515 |
2496235 | 2496235 | 2022-05-11 | Dodge | Wisconsin | 55027 | 27516 | 339 |
2496236 | 2496236 | 2022-05-11 | Door | Wisconsin | 55029 | 7072 | 71 |
2496237 | 2496237 | 2022-05-11 | Douglas | Wisconsin | 55031 | 11930 | 79 |
2496238 | 2496238 | 2022-05-11 | Dunn | Wisconsin | 55033 | 13583 | 75 |
2496239 | 2496239 | 2022-05-11 | Eau Claire | Wisconsin | 55035 | 31192 | 187 |
2496240 | 2496240 | 2022-05-11 | Florence | Wisconsin | 55037 | 1090 | 17 |
2496241 | 2496241 | 2022-05-11 | Fond du Lac | Wisconsin | 55039 | 32418 | 277 |
2496242 | 2496242 | 2022-05-11 | Forest | Wisconsin | 55041 | 2688 | 52 |
2496243 | 2496243 | 2022-05-11 | Grant | Wisconsin | 55043 | 12913 | 146 |
2496244 | 2496244 | 2022-05-11 | Green | Wisconsin | 55045 | 9483 | 54 |
2496245 | 2496245 | 2022-05-11 | Green Lake | Wisconsin | 55047 | 5248 | 64 |
2496246 | 2496246 | 2022-05-11 | Iowa | Wisconsin | 55049 | 5406 | 29 |
2496247 | 2496247 | 2022-05-11 | Iron | Wisconsin | 55051 | 1480 | 47 |
2496248 | 2496248 | 2022-05-11 | Jackson | Wisconsin | 55053 | 5726 | 43 |
2496249 | 2496249 | 2022-05-11 | Jefferson | Wisconsin | 55055 | 21943 | 243 |
2496250 | 2496250 | 2022-05-11 | Juneau | Wisconsin | 55057 | 7823 | 68 |
2496251 | 2496251 | 2022-05-11 | Kenosha | Wisconsin | 55059 | 45128 | 631 |
2496252 | 2496252 | 2022-05-11 | Kewaunee | Wisconsin | 55061 | 5921 | 59 |
2496253 | 2496253 | 2022-05-11 | La Crosse | Wisconsin | 55063 | 35861 | 186 |
2496254 | 2496254 | 2022-05-11 | Lafayette | Wisconsin | 55065 | 3720 | 26 |
2496255 | 2496255 | 2022-05-11 | Langlade | Wisconsin | 55067 | 5279 | 92 |
2496256 | 2496256 | 2022-05-11 | Lincoln | Wisconsin | 55069 | 7156 | 148 |
2496257 | 2496257 | 2022-05-11 | Manitowoc | Wisconsin | 55071 | 20754 | 189 |
2496258 | 2496258 | 2022-05-11 | Marathon | Wisconsin | 55073 | 40201 | 491 |
2496259 | 2496259 | 2022-05-11 | Marinette | Wisconsin | 55075 | 11731 | 126 |
2496260 | 2496260 | 2022-05-11 | Marquette | Wisconsin | 55077 | 3863 | 61 |
2496261 | 2496261 | 2022-05-11 | Menominee | Wisconsin | 55078 | 1976 | 14 |
2496262 | 2496262 | 2022-05-11 | Milwaukee | Wisconsin | 55079 | 276490 | 2290 |
2496263 | 2496263 | 2022-05-11 | Monroe | Wisconsin | 55081 | 12271 | 91 |
2496264 | 2496264 | 2022-05-11 | Oconto | Wisconsin | 55083 | 11506 | 120 |
2496265 | 2496265 | 2022-05-11 | Oneida | Wisconsin | 55085 | 8591 | 139 |
2496266 | 2496266 | 2022-05-11 | Outagamie | Wisconsin | 55087 | 55191 | 406 |
2496267 | 2496267 | 2022-05-11 | Ozaukee | Wisconsin | 55089 | 23042 | 186 |
2496268 | 2496268 | 2022-05-11 | Pepin | Wisconsin | 55091 | 1996 | 18 |
2496269 | 2496269 | 2022-05-11 | Pierce | Wisconsin | 55093 | 11842 | 73 |
2496270 | 2496270 | 2022-05-11 | Polk | Wisconsin | 55095 | 12659 | 122 |
2496271 | 2496271 | 2022-05-11 | Portage | Wisconsin | 55097 | 18415 | 161 |
2496272 | 2496272 | 2022-05-11 | Price | Wisconsin | 55099 | 3279 | 33 |
2496273 | 2496273 | 2022-05-11 | Racine | Wisconsin | 55101 | 57484 | 690 |
2496274 | 2496274 | 2022-05-11 | Richland | Wisconsin | 55103 | 3976 | 48 |
2496275 | 2496275 | 2022-05-11 | Rock | Wisconsin | 55105 | 44131 | 395 |
2496276 | 2496276 | 2022-05-11 | Rusk | Wisconsin | 55107 | 3460 | 55 |
2496277 | 2496277 | 2022-05-11 | Sauk | Wisconsin | 55111 | 16421 | 136 |
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);