ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Clark" and fips = 55019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537573 | 537573 | 2020-09-15 | Clark | Wisconsin | 55019 | 324 | 8 |
534337 | 534337 | 2020-09-14 | Clark | Wisconsin | 55019 | 316 | 8 |
531102 | 531102 | 2020-09-13 | Clark | Wisconsin | 55019 | 312 | 8 |
527865 | 527865 | 2020-09-12 | Clark | Wisconsin | 55019 | 303 | 8 |
524629 | 524629 | 2020-09-11 | Clark | Wisconsin | 55019 | 296 | 8 |
521393 | 521393 | 2020-09-10 | Clark | Wisconsin | 55019 | 280 | 8 |
518156 | 518156 | 2020-09-09 | Clark | Wisconsin | 55019 | 277 | 8 |
514921 | 514921 | 2020-09-08 | Clark | Wisconsin | 55019 | 274 | 8 |
511688 | 511688 | 2020-09-07 | Clark | Wisconsin | 55019 | 274 | 8 |
508455 | 508455 | 2020-09-06 | Clark | Wisconsin | 55019 | 273 | 8 |
505223 | 505223 | 2020-09-05 | Clark | Wisconsin | 55019 | 269 | 8 |
501989 | 501989 | 2020-09-04 | Clark | Wisconsin | 55019 | 267 | 8 |
498755 | 498755 | 2020-09-03 | Clark | Wisconsin | 55019 | 248 | 8 |
495522 | 495522 | 2020-09-02 | Clark | Wisconsin | 55019 | 247 | 8 |
492288 | 492288 | 2020-09-01 | Clark | Wisconsin | 55019 | 246 | 8 |
489055 | 489055 | 2020-08-31 | Clark | Wisconsin | 55019 | 241 | 8 |
485822 | 485822 | 2020-08-30 | Clark | Wisconsin | 55019 | 240 | 8 |
482587 | 482587 | 2020-08-29 | Clark | Wisconsin | 55019 | 239 | 8 |
479353 | 479353 | 2020-08-28 | Clark | Wisconsin | 55019 | 236 | 8 |
476120 | 476120 | 2020-08-27 | Clark | Wisconsin | 55019 | 236 | 8 |
472887 | 472887 | 2020-08-26 | Clark | Wisconsin | 55019 | 234 | 8 |
469655 | 469655 | 2020-08-25 | Clark | Wisconsin | 55019 | 230 | 8 |
466426 | 466426 | 2020-08-24 | Clark | Wisconsin | 55019 | 230 | 8 |
463197 | 463197 | 2020-08-23 | Clark | Wisconsin | 55019 | 228 | 8 |
459968 | 459968 | 2020-08-22 | Clark | Wisconsin | 55019 | 224 | 8 |
456741 | 456741 | 2020-08-21 | Clark | Wisconsin | 55019 | 211 | 8 |
453513 | 453513 | 2020-08-20 | Clark | Wisconsin | 55019 | 206 | 8 |
450285 | 450285 | 2020-08-19 | Clark | Wisconsin | 55019 | 202 | 8 |
447057 | 447057 | 2020-08-18 | Clark | Wisconsin | 55019 | 200 | 8 |
443830 | 443830 | 2020-08-17 | Clark | Wisconsin | 55019 | 200 | 8 |
440604 | 440604 | 2020-08-16 | Clark | Wisconsin | 55019 | 197 | 8 |
437378 | 437378 | 2020-08-15 | Clark | Wisconsin | 55019 | 195 | 8 |
434152 | 434152 | 2020-08-14 | Clark | Wisconsin | 55019 | 196 | 8 |
430927 | 430927 | 2020-08-13 | Clark | Wisconsin | 55019 | 191 | 8 |
427699 | 427699 | 2020-08-12 | Clark | Wisconsin | 55019 | 190 | 8 |
424475 | 424475 | 2020-08-11 | Clark | Wisconsin | 55019 | 189 | 8 |
421254 | 421254 | 2020-08-10 | Clark | Wisconsin | 55019 | 188 | 7 |
418033 | 418033 | 2020-08-09 | Clark | Wisconsin | 55019 | 184 | 7 |
414812 | 414812 | 2020-08-08 | Clark | Wisconsin | 55019 | 183 | 7 |
411592 | 411592 | 2020-08-07 | Clark | Wisconsin | 55019 | 183 | 7 |
408373 | 408373 | 2020-08-06 | Clark | Wisconsin | 55019 | 180 | 7 |
405153 | 405153 | 2020-08-05 | Clark | Wisconsin | 55019 | 179 | 7 |
401935 | 401935 | 2020-08-04 | Clark | Wisconsin | 55019 | 179 | 7 |
398719 | 398719 | 2020-08-03 | Clark | Wisconsin | 55019 | 177 | 7 |
395503 | 395503 | 2020-08-02 | Clark | Wisconsin | 55019 | 174 | 7 |
392287 | 392287 | 2020-08-01 | Clark | Wisconsin | 55019 | 173 | 7 |
389070 | 389070 | 2020-07-31 | Clark | Wisconsin | 55019 | 168 | 7 |
385853 | 385853 | 2020-07-30 | Clark | Wisconsin | 55019 | 167 | 7 |
382635 | 382635 | 2020-07-29 | Clark | Wisconsin | 55019 | 166 | 7 |
379418 | 379418 | 2020-07-28 | Clark | Wisconsin | 55019 | 161 | 7 |
376202 | 376202 | 2020-07-27 | Clark | Wisconsin | 55019 | 158 | 7 |
372988 | 372988 | 2020-07-26 | Clark | Wisconsin | 55019 | 157 | 7 |
369776 | 369776 | 2020-07-25 | Clark | Wisconsin | 55019 | 156 | 7 |
366566 | 366566 | 2020-07-24 | Clark | Wisconsin | 55019 | 154 | 7 |
363359 | 363359 | 2020-07-23 | Clark | Wisconsin | 55019 | 152 | 7 |
360153 | 360153 | 2020-07-22 | Clark | Wisconsin | 55019 | 147 | 7 |
356948 | 356948 | 2020-07-21 | Clark | Wisconsin | 55019 | 142 | 7 |
353745 | 353745 | 2020-07-20 | Clark | Wisconsin | 55019 | 141 | 7 |
350543 | 350543 | 2020-07-19 | Clark | Wisconsin | 55019 | 139 | 7 |
347342 | 347342 | 2020-07-18 | Clark | Wisconsin | 55019 | 132 | 7 |
344142 | 344142 | 2020-07-17 | Clark | Wisconsin | 55019 | 130 | 7 |
340943 | 340943 | 2020-07-16 | Clark | Wisconsin | 55019 | 128 | 7 |
337747 | 337747 | 2020-07-15 | Clark | Wisconsin | 55019 | 121 | 7 |
334552 | 334552 | 2020-07-14 | Clark | Wisconsin | 55019 | 118 | 7 |
331359 | 331359 | 2020-07-13 | Clark | Wisconsin | 55019 | 111 | 7 |
328173 | 328173 | 2020-07-12 | Clark | Wisconsin | 55019 | 101 | 7 |
324987 | 324987 | 2020-07-11 | Clark | Wisconsin | 55019 | 99 | 7 |
321806 | 321806 | 2020-07-10 | Clark | Wisconsin | 55019 | 98 | 7 |
318627 | 318627 | 2020-07-09 | Clark | Wisconsin | 55019 | 93 | 7 |
315454 | 315454 | 2020-07-08 | Clark | Wisconsin | 55019 | 88 | 7 |
312279 | 312279 | 2020-07-07 | Clark | Wisconsin | 55019 | 87 | 7 |
309110 | 309110 | 2020-07-06 | Clark | Wisconsin | 55019 | 87 | 7 |
305941 | 305941 | 2020-07-05 | Clark | Wisconsin | 55019 | 87 | 7 |
302777 | 302777 | 2020-07-04 | Clark | Wisconsin | 55019 | 86 | 7 |
299613 | 299613 | 2020-07-03 | Clark | Wisconsin | 55019 | 82 | 7 |
296451 | 296451 | 2020-07-02 | Clark | Wisconsin | 55019 | 81 | 7 |
293296 | 293296 | 2020-07-01 | Clark | Wisconsin | 55019 | 77 | 6 |
290143 | 290143 | 2020-06-30 | Clark | Wisconsin | 55019 | 72 | 6 |
286993 | 286993 | 2020-06-29 | Clark | Wisconsin | 55019 | 70 | 6 |
283847 | 283847 | 2020-06-28 | Clark | Wisconsin | 55019 | 70 | 6 |
280701 | 280701 | 2020-06-27 | Clark | Wisconsin | 55019 | 69 | 6 |
277553 | 277553 | 2020-06-26 | Clark | Wisconsin | 55019 | 67 | 6 |
274405 | 274405 | 2020-06-25 | Clark | Wisconsin | 55019 | 64 | 6 |
271265 | 271265 | 2020-06-24 | Clark | Wisconsin | 55019 | 64 | 6 |
268131 | 268131 | 2020-06-23 | Clark | Wisconsin | 55019 | 60 | 6 |
265002 | 265002 | 2020-06-22 | Clark | Wisconsin | 55019 | 60 | 6 |
261873 | 261873 | 2020-06-21 | Clark | Wisconsin | 55019 | 58 | 6 |
258746 | 258746 | 2020-06-20 | Clark | Wisconsin | 55019 | 58 | 6 |
255619 | 255619 | 2020-06-19 | Clark | Wisconsin | 55019 | 56 | 6 |
252500 | 252500 | 2020-06-18 | Clark | Wisconsin | 55019 | 56 | 5 |
249385 | 249385 | 2020-06-17 | Clark | Wisconsin | 55019 | 53 | 4 |
246273 | 246273 | 2020-06-16 | Clark | Wisconsin | 55019 | 51 | 4 |
243160 | 243160 | 2020-06-15 | Clark | Wisconsin | 55019 | 51 | 4 |
240049 | 240049 | 2020-06-14 | Clark | Wisconsin | 55019 | 50 | 4 |
236941 | 236941 | 2020-06-13 | Clark | Wisconsin | 55019 | 50 | 4 |
233834 | 233834 | 2020-06-12 | Clark | Wisconsin | 55019 | 50 | 4 |
230729 | 230729 | 2020-06-11 | Clark | Wisconsin | 55019 | 45 | 4 |
227625 | 227625 | 2020-06-10 | Clark | Wisconsin | 55019 | 45 | 4 |
224525 | 224525 | 2020-06-09 | Clark | Wisconsin | 55019 | 45 | 4 |
221429 | 221429 | 2020-06-08 | Clark | Wisconsin | 55019 | 42 | 4 |
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);