ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where fips = 1005 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917195 | 917195 | 2021-01-11 | Barbour | Alabama | 1005 | 1663 | 35 |
913950 | 913950 | 2021-01-10 | Barbour | Alabama | 1005 | 1658 | 35 |
910705 | 910705 | 2021-01-09 | Barbour | Alabama | 1005 | 1648 | 35 |
907460 | 907460 | 2021-01-08 | Barbour | Alabama | 1005 | 1634 | 35 |
904214 | 904214 | 2021-01-07 | Barbour | Alabama | 1005 | 1614 | 35 |
900969 | 900969 | 2021-01-06 | Barbour | Alabama | 1005 | 1597 | 35 |
897724 | 897724 | 2021-01-05 | Barbour | Alabama | 1005 | 1575 | 33 |
894478 | 894478 | 2021-01-04 | Barbour | Alabama | 1005 | 1533 | 33 |
891232 | 891232 | 2021-01-03 | Barbour | Alabama | 1005 | 1530 | 33 |
887985 | 887985 | 2021-01-02 | Barbour | Alabama | 1005 | 1528 | 33 |
884740 | 884740 | 2021-01-01 | Barbour | Alabama | 1005 | 1517 | 33 |
881495 | 881495 | 2020-12-31 | Barbour | Alabama | 1005 | 1514 | 32 |
878250 | 878250 | 2020-12-30 | Barbour | Alabama | 1005 | 1492 | 32 |
875005 | 875005 | 2020-12-29 | Barbour | Alabama | 1005 | 1462 | 32 |
871760 | 871760 | 2020-12-28 | Barbour | Alabama | 1005 | 1417 | 32 |
868515 | 868515 | 2020-12-27 | Barbour | Alabama | 1005 | 1406 | 32 |
865270 | 865270 | 2020-12-26 | Barbour | Alabama | 1005 | 1398 | 32 |
862025 | 862025 | 2020-12-25 | Barbour | Alabama | 1005 | 1396 | 32 |
858780 | 858780 | 2020-12-24 | Barbour | Alabama | 1005 | 1390 | 32 |
855535 | 855535 | 2020-12-23 | Barbour | Alabama | 1005 | 1383 | 32 |
852290 | 852290 | 2020-12-22 | Barbour | Alabama | 1005 | 1363 | 32 |
849045 | 849045 | 2020-12-21 | Barbour | Alabama | 1005 | 1336 | 32 |
845800 | 845800 | 2020-12-20 | Barbour | Alabama | 1005 | 1336 | 32 |
842554 | 842554 | 2020-12-19 | Barbour | Alabama | 1005 | 1330 | 32 |
839309 | 839309 | 2020-12-18 | Barbour | Alabama | 1005 | 1318 | 30 |
836064 | 836064 | 2020-12-17 | Barbour | Alabama | 1005 | 1309 | 30 |
832818 | 832818 | 2020-12-16 | Barbour | Alabama | 1005 | 1296 | 30 |
829571 | 829571 | 2020-12-15 | Barbour | Alabama | 1005 | 1292 | 30 |
826325 | 826325 | 2020-12-14 | Barbour | Alabama | 1005 | 1275 | 30 |
823078 | 823078 | 2020-12-13 | Barbour | Alabama | 1005 | 1272 | 30 |
819832 | 819832 | 2020-12-12 | Barbour | Alabama | 1005 | 1269 | 30 |
816586 | 816586 | 2020-12-11 | Barbour | Alabama | 1005 | 1264 | 30 |
813340 | 813340 | 2020-12-10 | Barbour | Alabama | 1005 | 1258 | 30 |
810096 | 810096 | 2020-12-09 | Barbour | Alabama | 1005 | 1245 | 30 |
806851 | 806851 | 2020-12-08 | Barbour | Alabama | 1005 | 1240 | 30 |
803606 | 803606 | 2020-12-07 | Barbour | Alabama | 1005 | 1224 | 29 |
800361 | 800361 | 2020-12-06 | Barbour | Alabama | 1005 | 1223 | 29 |
797116 | 797116 | 2020-12-05 | Barbour | Alabama | 1005 | 1219 | 29 |
793871 | 793871 | 2020-12-04 | Barbour | Alabama | 1005 | 1217 | 29 |
790626 | 790626 | 2020-12-03 | Barbour | Alabama | 1005 | 1214 | 29 |
787381 | 787381 | 2020-12-02 | Barbour | Alabama | 1005 | 1206 | 29 |
784137 | 784137 | 2020-12-01 | Barbour | Alabama | 1005 | 1189 | 11 |
780892 | 780892 | 2020-11-30 | Barbour | Alabama | 1005 | 1178 | 11 |
777646 | 777646 | 2020-11-29 | Barbour | Alabama | 1005 | 1175 | 11 |
774401 | 774401 | 2020-11-28 | Barbour | Alabama | 1005 | 1173 | 10 |
771156 | 771156 | 2020-11-27 | Barbour | Alabama | 1005 | 1171 | 10 |
767910 | 767910 | 2020-11-26 | Barbour | Alabama | 1005 | 1170 | 10 |
764665 | 764665 | 2020-11-25 | Barbour | Alabama | 1005 | 1170 | 10 |
761420 | 761420 | 2020-11-24 | Barbour | Alabama | 1005 | 1167 | 10 |
758175 | 758175 | 2020-11-23 | Barbour | Alabama | 1005 | 1161 | 10 |
754928 | 754928 | 2020-11-22 | Barbour | Alabama | 1005 | 1160 | 10 |
751682 | 751682 | 2020-11-21 | Barbour | Alabama | 1005 | 1157 | 10 |
748436 | 748436 | 2020-11-20 | Barbour | Alabama | 1005 | 1151 | 10 |
745190 | 745190 | 2020-11-19 | Barbour | Alabama | 1005 | 1145 | 10 |
741943 | 741943 | 2020-11-18 | Barbour | Alabama | 1005 | 1137 | 10 |
738696 | 738696 | 2020-11-17 | Barbour | Alabama | 1005 | 1134 | 9 |
735452 | 735452 | 2020-11-16 | Barbour | Alabama | 1005 | 1130 | 9 |
732206 | 732206 | 2020-11-15 | Barbour | Alabama | 1005 | 1128 | 9 |
728961 | 728961 | 2020-11-14 | Barbour | Alabama | 1005 | 1123 | 9 |
725718 | 725718 | 2020-11-13 | Barbour | Alabama | 1005 | 1117 | 9 |
722475 | 722475 | 2020-11-12 | Barbour | Alabama | 1005 | 1113 | 9 |
719232 | 719232 | 2020-11-11 | Barbour | Alabama | 1005 | 1112 | 9 |
715989 | 715989 | 2020-11-10 | Barbour | Alabama | 1005 | 1107 | 9 |
712745 | 712745 | 2020-11-09 | Barbour | Alabama | 1005 | 1098 | 9 |
709501 | 709501 | 2020-11-08 | Barbour | Alabama | 1005 | 1095 | 9 |
706257 | 706257 | 2020-11-07 | Barbour | Alabama | 1005 | 1092 | 9 |
703014 | 703014 | 2020-11-06 | Barbour | Alabama | 1005 | 1090 | 9 |
699771 | 699771 | 2020-11-05 | Barbour | Alabama | 1005 | 1080 | 9 |
696527 | 696527 | 2020-11-04 | Barbour | Alabama | 1005 | 1079 | 9 |
693285 | 693285 | 2020-11-03 | Barbour | Alabama | 1005 | 1074 | 9 |
690042 | 690042 | 2020-11-02 | Barbour | Alabama | 1005 | 1065 | 9 |
686797 | 686797 | 2020-11-01 | Barbour | Alabama | 1005 | 1061 | 9 |
683553 | 683553 | 2020-10-31 | Barbour | Alabama | 1005 | 1060 | 9 |
680310 | 680310 | 2020-10-30 | Barbour | Alabama | 1005 | 1056 | 9 |
677067 | 677067 | 2020-10-29 | Barbour | Alabama | 1005 | 1055 | 9 |
673824 | 673824 | 2020-10-28 | Barbour | Alabama | 1005 | 1045 | 9 |
670582 | 670582 | 2020-10-27 | Barbour | Alabama | 1005 | 1042 | 9 |
667339 | 667339 | 2020-10-26 | Barbour | Alabama | 1005 | 1033 | 9 |
664094 | 664094 | 2020-10-25 | Barbour | Alabama | 1005 | 1033 | 9 |
660850 | 660850 | 2020-10-24 | Barbour | Alabama | 1005 | 1031 | 9 |
657606 | 657606 | 2020-10-23 | Barbour | Alabama | 1005 | 1012 | 9 |
654361 | 654361 | 2020-10-22 | Barbour | Alabama | 1005 | 997 | 9 |
651116 | 651116 | 2020-10-21 | Barbour | Alabama | 1005 | 996 | 9 |
647872 | 647872 | 2020-10-20 | Barbour | Alabama | 1005 | 988 | 9 |
644627 | 644627 | 2020-10-19 | Barbour | Alabama | 1005 | 981 | 9 |
641379 | 641379 | 2020-10-18 | Barbour | Alabama | 1005 | 981 | 9 |
638132 | 638132 | 2020-10-17 | Barbour | Alabama | 1005 | 977 | 9 |
634887 | 634887 | 2020-10-16 | Barbour | Alabama | 1005 | 968 | 9 |
631642 | 631642 | 2020-10-15 | Barbour | Alabama | 1005 | 965 | 9 |
628398 | 628398 | 2020-10-14 | Barbour | Alabama | 1005 | 950 | 9 |
625155 | 625155 | 2020-10-13 | Barbour | Alabama | 1005 | 951 | 9 |
621912 | 621912 | 2020-10-12 | Barbour | Alabama | 1005 | 944 | 9 |
618669 | 618669 | 2020-10-11 | Barbour | Alabama | 1005 | 942 | 9 |
615427 | 615427 | 2020-10-10 | Barbour | Alabama | 1005 | 942 | 9 |
612186 | 612186 | 2020-10-09 | Barbour | Alabama | 1005 | 939 | 9 |
608944 | 608944 | 2020-10-08 | Barbour | Alabama | 1005 | 927 | 9 |
605701 | 605701 | 2020-10-07 | Barbour | Alabama | 1005 | 927 | 7 |
602459 | 602459 | 2020-10-06 | Barbour | Alabama | 1005 | 923 | 7 |
599216 | 599216 | 2020-10-05 | Barbour | Alabama | 1005 | 921 | 7 |
595973 | 595973 | 2020-10-04 | Barbour | Alabama | 1005 | 921 | 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);