ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Winnebago" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1066463 | 1066463 | 2021-02-25 | Winnebago | Wisconsin | 55139 | 19702 | 204 |
1063218 | 1063218 | 2021-02-24 | Winnebago | Wisconsin | 55139 | 19661 | 204 |
1059973 | 1059973 | 2021-02-23 | Winnebago | Wisconsin | 55139 | 19632 | 204 |
1056727 | 1056727 | 2021-02-22 | Winnebago | Wisconsin | 55139 | 19613 | 203 |
1053481 | 1053481 | 2021-02-21 | Winnebago | Wisconsin | 55139 | 19581 | 203 |
1050234 | 1050234 | 2021-02-20 | Winnebago | Wisconsin | 55139 | 19579 | 203 |
1046987 | 1046987 | 2021-02-19 | Winnebago | Wisconsin | 55139 | 19560 | 201 |
1043742 | 1043742 | 2021-02-18 | Winnebago | Wisconsin | 55139 | 19535 | 199 |
1040497 | 1040497 | 2021-02-17 | Winnebago | Wisconsin | 55139 | 19504 | 199 |
1037252 | 1037252 | 2021-02-16 | Winnebago | Wisconsin | 55139 | 19477 | 199 |
1034007 | 1034007 | 2021-02-15 | Winnebago | Wisconsin | 55139 | 19450 | 197 |
1030761 | 1030761 | 2021-02-14 | Winnebago | Wisconsin | 55139 | 19427 | 197 |
1027514 | 1027514 | 2021-02-13 | Winnebago | Wisconsin | 55139 | 19419 | 197 |
1024269 | 1024269 | 2021-02-12 | Winnebago | Wisconsin | 55139 | 19394 | 197 |
1021024 | 1021024 | 2021-02-11 | Winnebago | Wisconsin | 55139 | 19354 | 196 |
1017779 | 1017779 | 2021-02-10 | Winnebago | Wisconsin | 55139 | 19307 | 196 |
1014534 | 1014534 | 2021-02-09 | Winnebago | Wisconsin | 55139 | 19294 | 194 |
1011289 | 1011289 | 2021-02-08 | Winnebago | Wisconsin | 55139 | 19273 | 194 |
1008043 | 1008043 | 2021-02-07 | Winnebago | Wisconsin | 55139 | 19255 | 194 |
1004797 | 1004797 | 2021-02-06 | Winnebago | Wisconsin | 55139 | 19232 | 192 |
1001551 | 1001551 | 2021-02-05 | Winnebago | Wisconsin | 55139 | 19211 | 190 |
998305 | 998305 | 2021-02-04 | Winnebago | Wisconsin | 55139 | 19177 | 189 |
995059 | 995059 | 2021-02-03 | Winnebago | Wisconsin | 55139 | 19137 | 189 |
991813 | 991813 | 2021-02-02 | Winnebago | Wisconsin | 55139 | 19098 | 188 |
988567 | 988567 | 2021-02-01 | Winnebago | Wisconsin | 55139 | 19066 | 188 |
985320 | 985320 | 2021-01-31 | Winnebago | Wisconsin | 55139 | 19048 | 188 |
982073 | 982073 | 2021-01-30 | Winnebago | Wisconsin | 55139 | 19019 | 188 |
978827 | 978827 | 2021-01-29 | Winnebago | Wisconsin | 55139 | 18977 | 187 |
975582 | 975582 | 2021-01-28 | Winnebago | Wisconsin | 55139 | 18929 | 186 |
972337 | 972337 | 2021-01-27 | Winnebago | Wisconsin | 55139 | 18853 | 186 |
969092 | 969092 | 2021-01-26 | Winnebago | Wisconsin | 55139 | 18790 | 185 |
965848 | 965848 | 2021-01-25 | Winnebago | Wisconsin | 55139 | 18762 | 185 |
962603 | 962603 | 2021-01-24 | Winnebago | Wisconsin | 55139 | 18745 | 184 |
959358 | 959358 | 2021-01-23 | Winnebago | Wisconsin | 55139 | 18687 | 184 |
956112 | 956112 | 2021-01-22 | Winnebago | Wisconsin | 55139 | 18620 | 184 |
952867 | 952867 | 2021-01-21 | Winnebago | Wisconsin | 55139 | 18556 | 184 |
949622 | 949622 | 2021-01-20 | Winnebago | Wisconsin | 55139 | 18446 | 184 |
946376 | 946376 | 2021-01-19 | Winnebago | Wisconsin | 55139 | 18406 | 184 |
943129 | 943129 | 2021-01-18 | Winnebago | Wisconsin | 55139 | 18361 | 183 |
939884 | 939884 | 2021-01-17 | Winnebago | Wisconsin | 55139 | 18336 | 183 |
936639 | 936639 | 2021-01-16 | Winnebago | Wisconsin | 55139 | 18277 | 183 |
933394 | 933394 | 2021-01-15 | Winnebago | Wisconsin | 55139 | 18204 | 182 |
930149 | 930149 | 2021-01-14 | Winnebago | Wisconsin | 55139 | 18117 | 181 |
926904 | 926904 | 2021-01-13 | Winnebago | Wisconsin | 55139 | 18011 | 180 |
923658 | 923658 | 2021-01-12 | Winnebago | Wisconsin | 55139 | 17932 | 180 |
920413 | 920413 | 2021-01-11 | Winnebago | Wisconsin | 55139 | 17877 | 175 |
917168 | 917168 | 2021-01-10 | Winnebago | Wisconsin | 55139 | 17833 | 175 |
913923 | 913923 | 2021-01-09 | Winnebago | Wisconsin | 55139 | 17760 | 175 |
910678 | 910678 | 2021-01-08 | Winnebago | Wisconsin | 55139 | 17671 | 175 |
907433 | 907433 | 2021-01-07 | Winnebago | Wisconsin | 55139 | 17519 | 174 |
904187 | 904187 | 2021-01-06 | Winnebago | Wisconsin | 55139 | 17396 | 173 |
900942 | 900942 | 2021-01-05 | Winnebago | Wisconsin | 55139 | 17318 | 171 |
897697 | 897697 | 2021-01-04 | Winnebago | Wisconsin | 55139 | 17246 | 168 |
894451 | 894451 | 2021-01-03 | Winnebago | Wisconsin | 55139 | 17217 | 166 |
891205 | 891205 | 2021-01-02 | Winnebago | Wisconsin | 55139 | 17206 | 166 |
887958 | 887958 | 2021-01-01 | Winnebago | Wisconsin | 55139 | 17128 | 166 |
884713 | 884713 | 2020-12-31 | Winnebago | Wisconsin | 55139 | 17021 | 165 |
881468 | 881468 | 2020-12-30 | Winnebago | Wisconsin | 55139 | 16937 | 164 |
878223 | 878223 | 2020-12-29 | Winnebago | Wisconsin | 55139 | 16870 | 164 |
874978 | 874978 | 2020-12-28 | Winnebago | Wisconsin | 55139 | 16832 | 164 |
871733 | 871733 | 2020-12-27 | Winnebago | Wisconsin | 55139 | 16810 | 164 |
868488 | 868488 | 2020-12-26 | Winnebago | Wisconsin | 55139 | 16776 | 164 |
865243 | 865243 | 2020-12-25 | Winnebago | Wisconsin | 55139 | 16667 | 164 |
861998 | 861998 | 2020-12-24 | Winnebago | Wisconsin | 55139 | 16655 | 164 |
858753 | 858753 | 2020-12-23 | Winnebago | Wisconsin | 55139 | 16557 | 164 |
855508 | 855508 | 2020-12-22 | Winnebago | Wisconsin | 55139 | 16506 | 161 |
852263 | 852263 | 2020-12-21 | Winnebago | Wisconsin | 55139 | 16441 | 161 |
849018 | 849018 | 2020-12-20 | Winnebago | Wisconsin | 55139 | 16373 | 161 |
845773 | 845773 | 2020-12-19 | Winnebago | Wisconsin | 55139 | 16303 | 158 |
842527 | 842527 | 2020-12-18 | Winnebago | Wisconsin | 55139 | 16235 | 158 |
839282 | 839282 | 2020-12-17 | Winnebago | Wisconsin | 55139 | 16122 | 158 |
836037 | 836037 | 2020-12-16 | Winnebago | Wisconsin | 55139 | 16001 | 152 |
832791 | 832791 | 2020-12-15 | Winnebago | Wisconsin | 55139 | 15979 | 150 |
829544 | 829544 | 2020-12-14 | Winnebago | Wisconsin | 55139 | 15915 | 150 |
826298 | 826298 | 2020-12-13 | Winnebago | Wisconsin | 55139 | 15872 | 149 |
823051 | 823051 | 2020-12-12 | Winnebago | Wisconsin | 55139 | 15807 | 149 |
819805 | 819805 | 2020-12-11 | Winnebago | Wisconsin | 55139 | 15700 | 149 |
816559 | 816559 | 2020-12-10 | Winnebago | Wisconsin | 55139 | 15567 | 146 |
813313 | 813313 | 2020-12-09 | Winnebago | Wisconsin | 55139 | 15471 | 141 |
810069 | 810069 | 2020-12-08 | Winnebago | Wisconsin | 55139 | 15347 | 136 |
806824 | 806824 | 2020-12-07 | Winnebago | Wisconsin | 55139 | 15255 | 131 |
803579 | 803579 | 2020-12-06 | Winnebago | Wisconsin | 55139 | 15193 | 131 |
800334 | 800334 | 2020-12-05 | Winnebago | Wisconsin | 55139 | 15093 | 130 |
797089 | 797089 | 2020-12-04 | Winnebago | Wisconsin | 55139 | 14962 | 127 |
793844 | 793844 | 2020-12-03 | Winnebago | Wisconsin | 55139 | 14750 | 125 |
790599 | 790599 | 2020-12-02 | Winnebago | Wisconsin | 55139 | 14604 | 121 |
787354 | 787354 | 2020-12-01 | Winnebago | Wisconsin | 55139 | 14435 | 120 |
784110 | 784110 | 2020-11-30 | Winnebago | Wisconsin | 55139 | 14383 | 111 |
780865 | 780865 | 2020-11-29 | Winnebago | Wisconsin | 55139 | 14321 | 111 |
777619 | 777619 | 2020-11-28 | Winnebago | Wisconsin | 55139 | 14229 | 111 |
774374 | 774374 | 2020-11-27 | Winnebago | Wisconsin | 55139 | 14049 | 110 |
771129 | 771129 | 2020-11-26 | Winnebago | Wisconsin | 55139 | 14045 | 110 |
767883 | 767883 | 2020-11-25 | Winnebago | Wisconsin | 55139 | 13904 | 108 |
764638 | 764638 | 2020-11-24 | Winnebago | Wisconsin | 55139 | 13806 | 108 |
761393 | 761393 | 2020-11-23 | Winnebago | Wisconsin | 55139 | 13678 | 105 |
758148 | 758148 | 2020-11-22 | Winnebago | Wisconsin | 55139 | 13599 | 105 |
754901 | 754901 | 2020-11-21 | Winnebago | Wisconsin | 55139 | 13485 | 105 |
751655 | 751655 | 2020-11-20 | Winnebago | Wisconsin | 55139 | 13287 | 105 |
748409 | 748409 | 2020-11-19 | Winnebago | Wisconsin | 55139 | 13150 | 102 |
745163 | 745163 | 2020-11-18 | Winnebago | Wisconsin | 55139 | 12975 | 102 |
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);