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
- 1073 791
- 1083 791
- 1101 791
- 1125 791
- 1051 790
- 1003 789
- 1081 789
- 1117 789
- 1089 787
- 1115 787
- 1121 786
- 1015 785
- 1097 785
- 1127 785
- 1017 784
- 1071 784
- 1075 784
- 1077 784
- 1129 784
- 1043 783
- 1093 783
- 1069 781
- 1123 781
- 1059 780
- 1103 780
- 1001 779
- 1079 779
- 1095 779
- 1107 779
- 1109 779
- 1113 779
- 1131 779
- 1009 778
- 1013 778
- 1019 778
- 1021 778
- 1027 778
- 1029 778
- 1033 778
- 1047 778
- 1055 778
- 1085 778
- 1091 778
- 1011 777
- 1023 777
- 1037 777
- 1041 777
- 1049 777
- 1111 777
- 1133 777
- 1039 776
- 1053 776
- 1063 776
- 1099 776
- 1087 775
- 1119 774
- 1007 773
- 1057 773
- 1065 773
- 1025 771
- 1035 771
- 1045 771
- 1031 770
- 1067 770
- 1005 769
- 1105 764
- 1061 760
county 67
- Jefferson 791
- Limestone 791
- Montgomery 791
- Tuscaloosa 791
- Elmore 790
- Baldwin 789
- Lee 789
- Shelby 789
- Madison 787
- St. Clair 787
- Talladega 786
- Calhoun 785
- Mobile 785
- Walker 785
- Chambers 784
- Jackson 784
- Lamar 784
- Lauderdale 784
- Washington 784
- Cullman 783
- Marion 783
- Houston 781
- Tallapoosa 781
- Franklin 780
- Morgan 780
- Autauga 779
- Lawrence 779
- Marshall 779
- Pickens 779
- Pike 779
- Russell 779
- Wilcox 779
- Blount 778
- Butler 778
- Cherokee 778
- Chilton 778
- Clay 778
- Cleburne 778
- Colbert 778
- Dallas 778
- Etowah 778
- Lowndes 778
- Marengo 778
- Bullock 777
- Choctaw 777
- Coosa 777
- Crenshaw 777
- DeKalb 777
- Randolph 777
- Winston 777
- Covington 776
- Escambia 776
- Greene 776
- Monroe 776
- Macon 775
- Sumter 774
- Bibb 773
- Fayette 773
- Hale 773
- Clarke 771
- Conecuh 771
- Dale 771
- Coffee 770
- Henry 770
- Barbour 769
- Perry 764
- Geneva 760
state 1
- Alabama · 52,212 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496350 | 2496350 | 2022-05-12 | Henry | Alabama | 1067 | 4582 | 76 |
2496351 | 2496351 | 2022-05-12 | Houston | Alabama | 1069 | 25795 | 506 |
2496352 | 2496352 | 2022-05-12 | Jackson | Alabama | 1071 | 15049 | 241 |
2496353 | 2496353 | 2022-05-12 | Jefferson | Alabama | 1073 | 185846 | 2373 |
2496354 | 2496354 | 2022-05-12 | Lamar | Alabama | 1075 | 3745 | 65 |
2496355 | 2496355 | 2022-05-12 | Lauderdale | Alabama | 1077 | 24187 | 397 |
2496356 | 2496356 | 2022-05-12 | Lawrence | Alabama | 1079 | 7681 | 160 |
2496357 | 2496357 | 2022-05-12 | Lee | Alabama | 1081 | 37876 | 341 |
2496358 | 2496358 | 2022-05-12 | Limestone | Alabama | 1083 | 25053 | 292 |
2496359 | 2496359 | 2022-05-12 | Lowndes | Alabama | 1085 | 2628 | 77 |
2496360 | 2496360 | 2022-05-12 | Macon | Alabama | 1087 | 3882 | 85 |
2496361 | 2496361 | 2022-05-12 | Madison | Alabama | 1089 | 90339 | 967 |
2496362 | 2496362 | 2022-05-12 | Marengo | Alabama | 1091 | 5195 | 108 |
2496363 | 2496363 | 2022-05-12 | Marion | Alabama | 1093 | 8153 | 152 |
2496364 | 2496364 | 2022-05-12 | Marshall | Alabama | 1095 | 27430 | 394 |
2496365 | 2496365 | 2022-05-12 | Mobile | Alabama | 1097 | 113283 | 1653 |
2496366 | 2496366 | 2022-05-12 | Monroe | Alabama | 1099 | 5276 | 80 |
2496367 | 2496367 | 2022-05-12 | Montgomery | Alabama | 1101 | 55297 | 948 |
2496368 | 2496368 | 2022-05-12 | Morgan | Alabama | 1103 | 36154 | 517 |
2496369 | 2496369 | 2022-05-12 | Perry | Alabama | 1105 | 2096 | 47 |
2496370 | 2496370 | 2022-05-12 | Pickens | Alabama | 1107 | 5269 | 102 |
2496371 | 2496371 | 2022-05-12 | Pike | Alabama | 1109 | 7587 | 134 |
2496372 | 2496372 | 2022-05-12 | Randolph | Alabama | 1111 | 5085 | 75 |
2496373 | 2496373 | 2022-05-12 | Russell | Alabama | 1113 | 10111 | 93 |
2496374 | 2496374 | 2022-05-12 | Shelby | Alabama | 1117 | 61246 | 452 |
2496375 | 2496375 | 2022-05-12 | St. Clair | Alabama | 1115 | 25385 | 416 |
2496376 | 2496376 | 2022-05-12 | Sumter | Alabama | 1119 | 2590 | 51 |
2496377 | 2496377 | 2022-05-12 | Talladega | Alabama | 1121 | 22389 | 377 |
2496378 | 2496378 | 2022-05-12 | Tallapoosa | Alabama | 1123 | 11443 | 234 |
2496379 | 2496379 | 2022-05-12 | Tuscaloosa | Alabama | 1125 | 56284 | 786 |
2496380 | 2496380 | 2022-05-12 | Walker | Alabama | 1127 | 18763 | 447 |
2496381 | 2496381 | 2022-05-12 | Washington | Alabama | 1129 | 3735 | 59 |
2496382 | 2496382 | 2022-05-12 | Wilcox | Alabama | 1131 | 2892 | 46 |
2496383 | 2496383 | 2022-05-12 | Winston | Alabama | 1133 | 7575 | 131 |
2493059 | 2493059 | 2022-05-11 | Autauga | Alabama | 1001 | 15853 | 216 |
2493060 | 2493060 | 2022-05-11 | Baldwin | Alabama | 1003 | 55807 | 680 |
2493061 | 2493061 | 2022-05-11 | Barbour | Alabama | 1005 | 5677 | 98 |
2493062 | 2493062 | 2022-05-11 | Bibb | Alabama | 1007 | 6453 | 104 |
2493063 | 2493063 | 2022-05-11 | Blount | Alabama | 1009 | 14999 | 243 |
2493064 | 2493064 | 2022-05-11 | Bullock | Alabama | 1011 | 2318 | 54 |
2493065 | 2493065 | 2022-05-11 | Butler | Alabama | 1013 | 5068 | 129 |
2493066 | 2493066 | 2022-05-11 | Calhoun | Alabama | 1015 | 32443 | 626 |
2493067 | 2493067 | 2022-05-11 | Chambers | Alabama | 1017 | 8505 | 162 |
2493068 | 2493068 | 2022-05-11 | Cherokee | Alabama | 1019 | 5134 | 86 |
2493069 | 2493069 | 2022-05-11 | Chilton | Alabama | 1021 | 11128 | 207 |
2493070 | 2493070 | 2022-05-11 | Choctaw | Alabama | 1023 | 2050 | 36 |
2493071 | 2493071 | 2022-05-11 | Clarke | Alabama | 1025 | 7151 | 101 |
2493072 | 2493072 | 2022-05-11 | Clay | Alabama | 1027 | 4092 | 82 |
2493073 | 2493073 | 2022-05-11 | Cleburne | Alabama | 1029 | 3562 | 69 |
2493074 | 2493074 | 2022-05-11 | Coffee | Alabama | 1031 | 13632 | 231 |
2493075 | 2493075 | 2022-05-11 | Colbert | Alabama | 1033 | 16353 | 260 |
2493076 | 2493076 | 2022-05-11 | Conecuh | Alabama | 1035 | 2868 | 70 |
2493077 | 2493077 | 2022-05-11 | Coosa | Alabama | 1037 | 2974 | 58 |
2493078 | 2493078 | 2022-05-11 | Covington | Alabama | 1039 | 9355 | 232 |
2493079 | 2493079 | 2022-05-11 | Crenshaw | Alabama | 1041 | 3834 | 99 |
2493080 | 2493080 | 2022-05-11 | Cullman | Alabama | 1043 | 24639 | 367 |
2493081 | 2493081 | 2022-05-11 | Dale | Alabama | 1045 | 12930 | 231 |
2493082 | 2493082 | 2022-05-11 | Dallas | Alabama | 1047 | 8428 | 244 |
2493083 | 2493083 | 2022-05-11 | DeKalb | Alabama | 1049 | 18787 | 328 |
2493084 | 2493084 | 2022-05-11 | Elmore | Alabama | 1051 | 23410 | 347 |
2493085 | 2493085 | 2022-05-11 | Escambia | Alabama | 1053 | 10072 | 170 |
2493086 | 2493086 | 2022-05-11 | Etowah | Alabama | 1055 | 28777 | 651 |
2493087 | 2493087 | 2022-05-11 | Fayette | Alabama | 1057 | 4983 | 96 |
2493088 | 2493088 | 2022-05-11 | Franklin | Alabama | 1059 | 9900 | 139 |
2493089 | 2493089 | 2022-05-11 | Geneva | Alabama | 1061 | 6490 | 164 |
2493090 | 2493090 | 2022-05-11 | Greene | Alabama | 1063 | 1876 | 49 |
2493091 | 2493091 | 2022-05-11 | Hale | Alabama | 1065 | 4741 | 106 |
2493092 | 2493092 | 2022-05-11 | Henry | Alabama | 1067 | 4581 | 76 |
2493093 | 2493093 | 2022-05-11 | Houston | Alabama | 1069 | 25781 | 506 |
2493094 | 2493094 | 2022-05-11 | Jackson | Alabama | 1071 | 15048 | 241 |
2493095 | 2493095 | 2022-05-11 | Jefferson | Alabama | 1073 | 185752 | 2373 |
2493096 | 2493096 | 2022-05-11 | Lamar | Alabama | 1075 | 3745 | 65 |
2493097 | 2493097 | 2022-05-11 | Lauderdale | Alabama | 1077 | 24181 | 396 |
2493098 | 2493098 | 2022-05-11 | Lawrence | Alabama | 1079 | 7680 | 159 |
2493099 | 2493099 | 2022-05-11 | Lee | Alabama | 1081 | 37858 | 341 |
2493100 | 2493100 | 2022-05-11 | Limestone | Alabama | 1083 | 25040 | 292 |
2493101 | 2493101 | 2022-05-11 | Lowndes | Alabama | 1085 | 2628 | 77 |
2493102 | 2493102 | 2022-05-11 | Macon | Alabama | 1087 | 3881 | 84 |
2493103 | 2493103 | 2022-05-11 | Madison | Alabama | 1089 | 90260 | 966 |
2493104 | 2493104 | 2022-05-11 | Marengo | Alabama | 1091 | 5194 | 108 |
2493105 | 2493105 | 2022-05-11 | Marion | Alabama | 1093 | 8151 | 152 |
2493106 | 2493106 | 2022-05-11 | Marshall | Alabama | 1095 | 27418 | 393 |
2493107 | 2493107 | 2022-05-11 | Mobile | Alabama | 1097 | 113279 | 1651 |
2493108 | 2493108 | 2022-05-11 | Monroe | Alabama | 1099 | 5276 | 80 |
2493109 | 2493109 | 2022-05-11 | Montgomery | Alabama | 1101 | 55266 | 948 |
2493110 | 2493110 | 2022-05-11 | Morgan | Alabama | 1103 | 36150 | 516 |
2493111 | 2493111 | 2022-05-11 | Perry | Alabama | 1105 | 2096 | 47 |
2493112 | 2493112 | 2022-05-11 | Pickens | Alabama | 1107 | 5267 | 102 |
2493113 | 2493113 | 2022-05-11 | Pike | Alabama | 1109 | 7583 | 134 |
2493114 | 2493114 | 2022-05-11 | Randolph | Alabama | 1111 | 5089 | 75 |
2493115 | 2493115 | 2022-05-11 | Russell | Alabama | 1113 | 10109 | 93 |
2493116 | 2493116 | 2022-05-11 | Shelby | Alabama | 1117 | 61218 | 451 |
2493117 | 2493117 | 2022-05-11 | St. Clair | Alabama | 1115 | 25379 | 416 |
2493118 | 2493118 | 2022-05-11 | Sumter | Alabama | 1119 | 2590 | 51 |
2493119 | 2493119 | 2022-05-11 | Talladega | Alabama | 1121 | 22381 | 376 |
2493120 | 2493120 | 2022-05-11 | Tallapoosa | Alabama | 1123 | 11439 | 234 |
2493121 | 2493121 | 2022-05-11 | Tuscaloosa | Alabama | 1125 | 56268 | 786 |
2493122 | 2493122 | 2022-05-11 | Walker | Alabama | 1127 | 18758 | 446 |
2493123 | 2493123 | 2022-05-11 | Washington | Alabama | 1129 | 3735 | 59 |
2493124 | 2493124 | 2022-05-11 | Wilcox | Alabama | 1131 | 2891 | 46 |
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);