ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Adams" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1056657 | 1056657 | 2021-02-22 | Adams | Wisconsin | 55001 | 1731 | 15 |
1053411 | 1053411 | 2021-02-21 | Adams | Wisconsin | 55001 | 1729 | 15 |
1050164 | 1050164 | 2021-02-20 | Adams | Wisconsin | 55001 | 1729 | 15 |
1046917 | 1046917 | 2021-02-19 | Adams | Wisconsin | 55001 | 1723 | 15 |
1043672 | 1043672 | 2021-02-18 | Adams | Wisconsin | 55001 | 1721 | 15 |
1040427 | 1040427 | 2021-02-17 | Adams | Wisconsin | 55001 | 1714 | 15 |
1037182 | 1037182 | 2021-02-16 | Adams | Wisconsin | 55001 | 1713 | 15 |
1033937 | 1033937 | 2021-02-15 | Adams | Wisconsin | 55001 | 1708 | 15 |
1030691 | 1030691 | 2021-02-14 | Adams | Wisconsin | 55001 | 1705 | 15 |
1027444 | 1027444 | 2021-02-13 | Adams | Wisconsin | 55001 | 1700 | 15 |
1024199 | 1024199 | 2021-02-12 | Adams | Wisconsin | 55001 | 1699 | 15 |
1020954 | 1020954 | 2021-02-11 | Adams | Wisconsin | 55001 | 1698 | 15 |
1017709 | 1017709 | 2021-02-10 | Adams | Wisconsin | 55001 | 1695 | 15 |
1014464 | 1014464 | 2021-02-09 | Adams | Wisconsin | 55001 | 1690 | 15 |
1011219 | 1011219 | 2021-02-08 | Adams | Wisconsin | 55001 | 1685 | 15 |
1007973 | 1007973 | 2021-02-07 | Adams | Wisconsin | 55001 | 1682 | 14 |
1004727 | 1004727 | 2021-02-06 | Adams | Wisconsin | 55001 | 1678 | 14 |
1001481 | 1001481 | 2021-02-05 | Adams | Wisconsin | 55001 | 1676 | 14 |
998235 | 998235 | 2021-02-04 | Adams | Wisconsin | 55001 | 1674 | 14 |
994989 | 994989 | 2021-02-03 | Adams | Wisconsin | 55001 | 1668 | 14 |
991743 | 991743 | 2021-02-02 | Adams | Wisconsin | 55001 | 1665 | 14 |
988497 | 988497 | 2021-02-01 | Adams | Wisconsin | 55001 | 1666 | 14 |
985250 | 985250 | 2021-01-31 | Adams | Wisconsin | 55001 | 1660 | 14 |
982003 | 982003 | 2021-01-30 | Adams | Wisconsin | 55001 | 1654 | 14 |
978757 | 978757 | 2021-01-29 | Adams | Wisconsin | 55001 | 1650 | 14 |
975512 | 975512 | 2021-01-28 | Adams | Wisconsin | 55001 | 1646 | 14 |
972267 | 972267 | 2021-01-27 | Adams | Wisconsin | 55001 | 1634 | 14 |
969022 | 969022 | 2021-01-26 | Adams | Wisconsin | 55001 | 1629 | 14 |
965778 | 965778 | 2021-01-25 | Adams | Wisconsin | 55001 | 1626 | 14 |
962533 | 962533 | 2021-01-24 | Adams | Wisconsin | 55001 | 1623 | 14 |
959288 | 959288 | 2021-01-23 | Adams | Wisconsin | 55001 | 1622 | 14 |
956042 | 956042 | 2021-01-22 | Adams | Wisconsin | 55001 | 1608 | 14 |
952797 | 952797 | 2021-01-21 | Adams | Wisconsin | 55001 | 1604 | 14 |
949552 | 949552 | 2021-01-20 | Adams | Wisconsin | 55001 | 1591 | 14 |
946306 | 946306 | 2021-01-19 | Adams | Wisconsin | 55001 | 1578 | 13 |
943059 | 943059 | 2021-01-18 | Adams | Wisconsin | 55001 | 1574 | 13 |
939814 | 939814 | 2021-01-17 | Adams | Wisconsin | 55001 | 1572 | 13 |
936569 | 936569 | 2021-01-16 | Adams | Wisconsin | 55001 | 1573 | 13 |
933324 | 933324 | 2021-01-15 | Adams | Wisconsin | 55001 | 1566 | 13 |
930079 | 930079 | 2021-01-14 | Adams | Wisconsin | 55001 | 1560 | 13 |
926834 | 926834 | 2021-01-13 | Adams | Wisconsin | 55001 | 1549 | 13 |
923588 | 923588 | 2021-01-12 | Adams | Wisconsin | 55001 | 1544 | 13 |
920343 | 920343 | 2021-01-11 | Adams | Wisconsin | 55001 | 1537 | 13 |
917098 | 917098 | 2021-01-10 | Adams | Wisconsin | 55001 | 1525 | 13 |
913853 | 913853 | 2021-01-09 | Adams | Wisconsin | 55001 | 1521 | 13 |
910608 | 910608 | 2021-01-08 | Adams | Wisconsin | 55001 | 1515 | 13 |
907363 | 907363 | 2021-01-07 | Adams | Wisconsin | 55001 | 1498 | 13 |
904117 | 904117 | 2021-01-06 | Adams | Wisconsin | 55001 | 1489 | 13 |
900872 | 900872 | 2021-01-05 | Adams | Wisconsin | 55001 | 1461 | 13 |
897627 | 897627 | 2021-01-04 | Adams | Wisconsin | 55001 | 1452 | 13 |
894381 | 894381 | 2021-01-03 | Adams | Wisconsin | 55001 | 1445 | 13 |
891135 | 891135 | 2021-01-02 | Adams | Wisconsin | 55001 | 1438 | 13 |
887888 | 887888 | 2021-01-01 | Adams | Wisconsin | 55001 | 1430 | 13 |
884643 | 884643 | 2020-12-31 | Adams | Wisconsin | 55001 | 1427 | 13 |
881398 | 881398 | 2020-12-30 | Adams | Wisconsin | 55001 | 1416 | 13 |
878153 | 878153 | 2020-12-29 | Adams | Wisconsin | 55001 | 1405 | 13 |
874908 | 874908 | 2020-12-28 | Adams | Wisconsin | 55001 | 1401 | 12 |
871663 | 871663 | 2020-12-27 | Adams | Wisconsin | 55001 | 1401 | 12 |
868418 | 868418 | 2020-12-26 | Adams | Wisconsin | 55001 | 1396 | 12 |
865173 | 865173 | 2020-12-25 | Adams | Wisconsin | 55001 | 1396 | 12 |
861928 | 861928 | 2020-12-24 | Adams | Wisconsin | 55001 | 1392 | 12 |
858683 | 858683 | 2020-12-23 | Adams | Wisconsin | 55001 | 1388 | 12 |
855438 | 855438 | 2020-12-22 | Adams | Wisconsin | 55001 | 1374 | 12 |
852193 | 852193 | 2020-12-21 | Adams | Wisconsin | 55001 | 1370 | 12 |
848948 | 848948 | 2020-12-20 | Adams | Wisconsin | 55001 | 1359 | 12 |
845703 | 845703 | 2020-12-19 | Adams | Wisconsin | 55001 | 1355 | 12 |
842457 | 842457 | 2020-12-18 | Adams | Wisconsin | 55001 | 1344 | 12 |
839212 | 839212 | 2020-12-17 | Adams | Wisconsin | 55001 | 1339 | 12 |
835967 | 835967 | 2020-12-16 | Adams | Wisconsin | 55001 | 1324 | 12 |
832721 | 832721 | 2020-12-15 | Adams | Wisconsin | 55001 | 1314 | 12 |
829474 | 829474 | 2020-12-14 | Adams | Wisconsin | 55001 | 1297 | 12 |
826228 | 826228 | 2020-12-13 | Adams | Wisconsin | 55001 | 1287 | 12 |
822981 | 822981 | 2020-12-12 | Adams | Wisconsin | 55001 | 1277 | 12 |
819735 | 819735 | 2020-12-11 | Adams | Wisconsin | 55001 | 1265 | 11 |
816489 | 816489 | 2020-12-10 | Adams | Wisconsin | 55001 | 1261 | 11 |
813243 | 813243 | 2020-12-09 | Adams | Wisconsin | 55001 | 1237 | 10 |
809999 | 809999 | 2020-12-08 | Adams | Wisconsin | 55001 | 1230 | 10 |
806754 | 806754 | 2020-12-07 | Adams | Wisconsin | 55001 | 1214 | 11 |
803509 | 803509 | 2020-12-06 | Adams | Wisconsin | 55001 | 1208 | 11 |
800264 | 800264 | 2020-12-05 | Adams | Wisconsin | 55001 | 1200 | 10 |
797019 | 797019 | 2020-12-04 | Adams | Wisconsin | 55001 | 1185 | 10 |
793774 | 793774 | 2020-12-03 | Adams | Wisconsin | 55001 | 1163 | 10 |
790529 | 790529 | 2020-12-02 | Adams | Wisconsin | 55001 | 1144 | 8 |
787284 | 787284 | 2020-12-01 | Adams | Wisconsin | 55001 | 1138 | 8 |
784040 | 784040 | 2020-11-30 | Adams | Wisconsin | 55001 | 1114 | 8 |
780795 | 780795 | 2020-11-29 | Adams | Wisconsin | 55001 | 1107 | 8 |
777549 | 777549 | 2020-11-28 | Adams | Wisconsin | 55001 | 1103 | 8 |
774304 | 774304 | 2020-11-27 | Adams | Wisconsin | 55001 | 1082 | 7 |
771059 | 771059 | 2020-11-26 | Adams | Wisconsin | 55001 | 1081 | 7 |
767813 | 767813 | 2020-11-25 | Adams | Wisconsin | 55001 | 1067 | 7 |
764568 | 764568 | 2020-11-24 | Adams | Wisconsin | 55001 | 1061 | 7 |
761323 | 761323 | 2020-11-23 | Adams | Wisconsin | 55001 | 1052 | 7 |
758078 | 758078 | 2020-11-22 | Adams | Wisconsin | 55001 | 1044 | 7 |
754831 | 754831 | 2020-11-21 | Adams | Wisconsin | 55001 | 1021 | 7 |
751585 | 751585 | 2020-11-20 | Adams | Wisconsin | 55001 | 1006 | 7 |
748339 | 748339 | 2020-11-19 | Adams | Wisconsin | 55001 | 985 | 7 |
745093 | 745093 | 2020-11-18 | Adams | Wisconsin | 55001 | 949 | 7 |
741846 | 741846 | 2020-11-17 | Adams | Wisconsin | 55001 | 926 | 7 |
738599 | 738599 | 2020-11-16 | Adams | Wisconsin | 55001 | 914 | 7 |
735355 | 735355 | 2020-11-15 | Adams | Wisconsin | 55001 | 907 | 7 |
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);