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 112
- Jefferson 112
- Limestone 112
- Montgomery 112
- Tuscaloosa 112
- Baldwin 111
- Lee 110
- Shelby 110
- Madison 108
- St. Clair 108
- Calhoun 107
- Talladega 107
- Chambers 106
- Mobile 106
- Walker 106
- Cullman 105
- Jackson 105
- Lamar 105
- Lauderdale 105
- Washington 105
- Marion 104
- Franklin 102
- Houston 102
- Tallapoosa 102
- Autauga 101
- Morgan 101
- Blount 100
- Butler 100
- Cherokee 100
- Chilton 100
- …
state 1
- Alabama · 6,752 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
293383 | 293383 | 2020-07-02 | Autauga | Alabama | 1001 | 561 | 13 |
293384 | 293384 | 2020-07-02 | Baldwin | Alabama | 1003 | 751 | 10 |
293385 | 293385 | 2020-07-02 | Barbour | Alabama | 1005 | 335 | 1 |
293386 | 293386 | 2020-07-02 | Bibb | Alabama | 1007 | 179 | 1 |
293387 | 293387 | 2020-07-02 | Blount | Alabama | 1009 | 222 | 1 |
293388 | 293388 | 2020-07-02 | Bullock | Alabama | 1011 | 369 | 10 |
293389 | 293389 | 2020-07-02 | Butler | Alabama | 1013 | 610 | 27 |
293390 | 293390 | 2020-07-02 | Calhoun | Alabama | 1015 | 288 | 5 |
293391 | 293391 | 2020-07-02 | Chambers | Alabama | 1017 | 611 | 27 |
293392 | 293392 | 2020-07-02 | Cherokee | Alabama | 1019 | 82 | 7 |
293393 | 293393 | 2020-07-02 | Chilton | Alabama | 1021 | 222 | 3 |
293394 | 293394 | 2020-07-02 | Choctaw | Alabama | 1023 | 193 | 12 |
293395 | 293395 | 2020-07-02 | Clarke | Alabama | 1025 | 269 | 6 |
293396 | 293396 | 2020-07-02 | Clay | Alabama | 1027 | 61 | 2 |
293397 | 293397 | 2020-07-02 | Cleburne | Alabama | 1029 | 30 | 1 |
293398 | 293398 | 2020-07-02 | Coffee | Alabama | 1031 | 364 | 2 |
293399 | 293399 | 2020-07-02 | Colbert | Alabama | 1033 | 386 | 5 |
293400 | 293400 | 2020-07-02 | Conecuh | Alabama | 1035 | 188 | 6 |
293401 | 293401 | 2020-07-02 | Coosa | Alabama | 1037 | 57 | 1 |
293402 | 293402 | 2020-07-02 | Covington | Alabama | 1039 | 340 | 8 |
293403 | 293403 | 2020-07-02 | Crenshaw | Alabama | 1041 | 128 | 3 |
293404 | 293404 | 2020-07-02 | Cullman | Alabama | 1043 | 422 | 4 |
293405 | 293405 | 2020-07-02 | Dale | Alabama | 1045 | 265 | 0 |
293406 | 293406 | 2020-07-02 | Dallas | Alabama | 1047 | 849 | 9 |
293407 | 293407 | 2020-07-02 | DeKalb | Alabama | 1049 | 650 | 5 |
293408 | 293408 | 2020-07-02 | Elmore | Alabama | 1051 | 849 | 14 |
293409 | 293409 | 2020-07-02 | Escambia | Alabama | 1053 | 293 | 6 |
293410 | 293410 | 2020-07-02 | Etowah | Alabama | 1055 | 653 | 13 |
293411 | 293411 | 2020-07-02 | Fayette | Alabama | 1057 | 70 | 1 |
293412 | 293412 | 2020-07-02 | Franklin | Alabama | 1059 | 867 | 14 |
293413 | 293413 | 2020-07-02 | Geneva | Alabama | 1061 | 70 | 0 |
293414 | 293414 | 2020-07-02 | Greene | Alabama | 1063 | 178 | 8 |
293415 | 293415 | 2020-07-02 | Hale | Alabama | 1065 | 301 | 21 |
293416 | 293416 | 2020-07-02 | Henry | Alabama | 1067 | 131 | 4 |
293417 | 293417 | 2020-07-02 | Houston | Alabama | 1069 | 461 | 6 |
293418 | 293418 | 2020-07-02 | Jackson | Alabama | 1071 | 256 | 3 |
293419 | 293419 | 2020-07-02 | Jefferson | Alabama | 1073 | 4581 | 145 |
293420 | 293420 | 2020-07-02 | Lamar | Alabama | 1075 | 72 | 1 |
293421 | 293421 | 2020-07-02 | Lauderdale | Alabama | 1077 | 459 | 6 |
293422 | 293422 | 2020-07-02 | Lawrence | Alabama | 1079 | 103 | 0 |
293423 | 293423 | 2020-07-02 | Lee | Alabama | 1081 | 1267 | 38 |
293424 | 293424 | 2020-07-02 | Limestone | Alabama | 1083 | 434 | 0 |
293425 | 293425 | 2020-07-02 | Lowndes | Alabama | 1085 | 462 | 21 |
293426 | 293426 | 2020-07-02 | Macon | Alabama | 1087 | 179 | 8 |
293427 | 293427 | 2020-07-02 | Madison | Alabama | 1089 | 1129 | 8 |
293428 | 293428 | 2020-07-02 | Marengo | Alabama | 1091 | 301 | 11 |
293429 | 293429 | 2020-07-02 | Marion | Alabama | 1093 | 210 | 13 |
293430 | 293430 | 2020-07-02 | Marshall | Alabama | 1095 | 1631 | 10 |
293431 | 293431 | 2020-07-02 | Mobile | Alabama | 1097 | 3823 | 138 |
293432 | 293432 | 2020-07-02 | Monroe | Alabama | 1099 | 206 | 2 |
293433 | 293433 | 2020-07-02 | Montgomery | Alabama | 1101 | 3925 | 104 |
293434 | 293434 | 2020-07-02 | Morgan | Alabama | 1103 | 1032 | 3 |
293435 | 293435 | 2020-07-02 | Perry | Alabama | 1105 | 154 | 1 |
293436 | 293436 | 2020-07-02 | Pickens | Alabama | 1107 | 218 | 6 |
293437 | 293437 | 2020-07-02 | Pike | Alabama | 1109 | 415 | 5 |
293438 | 293438 | 2020-07-02 | Randolph | Alabama | 1111 | 190 | 9 |
293439 | 293439 | 2020-07-02 | Russell | Alabama | 1113 | 509 | 0 |
293440 | 293440 | 2020-07-02 | Shelby | Alabama | 1117 | 1128 | 23 |
293441 | 293441 | 2020-07-02 | St. Clair | Alabama | 1115 | 329 | 2 |
293442 | 293442 | 2020-07-02 | Sumter | Alabama | 1119 | 280 | 12 |
293443 | 293443 | 2020-07-02 | Talladega | Alabama | 1121 | 290 | 8 |
293444 | 293444 | 2020-07-02 | Tallapoosa | Alabama | 1123 | 579 | 70 |
293445 | 293445 | 2020-07-02 | Tuscaloosa | Alabama | 1125 | 2129 | 41 |
293446 | 293446 | 2020-07-02 | Walker | Alabama | 1127 | 884 | 23 |
293447 | 293447 | 2020-07-02 | Washington | Alabama | 1129 | 105 | 7 |
293448 | 293448 | 2020-07-02 | Wilcox | Alabama | 1131 | 287 | 8 |
293449 | 293449 | 2020-07-02 | Winston | Alabama | 1133 | 239 | 3 |
290230 | 290230 | 2020-07-01 | Autauga | Alabama | 1001 | 553 | 12 |
290231 | 290231 | 2020-07-01 | Baldwin | Alabama | 1003 | 703 | 10 |
290232 | 290232 | 2020-07-01 | Barbour | Alabama | 1005 | 326 | 1 |
290233 | 290233 | 2020-07-01 | Bibb | Alabama | 1007 | 174 | 1 |
290234 | 290234 | 2020-07-01 | Blount | Alabama | 1009 | 218 | 1 |
290235 | 290235 | 2020-07-01 | Bullock | Alabama | 1011 | 367 | 10 |
290236 | 290236 | 2020-07-01 | Butler | Alabama | 1013 | 607 | 27 |
290237 | 290237 | 2020-07-01 | Calhoun | Alabama | 1015 | 278 | 5 |
290238 | 290238 | 2020-07-01 | Chambers | Alabama | 1017 | 595 | 27 |
290239 | 290239 | 2020-07-01 | Cherokee | Alabama | 1019 | 77 | 7 |
290240 | 290240 | 2020-07-01 | Chilton | Alabama | 1021 | 219 | 3 |
290241 | 290241 | 2020-07-01 | Choctaw | Alabama | 1023 | 193 | 12 |
290242 | 290242 | 2020-07-01 | Clarke | Alabama | 1025 | 267 | 5 |
290243 | 290243 | 2020-07-01 | Clay | Alabama | 1027 | 58 | 2 |
290244 | 290244 | 2020-07-01 | Cleburne | Alabama | 1029 | 29 | 1 |
290245 | 290245 | 2020-07-01 | Coffee | Alabama | 1031 | 358 | 2 |
290246 | 290246 | 2020-07-01 | Colbert | Alabama | 1033 | 377 | 5 |
290247 | 290247 | 2020-07-01 | Conecuh | Alabama | 1035 | 182 | 4 |
290248 | 290248 | 2020-07-01 | Coosa | Alabama | 1037 | 55 | 1 |
290249 | 290249 | 2020-07-01 | Covington | Alabama | 1039 | 317 | 8 |
290250 | 290250 | 2020-07-01 | Crenshaw | Alabama | 1041 | 127 | 3 |
290251 | 290251 | 2020-07-01 | Cullman | Alabama | 1043 | 411 | 3 |
290252 | 290252 | 2020-07-01 | Dale | Alabama | 1045 | 247 | 0 |
290253 | 290253 | 2020-07-01 | Dallas | Alabama | 1047 | 826 | 8 |
290254 | 290254 | 2020-07-01 | DeKalb | Alabama | 1049 | 609 | 5 |
290255 | 290255 | 2020-07-01 | Elmore | Alabama | 1051 | 829 | 14 |
290256 | 290256 | 2020-07-01 | Escambia | Alabama | 1053 | 263 | 6 |
290257 | 290257 | 2020-07-01 | Etowah | Alabama | 1055 | 634 | 13 |
290258 | 290258 | 2020-07-01 | Fayette | Alabama | 1057 | 70 | 1 |
290259 | 290259 | 2020-07-01 | Franklin | Alabama | 1059 | 856 | 13 |
290260 | 290260 | 2020-07-01 | Geneva | Alabama | 1061 | 67 | 0 |
290261 | 290261 | 2020-07-01 | Greene | Alabama | 1063 | 166 | 7 |
290262 | 290262 | 2020-07-01 | Hale | Alabama | 1065 | 298 | 21 |
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);