ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
72 rows where date = "2021-03-23" 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 |
---|---|---|---|---|---|---|---|
1150796 | 1150796 | 2021-03-23 | Adams | Wisconsin | 55001 | 1773 | 15 |
1150797 | 1150797 | 2021-03-23 | Ashland | Wisconsin | 55003 | 1264 | 16 |
1150798 | 1150798 | 2021-03-23 | Barron | Wisconsin | 55005 | 5652 | 76 |
1150799 | 1150799 | 2021-03-23 | Bayfield | Wisconsin | 55007 | 1158 | 19 |
1150800 | 1150800 | 2021-03-23 | Brown | Wisconsin | 55009 | 33464 | 261 |
1150801 | 1150801 | 2021-03-23 | Buffalo | Wisconsin | 55011 | 1358 | 7 |
1150802 | 1150802 | 2021-03-23 | Burnett | Wisconsin | 55013 | 1364 | 23 |
1150803 | 1150803 | 2021-03-23 | Calumet | Wisconsin | 55015 | 6145 | 50 |
1150804 | 1150804 | 2021-03-23 | Chippewa | Wisconsin | 55017 | 7335 | 95 |
1150805 | 1150805 | 2021-03-23 | Clark | Wisconsin | 55019 | 3554 | 62 |
1150806 | 1150806 | 2021-03-23 | Columbia | Wisconsin | 55021 | 5522 | 67 |
1150807 | 1150807 | 2021-03-23 | Crawford | Wisconsin | 55023 | 1724 | 17 |
1150808 | 1150808 | 2021-03-23 | Dane | Wisconsin | 55025 | 43155 | 311 |
1150809 | 1150809 | 2021-03-23 | Dodge | Wisconsin | 55027 | 12348 | 182 |
1150810 | 1150810 | 2021-03-23 | Door | Wisconsin | 55029 | 2677 | 26 |
1150811 | 1150811 | 2021-03-23 | Douglas | Wisconsin | 55031 | 4321 | 45 |
1150812 | 1150812 | 2021-03-23 | Dunn | Wisconsin | 55033 | 4683 | 30 |
1150813 | 1150813 | 2021-03-23 | Eau Claire | Wisconsin | 55035 | 11496 | 116 |
1150814 | 1150814 | 2021-03-23 | Florence | Wisconsin | 55037 | 474 | 12 |
1150815 | 1150815 | 2021-03-23 | Fond du Lac | Wisconsin | 55039 | 13221 | 109 |
1150816 | 1150816 | 2021-03-23 | Forest | Wisconsin | 55041 | 1006 | 26 |
1150817 | 1150817 | 2021-03-23 | Grant | Wisconsin | 55043 | 5411 | 88 |
1150818 | 1150818 | 2021-03-23 | Green | Wisconsin | 55045 | 3390 | 22 |
1150819 | 1150819 | 2021-03-23 | Green Lake | Wisconsin | 55047 | 1959 | 21 |
1150820 | 1150820 | 2021-03-23 | Iowa | Wisconsin | 55049 | 2024 | 11 |
1150821 | 1150821 | 2021-03-23 | Iron | Wisconsin | 55051 | 677 | 40 |
1150822 | 1150822 | 2021-03-23 | Jackson | Wisconsin | 55053 | 2633 | 27 |
1150823 | 1150823 | 2021-03-23 | Jefferson | Wisconsin | 55055 | 9021 | 126 |
1150824 | 1150824 | 2021-03-23 | Juneau | Wisconsin | 55057 | 3140 | 22 |
1150825 | 1150825 | 2021-03-23 | Kenosha | Wisconsin | 55059 | 17324 | 319 |
1150826 | 1150826 | 2021-03-23 | Kewaunee | Wisconsin | 55061 | 2602 | 30 |
1150827 | 1150827 | 2021-03-23 | La Crosse | Wisconsin | 55063 | 13098 | 80 |
1150828 | 1150828 | 2021-03-23 | Lafayette | Wisconsin | 55065 | 1640 | 7 |
1150829 | 1150829 | 2021-03-23 | Langlade | Wisconsin | 55067 | 2100 | 44 |
1150830 | 1150830 | 2021-03-23 | Lincoln | Wisconsin | 55069 | 3131 | 78 |
1150831 | 1150831 | 2021-03-23 | Manitowoc | Wisconsin | 55071 | 8473 | 84 |
1150832 | 1150832 | 2021-03-23 | Marathon | Wisconsin | 55073 | 15261 | 217 |
1150833 | 1150833 | 2021-03-23 | Marinette | Wisconsin | 55075 | 4394 | 68 |
1150834 | 1150834 | 2021-03-23 | Marquette | Wisconsin | 55077 | 1503 | 27 |
1150835 | 1150835 | 2021-03-23 | Menominee | Wisconsin | 55078 | 798 | 11 |
1150836 | 1150836 | 2021-03-23 | Milwaukee | Wisconsin | 55079 | 109014 | 1292 |
1150837 | 1150837 | 2021-03-23 | Monroe | Wisconsin | 55081 | 4459 | 35 |
1150838 | 1150838 | 2021-03-23 | Oconto | Wisconsin | 55083 | 4775 | 55 |
1150839 | 1150839 | 2021-03-23 | Oneida | Wisconsin | 55085 | 3609 | 73 |
1150840 | 1150840 | 2021-03-23 | Outagamie | Wisconsin | 55087 | 22286 | 212 |
1150841 | 1150841 | 2021-03-23 | Ozaukee | Wisconsin | 55089 | 8731 | 88 |
1150842 | 1150842 | 2021-03-23 | Pepin | Wisconsin | 55091 | 836 | 7 |
1150843 | 1150843 | 2021-03-23 | Pierce | Wisconsin | 55093 | 4487 | 41 |
1150844 | 1150844 | 2021-03-23 | Polk | Wisconsin | 55095 | 4097 | 48 |
1150845 | 1150845 | 2021-03-23 | Portage | Wisconsin | 55097 | 7069 | 69 |
1150846 | 1150846 | 2021-03-23 | Price | Wisconsin | 55099 | 1271 | 7 |
1150847 | 1150847 | 2021-03-23 | Racine | Wisconsin | 55101 | 23267 | 361 |
1150848 | 1150848 | 2021-03-23 | Richland | Wisconsin | 55103 | 1333 | 15 |
1150849 | 1150849 | 2021-03-23 | Rock | Wisconsin | 55105 | 16232 | 179 |
1150850 | 1150850 | 2021-03-23 | Rusk | Wisconsin | 55107 | 1321 | 17 |
1150851 | 1150851 | 2021-03-23 | Sauk | Wisconsin | 55111 | 5673 | 50 |
1150852 | 1150852 | 2021-03-23 | Sawyer | Wisconsin | 55113 | 1590 | 22 |
1150853 | 1150853 | 2021-03-23 | Shawano | Wisconsin | 55115 | 5162 | 81 |
1150854 | 1150854 | 2021-03-23 | Sheboygan | Wisconsin | 55117 | 13977 | 142 |
1150855 | 1150855 | 2021-03-23 | St. Croix | Wisconsin | 55109 | 8257 | 54 |
1150856 | 1150856 | 2021-03-23 | Taylor | Wisconsin | 55119 | 2039 | 31 |
1150857 | 1150857 | 2021-03-23 | Trempealeau | Wisconsin | 55121 | 3521 | 40 |
1150858 | 1150858 | 2021-03-23 | Vernon | Wisconsin | 55123 | 1927 | 40 |
1150859 | 1150859 | 2021-03-23 | Vilas | Wisconsin | 55125 | 2316 | 40 |
1150860 | 1150860 | 2021-03-23 | Walworth | Wisconsin | 55127 | 11697 | 153 |
1150861 | 1150861 | 2021-03-23 | Washburn | Wisconsin | 55129 | 1411 | 20 |
1150862 | 1150862 | 2021-03-23 | Washington | Wisconsin | 55131 | 15827 | 149 |
1150863 | 1150863 | 2021-03-23 | Waukesha | Wisconsin | 55133 | 45970 | 541 |
1150864 | 1150864 | 2021-03-23 | Waupaca | Wisconsin | 55135 | 5800 | 160 |
1150865 | 1150865 | 2021-03-23 | Waushara | Wisconsin | 55137 | 2431 | 35 |
1150866 | 1150866 | 2021-03-23 | Winnebago | Wisconsin | 55139 | 20176 | 207 |
1150867 | 1150867 | 2021-03-23 | Wood | Wisconsin | 55141 | 7206 | 90 |
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);