ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
401 rows where deaths = 8 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wilcox 38
- Geneva 30
- Pike 30
- Henry 28
- Monroe 22
- Randolph 18
- Cherokee 17
- Lamar 16
- Talladega 16
- Etowah 12
- Fayette 9
- Baldwin 8
- Coffee 8
- Escambia 8
- Greene 8
- Marshall 8
- Tuscaloosa 8
- Chambers 7
- Conecuh 7
- Covington 7
- Dallas 6
- Madison 6
- Cleburne 5
- Lauderdale 5
- Walker 5
- Bibb 4
- Choctaw 4
- Clay 4
- Franklin 4
- Houston 4
- …
state 1
- Alabama · 401 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
904245 | 904245 | 2021-01-07 | Henry | Alabama | 1067 | 1382 | 8 |
901000 | 901000 | 2021-01-06 | Henry | Alabama | 1067 | 1350 | 8 |
897755 | 897755 | 2021-01-05 | Henry | Alabama | 1067 | 1322 | 8 |
894509 | 894509 | 2021-01-04 | Henry | Alabama | 1067 | 1307 | 8 |
891263 | 891263 | 2021-01-03 | Henry | Alabama | 1067 | 1296 | 8 |
888016 | 888016 | 2021-01-02 | Henry | Alabama | 1067 | 1284 | 8 |
884771 | 884771 | 2021-01-01 | Henry | Alabama | 1067 | 1268 | 8 |
881526 | 881526 | 2020-12-31 | Henry | Alabama | 1067 | 1247 | 8 |
878281 | 878281 | 2020-12-30 | Henry | Alabama | 1067 | 1222 | 8 |
875036 | 875036 | 2020-12-29 | Henry | Alabama | 1067 | 1193 | 8 |
871791 | 871791 | 2020-12-28 | Henry | Alabama | 1067 | 1178 | 8 |
868546 | 868546 | 2020-12-27 | Henry | Alabama | 1067 | 1172 | 8 |
865301 | 865301 | 2020-12-26 | Henry | Alabama | 1067 | 1160 | 8 |
862056 | 862056 | 2020-12-25 | Henry | Alabama | 1067 | 1155 | 8 |
858811 | 858811 | 2020-12-24 | Henry | Alabama | 1067 | 1140 | 8 |
855566 | 855566 | 2020-12-23 | Henry | Alabama | 1067 | 1130 | 8 |
852321 | 852321 | 2020-12-22 | Henry | Alabama | 1067 | 1115 | 8 |
849076 | 849076 | 2020-12-21 | Henry | Alabama | 1067 | 1093 | 8 |
845831 | 845831 | 2020-12-20 | Henry | Alabama | 1067 | 1085 | 8 |
842585 | 842585 | 2020-12-19 | Henry | Alabama | 1067 | 1081 | 8 |
839340 | 839340 | 2020-12-18 | Henry | Alabama | 1067 | 1061 | 8 |
836095 | 836095 | 2020-12-17 | Henry | Alabama | 1067 | 1037 | 8 |
832849 | 832849 | 2020-12-16 | Henry | Alabama | 1067 | 1019 | 8 |
829602 | 829602 | 2020-12-15 | Henry | Alabama | 1067 | 1006 | 8 |
826356 | 826356 | 2020-12-14 | Henry | Alabama | 1067 | 995 | 8 |
823109 | 823109 | 2020-12-13 | Henry | Alabama | 1067 | 989 | 8 |
819863 | 819863 | 2020-12-12 | Henry | Alabama | 1067 | 984 | 8 |
816617 | 816617 | 2020-12-11 | Henry | Alabama | 1067 | 961 | 8 |
813375 | 813375 | 2020-12-10 | Lamar | Alabama | 1075 | 806 | 8 |
810131 | 810131 | 2020-12-09 | Lamar | Alabama | 1075 | 786 | 8 |
806886 | 806886 | 2020-12-08 | Lamar | Alabama | 1075 | 769 | 8 |
803641 | 803641 | 2020-12-07 | Lamar | Alabama | 1075 | 759 | 8 |
800396 | 800396 | 2020-12-06 | Lamar | Alabama | 1075 | 755 | 8 |
797151 | 797151 | 2020-12-05 | Lamar | Alabama | 1075 | 744 | 8 |
793906 | 793906 | 2020-12-04 | Lamar | Alabama | 1075 | 734 | 8 |
790654 | 790654 | 2020-12-03 | Geneva | Alabama | 1061 | 1281 | 8 |
790661 | 790661 | 2020-12-03 | Lamar | Alabama | 1075 | 725 | 8 |
787409 | 787409 | 2020-12-02 | Geneva | Alabama | 1061 | 1263 | 8 |
787416 | 787416 | 2020-12-02 | Lamar | Alabama | 1075 | 713 | 8 |
784165 | 784165 | 2020-12-01 | Geneva | Alabama | 1061 | 1250 | 8 |
784172 | 784172 | 2020-12-01 | Lamar | Alabama | 1075 | 701 | 8 |
780920 | 780920 | 2020-11-30 | Geneva | Alabama | 1061 | 1243 | 8 |
780927 | 780927 | 2020-11-30 | Lamar | Alabama | 1075 | 689 | 8 |
777674 | 777674 | 2020-11-29 | Geneva | Alabama | 1061 | 1237 | 8 |
777681 | 777681 | 2020-11-29 | Lamar | Alabama | 1075 | 683 | 8 |
774429 | 774429 | 2020-11-28 | Geneva | Alabama | 1061 | 1221 | 8 |
774436 | 774436 | 2020-11-28 | Lamar | Alabama | 1075 | 679 | 8 |
771184 | 771184 | 2020-11-27 | Geneva | Alabama | 1061 | 1213 | 8 |
771191 | 771191 | 2020-11-27 | Lamar | Alabama | 1075 | 671 | 8 |
767938 | 767938 | 2020-11-26 | Geneva | Alabama | 1061 | 1210 | 8 |
767945 | 767945 | 2020-11-26 | Lamar | Alabama | 1075 | 667 | 8 |
764693 | 764693 | 2020-11-25 | Geneva | Alabama | 1061 | 1202 | 8 |
764700 | 764700 | 2020-11-25 | Lamar | Alabama | 1075 | 650 | 8 |
761448 | 761448 | 2020-11-24 | Geneva | Alabama | 1061 | 1184 | 8 |
758203 | 758203 | 2020-11-23 | Geneva | Alabama | 1061 | 1174 | 8 |
754956 | 754956 | 2020-11-22 | Geneva | Alabama | 1061 | 1167 | 8 |
751710 | 751710 | 2020-11-21 | Geneva | Alabama | 1061 | 1155 | 8 |
748464 | 748464 | 2020-11-20 | Geneva | Alabama | 1061 | 1145 | 8 |
745218 | 745218 | 2020-11-19 | Geneva | Alabama | 1061 | 1135 | 8 |
741971 | 741971 | 2020-11-18 | Geneva | Alabama | 1061 | 1124 | 8 |
738724 | 738724 | 2020-11-17 | Geneva | Alabama | 1061 | 1118 | 8 |
735480 | 735480 | 2020-11-16 | Geneva | Alabama | 1061 | 1114 | 8 |
732234 | 732234 | 2020-11-15 | Geneva | Alabama | 1061 | 1101 | 8 |
728989 | 728989 | 2020-11-14 | Geneva | Alabama | 1061 | 1084 | 8 |
725746 | 725746 | 2020-11-13 | Geneva | Alabama | 1061 | 1078 | 8 |
722503 | 722503 | 2020-11-12 | Geneva | Alabama | 1061 | 1065 | 8 |
719260 | 719260 | 2020-11-11 | Geneva | Alabama | 1061 | 1053 | 8 |
716017 | 716017 | 2020-11-10 | Geneva | Alabama | 1061 | 1038 | 8 |
712773 | 712773 | 2020-11-09 | Geneva | Alabama | 1061 | 1032 | 8 |
709529 | 709529 | 2020-11-08 | Geneva | Alabama | 1061 | 1025 | 8 |
706285 | 706285 | 2020-11-07 | Geneva | Alabama | 1061 | 1016 | 8 |
703042 | 703042 | 2020-11-06 | Geneva | Alabama | 1061 | 1012 | 8 |
699799 | 699799 | 2020-11-05 | Geneva | Alabama | 1061 | 1003 | 8 |
696555 | 696555 | 2020-11-04 | Geneva | Alabama | 1061 | 993 | 8 |
667351 | 667351 | 2020-10-26 | Cleburne | Alabama | 1029 | 573 | 8 |
664106 | 664106 | 2020-10-25 | Cleburne | Alabama | 1029 | 569 | 8 |
660862 | 660862 | 2020-10-24 | Cleburne | Alabama | 1029 | 556 | 8 |
657618 | 657618 | 2020-10-23 | Cleburne | Alabama | 1029 | 551 | 8 |
654373 | 654373 | 2020-10-22 | Cleburne | Alabama | 1029 | 543 | 8 |
599263 | 599263 | 2020-10-05 | Monroe | Alabama | 1099 | 597 | 8 |
596020 | 596020 | 2020-10-04 | Monroe | Alabama | 1099 | 597 | 8 |
592778 | 592778 | 2020-10-03 | Monroe | Alabama | 1099 | 595 | 8 |
589538 | 589538 | 2020-10-02 | Monroe | Alabama | 1099 | 593 | 8 |
586297 | 586297 | 2020-10-01 | Monroe | Alabama | 1099 | 592 | 8 |
583057 | 583057 | 2020-09-30 | Monroe | Alabama | 1099 | 592 | 8 |
579782 | 579782 | 2020-09-29 | Clay | Alabama | 1027 | 591 | 8 |
579818 | 579818 | 2020-09-29 | Monroe | Alabama | 1099 | 590 | 8 |
576541 | 576541 | 2020-09-28 | Clay | Alabama | 1027 | 592 | 8 |
576556 | 576556 | 2020-09-28 | Fayette | Alabama | 1057 | 467 | 8 |
576577 | 576577 | 2020-09-28 | Monroe | Alabama | 1099 | 590 | 8 |
573297 | 573297 | 2020-09-27 | Clay | Alabama | 1027 | 587 | 8 |
573312 | 573312 | 2020-09-27 | Fayette | Alabama | 1057 | 462 | 8 |
573333 | 573333 | 2020-09-27 | Monroe | Alabama | 1099 | 590 | 8 |
570055 | 570055 | 2020-09-26 | Clay | Alabama | 1027 | 585 | 8 |
570070 | 570070 | 2020-09-26 | Fayette | Alabama | 1057 | 457 | 8 |
570091 | 570091 | 2020-09-26 | Monroe | Alabama | 1099 | 589 | 8 |
566829 | 566829 | 2020-09-25 | Fayette | Alabama | 1057 | 450 | 8 |
566850 | 566850 | 2020-09-25 | Monroe | Alabama | 1099 | 584 | 8 |
563575 | 563575 | 2020-09-24 | Coffee | Alabama | 1031 | 1307 | 8 |
563588 | 563588 | 2020-09-24 | Fayette | Alabama | 1057 | 443 | 8 |
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);