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
- Jefferson 589
- Limestone 589
- Montgomery 589
- Tuscaloosa 589
- Elmore 588
- Baldwin 587
- Lee 587
- Shelby 587
- Madison 585
- St. Clair 585
- Talladega 584
- Calhoun 583
- Mobile 583
- Walker 583
- Chambers 582
- Jackson 582
- Lamar 582
- Lauderdale 582
- Washington 582
- Cullman 581
- Marion 581
- Houston 579
- Tallapoosa 579
- Franklin 578
- Morgan 578
- Autauga 577
- Lawrence 577
- Marshall 577
- Pickens 577
- Pike 577
- …
state 1
- Alabama · 38,678 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1839390 | 1839390 | 2021-10-22 | Henry | Alabama | 1067 | 3119 | 66 |
1839391 | 1839391 | 2021-10-22 | Houston | Alabama | 1069 | 17360 | 412 |
1839392 | 1839392 | 2021-10-22 | Jackson | Alabama | 1071 | 9860 | 183 |
1839393 | 1839393 | 2021-10-22 | Jefferson | Alabama | 1073 | 114709 | 1924 |
1839394 | 1839394 | 2021-10-22 | Lamar | Alabama | 1075 | 2233 | 47 |
1839395 | 1839395 | 2021-10-22 | Lauderdale | Alabama | 1077 | 14270 | 295 |
1839396 | 1839396 | 2021-10-22 | Lawrence | Alabama | 1079 | 4309 | 117 |
1839397 | 1839397 | 2021-10-22 | Lee | Alabama | 1081 | 23519 | 246 |
1839398 | 1839398 | 2021-10-22 | Limestone | Alabama | 1083 | 15328 | 199 |
1839399 | 1839399 | 2021-10-22 | Lowndes | Alabama | 1085 | 1747 | 64 |
1839400 | 1839400 | 2021-10-22 | Macon | Alabama | 1087 | 2341 | 63 |
1839401 | 1839401 | 2021-10-22 | Madison | Alabama | 1089 | 52231 | 697 |
1839402 | 1839402 | 2021-10-22 | Marengo | Alabama | 1091 | 3378 | 90 |
1839403 | 1839403 | 2021-10-22 | Marion | Alabama | 1093 | 4995 | 126 |
1839404 | 1839404 | 2021-10-22 | Marshall | Alabama | 1095 | 18338 | 303 |
1839405 | 1839405 | 2021-10-22 | Mobile | Alabama | 1097 | 72497 | 1336 |
1839406 | 1839406 | 2021-10-22 | Monroe | Alabama | 1099 | 3314 | 63 |
1839407 | 1839407 | 2021-10-22 | Montgomery | Alabama | 1101 | 34092 | 739 |
1839408 | 1839408 | 2021-10-22 | Morgan | Alabama | 1103 | 20910 | 378 |
1839409 | 1839409 | 2021-10-22 | Perry | Alabama | 1105 | 1383 | 40 |
1839410 | 1839410 | 2021-10-22 | Pickens | Alabama | 1107 | 3156 | 82 |
1839411 | 1839411 | 2021-10-22 | Pike | Alabama | 1109 | 4791 | 105 |
1839412 | 1839412 | 2021-10-22 | Randolph | Alabama | 1111 | 3298 | 64 |
1839413 | 1839413 | 2021-10-22 | Russell | Alabama | 1113 | 6352 | 59 |
1839414 | 1839414 | 2021-10-22 | Shelby | Alabama | 1117 | 37575 | 349 |
1839415 | 1839415 | 2021-10-22 | St. Clair | Alabama | 1115 | 16034 | 339 |
1839416 | 1839416 | 2021-10-22 | Sumter | Alabama | 1119 | 1329 | 38 |
1839417 | 1839417 | 2021-10-22 | Talladega | Alabama | 1121 | 13827 | 281 |
1839418 | 1839418 | 2021-10-22 | Tallapoosa | Alabama | 1123 | 7079 | 198 |
1839419 | 1839419 | 2021-10-22 | Tuscaloosa | Alabama | 1125 | 35073 | 612 |
1839420 | 1839420 | 2021-10-22 | Walker | Alabama | 1127 | 11180 | 370 |
1839421 | 1839421 | 2021-10-22 | Washington | Alabama | 1129 | 2513 | 51 |
1839422 | 1839422 | 2021-10-22 | Wilcox | Alabama | 1131 | 1687 | 39 |
1839423 | 1839423 | 2021-10-22 | Winston | Alabama | 1133 | 4507 | 103 |
1836108 | 1836108 | 2021-10-21 | Autauga | Alabama | 1001 | 9954 | 146 |
1836109 | 1836109 | 2021-10-21 | Baldwin | Alabama | 1003 | 37192 | 547 |
1836110 | 1836110 | 2021-10-21 | Barbour | Alabama | 1005 | 3566 | 76 |
1836111 | 1836111 | 2021-10-21 | Bibb | Alabama | 1007 | 4240 | 86 |
1836112 | 1836112 | 2021-10-21 | Blount | Alabama | 1009 | 10162 | 175 |
1836113 | 1836113 | 2021-10-21 | Bullock | Alabama | 1011 | 1516 | 44 |
1836114 | 1836114 | 2021-10-21 | Butler | Alabama | 1013 | 3256 | 96 |
1836115 | 1836115 | 2021-10-21 | Calhoun | Alabama | 1015 | 22205 | 476 |
1836116 | 1836116 | 2021-10-21 | Chambers | Alabama | 1017 | 5567 | 142 |
1836117 | 1836117 | 2021-10-21 | Cherokee | Alabama | 1019 | 3017 | 60 |
1836118 | 1836118 | 2021-10-21 | Chilton | Alabama | 1021 | 6627 | 161 |
1836119 | 1836119 | 2021-10-21 | Choctaw | Alabama | 1023 | 881 | 27 |
1836120 | 1836120 | 2021-10-21 | Clarke | Alabama | 1025 | 4745 | 83 |
1836121 | 1836121 | 2021-10-21 | Clay | Alabama | 1027 | 2417 | 68 |
1836122 | 1836122 | 2021-10-21 | Cleburne | Alabama | 1029 | 2473 | 60 |
1836123 | 1836123 | 2021-10-21 | Coffee | Alabama | 1031 | 9195 | 191 |
1836124 | 1836124 | 2021-10-21 | Colbert | Alabama | 1033 | 8826 | 201 |
1836125 | 1836125 | 2021-10-21 | Conecuh | Alabama | 1035 | 1858 | 53 |
1836126 | 1836126 | 2021-10-21 | Coosa | Alabama | 1037 | 1797 | 39 |
1836127 | 1836127 | 2021-10-21 | Covington | Alabama | 1039 | 6699 | 183 |
1836128 | 1836128 | 2021-10-21 | Crenshaw | Alabama | 1041 | 2443 | 75 |
1836129 | 1836129 | 2021-10-21 | Cullman | Alabama | 1043 | 15383 | 292 |
1836130 | 1836130 | 2021-10-21 | Dale | Alabama | 1045 | 8880 | 185 |
1836131 | 1836131 | 2021-10-21 | Dallas | Alabama | 1047 | 4936 | 200 |
1836132 | 1836132 | 2021-10-21 | DeKalb | Alabama | 1049 | 12622 | 260 |
1836133 | 1836133 | 2021-10-21 | Elmore | Alabama | 1051 | 15161 | 284 |
1836134 | 1836134 | 2021-10-21 | Escambia | Alabama | 1053 | 6764 | 130 |
1836135 | 1836135 | 2021-10-21 | Etowah | Alabama | 1055 | 19811 | 497 |
1836136 | 1836136 | 2021-10-21 | Fayette | Alabama | 1057 | 2918 | 79 |
1836137 | 1836137 | 2021-10-21 | Franklin | Alabama | 1059 | 5955 | 105 |
1836138 | 1836138 | 2021-10-21 | Geneva | Alabama | 1061 | 4566 | 126 |
1836139 | 1836139 | 2021-10-21 | Greene | Alabama | 1063 | 1266 | 44 |
1836140 | 1836140 | 2021-10-21 | Hale | Alabama | 1065 | 3110 | 88 |
1836141 | 1836141 | 2021-10-21 | Henry | Alabama | 1067 | 3119 | 65 |
1836142 | 1836142 | 2021-10-21 | Houston | Alabama | 1069 | 17345 | 411 |
1836143 | 1836143 | 2021-10-21 | Jackson | Alabama | 1071 | 9844 | 182 |
1836144 | 1836144 | 2021-10-21 | Jefferson | Alabama | 1073 | 114550 | 1922 |
1836145 | 1836145 | 2021-10-21 | Lamar | Alabama | 1075 | 2220 | 47 |
1836146 | 1836146 | 2021-10-21 | Lauderdale | Alabama | 1077 | 14225 | 294 |
1836147 | 1836147 | 2021-10-21 | Lawrence | Alabama | 1079 | 4296 | 117 |
1836148 | 1836148 | 2021-10-21 | Lee | Alabama | 1081 | 23195 | 245 |
1836149 | 1836149 | 2021-10-21 | Limestone | Alabama | 1083 | 15298 | 198 |
1836150 | 1836150 | 2021-10-21 | Lowndes | Alabama | 1085 | 1745 | 64 |
1836151 | 1836151 | 2021-10-21 | Macon | Alabama | 1087 | 2323 | 63 |
1836152 | 1836152 | 2021-10-21 | Madison | Alabama | 1089 | 52172 | 694 |
1836153 | 1836153 | 2021-10-21 | Marengo | Alabama | 1091 | 3377 | 89 |
1836154 | 1836154 | 2021-10-21 | Marion | Alabama | 1093 | 4982 | 126 |
1836155 | 1836155 | 2021-10-21 | Marshall | Alabama | 1095 | 18317 | 302 |
1836156 | 1836156 | 2021-10-21 | Mobile | Alabama | 1097 | 72460 | 1333 |
1836157 | 1836157 | 2021-10-21 | Monroe | Alabama | 1099 | 3314 | 63 |
1836158 | 1836158 | 2021-10-21 | Montgomery | Alabama | 1101 | 34067 | 734 |
1836159 | 1836159 | 2021-10-21 | Morgan | Alabama | 1103 | 20754 | 376 |
1836160 | 1836160 | 2021-10-21 | Perry | Alabama | 1105 | 1383 | 40 |
1836161 | 1836161 | 2021-10-21 | Pickens | Alabama | 1107 | 3156 | 82 |
1836162 | 1836162 | 2021-10-21 | Pike | Alabama | 1109 | 4722 | 105 |
1836163 | 1836163 | 2021-10-21 | Randolph | Alabama | 1111 | 3287 | 63 |
1836164 | 1836164 | 2021-10-21 | Russell | Alabama | 1113 | 6279 | 59 |
1836165 | 1836165 | 2021-10-21 | Shelby | Alabama | 1117 | 37533 | 348 |
1836166 | 1836166 | 2021-10-21 | St. Clair | Alabama | 1115 | 15983 | 339 |
1836167 | 1836167 | 2021-10-21 | Sumter | Alabama | 1119 | 1327 | 38 |
1836168 | 1836168 | 2021-10-21 | Talladega | Alabama | 1121 | 13802 | 276 |
1836169 | 1836169 | 2021-10-21 | Tallapoosa | Alabama | 1123 | 7071 | 198 |
1836170 | 1836170 | 2021-10-21 | Tuscaloosa | Alabama | 1125 | 35044 | 606 |
1836171 | 1836171 | 2021-10-21 | Walker | Alabama | 1127 | 11162 | 369 |
1836172 | 1836172 | 2021-10-21 | Washington | Alabama | 1129 | 2513 | 51 |
1836173 | 1836173 | 2021-10-21 | Wilcox | Alabama | 1131 | 1679 | 39 |
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);