ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Walworth" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199575 | 1199575 | 2021-04-07 | Walworth | Wisconsin | 55127 | 11969 | 155 |
1196326 | 1196326 | 2021-04-06 | Walworth | Wisconsin | 55127 | 11955 | 155 |
1193078 | 1193078 | 2021-04-05 | Walworth | Wisconsin | 55127 | 11889 | 155 |
1189828 | 1189828 | 2021-04-04 | Walworth | Wisconsin | 55127 | 11866 | 155 |
1186581 | 1186581 | 2021-04-03 | Walworth | Wisconsin | 55127 | 11866 | 155 |
1183334 | 1183334 | 2021-04-02 | Walworth | Wisconsin | 55127 | 11866 | 155 |
1180087 | 1180087 | 2021-04-01 | Walworth | Wisconsin | 55127 | 11866 | 155 |
1176840 | 1176840 | 2021-03-31 | Walworth | Wisconsin | 55127 | 11843 | 155 |
1173593 | 1173593 | 2021-03-30 | Walworth | Wisconsin | 55127 | 11825 | 155 |
1170346 | 1170346 | 2021-03-29 | Walworth | Wisconsin | 55127 | 11782 | 154 |
1167098 | 1167098 | 2021-03-28 | Walworth | Wisconsin | 55127 | 11757 | 154 |
1163850 | 1163850 | 2021-03-27 | Walworth | Wisconsin | 55127 | 11757 | 154 |
1160602 | 1160602 | 2021-03-26 | Walworth | Wisconsin | 55127 | 11757 | 154 |
1157354 | 1157354 | 2021-03-25 | Walworth | Wisconsin | 55127 | 11736 | 153 |
1154107 | 1154107 | 2021-03-24 | Walworth | Wisconsin | 55127 | 11719 | 153 |
1150860 | 1150860 | 2021-03-23 | Walworth | Wisconsin | 55127 | 11697 | 153 |
1147613 | 1147613 | 2021-03-22 | Walworth | Wisconsin | 55127 | 11656 | 153 |
1144366 | 1144366 | 2021-03-21 | Walworth | Wisconsin | 55127 | 11648 | 153 |
1141119 | 1141119 | 2021-03-20 | Walworth | Wisconsin | 55127 | 11648 | 153 |
1137873 | 1137873 | 2021-03-19 | Walworth | Wisconsin | 55127 | 11648 | 153 |
1134627 | 1134627 | 2021-03-18 | Walworth | Wisconsin | 55127 | 11629 | 153 |
1131379 | 1131379 | 2021-03-17 | Walworth | Wisconsin | 55127 | 11619 | 152 |
1128132 | 1128132 | 2021-03-16 | Walworth | Wisconsin | 55127 | 11562 | 151 |
1124886 | 1124886 | 2021-03-15 | Walworth | Wisconsin | 55127 | 11562 | 151 |
1121640 | 1121640 | 2021-03-14 | Walworth | Wisconsin | 55127 | 11562 | 151 |
1118393 | 1118393 | 2021-03-13 | Walworth | Wisconsin | 55127 | 11364 | 151 |
1115146 | 1115146 | 2021-03-12 | Walworth | Wisconsin | 55127 | 11356 | 151 |
1111900 | 1111900 | 2021-03-11 | Walworth | Wisconsin | 55127 | 11339 | 150 |
1108654 | 1108654 | 2021-03-10 | Walworth | Wisconsin | 55127 | 11323 | 149 |
1105408 | 1105408 | 2021-03-09 | Walworth | Wisconsin | 55127 | 11315 | 149 |
1102162 | 1102162 | 2021-03-08 | Walworth | Wisconsin | 55127 | 11281 | 149 |
1098916 | 1098916 | 2021-03-07 | Walworth | Wisconsin | 55127 | 11281 | 149 |
1095668 | 1095668 | 2021-03-06 | Walworth | Wisconsin | 55127 | 11281 | 149 |
1092422 | 1092422 | 2021-03-05 | Walworth | Wisconsin | 55127 | 11279 | 149 |
1089176 | 1089176 | 2021-03-04 | Walworth | Wisconsin | 55127 | 11276 | 148 |
1085931 | 1085931 | 2021-03-03 | Walworth | Wisconsin | 55127 | 11259 | 148 |
1082685 | 1082685 | 2021-03-02 | Walworth | Wisconsin | 55127 | 11240 | 148 |
1079439 | 1079439 | 2021-03-01 | Walworth | Wisconsin | 55127 | 11222 | 146 |
1076194 | 1076194 | 2021-02-28 | Walworth | Wisconsin | 55127 | 11222 | 146 |
1072948 | 1072948 | 2021-02-27 | Walworth | Wisconsin | 55127 | 11224 | 146 |
1069702 | 1069702 | 2021-02-26 | Walworth | Wisconsin | 55127 | 11206 | 145 |
1066457 | 1066457 | 2021-02-25 | Walworth | Wisconsin | 55127 | 11187 | 145 |
1063212 | 1063212 | 2021-02-24 | Walworth | Wisconsin | 55127 | 11173 | 145 |
1059967 | 1059967 | 2021-02-23 | Walworth | Wisconsin | 55127 | 11161 | 144 |
1056721 | 1056721 | 2021-02-22 | Walworth | Wisconsin | 55127 | 11146 | 144 |
1053475 | 1053475 | 2021-02-21 | Walworth | Wisconsin | 55127 | 11146 | 144 |
1050228 | 1050228 | 2021-02-20 | Walworth | Wisconsin | 55127 | 11145 | 144 |
1046981 | 1046981 | 2021-02-19 | Walworth | Wisconsin | 55127 | 11146 | 143 |
1043736 | 1043736 | 2021-02-18 | Walworth | Wisconsin | 55127 | 11131 | 143 |
1040491 | 1040491 | 2021-02-17 | Walworth | Wisconsin | 55127 | 11118 | 143 |
1037246 | 1037246 | 2021-02-16 | Walworth | Wisconsin | 55127 | 11108 | 143 |
1034001 | 1034001 | 2021-02-15 | Walworth | Wisconsin | 55127 | 11086 | 143 |
1030755 | 1030755 | 2021-02-14 | Walworth | Wisconsin | 55127 | 11086 | 143 |
1027508 | 1027508 | 2021-02-13 | Walworth | Wisconsin | 55127 | 11076 | 143 |
1024263 | 1024263 | 2021-02-12 | Walworth | Wisconsin | 55127 | 11073 | 143 |
1021018 | 1021018 | 2021-02-11 | Walworth | Wisconsin | 55127 | 11059 | 143 |
1017773 | 1017773 | 2021-02-10 | Walworth | Wisconsin | 55127 | 11036 | 143 |
1014528 | 1014528 | 2021-02-09 | Walworth | Wisconsin | 55127 | 11017 | 139 |
1011283 | 1011283 | 2021-02-08 | Walworth | Wisconsin | 55127 | 11001 | 138 |
1008037 | 1008037 | 2021-02-07 | Walworth | Wisconsin | 55127 | 11001 | 138 |
1004791 | 1004791 | 2021-02-06 | Walworth | Wisconsin | 55127 | 10990 | 138 |
1001545 | 1001545 | 2021-02-05 | Walworth | Wisconsin | 55127 | 10965 | 136 |
998299 | 998299 | 2021-02-04 | Walworth | Wisconsin | 55127 | 10944 | 135 |
995053 | 995053 | 2021-02-03 | Walworth | Wisconsin | 55127 | 10904 | 133 |
991807 | 991807 | 2021-02-02 | Walworth | Wisconsin | 55127 | 10891 | 133 |
988561 | 988561 | 2021-02-01 | Walworth | Wisconsin | 55127 | 10855 | 132 |
985314 | 985314 | 2021-01-31 | Walworth | Wisconsin | 55127 | 10855 | 132 |
982067 | 982067 | 2021-01-30 | Walworth | Wisconsin | 55127 | 10848 | 131 |
978821 | 978821 | 2021-01-29 | Walworth | Wisconsin | 55127 | 10810 | 131 |
975576 | 975576 | 2021-01-28 | Walworth | Wisconsin | 55127 | 10767 | 131 |
972331 | 972331 | 2021-01-27 | Walworth | Wisconsin | 55127 | 10744 | 131 |
969086 | 969086 | 2021-01-26 | Walworth | Wisconsin | 55127 | 10718 | 129 |
965842 | 965842 | 2021-01-25 | Walworth | Wisconsin | 55127 | 10690 | 129 |
962597 | 962597 | 2021-01-24 | Walworth | Wisconsin | 55127 | 10650 | 129 |
959352 | 959352 | 2021-01-23 | Walworth | Wisconsin | 55127 | 10626 | 129 |
956106 | 956106 | 2021-01-22 | Walworth | Wisconsin | 55127 | 10608 | 129 |
952861 | 952861 | 2021-01-21 | Walworth | Wisconsin | 55127 | 10577 | 127 |
949616 | 949616 | 2021-01-20 | Walworth | Wisconsin | 55127 | 10523 | 126 |
946370 | 946370 | 2021-01-19 | Walworth | Wisconsin | 55127 | 10502 | 125 |
943123 | 943123 | 2021-01-18 | Walworth | Wisconsin | 55127 | 10459 | 126 |
939878 | 939878 | 2021-01-17 | Walworth | Wisconsin | 55127 | 10431 | 126 |
936633 | 936633 | 2021-01-16 | Walworth | Wisconsin | 55127 | 10396 | 126 |
933388 | 933388 | 2021-01-15 | Walworth | Wisconsin | 55127 | 10377 | 121 |
930143 | 930143 | 2021-01-14 | Walworth | Wisconsin | 55127 | 10324 | 117 |
926898 | 926898 | 2021-01-13 | Walworth | Wisconsin | 55127 | 10268 | 117 |
923652 | 923652 | 2021-01-12 | Walworth | Wisconsin | 55127 | 10215 | 115 |
920407 | 920407 | 2021-01-11 | Walworth | Wisconsin | 55127 | 10114 | 114 |
917162 | 917162 | 2021-01-10 | Walworth | Wisconsin | 55127 | 10065 | 114 |
913917 | 913917 | 2021-01-09 | Walworth | Wisconsin | 55127 | 10006 | 114 |
910672 | 910672 | 2021-01-08 | Walworth | Wisconsin | 55127 | 9952 | 114 |
907427 | 907427 | 2021-01-07 | Walworth | Wisconsin | 55127 | 9840 | 113 |
904181 | 904181 | 2021-01-06 | Walworth | Wisconsin | 55127 | 9763 | 112 |
900936 | 900936 | 2021-01-05 | Walworth | Wisconsin | 55127 | 9671 | 107 |
897691 | 897691 | 2021-01-04 | Walworth | Wisconsin | 55127 | 9561 | 103 |
894445 | 894445 | 2021-01-03 | Walworth | Wisconsin | 55127 | 9505 | 103 |
891199 | 891199 | 2021-01-02 | Walworth | Wisconsin | 55127 | 9439 | 103 |
887952 | 887952 | 2021-01-01 | Walworth | Wisconsin | 55127 | 9439 | 103 |
884707 | 884707 | 2020-12-31 | Walworth | Wisconsin | 55127 | 9438 | 102 |
881462 | 881462 | 2020-12-30 | Walworth | Wisconsin | 55127 | 9381 | 96 |
878217 | 878217 | 2020-12-29 | Walworth | Wisconsin | 55127 | 9333 | 95 |
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);