ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
829 rows where fips = 55025 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
923600 | 923600 | 2021-01-12 | Dane | Wisconsin | 55025 | 36971 | 233 |
920355 | 920355 | 2021-01-11 | Dane | Wisconsin | 55025 | 36877 | 230 |
917110 | 917110 | 2021-01-10 | Dane | Wisconsin | 55025 | 36728 | 230 |
913865 | 913865 | 2021-01-09 | Dane | Wisconsin | 55025 | 36520 | 230 |
910620 | 910620 | 2021-01-08 | Dane | Wisconsin | 55025 | 36325 | 222 |
907375 | 907375 | 2021-01-07 | Dane | Wisconsin | 55025 | 35977 | 222 |
904129 | 904129 | 2021-01-06 | Dane | Wisconsin | 55025 | 35565 | 208 |
900884 | 900884 | 2021-01-05 | Dane | Wisconsin | 55025 | 35342 | 208 |
897639 | 897639 | 2021-01-04 | Dane | Wisconsin | 55025 | 35207 | 199 |
894393 | 894393 | 2021-01-03 | Dane | Wisconsin | 55025 | 35000 | 199 |
891147 | 891147 | 2021-01-02 | Dane | Wisconsin | 55025 | 34732 | 200 |
887900 | 887900 | 2021-01-01 | Dane | Wisconsin | 55025 | 34732 | 200 |
884655 | 884655 | 2020-12-31 | Dane | Wisconsin | 55025 | 34503 | 199 |
881410 | 881410 | 2020-12-30 | Dane | Wisconsin | 55025 | 34138 | 199 |
878165 | 878165 | 2020-12-29 | Dane | Wisconsin | 55025 | 33968 | 196 |
874920 | 874920 | 2020-12-28 | Dane | Wisconsin | 55025 | 33890 | 182 |
871675 | 871675 | 2020-12-27 | Dane | Wisconsin | 55025 | 33721 | 182 |
868430 | 868430 | 2020-12-26 | Dane | Wisconsin | 55025 | 33541 | 182 |
865185 | 865185 | 2020-12-25 | Dane | Wisconsin | 55025 | 33540 | 182 |
861940 | 861940 | 2020-12-24 | Dane | Wisconsin | 55025 | 33383 | 180 |
858695 | 858695 | 2020-12-23 | Dane | Wisconsin | 55025 | 33168 | 178 |
855450 | 855450 | 2020-12-22 | Dane | Wisconsin | 55025 | 33019 | 169 |
852205 | 852205 | 2020-12-21 | Dane | Wisconsin | 55025 | 32926 | 142 |
848960 | 848960 | 2020-12-20 | Dane | Wisconsin | 55025 | 32790 | 142 |
845715 | 845715 | 2020-12-19 | Dane | Wisconsin | 55025 | 32675 | 142 |
842469 | 842469 | 2020-12-18 | Dane | Wisconsin | 55025 | 32454 | 142 |
839224 | 839224 | 2020-12-17 | Dane | Wisconsin | 55025 | 32200 | 142 |
835979 | 835979 | 2020-12-16 | Dane | Wisconsin | 55025 | 31910 | 142 |
832733 | 832733 | 2020-12-15 | Dane | Wisconsin | 55025 | 31739 | 120 |
829486 | 829486 | 2020-12-14 | Dane | Wisconsin | 55025 | 31693 | 117 |
826240 | 826240 | 2020-12-13 | Dane | Wisconsin | 55025 | 31508 | 117 |
822993 | 822993 | 2020-12-12 | Dane | Wisconsin | 55025 | 31287 | 116 |
819747 | 819747 | 2020-12-11 | Dane | Wisconsin | 55025 | 31028 | 116 |
816501 | 816501 | 2020-12-10 | Dane | Wisconsin | 55025 | 30847 | 112 |
813255 | 813255 | 2020-12-09 | Dane | Wisconsin | 55025 | 30571 | 111 |
810011 | 810011 | 2020-12-08 | Dane | Wisconsin | 55025 | 30375 | 110 |
806766 | 806766 | 2020-12-07 | Dane | Wisconsin | 55025 | 30249 | 107 |
803521 | 803521 | 2020-12-06 | Dane | Wisconsin | 55025 | 30001 | 107 |
800276 | 800276 | 2020-12-05 | Dane | Wisconsin | 55025 | 29868 | 107 |
797031 | 797031 | 2020-12-04 | Dane | Wisconsin | 55025 | 29493 | 105 |
793786 | 793786 | 2020-12-03 | Dane | Wisconsin | 55025 | 29068 | 105 |
790541 | 790541 | 2020-12-02 | Dane | Wisconsin | 55025 | 28618 | 105 |
787296 | 787296 | 2020-12-01 | Dane | Wisconsin | 55025 | 28370 | 84 |
784052 | 784052 | 2020-11-30 | Dane | Wisconsin | 55025 | 28265 | 83 |
780807 | 780807 | 2020-11-29 | Dane | Wisconsin | 55025 | 28017 | 83 |
777561 | 777561 | 2020-11-28 | Dane | Wisconsin | 55025 | 27619 | 83 |
774316 | 774316 | 2020-11-27 | Dane | Wisconsin | 55025 | 27164 | 83 |
771071 | 771071 | 2020-11-26 | Dane | Wisconsin | 55025 | 27120 | 83 |
767825 | 767825 | 2020-11-25 | Dane | Wisconsin | 55025 | 26727 | 80 |
764580 | 764580 | 2020-11-24 | Dane | Wisconsin | 55025 | 26485 | 80 |
761335 | 761335 | 2020-11-23 | Dane | Wisconsin | 55025 | 25722 | 78 |
758090 | 758090 | 2020-11-22 | Dane | Wisconsin | 55025 | 25554 | 78 |
754843 | 754843 | 2020-11-21 | Dane | Wisconsin | 55025 | 25345 | 78 |
751597 | 751597 | 2020-11-20 | Dane | Wisconsin | 55025 | 24973 | 74 |
748351 | 748351 | 2020-11-19 | Dane | Wisconsin | 55025 | 24519 | 71 |
745105 | 745105 | 2020-11-18 | Dane | Wisconsin | 55025 | 24105 | 70 |
741858 | 741858 | 2020-11-17 | Dane | Wisconsin | 55025 | 23546 | 66 |
738611 | 738611 | 2020-11-16 | Dane | Wisconsin | 55025 | 22839 | 63 |
735367 | 735367 | 2020-11-15 | Dane | Wisconsin | 55025 | 22337 | 63 |
732121 | 732121 | 2020-11-14 | Dane | Wisconsin | 55025 | 21965 | 63 |
728876 | 728876 | 2020-11-13 | Dane | Wisconsin | 55025 | 21670 | 63 |
725633 | 725633 | 2020-11-12 | Dane | Wisconsin | 55025 | 21201 | 59 |
722390 | 722390 | 2020-11-11 | Dane | Wisconsin | 55025 | 20572 | 58 |
719147 | 719147 | 2020-11-10 | Dane | Wisconsin | 55025 | 20116 | 58 |
715904 | 715904 | 2020-11-09 | Dane | Wisconsin | 55025 | 19418 | 57 |
712660 | 712660 | 2020-11-08 | Dane | Wisconsin | 55025 | 19144 | 57 |
709416 | 709416 | 2020-11-07 | Dane | Wisconsin | 55025 | 18884 | 57 |
706172 | 706172 | 2020-11-06 | Dane | Wisconsin | 55025 | 18413 | 55 |
702929 | 702929 | 2020-11-05 | Dane | Wisconsin | 55025 | 17893 | 52 |
699686 | 699686 | 2020-11-04 | Dane | Wisconsin | 55025 | 17563 | 53 |
696442 | 696442 | 2020-11-03 | Dane | Wisconsin | 55025 | 17372 | 51 |
693200 | 693200 | 2020-11-02 | Dane | Wisconsin | 55025 | 16791 | 51 |
689956 | 689956 | 2020-11-01 | Dane | Wisconsin | 55025 | 16593 | 51 |
686711 | 686711 | 2020-10-31 | Dane | Wisconsin | 55025 | 16418 | 50 |
683468 | 683468 | 2020-10-30 | Dane | Wisconsin | 55025 | 16094 | 50 |
680225 | 680225 | 2020-10-29 | Dane | Wisconsin | 55025 | 15720 | 51 |
676982 | 676982 | 2020-10-28 | Dane | Wisconsin | 55025 | 15492 | 50 |
673739 | 673739 | 2020-10-27 | Dane | Wisconsin | 55025 | 15106 | 49 |
670497 | 670497 | 2020-10-26 | Dane | Wisconsin | 55025 | 14843 | 49 |
667254 | 667254 | 2020-10-25 | Dane | Wisconsin | 55025 | 14662 | 49 |
664009 | 664009 | 2020-10-24 | Dane | Wisconsin | 55025 | 14368 | 49 |
660765 | 660765 | 2020-10-23 | Dane | Wisconsin | 55025 | 14085 | 48 |
657521 | 657521 | 2020-10-22 | Dane | Wisconsin | 55025 | 13840 | 48 |
654276 | 654276 | 2020-10-21 | Dane | Wisconsin | 55025 | 13639 | 47 |
651031 | 651031 | 2020-10-20 | Dane | Wisconsin | 55025 | 13362 | 47 |
647787 | 647787 | 2020-10-19 | Dane | Wisconsin | 55025 | 13052 | 47 |
644541 | 644541 | 2020-10-18 | Dane | Wisconsin | 55025 | 12826 | 46 |
641293 | 641293 | 2020-10-17 | Dane | Wisconsin | 55025 | 12826 | 46 |
638046 | 638046 | 2020-10-16 | Dane | Wisconsin | 55025 | 12826 | 46 |
634801 | 634801 | 2020-10-15 | Dane | Wisconsin | 55025 | 12593 | 46 |
631556 | 631556 | 2020-10-14 | Dane | Wisconsin | 55025 | 12370 | 46 |
628312 | 628312 | 2020-10-13 | Dane | Wisconsin | 55025 | 12194 | 45 |
625069 | 625069 | 2020-10-12 | Dane | Wisconsin | 55025 | 12075 | 44 |
621826 | 621826 | 2020-10-11 | Dane | Wisconsin | 55025 | 11905 | 44 |
618583 | 618583 | 2020-10-10 | Dane | Wisconsin | 55025 | 11722 | 44 |
615341 | 615341 | 2020-10-09 | Dane | Wisconsin | 55025 | 11514 | 43 |
612100 | 612100 | 2020-10-08 | Dane | Wisconsin | 55025 | 11319 | 43 |
608858 | 608858 | 2020-10-07 | Dane | Wisconsin | 55025 | 11209 | 43 |
605615 | 605615 | 2020-10-06 | Dane | Wisconsin | 55025 | 11146 | 43 |
602373 | 602373 | 2020-10-05 | Dane | Wisconsin | 55025 | 10987 | 43 |
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);