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 314
- Jefferson 314
- Limestone 314
- Montgomery 314
- Tuscaloosa 314
- Baldwin 313
- Lee 312
- Shelby 312
- Madison 310
- St. Clair 310
- Calhoun 309
- Talladega 309
- Chambers 308
- Mobile 308
- Walker 308
- Cullman 307
- Jackson 307
- Lamar 307
- Lauderdale 307
- Washington 307
- Marion 306
- Franklin 304
- Houston 304
- Tallapoosa 304
- Autauga 303
- Morgan 303
- Blount 302
- Butler 302
- Cherokee 302
- Chilton 302
- …
state 1
- Alabama · 20,286 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
946401 | 946401 | 2021-01-20 | Autauga | Alabama | 1001 | 5257 | 55 |
946402 | 946402 | 2021-01-20 | Baldwin | Alabama | 1003 | 16653 | 184 |
946403 | 946403 | 2021-01-20 | Barbour | Alabama | 1005 | 1760 | 36 |
946404 | 946404 | 2021-01-20 | Bibb | Alabama | 1007 | 2188 | 47 |
946405 | 946405 | 2021-01-20 | Blount | Alabama | 1009 | 5376 | 83 |
946406 | 946406 | 2021-01-20 | Bullock | Alabama | 1011 | 1011 | 28 |
946407 | 946407 | 2021-01-20 | Butler | Alabama | 1013 | 1708 | 58 |
946408 | 946408 | 2021-01-20 | Calhoun | Alabama | 1015 | 11292 | 201 |
946409 | 946409 | 2021-01-20 | Chambers | Alabama | 1017 | 2931 | 70 |
946410 | 946410 | 2021-01-20 | Cherokee | Alabama | 1019 | 1619 | 30 |
946411 | 946411 | 2021-01-20 | Chilton | Alabama | 1021 | 3389 | 66 |
946412 | 946412 | 2021-01-20 | Choctaw | Alabama | 1023 | 516 | 24 |
946413 | 946413 | 2021-01-20 | Clarke | Alabama | 1025 | 2878 | 33 |
946414 | 946414 | 2021-01-20 | Clay | Alabama | 1027 | 1276 | 45 |
946415 | 946415 | 2021-01-20 | Cleburne | Alabama | 1029 | 1190 | 23 |
946416 | 946416 | 2021-01-20 | Coffee | Alabama | 1031 | 4504 | 56 |
946417 | 946417 | 2021-01-20 | Colbert | Alabama | 1033 | 5398 | 73 |
946418 | 946418 | 2021-01-20 | Conecuh | Alabama | 1035 | 957 | 20 |
946419 | 946419 | 2021-01-20 | Coosa | Alabama | 1037 | 610 | 15 |
946420 | 946420 | 2021-01-20 | Covington | Alabama | 1039 | 3326 | 68 |
946421 | 946421 | 2021-01-20 | Crenshaw | Alabama | 1041 | 1215 | 44 |
946422 | 946422 | 2021-01-20 | Cullman | Alabama | 1043 | 8125 | 106 |
946423 | 946423 | 2021-01-20 | Dale | Alabama | 1045 | 4029 | 81 |
946424 | 946424 | 2021-01-20 | Dallas | Alabama | 1047 | 3088 | 96 |
946425 | 946425 | 2021-01-20 | DeKalb | Alabama | 1049 | 7765 | 99 |
946426 | 946426 | 2021-01-20 | Elmore | Alabama | 1051 | 7999 | 104 |
946427 | 946427 | 2021-01-20 | Escambia | Alabama | 1053 | 3260 | 43 |
946428 | 946428 | 2021-01-20 | Etowah | Alabama | 1055 | 11861 | 176 |
946429 | 946429 | 2021-01-20 | Fayette | Alabama | 1057 | 1729 | 28 |
946430 | 946430 | 2021-01-20 | Franklin | Alabama | 1059 | 3699 | 48 |
946431 | 946431 | 2021-01-20 | Geneva | Alabama | 1061 | 2054 | 46 |
946432 | 946432 | 2021-01-20 | Greene | Alabama | 1063 | 766 | 23 |
946433 | 946433 | 2021-01-20 | Hale | Alabama | 1065 | 1795 | 42 |
946434 | 946434 | 2021-01-20 | Henry | Alabama | 1067 | 1565 | 23 |
946435 | 946435 | 2021-01-20 | Houston | Alabama | 1069 | 8746 | 156 |
946436 | 946436 | 2021-01-20 | Jackson | Alabama | 1071 | 5863 | 41 |
946437 | 946437 | 2021-01-20 | Jefferson | Alabama | 1073 | 63040 | 956 |
946438 | 946438 | 2021-01-20 | Lamar | Alabama | 1075 | 1190 | 21 |
946439 | 946439 | 2021-01-20 | Lauderdale | Alabama | 1077 | 7686 | 98 |
946440 | 946440 | 2021-01-20 | Lawrence | Alabama | 1079 | 2466 | 49 |
946441 | 946441 | 2021-01-20 | Lee | Alabama | 1081 | 12749 | 102 |
946442 | 946442 | 2021-01-20 | Limestone | Alabama | 1083 | 8132 | 76 |
946443 | 946443 | 2021-01-20 | Lowndes | Alabama | 1085 | 1120 | 36 |
946444 | 946444 | 2021-01-20 | Macon | Alabama | 1087 | 1186 | 37 |
946445 | 946445 | 2021-01-20 | Madison | Alabama | 1089 | 27486 | 201 |
946446 | 946446 | 2021-01-20 | Marengo | Alabama | 1091 | 2028 | 29 |
946447 | 946447 | 2021-01-20 | Marion | Alabama | 1093 | 2489 | 53 |
946448 | 946448 | 2021-01-20 | Marshall | Alabama | 1095 | 10290 | 113 |
946449 | 946449 | 2021-01-20 | Mobile | Alabama | 1097 | 30794 | 557 |
946450 | 946450 | 2021-01-20 | Monroe | Alabama | 1099 | 1498 | 18 |
946451 | 946451 | 2021-01-20 | Montgomery | Alabama | 1101 | 19352 | 315 |
946452 | 946452 | 2021-01-20 | Morgan | Alabama | 1103 | 12389 | 119 |
946453 | 946453 | 2021-01-20 | Perry | Alabama | 1105 | 990 | 19 |
946454 | 946454 | 2021-01-20 | Pickens | Alabama | 1107 | 1975 | 31 |
946455 | 946455 | 2021-01-20 | Pike | Alabama | 1109 | 2552 | 30 |
946456 | 946456 | 2021-01-20 | Randolph | Alabama | 1111 | 1421 | 35 |
946457 | 946457 | 2021-01-20 | Russell | Alabama | 1113 | 3407 | 11 |
946458 | 946458 | 2021-01-20 | Shelby | Alabama | 1117 | 18833 | 120 |
946459 | 946459 | 2021-01-20 | St. Clair | Alabama | 1115 | 7651 | 121 |
946460 | 946460 | 2021-01-20 | Sumter | Alabama | 1119 | 896 | 26 |
946461 | 946461 | 2021-01-20 | Talladega | Alabama | 1121 | 6309 | 108 |
946462 | 946462 | 2021-01-20 | Tallapoosa | Alabama | 1123 | 2641 | 107 |
946463 | 946463 | 2021-01-20 | Tuscaloosa | Alabama | 1125 | 20996 | 268 |
946464 | 946464 | 2021-01-20 | Walker | Alabama | 1127 | 5954 | 174 |
946465 | 946465 | 2021-01-20 | Washington | Alabama | 1129 | 1391 | 26 |
946466 | 946466 | 2021-01-20 | Wilcox | Alabama | 1131 | 1051 | 21 |
946467 | 946467 | 2021-01-20 | Winston | Alabama | 1133 | 2295 | 35 |
943154 | 943154 | 2021-01-19 | Autauga | Alabama | 1001 | 5227 | 55 |
943155 | 943155 | 2021-01-19 | Baldwin | Alabama | 1003 | 16513 | 183 |
943156 | 943156 | 2021-01-19 | Barbour | Alabama | 1005 | 1738 | 36 |
943157 | 943157 | 2021-01-19 | Bibb | Alabama | 1007 | 2170 | 47 |
943158 | 943158 | 2021-01-19 | Blount | Alabama | 1009 | 5320 | 83 |
943159 | 943159 | 2021-01-19 | Bullock | Alabama | 1011 | 997 | 28 |
943160 | 943160 | 2021-01-19 | Butler | Alabama | 1013 | 1707 | 58 |
943161 | 943161 | 2021-01-19 | Calhoun | Alabama | 1015 | 11206 | 200 |
943162 | 943162 | 2021-01-19 | Chambers | Alabama | 1017 | 2886 | 69 |
943163 | 943163 | 2021-01-19 | Cherokee | Alabama | 1019 | 1609 | 30 |
943164 | 943164 | 2021-01-19 | Chilton | Alabama | 1021 | 3378 | 65 |
943165 | 943165 | 2021-01-19 | Choctaw | Alabama | 1023 | 515 | 24 |
943166 | 943166 | 2021-01-19 | Clarke | Alabama | 1025 | 2831 | 33 |
943167 | 943167 | 2021-01-19 | Clay | Alabama | 1027 | 1270 | 45 |
943168 | 943168 | 2021-01-19 | Cleburne | Alabama | 1029 | 1184 | 23 |
943169 | 943169 | 2021-01-19 | Coffee | Alabama | 1031 | 4462 | 56 |
943170 | 943170 | 2021-01-19 | Colbert | Alabama | 1033 | 5354 | 73 |
943171 | 943171 | 2021-01-19 | Conecuh | Alabama | 1035 | 951 | 20 |
943172 | 943172 | 2021-01-19 | Coosa | Alabama | 1037 | 605 | 15 |
943173 | 943173 | 2021-01-19 | Covington | Alabama | 1039 | 3301 | 68 |
943174 | 943174 | 2021-01-19 | Crenshaw | Alabama | 1041 | 1202 | 44 |
943175 | 943175 | 2021-01-19 | Cullman | Alabama | 1043 | 8094 | 105 |
943176 | 943176 | 2021-01-19 | Dale | Alabama | 1045 | 3997 | 81 |
943177 | 943177 | 2021-01-19 | Dallas | Alabama | 1047 | 3051 | 96 |
943178 | 943178 | 2021-01-19 | DeKalb | Alabama | 1049 | 7715 | 97 |
943179 | 943179 | 2021-01-19 | Elmore | Alabama | 1051 | 7923 | 101 |
943180 | 943180 | 2021-01-19 | Escambia | Alabama | 1053 | 3213 | 42 |
943181 | 943181 | 2021-01-19 | Etowah | Alabama | 1055 | 11805 | 168 |
943182 | 943182 | 2021-01-19 | Fayette | Alabama | 1057 | 1712 | 26 |
943183 | 943183 | 2021-01-19 | Franklin | Alabama | 1059 | 3681 | 48 |
943184 | 943184 | 2021-01-19 | Geneva | Alabama | 1061 | 2033 | 35 |
943185 | 943185 | 2021-01-19 | Greene | Alabama | 1063 | 762 | 23 |
943186 | 943186 | 2021-01-19 | Hale | Alabama | 1065 | 1774 | 42 |
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);