ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1019 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
868522 | 868522 | 2020-12-27 | Cherokee | Alabama | 1019 | 1369 | 23 |
865277 | 865277 | 2020-12-26 | Cherokee | Alabama | 1019 | 1368 | 23 |
862032 | 862032 | 2020-12-25 | Cherokee | Alabama | 1019 | 1368 | 23 |
858787 | 858787 | 2020-12-24 | Cherokee | Alabama | 1019 | 1343 | 23 |
855542 | 855542 | 2020-12-23 | Cherokee | Alabama | 1019 | 1329 | 23 |
852297 | 852297 | 2020-12-22 | Cherokee | Alabama | 1019 | 1314 | 23 |
849052 | 849052 | 2020-12-21 | Cherokee | Alabama | 1019 | 1294 | 23 |
845807 | 845807 | 2020-12-20 | Cherokee | Alabama | 1019 | 1287 | 23 |
842561 | 842561 | 2020-12-19 | Cherokee | Alabama | 1019 | 1278 | 23 |
839316 | 839316 | 2020-12-18 | Cherokee | Alabama | 1019 | 1265 | 23 |
836071 | 836071 | 2020-12-17 | Cherokee | Alabama | 1019 | 1241 | 24 |
832825 | 832825 | 2020-12-16 | Cherokee | Alabama | 1019 | 1218 | 24 |
829578 | 829578 | 2020-12-15 | Cherokee | Alabama | 1019 | 1213 | 24 |
826332 | 826332 | 2020-12-14 | Cherokee | Alabama | 1019 | 1204 | 24 |
823085 | 823085 | 2020-12-13 | Cherokee | Alabama | 1019 | 1197 | 24 |
819839 | 819839 | 2020-12-12 | Cherokee | Alabama | 1019 | 1187 | 24 |
816593 | 816593 | 2020-12-11 | Cherokee | Alabama | 1019 | 1167 | 24 |
813347 | 813347 | 2020-12-10 | Cherokee | Alabama | 1019 | 1149 | 24 |
810103 | 810103 | 2020-12-09 | Cherokee | Alabama | 1019 | 1134 | 24 |
806858 | 806858 | 2020-12-08 | Cherokee | Alabama | 1019 | 1125 | 24 |
803613 | 803613 | 2020-12-07 | Cherokee | Alabama | 1019 | 1110 | 24 |
800368 | 800368 | 2020-12-06 | Cherokee | Alabama | 1019 | 1093 | 24 |
797123 | 797123 | 2020-12-05 | Cherokee | Alabama | 1019 | 1090 | 24 |
793878 | 793878 | 2020-12-04 | Cherokee | Alabama | 1019 | 1082 | 24 |
790633 | 790633 | 2020-12-03 | Cherokee | Alabama | 1019 | 1067 | 24 |
787388 | 787388 | 2020-12-02 | Cherokee | Alabama | 1019 | 1055 | 24 |
784144 | 784144 | 2020-12-01 | Cherokee | Alabama | 1019 | 1051 | 24 |
780899 | 780899 | 2020-11-30 | Cherokee | Alabama | 1019 | 1034 | 24 |
777653 | 777653 | 2020-11-29 | Cherokee | Alabama | 1019 | 1029 | 24 |
774408 | 774408 | 2020-11-28 | Cherokee | Alabama | 1019 | 1022 | 24 |
771163 | 771163 | 2020-11-27 | Cherokee | Alabama | 1019 | 1015 | 24 |
767917 | 767917 | 2020-11-26 | Cherokee | Alabama | 1019 | 1010 | 24 |
764672 | 764672 | 2020-11-25 | Cherokee | Alabama | 1019 | 1008 | 24 |
761427 | 761427 | 2020-11-24 | Cherokee | Alabama | 1019 | 996 | 24 |
758182 | 758182 | 2020-11-23 | Cherokee | Alabama | 1019 | 989 | 24 |
754935 | 754935 | 2020-11-22 | Cherokee | Alabama | 1019 | 985 | 24 |
751689 | 751689 | 2020-11-21 | Cherokee | Alabama | 1019 | 979 | 24 |
748443 | 748443 | 2020-11-20 | Cherokee | Alabama | 1019 | 959 | 24 |
745197 | 745197 | 2020-11-19 | Cherokee | Alabama | 1019 | 956 | 24 |
741950 | 741950 | 2020-11-18 | Cherokee | Alabama | 1019 | 935 | 16 |
738703 | 738703 | 2020-11-17 | Cherokee | Alabama | 1019 | 919 | 15 |
735459 | 735459 | 2020-11-16 | Cherokee | Alabama | 1019 | 912 | 15 |
732213 | 732213 | 2020-11-15 | Cherokee | Alabama | 1019 | 908 | 15 |
728968 | 728968 | 2020-11-14 | Cherokee | Alabama | 1019 | 898 | 15 |
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);