ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 55105 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199564 | 1199564 | 2021-04-07 | Rock | Wisconsin | 55105 | 16676 | 185 |
1196315 | 1196315 | 2021-04-06 | Rock | Wisconsin | 55105 | 16630 | 185 |
1193067 | 1193067 | 2021-04-05 | Rock | Wisconsin | 55105 | 16611 | 184 |
1189817 | 1189817 | 2021-04-04 | Rock | Wisconsin | 55105 | 16588 | 184 |
1186570 | 1186570 | 2021-04-03 | Rock | Wisconsin | 55105 | 16558 | 184 |
1183323 | 1183323 | 2021-04-02 | Rock | Wisconsin | 55105 | 16524 | 183 |
1180076 | 1180076 | 2021-04-01 | Rock | Wisconsin | 55105 | 16488 | 183 |
1176829 | 1176829 | 2021-03-31 | Rock | Wisconsin | 55105 | 16446 | 182 |
1173582 | 1173582 | 2021-03-30 | Rock | Wisconsin | 55105 | 16414 | 181 |
1170335 | 1170335 | 2021-03-29 | Rock | Wisconsin | 55105 | 16393 | 179 |
1167087 | 1167087 | 2021-03-28 | Rock | Wisconsin | 55105 | 16376 | 179 |
1163839 | 1163839 | 2021-03-27 | Rock | Wisconsin | 55105 | 16353 | 179 |
1160591 | 1160591 | 2021-03-26 | Rock | Wisconsin | 55105 | 16316 | 179 |
1157343 | 1157343 | 2021-03-25 | Rock | Wisconsin | 55105 | 16287 | 179 |
1154096 | 1154096 | 2021-03-24 | Rock | Wisconsin | 55105 | 16262 | 180 |
1150849 | 1150849 | 2021-03-23 | Rock | Wisconsin | 55105 | 16232 | 179 |
1147602 | 1147602 | 2021-03-22 | Rock | Wisconsin | 55105 | 16227 | 179 |
1144355 | 1144355 | 2021-03-21 | Rock | Wisconsin | 55105 | 16196 | 179 |
1141108 | 1141108 | 2021-03-20 | Rock | Wisconsin | 55105 | 16184 | 179 |
1137862 | 1137862 | 2021-03-19 | Rock | Wisconsin | 55105 | 16172 | 177 |
1134616 | 1134616 | 2021-03-18 | Rock | Wisconsin | 55105 | 16153 | 176 |
1131368 | 1131368 | 2021-03-17 | Rock | Wisconsin | 55105 | 16138 | 177 |
1128121 | 1128121 | 2021-03-16 | Rock | Wisconsin | 55105 | 16116 | 176 |
1124875 | 1124875 | 2021-03-15 | Rock | Wisconsin | 55105 | 16112 | 176 |
1121629 | 1121629 | 2021-03-14 | Rock | Wisconsin | 55105 | 16108 | 176 |
1118382 | 1118382 | 2021-03-13 | Rock | Wisconsin | 55105 | 16107 | 176 |
1115135 | 1115135 | 2021-03-12 | Rock | Wisconsin | 55105 | 16081 | 176 |
1111889 | 1111889 | 2021-03-11 | Rock | Wisconsin | 55105 | 16070 | 176 |
1108643 | 1108643 | 2021-03-10 | Rock | Wisconsin | 55105 | 16053 | 176 |
1105397 | 1105397 | 2021-03-09 | Rock | Wisconsin | 55105 | 16032 | 175 |
1102151 | 1102151 | 2021-03-08 | Rock | Wisconsin | 55105 | 16021 | 173 |
1098905 | 1098905 | 2021-03-07 | Rock | Wisconsin | 55105 | 16019 | 173 |
1095657 | 1095657 | 2021-03-06 | Rock | Wisconsin | 55105 | 16008 | 173 |
1092411 | 1092411 | 2021-03-05 | Rock | Wisconsin | 55105 | 15996 | 173 |
1089165 | 1089165 | 2021-03-04 | Rock | Wisconsin | 55105 | 15981 | 173 |
1085920 | 1085920 | 2021-03-03 | Rock | Wisconsin | 55105 | 15967 | 173 |
1082674 | 1082674 | 2021-03-02 | Rock | Wisconsin | 55105 | 15958 | 173 |
1079428 | 1079428 | 2021-03-01 | Rock | Wisconsin | 55105 | 15941 | 173 |
1076183 | 1076183 | 2021-02-28 | Rock | Wisconsin | 55105 | 15950 | 173 |
1072937 | 1072937 | 2021-02-27 | Rock | Wisconsin | 55105 | 15944 | 173 |
1069691 | 1069691 | 2021-02-26 | Rock | Wisconsin | 55105 | 15932 | 172 |
1066446 | 1066446 | 2021-02-25 | Rock | Wisconsin | 55105 | 15903 | 171 |
1063201 | 1063201 | 2021-02-24 | Rock | Wisconsin | 55105 | 15884 | 170 |
1059956 | 1059956 | 2021-02-23 | Rock | Wisconsin | 55105 | 15863 | 167 |
1056710 | 1056710 | 2021-02-22 | Rock | Wisconsin | 55105 | 15857 | 165 |
1053464 | 1053464 | 2021-02-21 | Rock | Wisconsin | 55105 | 15846 | 165 |
1050217 | 1050217 | 2021-02-20 | Rock | Wisconsin | 55105 | 15833 | 165 |
1046970 | 1046970 | 2021-02-19 | Rock | Wisconsin | 55105 | 15817 | 165 |
1043725 | 1043725 | 2021-02-18 | Rock | Wisconsin | 55105 | 15795 | 165 |
1040480 | 1040480 | 2021-02-17 | Rock | Wisconsin | 55105 | 15772 | 165 |
1037235 | 1037235 | 2021-02-16 | Rock | Wisconsin | 55105 | 15755 | 165 |
1033990 | 1033990 | 2021-02-15 | Rock | Wisconsin | 55105 | 15737 | 165 |
1030744 | 1030744 | 2021-02-14 | Rock | Wisconsin | 55105 | 15710 | 164 |
1027497 | 1027497 | 2021-02-13 | Rock | Wisconsin | 55105 | 15675 | 164 |
1024252 | 1024252 | 2021-02-12 | Rock | Wisconsin | 55105 | 15647 | 162 |
1021007 | 1021007 | 2021-02-11 | Rock | Wisconsin | 55105 | 15609 | 162 |
1017762 | 1017762 | 2021-02-10 | Rock | Wisconsin | 55105 | 15556 | 162 |
1014517 | 1014517 | 2021-02-09 | Rock | Wisconsin | 55105 | 15491 | 162 |
1011272 | 1011272 | 2021-02-08 | Rock | Wisconsin | 55105 | 15482 | 161 |
1008026 | 1008026 | 2021-02-07 | Rock | Wisconsin | 55105 | 15468 | 161 |
1004780 | 1004780 | 2021-02-06 | Rock | Wisconsin | 55105 | 15449 | 161 |
1001534 | 1001534 | 2021-02-05 | Rock | Wisconsin | 55105 | 15423 | 160 |
998288 | 998288 | 2021-02-04 | Rock | Wisconsin | 55105 | 15352 | 158 |
995042 | 995042 | 2021-02-03 | Rock | Wisconsin | 55105 | 15296 | 158 |
991796 | 991796 | 2021-02-02 | Rock | Wisconsin | 55105 | 15268 | 158 |
988550 | 988550 | 2021-02-01 | Rock | Wisconsin | 55105 | 15229 | 157 |
985303 | 985303 | 2021-01-31 | Rock | Wisconsin | 55105 | 15210 | 157 |
982056 | 982056 | 2021-01-30 | Rock | Wisconsin | 55105 | 15178 | 157 |
978810 | 978810 | 2021-01-29 | Rock | Wisconsin | 55105 | 15124 | 152 |
975565 | 975565 | 2021-01-28 | Rock | Wisconsin | 55105 | 15083 | 150 |
972320 | 972320 | 2021-01-27 | Rock | Wisconsin | 55105 | 15033 | 150 |
969075 | 969075 | 2021-01-26 | Rock | Wisconsin | 55105 | 14997 | 149 |
965831 | 965831 | 2021-01-25 | Rock | Wisconsin | 55105 | 14949 | 148 |
962586 | 962586 | 2021-01-24 | Rock | Wisconsin | 55105 | 14925 | 148 |
959341 | 959341 | 2021-01-23 | Rock | Wisconsin | 55105 | 14871 | 146 |
956095 | 956095 | 2021-01-22 | Rock | Wisconsin | 55105 | 14780 | 145 |
952850 | 952850 | 2021-01-21 | Rock | Wisconsin | 55105 | 14718 | 145 |
949605 | 949605 | 2021-01-20 | Rock | Wisconsin | 55105 | 14642 | 143 |
946359 | 946359 | 2021-01-19 | Rock | Wisconsin | 55105 | 14585 | 142 |
943112 | 943112 | 2021-01-18 | Rock | Wisconsin | 55105 | 14526 | 140 |
939867 | 939867 | 2021-01-17 | Rock | Wisconsin | 55105 | 14488 | 140 |
936622 | 936622 | 2021-01-16 | Rock | Wisconsin | 55105 | 14404 | 140 |
933377 | 933377 | 2021-01-15 | Rock | Wisconsin | 55105 | 14341 | 138 |
930132 | 930132 | 2021-01-14 | Rock | Wisconsin | 55105 | 14241 | 136 |
926887 | 926887 | 2021-01-13 | Rock | Wisconsin | 55105 | 14126 | 135 |
923641 | 923641 | 2021-01-12 | Rock | Wisconsin | 55105 | 14089 | 134 |
920396 | 920396 | 2021-01-11 | Rock | Wisconsin | 55105 | 13975 | 131 |
917151 | 917151 | 2021-01-10 | Rock | Wisconsin | 55105 | 13919 | 131 |
913906 | 913906 | 2021-01-09 | Rock | Wisconsin | 55105 | 13887 | 131 |
910661 | 910661 | 2021-01-08 | Rock | Wisconsin | 55105 | 13770 | 131 |
907416 | 907416 | 2021-01-07 | Rock | Wisconsin | 55105 | 13634 | 128 |
904170 | 904170 | 2021-01-06 | Rock | Wisconsin | 55105 | 13516 | 128 |
900925 | 900925 | 2021-01-05 | Rock | Wisconsin | 55105 | 13411 | 127 |
897680 | 897680 | 2021-01-04 | Rock | Wisconsin | 55105 | 13267 | 125 |
894434 | 894434 | 2021-01-03 | Rock | Wisconsin | 55105 | 13216 | 126 |
891188 | 891188 | 2021-01-02 | Rock | Wisconsin | 55105 | 13175 | 126 |
887941 | 887941 | 2021-01-01 | Rock | Wisconsin | 55105 | 13134 | 126 |
884696 | 884696 | 2020-12-31 | Rock | Wisconsin | 55105 | 13032 | 126 |
881451 | 881451 | 2020-12-30 | Rock | Wisconsin | 55105 | 12895 | 124 |
878206 | 878206 | 2020-12-29 | Rock | Wisconsin | 55105 | 12776 | 123 |
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);