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 67
- 1051 458
- 1073 458
- 1083 458
- 1101 458
- 1125 458
- 1003 457
- 1081 456
- 1117 456
- 1089 454
- 1115 454
- 1015 453
- 1121 453
- 1017 452
- 1097 452
- 1127 452
- 1043 451
- 1071 451
- 1075 451
- 1077 451
- 1129 451
- 1093 450
- 1059 448
- 1069 448
- 1123 448
- 1001 447
- 1103 447
- 1009 446
- 1013 446
- 1019 446
- 1021 446
- 1027 446
- 1029 446
- 1033 446
- 1047 446
- 1055 446
- 1079 446
- 1095 446
- 1107 446
- 1109 446
- 1113 446
- 1131 446
- 1011 445
- 1023 445
- 1037 445
- 1041 445
- 1049 445
- 1085 445
- 1091 445
- 1039 444
- 1053 444
- 1063 444
- 1111 444
- 1133 444
- 1099 443
- 1087 442
- 1007 441
- 1057 441
- 1065 441
- 1119 441
- 1025 439
- 1035 439
- 1045 439
- 1031 438
- 1005 437
- 1067 437
- 1105 431
- 1061 428
county 67
- Elmore 458
- Jefferson 458
- Limestone 458
- Montgomery 458
- Tuscaloosa 458
- Baldwin 457
- Lee 456
- Shelby 456
- Madison 454
- St. Clair 454
- Calhoun 453
- Talladega 453
- Chambers 452
- Mobile 452
- Walker 452
- Cullman 451
- Jackson 451
- Lamar 451
- Lauderdale 451
- Washington 451
- Marion 450
- Franklin 448
- Houston 448
- Tallapoosa 448
- Autauga 447
- Morgan 447
- Blount 446
- Butler 446
- Cherokee 446
- Chilton 446
- Clay 446
- Cleburne 446
- Colbert 446
- Dallas 446
- Etowah 446
- Lawrence 446
- Marshall 446
- Pickens 446
- Pike 446
- Russell 446
- Wilcox 446
- Bullock 445
- Choctaw 445
- Coosa 445
- Crenshaw 445
- DeKalb 445
- Lowndes 445
- Marengo 445
- Covington 444
- Escambia 444
- Greene 444
- Randolph 444
- Winston 444
- Monroe 443
- Macon 442
- Bibb 441
- Fayette 441
- Hale 441
- Sumter 441
- Clarke 439
- Conecuh 439
- Dale 439
- Coffee 438
- Barbour 437
- Henry 437
- Perry 431
- Geneva 428
state 1
- Alabama · 29,934 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1413884 | 1413884 | 2021-06-13 | Autauga | Alabama | 1001 | 7215 | 113 |
1413885 | 1413885 | 2021-06-13 | Baldwin | Alabama | 1003 | 21774 | 313 |
1413886 | 1413886 | 2021-06-13 | Barbour | Alabama | 1005 | 2345 | 59 |
1413887 | 1413887 | 2021-06-13 | Bibb | Alabama | 1007 | 2673 | 64 |
1413888 | 1413888 | 2021-06-13 | Blount | Alabama | 1009 | 6925 | 139 |
1413889 | 1413889 | 2021-06-13 | Bullock | Alabama | 1011 | 1242 | 42 |
1413890 | 1413890 | 2021-06-13 | Butler | Alabama | 1013 | 2233 | 71 |
1413891 | 1413891 | 2021-06-13 | Calhoun | Alabama | 1015 | 14692 | 325 |
1413892 | 1413892 | 2021-06-13 | Chambers | Alabama | 1017 | 3715 | 123 |
1413893 | 1413893 | 2021-06-13 | Cherokee | Alabama | 1019 | 1872 | 45 |
1413894 | 1413894 | 2021-06-13 | Chilton | Alabama | 1021 | 4461 | 116 |
1413895 | 1413895 | 2021-06-13 | Choctaw | Alabama | 1023 | 617 | 25 |
1413896 | 1413896 | 2021-06-13 | Clarke | Alabama | 1025 | 3528 | 61 |
1413897 | 1413897 | 2021-06-13 | Clay | Alabama | 1027 | 1595 | 59 |
1413898 | 1413898 | 2021-06-13 | Cleburne | Alabama | 1029 | 1525 | 43 |
1413899 | 1413899 | 2021-06-13 | Coffee | Alabama | 1031 | 5616 | 126 |
1413900 | 1413900 | 2021-06-13 | Colbert | Alabama | 1033 | 6394 | 139 |
1413901 | 1413901 | 2021-06-13 | Conecuh | Alabama | 1035 | 1129 | 30 |
1413902 | 1413902 | 2021-06-13 | Coosa | Alabama | 1037 | 1111 | 29 |
1413903 | 1413903 | 2021-06-13 | Covington | Alabama | 1039 | 4263 | 122 |
1413904 | 1413904 | 2021-06-13 | Crenshaw | Alabama | 1041 | 1550 | 57 |
1413905 | 1413905 | 2021-06-13 | Cullman | Alabama | 1043 | 9921 | 200 |
1413906 | 1413906 | 2021-06-13 | Dale | Alabama | 1045 | 4928 | 114 |
1413907 | 1413907 | 2021-06-13 | Dallas | Alabama | 1047 | 3604 | 156 |
1413908 | 1413908 | 2021-06-13 | DeKalb | Alabama | 1049 | 8955 | 189 |
1413909 | 1413909 | 2021-06-13 | Elmore | Alabama | 1051 | 10295 | 212 |
1413910 | 1413910 | 2021-06-13 | Escambia | Alabama | 1053 | 4002 | 80 |
1413911 | 1413911 | 2021-06-13 | Etowah | Alabama | 1055 | 14132 | 361 |
1413912 | 1413912 | 2021-06-13 | Fayette | Alabama | 1057 | 2171 | 62 |
1413913 | 1413913 | 2021-06-13 | Franklin | Alabama | 1059 | 4306 | 83 |
1413914 | 1413914 | 2021-06-13 | Geneva | Alabama | 1061 | 2569 | 81 |
1413915 | 1413915 | 2021-06-13 | Greene | Alabama | 1063 | 934 | 34 |
1413916 | 1413916 | 2021-06-13 | Hale | Alabama | 1065 | 2265 | 78 |
1413917 | 1413917 | 2021-06-13 | Henry | Alabama | 1067 | 1938 | 43 |
1413918 | 1413918 | 2021-06-13 | Houston | Alabama | 1069 | 10748 | 287 |
1413919 | 1413919 | 2021-06-13 | Jackson | Alabama | 1071 | 6900 | 113 |
1413920 | 1413920 | 2021-06-13 | Jefferson | Alabama | 1073 | 80802 | 1563 |
1413921 | 1413921 | 2021-06-13 | Lamar | Alabama | 1075 | 1458 | 37 |
1413922 | 1413922 | 2021-06-13 | Lauderdale | Alabama | 1077 | 9582 | 248 |
1413923 | 1413923 | 2021-06-13 | Lawrence | Alabama | 1079 | 3121 | 100 |
1413924 | 1413924 | 2021-06-13 | Lee | Alabama | 1081 | 16234 | 175 |
1413925 | 1413925 | 2021-06-13 | Limestone | Alabama | 1083 | 10180 | 157 |
1413926 | 1413926 | 2021-06-13 | Lowndes | Alabama | 1085 | 1419 | 53 |
1413927 | 1413927 | 2021-06-13 | Macon | Alabama | 1087 | 1630 | 51 |
1413928 | 1413928 | 2021-06-13 | Madison | Alabama | 1089 | 35600 | 522 |
1413929 | 1413929 | 2021-06-13 | Marengo | Alabama | 1091 | 2505 | 65 |
1413930 | 1413930 | 2021-06-13 | Marion | Alabama | 1093 | 3231 | 106 |
1413931 | 1413931 | 2021-06-13 | Marshall | Alabama | 1095 | 12443 | 230 |
1413932 | 1413932 | 2021-06-13 | Mobile | Alabama | 1097 | 41925 | 826 |
1413933 | 1413933 | 2021-06-13 | Monroe | Alabama | 1099 | 1791 | 41 |
1413934 | 1413934 | 2021-06-13 | Montgomery | Alabama | 1101 | 25067 | 610 |
1413935 | 1413935 | 2021-06-13 | Morgan | Alabama | 1103 | 14614 | 285 |
1413936 | 1413936 | 2021-06-13 | Perry | Alabama | 1105 | 1087 | 26 |
1413937 | 1413937 | 2021-06-13 | Pickens | Alabama | 1107 | 2365 | 62 |
1413938 | 1413938 | 2021-06-13 | Pike | Alabama | 1109 | 3139 | 78 |
1413939 | 1413939 | 2021-06-13 | Randolph | Alabama | 1111 | 1868 | 44 |
1413940 | 1413940 | 2021-06-13 | Russell | Alabama | 1113 | 4544 | 41 |
1413941 | 1413941 | 2021-06-13 | Shelby | Alabama | 1117 | 25554 | 254 |
1413942 | 1413942 | 2021-06-13 | St. Clair | Alabama | 1115 | 10146 | 250 |
1413943 | 1413943 | 2021-06-13 | Sumter | Alabama | 1119 | 1057 | 32 |
1413944 | 1413944 | 2021-06-13 | Talladega | Alabama | 1121 | 8441 | 184 |
1413945 | 1413945 | 2021-06-13 | Tallapoosa | Alabama | 1123 | 4117 | 154 |
1413946 | 1413946 | 2021-06-13 | Tuscaloosa | Alabama | 1125 | 26136 | 458 |
1413947 | 1413947 | 2021-06-13 | Walker | Alabama | 1127 | 7318 | 279 |
1413948 | 1413948 | 2021-06-13 | Washington | Alabama | 1129 | 1703 | 39 |
1413949 | 1413949 | 2021-06-13 | Wilcox | Alabama | 1131 | 1270 | 30 |
1413950 | 1413950 | 2021-06-13 | Winston | Alabama | 1133 | 2833 | 72 |
1410639 | 1410639 | 2021-06-12 | Autauga | Alabama | 1001 | 7215 | 113 |
1410640 | 1410640 | 2021-06-12 | Baldwin | Alabama | 1003 | 21774 | 313 |
1410641 | 1410641 | 2021-06-12 | Barbour | Alabama | 1005 | 2345 | 59 |
1410642 | 1410642 | 2021-06-12 | Bibb | Alabama | 1007 | 2673 | 64 |
1410643 | 1410643 | 2021-06-12 | Blount | Alabama | 1009 | 6925 | 139 |
1410644 | 1410644 | 2021-06-12 | Bullock | Alabama | 1011 | 1242 | 42 |
1410645 | 1410645 | 2021-06-12 | Butler | Alabama | 1013 | 2233 | 71 |
1410646 | 1410646 | 2021-06-12 | Calhoun | Alabama | 1015 | 14692 | 325 |
1410647 | 1410647 | 2021-06-12 | Chambers | Alabama | 1017 | 3715 | 123 |
1410648 | 1410648 | 2021-06-12 | Cherokee | Alabama | 1019 | 1872 | 45 |
1410649 | 1410649 | 2021-06-12 | Chilton | Alabama | 1021 | 4461 | 116 |
1410650 | 1410650 | 2021-06-12 | Choctaw | Alabama | 1023 | 617 | 25 |
1410651 | 1410651 | 2021-06-12 | Clarke | Alabama | 1025 | 3528 | 61 |
1410652 | 1410652 | 2021-06-12 | Clay | Alabama | 1027 | 1595 | 59 |
1410653 | 1410653 | 2021-06-12 | Cleburne | Alabama | 1029 | 1525 | 43 |
1410654 | 1410654 | 2021-06-12 | Coffee | Alabama | 1031 | 5616 | 126 |
1410655 | 1410655 | 2021-06-12 | Colbert | Alabama | 1033 | 6394 | 139 |
1410656 | 1410656 | 2021-06-12 | Conecuh | Alabama | 1035 | 1129 | 30 |
1410657 | 1410657 | 2021-06-12 | Coosa | Alabama | 1037 | 1111 | 29 |
1410658 | 1410658 | 2021-06-12 | Covington | Alabama | 1039 | 4263 | 122 |
1410659 | 1410659 | 2021-06-12 | Crenshaw | Alabama | 1041 | 1550 | 57 |
1410660 | 1410660 | 2021-06-12 | Cullman | Alabama | 1043 | 9921 | 200 |
1410661 | 1410661 | 2021-06-12 | Dale | Alabama | 1045 | 4928 | 114 |
1410662 | 1410662 | 2021-06-12 | Dallas | Alabama | 1047 | 3604 | 156 |
1410663 | 1410663 | 2021-06-12 | DeKalb | Alabama | 1049 | 8955 | 189 |
1410664 | 1410664 | 2021-06-12 | Elmore | Alabama | 1051 | 10295 | 212 |
1410665 | 1410665 | 2021-06-12 | Escambia | Alabama | 1053 | 4002 | 80 |
1410666 | 1410666 | 2021-06-12 | Etowah | Alabama | 1055 | 14132 | 361 |
1410667 | 1410667 | 2021-06-12 | Fayette | Alabama | 1057 | 2171 | 62 |
1410668 | 1410668 | 2021-06-12 | Franklin | Alabama | 1059 | 4306 | 83 |
1410669 | 1410669 | 2021-06-12 | Geneva | Alabama | 1061 | 2569 | 81 |
1410670 | 1410670 | 2021-06-12 | Greene | Alabama | 1063 | 934 | 34 |
1410671 | 1410671 | 2021-06-12 | Hale | Alabama | 1065 | 2265 | 78 |
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);