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 302
- Jefferson 302
- Limestone 302
- Montgomery 302
- Tuscaloosa 302
- Baldwin 301
- Lee 300
- Shelby 300
- Madison 298
- St. Clair 298
- Calhoun 297
- Talladega 297
- Chambers 296
- Mobile 296
- Walker 296
- Cullman 295
- Jackson 295
- Lamar 295
- Lauderdale 295
- Washington 295
- Marion 294
- Franklin 292
- Houston 292
- Tallapoosa 292
- Autauga 291
- Morgan 291
- Blount 290
- Butler 290
- Cherokee 290
- Chilton 290
- …
state 1
- Alabama · 19,483 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
910769 | 910769 | 2021-01-09 | Winston | Alabama | 1133 | 2175 | 34 |
907458 | 907458 | 2021-01-08 | Autauga | Alabama | 1001 | 4770 | 50 |
907459 | 907459 | 2021-01-08 | Baldwin | Alabama | 1003 | 15052 | 171 |
907460 | 907460 | 2021-01-08 | Barbour | Alabama | 1005 | 1634 | 35 |
907461 | 907461 | 2021-01-08 | Bibb | Alabama | 1007 | 2015 | 48 |
907462 | 907462 | 2021-01-08 | Blount | Alabama | 1009 | 5018 | 75 |
907463 | 907463 | 2021-01-08 | Bullock | Alabama | 1011 | 949 | 28 |
907464 | 907464 | 2021-01-08 | Butler | Alabama | 1013 | 1610 | 46 |
907465 | 907465 | 2021-01-08 | Calhoun | Alabama | 1015 | 10372 | 159 |
907466 | 907466 | 2021-01-08 | Chambers | Alabama | 1017 | 2592 | 63 |
907467 | 907467 | 2021-01-08 | Cherokee | Alabama | 1019 | 1517 | 24 |
907468 | 907468 | 2021-01-08 | Chilton | Alabama | 1021 | 3218 | 54 |
907469 | 907469 | 2021-01-08 | Choctaw | Alabama | 1023 | 498 | 22 |
907470 | 907470 | 2021-01-08 | Clarke | Alabama | 1025 | 2575 | 26 |
907471 | 907471 | 2021-01-08 | Clay | Alabama | 1027 | 1211 | 35 |
907472 | 907472 | 2021-01-08 | Cleburne | Alabama | 1029 | 1107 | 17 |
907473 | 907473 | 2021-01-08 | Coffee | Alabama | 1031 | 4046 | 42 |
907474 | 907474 | 2021-01-08 | Colbert | Alabama | 1033 | 4958 | 61 |
907475 | 907475 | 2021-01-08 | Conecuh | Alabama | 1035 | 888 | 17 |
907476 | 907476 | 2021-01-08 | Coosa | Alabama | 1037 | 571 | 7 |
907477 | 907477 | 2021-01-08 | Covington | Alabama | 1039 | 3110 | 43 |
907478 | 907478 | 2021-01-08 | Crenshaw | Alabama | 1041 | 1108 | 36 |
907479 | 907479 | 2021-01-08 | Cullman | Alabama | 1043 | 7613 | 78 |
907480 | 907480 | 2021-01-08 | Dale | Alabama | 1045 | 3636 | 64 |
907481 | 907481 | 2021-01-08 | Dallas | Alabama | 1047 | 2908 | 45 |
907482 | 907482 | 2021-01-08 | DeKalb | Alabama | 1049 | 7271 | 62 |
907483 | 907483 | 2021-01-08 | Elmore | Alabama | 1051 | 7238 | 85 |
907484 | 907484 | 2021-01-08 | Escambia | Alabama | 1053 | 2893 | 34 |
907485 | 907485 | 2021-01-08 | Etowah | Alabama | 1055 | 10854 | 105 |
907486 | 907486 | 2021-01-08 | Fayette | Alabama | 1057 | 1534 | 21 |
907487 | 907487 | 2021-01-08 | Franklin | Alabama | 1059 | 3462 | 39 |
907488 | 907488 | 2021-01-08 | Geneva | Alabama | 1061 | 1858 | 23 |
907489 | 907489 | 2021-01-08 | Greene | Alabama | 1063 | 723 | 20 |
907490 | 907490 | 2021-01-08 | Hale | Alabama | 1065 | 1622 | 41 |
907491 | 907491 | 2021-01-08 | Henry | Alabama | 1067 | 1407 | 9 |
907492 | 907492 | 2021-01-08 | Houston | Alabama | 1069 | 8013 | 72 |
907493 | 907493 | 2021-01-08 | Jackson | Alabama | 1071 | 5495 | 34 |
907494 | 907494 | 2021-01-08 | Jefferson | Alabama | 1073 | 57609 | 776 |
907495 | 907495 | 2021-01-08 | Lamar | Alabama | 1075 | 1124 | 16 |
907496 | 907496 | 2021-01-08 | Lauderdale | Alabama | 1077 | 7051 | 71 |
907497 | 907497 | 2021-01-08 | Lawrence | Alabama | 1079 | 2263 | 44 |
907498 | 907498 | 2021-01-08 | Lee | Alabama | 1081 | 11355 | 79 |
907499 | 907499 | 2021-01-08 | Limestone | Alabama | 1083 | 7426 | 60 |
907500 | 907500 | 2021-01-08 | Lowndes | Alabama | 1085 | 1037 | 34 |
907501 | 907501 | 2021-01-08 | Macon | Alabama | 1087 | 1073 | 35 |
907502 | 907502 | 2021-01-08 | Madison | Alabama | 1089 | 24795 | 179 |
907503 | 907503 | 2021-01-08 | Marengo | Alabama | 1091 | 1910 | 27 |
907504 | 907504 | 2021-01-08 | Marion | Alabama | 1093 | 2281 | 46 |
907505 | 907505 | 2021-01-08 | Marshall | Alabama | 1095 | 9710 | 92 |
907506 | 907506 | 2021-01-08 | Mobile | Alabama | 1097 | 28034 | 521 |
907507 | 907507 | 2021-01-08 | Monroe | Alabama | 1099 | 1355 | 12 |
907508 | 907508 | 2021-01-08 | Montgomery | Alabama | 1101 | 17723 | 282 |
907509 | 907509 | 2021-01-08 | Morgan | Alabama | 1103 | 11485 | 103 |
907510 | 907510 | 2021-01-08 | Perry | Alabama | 1105 | 914 | 19 |
907511 | 907511 | 2021-01-08 | Pickens | Alabama | 1107 | 1854 | 31 |
907512 | 907512 | 2021-01-08 | Pike | Alabama | 1109 | 2281 | 23 |
907513 | 907513 | 2021-01-08 | Randolph | Alabama | 1111 | 1328 | 32 |
907514 | 907514 | 2021-01-08 | Russell | Alabama | 1113 | 3013 | 7 |
907515 | 907515 | 2021-01-08 | Shelby | Alabama | 1117 | 17253 | 105 |
907516 | 907516 | 2021-01-08 | St. Clair | Alabama | 1115 | 7055 | 74 |
907517 | 907517 | 2021-01-08 | Sumter | Alabama | 1119 | 885 | 24 |
907518 | 907518 | 2021-01-08 | Talladega | Alabama | 1121 | 5689 | 84 |
907519 | 907519 | 2021-01-08 | Tallapoosa | Alabama | 1123 | 2531 | 107 |
907520 | 907520 | 2021-01-08 | Tuscaloosa | Alabama | 1125 | 19878 | 267 |
907521 | 907521 | 2021-01-08 | Walker | Alabama | 1127 | 5648 | 170 |
907522 | 907522 | 2021-01-08 | Washington | Alabama | 1129 | 1305 | 26 |
907523 | 907523 | 2021-01-08 | Wilcox | Alabama | 1131 | 939 | 20 |
907524 | 907524 | 2021-01-08 | Winston | Alabama | 1133 | 2137 | 34 |
904212 | 904212 | 2021-01-07 | Autauga | Alabama | 1001 | 4705 | 50 |
904213 | 904213 | 2021-01-07 | Baldwin | Alabama | 1003 | 14845 | 171 |
904214 | 904214 | 2021-01-07 | Barbour | Alabama | 1005 | 1614 | 35 |
904215 | 904215 | 2021-01-07 | Bibb | Alabama | 1007 | 1981 | 48 |
904216 | 904216 | 2021-01-07 | Blount | Alabama | 1009 | 4957 | 72 |
904217 | 904217 | 2021-01-07 | Bullock | Alabama | 1011 | 927 | 22 |
904218 | 904218 | 2021-01-07 | Butler | Alabama | 1013 | 1598 | 46 |
904219 | 904219 | 2021-01-07 | Calhoun | Alabama | 1015 | 10283 | 158 |
904220 | 904220 | 2021-01-07 | Chambers | Alabama | 1017 | 2552 | 63 |
904221 | 904221 | 2021-01-07 | Cherokee | Alabama | 1019 | 1496 | 25 |
904222 | 904222 | 2021-01-07 | Chilton | Alabama | 1021 | 3159 | 54 |
904223 | 904223 | 2021-01-07 | Choctaw | Alabama | 1023 | 496 | 22 |
904224 | 904224 | 2021-01-07 | Clarke | Alabama | 1025 | 2550 | 26 |
904225 | 904225 | 2021-01-07 | Clay | Alabama | 1027 | 1196 | 34 |
904226 | 904226 | 2021-01-07 | Cleburne | Alabama | 1029 | 1089 | 17 |
904227 | 904227 | 2021-01-07 | Coffee | Alabama | 1031 | 3934 | 42 |
904228 | 904228 | 2021-01-07 | Colbert | Alabama | 1033 | 4911 | 62 |
904229 | 904229 | 2021-01-07 | Conecuh | Alabama | 1035 | 884 | 17 |
904230 | 904230 | 2021-01-07 | Coosa | Alabama | 1037 | 563 | 7 |
904231 | 904231 | 2021-01-07 | Covington | Alabama | 1039 | 3073 | 43 |
904232 | 904232 | 2021-01-07 | Crenshaw | Alabama | 1041 | 1082 | 36 |
904233 | 904233 | 2021-01-07 | Cullman | Alabama | 1043 | 7538 | 78 |
904234 | 904234 | 2021-01-07 | Dale | Alabama | 1045 | 3583 | 64 |
904235 | 904235 | 2021-01-07 | Dallas | Alabama | 1047 | 2898 | 45 |
904236 | 904236 | 2021-01-07 | DeKalb | Alabama | 1049 | 7223 | 62 |
904237 | 904237 | 2021-01-07 | Elmore | Alabama | 1051 | 7156 | 85 |
904238 | 904238 | 2021-01-07 | Escambia | Alabama | 1053 | 2858 | 34 |
904239 | 904239 | 2021-01-07 | Etowah | Alabama | 1055 | 10732 | 105 |
904240 | 904240 | 2021-01-07 | Fayette | Alabama | 1057 | 1517 | 21 |
904241 | 904241 | 2021-01-07 | Franklin | Alabama | 1059 | 3418 | 39 |
904242 | 904242 | 2021-01-07 | Geneva | Alabama | 1061 | 1819 | 23 |
904243 | 904243 | 2021-01-07 | Greene | Alabama | 1063 | 716 | 20 |
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);