ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55073 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199547 | 1199547 | 2021-04-07 | Marathon | Wisconsin | 55073 | 15460 | 218 |
1196298 | 1196298 | 2021-04-06 | Marathon | Wisconsin | 55073 | 15439 | 218 |
1193050 | 1193050 | 2021-04-05 | Marathon | Wisconsin | 55073 | 15424 | 218 |
1189800 | 1189800 | 2021-04-04 | Marathon | Wisconsin | 55073 | 15417 | 218 |
1186553 | 1186553 | 2021-04-03 | Marathon | Wisconsin | 55073 | 15399 | 218 |
1183306 | 1183306 | 2021-04-02 | Marathon | Wisconsin | 55073 | 15374 | 218 |
1180059 | 1180059 | 2021-04-01 | Marathon | Wisconsin | 55073 | 15362 | 218 |
1176812 | 1176812 | 2021-03-31 | Marathon | Wisconsin | 55073 | 15335 | 218 |
1173565 | 1173565 | 2021-03-30 | Marathon | Wisconsin | 55073 | 15320 | 218 |
1170318 | 1170318 | 2021-03-29 | Marathon | Wisconsin | 55073 | 15312 | 218 |
1167070 | 1167070 | 2021-03-28 | Marathon | Wisconsin | 55073 | 15308 | 218 |
1163822 | 1163822 | 2021-03-27 | Marathon | Wisconsin | 55073 | 15297 | 218 |
1160574 | 1160574 | 2021-03-26 | Marathon | Wisconsin | 55073 | 15289 | 218 |
1157326 | 1157326 | 2021-03-25 | Marathon | Wisconsin | 55073 | 15272 | 218 |
1154079 | 1154079 | 2021-03-24 | Marathon | Wisconsin | 55073 | 15265 | 218 |
1150832 | 1150832 | 2021-03-23 | Marathon | Wisconsin | 55073 | 15261 | 217 |
1147585 | 1147585 | 2021-03-22 | Marathon | Wisconsin | 55073 | 15261 | 217 |
1144338 | 1144338 | 2021-03-21 | Marathon | Wisconsin | 55073 | 15258 | 217 |
1141091 | 1141091 | 2021-03-20 | Marathon | Wisconsin | 55073 | 15250 | 217 |
1137845 | 1137845 | 2021-03-19 | Marathon | Wisconsin | 55073 | 15240 | 217 |
1134599 | 1134599 | 2021-03-18 | Marathon | Wisconsin | 55073 | 15223 | 217 |
1131351 | 1131351 | 2021-03-17 | Marathon | Wisconsin | 55073 | 15209 | 217 |
1128104 | 1128104 | 2021-03-16 | Marathon | Wisconsin | 55073 | 15201 | 217 |
1124858 | 1124858 | 2021-03-15 | Marathon | Wisconsin | 55073 | 15192 | 217 |
1121612 | 1121612 | 2021-03-14 | Marathon | Wisconsin | 55073 | 15185 | 217 |
1118365 | 1118365 | 2021-03-13 | Marathon | Wisconsin | 55073 | 15174 | 217 |
1115118 | 1115118 | 2021-03-12 | Marathon | Wisconsin | 55073 | 15165 | 216 |
1111872 | 1111872 | 2021-03-11 | Marathon | Wisconsin | 55073 | 15150 | 216 |
1108626 | 1108626 | 2021-03-10 | Marathon | Wisconsin | 55073 | 15140 | 215 |
1105380 | 1105380 | 2021-03-09 | Marathon | Wisconsin | 55073 | 15133 | 215 |
1102134 | 1102134 | 2021-03-08 | Marathon | Wisconsin | 55073 | 15119 | 214 |
1098888 | 1098888 | 2021-03-07 | Marathon | Wisconsin | 55073 | 15112 | 214 |
1095640 | 1095640 | 2021-03-06 | Marathon | Wisconsin | 55073 | 15107 | 214 |
1092394 | 1092394 | 2021-03-05 | Marathon | Wisconsin | 55073 | 15093 | 214 |
1089148 | 1089148 | 2021-03-04 | Marathon | Wisconsin | 55073 | 15070 | 214 |
1085903 | 1085903 | 2021-03-03 | Marathon | Wisconsin | 55073 | 15063 | 214 |
1082657 | 1082657 | 2021-03-02 | Marathon | Wisconsin | 55073 | 15048 | 209 |
1079411 | 1079411 | 2021-03-01 | Marathon | Wisconsin | 55073 | 15037 | 209 |
1076166 | 1076166 | 2021-02-28 | Marathon | Wisconsin | 55073 | 15025 | 209 |
1072920 | 1072920 | 2021-02-27 | Marathon | Wisconsin | 55073 | 15014 | 209 |
1069674 | 1069674 | 2021-02-26 | Marathon | Wisconsin | 55073 | 14995 | 209 |
1066429 | 1066429 | 2021-02-25 | Marathon | Wisconsin | 55073 | 14976 | 209 |
1063184 | 1063184 | 2021-02-24 | Marathon | Wisconsin | 55073 | 14958 | 208 |
1059939 | 1059939 | 2021-02-23 | Marathon | Wisconsin | 55073 | 14940 | 207 |
1056693 | 1056693 | 2021-02-22 | Marathon | Wisconsin | 55073 | 14917 | 204 |
1053447 | 1053447 | 2021-02-21 | Marathon | Wisconsin | 55073 | 14903 | 204 |
1050200 | 1050200 | 2021-02-20 | Marathon | Wisconsin | 55073 | 14896 | 204 |
1046953 | 1046953 | 2021-02-19 | Marathon | Wisconsin | 55073 | 14873 | 204 |
1043708 | 1043708 | 2021-02-18 | Marathon | Wisconsin | 55073 | 14858 | 203 |
1040463 | 1040463 | 2021-02-17 | Marathon | Wisconsin | 55073 | 14848 | 203 |
1037218 | 1037218 | 2021-02-16 | Marathon | Wisconsin | 55073 | 14835 | 203 |
1033973 | 1033973 | 2021-02-15 | Marathon | Wisconsin | 55073 | 14827 | 203 |
1030727 | 1030727 | 2021-02-14 | Marathon | Wisconsin | 55073 | 14820 | 203 |
1027480 | 1027480 | 2021-02-13 | Marathon | Wisconsin | 55073 | 14804 | 203 |
1024235 | 1024235 | 2021-02-12 | Marathon | Wisconsin | 55073 | 14788 | 203 |
1020990 | 1020990 | 2021-02-11 | Marathon | Wisconsin | 55073 | 14775 | 202 |
1017745 | 1017745 | 2021-02-10 | Marathon | Wisconsin | 55073 | 14742 | 202 |
1014500 | 1014500 | 2021-02-09 | Marathon | Wisconsin | 55073 | 14723 | 202 |
1011255 | 1011255 | 2021-02-08 | Marathon | Wisconsin | 55073 | 14715 | 202 |
1008009 | 1008009 | 2021-02-07 | Marathon | Wisconsin | 55073 | 14712 | 202 |
1004763 | 1004763 | 2021-02-06 | Marathon | Wisconsin | 55073 | 14698 | 202 |
1001517 | 1001517 | 2021-02-05 | Marathon | Wisconsin | 55073 | 14695 | 202 |
998271 | 998271 | 2021-02-04 | Marathon | Wisconsin | 55073 | 14680 | 201 |
995025 | 995025 | 2021-02-03 | Marathon | Wisconsin | 55073 | 14658 | 201 |
991779 | 991779 | 2021-02-02 | Marathon | Wisconsin | 55073 | 14643 | 201 |
988533 | 988533 | 2021-02-01 | Marathon | Wisconsin | 55073 | 14620 | 201 |
985286 | 985286 | 2021-01-31 | Marathon | Wisconsin | 55073 | 14609 | 201 |
982039 | 982039 | 2021-01-30 | Marathon | Wisconsin | 55073 | 14584 | 201 |
978793 | 978793 | 2021-01-29 | Marathon | Wisconsin | 55073 | 14568 | 201 |
975548 | 975548 | 2021-01-28 | Marathon | Wisconsin | 55073 | 14532 | 201 |
972303 | 972303 | 2021-01-27 | Marathon | Wisconsin | 55073 | 14493 | 201 |
969058 | 969058 | 2021-01-26 | Marathon | Wisconsin | 55073 | 14457 | 201 |
965814 | 965814 | 2021-01-25 | Marathon | Wisconsin | 55073 | 14417 | 200 |
962569 | 962569 | 2021-01-24 | Marathon | Wisconsin | 55073 | 14395 | 200 |
959324 | 959324 | 2021-01-23 | Marathon | Wisconsin | 55073 | 14358 | 200 |
956078 | 956078 | 2021-01-22 | Marathon | Wisconsin | 55073 | 14306 | 199 |
952833 | 952833 | 2021-01-21 | Marathon | Wisconsin | 55073 | 14278 | 199 |
949588 | 949588 | 2021-01-20 | Marathon | Wisconsin | 55073 | 14233 | 197 |
946342 | 946342 | 2021-01-19 | Marathon | Wisconsin | 55073 | 14184 | 196 |
943095 | 943095 | 2021-01-18 | Marathon | Wisconsin | 55073 | 14129 | 194 |
939850 | 939850 | 2021-01-17 | Marathon | Wisconsin | 55073 | 14108 | 194 |
936605 | 936605 | 2021-01-16 | Marathon | Wisconsin | 55073 | 14058 | 194 |
933360 | 933360 | 2021-01-15 | Marathon | Wisconsin | 55073 | 14011 | 193 |
930115 | 930115 | 2021-01-14 | Marathon | Wisconsin | 55073 | 13929 | 193 |
926870 | 926870 | 2021-01-13 | Marathon | Wisconsin | 55073 | 13893 | 193 |
923624 | 923624 | 2021-01-12 | Marathon | Wisconsin | 55073 | 13827 | 188 |
920379 | 920379 | 2021-01-11 | Marathon | Wisconsin | 55073 | 13752 | 185 |
917134 | 917134 | 2021-01-10 | Marathon | Wisconsin | 55073 | 13698 | 185 |
913889 | 913889 | 2021-01-09 | Marathon | Wisconsin | 55073 | 13662 | 185 |
910644 | 910644 | 2021-01-08 | Marathon | Wisconsin | 55073 | 13562 | 185 |
907399 | 907399 | 2021-01-07 | Marathon | Wisconsin | 55073 | 13509 | 185 |
904153 | 904153 | 2021-01-06 | Marathon | Wisconsin | 55073 | 13422 | 185 |
900908 | 900908 | 2021-01-05 | Marathon | Wisconsin | 55073 | 13329 | 183 |
897663 | 897663 | 2021-01-04 | Marathon | Wisconsin | 55073 | 13234 | 183 |
894417 | 894417 | 2021-01-03 | Marathon | Wisconsin | 55073 | 13210 | 183 |
891171 | 891171 | 2021-01-02 | Marathon | Wisconsin | 55073 | 13134 | 183 |
887924 | 887924 | 2021-01-01 | Marathon | Wisconsin | 55073 | 13133 | 183 |
884679 | 884679 | 2020-12-31 | Marathon | Wisconsin | 55073 | 13062 | 183 |
881434 | 881434 | 2020-12-30 | Marathon | Wisconsin | 55073 | 12967 | 179 |
878189 | 878189 | 2020-12-29 | Marathon | Wisconsin | 55073 | 12903 | 178 |
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);