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 |
---|---|---|---|---|---|---|---|
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 |
725725 | 725725 | 2020-11-13 | Cherokee | Alabama | 1019 | 892 | 15 |
722482 | 722482 | 2020-11-12 | Cherokee | Alabama | 1019 | 870 | 15 |
719239 | 719239 | 2020-11-11 | Cherokee | Alabama | 1019 | 865 | 15 |
715996 | 715996 | 2020-11-10 | Cherokee | Alabama | 1019 | 857 | 15 |
712752 | 712752 | 2020-11-09 | Cherokee | Alabama | 1019 | 845 | 15 |
709508 | 709508 | 2020-11-08 | Cherokee | Alabama | 1019 | 840 | 15 |
706264 | 706264 | 2020-11-07 | Cherokee | Alabama | 1019 | 836 | 15 |
703021 | 703021 | 2020-11-06 | Cherokee | Alabama | 1019 | 832 | 15 |
699778 | 699778 | 2020-11-05 | Cherokee | Alabama | 1019 | 831 | 15 |
696534 | 696534 | 2020-11-04 | Cherokee | Alabama | 1019 | 823 | 15 |
693292 | 693292 | 2020-11-03 | Cherokee | Alabama | 1019 | 808 | 15 |
690049 | 690049 | 2020-11-02 | Cherokee | Alabama | 1019 | 791 | 15 |
686804 | 686804 | 2020-11-01 | Cherokee | Alabama | 1019 | 787 | 15 |
683560 | 683560 | 2020-10-31 | Cherokee | Alabama | 1019 | 783 | 15 |
680317 | 680317 | 2020-10-30 | Cherokee | Alabama | 1019 | 769 | 15 |
677074 | 677074 | 2020-10-29 | Cherokee | Alabama | 1019 | 764 | 14 |
673831 | 673831 | 2020-10-28 | Cherokee | Alabama | 1019 | 761 | 14 |
670589 | 670589 | 2020-10-27 | Cherokee | Alabama | 1019 | 756 | 14 |
667346 | 667346 | 2020-10-26 | Cherokee | Alabama | 1019 | 745 | 14 |
664101 | 664101 | 2020-10-25 | Cherokee | Alabama | 1019 | 738 | 14 |
660857 | 660857 | 2020-10-24 | Cherokee | Alabama | 1019 | 733 | 14 |
657613 | 657613 | 2020-10-23 | Cherokee | Alabama | 1019 | 731 | 14 |
654368 | 654368 | 2020-10-22 | Cherokee | Alabama | 1019 | 726 | 14 |
651123 | 651123 | 2020-10-21 | Cherokee | Alabama | 1019 | 723 | 14 |
647879 | 647879 | 2020-10-20 | Cherokee | Alabama | 1019 | 722 | 14 |
644634 | 644634 | 2020-10-19 | Cherokee | Alabama | 1019 | 715 | 14 |
641386 | 641386 | 2020-10-18 | Cherokee | Alabama | 1019 | 714 | 14 |
638139 | 638139 | 2020-10-17 | Cherokee | Alabama | 1019 | 713 | 14 |
634894 | 634894 | 2020-10-16 | Cherokee | Alabama | 1019 | 702 | 14 |
631649 | 631649 | 2020-10-15 | Cherokee | Alabama | 1019 | 696 | 14 |
628405 | 628405 | 2020-10-14 | Cherokee | Alabama | 1019 | 687 | 14 |
625162 | 625162 | 2020-10-13 | Cherokee | Alabama | 1019 | 687 | 13 |
621919 | 621919 | 2020-10-12 | Cherokee | Alabama | 1019 | 674 | 13 |
618676 | 618676 | 2020-10-11 | Cherokee | Alabama | 1019 | 670 | 13 |
615434 | 615434 | 2020-10-10 | Cherokee | Alabama | 1019 | 666 | 13 |
612193 | 612193 | 2020-10-09 | Cherokee | Alabama | 1019 | 662 | 13 |
608951 | 608951 | 2020-10-08 | Cherokee | Alabama | 1019 | 654 | 13 |
605708 | 605708 | 2020-10-07 | Cherokee | Alabama | 1019 | 651 | 13 |
602466 | 602466 | 2020-10-06 | Cherokee | Alabama | 1019 | 644 | 13 |
599223 | 599223 | 2020-10-05 | Cherokee | Alabama | 1019 | 642 | 13 |
595980 | 595980 | 2020-10-04 | Cherokee | Alabama | 1019 | 639 | 13 |
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);