ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 55131 and state = "Wisconsin" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
4392 | 4392 | 2020-03-18 | Washington | Wisconsin | 55131 | 2 | 0 |
5158 | 5158 | 2020-03-19 | Washington | Wisconsin | 55131 | 2 | 0 |
6072 | 6072 | 2020-03-20 | Washington | Wisconsin | 55131 | 3 | 0 |
7105 | 7105 | 2020-03-21 | Washington | Wisconsin | 55131 | 3 | 0 |
8243 | 8243 | 2020-03-22 | Washington | Wisconsin | 55131 | 14 | 0 |
9469 | 9469 | 2020-03-23 | Washington | Wisconsin | 55131 | 15 | 0 |
10823 | 10823 | 2020-03-24 | Washington | Wisconsin | 55131 | 17 | 0 |
12354 | 12354 | 2020-03-25 | Washington | Wisconsin | 55131 | 21 | 0 |
14010 | 14010 | 2020-03-26 | Washington | Wisconsin | 55131 | 25 | 0 |
15785 | 15785 | 2020-03-27 | Washington | Wisconsin | 55131 | 27 | 0 |
17666 | 17666 | 2020-03-28 | Washington | Wisconsin | 55131 | 31 | 0 |
19635 | 19635 | 2020-03-29 | Washington | Wisconsin | 55131 | 31 | 0 |
21707 | 21707 | 2020-03-30 | Washington | Wisconsin | 55131 | 34 | 0 |
23860 | 23860 | 2020-03-31 | Washington | Wisconsin | 55131 | 40 | 1 |
26081 | 26081 | 2020-04-01 | Washington | Wisconsin | 55131 | 44 | 1 |
28375 | 28375 | 2020-04-02 | Washington | Wisconsin | 55131 | 46 | 2 |
30731 | 30731 | 2020-04-03 | Washington | Wisconsin | 55131 | 52 | 2 |
33134 | 33134 | 2020-04-04 | Washington | Wisconsin | 55131 | 55 | 3 |
35573 | 35573 | 2020-04-05 | Washington | Wisconsin | 55131 | 57 | 3 |
38060 | 38060 | 2020-04-06 | Washington | Wisconsin | 55131 | 57 | 3 |
40602 | 40602 | 2020-04-07 | Washington | Wisconsin | 55131 | 59 | 3 |
43174 | 43174 | 2020-04-08 | Washington | Wisconsin | 55131 | 62 | 3 |
45772 | 45772 | 2020-04-09 | Washington | Wisconsin | 55131 | 63 | 3 |
48401 | 48401 | 2020-04-10 | Washington | Wisconsin | 55131 | 67 | 3 |
51062 | 51062 | 2020-04-11 | Washington | Wisconsin | 55131 | 71 | 3 |
53739 | 53739 | 2020-04-12 | Washington | Wisconsin | 55131 | 71 | 3 |
56430 | 56430 | 2020-04-13 | Washington | Wisconsin | 55131 | 73 | 3 |
59138 | 59138 | 2020-04-14 | Washington | Wisconsin | 55131 | 73 | 3 |
61857 | 61857 | 2020-04-15 | Washington | Wisconsin | 55131 | 78 | 3 |
64590 | 64590 | 2020-04-16 | Washington | Wisconsin | 55131 | 79 | 3 |
67338 | 67338 | 2020-04-17 | Washington | Wisconsin | 55131 | 81 | 3 |
70100 | 70100 | 2020-04-18 | Washington | Wisconsin | 55131 | 82 | 3 |
72869 | 72869 | 2020-04-19 | Washington | Wisconsin | 55131 | 84 | 3 |
75645 | 75645 | 2020-04-20 | Washington | Wisconsin | 55131 | 86 | 3 |
78428 | 78428 | 2020-04-21 | Washington | Wisconsin | 55131 | 87 | 3 |
81221 | 81221 | 2020-04-22 | Washington | Wisconsin | 55131 | 88 | 4 |
84022 | 84022 | 2020-04-23 | Washington | Wisconsin | 55131 | 90 | 4 |
86830 | 86830 | 2020-04-24 | Washington | Wisconsin | 55131 | 91 | 4 |
89646 | 89646 | 2020-04-25 | Washington | Wisconsin | 55131 | 92 | 4 |
92464 | 92464 | 2020-04-26 | Washington | Wisconsin | 55131 | 92 | 4 |
95294 | 95294 | 2020-04-27 | Washington | Wisconsin | 55131 | 94 | 4 |
98139 | 98139 | 2020-04-28 | Washington | Wisconsin | 55131 | 96 | 4 |
100989 | 100989 | 2020-04-29 | Washington | Wisconsin | 55131 | 97 | 4 |
103844 | 103844 | 2020-04-30 | Washington | Wisconsin | 55131 | 98 | 4 |
106709 | 106709 | 2020-05-01 | Washington | Wisconsin | 55131 | 99 | 4 |
109578 | 109578 | 2020-05-02 | Washington | Wisconsin | 55131 | 100 | 4 |
112453 | 112453 | 2020-05-03 | Washington | Wisconsin | 55131 | 101 | 4 |
115336 | 115336 | 2020-05-04 | Washington | Wisconsin | 55131 | 104 | 4 |
118295 | 118295 | 2020-05-05 | Washington | Wisconsin | 55131 | 106 | 4 |
121261 | 121261 | 2020-05-06 | Washington | Wisconsin | 55131 | 107 | 4 |
124241 | 124241 | 2020-05-07 | Washington | Wisconsin | 55131 | 113 | 4 |
127226 | 127226 | 2020-05-08 | Washington | Wisconsin | 55131 | 114 | 4 |
130216 | 130216 | 2020-05-09 | Washington | Wisconsin | 55131 | 116 | 4 |
133206 | 133206 | 2020-05-10 | Washington | Wisconsin | 55131 | 117 | 4 |
136196 | 136196 | 2020-05-11 | Washington | Wisconsin | 55131 | 118 | 4 |
139187 | 139187 | 2020-05-12 | Washington | Wisconsin | 55131 | 119 | 4 |
142183 | 142183 | 2020-05-13 | Washington | Wisconsin | 55131 | 122 | 4 |
145182 | 145182 | 2020-05-14 | Washington | Wisconsin | 55131 | 125 | 4 |
148185 | 148185 | 2020-05-15 | Washington | Wisconsin | 55131 | 129 | 4 |
151194 | 151194 | 2020-05-16 | Washington | Wisconsin | 55131 | 140 | 4 |
154206 | 154206 | 2020-05-17 | Washington | Wisconsin | 55131 | 148 | 4 |
157222 | 157222 | 2020-05-18 | Washington | Wisconsin | 55131 | 149 | 4 |
160246 | 160246 | 2020-05-19 | Washington | Wisconsin | 55131 | 155 | 4 |
163274 | 163274 | 2020-05-20 | Washington | Wisconsin | 55131 | 163 | 4 |
166305 | 166305 | 2020-05-21 | Washington | Wisconsin | 55131 | 171 | 4 |
169341 | 169341 | 2020-05-22 | Washington | Wisconsin | 55131 | 178 | 4 |
172382 | 172382 | 2020-05-23 | Washington | Wisconsin | 55131 | 181 | 4 |
175425 | 175425 | 2020-05-24 | Washington | Wisconsin | 55131 | 193 | 4 |
178470 | 178470 | 2020-05-25 | Washington | Wisconsin | 55131 | 206 | 4 |
181514 | 181514 | 2020-05-26 | Washington | Wisconsin | 55131 | 209 | 4 |
184565 | 184565 | 2020-05-27 | Washington | Wisconsin | 55131 | 212 | 4 |
187622 | 187622 | 2020-05-28 | Washington | Wisconsin | 55131 | 233 | 4 |
190686 | 190686 | 2020-05-29 | Washington | Wisconsin | 55131 | 238 | 6 |
193752 | 193752 | 2020-05-30 | Washington | Wisconsin | 55131 | 248 | 7 |
196822 | 196822 | 2020-05-31 | Washington | Wisconsin | 55131 | 252 | 7 |
199895 | 199895 | 2020-06-01 | Washington | Wisconsin | 55131 | 257 | 7 |
202971 | 202971 | 2020-06-02 | Washington | Wisconsin | 55131 | 260 | 8 |
206050 | 206050 | 2020-06-03 | Washington | Wisconsin | 55131 | 261 | 9 |
209132 | 209132 | 2020-06-04 | Washington | Wisconsin | 55131 | 267 | 9 |
212217 | 212217 | 2020-06-05 | Washington | Wisconsin | 55131 | 272 | 9 |
215304 | 215304 | 2020-06-06 | Washington | Wisconsin | 55131 | 277 | 9 |
218394 | 218394 | 2020-06-07 | Washington | Wisconsin | 55131 | 277 | 9 |
221486 | 221486 | 2020-06-08 | Washington | Wisconsin | 55131 | 279 | 10 |
224582 | 224582 | 2020-06-09 | Washington | Wisconsin | 55131 | 281 | 10 |
227683 | 227683 | 2020-06-10 | Washington | Wisconsin | 55131 | 283 | 11 |
230787 | 230787 | 2020-06-11 | Washington | Wisconsin | 55131 | 287 | 12 |
233892 | 233892 | 2020-06-12 | Washington | Wisconsin | 55131 | 289 | 12 |
236999 | 236999 | 2020-06-13 | Washington | Wisconsin | 55131 | 290 | 12 |
240107 | 240107 | 2020-06-14 | Washington | Wisconsin | 55131 | 292 | 12 |
243218 | 243218 | 2020-06-15 | Washington | Wisconsin | 55131 | 294 | 12 |
246331 | 246331 | 2020-06-16 | Washington | Wisconsin | 55131 | 296 | 12 |
249443 | 249443 | 2020-06-17 | Washington | Wisconsin | 55131 | 301 | 12 |
252558 | 252558 | 2020-06-18 | Washington | Wisconsin | 55131 | 304 | 12 |
255677 | 255677 | 2020-06-19 | Washington | Wisconsin | 55131 | 311 | 13 |
258804 | 258804 | 2020-06-20 | Washington | Wisconsin | 55131 | 318 | 13 |
261931 | 261931 | 2020-06-21 | Washington | Wisconsin | 55131 | 321 | 13 |
265060 | 265060 | 2020-06-22 | Washington | Wisconsin | 55131 | 323 | 13 |
268189 | 268189 | 2020-06-23 | Washington | Wisconsin | 55131 | 327 | 14 |
271323 | 271323 | 2020-06-24 | Washington | Wisconsin | 55131 | 331 | 16 |
274463 | 274463 | 2020-06-25 | Washington | Wisconsin | 55131 | 335 | 16 |
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);