ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
52,312 rows where state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Elmore 671
- Jefferson 671
- Limestone 671
- Montgomery 671
- Tuscaloosa 671
- Baldwin 670
- Lee 669
- Shelby 669
- Madison 667
- St. Clair 667
- Calhoun 666
- Talladega 666
- Chambers 665
- Mobile 665
- Walker 665
- Cullman 664
- Jackson 664
- Lamar 664
- Lauderdale 664
- Washington 664
- Marion 663
- Franklin 661
- Houston 661
- Tallapoosa 661
- Autauga 660
- Morgan 660
- Blount 659
- Butler 659
- Cherokee 659
- Chilton 659
- …
state 1
- Alabama · 44,205 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2105877 | 2105877 | 2022-01-12 | Autauga | Alabama | 1001 | 12180 | 162 |
2105878 | 2105878 | 2022-01-12 | Baldwin | Alabama | 1003 | 44353 | 603 |
2105879 | 2105879 | 2022-01-12 | Barbour | Alabama | 1005 | 4437 | 83 |
2105880 | 2105880 | 2022-01-12 | Bibb | Alabama | 1007 | 5046 | 95 |
2105881 | 2105881 | 2022-01-12 | Blount | Alabama | 1009 | 12068 | 202 |
2105882 | 2105882 | 2022-01-12 | Bullock | Alabama | 1011 | 1922 | 46 |
2105883 | 2105883 | 2022-01-12 | Butler | Alabama | 1013 | 4073 | 102 |
2105884 | 2105884 | 2022-01-12 | Calhoun | Alabama | 1015 | 25325 | 535 |
2105885 | 2105885 | 2022-01-12 | Chambers | Alabama | 1017 | 7054 | 147 |
2105886 | 2105886 | 2022-01-12 | Cherokee | Alabama | 1019 | 3719 | 66 |
2105887 | 2105887 | 2022-01-12 | Chilton | Alabama | 1021 | 8177 | 175 |
2105888 | 2105888 | 2022-01-12 | Choctaw | Alabama | 1023 | 1245 | 30 |
2105889 | 2105889 | 2022-01-12 | Clarke | Alabama | 1025 | 5479 | 89 |
2105890 | 2105890 | 2022-01-12 | Clay | Alabama | 1027 | 3002 | 70 |
2105891 | 2105891 | 2022-01-12 | Cleburne | Alabama | 1029 | 2814 | 61 |
2105892 | 2105892 | 2022-01-12 | Coffee | Alabama | 1031 | 10727 | 201 |
2105893 | 2105893 | 2022-01-12 | Colbert | Alabama | 1033 | 11076 | 217 |
2105894 | 2105894 | 2022-01-12 | Conecuh | Alabama | 1035 | 2246 | 62 |
2105895 | 2105895 | 2022-01-12 | Coosa | Alabama | 1037 | 2202 | 48 |
2105896 | 2105896 | 2022-01-12 | Covington | Alabama | 1039 | 7587 | 203 |
2105897 | 2105897 | 2022-01-12 | Crenshaw | Alabama | 1041 | 3065 | 80 |
2105898 | 2105898 | 2022-01-12 | Cullman | Alabama | 1043 | 18496 | 316 |
2105899 | 2105899 | 2022-01-12 | Dale | Alabama | 1045 | 10274 | 198 |
2105900 | 2105900 | 2022-01-12 | Dallas | Alabama | 1047 | 6343 | 214 |
2105901 | 2105901 | 2022-01-12 | DeKalb | Alabama | 1049 | 14425 | 283 |
2105902 | 2105902 | 2022-01-12 | Elmore | Alabama | 1051 | 18318 | 301 |
2105903 | 2105903 | 2022-01-12 | Escambia | Alabama | 1053 | 8153 | 150 |
2105904 | 2105904 | 2022-01-12 | Etowah | Alabama | 1055 | 22449 | 530 |
2105905 | 2105905 | 2022-01-12 | Fayette | Alabama | 1057 | 3630 | 86 |
2105906 | 2105906 | 2022-01-12 | Franklin | Alabama | 1059 | 7036 | 114 |
2105907 | 2105907 | 2022-01-12 | Geneva | Alabama | 1061 | 4986 | 138 |
2105908 | 2105908 | 2022-01-12 | Greene | Alabama | 1063 | 1493 | 47 |
2105909 | 2105909 | 2022-01-12 | Hale | Alabama | 1065 | 3705 | 91 |
2105910 | 2105910 | 2022-01-12 | Henry | Alabama | 1067 | 3584 | 67 |
2105911 | 2105911 | 2022-01-12 | Houston | Alabama | 1069 | 20142 | 437 |
2105912 | 2105912 | 2022-01-12 | Jackson | Alabama | 1071 | 11314 | 204 |
2105913 | 2105913 | 2022-01-12 | Jefferson | Alabama | 1073 | 145464 | 2034 |
2105914 | 2105914 | 2022-01-12 | Lamar | Alabama | 1075 | 2756 | 60 |
2105915 | 2105915 | 2022-01-12 | Lauderdale | Alabama | 1077 | 17639 | 322 |
2105916 | 2105916 | 2022-01-12 | Lawrence | Alabama | 1079 | 5522 | 138 |
2105917 | 2105917 | 2022-01-12 | Lee | Alabama | 1081 | 30677 | 271 |
2105918 | 2105918 | 2022-01-12 | Limestone | Alabama | 1083 | 19006 | 231 |
2105919 | 2105919 | 2022-01-12 | Lowndes | Alabama | 1085 | 2166 | 68 |
2105920 | 2105920 | 2022-01-12 | Macon | Alabama | 1087 | 3070 | 69 |
2105921 | 2105921 | 2022-01-12 | Madison | Alabama | 1089 | 66148 | 779 |
2105922 | 2105922 | 2022-01-12 | Marengo | Alabama | 1091 | 3819 | 93 |
2105923 | 2105923 | 2022-01-12 | Marion | Alabama | 1093 | 5994 | 132 |
2105924 | 2105924 | 2022-01-12 | Marshall | Alabama | 1095 | 20951 | 329 |
2105925 | 2105925 | 2022-01-12 | Mobile | Alabama | 1097 | 90684 | 1405 |
2105926 | 2105926 | 2022-01-12 | Monroe | Alabama | 1099 | 4029 | 66 |
2105927 | 2105927 | 2022-01-12 | Montgomery | Alabama | 1101 | 44560 | 804 |
2105928 | 2105928 | 2022-01-12 | Morgan | Alabama | 1103 | 26361 | 431 |
2105929 | 2105929 | 2022-01-12 | Perry | Alabama | 1105 | 1666 | 41 |
2105930 | 2105930 | 2022-01-12 | Pickens | Alabama | 1107 | 3918 | 92 |
2105931 | 2105931 | 2022-01-12 | Pike | Alabama | 1109 | 5975 | 112 |
2105932 | 2105932 | 2022-01-12 | Randolph | Alabama | 1111 | 4072 | 68 |
2105933 | 2105933 | 2022-01-12 | Russell | Alabama | 1113 | 8282 | 68 |
2105934 | 2105934 | 2022-01-12 | Shelby | Alabama | 1117 | 46249 | 383 |
2105935 | 2105935 | 2022-01-12 | St. Clair | Alabama | 1115 | 20037 | 367 |
2105936 | 2105936 | 2022-01-12 | Sumter | Alabama | 1119 | 1737 | 42 |
2105937 | 2105937 | 2022-01-12 | Talladega | Alabama | 1121 | 16909 | 313 |
2105938 | 2105938 | 2022-01-12 | Tallapoosa | Alabama | 1123 | 8858 | 207 |
2105939 | 2105939 | 2022-01-12 | Tuscaloosa | Alabama | 1125 | 42127 | 667 |
2105940 | 2105940 | 2022-01-12 | Walker | Alabama | 1127 | 13579 | 392 |
2105941 | 2105941 | 2022-01-12 | Washington | Alabama | 1129 | 2823 | 52 |
2105942 | 2105942 | 2022-01-12 | Wilcox | Alabama | 1131 | 2092 | 38 |
2105943 | 2105943 | 2022-01-12 | Winston | Alabama | 1133 | 5307 | 114 |
2102626 | 2102626 | 2022-01-11 | Autauga | Alabama | 1001 | 12102 | 162 |
2102627 | 2102627 | 2022-01-11 | Baldwin | Alabama | 1003 | 43896 | 603 |
2102628 | 2102628 | 2022-01-11 | Barbour | Alabama | 1005 | 4375 | 83 |
2102629 | 2102629 | 2022-01-11 | Bibb | Alabama | 1007 | 5007 | 95 |
2102630 | 2102630 | 2022-01-11 | Blount | Alabama | 1009 | 11965 | 202 |
2102631 | 2102631 | 2022-01-11 | Bullock | Alabama | 1011 | 1901 | 46 |
2102632 | 2102632 | 2022-01-11 | Butler | Alabama | 1013 | 4037 | 102 |
2102633 | 2102633 | 2022-01-11 | Calhoun | Alabama | 1015 | 25110 | 535 |
2102634 | 2102634 | 2022-01-11 | Chambers | Alabama | 1017 | 7008 | 147 |
2102635 | 2102635 | 2022-01-11 | Cherokee | Alabama | 1019 | 3682 | 66 |
2102636 | 2102636 | 2022-01-11 | Chilton | Alabama | 1021 | 8080 | 175 |
2102637 | 2102637 | 2022-01-11 | Choctaw | Alabama | 1023 | 1203 | 30 |
2102638 | 2102638 | 2022-01-11 | Clarke | Alabama | 1025 | 5375 | 89 |
2102639 | 2102639 | 2022-01-11 | Clay | Alabama | 1027 | 2950 | 70 |
2102640 | 2102640 | 2022-01-11 | Cleburne | Alabama | 1029 | 2793 | 61 |
2102641 | 2102641 | 2022-01-11 | Coffee | Alabama | 1031 | 10605 | 201 |
2102642 | 2102642 | 2022-01-11 | Colbert | Alabama | 1033 | 10942 | 217 |
2102643 | 2102643 | 2022-01-11 | Conecuh | Alabama | 1035 | 2224 | 62 |
2102644 | 2102644 | 2022-01-11 | Coosa | Alabama | 1037 | 2175 | 48 |
2102645 | 2102645 | 2022-01-11 | Covington | Alabama | 1039 | 7524 | 203 |
2102646 | 2102646 | 2022-01-11 | Crenshaw | Alabama | 1041 | 3024 | 80 |
2102647 | 2102647 | 2022-01-11 | Cullman | Alabama | 1043 | 18341 | 315 |
2102648 | 2102648 | 2022-01-11 | Dale | Alabama | 1045 | 10134 | 198 |
2102649 | 2102649 | 2022-01-11 | Dallas | Alabama | 1047 | 6291 | 213 |
2102650 | 2102650 | 2022-01-11 | DeKalb | Alabama | 1049 | 14329 | 283 |
2102651 | 2102651 | 2022-01-11 | Elmore | Alabama | 1051 | 18148 | 301 |
2102652 | 2102652 | 2022-01-11 | Escambia | Alabama | 1053 | 8073 | 150 |
2102653 | 2102653 | 2022-01-11 | Etowah | Alabama | 1055 | 22187 | 530 |
2102654 | 2102654 | 2022-01-11 | Fayette | Alabama | 1057 | 3605 | 86 |
2102655 | 2102655 | 2022-01-11 | Franklin | Alabama | 1059 | 6954 | 113 |
2102656 | 2102656 | 2022-01-11 | Geneva | Alabama | 1061 | 4954 | 138 |
2102657 | 2102657 | 2022-01-11 | Greene | Alabama | 1063 | 1479 | 47 |
2102658 | 2102658 | 2022-01-11 | Hale | Alabama | 1065 | 3659 | 91 |
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);