ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where "date" is on date 2021-02-17 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1040427 | 1040427 | 2021-02-17 | Adams | Wisconsin | 55001 | 1714 | 15 |
1040428 | 1040428 | 2021-02-17 | Ashland | Wisconsin | 55003 | 1234 | 16 |
1040429 | 1040429 | 2021-02-17 | Barron | Wisconsin | 55005 | 5409 | 74 |
1040430 | 1040430 | 2021-02-17 | Bayfield | Wisconsin | 55007 | 1130 | 18 |
1040431 | 1040431 | 2021-02-17 | Brown | Wisconsin | 55009 | 32250 | 227 |
1040432 | 1040432 | 2021-02-17 | Buffalo | Wisconsin | 55011 | 1337 | 7 |
1040433 | 1040433 | 2021-02-17 | Burnett | Wisconsin | 55013 | 1299 | 23 |
1040434 | 1040434 | 2021-02-17 | Calumet | Wisconsin | 55015 | 5928 | 44 |
1040435 | 1040435 | 2021-02-17 | Chippewa | Wisconsin | 55017 | 7143 | 92 |
1040436 | 1040436 | 2021-02-17 | Clark | Wisconsin | 55019 | 3529 | 61 |
1040437 | 1040437 | 2021-02-17 | Columbia | Wisconsin | 55021 | 5338 | 58 |
1040438 | 1040438 | 2021-02-17 | Crawford | Wisconsin | 55023 | 1708 | 17 |
1040439 | 1040439 | 2021-02-17 | Dane | Wisconsin | 55025 | 40988 | 286 |
1040440 | 1040440 | 2021-02-17 | Dodge | Wisconsin | 55027 | 12089 | 175 |
1040441 | 1040441 | 2021-02-17 | Door | Wisconsin | 55029 | 2589 | 24 |
1040442 | 1040442 | 2021-02-17 | Douglas | Wisconsin | 55031 | 4184 | 37 |
1040443 | 1040443 | 2021-02-17 | Dunn | Wisconsin | 55033 | 4531 | 27 |
1040444 | 1040444 | 2021-02-17 | Eau Claire | Wisconsin | 55035 | 11185 | 114 |
1040445 | 1040445 | 2021-02-17 | Florence | Wisconsin | 55037 | 465 | 12 |
1040446 | 1040446 | 2021-02-17 | Fond du Lac | Wisconsin | 55039 | 12866 | 97 |
1040447 | 1040447 | 2021-02-17 | Forest | Wisconsin | 55041 | 989 | 26 |
1040448 | 1040448 | 2021-02-17 | Grant | Wisconsin | 55043 | 5281 | 84 |
1040449 | 1040449 | 2021-02-17 | Green | Wisconsin | 55045 | 3119 | 22 |
1040450 | 1040450 | 2021-02-17 | Green Lake | Wisconsin | 55047 | 1934 | 21 |
1040451 | 1040451 | 2021-02-17 | Iowa | Wisconsin | 55049 | 1926 | 10 |
1040452 | 1040452 | 2021-02-17 | Iron | Wisconsin | 55051 | 640 | 39 |
1040453 | 1040453 | 2021-02-17 | Jackson | Wisconsin | 55053 | 2613 | 23 |
1040454 | 1040454 | 2021-02-17 | Jefferson | Wisconsin | 55055 | 8724 | 84 |
1040455 | 1040455 | 2021-02-17 | Juneau | Wisconsin | 55057 | 3046 | 20 |
1040456 | 1040456 | 2021-02-17 | Kenosha | Wisconsin | 55059 | 16712 | 309 |
1040457 | 1040457 | 2021-02-17 | Kewaunee | Wisconsin | 55061 | 2568 | 28 |
1040458 | 1040458 | 2021-02-17 | La Crosse | Wisconsin | 55063 | 12728 | 75 |
1040459 | 1040459 | 2021-02-17 | Lafayette | Wisconsin | 55065 | 1574 | 8 |
1040460 | 1040460 | 2021-02-17 | Langlade | Wisconsin | 55067 | 2076 | 43 |
1040461 | 1040461 | 2021-02-17 | Lincoln | Wisconsin | 55069 | 3060 | 73 |
1040462 | 1040462 | 2021-02-17 | Manitowoc | Wisconsin | 55071 | 8278 | 78 |
1040463 | 1040463 | 2021-02-17 | Marathon | Wisconsin | 55073 | 14848 | 203 |
1040464 | 1040464 | 2021-02-17 | Marinette | Wisconsin | 55075 | 4341 | 63 |
1040465 | 1040465 | 2021-02-17 | Marquette | Wisconsin | 55077 | 1472 | 26 |
1040466 | 1040466 | 2021-02-17 | Menominee | Wisconsin | 55078 | 794 | 11 |
1040467 | 1040467 | 2021-02-17 | Milwaukee | Wisconsin | 55079 | 105935 | 1251 |
1040468 | 1040468 | 2021-02-17 | Monroe | Wisconsin | 55081 | 4330 | 31 |
1040469 | 1040469 | 2021-02-17 | Oconto | Wisconsin | 55083 | 4682 | 54 |
1040470 | 1040470 | 2021-02-17 | Oneida | Wisconsin | 55085 | 3453 | 68 |
1040471 | 1040471 | 2021-02-17 | Outagamie | Wisconsin | 55087 | 21222 | 198 |
1040472 | 1040472 | 2021-02-17 | Ozaukee | Wisconsin | 55089 | 8434 | 79 |
1040473 | 1040473 | 2021-02-17 | Pepin | Wisconsin | 55091 | 820 | 7 |
1040474 | 1040474 | 2021-02-17 | Pierce | Wisconsin | 55093 | 4295 | 39 |
1040475 | 1040475 | 2021-02-17 | Polk | Wisconsin | 55095 | 3860 | 45 |
1040476 | 1040476 | 2021-02-17 | Portage | Wisconsin | 55097 | 6880 | 66 |
1040477 | 1040477 | 2021-02-17 | Price | Wisconsin | 55099 | 1232 | 7 |
1040478 | 1040478 | 2021-02-17 | Racine | Wisconsin | 55101 | 22715 | 343 |
1040479 | 1040479 | 2021-02-17 | Richland | Wisconsin | 55103 | 1299 | 13 |
1040480 | 1040480 | 2021-02-17 | Rock | Wisconsin | 55105 | 15772 | 165 |
1040481 | 1040481 | 2021-02-17 | Rusk | Wisconsin | 55107 | 1281 | 17 |
1040482 | 1040482 | 2021-02-17 | Sauk | Wisconsin | 55111 | 5430 | 45 |
1040483 | 1040483 | 2021-02-17 | Sawyer | Wisconsin | 55113 | 1506 | 21 |
1040484 | 1040484 | 2021-02-17 | Shawano | Wisconsin | 55115 | 5051 | 81 |
1040485 | 1040485 | 2021-02-17 | Sheboygan | Wisconsin | 55117 | 13437 | 133 |
1040486 | 1040486 | 2021-02-17 | St. Croix | Wisconsin | 55109 | 7878 | 46 |
1040487 | 1040487 | 2021-02-17 | Taylor | Wisconsin | 55119 | 1996 | 29 |
1040488 | 1040488 | 2021-02-17 | Trempealeau | Wisconsin | 55121 | 3452 | 38 |
1040489 | 1040489 | 2021-02-17 | Vernon | Wisconsin | 55123 | 1864 | 39 |
1040490 | 1040490 | 2021-02-17 | Vilas | Wisconsin | 55125 | 2192 | 38 |
1040491 | 1040491 | 2021-02-17 | Walworth | Wisconsin | 55127 | 11118 | 143 |
1040492 | 1040492 | 2021-02-17 | Washburn | Wisconsin | 55129 | 1345 | 20 |
1040493 | 1040493 | 2021-02-17 | Washington | Wisconsin | 55131 | 15336 | 137 |
1040494 | 1040494 | 2021-02-17 | Waukesha | Wisconsin | 55133 | 44187 | 510 |
1040495 | 1040495 | 2021-02-17 | Waupaca | Wisconsin | 55135 | 5587 | 156 |
1040496 | 1040496 | 2021-02-17 | Waushara | Wisconsin | 55137 | 2392 | 31 |
1040497 | 1040497 | 2021-02-17 | Winnebago | Wisconsin | 55139 | 19504 | 199 |
1040498 | 1040498 | 2021-02-17 | Wood | Wisconsin | 55141 | 7068 | 84 |
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);