ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55021 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
280702 | 280702 | 2020-06-27 | Columbia | Wisconsin | 55021 | 79 | 1 |
283848 | 283848 | 2020-06-28 | Columbia | Wisconsin | 55021 | 80 | 1 |
286994 | 286994 | 2020-06-29 | Columbia | Wisconsin | 55021 | 83 | 1 |
290144 | 290144 | 2020-06-30 | Columbia | Wisconsin | 55021 | 85 | 1 |
293297 | 293297 | 2020-07-01 | Columbia | Wisconsin | 55021 | 88 | 1 |
296452 | 296452 | 2020-07-02 | Columbia | Wisconsin | 55021 | 89 | 1 |
299614 | 299614 | 2020-07-03 | Columbia | Wisconsin | 55021 | 91 | 1 |
302778 | 302778 | 2020-07-04 | Columbia | Wisconsin | 55021 | 94 | 1 |
305942 | 305942 | 2020-07-05 | Columbia | Wisconsin | 55021 | 101 | 1 |
309111 | 309111 | 2020-07-06 | Columbia | Wisconsin | 55021 | 101 | 1 |
312280 | 312280 | 2020-07-07 | Columbia | Wisconsin | 55021 | 104 | 1 |
315455 | 315455 | 2020-07-08 | Columbia | Wisconsin | 55021 | 105 | 1 |
318628 | 318628 | 2020-07-09 | Columbia | Wisconsin | 55021 | 110 | 1 |
321807 | 321807 | 2020-07-10 | Columbia | Wisconsin | 55021 | 113 | 1 |
324988 | 324988 | 2020-07-11 | Columbia | Wisconsin | 55021 | 116 | 1 |
328174 | 328174 | 2020-07-12 | Columbia | Wisconsin | 55021 | 120 | 1 |
331360 | 331360 | 2020-07-13 | Columbia | Wisconsin | 55021 | 123 | 1 |
334553 | 334553 | 2020-07-14 | Columbia | Wisconsin | 55021 | 125 | 1 |
337748 | 337748 | 2020-07-15 | Columbia | Wisconsin | 55021 | 129 | 1 |
340944 | 340944 | 2020-07-16 | Columbia | Wisconsin | 55021 | 131 | 1 |
344143 | 344143 | 2020-07-17 | Columbia | Wisconsin | 55021 | 141 | 1 |
347343 | 347343 | 2020-07-18 | Columbia | Wisconsin | 55021 | 150 | 1 |
350544 | 350544 | 2020-07-19 | Columbia | Wisconsin | 55021 | 154 | 1 |
353746 | 353746 | 2020-07-20 | Columbia | Wisconsin | 55021 | 159 | 1 |
356949 | 356949 | 2020-07-21 | Columbia | Wisconsin | 55021 | 166 | 1 |
360154 | 360154 | 2020-07-22 | Columbia | Wisconsin | 55021 | 171 | 1 |
363360 | 363360 | 2020-07-23 | Columbia | Wisconsin | 55021 | 173 | 1 |
366567 | 366567 | 2020-07-24 | Columbia | Wisconsin | 55021 | 181 | 1 |
369777 | 369777 | 2020-07-25 | Columbia | Wisconsin | 55021 | 187 | 1 |
372989 | 372989 | 2020-07-26 | Columbia | Wisconsin | 55021 | 195 | 1 |
376203 | 376203 | 2020-07-27 | Columbia | Wisconsin | 55021 | 196 | 1 |
379419 | 379419 | 2020-07-28 | Columbia | Wisconsin | 55021 | 198 | 1 |
382636 | 382636 | 2020-07-29 | Columbia | Wisconsin | 55021 | 204 | 1 |
385854 | 385854 | 2020-07-30 | Columbia | Wisconsin | 55021 | 210 | 1 |
389071 | 389071 | 2020-07-31 | Columbia | Wisconsin | 55021 | 213 | 1 |
392288 | 392288 | 2020-08-01 | Columbia | Wisconsin | 55021 | 219 | 1 |
395504 | 395504 | 2020-08-02 | Columbia | Wisconsin | 55021 | 224 | 1 |
398720 | 398720 | 2020-08-03 | Columbia | Wisconsin | 55021 | 227 | 1 |
401936 | 401936 | 2020-08-04 | Columbia | Wisconsin | 55021 | 228 | 1 |
405154 | 405154 | 2020-08-05 | Columbia | Wisconsin | 55021 | 233 | 1 |
408374 | 408374 | 2020-08-06 | Columbia | Wisconsin | 55021 | 238 | 1 |
411593 | 411593 | 2020-08-07 | Columbia | Wisconsin | 55021 | 241 | 1 |
414813 | 414813 | 2020-08-08 | Columbia | Wisconsin | 55021 | 245 | 1 |
418034 | 418034 | 2020-08-09 | Columbia | Wisconsin | 55021 | 248 | 1 |
421255 | 421255 | 2020-08-10 | Columbia | Wisconsin | 55021 | 252 | 1 |
424476 | 424476 | 2020-08-11 | Columbia | Wisconsin | 55021 | 255 | 2 |
427700 | 427700 | 2020-08-12 | Columbia | Wisconsin | 55021 | 273 | 2 |
430928 | 430928 | 2020-08-13 | Columbia | Wisconsin | 55021 | 274 | 2 |
434153 | 434153 | 2020-08-14 | Columbia | Wisconsin | 55021 | 279 | 2 |
437379 | 437379 | 2020-08-15 | Columbia | Wisconsin | 55021 | 287 | 2 |
440605 | 440605 | 2020-08-16 | Columbia | Wisconsin | 55021 | 288 | 2 |
443831 | 443831 | 2020-08-17 | Columbia | Wisconsin | 55021 | 291 | 2 |
447058 | 447058 | 2020-08-18 | Columbia | Wisconsin | 55021 | 292 | 2 |
450286 | 450286 | 2020-08-19 | Columbia | Wisconsin | 55021 | 297 | 2 |
453514 | 453514 | 2020-08-20 | Columbia | Wisconsin | 55021 | 307 | 2 |
456742 | 456742 | 2020-08-21 | Columbia | Wisconsin | 55021 | 310 | 2 |
459969 | 459969 | 2020-08-22 | Columbia | Wisconsin | 55021 | 314 | 2 |
463198 | 463198 | 2020-08-23 | Columbia | Wisconsin | 55021 | 319 | 2 |
466427 | 466427 | 2020-08-24 | Columbia | Wisconsin | 55021 | 326 | 2 |
469656 | 469656 | 2020-08-25 | Columbia | Wisconsin | 55021 | 329 | 2 |
472888 | 472888 | 2020-08-26 | Columbia | Wisconsin | 55021 | 334 | 2 |
476121 | 476121 | 2020-08-27 | Columbia | Wisconsin | 55021 | 340 | 2 |
479354 | 479354 | 2020-08-28 | Columbia | Wisconsin | 55021 | 344 | 2 |
482588 | 482588 | 2020-08-29 | Columbia | Wisconsin | 55021 | 349 | 2 |
485823 | 485823 | 2020-08-30 | Columbia | Wisconsin | 55021 | 351 | 2 |
489056 | 489056 | 2020-08-31 | Columbia | Wisconsin | 55021 | 351 | 2 |
492289 | 492289 | 2020-09-01 | Columbia | Wisconsin | 55021 | 361 | 2 |
495523 | 495523 | 2020-09-02 | Columbia | Wisconsin | 55021 | 366 | 2 |
498756 | 498756 | 2020-09-03 | Columbia | Wisconsin | 55021 | 369 | 2 |
501990 | 501990 | 2020-09-04 | Columbia | Wisconsin | 55021 | 414 | 2 |
505224 | 505224 | 2020-09-05 | Columbia | Wisconsin | 55021 | 419 | 2 |
508456 | 508456 | 2020-09-06 | Columbia | Wisconsin | 55021 | 426 | 2 |
511689 | 511689 | 2020-09-07 | Columbia | Wisconsin | 55021 | 431 | 2 |
514922 | 514922 | 2020-09-08 | Columbia | Wisconsin | 55021 | 435 | 2 |
518157 | 518157 | 2020-09-09 | Columbia | Wisconsin | 55021 | 442 | 2 |
521394 | 521394 | 2020-09-10 | Columbia | Wisconsin | 55021 | 453 | 2 |
524630 | 524630 | 2020-09-11 | Columbia | Wisconsin | 55021 | 455 | 2 |
527866 | 527866 | 2020-09-12 | Columbia | Wisconsin | 55021 | 460 | 2 |
531103 | 531103 | 2020-09-13 | Columbia | Wisconsin | 55021 | 475 | 2 |
534338 | 534338 | 2020-09-14 | Columbia | Wisconsin | 55021 | 478 | 2 |
537574 | 537574 | 2020-09-15 | Columbia | Wisconsin | 55021 | 489 | 2 |
540811 | 540811 | 2020-09-16 | Columbia | Wisconsin | 55021 | 498 | 2 |
544047 | 544047 | 2020-09-17 | Columbia | Wisconsin | 55021 | 515 | 2 |
547284 | 547284 | 2020-09-18 | Columbia | Wisconsin | 55021 | 524 | 2 |
550523 | 550523 | 2020-09-19 | Columbia | Wisconsin | 55021 | 538 | 2 |
553762 | 553762 | 2020-09-20 | Columbia | Wisconsin | 55021 | 551 | 2 |
556999 | 556999 | 2020-09-21 | Columbia | Wisconsin | 55021 | 559 | 2 |
560235 | 560235 | 2020-09-22 | Columbia | Wisconsin | 55021 | 577 | 2 |
563474 | 563474 | 2020-09-23 | Columbia | Wisconsin | 55021 | 597 | 2 |
566715 | 566715 | 2020-09-24 | Columbia | Wisconsin | 55021 | 606 | 2 |
569956 | 569956 | 2020-09-25 | Columbia | Wisconsin | 55021 | 622 | 2 |
573198 | 573198 | 2020-09-26 | Columbia | Wisconsin | 55021 | 652 | 2 |
576442 | 576442 | 2020-09-27 | Columbia | Wisconsin | 55021 | 670 | 2 |
579683 | 579683 | 2020-09-28 | Columbia | Wisconsin | 55021 | 692 | 2 |
582922 | 582922 | 2020-09-29 | Columbia | Wisconsin | 55021 | 705 | 3 |
586162 | 586162 | 2020-09-30 | Columbia | Wisconsin | 55021 | 728 | 3 |
589403 | 589403 | 2020-10-01 | Columbia | Wisconsin | 55021 | 749 | 3 |
592643 | 592643 | 2020-10-02 | Columbia | Wisconsin | 55021 | 789 | 3 |
595885 | 595885 | 2020-10-03 | Columbia | Wisconsin | 55021 | 841 | 3 |
599128 | 599128 | 2020-10-04 | Columbia | Wisconsin | 55021 | 878 | 3 |
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);