ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,548 rows where county = "Walworth" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056029 | 1056029 | 2021-02-22 | Walworth | South Dakota | 46129 | 717 | 15 |
1056721 | 1056721 | 2021-02-22 | Walworth | Wisconsin | 55127 | 11146 | 144 |
1052783 | 1052783 | 2021-02-21 | Walworth | South Dakota | 46129 | 716 | 15 |
1053475 | 1053475 | 2021-02-21 | Walworth | Wisconsin | 55127 | 11146 | 144 |
1049536 | 1049536 | 2021-02-20 | Walworth | South Dakota | 46129 | 716 | 15 |
1050228 | 1050228 | 2021-02-20 | Walworth | Wisconsin | 55127 | 11145 | 144 |
1046289 | 1046289 | 2021-02-19 | Walworth | South Dakota | 46129 | 715 | 15 |
1046981 | 1046981 | 2021-02-19 | Walworth | Wisconsin | 55127 | 11146 | 143 |
1043044 | 1043044 | 2021-02-18 | Walworth | South Dakota | 46129 | 716 | 15 |
1043736 | 1043736 | 2021-02-18 | Walworth | Wisconsin | 55127 | 11131 | 143 |
1039799 | 1039799 | 2021-02-17 | Walworth | South Dakota | 46129 | 717 | 15 |
1040491 | 1040491 | 2021-02-17 | Walworth | Wisconsin | 55127 | 11118 | 143 |
1036554 | 1036554 | 2021-02-16 | Walworth | South Dakota | 46129 | 717 | 15 |
1037246 | 1037246 | 2021-02-16 | Walworth | Wisconsin | 55127 | 11108 | 143 |
1033309 | 1033309 | 2021-02-15 | Walworth | South Dakota | 46129 | 717 | 15 |
1034001 | 1034001 | 2021-02-15 | Walworth | Wisconsin | 55127 | 11086 | 143 |
1030063 | 1030063 | 2021-02-14 | Walworth | South Dakota | 46129 | 717 | 15 |
1030755 | 1030755 | 2021-02-14 | Walworth | Wisconsin | 55127 | 11086 | 143 |
1026816 | 1026816 | 2021-02-13 | Walworth | South Dakota | 46129 | 713 | 15 |
1027508 | 1027508 | 2021-02-13 | Walworth | Wisconsin | 55127 | 11076 | 143 |
1023571 | 1023571 | 2021-02-12 | Walworth | South Dakota | 46129 | 712 | 15 |
1024263 | 1024263 | 2021-02-12 | Walworth | Wisconsin | 55127 | 11073 | 143 |
1020326 | 1020326 | 2021-02-11 | Walworth | South Dakota | 46129 | 712 | 15 |
1021018 | 1021018 | 2021-02-11 | Walworth | Wisconsin | 55127 | 11059 | 143 |
1017081 | 1017081 | 2021-02-10 | Walworth | South Dakota | 46129 | 709 | 15 |
1017773 | 1017773 | 2021-02-10 | Walworth | Wisconsin | 55127 | 11036 | 143 |
1013836 | 1013836 | 2021-02-09 | Walworth | South Dakota | 46129 | 709 | 15 |
1014528 | 1014528 | 2021-02-09 | Walworth | Wisconsin | 55127 | 11017 | 139 |
1010591 | 1010591 | 2021-02-08 | Walworth | South Dakota | 46129 | 709 | 15 |
1011283 | 1011283 | 2021-02-08 | Walworth | Wisconsin | 55127 | 11001 | 138 |
1007345 | 1007345 | 2021-02-07 | Walworth | South Dakota | 46129 | 709 | 15 |
1008037 | 1008037 | 2021-02-07 | Walworth | Wisconsin | 55127 | 11001 | 138 |
1004099 | 1004099 | 2021-02-06 | Walworth | South Dakota | 46129 | 708 | 15 |
1004791 | 1004791 | 2021-02-06 | Walworth | Wisconsin | 55127 | 10990 | 138 |
1000853 | 1000853 | 2021-02-05 | Walworth | South Dakota | 46129 | 707 | 15 |
1001545 | 1001545 | 2021-02-05 | Walworth | Wisconsin | 55127 | 10965 | 136 |
997607 | 997607 | 2021-02-04 | Walworth | South Dakota | 46129 | 705 | 15 |
998299 | 998299 | 2021-02-04 | Walworth | Wisconsin | 55127 | 10944 | 135 |
994361 | 994361 | 2021-02-03 | Walworth | South Dakota | 46129 | 703 | 15 |
995053 | 995053 | 2021-02-03 | Walworth | Wisconsin | 55127 | 10904 | 133 |
991115 | 991115 | 2021-02-02 | Walworth | South Dakota | 46129 | 703 | 15 |
991807 | 991807 | 2021-02-02 | Walworth | Wisconsin | 55127 | 10891 | 133 |
987869 | 987869 | 2021-02-01 | Walworth | South Dakota | 46129 | 702 | 15 |
988561 | 988561 | 2021-02-01 | Walworth | Wisconsin | 55127 | 10855 | 132 |
984622 | 984622 | 2021-01-31 | Walworth | South Dakota | 46129 | 700 | 15 |
985314 | 985314 | 2021-01-31 | Walworth | Wisconsin | 55127 | 10855 | 132 |
981375 | 981375 | 2021-01-30 | Walworth | South Dakota | 46129 | 700 | 15 |
982067 | 982067 | 2021-01-30 | Walworth | Wisconsin | 55127 | 10848 | 131 |
978129 | 978129 | 2021-01-29 | Walworth | South Dakota | 46129 | 700 | 14 |
978821 | 978821 | 2021-01-29 | Walworth | Wisconsin | 55127 | 10810 | 131 |
974884 | 974884 | 2021-01-28 | Walworth | South Dakota | 46129 | 700 | 14 |
975576 | 975576 | 2021-01-28 | Walworth | Wisconsin | 55127 | 10767 | 131 |
971639 | 971639 | 2021-01-27 | Walworth | South Dakota | 46129 | 699 | 14 |
972331 | 972331 | 2021-01-27 | Walworth | Wisconsin | 55127 | 10744 | 131 |
968394 | 968394 | 2021-01-26 | Walworth | South Dakota | 46129 | 700 | 14 |
969086 | 969086 | 2021-01-26 | Walworth | Wisconsin | 55127 | 10718 | 129 |
965150 | 965150 | 2021-01-25 | Walworth | South Dakota | 46129 | 700 | 14 |
965842 | 965842 | 2021-01-25 | Walworth | Wisconsin | 55127 | 10690 | 129 |
961905 | 961905 | 2021-01-24 | Walworth | South Dakota | 46129 | 699 | 14 |
962597 | 962597 | 2021-01-24 | Walworth | Wisconsin | 55127 | 10650 | 129 |
958660 | 958660 | 2021-01-23 | Walworth | South Dakota | 46129 | 693 | 14 |
959352 | 959352 | 2021-01-23 | Walworth | Wisconsin | 55127 | 10626 | 129 |
955414 | 955414 | 2021-01-22 | Walworth | South Dakota | 46129 | 692 | 14 |
956106 | 956106 | 2021-01-22 | Walworth | Wisconsin | 55127 | 10608 | 129 |
952169 | 952169 | 2021-01-21 | Walworth | South Dakota | 46129 | 689 | 14 |
952861 | 952861 | 2021-01-21 | Walworth | Wisconsin | 55127 | 10577 | 127 |
948924 | 948924 | 2021-01-20 | Walworth | South Dakota | 46129 | 689 | 14 |
949616 | 949616 | 2021-01-20 | Walworth | Wisconsin | 55127 | 10523 | 126 |
945678 | 945678 | 2021-01-19 | Walworth | South Dakota | 46129 | 687 | 14 |
946370 | 946370 | 2021-01-19 | Walworth | Wisconsin | 55127 | 10502 | 125 |
942431 | 942431 | 2021-01-18 | Walworth | South Dakota | 46129 | 684 | 14 |
943123 | 943123 | 2021-01-18 | Walworth | Wisconsin | 55127 | 10459 | 126 |
939186 | 939186 | 2021-01-17 | Walworth | South Dakota | 46129 | 684 | 14 |
939878 | 939878 | 2021-01-17 | Walworth | Wisconsin | 55127 | 10431 | 126 |
935941 | 935941 | 2021-01-16 | Walworth | South Dakota | 46129 | 676 | 14 |
936633 | 936633 | 2021-01-16 | Walworth | Wisconsin | 55127 | 10396 | 126 |
932696 | 932696 | 2021-01-15 | Walworth | South Dakota | 46129 | 673 | 14 |
933388 | 933388 | 2021-01-15 | Walworth | Wisconsin | 55127 | 10377 | 121 |
929451 | 929451 | 2021-01-14 | Walworth | South Dakota | 46129 | 669 | 14 |
930143 | 930143 | 2021-01-14 | Walworth | Wisconsin | 55127 | 10324 | 117 |
926206 | 926206 | 2021-01-13 | Walworth | South Dakota | 46129 | 666 | 14 |
926898 | 926898 | 2021-01-13 | Walworth | Wisconsin | 55127 | 10268 | 117 |
922960 | 922960 | 2021-01-12 | Walworth | South Dakota | 46129 | 665 | 14 |
923652 | 923652 | 2021-01-12 | Walworth | Wisconsin | 55127 | 10215 | 115 |
919715 | 919715 | 2021-01-11 | Walworth | South Dakota | 46129 | 662 | 14 |
920407 | 920407 | 2021-01-11 | Walworth | Wisconsin | 55127 | 10114 | 114 |
916470 | 916470 | 2021-01-10 | Walworth | South Dakota | 46129 | 661 | 14 |
917162 | 917162 | 2021-01-10 | Walworth | Wisconsin | 55127 | 10065 | 114 |
913225 | 913225 | 2021-01-09 | Walworth | South Dakota | 46129 | 657 | 14 |
913917 | 913917 | 2021-01-09 | Walworth | Wisconsin | 55127 | 10006 | 114 |
909980 | 909980 | 2021-01-08 | Walworth | South Dakota | 46129 | 656 | 14 |
910672 | 910672 | 2021-01-08 | Walworth | Wisconsin | 55127 | 9952 | 114 |
906735 | 906735 | 2021-01-07 | Walworth | South Dakota | 46129 | 652 | 14 |
907427 | 907427 | 2021-01-07 | Walworth | Wisconsin | 55127 | 9840 | 113 |
903489 | 903489 | 2021-01-06 | Walworth | South Dakota | 46129 | 646 | 14 |
904181 | 904181 | 2021-01-06 | Walworth | Wisconsin | 55127 | 9763 | 112 |
900244 | 900244 | 2021-01-05 | Walworth | South Dakota | 46129 | 639 | 14 |
900936 | 900936 | 2021-01-05 | Walworth | Wisconsin | 55127 | 9671 | 107 |
896999 | 896999 | 2021-01-04 | Walworth | South Dakota | 46129 | 637 | 14 |
897691 | 897691 | 2021-01-04 | Walworth | Wisconsin | 55127 | 9561 | 103 |
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);