ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walworth" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
334608 | 334608 | 2020-07-14 | Walworth | Wisconsin | 55127 | 800 | 18 |
331415 | 331415 | 2020-07-13 | Walworth | Wisconsin | 55127 | 791 | 18 |
328229 | 328229 | 2020-07-12 | Walworth | Wisconsin | 55127 | 754 | 18 |
325043 | 325043 | 2020-07-11 | Walworth | Wisconsin | 55127 | 752 | 18 |
321862 | 321862 | 2020-07-10 | Walworth | Wisconsin | 55127 | 734 | 18 |
318683 | 318683 | 2020-07-09 | Walworth | Wisconsin | 55127 | 723 | 18 |
315510 | 315510 | 2020-07-08 | Walworth | Wisconsin | 55127 | 713 | 18 |
312335 | 312335 | 2020-07-07 | Walworth | Wisconsin | 55127 | 701 | 18 |
309166 | 309166 | 2020-07-06 | Walworth | Wisconsin | 55127 | 691 | 18 |
305997 | 305997 | 2020-07-05 | Walworth | Wisconsin | 55127 | 689 | 18 |
302833 | 302833 | 2020-07-04 | Walworth | Wisconsin | 55127 | 677 | 18 |
299669 | 299669 | 2020-07-03 | Walworth | Wisconsin | 55127 | 650 | 18 |
296507 | 296507 | 2020-07-02 | Walworth | Wisconsin | 55127 | 622 | 18 |
293352 | 293352 | 2020-07-01 | Walworth | Wisconsin | 55127 | 612 | 18 |
290199 | 290199 | 2020-06-30 | Walworth | Wisconsin | 55127 | 607 | 18 |
287049 | 287049 | 2020-06-29 | Walworth | Wisconsin | 55127 | 574 | 18 |
283903 | 283903 | 2020-06-28 | Walworth | Wisconsin | 55127 | 572 | 18 |
280757 | 280757 | 2020-06-27 | Walworth | Wisconsin | 55127 | 570 | 18 |
277609 | 277609 | 2020-06-26 | Walworth | Wisconsin | 55127 | 559 | 18 |
274461 | 274461 | 2020-06-25 | Walworth | Wisconsin | 55127 | 546 | 18 |
271321 | 271321 | 2020-06-24 | Walworth | Wisconsin | 55127 | 522 | 18 |
268187 | 268187 | 2020-06-23 | Walworth | Wisconsin | 55127 | 509 | 18 |
265058 | 265058 | 2020-06-22 | Walworth | Wisconsin | 55127 | 498 | 18 |
261929 | 261929 | 2020-06-21 | Walworth | Wisconsin | 55127 | 498 | 18 |
258802 | 258802 | 2020-06-20 | Walworth | Wisconsin | 55127 | 497 | 18 |
255675 | 255675 | 2020-06-19 | Walworth | Wisconsin | 55127 | 488 | 18 |
252556 | 252556 | 2020-06-18 | Walworth | Wisconsin | 55127 | 487 | 17 |
249441 | 249441 | 2020-06-17 | Walworth | Wisconsin | 55127 | 481 | 17 |
246329 | 246329 | 2020-06-16 | Walworth | Wisconsin | 55127 | 480 | 17 |
243216 | 243216 | 2020-06-15 | Walworth | Wisconsin | 55127 | 471 | 17 |
240105 | 240105 | 2020-06-14 | Walworth | Wisconsin | 55127 | 471 | 17 |
236997 | 236997 | 2020-06-13 | Walworth | Wisconsin | 55127 | 471 | 17 |
233890 | 233890 | 2020-06-12 | Walworth | Wisconsin | 55127 | 469 | 17 |
230785 | 230785 | 2020-06-11 | Walworth | Wisconsin | 55127 | 468 | 17 |
227681 | 227681 | 2020-06-10 | Walworth | Wisconsin | 55127 | 456 | 17 |
224580 | 224580 | 2020-06-09 | Walworth | Wisconsin | 55127 | 452 | 17 |
221484 | 221484 | 2020-06-08 | Walworth | Wisconsin | 55127 | 440 | 17 |
218392 | 218392 | 2020-06-07 | Walworth | Wisconsin | 55127 | 435 | 17 |
215302 | 215302 | 2020-06-06 | Walworth | Wisconsin | 55127 | 435 | 17 |
212215 | 212215 | 2020-06-05 | Walworth | Wisconsin | 55127 | 428 | 17 |
209130 | 209130 | 2020-06-04 | Walworth | Wisconsin | 55127 | 424 | 17 |
206048 | 206048 | 2020-06-03 | Walworth | Wisconsin | 55127 | 424 | 17 |
202969 | 202969 | 2020-06-02 | Walworth | Wisconsin | 55127 | 398 | 17 |
199893 | 199893 | 2020-06-01 | Walworth | Wisconsin | 55127 | 397 | 17 |
196820 | 196820 | 2020-05-31 | Walworth | Wisconsin | 55127 | 395 | 17 |
193750 | 193750 | 2020-05-30 | Walworth | Wisconsin | 55127 | 392 | 17 |
190684 | 190684 | 2020-05-29 | Walworth | Wisconsin | 55127 | 379 | 17 |
187620 | 187620 | 2020-05-28 | Walworth | Wisconsin | 55127 | 372 | 16 |
184563 | 184563 | 2020-05-27 | Walworth | Wisconsin | 55127 | 363 | 16 |
181512 | 181512 | 2020-05-26 | Walworth | Wisconsin | 55127 | 351 | 13 |
178468 | 178468 | 2020-05-25 | Walworth | Wisconsin | 55127 | 351 | 13 |
175423 | 175423 | 2020-05-24 | Walworth | Wisconsin | 55127 | 348 | 13 |
172380 | 172380 | 2020-05-23 | Walworth | Wisconsin | 55127 | 339 | 12 |
169339 | 169339 | 2020-05-22 | Walworth | Wisconsin | 55127 | 329 | 11 |
166303 | 166303 | 2020-05-21 | Walworth | Wisconsin | 55127 | 316 | 11 |
163272 | 163272 | 2020-05-20 | Walworth | Wisconsin | 55127 | 296 | 11 |
160244 | 160244 | 2020-05-19 | Walworth | Wisconsin | 55127 | 287 | 11 |
157220 | 157220 | 2020-05-18 | Walworth | Wisconsin | 55127 | 284 | 12 |
154204 | 154204 | 2020-05-17 | Walworth | Wisconsin | 55127 | 280 | 12 |
151192 | 151192 | 2020-05-16 | Walworth | Wisconsin | 55127 | 277 | 12 |
148183 | 148183 | 2020-05-15 | Walworth | Wisconsin | 55127 | 269 | 11 |
145180 | 145180 | 2020-05-14 | Walworth | Wisconsin | 55127 | 251 | 11 |
142181 | 142181 | 2020-05-13 | Walworth | Wisconsin | 55127 | 243 | 11 |
139185 | 139185 | 2020-05-12 | Walworth | Wisconsin | 55127 | 244 | 11 |
136194 | 136194 | 2020-05-11 | Walworth | Wisconsin | 55127 | 240 | 10 |
133204 | 133204 | 2020-05-10 | Walworth | Wisconsin | 55127 | 235 | 10 |
130214 | 130214 | 2020-05-09 | Walworth | Wisconsin | 55127 | 229 | 10 |
127224 | 127224 | 2020-05-08 | Walworth | Wisconsin | 55127 | 226 | 10 |
124239 | 124239 | 2020-05-07 | Walworth | Wisconsin | 55127 | 226 | 9 |
121259 | 121259 | 2020-05-06 | Walworth | Wisconsin | 55127 | 215 | 9 |
118293 | 118293 | 2020-05-05 | Walworth | Wisconsin | 55127 | 212 | 8 |
115334 | 115334 | 2020-05-04 | Walworth | Wisconsin | 55127 | 211 | 8 |
112451 | 112451 | 2020-05-03 | Walworth | Wisconsin | 55127 | 197 | 8 |
109576 | 109576 | 2020-05-02 | Walworth | Wisconsin | 55127 | 183 | 8 |
106707 | 106707 | 2020-05-01 | Walworth | Wisconsin | 55127 | 171 | 8 |
103842 | 103842 | 2020-04-30 | Walworth | Wisconsin | 55127 | 161 | 8 |
100987 | 100987 | 2020-04-29 | Walworth | Wisconsin | 55127 | 156 | 8 |
98137 | 98137 | 2020-04-28 | Walworth | Wisconsin | 55127 | 139 | 8 |
95292 | 95292 | 2020-04-27 | Walworth | Wisconsin | 55127 | 138 | 8 |
92462 | 92462 | 2020-04-26 | Walworth | Wisconsin | 55127 | 135 | 8 |
89644 | 89644 | 2020-04-25 | Walworth | Wisconsin | 55127 | 132 | 8 |
86828 | 86828 | 2020-04-24 | Walworth | Wisconsin | 55127 | 113 | 7 |
84020 | 84020 | 2020-04-23 | Walworth | Wisconsin | 55127 | 100 | 7 |
81219 | 81219 | 2020-04-22 | Walworth | Wisconsin | 55127 | 94 | 7 |
78426 | 78426 | 2020-04-21 | Walworth | Wisconsin | 55127 | 90 | 7 |
75643 | 75643 | 2020-04-20 | Walworth | Wisconsin | 55127 | 86 | 6 |
72867 | 72867 | 2020-04-19 | Walworth | Wisconsin | 55127 | 89 | 6 |
70098 | 70098 | 2020-04-18 | Walworth | Wisconsin | 55127 | 89 | 4 |
67336 | 67336 | 2020-04-17 | Walworth | Wisconsin | 55127 | 75 | 3 |
64588 | 64588 | 2020-04-16 | Walworth | Wisconsin | 55127 | 71 | 3 |
61855 | 61855 | 2020-04-15 | Walworth | Wisconsin | 55127 | 49 | 2 |
59136 | 59136 | 2020-04-14 | Walworth | Wisconsin | 55127 | 45 | 1 |
56429 | 56429 | 2020-04-13 | Walworth | Wisconsin | 55127 | 38 | 0 |
53738 | 53738 | 2020-04-12 | Walworth | Wisconsin | 55127 | 37 | 0 |
51061 | 51061 | 2020-04-11 | Walworth | Wisconsin | 55127 | 35 | 0 |
48400 | 48400 | 2020-04-10 | Walworth | Wisconsin | 55127 | 35 | 0 |
45771 | 45771 | 2020-04-09 | Walworth | Wisconsin | 55127 | 28 | 0 |
43173 | 43173 | 2020-04-08 | Walworth | Wisconsin | 55127 | 23 | 0 |
40601 | 40601 | 2020-04-07 | Walworth | Wisconsin | 55127 | 21 | 0 |
38059 | 38059 | 2020-04-06 | Walworth | Wisconsin | 55127 | 20 | 0 |
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);