ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 1093 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917239 | 917239 | 2021-01-11 | Marion | Alabama | 1093 | 2335 | 46 |
913994 | 913994 | 2021-01-10 | Marion | Alabama | 1093 | 2320 | 46 |
910749 | 910749 | 2021-01-09 | Marion | Alabama | 1093 | 2304 | 46 |
907504 | 907504 | 2021-01-08 | Marion | Alabama | 1093 | 2281 | 46 |
904258 | 904258 | 2021-01-07 | Marion | Alabama | 1093 | 2248 | 46 |
901013 | 901013 | 2021-01-06 | Marion | Alabama | 1093 | 2223 | 45 |
897768 | 897768 | 2021-01-05 | Marion | Alabama | 1093 | 2190 | 43 |
894522 | 894522 | 2021-01-04 | Marion | Alabama | 1093 | 2164 | 43 |
891276 | 891276 | 2021-01-03 | Marion | Alabama | 1093 | 2152 | 43 |
888029 | 888029 | 2021-01-02 | Marion | Alabama | 1093 | 2134 | 43 |
884784 | 884784 | 2021-01-01 | Marion | Alabama | 1093 | 2112 | 43 |
881539 | 881539 | 2020-12-31 | Marion | Alabama | 1093 | 2087 | 43 |
878294 | 878294 | 2020-12-30 | Marion | Alabama | 1093 | 2049 | 43 |
875049 | 875049 | 2020-12-29 | Marion | Alabama | 1093 | 2019 | 43 |
871804 | 871804 | 2020-12-28 | Marion | Alabama | 1093 | 2004 | 43 |
868559 | 868559 | 2020-12-27 | Marion | Alabama | 1093 | 1997 | 43 |
865314 | 865314 | 2020-12-26 | Marion | Alabama | 1093 | 1990 | 43 |
862069 | 862069 | 2020-12-25 | Marion | Alabama | 1093 | 1986 | 43 |
858824 | 858824 | 2020-12-24 | Marion | Alabama | 1093 | 1952 | 43 |
855579 | 855579 | 2020-12-23 | Marion | Alabama | 1093 | 1933 | 43 |
852334 | 852334 | 2020-12-22 | Marion | Alabama | 1093 | 1913 | 42 |
849089 | 849089 | 2020-12-21 | Marion | Alabama | 1093 | 1880 | 42 |
845844 | 845844 | 2020-12-20 | Marion | Alabama | 1093 | 1853 | 42 |
842598 | 842598 | 2020-12-19 | Marion | Alabama | 1093 | 1841 | 42 |
839353 | 839353 | 2020-12-18 | Marion | Alabama | 1093 | 1813 | 42 |
836108 | 836108 | 2020-12-17 | Marion | Alabama | 1093 | 1779 | 42 |
832862 | 832862 | 2020-12-16 | Marion | Alabama | 1093 | 1739 | 41 |
829615 | 829615 | 2020-12-15 | Marion | Alabama | 1093 | 1716 | 41 |
826369 | 826369 | 2020-12-14 | Marion | Alabama | 1093 | 1708 | 40 |
823122 | 823122 | 2020-12-13 | Marion | Alabama | 1093 | 1684 | 40 |
819876 | 819876 | 2020-12-12 | Marion | Alabama | 1093 | 1669 | 40 |
816630 | 816630 | 2020-12-11 | Marion | Alabama | 1093 | 1648 | 39 |
813384 | 813384 | 2020-12-10 | Marion | Alabama | 1093 | 1632 | 39 |
810140 | 810140 | 2020-12-09 | Marion | Alabama | 1093 | 1597 | 37 |
806895 | 806895 | 2020-12-08 | Marion | Alabama | 1093 | 1585 | 36 |
803650 | 803650 | 2020-12-07 | Marion | Alabama | 1093 | 1558 | 36 |
800405 | 800405 | 2020-12-06 | Marion | Alabama | 1093 | 1537 | 36 |
797160 | 797160 | 2020-12-05 | Marion | Alabama | 1093 | 1530 | 36 |
793915 | 793915 | 2020-12-04 | Marion | Alabama | 1093 | 1502 | 36 |
790670 | 790670 | 2020-12-03 | Marion | Alabama | 1093 | 1482 | 36 |
787425 | 787425 | 2020-12-02 | Marion | Alabama | 1093 | 1461 | 36 |
784181 | 784181 | 2020-12-01 | Marion | Alabama | 1093 | 1447 | 36 |
780936 | 780936 | 2020-11-30 | Marion | Alabama | 1093 | 1436 | 36 |
777690 | 777690 | 2020-11-29 | Marion | Alabama | 1093 | 1413 | 36 |
774445 | 774445 | 2020-11-28 | Marion | Alabama | 1093 | 1402 | 36 |
771200 | 771200 | 2020-11-27 | Marion | Alabama | 1093 | 1379 | 36 |
767954 | 767954 | 2020-11-26 | Marion | Alabama | 1093 | 1371 | 36 |
764709 | 764709 | 2020-11-25 | Marion | Alabama | 1093 | 1365 | 35 |
761464 | 761464 | 2020-11-24 | Marion | Alabama | 1093 | 1355 | 35 |
758219 | 758219 | 2020-11-23 | Marion | Alabama | 1093 | 1345 | 35 |
754972 | 754972 | 2020-11-22 | Marion | Alabama | 1093 | 1339 | 35 |
751726 | 751726 | 2020-11-21 | Marion | Alabama | 1093 | 1330 | 35 |
748480 | 748480 | 2020-11-20 | Marion | Alabama | 1093 | 1320 | 33 |
745234 | 745234 | 2020-11-19 | Marion | Alabama | 1093 | 1303 | 33 |
741987 | 741987 | 2020-11-18 | Marion | Alabama | 1093 | 1300 | 33 |
738740 | 738740 | 2020-11-17 | Marion | Alabama | 1093 | 1294 | 33 |
735496 | 735496 | 2020-11-16 | Marion | Alabama | 1093 | 1284 | 32 |
732250 | 732250 | 2020-11-15 | Marion | Alabama | 1093 | 1276 | 32 |
729005 | 729005 | 2020-11-14 | Marion | Alabama | 1093 | 1263 | 32 |
725762 | 725762 | 2020-11-13 | Marion | Alabama | 1093 | 1258 | 32 |
722519 | 722519 | 2020-11-12 | Marion | Alabama | 1093 | 1243 | 33 |
719276 | 719276 | 2020-11-11 | Marion | Alabama | 1093 | 1226 | 33 |
716033 | 716033 | 2020-11-10 | Marion | Alabama | 1093 | 1222 | 31 |
712789 | 712789 | 2020-11-09 | Marion | Alabama | 1093 | 1215 | 31 |
709545 | 709545 | 2020-11-08 | Marion | Alabama | 1093 | 1211 | 31 |
706301 | 706301 | 2020-11-07 | Marion | Alabama | 1093 | 1203 | 31 |
703058 | 703058 | 2020-11-06 | Marion | Alabama | 1093 | 1197 | 31 |
699815 | 699815 | 2020-11-05 | Marion | Alabama | 1093 | 1188 | 31 |
696571 | 696571 | 2020-11-04 | Marion | Alabama | 1093 | 1177 | 31 |
693329 | 693329 | 2020-11-03 | Marion | Alabama | 1093 | 1150 | 31 |
690086 | 690086 | 2020-11-02 | Marion | Alabama | 1093 | 1134 | 31 |
686841 | 686841 | 2020-11-01 | Marion | Alabama | 1093 | 1127 | 31 |
683597 | 683597 | 2020-10-31 | Marion | Alabama | 1093 | 1121 | 31 |
680354 | 680354 | 2020-10-30 | Marion | Alabama | 1093 | 1118 | 31 |
677111 | 677111 | 2020-10-29 | Marion | Alabama | 1093 | 1109 | 31 |
673868 | 673868 | 2020-10-28 | Marion | Alabama | 1093 | 1103 | 31 |
670626 | 670626 | 2020-10-27 | Marion | Alabama | 1093 | 1103 | 31 |
667383 | 667383 | 2020-10-26 | Marion | Alabama | 1093 | 1097 | 29 |
664138 | 664138 | 2020-10-25 | Marion | Alabama | 1093 | 1081 | 29 |
660894 | 660894 | 2020-10-24 | Marion | Alabama | 1093 | 1076 | 29 |
657650 | 657650 | 2020-10-23 | Marion | Alabama | 1093 | 1071 | 29 |
654405 | 654405 | 2020-10-22 | Marion | Alabama | 1093 | 1062 | 29 |
651160 | 651160 | 2020-10-21 | Marion | Alabama | 1093 | 1050 | 29 |
647916 | 647916 | 2020-10-20 | Marion | Alabama | 1093 | 1047 | 29 |
644671 | 644671 | 2020-10-19 | Marion | Alabama | 1093 | 1042 | 29 |
641423 | 641423 | 2020-10-18 | Marion | Alabama | 1093 | 1039 | 29 |
638176 | 638176 | 2020-10-17 | Marion | Alabama | 1093 | 1037 | 29 |
634931 | 634931 | 2020-10-16 | Marion | Alabama | 1093 | 1036 | 29 |
631686 | 631686 | 2020-10-15 | Marion | Alabama | 1093 | 1032 | 29 |
628442 | 628442 | 2020-10-14 | Marion | Alabama | 1093 | 1025 | 29 |
625199 | 625199 | 2020-10-13 | Marion | Alabama | 1093 | 1024 | 29 |
621956 | 621956 | 2020-10-12 | Marion | Alabama | 1093 | 1022 | 29 |
618713 | 618713 | 2020-10-11 | Marion | Alabama | 1093 | 1019 | 29 |
615471 | 615471 | 2020-10-10 | Marion | Alabama | 1093 | 1020 | 29 |
612230 | 612230 | 2020-10-09 | Marion | Alabama | 1093 | 1020 | 29 |
608988 | 608988 | 2020-10-08 | Marion | Alabama | 1093 | 1015 | 29 |
605745 | 605745 | 2020-10-07 | Marion | Alabama | 1093 | 1009 | 29 |
602503 | 602503 | 2020-10-06 | Marion | Alabama | 1093 | 1006 | 29 |
599260 | 599260 | 2020-10-05 | Marion | Alabama | 1093 | 1002 | 29 |
596017 | 596017 | 2020-10-04 | Marion | Alabama | 1093 | 997 | 29 |
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);