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 550
- Jefferson 550
- Limestone 550
- Montgomery 550
- Tuscaloosa 550
- Baldwin 549
- Lee 548
- Shelby 548
- Madison 546
- St. Clair 546
- Calhoun 545
- Talladega 545
- Chambers 544
- Mobile 544
- Walker 544
- Cullman 543
- Jackson 543
- Lamar 543
- Lauderdale 543
- Washington 543
- Marion 542
- Franklin 540
- Houston 540
- Tallapoosa 540
- Autauga 539
- Morgan 539
- Blount 538
- Butler 538
- Cherokee 538
- Chilton 538
- …
state 1
- Alabama · 36,098 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1712647 | 1712647 | 2021-09-13 | Autauga | Alabama | 1001 | 9317 | 119 |
1712648 | 1712648 | 2021-09-13 | Baldwin | Alabama | 1003 | 35039 | 412 |
1712649 | 1712649 | 2021-09-13 | Barbour | Alabama | 1005 | 3315 | 67 |
1712650 | 1712650 | 2021-09-13 | Bibb | Alabama | 1007 | 3821 | 75 |
1712651 | 1712651 | 2021-09-13 | Blount | Alabama | 1009 | 9199 | 146 |
1712652 | 1712652 | 2021-09-13 | Bullock | Alabama | 1011 | 1442 | 42 |
1712653 | 1712653 | 2021-09-13 | Butler | Alabama | 1013 | 3024 | 77 |
1712654 | 1712654 | 2021-09-13 | Calhoun | Alabama | 1015 | 19359 | 363 |
1712655 | 1712655 | 2021-09-13 | Chambers | Alabama | 1017 | 5084 | 127 |
1712656 | 1712656 | 2021-09-13 | Cherokee | Alabama | 1019 | 2714 | 49 |
1712657 | 1712657 | 2021-09-13 | Chilton | Alabama | 1021 | 6100 | 127 |
1712658 | 1712658 | 2021-09-13 | Choctaw | Alabama | 1023 | 713 | 25 |
1712659 | 1712659 | 2021-09-13 | Clarke | Alabama | 1025 | 4424 | 68 |
1712660 | 1712660 | 2021-09-13 | Clay | Alabama | 1027 | 2159 | 60 |
1712661 | 1712661 | 2021-09-13 | Cleburne | Alabama | 1029 | 2042 | 46 |
1712662 | 1712662 | 2021-09-13 | Coffee | Alabama | 1031 | 8468 | 149 |
1712663 | 1712663 | 2021-09-13 | Colbert | Alabama | 1033 | 8142 | 159 |
1712664 | 1712664 | 2021-09-13 | Conecuh | Alabama | 1035 | 1712 | 37 |
1712665 | 1712665 | 2021-09-13 | Coosa | Alabama | 1037 | 1564 | 31 |
1712666 | 1712666 | 2021-09-13 | Covington | Alabama | 1039 | 6133 | 153 |
1712667 | 1712667 | 2021-09-13 | Crenshaw | Alabama | 1041 | 2244 | 62 |
1712668 | 1712668 | 2021-09-13 | Cullman | Alabama | 1043 | 13566 | 226 |
1712669 | 1712669 | 2021-09-13 | Dale | Alabama | 1045 | 8069 | 141 |
1712670 | 1712670 | 2021-09-13 | Dallas | Alabama | 1047 | 4546 | 173 |
1712671 | 1712671 | 2021-09-13 | DeKalb | Alabama | 1049 | 11568 | 220 |
1712672 | 1712672 | 2021-09-13 | Elmore | Alabama | 1051 | 13694 | 239 |
1712673 | 1712673 | 2021-09-13 | Escambia | Alabama | 1053 | 6228 | 97 |
1712674 | 1712674 | 2021-09-13 | Etowah | Alabama | 1055 | 18201 | 410 |
1712675 | 1712675 | 2021-09-13 | Fayette | Alabama | 1057 | 2662 | 67 |
1712676 | 1712676 | 2021-09-13 | Franklin | Alabama | 1059 | 5539 | 92 |
1712677 | 1712677 | 2021-09-13 | Geneva | Alabama | 1061 | 4089 | 98 |
1712678 | 1712678 | 2021-09-13 | Greene | Alabama | 1063 | 1174 | 41 |
1712679 | 1712679 | 2021-09-13 | Hale | Alabama | 1065 | 2806 | 81 |
1712680 | 1712680 | 2021-09-13 | Henry | Alabama | 1067 | 2854 | 50 |
1712681 | 1712681 | 2021-09-13 | Houston | Alabama | 1069 | 15732 | 331 |
1712682 | 1712682 | 2021-09-13 | Jackson | Alabama | 1071 | 8834 | 132 |
1712683 | 1712683 | 2021-09-13 | Jefferson | Alabama | 1073 | 107467 | 1701 |
1712684 | 1712684 | 2021-09-13 | Lamar | Alabama | 1075 | 1827 | 38 |
1712685 | 1712685 | 2021-09-13 | Lauderdale | Alabama | 1077 | 12734 | 263 |
1712686 | 1712686 | 2021-09-13 | Lawrence | Alabama | 1079 | 3976 | 101 |
1712687 | 1712687 | 2021-09-13 | Lee | Alabama | 1081 | 21353 | 199 |
1712688 | 1712688 | 2021-09-13 | Limestone | Alabama | 1083 | 13682 | 176 |
1712689 | 1712689 | 2021-09-13 | Lowndes | Alabama | 1085 | 1664 | 55 |
1712690 | 1712690 | 2021-09-13 | Macon | Alabama | 1087 | 2091 | 54 |
1712691 | 1712691 | 2021-09-13 | Madison | Alabama | 1089 | 47216 | 560 |
1712692 | 1712692 | 2021-09-13 | Marengo | Alabama | 1091 | 3157 | 76 |
1712693 | 1712693 | 2021-09-13 | Marion | Alabama | 1093 | 4438 | 113 |
1712694 | 1712694 | 2021-09-13 | Marshall | Alabama | 1095 | 16790 | 250 |
1712695 | 1712695 | 2021-09-13 | Mobile | Alabama | 1097 | 69037 | 1126 |
1712696 | 1712696 | 2021-09-13 | Monroe | Alabama | 1099 | 3031 | 44 |
1712697 | 1712697 | 2021-09-13 | Montgomery | Alabama | 1101 | 32012 | 643 |
1712698 | 1712698 | 2021-09-13 | Morgan | Alabama | 1103 | 18881 | 307 |
1712699 | 1712699 | 2021-09-13 | Perry | Alabama | 1105 | 1320 | 30 |
1712700 | 1712700 | 2021-09-13 | Pickens | Alabama | 1107 | 2920 | 65 |
1712701 | 1712701 | 2021-09-13 | Pike | Alabama | 1109 | 4315 | 87 |
1712702 | 1712702 | 2021-09-13 | Randolph | Alabama | 1111 | 2832 | 55 |
1712703 | 1712703 | 2021-09-13 | Russell | Alabama | 1113 | 5821 | 51 |
1712704 | 1712704 | 2021-09-13 | Shelby | Alabama | 1117 | 34429 | 280 |
1712705 | 1712705 | 2021-09-13 | St. Clair | Alabama | 1115 | 14539 | 267 |
1712706 | 1712706 | 2021-09-13 | Sumter | Alabama | 1119 | 1224 | 35 |
1712707 | 1712707 | 2021-09-13 | Talladega | Alabama | 1121 | 11886 | 197 |
1712708 | 1712708 | 2021-09-13 | Tallapoosa | Alabama | 1123 | 6149 | 163 |
1712709 | 1712709 | 2021-09-13 | Tuscaloosa | Alabama | 1125 | 32196 | 491 |
1712710 | 1712710 | 2021-09-13 | Walker | Alabama | 1127 | 9886 | 302 |
1712711 | 1712711 | 2021-09-13 | Washington | Alabama | 1129 | 2392 | 43 |
1712712 | 1712712 | 2021-09-13 | Wilcox | Alabama | 1131 | 1519 | 33 |
1712713 | 1712713 | 2021-09-13 | Winston | Alabama | 1133 | 3937 | 81 |
1709400 | 1709400 | 2021-09-12 | Autauga | Alabama | 1001 | 9287 | 119 |
1709401 | 1709401 | 2021-09-12 | Baldwin | Alabama | 1003 | 34950 | 412 |
1709402 | 1709402 | 2021-09-12 | Barbour | Alabama | 1005 | 3295 | 67 |
1709403 | 1709403 | 2021-09-12 | Bibb | Alabama | 1007 | 3795 | 75 |
1709404 | 1709404 | 2021-09-12 | Blount | Alabama | 1009 | 9176 | 146 |
1709405 | 1709405 | 2021-09-12 | Bullock | Alabama | 1011 | 1441 | 42 |
1709406 | 1709406 | 2021-09-12 | Butler | Alabama | 1013 | 3012 | 77 |
1709407 | 1709407 | 2021-09-12 | Calhoun | Alabama | 1015 | 19273 | 363 |
1709408 | 1709408 | 2021-09-12 | Chambers | Alabama | 1017 | 5062 | 127 |
1709409 | 1709409 | 2021-09-12 | Cherokee | Alabama | 1019 | 2703 | 49 |
1709410 | 1709410 | 2021-09-12 | Chilton | Alabama | 1021 | 6063 | 127 |
1709411 | 1709411 | 2021-09-12 | Choctaw | Alabama | 1023 | 712 | 25 |
1709412 | 1709412 | 2021-09-12 | Clarke | Alabama | 1025 | 4417 | 68 |
1709413 | 1709413 | 2021-09-12 | Clay | Alabama | 1027 | 2148 | 60 |
1709414 | 1709414 | 2021-09-12 | Cleburne | Alabama | 1029 | 2030 | 46 |
1709415 | 1709415 | 2021-09-12 | Coffee | Alabama | 1031 | 8445 | 149 |
1709416 | 1709416 | 2021-09-12 | Colbert | Alabama | 1033 | 8115 | 159 |
1709417 | 1709417 | 2021-09-12 | Conecuh | Alabama | 1035 | 1699 | 37 |
1709418 | 1709418 | 2021-09-12 | Coosa | Alabama | 1037 | 1551 | 31 |
1709419 | 1709419 | 2021-09-12 | Covington | Alabama | 1039 | 6115 | 153 |
1709420 | 1709420 | 2021-09-12 | Crenshaw | Alabama | 1041 | 2239 | 62 |
1709421 | 1709421 | 2021-09-12 | Cullman | Alabama | 1043 | 13465 | 226 |
1709422 | 1709422 | 2021-09-12 | Dale | Alabama | 1045 | 8034 | 141 |
1709423 | 1709423 | 2021-09-12 | Dallas | Alabama | 1047 | 4532 | 173 |
1709424 | 1709424 | 2021-09-12 | DeKalb | Alabama | 1049 | 11550 | 220 |
1709425 | 1709425 | 2021-09-12 | Elmore | Alabama | 1051 | 13636 | 239 |
1709426 | 1709426 | 2021-09-12 | Escambia | Alabama | 1053 | 6202 | 97 |
1709427 | 1709427 | 2021-09-12 | Etowah | Alabama | 1055 | 18169 | 410 |
1709428 | 1709428 | 2021-09-12 | Fayette | Alabama | 1057 | 2648 | 67 |
1709429 | 1709429 | 2021-09-12 | Franklin | Alabama | 1059 | 5532 | 92 |
1709430 | 1709430 | 2021-09-12 | Geneva | Alabama | 1061 | 4075 | 98 |
1709431 | 1709431 | 2021-09-12 | Greene | Alabama | 1063 | 1173 | 41 |
1709432 | 1709432 | 2021-09-12 | Hale | Alabama | 1065 | 2800 | 81 |
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);