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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 55025 829
- 55093 796
- 55039 794
- 55133 794
- 55079 792
- 55101 792
- 55117 792
- 55139 791
- 55087 789
- 55141 789
- 55059 788
- 55009 787
- 55063 787
- 55131 787
- 55007 786
- 55015 786
- 55021 786
- 55035 786
- 55089 786
- 55111 786
- 55127 786
- 55017 785
- 55031 785
- 55033 785
- 55045 785
- 55055 785
- 55073 785
- 55105 785
- 55109 785
- 55027 782
- …
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 829
- Pierce 796
- Fond du Lac 794
- Waukesha 794
- Milwaukee 792
- Racine 792
- Sheboygan 792
- Winnebago 791
- Outagamie 789
- Wood 789
- Kenosha 788
- Brown 787
- La Crosse 787
- Washington 787
- Bayfield 786
- Calumet 786
- Columbia 786
- Eau Claire 786
- Ozaukee 786
- Sauk 786
- Walworth 786
- Chippewa 785
- Douglas 785
- Dunn 785
- Green 785
- Jefferson 785
- Marathon 785
- Rock 785
- St. Croix 785
- Dodge 782
- …
state 1
- Wisconsin · 55,993 ✖
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
28328 | 28328 | 2020-04-02 | Adams | Wisconsin | 55001 | 1 | 0 |
30682 | 30682 | 2020-04-03 | Adams | Wisconsin | 55001 | 1 | 0 |
33083 | 33083 | 2020-04-04 | Adams | Wisconsin | 55001 | 1 | 0 |
35521 | 35521 | 2020-04-05 | Adams | Wisconsin | 55001 | 1 | 0 |
38007 | 38007 | 2020-04-06 | Adams | Wisconsin | 55001 | 2 | 0 |
40548 | 40548 | 2020-04-07 | Adams | Wisconsin | 55001 | 2 | 0 |
43120 | 43120 | 2020-04-08 | Adams | Wisconsin | 55001 | 2 | 0 |
45717 | 45717 | 2020-04-09 | Adams | Wisconsin | 55001 | 2 | 0 |
48345 | 48345 | 2020-04-10 | Adams | Wisconsin | 55001 | 2 | 0 |
51005 | 51005 | 2020-04-11 | Adams | Wisconsin | 55001 | 2 | 0 |
53682 | 53682 | 2020-04-12 | Adams | Wisconsin | 55001 | 2 | 0 |
56372 | 56372 | 2020-04-13 | Adams | Wisconsin | 55001 | 3 | 0 |
59079 | 59079 | 2020-04-14 | Adams | Wisconsin | 55001 | 3 | 1 |
61798 | 61798 | 2020-04-15 | Adams | Wisconsin | 55001 | 3 | 1 |
64531 | 64531 | 2020-04-16 | Adams | Wisconsin | 55001 | 3 | 1 |
67279 | 67279 | 2020-04-17 | Adams | Wisconsin | 55001 | 4 | 1 |
70041 | 70041 | 2020-04-18 | Adams | Wisconsin | 55001 | 4 | 1 |
72810 | 72810 | 2020-04-19 | Adams | Wisconsin | 55001 | 4 | 1 |
75586 | 75586 | 2020-04-20 | Adams | Wisconsin | 55001 | 4 | 1 |
78369 | 78369 | 2020-04-21 | Adams | Wisconsin | 55001 | 4 | 1 |
81162 | 81162 | 2020-04-22 | Adams | Wisconsin | 55001 | 4 | 1 |
83963 | 83963 | 2020-04-23 | Adams | Wisconsin | 55001 | 4 | 1 |
86770 | 86770 | 2020-04-24 | Adams | Wisconsin | 55001 | 4 | 1 |
89586 | 89586 | 2020-04-25 | Adams | Wisconsin | 55001 | 4 | 1 |
92404 | 92404 | 2020-04-26 | Adams | Wisconsin | 55001 | 4 | 1 |
95234 | 95234 | 2020-04-27 | Adams | Wisconsin | 55001 | 4 | 1 |
98079 | 98079 | 2020-04-28 | Adams | Wisconsin | 55001 | 4 | 1 |
100929 | 100929 | 2020-04-29 | Adams | Wisconsin | 55001 | 4 | 1 |
103784 | 103784 | 2020-04-30 | Adams | Wisconsin | 55001 | 4 | 1 |
106648 | 106648 | 2020-05-01 | Adams | Wisconsin | 55001 | 4 | 1 |
109517 | 109517 | 2020-05-02 | Adams | Wisconsin | 55001 | 4 | 1 |
112392 | 112392 | 2020-05-03 | Adams | Wisconsin | 55001 | 4 | 1 |
115275 | 115275 | 2020-05-04 | Adams | Wisconsin | 55001 | 4 | 1 |
118234 | 118234 | 2020-05-05 | Adams | Wisconsin | 55001 | 4 | 1 |
121199 | 121199 | 2020-05-06 | Adams | Wisconsin | 55001 | 4 | 1 |
124179 | 124179 | 2020-05-07 | Adams | Wisconsin | 55001 | 4 | 1 |
127164 | 127164 | 2020-05-08 | Adams | Wisconsin | 55001 | 4 | 1 |
130154 | 130154 | 2020-05-09 | Adams | Wisconsin | 55001 | 4 | 1 |
133144 | 133144 | 2020-05-10 | Adams | Wisconsin | 55001 | 4 | 1 |
136134 | 136134 | 2020-05-11 | Adams | Wisconsin | 55001 | 4 | 1 |
139125 | 139125 | 2020-05-12 | Adams | Wisconsin | 55001 | 4 | 1 |
142121 | 142121 | 2020-05-13 | Adams | Wisconsin | 55001 | 4 | 1 |
145118 | 145118 | 2020-05-14 | Adams | Wisconsin | 55001 | 4 | 1 |
148121 | 148121 | 2020-05-15 | Adams | Wisconsin | 55001 | 4 | 1 |
151130 | 151130 | 2020-05-16 | Adams | Wisconsin | 55001 | 4 | 1 |
154142 | 154142 | 2020-05-17 | Adams | Wisconsin | 55001 | 4 | 1 |
157158 | 157158 | 2020-05-18 | Adams | Wisconsin | 55001 | 4 | 1 |
160182 | 160182 | 2020-05-19 | Adams | Wisconsin | 55001 | 4 | 1 |
163210 | 163210 | 2020-05-20 | Adams | Wisconsin | 55001 | 4 | 1 |
166239 | 166239 | 2020-05-21 | Adams | Wisconsin | 55001 | 4 | 1 |
169275 | 169275 | 2020-05-22 | Adams | Wisconsin | 55001 | 4 | 1 |
172316 | 172316 | 2020-05-23 | Adams | Wisconsin | 55001 | 4 | 1 |
175359 | 175359 | 2020-05-24 | Adams | Wisconsin | 55001 | 4 | 1 |
178404 | 178404 | 2020-05-25 | Adams | Wisconsin | 55001 | 4 | 1 |
181448 | 181448 | 2020-05-26 | Adams | Wisconsin | 55001 | 4 | 1 |
184499 | 184499 | 2020-05-27 | Adams | Wisconsin | 55001 | 4 | 1 |
187556 | 187556 | 2020-05-28 | Adams | Wisconsin | 55001 | 4 | 1 |
190620 | 190620 | 2020-05-29 | Adams | Wisconsin | 55001 | 4 | 1 |
193686 | 193686 | 2020-05-30 | Adams | Wisconsin | 55001 | 4 | 1 |
196756 | 196756 | 2020-05-31 | Adams | Wisconsin | 55001 | 4 | 1 |
199829 | 199829 | 2020-06-01 | Adams | Wisconsin | 55001 | 4 | 1 |
202905 | 202905 | 2020-06-02 | Adams | Wisconsin | 55001 | 4 | 1 |
205984 | 205984 | 2020-06-03 | Adams | Wisconsin | 55001 | 4 | 1 |
209066 | 209066 | 2020-06-04 | Adams | Wisconsin | 55001 | 4 | 1 |
212151 | 212151 | 2020-06-05 | Adams | Wisconsin | 55001 | 5 | 1 |
215238 | 215238 | 2020-06-06 | Adams | Wisconsin | 55001 | 5 | 1 |
218328 | 218328 | 2020-06-07 | Adams | Wisconsin | 55001 | 5 | 1 |
221420 | 221420 | 2020-06-08 | Adams | Wisconsin | 55001 | 5 | 1 |
224516 | 224516 | 2020-06-09 | Adams | Wisconsin | 55001 | 6 | 1 |
227616 | 227616 | 2020-06-10 | Adams | Wisconsin | 55001 | 6 | 1 |
230720 | 230720 | 2020-06-11 | Adams | Wisconsin | 55001 | 6 | 1 |
233825 | 233825 | 2020-06-12 | Adams | Wisconsin | 55001 | 7 | 1 |
236932 | 236932 | 2020-06-13 | Adams | Wisconsin | 55001 | 7 | 1 |
240040 | 240040 | 2020-06-14 | Adams | Wisconsin | 55001 | 8 | 1 |
243151 | 243151 | 2020-06-15 | Adams | Wisconsin | 55001 | 8 | 2 |
246264 | 246264 | 2020-06-16 | Adams | Wisconsin | 55001 | 8 | 2 |
249376 | 249376 | 2020-06-17 | Adams | Wisconsin | 55001 | 9 | 2 |
252491 | 252491 | 2020-06-18 | Adams | Wisconsin | 55001 | 10 | 2 |
255610 | 255610 | 2020-06-19 | Adams | Wisconsin | 55001 | 10 | 2 |
258737 | 258737 | 2020-06-20 | Adams | Wisconsin | 55001 | 10 | 2 |
261864 | 261864 | 2020-06-21 | Adams | Wisconsin | 55001 | 10 | 2 |
264993 | 264993 | 2020-06-22 | Adams | Wisconsin | 55001 | 11 | 2 |
268122 | 268122 | 2020-06-23 | Adams | Wisconsin | 55001 | 11 | 2 |
271256 | 271256 | 2020-06-24 | Adams | Wisconsin | 55001 | 11 | 2 |
274396 | 274396 | 2020-06-25 | Adams | Wisconsin | 55001 | 12 | 2 |
277544 | 277544 | 2020-06-26 | Adams | Wisconsin | 55001 | 14 | 2 |
280692 | 280692 | 2020-06-27 | Adams | Wisconsin | 55001 | 15 | 2 |
283838 | 283838 | 2020-06-28 | Adams | Wisconsin | 55001 | 15 | 2 |
286984 | 286984 | 2020-06-29 | Adams | Wisconsin | 55001 | 19 | 2 |
290134 | 290134 | 2020-06-30 | Adams | Wisconsin | 55001 | 19 | 2 |
293287 | 293287 | 2020-07-01 | Adams | Wisconsin | 55001 | 19 | 2 |
296442 | 296442 | 2020-07-02 | Adams | Wisconsin | 55001 | 20 | 2 |
299604 | 299604 | 2020-07-03 | Adams | Wisconsin | 55001 | 23 | 2 |
302768 | 302768 | 2020-07-04 | Adams | Wisconsin | 55001 | 27 | 2 |
305932 | 305932 | 2020-07-05 | Adams | Wisconsin | 55001 | 32 | 2 |
309101 | 309101 | 2020-07-06 | Adams | Wisconsin | 55001 | 33 | 2 |
312270 | 312270 | 2020-07-07 | Adams | Wisconsin | 55001 | 33 | 2 |
315445 | 315445 | 2020-07-08 | Adams | Wisconsin | 55001 | 35 | 2 |
318618 | 318618 | 2020-07-09 | Adams | Wisconsin | 55001 | 35 | 2 |
321797 | 321797 | 2020-07-10 | Adams | Wisconsin | 55001 | 37 | 2 |
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);