ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55021 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732119 | 732119 | 2020-11-14 | Columbia | Wisconsin | 55021 | 2790 | 11 |
728874 | 728874 | 2020-11-13 | Columbia | Wisconsin | 55021 | 2755 | 10 |
725631 | 725631 | 2020-11-12 | Columbia | Wisconsin | 55021 | 2706 | 10 |
722388 | 722388 | 2020-11-11 | Columbia | Wisconsin | 55021 | 2652 | 10 |
719145 | 719145 | 2020-11-10 | Columbia | Wisconsin | 55021 | 2574 | 10 |
715902 | 715902 | 2020-11-09 | Columbia | Wisconsin | 55021 | 2496 | 10 |
712658 | 712658 | 2020-11-08 | Columbia | Wisconsin | 55021 | 2437 | 10 |
709414 | 709414 | 2020-11-07 | Columbia | Wisconsin | 55021 | 2392 | 10 |
706170 | 706170 | 2020-11-06 | Columbia | Wisconsin | 55021 | 2292 | 8 |
702927 | 702927 | 2020-11-05 | Columbia | Wisconsin | 55021 | 2236 | 8 |
699684 | 699684 | 2020-11-04 | Columbia | Wisconsin | 55021 | 2198 | 8 |
696440 | 696440 | 2020-11-03 | Columbia | Wisconsin | 55021 | 2165 | 8 |
693198 | 693198 | 2020-11-02 | Columbia | Wisconsin | 55021 | 2116 | 7 |
689954 | 689954 | 2020-11-01 | Columbia | Wisconsin | 55021 | 2087 | 7 |
686709 | 686709 | 2020-10-31 | Columbia | Wisconsin | 55021 | 2051 | 7 |
683466 | 683466 | 2020-10-30 | Columbia | Wisconsin | 55021 | 2001 | 7 |
680223 | 680223 | 2020-10-29 | Columbia | Wisconsin | 55021 | 1953 | 7 |
676980 | 676980 | 2020-10-28 | Columbia | Wisconsin | 55021 | 1919 | 6 |
673737 | 673737 | 2020-10-27 | Columbia | Wisconsin | 55021 | 1883 | 5 |
670495 | 670495 | 2020-10-26 | Columbia | Wisconsin | 55021 | 1808 | 5 |
667252 | 667252 | 2020-10-25 | Columbia | Wisconsin | 55021 | 1782 | 5 |
664007 | 664007 | 2020-10-24 | Columbia | Wisconsin | 55021 | 1741 | 5 |
660763 | 660763 | 2020-10-23 | Columbia | Wisconsin | 55021 | 1691 | 5 |
657519 | 657519 | 2020-10-22 | Columbia | Wisconsin | 55021 | 1654 | 5 |
654274 | 654274 | 2020-10-21 | Columbia | Wisconsin | 55021 | 1595 | 4 |
651029 | 651029 | 2020-10-20 | Columbia | Wisconsin | 55021 | 1564 | 4 |
647785 | 647785 | 2020-10-19 | Columbia | Wisconsin | 55021 | 1524 | 4 |
644539 | 644539 | 2020-10-18 | Columbia | Wisconsin | 55021 | 1379 | 4 |
641291 | 641291 | 2020-10-17 | Columbia | Wisconsin | 55021 | 1379 | 4 |
638044 | 638044 | 2020-10-16 | Columbia | Wisconsin | 55021 | 1379 | 4 |
634799 | 634799 | 2020-10-15 | Columbia | Wisconsin | 55021 | 1325 | 4 |
631554 | 631554 | 2020-10-14 | Columbia | Wisconsin | 55021 | 1287 | 4 |
628310 | 628310 | 2020-10-13 | Columbia | Wisconsin | 55021 | 1231 | 3 |
625067 | 625067 | 2020-10-12 | Columbia | Wisconsin | 55021 | 1197 | 3 |
621824 | 621824 | 2020-10-11 | Columbia | Wisconsin | 55021 | 1160 | 3 |
618581 | 618581 | 2020-10-10 | Columbia | Wisconsin | 55021 | 1113 | 3 |
615339 | 615339 | 2020-10-09 | Columbia | Wisconsin | 55021 | 1076 | 3 |
612098 | 612098 | 2020-10-08 | Columbia | Wisconsin | 55021 | 1041 | 3 |
608856 | 608856 | 2020-10-07 | Columbia | Wisconsin | 55021 | 1001 | 3 |
605613 | 605613 | 2020-10-06 | Columbia | Wisconsin | 55021 | 916 | 3 |
602371 | 602371 | 2020-10-05 | Columbia | Wisconsin | 55021 | 900 | 3 |
599128 | 599128 | 2020-10-04 | Columbia | Wisconsin | 55021 | 878 | 3 |
595885 | 595885 | 2020-10-03 | Columbia | Wisconsin | 55021 | 841 | 3 |
592643 | 592643 | 2020-10-02 | Columbia | Wisconsin | 55021 | 789 | 3 |
589403 | 589403 | 2020-10-01 | Columbia | Wisconsin | 55021 | 749 | 3 |
586162 | 586162 | 2020-09-30 | Columbia | Wisconsin | 55021 | 728 | 3 |
582922 | 582922 | 2020-09-29 | Columbia | Wisconsin | 55021 | 705 | 3 |
579683 | 579683 | 2020-09-28 | Columbia | Wisconsin | 55021 | 692 | 2 |
576442 | 576442 | 2020-09-27 | Columbia | Wisconsin | 55021 | 670 | 2 |
573198 | 573198 | 2020-09-26 | Columbia | Wisconsin | 55021 | 652 | 2 |
569956 | 569956 | 2020-09-25 | Columbia | Wisconsin | 55021 | 622 | 2 |
566715 | 566715 | 2020-09-24 | Columbia | Wisconsin | 55021 | 606 | 2 |
563474 | 563474 | 2020-09-23 | Columbia | Wisconsin | 55021 | 597 | 2 |
560235 | 560235 | 2020-09-22 | Columbia | Wisconsin | 55021 | 577 | 2 |
556999 | 556999 | 2020-09-21 | Columbia | Wisconsin | 55021 | 559 | 2 |
553762 | 553762 | 2020-09-20 | Columbia | Wisconsin | 55021 | 551 | 2 |
550523 | 550523 | 2020-09-19 | Columbia | Wisconsin | 55021 | 538 | 2 |
547284 | 547284 | 2020-09-18 | Columbia | Wisconsin | 55021 | 524 | 2 |
544047 | 544047 | 2020-09-17 | Columbia | Wisconsin | 55021 | 515 | 2 |
540811 | 540811 | 2020-09-16 | Columbia | Wisconsin | 55021 | 498 | 2 |
537574 | 537574 | 2020-09-15 | Columbia | Wisconsin | 55021 | 489 | 2 |
534338 | 534338 | 2020-09-14 | Columbia | Wisconsin | 55021 | 478 | 2 |
531103 | 531103 | 2020-09-13 | Columbia | Wisconsin | 55021 | 475 | 2 |
527866 | 527866 | 2020-09-12 | Columbia | Wisconsin | 55021 | 460 | 2 |
524630 | 524630 | 2020-09-11 | Columbia | Wisconsin | 55021 | 455 | 2 |
521394 | 521394 | 2020-09-10 | Columbia | Wisconsin | 55021 | 453 | 2 |
518157 | 518157 | 2020-09-09 | Columbia | Wisconsin | 55021 | 442 | 2 |
514922 | 514922 | 2020-09-08 | Columbia | Wisconsin | 55021 | 435 | 2 |
511689 | 511689 | 2020-09-07 | Columbia | Wisconsin | 55021 | 431 | 2 |
508456 | 508456 | 2020-09-06 | Columbia | Wisconsin | 55021 | 426 | 2 |
505224 | 505224 | 2020-09-05 | Columbia | Wisconsin | 55021 | 419 | 2 |
501990 | 501990 | 2020-09-04 | Columbia | Wisconsin | 55021 | 414 | 2 |
498756 | 498756 | 2020-09-03 | Columbia | Wisconsin | 55021 | 369 | 2 |
495523 | 495523 | 2020-09-02 | Columbia | Wisconsin | 55021 | 366 | 2 |
492289 | 492289 | 2020-09-01 | Columbia | Wisconsin | 55021 | 361 | 2 |
489056 | 489056 | 2020-08-31 | Columbia | Wisconsin | 55021 | 351 | 2 |
485823 | 485823 | 2020-08-30 | Columbia | Wisconsin | 55021 | 351 | 2 |
482588 | 482588 | 2020-08-29 | Columbia | Wisconsin | 55021 | 349 | 2 |
479354 | 479354 | 2020-08-28 | Columbia | Wisconsin | 55021 | 344 | 2 |
476121 | 476121 | 2020-08-27 | Columbia | Wisconsin | 55021 | 340 | 2 |
472888 | 472888 | 2020-08-26 | Columbia | Wisconsin | 55021 | 334 | 2 |
469656 | 469656 | 2020-08-25 | Columbia | Wisconsin | 55021 | 329 | 2 |
466427 | 466427 | 2020-08-24 | Columbia | Wisconsin | 55021 | 326 | 2 |
463198 | 463198 | 2020-08-23 | Columbia | Wisconsin | 55021 | 319 | 2 |
459969 | 459969 | 2020-08-22 | Columbia | Wisconsin | 55021 | 314 | 2 |
456742 | 456742 | 2020-08-21 | Columbia | Wisconsin | 55021 | 310 | 2 |
453514 | 453514 | 2020-08-20 | Columbia | Wisconsin | 55021 | 307 | 2 |
450286 | 450286 | 2020-08-19 | Columbia | Wisconsin | 55021 | 297 | 2 |
447058 | 447058 | 2020-08-18 | Columbia | Wisconsin | 55021 | 292 | 2 |
443831 | 443831 | 2020-08-17 | Columbia | Wisconsin | 55021 | 291 | 2 |
440605 | 440605 | 2020-08-16 | Columbia | Wisconsin | 55021 | 288 | 2 |
437379 | 437379 | 2020-08-15 | Columbia | Wisconsin | 55021 | 287 | 2 |
434153 | 434153 | 2020-08-14 | Columbia | Wisconsin | 55021 | 279 | 2 |
430928 | 430928 | 2020-08-13 | Columbia | Wisconsin | 55021 | 274 | 2 |
427700 | 427700 | 2020-08-12 | Columbia | Wisconsin | 55021 | 273 | 2 |
424476 | 424476 | 2020-08-11 | Columbia | Wisconsin | 55021 | 255 | 2 |
421255 | 421255 | 2020-08-10 | Columbia | Wisconsin | 55021 | 252 | 1 |
418034 | 418034 | 2020-08-09 | Columbia | Wisconsin | 55021 | 248 | 1 |
414813 | 414813 | 2020-08-08 | Columbia | Wisconsin | 55021 | 245 | 1 |
411593 | 411593 | 2020-08-07 | Columbia | Wisconsin | 55021 | 241 | 1 |
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);