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 |
---|---|---|---|---|---|---|---|
1199523 | 1199523 | 2021-04-07 | Dane | Wisconsin | 55025 | 44022 | 312 |
1196274 | 1196274 | 2021-04-06 | Dane | Wisconsin | 55025 | 43962 | 312 |
1193026 | 1193026 | 2021-04-05 | Dane | Wisconsin | 55025 | 43921 | 312 |
1189776 | 1189776 | 2021-04-04 | Dane | Wisconsin | 55025 | 43843 | 312 |
1186529 | 1186529 | 2021-04-03 | Dane | Wisconsin | 55025 | 43761 | 312 |
1183282 | 1183282 | 2021-04-02 | Dane | Wisconsin | 55025 | 43678 | 312 |
1180035 | 1180035 | 2021-04-01 | Dane | Wisconsin | 55025 | 43593 | 312 |
1176788 | 1176788 | 2021-03-31 | Dane | Wisconsin | 55025 | 43511 | 311 |
1173541 | 1173541 | 2021-03-30 | Dane | Wisconsin | 55025 | 43505 | 311 |
1170294 | 1170294 | 2021-03-29 | Dane | Wisconsin | 55025 | 43484 | 311 |
1167046 | 1167046 | 2021-03-28 | Dane | Wisconsin | 55025 | 43436 | 311 |
1163798 | 1163798 | 2021-03-27 | Dane | Wisconsin | 55025 | 43386 | 311 |
1160550 | 1160550 | 2021-03-26 | Dane | Wisconsin | 55025 | 43339 | 311 |
1157302 | 1157302 | 2021-03-25 | Dane | Wisconsin | 55025 | 43280 | 312 |
1154055 | 1154055 | 2021-03-24 | Dane | Wisconsin | 55025 | 43226 | 311 |
1150808 | 1150808 | 2021-03-23 | Dane | Wisconsin | 55025 | 43155 | 311 |
1147561 | 1147561 | 2021-03-22 | Dane | Wisconsin | 55025 | 43155 | 311 |
1144314 | 1144314 | 2021-03-21 | Dane | Wisconsin | 55025 | 43124 | 311 |
1141067 | 1141067 | 2021-03-20 | Dane | Wisconsin | 55025 | 43074 | 311 |
1137821 | 1137821 | 2021-03-19 | Dane | Wisconsin | 55025 | 43046 | 305 |
1134575 | 1134575 | 2021-03-18 | Dane | Wisconsin | 55025 | 42998 | 305 |
1131327 | 1131327 | 2021-03-17 | Dane | Wisconsin | 55025 | 42929 | 305 |
1128080 | 1128080 | 2021-03-16 | Dane | Wisconsin | 55025 | 42886 | 303 |
1124834 | 1124834 | 2021-03-15 | Dane | Wisconsin | 55025 | 42840 | 303 |
1121588 | 1121588 | 2021-03-14 | Dane | Wisconsin | 55025 | 42818 | 303 |
1118341 | 1118341 | 2021-03-13 | Dane | Wisconsin | 55025 | 42784 | 303 |
1115094 | 1115094 | 2021-03-12 | Dane | Wisconsin | 55025 | 42751 | 303 |
1111848 | 1111848 | 2021-03-11 | Dane | Wisconsin | 55025 | 42710 | 303 |
1108602 | 1108602 | 2021-03-10 | Dane | Wisconsin | 55025 | 42626 | 302 |
1105356 | 1105356 | 2021-03-09 | Dane | Wisconsin | 55025 | 42580 | 301 |
1102110 | 1102110 | 2021-03-08 | Dane | Wisconsin | 55025 | 42553 | 301 |
1098864 | 1098864 | 2021-03-07 | Dane | Wisconsin | 55025 | 42524 | 301 |
1095616 | 1095616 | 2021-03-06 | Dane | Wisconsin | 55025 | 42470 | 301 |
1092370 | 1092370 | 2021-03-05 | Dane | Wisconsin | 55025 | 42394 | 301 |
1089124 | 1089124 | 2021-03-04 | Dane | Wisconsin | 55025 | 42346 | 301 |
1085879 | 1085879 | 2021-03-03 | Dane | Wisconsin | 55025 | 42232 | 296 |
1082633 | 1082633 | 2021-03-02 | Dane | Wisconsin | 55025 | 42169 | 296 |
1079387 | 1079387 | 2021-03-01 | Dane | Wisconsin | 55025 | 42157 | 296 |
1076142 | 1076142 | 2021-02-28 | Dane | Wisconsin | 55025 | 42100 | 296 |
1072896 | 1072896 | 2021-02-27 | Dane | Wisconsin | 55025 | 42010 | 296 |
1069650 | 1069650 | 2021-02-26 | Dane | Wisconsin | 55025 | 41844 | 296 |
1066405 | 1066405 | 2021-02-25 | Dane | Wisconsin | 55025 | 41764 | 295 |
1063160 | 1063160 | 2021-02-24 | Dane | Wisconsin | 55025 | 41685 | 295 |
1059915 | 1059915 | 2021-02-23 | Dane | Wisconsin | 55025 | 41601 | 295 |
1056669 | 1056669 | 2021-02-22 | Dane | Wisconsin | 55025 | 41556 | 289 |
1053423 | 1053423 | 2021-02-21 | Dane | Wisconsin | 55025 | 41503 | 289 |
1050176 | 1050176 | 2021-02-20 | Dane | Wisconsin | 55025 | 41416 | 289 |
1046929 | 1046929 | 2021-02-19 | Dane | Wisconsin | 55025 | 41296 | 290 |
1043684 | 1043684 | 2021-02-18 | Dane | Wisconsin | 55025 | 41134 | 289 |
1040439 | 1040439 | 2021-02-17 | Dane | Wisconsin | 55025 | 40988 | 286 |
1037194 | 1037194 | 2021-02-16 | Dane | Wisconsin | 55025 | 40905 | 286 |
1033949 | 1033949 | 2021-02-15 | Dane | Wisconsin | 55025 | 40869 | 286 |
1030703 | 1030703 | 2021-02-14 | Dane | Wisconsin | 55025 | 40822 | 286 |
1027456 | 1027456 | 2021-02-13 | Dane | Wisconsin | 55025 | 40759 | 286 |
1024211 | 1024211 | 2021-02-12 | Dane | Wisconsin | 55025 | 40680 | 286 |
1020966 | 1020966 | 2021-02-11 | Dane | Wisconsin | 55025 | 40593 | 286 |
1017721 | 1017721 | 2021-02-10 | Dane | Wisconsin | 55025 | 40447 | 285 |
1014476 | 1014476 | 2021-02-09 | Dane | Wisconsin | 55025 | 40344 | 285 |
1011231 | 1011231 | 2021-02-08 | Dane | Wisconsin | 55025 | 40302 | 277 |
1007985 | 1007985 | 2021-02-07 | Dane | Wisconsin | 55025 | 40200 | 277 |
1004739 | 1004739 | 2021-02-06 | Dane | Wisconsin | 55025 | 40120 | 277 |
1001493 | 1001493 | 2021-02-05 | Dane | Wisconsin | 55025 | 40017 | 277 |
998247 | 998247 | 2021-02-04 | Dane | Wisconsin | 55025 | 39891 | 277 |
995001 | 995001 | 2021-02-03 | Dane | Wisconsin | 55025 | 39669 | 272 |
991755 | 991755 | 2021-02-02 | Dane | Wisconsin | 55025 | 39588 | 272 |
988509 | 988509 | 2021-02-01 | Dane | Wisconsin | 55025 | 39531 | 272 |
985262 | 985262 | 2021-01-31 | Dane | Wisconsin | 55025 | 39460 | 272 |
982015 | 982015 | 2021-01-30 | Dane | Wisconsin | 55025 | 39346 | 272 |
978769 | 978769 | 2021-01-29 | Dane | Wisconsin | 55025 | 39207 | 266 |
975524 | 975524 | 2021-01-28 | Dane | Wisconsin | 55025 | 39091 | 265 |
972279 | 972279 | 2021-01-27 | Dane | Wisconsin | 55025 | 38887 | 260 |
969034 | 969034 | 2021-01-26 | Dane | Wisconsin | 55025 | 38839 | 260 |
965790 | 965790 | 2021-01-25 | Dane | Wisconsin | 55025 | 38783 | 249 |
962545 | 962545 | 2021-01-24 | Dane | Wisconsin | 55025 | 38687 | 251 |
959300 | 959300 | 2021-01-23 | Dane | Wisconsin | 55025 | 38574 | 249 |
956054 | 956054 | 2021-01-22 | Dane | Wisconsin | 55025 | 38432 | 248 |
952809 | 952809 | 2021-01-21 | Dane | Wisconsin | 55025 | 38228 | 248 |
949564 | 949564 | 2021-01-20 | Dane | Wisconsin | 55025 | 38065 | 248 |
946318 | 946318 | 2021-01-19 | Dane | Wisconsin | 55025 | 38001 | 237 |
943071 | 943071 | 2021-01-18 | Dane | Wisconsin | 55025 | 37953 | 237 |
939826 | 939826 | 2021-01-17 | Dane | Wisconsin | 55025 | 37865 | 237 |
936581 | 936581 | 2021-01-16 | Dane | Wisconsin | 55025 | 37728 | 237 |
933336 | 933336 | 2021-01-15 | Dane | Wisconsin | 55025 | 37556 | 237 |
930091 | 930091 | 2021-01-14 | Dane | Wisconsin | 55025 | 37364 | 237 |
926846 | 926846 | 2021-01-13 | Dane | Wisconsin | 55025 | 37115 | 233 |
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 |
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);