ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where fips = 55065 and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056689 | 1056689 | 2021-02-22 | Lafayette | Wisconsin | 55065 | 1588 | 8 |
1053443 | 1053443 | 2021-02-21 | Lafayette | Wisconsin | 55065 | 1588 | 8 |
1050196 | 1050196 | 2021-02-20 | Lafayette | Wisconsin | 55065 | 1585 | 8 |
1046949 | 1046949 | 2021-02-19 | Lafayette | Wisconsin | 55065 | 1579 | 8 |
1043704 | 1043704 | 2021-02-18 | Lafayette | Wisconsin | 55065 | 1576 | 8 |
1040459 | 1040459 | 2021-02-17 | Lafayette | Wisconsin | 55065 | 1574 | 8 |
1037214 | 1037214 | 2021-02-16 | Lafayette | Wisconsin | 55065 | 1563 | 8 |
1033969 | 1033969 | 2021-02-15 | Lafayette | Wisconsin | 55065 | 1562 | 8 |
1030723 | 1030723 | 2021-02-14 | Lafayette | Wisconsin | 55065 | 1559 | 8 |
1027476 | 1027476 | 2021-02-13 | Lafayette | Wisconsin | 55065 | 1552 | 8 |
1024231 | 1024231 | 2021-02-12 | Lafayette | Wisconsin | 55065 | 1549 | 8 |
1020986 | 1020986 | 2021-02-11 | Lafayette | Wisconsin | 55065 | 1545 | 8 |
1017741 | 1017741 | 2021-02-10 | Lafayette | Wisconsin | 55065 | 1542 | 8 |
1014496 | 1014496 | 2021-02-09 | Lafayette | Wisconsin | 55065 | 1539 | 8 |
1011251 | 1011251 | 2021-02-08 | Lafayette | Wisconsin | 55065 | 1536 | 8 |
1008005 | 1008005 | 2021-02-07 | Lafayette | Wisconsin | 55065 | 1536 | 8 |
1004759 | 1004759 | 2021-02-06 | Lafayette | Wisconsin | 55065 | 1531 | 8 |
1001513 | 1001513 | 2021-02-05 | Lafayette | Wisconsin | 55065 | 1529 | 8 |
998267 | 998267 | 2021-02-04 | Lafayette | Wisconsin | 55065 | 1529 | 8 |
995021 | 995021 | 2021-02-03 | Lafayette | Wisconsin | 55065 | 1526 | 8 |
991775 | 991775 | 2021-02-02 | Lafayette | Wisconsin | 55065 | 1521 | 8 |
988529 | 988529 | 2021-02-01 | Lafayette | Wisconsin | 55065 | 1521 | 8 |
985282 | 985282 | 2021-01-31 | Lafayette | Wisconsin | 55065 | 1521 | 8 |
982035 | 982035 | 2021-01-30 | Lafayette | Wisconsin | 55065 | 1520 | 8 |
978789 | 978789 | 2021-01-29 | Lafayette | Wisconsin | 55065 | 1516 | 8 |
975544 | 975544 | 2021-01-28 | Lafayette | Wisconsin | 55065 | 1509 | 8 |
972299 | 972299 | 2021-01-27 | Lafayette | Wisconsin | 55065 | 1506 | 8 |
969054 | 969054 | 2021-01-26 | Lafayette | Wisconsin | 55065 | 1497 | 8 |
965810 | 965810 | 2021-01-25 | Lafayette | Wisconsin | 55065 | 1492 | 8 |
962565 | 962565 | 2021-01-24 | Lafayette | Wisconsin | 55065 | 1488 | 8 |
959320 | 959320 | 2021-01-23 | Lafayette | Wisconsin | 55065 | 1486 | 8 |
956074 | 956074 | 2021-01-22 | Lafayette | Wisconsin | 55065 | 1480 | 8 |
952829 | 952829 | 2021-01-21 | Lafayette | Wisconsin | 55065 | 1477 | 8 |
949584 | 949584 | 2021-01-20 | Lafayette | Wisconsin | 55065 | 1466 | 8 |
946338 | 946338 | 2021-01-19 | Lafayette | Wisconsin | 55065 | 1463 | 8 |
943091 | 943091 | 2021-01-18 | Lafayette | Wisconsin | 55065 | 1459 | 8 |
939846 | 939846 | 2021-01-17 | Lafayette | Wisconsin | 55065 | 1455 | 8 |
936601 | 936601 | 2021-01-16 | Lafayette | Wisconsin | 55065 | 1445 | 8 |
933356 | 933356 | 2021-01-15 | Lafayette | Wisconsin | 55065 | 1432 | 7 |
930111 | 930111 | 2021-01-14 | Lafayette | Wisconsin | 55065 | 1421 | 7 |
926866 | 926866 | 2021-01-13 | Lafayette | Wisconsin | 55065 | 1419 | 7 |
923620 | 923620 | 2021-01-12 | Lafayette | Wisconsin | 55065 | 1413 | 7 |
920375 | 920375 | 2021-01-11 | Lafayette | Wisconsin | 55065 | 1413 | 7 |
917130 | 917130 | 2021-01-10 | Lafayette | Wisconsin | 55065 | 1406 | 6 |
913885 | 913885 | 2021-01-09 | Lafayette | Wisconsin | 55065 | 1390 | 6 |
910640 | 910640 | 2021-01-08 | Lafayette | Wisconsin | 55065 | 1384 | 6 |
907395 | 907395 | 2021-01-07 | Lafayette | Wisconsin | 55065 | 1377 | 6 |
904149 | 904149 | 2021-01-06 | Lafayette | Wisconsin | 55065 | 1374 | 6 |
900904 | 900904 | 2021-01-05 | Lafayette | Wisconsin | 55065 | 1363 | 6 |
897659 | 897659 | 2021-01-04 | Lafayette | Wisconsin | 55065 | 1360 | 6 |
894413 | 894413 | 2021-01-03 | Lafayette | Wisconsin | 55065 | 1360 | 6 |
891167 | 891167 | 2021-01-02 | Lafayette | Wisconsin | 55065 | 1357 | 6 |
887920 | 887920 | 2021-01-01 | Lafayette | Wisconsin | 55065 | 1349 | 6 |
884675 | 884675 | 2020-12-31 | Lafayette | Wisconsin | 55065 | 1350 | 6 |
881430 | 881430 | 2020-12-30 | Lafayette | Wisconsin | 55065 | 1347 | 6 |
878185 | 878185 | 2020-12-29 | Lafayette | Wisconsin | 55065 | 1338 | 6 |
874940 | 874940 | 2020-12-28 | Lafayette | Wisconsin | 55065 | 1335 | 6 |
871695 | 871695 | 2020-12-27 | Lafayette | Wisconsin | 55065 | 1332 | 6 |
868450 | 868450 | 2020-12-26 | Lafayette | Wisconsin | 55065 | 1330 | 6 |
865205 | 865205 | 2020-12-25 | Lafayette | Wisconsin | 55065 | 1321 | 6 |
861960 | 861960 | 2020-12-24 | Lafayette | Wisconsin | 55065 | 1317 | 6 |
858715 | 858715 | 2020-12-23 | Lafayette | Wisconsin | 55065 | 1314 | 6 |
855470 | 855470 | 2020-12-22 | Lafayette | Wisconsin | 55065 | 1303 | 6 |
852225 | 852225 | 2020-12-21 | Lafayette | Wisconsin | 55065 | 1292 | 6 |
848980 | 848980 | 2020-12-20 | Lafayette | Wisconsin | 55065 | 1280 | 6 |
845735 | 845735 | 2020-12-19 | Lafayette | Wisconsin | 55065 | 1274 | 6 |
842489 | 842489 | 2020-12-18 | Lafayette | Wisconsin | 55065 | 1270 | 6 |
839244 | 839244 | 2020-12-17 | Lafayette | Wisconsin | 55065 | 1260 | 5 |
835999 | 835999 | 2020-12-16 | Lafayette | Wisconsin | 55065 | 1255 | 5 |
832753 | 832753 | 2020-12-15 | Lafayette | Wisconsin | 55065 | 1249 | 5 |
829506 | 829506 | 2020-12-14 | Lafayette | Wisconsin | 55065 | 1244 | 5 |
826260 | 826260 | 2020-12-13 | Lafayette | Wisconsin | 55065 | 1240 | 5 |
823013 | 823013 | 2020-12-12 | Lafayette | Wisconsin | 55065 | 1232 | 5 |
819767 | 819767 | 2020-12-11 | Lafayette | Wisconsin | 55065 | 1228 | 5 |
816521 | 816521 | 2020-12-10 | Lafayette | Wisconsin | 55065 | 1217 | 5 |
813275 | 813275 | 2020-12-09 | Lafayette | Wisconsin | 55065 | 1209 | 5 |
810031 | 810031 | 2020-12-08 | Lafayette | Wisconsin | 55065 | 1206 | 5 |
806786 | 806786 | 2020-12-07 | Lafayette | Wisconsin | 55065 | 1199 | 5 |
803541 | 803541 | 2020-12-06 | Lafayette | Wisconsin | 55065 | 1194 | 4 |
800296 | 800296 | 2020-12-05 | Lafayette | Wisconsin | 55065 | 1184 | 4 |
797051 | 797051 | 2020-12-04 | Lafayette | Wisconsin | 55065 | 1178 | 4 |
793806 | 793806 | 2020-12-03 | Lafayette | Wisconsin | 55065 | 1157 | 4 |
790561 | 790561 | 2020-12-02 | Lafayette | Wisconsin | 55065 | 1139 | 4 |
787316 | 787316 | 2020-12-01 | Lafayette | Wisconsin | 55065 | 1131 | 4 |
784072 | 784072 | 2020-11-30 | Lafayette | Wisconsin | 55065 | 1121 | 3 |
780827 | 780827 | 2020-11-29 | Lafayette | Wisconsin | 55065 | 1115 | 3 |
777581 | 777581 | 2020-11-28 | Lafayette | Wisconsin | 55065 | 1101 | 3 |
774336 | 774336 | 2020-11-27 | Lafayette | Wisconsin | 55065 | 1095 | 3 |
771091 | 771091 | 2020-11-26 | Lafayette | Wisconsin | 55065 | 1082 | 3 |
767845 | 767845 | 2020-11-25 | Lafayette | Wisconsin | 55065 | 1070 | 3 |
764600 | 764600 | 2020-11-24 | Lafayette | Wisconsin | 55065 | 1060 | 3 |
761355 | 761355 | 2020-11-23 | Lafayette | Wisconsin | 55065 | 1053 | 3 |
758110 | 758110 | 2020-11-22 | Lafayette | Wisconsin | 55065 | 1043 | 3 |
754863 | 754863 | 2020-11-21 | Lafayette | Wisconsin | 55065 | 1028 | 2 |
751617 | 751617 | 2020-11-20 | Lafayette | Wisconsin | 55065 | 1017 | 2 |
748371 | 748371 | 2020-11-19 | Lafayette | Wisconsin | 55065 | 988 | 2 |
745125 | 745125 | 2020-11-18 | Lafayette | Wisconsin | 55065 | 971 | 2 |
741878 | 741878 | 2020-11-17 | Lafayette | Wisconsin | 55065 | 953 | 2 |
738631 | 738631 | 2020-11-16 | Lafayette | Wisconsin | 55065 | 937 | 2 |
735387 | 735387 | 2020-11-15 | Lafayette | Wisconsin | 55065 | 926 | 2 |
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);