ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Cherokee" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1193118 | 1193118 | 2021-04-06 | Cherokee | Alabama | 1019 | 1814 | 43 |
1189868 | 1189868 | 2021-04-05 | Cherokee | Alabama | 1019 | 1812 | 43 |
1186621 | 1186621 | 2021-04-04 | Cherokee | Alabama | 1019 | 1812 | 43 |
1183374 | 1183374 | 2021-04-03 | Cherokee | Alabama | 1019 | 1812 | 43 |
1180127 | 1180127 | 2021-04-02 | Cherokee | Alabama | 1019 | 1811 | 43 |
1176880 | 1176880 | 2021-04-01 | Cherokee | Alabama | 1019 | 1810 | 43 |
1173633 | 1173633 | 2021-03-31 | Cherokee | Alabama | 1019 | 1806 | 43 |
1170386 | 1170386 | 2021-03-30 | Cherokee | Alabama | 1019 | 1806 | 43 |
1167138 | 1167138 | 2021-03-29 | Cherokee | Alabama | 1019 | 1804 | 43 |
1163890 | 1163890 | 2021-03-28 | Cherokee | Alabama | 1019 | 1804 | 43 |
1160642 | 1160642 | 2021-03-27 | Cherokee | Alabama | 1019 | 1804 | 43 |
1157394 | 1157394 | 2021-03-26 | Cherokee | Alabama | 1019 | 1801 | 43 |
1154147 | 1154147 | 2021-03-25 | Cherokee | Alabama | 1019 | 1798 | 43 |
1150900 | 1150900 | 2021-03-24 | Cherokee | Alabama | 1019 | 1797 | 42 |
1147653 | 1147653 | 2021-03-23 | Cherokee | Alabama | 1019 | 1794 | 42 |
1144406 | 1144406 | 2021-03-22 | Cherokee | Alabama | 1019 | 1794 | 42 |
1141159 | 1141159 | 2021-03-21 | Cherokee | Alabama | 1019 | 1794 | 42 |
1137913 | 1137913 | 2021-03-20 | Cherokee | Alabama | 1019 | 1793 | 42 |
1134667 | 1134667 | 2021-03-19 | Cherokee | Alabama | 1019 | 1793 | 42 |
1131419 | 1131419 | 2021-03-18 | Cherokee | Alabama | 1019 | 1792 | 42 |
1128172 | 1128172 | 2021-03-17 | Cherokee | Alabama | 1019 | 1791 | 42 |
1124926 | 1124926 | 2021-03-16 | Cherokee | Alabama | 1019 | 1792 | 42 |
1121680 | 1121680 | 2021-03-15 | Cherokee | Alabama | 1019 | 1791 | 42 |
1118433 | 1118433 | 2021-03-14 | Cherokee | Alabama | 1019 | 1788 | 42 |
1115186 | 1115186 | 2021-03-13 | Cherokee | Alabama | 1019 | 1788 | 42 |
1111940 | 1111940 | 2021-03-12 | Cherokee | Alabama | 1019 | 1787 | 42 |
1108694 | 1108694 | 2021-03-11 | Cherokee | Alabama | 1019 | 1785 | 42 |
1105448 | 1105448 | 2021-03-10 | Cherokee | Alabama | 1019 | 1786 | 42 |
1102202 | 1102202 | 2021-03-09 | Cherokee | Alabama | 1019 | 1784 | 41 |
1098956 | 1098956 | 2021-03-08 | Cherokee | Alabama | 1019 | 1783 | 40 |
1095708 | 1095708 | 2021-03-07 | Cherokee | Alabama | 1019 | 1782 | 40 |
1092462 | 1092462 | 2021-03-06 | Cherokee | Alabama | 1019 | 1781 | 40 |
1089216 | 1089216 | 2021-03-05 | Cherokee | Alabama | 1019 | 1781 | 40 |
1085971 | 1085971 | 2021-03-04 | Cherokee | Alabama | 1019 | 1780 | 39 |
1082725 | 1082725 | 2021-03-03 | Cherokee | Alabama | 1019 | 1777 | 39 |
1079479 | 1079479 | 2021-03-02 | Cherokee | Alabama | 1019 | 1771 | 39 |
1076234 | 1076234 | 2021-03-01 | Cherokee | Alabama | 1019 | 1770 | 38 |
1072988 | 1072988 | 2021-02-28 | Cherokee | Alabama | 1019 | 1770 | 38 |
1069742 | 1069742 | 2021-02-27 | Cherokee | Alabama | 1019 | 1768 | 38 |
1066497 | 1066497 | 2021-02-26 | Cherokee | Alabama | 1019 | 1764 | 38 |
1063252 | 1063252 | 2021-02-25 | Cherokee | Alabama | 1019 | 1764 | 38 |
1060007 | 1060007 | 2021-02-24 | Cherokee | Alabama | 1019 | 1763 | 38 |
1056761 | 1056761 | 2021-02-23 | Cherokee | Alabama | 1019 | 1757 | 37 |
1053515 | 1053515 | 2021-02-22 | Cherokee | Alabama | 1019 | 1753 | 37 |
1050268 | 1050268 | 2021-02-21 | Cherokee | Alabama | 1019 | 1753 | 37 |
1047021 | 1047021 | 2021-02-20 | Cherokee | Alabama | 1019 | 1753 | 37 |
1043776 | 1043776 | 2021-02-19 | Cherokee | Alabama | 1019 | 1751 | 37 |
1040531 | 1040531 | 2021-02-18 | Cherokee | Alabama | 1019 | 1751 | 37 |
1037286 | 1037286 | 2021-02-17 | Cherokee | Alabama | 1019 | 1750 | 37 |
1034041 | 1034041 | 2021-02-16 | Cherokee | Alabama | 1019 | 1750 | 37 |
1030795 | 1030795 | 2021-02-15 | Cherokee | Alabama | 1019 | 1745 | 37 |
1027548 | 1027548 | 2021-02-14 | Cherokee | Alabama | 1019 | 1744 | 37 |
1024303 | 1024303 | 2021-02-13 | Cherokee | Alabama | 1019 | 1742 | 37 |
1021058 | 1021058 | 2021-02-12 | Cherokee | Alabama | 1019 | 1739 | 37 |
1017813 | 1017813 | 2021-02-11 | Cherokee | Alabama | 1019 | 1738 | 37 |
1014568 | 1014568 | 2021-02-10 | Cherokee | Alabama | 1019 | 1738 | 37 |
1011323 | 1011323 | 2021-02-09 | Cherokee | Alabama | 1019 | 1735 | 37 |
1008077 | 1008077 | 2021-02-08 | Cherokee | Alabama | 1019 | 1731 | 36 |
1004831 | 1004831 | 2021-02-07 | Cherokee | Alabama | 1019 | 1730 | 36 |
1001585 | 1001585 | 2021-02-06 | Cherokee | Alabama | 1019 | 1729 | 36 |
998339 | 998339 | 2021-02-05 | Cherokee | Alabama | 1019 | 1724 | 36 |
995093 | 995093 | 2021-02-04 | Cherokee | Alabama | 1019 | 1723 | 36 |
991847 | 991847 | 2021-02-03 | Cherokee | Alabama | 1019 | 1718 | 36 |
988601 | 988601 | 2021-02-02 | Cherokee | Alabama | 1019 | 1714 | 36 |
985354 | 985354 | 2021-02-01 | Cherokee | Alabama | 1019 | 1707 | 35 |
982107 | 982107 | 2021-01-31 | Cherokee | Alabama | 1019 | 1704 | 35 |
978861 | 978861 | 2021-01-30 | Cherokee | Alabama | 1019 | 1688 | 35 |
975616 | 975616 | 2021-01-29 | Cherokee | Alabama | 1019 | 1688 | 35 |
972371 | 972371 | 2021-01-28 | Cherokee | Alabama | 1019 | 1682 | 35 |
969126 | 969126 | 2021-01-27 | Cherokee | Alabama | 1019 | 1673 | 33 |
965882 | 965882 | 2021-01-26 | Cherokee | Alabama | 1019 | 1674 | 33 |
962637 | 962637 | 2021-01-25 | Cherokee | Alabama | 1019 | 1660 | 31 |
959392 | 959392 | 2021-01-24 | Cherokee | Alabama | 1019 | 1657 | 31 |
956146 | 956146 | 2021-01-23 | Cherokee | Alabama | 1019 | 1651 | 31 |
952901 | 952901 | 2021-01-22 | Cherokee | Alabama | 1019 | 1643 | 30 |
949656 | 949656 | 2021-01-21 | Cherokee | Alabama | 1019 | 1625 | 30 |
946410 | 946410 | 2021-01-20 | Cherokee | Alabama | 1019 | 1619 | 30 |
943163 | 943163 | 2021-01-19 | Cherokee | Alabama | 1019 | 1609 | 30 |
939918 | 939918 | 2021-01-18 | Cherokee | Alabama | 1019 | 1605 | 30 |
936673 | 936673 | 2021-01-17 | Cherokee | Alabama | 1019 | 1603 | 30 |
933428 | 933428 | 2021-01-16 | Cherokee | Alabama | 1019 | 1600 | 30 |
930183 | 930183 | 2021-01-15 | Cherokee | Alabama | 1019 | 1596 | 30 |
926938 | 926938 | 2021-01-14 | Cherokee | Alabama | 1019 | 1583 | 30 |
923692 | 923692 | 2021-01-13 | Cherokee | Alabama | 1019 | 1569 | 29 |
920447 | 920447 | 2021-01-12 | Cherokee | Alabama | 1019 | 1568 | 29 |
917202 | 917202 | 2021-01-11 | Cherokee | Alabama | 1019 | 1545 | 24 |
913957 | 913957 | 2021-01-10 | Cherokee | Alabama | 1019 | 1537 | 24 |
910712 | 910712 | 2021-01-09 | Cherokee | Alabama | 1019 | 1523 | 24 |
907467 | 907467 | 2021-01-08 | Cherokee | Alabama | 1019 | 1517 | 24 |
904221 | 904221 | 2021-01-07 | Cherokee | Alabama | 1019 | 1496 | 25 |
900976 | 900976 | 2021-01-06 | Cherokee | Alabama | 1019 | 1468 | 25 |
897731 | 897731 | 2021-01-05 | Cherokee | Alabama | 1019 | 1454 | 22 |
894485 | 894485 | 2021-01-04 | Cherokee | Alabama | 1019 | 1441 | 22 |
891239 | 891239 | 2021-01-03 | Cherokee | Alabama | 1019 | 1438 | 22 |
887992 | 887992 | 2021-01-02 | Cherokee | Alabama | 1019 | 1435 | 22 |
884747 | 884747 | 2021-01-01 | Cherokee | Alabama | 1019 | 1429 | 22 |
881502 | 881502 | 2020-12-31 | Cherokee | Alabama | 1019 | 1414 | 22 |
878257 | 878257 | 2020-12-30 | Cherokee | Alabama | 1019 | 1403 | 22 |
875012 | 875012 | 2020-12-29 | Cherokee | Alabama | 1019 | 1393 | 23 |
871767 | 871767 | 2020-12-28 | Cherokee | Alabama | 1019 | 1372 | 23 |
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);