ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-01-12" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923588 | 923588 | 2021-01-12 | Adams | Wisconsin | 55001 | 1544 | 13 |
923589 | 923589 | 2021-01-12 | Ashland | Wisconsin | 55003 | 1121 | 16 |
923590 | 923590 | 2021-01-12 | Barron | Wisconsin | 55005 | 4873 | 58 |
923591 | 923591 | 2021-01-12 | Bayfield | Wisconsin | 55007 | 1012 | 18 |
923592 | 923592 | 2021-01-12 | Brown | Wisconsin | 55009 | 29461 | 182 |
923593 | 923593 | 2021-01-12 | Buffalo | Wisconsin | 55011 | 1129 | 7 |
923594 | 923594 | 2021-01-12 | Burnett | Wisconsin | 55013 | 1158 | 21 |
923595 | 923595 | 2021-01-12 | Calumet | Wisconsin | 55015 | 5331 | 40 |
923596 | 923596 | 2021-01-12 | Chippewa | Wisconsin | 55017 | 6460 | 72 |
923597 | 923597 | 2021-01-12 | Clark | Wisconsin | 55019 | 3277 | 58 |
923598 | 923598 | 2021-01-12 | Columbia | Wisconsin | 55021 | 4821 | 39 |
923599 | 923599 | 2021-01-12 | Crawford | Wisconsin | 55023 | 1645 | 13 |
923600 | 923600 | 2021-01-12 | Dane | Wisconsin | 55025 | 36971 | 233 |
923601 | 923601 | 2021-01-12 | Dodge | Wisconsin | 55027 | 11417 | 144 |
923602 | 923602 | 2021-01-12 | Door | Wisconsin | 55029 | 2358 | 18 |
923603 | 923603 | 2021-01-12 | Douglas | Wisconsin | 55031 | 3782 | 30 |
923604 | 923604 | 2021-01-12 | Dunn | Wisconsin | 55033 | 4027 | 25 |
923605 | 923605 | 2021-01-12 | Eau Claire | Wisconsin | 55035 | 10112 | 99 |
923606 | 923606 | 2021-01-12 | Florence | Wisconsin | 55037 | 439 | 12 |
923607 | 923607 | 2021-01-12 | Fond du Lac | Wisconsin | 55039 | 11874 | 79 |
923608 | 923608 | 2021-01-12 | Forest | Wisconsin | 55041 | 954 | 25 |
923609 | 923609 | 2021-01-12 | Grant | Wisconsin | 55043 | 4797 | 82 |
923610 | 923610 | 2021-01-12 | Green | Wisconsin | 55045 | 2542 | 14 |
923611 | 923611 | 2021-01-12 | Green Lake | Wisconsin | 55047 | 1802 | 17 |
923612 | 923612 | 2021-01-12 | Iowa | Wisconsin | 55049 | 1812 | 9 |
923613 | 923613 | 2021-01-12 | Iron | Wisconsin | 55051 | 545 | 36 |
923614 | 923614 | 2021-01-12 | Jackson | Wisconsin | 55053 | 2511 | 18 |
923615 | 923615 | 2021-01-12 | Jefferson | Wisconsin | 55055 | 7813 | 66 |
923616 | 923616 | 2021-01-12 | Juneau | Wisconsin | 55057 | 2760 | 12 |
923617 | 923617 | 2021-01-12 | Kenosha | Wisconsin | 55059 | 15038 | 254 |
923618 | 923618 | 2021-01-12 | Kewaunee | Wisconsin | 55061 | 2320 | 26 |
923619 | 923619 | 2021-01-12 | La Crosse | Wisconsin | 55063 | 11364 | 64 |
923620 | 923620 | 2021-01-12 | Lafayette | Wisconsin | 55065 | 1413 | 7 |
923621 | 923621 | 2021-01-12 | Langlade | Wisconsin | 55067 | 1991 | 40 |
923622 | 923622 | 2021-01-12 | Lincoln | Wisconsin | 55069 | 2834 | 64 |
923623 | 923623 | 2021-01-12 | Manitowoc | Wisconsin | 55071 | 7462 | 63 |
923624 | 923624 | 2021-01-12 | Marathon | Wisconsin | 55073 | 13827 | 188 |
923625 | 923625 | 2021-01-12 | Marinette | Wisconsin | 55075 | 4058 | 51 |
923626 | 923626 | 2021-01-12 | Marquette | Wisconsin | 55077 | 1359 | 25 |
923627 | 923627 | 2021-01-12 | Menominee | Wisconsin | 55078 | 761 | 10 |
923628 | 923628 | 2021-01-12 | Milwaukee | Wisconsin | 55079 | 97174 | 1022 |
923629 | 923629 | 2021-01-12 | Monroe | Wisconsin | 55081 | 3802 | 26 |
923630 | 923630 | 2021-01-12 | Oconto | Wisconsin | 55083 | 4360 | 45 |
923631 | 923631 | 2021-01-12 | Oneida | Wisconsin | 55085 | 3085 | 51 |
923632 | 923632 | 2021-01-12 | Outagamie | Wisconsin | 55087 | 18987 | 167 |
923633 | 923633 | 2021-01-12 | Ozaukee | Wisconsin | 55089 | 7630 | 63 |
923634 | 923634 | 2021-01-12 | Pepin | Wisconsin | 55091 | 753 | 6 |
923635 | 923635 | 2021-01-12 | Pierce | Wisconsin | 55093 | 3939 | 35 |
923636 | 923636 | 2021-01-12 | Polk | Wisconsin | 55095 | 3347 | 29 |
923637 | 923637 | 2021-01-12 | Portage | Wisconsin | 55097 | 6253 | 57 |
923638 | 923638 | 2021-01-12 | Price | Wisconsin | 55099 | 1060 | 6 |
923639 | 923639 | 2021-01-12 | Racine | Wisconsin | 55101 | 21031 | 283 |
923640 | 923640 | 2021-01-12 | Richland | Wisconsin | 55103 | 1208 | 13 |
923641 | 923641 | 2021-01-12 | Rock | Wisconsin | 55105 | 14089 | 134 |
923642 | 923642 | 2021-01-12 | Rusk | Wisconsin | 55107 | 1204 | 14 |
923643 | 923643 | 2021-01-12 | Sauk | Wisconsin | 55111 | 4986 | 37 |
923644 | 923644 | 2021-01-12 | Sawyer | Wisconsin | 55113 | 1326 | 17 |
923645 | 923645 | 2021-01-12 | Shawano | Wisconsin | 55115 | 4781 | 73 |
923646 | 923646 | 2021-01-12 | Sheboygan | Wisconsin | 55117 | 12493 | 100 |
923647 | 923647 | 2021-01-12 | St. Croix | Wisconsin | 55109 | 7015 | 34 |
923648 | 923648 | 2021-01-12 | Taylor | Wisconsin | 55119 | 1857 | 19 |
923649 | 923649 | 2021-01-12 | Trempealeau | Wisconsin | 55121 | 3212 | 32 |
923650 | 923650 | 2021-01-12 | Vernon | Wisconsin | 55123 | 1688 | 32 |
923651 | 923651 | 2021-01-12 | Vilas | Wisconsin | 55125 | 1837 | 30 |
923652 | 923652 | 2021-01-12 | Walworth | Wisconsin | 55127 | 10215 | 115 |
923653 | 923653 | 2021-01-12 | Washburn | Wisconsin | 55129 | 1185 | 17 |
923654 | 923654 | 2021-01-12 | Washington | Wisconsin | 55131 | 14096 | 110 |
923655 | 923655 | 2021-01-12 | Waukesha | Wisconsin | 55133 | 40300 | 407 |
923656 | 923656 | 2021-01-12 | Waupaca | Wisconsin | 55135 | 5093 | 139 |
923657 | 923657 | 2021-01-12 | Waushara | Wisconsin | 55137 | 2163 | 24 |
923658 | 923658 | 2021-01-12 | Winnebago | Wisconsin | 55139 | 17932 | 180 |
923659 | 923659 | 2021-01-12 | Wood | Wisconsin | 55141 | 6373 | 70 |
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);