ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where fips = 55121 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056718 | 1056718 | 2021-02-22 | Trempealeau | Wisconsin | 55121 | 3466 | 38 |
1053472 | 1053472 | 2021-02-21 | Trempealeau | Wisconsin | 55121 | 3464 | 38 |
1050225 | 1050225 | 2021-02-20 | Trempealeau | Wisconsin | 55121 | 3464 | 38 |
1046978 | 1046978 | 2021-02-19 | Trempealeau | Wisconsin | 55121 | 3460 | 38 |
1043733 | 1043733 | 2021-02-18 | Trempealeau | Wisconsin | 55121 | 3454 | 38 |
1040488 | 1040488 | 2021-02-17 | Trempealeau | Wisconsin | 55121 | 3452 | 38 |
1037243 | 1037243 | 2021-02-16 | Trempealeau | Wisconsin | 55121 | 3457 | 38 |
1033998 | 1033998 | 2021-02-15 | Trempealeau | Wisconsin | 55121 | 3450 | 38 |
1030752 | 1030752 | 2021-02-14 | Trempealeau | Wisconsin | 55121 | 3448 | 38 |
1027505 | 1027505 | 2021-02-13 | Trempealeau | Wisconsin | 55121 | 3444 | 38 |
1024260 | 1024260 | 2021-02-12 | Trempealeau | Wisconsin | 55121 | 3434 | 38 |
1021015 | 1021015 | 2021-02-11 | Trempealeau | Wisconsin | 55121 | 3429 | 38 |
1017770 | 1017770 | 2021-02-10 | Trempealeau | Wisconsin | 55121 | 3424 | 38 |
1014525 | 1014525 | 2021-02-09 | Trempealeau | Wisconsin | 55121 | 3418 | 38 |
1011280 | 1011280 | 2021-02-08 | Trempealeau | Wisconsin | 55121 | 3410 | 38 |
1008034 | 1008034 | 2021-02-07 | Trempealeau | Wisconsin | 55121 | 3404 | 38 |
1004788 | 1004788 | 2021-02-06 | Trempealeau | Wisconsin | 55121 | 3399 | 38 |
1001542 | 1001542 | 2021-02-05 | Trempealeau | Wisconsin | 55121 | 3391 | 38 |
998296 | 998296 | 2021-02-04 | Trempealeau | Wisconsin | 55121 | 3386 | 38 |
995050 | 995050 | 2021-02-03 | Trempealeau | Wisconsin | 55121 | 3380 | 38 |
991804 | 991804 | 2021-02-02 | Trempealeau | Wisconsin | 55121 | 3368 | 38 |
988558 | 988558 | 2021-02-01 | Trempealeau | Wisconsin | 55121 | 3367 | 38 |
985311 | 985311 | 2021-01-31 | Trempealeau | Wisconsin | 55121 | 3361 | 38 |
982064 | 982064 | 2021-01-30 | Trempealeau | Wisconsin | 55121 | 3362 | 38 |
978818 | 978818 | 2021-01-29 | Trempealeau | Wisconsin | 55121 | 3359 | 37 |
975573 | 975573 | 2021-01-28 | Trempealeau | Wisconsin | 55121 | 3354 | 36 |
972328 | 972328 | 2021-01-27 | Trempealeau | Wisconsin | 55121 | 3350 | 36 |
969083 | 969083 | 2021-01-26 | Trempealeau | Wisconsin | 55121 | 3341 | 36 |
965839 | 965839 | 2021-01-25 | Trempealeau | Wisconsin | 55121 | 3333 | 36 |
962594 | 962594 | 2021-01-24 | Trempealeau | Wisconsin | 55121 | 3340 | 36 |
959349 | 959349 | 2021-01-23 | Trempealeau | Wisconsin | 55121 | 3333 | 36 |
956103 | 956103 | 2021-01-22 | Trempealeau | Wisconsin | 55121 | 3322 | 36 |
952858 | 952858 | 2021-01-21 | Trempealeau | Wisconsin | 55121 | 3308 | 35 |
949613 | 949613 | 2021-01-20 | Trempealeau | Wisconsin | 55121 | 3299 | 34 |
946367 | 946367 | 2021-01-19 | Trempealeau | Wisconsin | 55121 | 3290 | 34 |
943120 | 943120 | 2021-01-18 | Trempealeau | Wisconsin | 55121 | 3276 | 34 |
939875 | 939875 | 2021-01-17 | Trempealeau | Wisconsin | 55121 | 3269 | 34 |
936630 | 936630 | 2021-01-16 | Trempealeau | Wisconsin | 55121 | 3261 | 34 |
933385 | 933385 | 2021-01-15 | Trempealeau | Wisconsin | 55121 | 3239 | 33 |
930140 | 930140 | 2021-01-14 | Trempealeau | Wisconsin | 55121 | 3233 | 33 |
926895 | 926895 | 2021-01-13 | Trempealeau | Wisconsin | 55121 | 3221 | 32 |
923649 | 923649 | 2021-01-12 | Trempealeau | Wisconsin | 55121 | 3212 | 32 |
920404 | 920404 | 2021-01-11 | Trempealeau | Wisconsin | 55121 | 3202 | 31 |
917159 | 917159 | 2021-01-10 | Trempealeau | Wisconsin | 55121 | 3192 | 31 |
913914 | 913914 | 2021-01-09 | Trempealeau | Wisconsin | 55121 | 3181 | 31 |
910669 | 910669 | 2021-01-08 | Trempealeau | Wisconsin | 55121 | 3163 | 31 |
907424 | 907424 | 2021-01-07 | Trempealeau | Wisconsin | 55121 | 3154 | 31 |
904178 | 904178 | 2021-01-06 | Trempealeau | Wisconsin | 55121 | 3137 | 31 |
900933 | 900933 | 2021-01-05 | Trempealeau | Wisconsin | 55121 | 3114 | 31 |
897688 | 897688 | 2021-01-04 | Trempealeau | Wisconsin | 55121 | 3103 | 30 |
894442 | 894442 | 2021-01-03 | Trempealeau | Wisconsin | 55121 | 3084 | 30 |
891196 | 891196 | 2021-01-02 | Trempealeau | Wisconsin | 55121 | 3065 | 30 |
887949 | 887949 | 2021-01-01 | Trempealeau | Wisconsin | 55121 | 3064 | 30 |
884704 | 884704 | 2020-12-31 | Trempealeau | Wisconsin | 55121 | 3052 | 30 |
881459 | 881459 | 2020-12-30 | Trempealeau | Wisconsin | 55121 | 3026 | 30 |
878214 | 878214 | 2020-12-29 | Trempealeau | Wisconsin | 55121 | 3009 | 30 |
874969 | 874969 | 2020-12-28 | Trempealeau | Wisconsin | 55121 | 2993 | 30 |
871724 | 871724 | 2020-12-27 | Trempealeau | Wisconsin | 55121 | 2982 | 30 |
868479 | 868479 | 2020-12-26 | Trempealeau | Wisconsin | 55121 | 2966 | 30 |
865234 | 865234 | 2020-12-25 | Trempealeau | Wisconsin | 55121 | 2963 | 30 |
861989 | 861989 | 2020-12-24 | Trempealeau | Wisconsin | 55121 | 2961 | 30 |
858744 | 858744 | 2020-12-23 | Trempealeau | Wisconsin | 55121 | 2949 | 29 |
855499 | 855499 | 2020-12-22 | Trempealeau | Wisconsin | 55121 | 2936 | 28 |
852254 | 852254 | 2020-12-21 | Trempealeau | Wisconsin | 55121 | 2926 | 28 |
849009 | 849009 | 2020-12-20 | Trempealeau | Wisconsin | 55121 | 2914 | 28 |
845764 | 845764 | 2020-12-19 | Trempealeau | Wisconsin | 55121 | 2903 | 28 |
842518 | 842518 | 2020-12-18 | Trempealeau | Wisconsin | 55121 | 2886 | 28 |
839273 | 839273 | 2020-12-17 | Trempealeau | Wisconsin | 55121 | 2861 | 28 |
836028 | 836028 | 2020-12-16 | Trempealeau | Wisconsin | 55121 | 2848 | 26 |
832782 | 832782 | 2020-12-15 | Trempealeau | Wisconsin | 55121 | 2819 | 25 |
829535 | 829535 | 2020-12-14 | Trempealeau | Wisconsin | 55121 | 2803 | 25 |
826289 | 826289 | 2020-12-13 | Trempealeau | Wisconsin | 55121 | 2784 | 25 |
823042 | 823042 | 2020-12-12 | Trempealeau | Wisconsin | 55121 | 2780 | 25 |
819796 | 819796 | 2020-12-11 | Trempealeau | Wisconsin | 55121 | 2768 | 24 |
816550 | 816550 | 2020-12-10 | Trempealeau | Wisconsin | 55121 | 2742 | 24 |
813304 | 813304 | 2020-12-09 | Trempealeau | Wisconsin | 55121 | 2711 | 24 |
810060 | 810060 | 2020-12-08 | Trempealeau | Wisconsin | 55121 | 2687 | 23 |
806815 | 806815 | 2020-12-07 | Trempealeau | Wisconsin | 55121 | 2669 | 22 |
803570 | 803570 | 2020-12-06 | Trempealeau | Wisconsin | 55121 | 2653 | 22 |
800325 | 800325 | 2020-12-05 | Trempealeau | Wisconsin | 55121 | 2636 | 22 |
797080 | 797080 | 2020-12-04 | Trempealeau | Wisconsin | 55121 | 2586 | 22 |
793835 | 793835 | 2020-12-03 | Trempealeau | Wisconsin | 55121 | 2548 | 22 |
790590 | 790590 | 2020-12-02 | Trempealeau | Wisconsin | 55121 | 2492 | 22 |
787345 | 787345 | 2020-12-01 | Trempealeau | Wisconsin | 55121 | 2452 | 17 |
784101 | 784101 | 2020-11-30 | Trempealeau | Wisconsin | 55121 | 2430 | 15 |
780856 | 780856 | 2020-11-29 | Trempealeau | Wisconsin | 55121 | 2414 | 15 |
777610 | 777610 | 2020-11-28 | Trempealeau | Wisconsin | 55121 | 2394 | 15 |
774365 | 774365 | 2020-11-27 | Trempealeau | Wisconsin | 55121 | 2344 | 15 |
771120 | 771120 | 2020-11-26 | Trempealeau | Wisconsin | 55121 | 2343 | 15 |
767874 | 767874 | 2020-11-25 | Trempealeau | Wisconsin | 55121 | 2311 | 15 |
764629 | 764629 | 2020-11-24 | Trempealeau | Wisconsin | 55121 | 2274 | 14 |
761384 | 761384 | 2020-11-23 | Trempealeau | Wisconsin | 55121 | 2232 | 12 |
758139 | 758139 | 2020-11-22 | Trempealeau | Wisconsin | 55121 | 2206 | 12 |
754892 | 754892 | 2020-11-21 | Trempealeau | Wisconsin | 55121 | 2149 | 12 |
751646 | 751646 | 2020-11-20 | Trempealeau | Wisconsin | 55121 | 2091 | 11 |
748400 | 748400 | 2020-11-19 | Trempealeau | Wisconsin | 55121 | 2022 | 11 |
745154 | 745154 | 2020-11-18 | Trempealeau | Wisconsin | 55121 | 1990 | 8 |
741907 | 741907 | 2020-11-17 | Trempealeau | Wisconsin | 55121 | 1892 | 8 |
738660 | 738660 | 2020-11-16 | Trempealeau | Wisconsin | 55121 | 1772 | 7 |
735416 | 735416 | 2020-11-15 | Trempealeau | Wisconsin | 55121 | 1718 | 7 |
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);