ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 55015 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
874915 | 874915 | 2020-12-28 | Calumet | Wisconsin | 55015 | 4938 | 36 |
871670 | 871670 | 2020-12-27 | Calumet | Wisconsin | 55015 | 4927 | 35 |
868425 | 868425 | 2020-12-26 | Calumet | Wisconsin | 55015 | 4912 | 35 |
865180 | 865180 | 2020-12-25 | Calumet | Wisconsin | 55015 | 4909 | 35 |
861935 | 861935 | 2020-12-24 | Calumet | Wisconsin | 55015 | 4897 | 35 |
858690 | 858690 | 2020-12-23 | Calumet | Wisconsin | 55015 | 4874 | 35 |
855445 | 855445 | 2020-12-22 | Calumet | Wisconsin | 55015 | 4851 | 35 |
852200 | 852200 | 2020-12-21 | Calumet | Wisconsin | 55015 | 4836 | 32 |
848955 | 848955 | 2020-12-20 | Calumet | Wisconsin | 55015 | 4823 | 32 |
845710 | 845710 | 2020-12-19 | Calumet | Wisconsin | 55015 | 4807 | 32 |
842464 | 842464 | 2020-12-18 | Calumet | Wisconsin | 55015 | 4775 | 33 |
839219 | 839219 | 2020-12-17 | Calumet | Wisconsin | 55015 | 4742 | 32 |
835974 | 835974 | 2020-12-16 | Calumet | Wisconsin | 55015 | 4721 | 31 |
832728 | 832728 | 2020-12-15 | Calumet | Wisconsin | 55015 | 4703 | 31 |
829481 | 829481 | 2020-12-14 | Calumet | Wisconsin | 55015 | 4684 | 31 |
826235 | 826235 | 2020-12-13 | Calumet | Wisconsin | 55015 | 4661 | 31 |
822988 | 822988 | 2020-12-12 | Calumet | Wisconsin | 55015 | 4628 | 31 |
819742 | 819742 | 2020-12-11 | Calumet | Wisconsin | 55015 | 4589 | 31 |
816496 | 816496 | 2020-12-10 | Calumet | Wisconsin | 55015 | 4557 | 30 |
813250 | 813250 | 2020-12-09 | Calumet | Wisconsin | 55015 | 4538 | 30 |
810006 | 810006 | 2020-12-08 | Calumet | Wisconsin | 55015 | 4519 | 30 |
806761 | 806761 | 2020-12-07 | Calumet | Wisconsin | 55015 | 4483 | 29 |
803516 | 803516 | 2020-12-06 | Calumet | Wisconsin | 55015 | 4468 | 29 |
800271 | 800271 | 2020-12-05 | Calumet | Wisconsin | 55015 | 4419 | 29 |
797026 | 797026 | 2020-12-04 | Calumet | Wisconsin | 55015 | 4398 | 28 |
793781 | 793781 | 2020-12-03 | Calumet | Wisconsin | 55015 | 4356 | 27 |
790536 | 790536 | 2020-12-02 | Calumet | Wisconsin | 55015 | 4312 | 27 |
787291 | 787291 | 2020-12-01 | Calumet | Wisconsin | 55015 | 4292 | 27 |
784047 | 784047 | 2020-11-30 | Calumet | Wisconsin | 55015 | 4273 | 26 |
780802 | 780802 | 2020-11-29 | Calumet | Wisconsin | 55015 | 4251 | 26 |
777556 | 777556 | 2020-11-28 | Calumet | Wisconsin | 55015 | 4238 | 26 |
774311 | 774311 | 2020-11-27 | Calumet | Wisconsin | 55015 | 4199 | 26 |
771066 | 771066 | 2020-11-26 | Calumet | Wisconsin | 55015 | 4196 | 26 |
767820 | 767820 | 2020-11-25 | Calumet | Wisconsin | 55015 | 4169 | 26 |
764575 | 764575 | 2020-11-24 | Calumet | Wisconsin | 55015 | 4128 | 26 |
761330 | 761330 | 2020-11-23 | Calumet | Wisconsin | 55015 | 4077 | 26 |
758085 | 758085 | 2020-11-22 | Calumet | Wisconsin | 55015 | 4047 | 26 |
754838 | 754838 | 2020-11-21 | Calumet | Wisconsin | 55015 | 3996 | 26 |
751592 | 751592 | 2020-11-20 | Calumet | Wisconsin | 55015 | 3942 | 26 |
748346 | 748346 | 2020-11-19 | Calumet | Wisconsin | 55015 | 3897 | 23 |
745100 | 745100 | 2020-11-18 | Calumet | Wisconsin | 55015 | 3841 | 22 |
741853 | 741853 | 2020-11-17 | Calumet | Wisconsin | 55015 | 3787 | 22 |
738606 | 738606 | 2020-11-16 | Calumet | Wisconsin | 55015 | 3725 | 22 |
735362 | 735362 | 2020-11-15 | Calumet | Wisconsin | 55015 | 3671 | 22 |
732116 | 732116 | 2020-11-14 | Calumet | Wisconsin | 55015 | 3624 | 22 |
728871 | 728871 | 2020-11-13 | Calumet | Wisconsin | 55015 | 3570 | 21 |
725628 | 725628 | 2020-11-12 | Calumet | Wisconsin | 55015 | 3496 | 21 |
722385 | 722385 | 2020-11-11 | Calumet | Wisconsin | 55015 | 3435 | 18 |
719142 | 719142 | 2020-11-10 | Calumet | Wisconsin | 55015 | 3376 | 18 |
715899 | 715899 | 2020-11-09 | Calumet | Wisconsin | 55015 | 3325 | 18 |
712655 | 712655 | 2020-11-08 | Calumet | Wisconsin | 55015 | 3261 | 18 |
709411 | 709411 | 2020-11-07 | Calumet | Wisconsin | 55015 | 3233 | 18 |
706167 | 706167 | 2020-11-06 | Calumet | Wisconsin | 55015 | 3173 | 18 |
702924 | 702924 | 2020-11-05 | Calumet | Wisconsin | 55015 | 3132 | 18 |
699681 | 699681 | 2020-11-04 | Calumet | Wisconsin | 55015 | 3072 | 18 |
696437 | 696437 | 2020-11-03 | Calumet | Wisconsin | 55015 | 3034 | 14 |
693195 | 693195 | 2020-11-02 | Calumet | Wisconsin | 55015 | 2961 | 14 |
689951 | 689951 | 2020-11-01 | Calumet | Wisconsin | 55015 | 2925 | 14 |
686706 | 686706 | 2020-10-31 | Calumet | Wisconsin | 55015 | 2886 | 14 |
683463 | 683463 | 2020-10-30 | Calumet | Wisconsin | 55015 | 2838 | 11 |
680220 | 680220 | 2020-10-29 | Calumet | Wisconsin | 55015 | 2804 | 11 |
676977 | 676977 | 2020-10-28 | Calumet | Wisconsin | 55015 | 2757 | 11 |
673734 | 673734 | 2020-10-27 | Calumet | Wisconsin | 55015 | 2737 | 11 |
670492 | 670492 | 2020-10-26 | Calumet | Wisconsin | 55015 | 2689 | 11 |
667249 | 667249 | 2020-10-25 | Calumet | Wisconsin | 55015 | 2669 | 11 |
664004 | 664004 | 2020-10-24 | Calumet | Wisconsin | 55015 | 2630 | 11 |
660760 | 660760 | 2020-10-23 | Calumet | Wisconsin | 55015 | 2580 | 11 |
657516 | 657516 | 2020-10-22 | Calumet | Wisconsin | 55015 | 2513 | 11 |
654271 | 654271 | 2020-10-21 | Calumet | Wisconsin | 55015 | 2433 | 11 |
651026 | 651026 | 2020-10-20 | Calumet | Wisconsin | 55015 | 2386 | 11 |
647782 | 647782 | 2020-10-19 | Calumet | Wisconsin | 55015 | 2335 | 10 |
644536 | 644536 | 2020-10-18 | Calumet | Wisconsin | 55015 | 2236 | 10 |
641288 | 641288 | 2020-10-17 | Calumet | Wisconsin | 55015 | 2236 | 10 |
638041 | 638041 | 2020-10-16 | Calumet | Wisconsin | 55015 | 2236 | 10 |
634796 | 634796 | 2020-10-15 | Calumet | Wisconsin | 55015 | 2156 | 10 |
631551 | 631551 | 2020-10-14 | Calumet | Wisconsin | 55015 | 2101 | 10 |
628307 | 628307 | 2020-10-13 | Calumet | Wisconsin | 55015 | 2051 | 10 |
625064 | 625064 | 2020-10-12 | Calumet | Wisconsin | 55015 | 1982 | 10 |
621821 | 621821 | 2020-10-11 | Calumet | Wisconsin | 55015 | 1941 | 9 |
618578 | 618578 | 2020-10-10 | Calumet | Wisconsin | 55015 | 1868 | 7 |
615336 | 615336 | 2020-10-09 | Calumet | Wisconsin | 55015 | 1824 | 6 |
612095 | 612095 | 2020-10-08 | Calumet | Wisconsin | 55015 | 1779 | 6 |
608853 | 608853 | 2020-10-07 | Calumet | Wisconsin | 55015 | 1713 | 6 |
605610 | 605610 | 2020-10-06 | Calumet | Wisconsin | 55015 | 1639 | 6 |
602368 | 602368 | 2020-10-05 | Calumet | Wisconsin | 55015 | 1621 | 5 |
599125 | 599125 | 2020-10-04 | Calumet | Wisconsin | 55015 | 1578 | 5 |
595882 | 595882 | 2020-10-03 | Calumet | Wisconsin | 55015 | 1523 | 5 |
592640 | 592640 | 2020-10-02 | Calumet | Wisconsin | 55015 | 1450 | 5 |
589400 | 589400 | 2020-10-01 | Calumet | Wisconsin | 55015 | 1384 | 5 |
586159 | 586159 | 2020-09-30 | Calumet | Wisconsin | 55015 | 1325 | 5 |
582919 | 582919 | 2020-09-29 | Calumet | Wisconsin | 55015 | 1278 | 4 |
579680 | 579680 | 2020-09-28 | Calumet | Wisconsin | 55015 | 1226 | 3 |
576439 | 576439 | 2020-09-27 | Calumet | Wisconsin | 55015 | 1189 | 3 |
573195 | 573195 | 2020-09-26 | Calumet | Wisconsin | 55015 | 1152 | 3 |
569953 | 569953 | 2020-09-25 | Calumet | Wisconsin | 55015 | 1056 | 3 |
566712 | 566712 | 2020-09-24 | Calumet | Wisconsin | 55015 | 1025 | 2 |
563471 | 563471 | 2020-09-23 | Calumet | Wisconsin | 55015 | 982 | 2 |
560232 | 560232 | 2020-09-22 | Calumet | Wisconsin | 55015 | 956 | 2 |
556996 | 556996 | 2020-09-21 | Calumet | Wisconsin | 55015 | 929 | 2 |
553759 | 553759 | 2020-09-20 | Calumet | Wisconsin | 55015 | 904 | 2 |
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);