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 317
- Jefferson 317
- Limestone 317
- Montgomery 317
- Tuscaloosa 317
- Baldwin 316
- Lee 315
- Shelby 315
- Madison 313
- St. Clair 313
- Calhoun 312
- Talladega 312
- Chambers 311
- Mobile 311
- Walker 311
- Cullman 310
- Jackson 310
- Lamar 310
- Lauderdale 310
- Washington 310
- Marion 309
- Franklin 307
- Houston 307
- Tallapoosa 307
- Autauga 306
- Morgan 306
- Blount 305
- Butler 305
- Cherokee 305
- Chilton 305
- …
state 1
- Alabama · 20,487 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
956137 | 956137 | 2021-01-23 | Autauga | Alabama | 1001 | 5358 | 62 |
956138 | 956138 | 2021-01-23 | Baldwin | Alabama | 1003 | 17128 | 189 |
956139 | 956139 | 2021-01-23 | Barbour | Alabama | 1005 | 1805 | 38 |
956140 | 956140 | 2021-01-23 | Bibb | Alabama | 1007 | 2223 | 48 |
956141 | 956141 | 2021-01-23 | Blount | Alabama | 1009 | 5462 | 86 |
956142 | 956142 | 2021-01-23 | Bullock | Alabama | 1011 | 1033 | 28 |
956143 | 956143 | 2021-01-23 | Butler | Alabama | 1013 | 1731 | 60 |
956144 | 956144 | 2021-01-23 | Calhoun | Alabama | 1015 | 11496 | 206 |
956145 | 956145 | 2021-01-23 | Chambers | Alabama | 1017 | 3034 | 70 |
956146 | 956146 | 2021-01-23 | Cherokee | Alabama | 1019 | 1651 | 31 |
956147 | 956147 | 2021-01-23 | Chilton | Alabama | 1021 | 3443 | 73 |
956148 | 956148 | 2021-01-23 | Choctaw | Alabama | 1023 | 519 | 24 |
956149 | 956149 | 2021-01-23 | Clarke | Alabama | 1025 | 2980 | 36 |
956150 | 956150 | 2021-01-23 | Clay | Alabama | 1027 | 1297 | 46 |
956151 | 956151 | 2021-01-23 | Cleburne | Alabama | 1029 | 1215 | 25 |
956152 | 956152 | 2021-01-23 | Coffee | Alabama | 1031 | 4607 | 64 |
956153 | 956153 | 2021-01-23 | Colbert | Alabama | 1033 | 5486 | 94 |
956154 | 956154 | 2021-01-23 | Conecuh | Alabama | 1035 | 978 | 22 |
956155 | 956155 | 2021-01-23 | Coosa | Alabama | 1037 | 634 | 18 |
956156 | 956156 | 2021-01-23 | Covington | Alabama | 1039 | 3385 | 80 |
956157 | 956157 | 2021-01-23 | Crenshaw | Alabama | 1041 | 1237 | 45 |
956158 | 956158 | 2021-01-23 | Cullman | Alabama | 1043 | 8257 | 124 |
956159 | 956159 | 2021-01-23 | Dale | Alabama | 1045 | 4096 | 85 |
956160 | 956160 | 2021-01-23 | Dallas | Alabama | 1047 | 3129 | 96 |
956161 | 956161 | 2021-01-23 | DeKalb | Alabama | 1049 | 7871 | 107 |
956162 | 956162 | 2021-01-23 | Elmore | Alabama | 1051 | 8183 | 110 |
956163 | 956163 | 2021-01-23 | Escambia | Alabama | 1053 | 3345 | 44 |
956164 | 956164 | 2021-01-23 | Etowah | Alabama | 1055 | 12070 | 181 |
956165 | 956165 | 2021-01-23 | Fayette | Alabama | 1057 | 1778 | 29 |
956166 | 956166 | 2021-01-23 | Franklin | Alabama | 1059 | 3741 | 50 |
956167 | 956167 | 2021-01-23 | Geneva | Alabama | 1061 | 2102 | 47 |
956168 | 956168 | 2021-01-23 | Greene | Alabama | 1063 | 779 | 23 |
956169 | 956169 | 2021-01-23 | Hale | Alabama | 1065 | 1849 | 44 |
956170 | 956170 | 2021-01-23 | Henry | Alabama | 1067 | 1595 | 25 |
956171 | 956171 | 2021-01-23 | Houston | Alabama | 1069 | 8988 | 164 |
956172 | 956172 | 2021-01-23 | Jackson | Alabama | 1071 | 5991 | 45 |
956173 | 956173 | 2021-01-23 | Jefferson | Alabama | 1073 | 64437 | 1007 |
956174 | 956174 | 2021-01-23 | Lamar | Alabama | 1075 | 1199 | 22 |
956175 | 956175 | 2021-01-23 | Lauderdale | Alabama | 1077 | 7847 | 107 |
956176 | 956176 | 2021-01-23 | Lawrence | Alabama | 1079 | 2533 | 55 |
956177 | 956177 | 2021-01-23 | Lee | Alabama | 1081 | 13137 | 107 |
956178 | 956178 | 2021-01-23 | Limestone | Alabama | 1083 | 8320 | 81 |
956179 | 956179 | 2021-01-23 | Lowndes | Alabama | 1085 | 1148 | 36 |
956180 | 956180 | 2021-01-23 | Macon | Alabama | 1087 | 1219 | 37 |
956181 | 956181 | 2021-01-23 | Madison | Alabama | 1089 | 28158 | 217 |
956182 | 956182 | 2021-01-23 | Marengo | Alabama | 1091 | 2082 | 31 |
956183 | 956183 | 2021-01-23 | Marion | Alabama | 1093 | 2531 | 61 |
956184 | 956184 | 2021-01-23 | Marshall | Alabama | 1095 | 10420 | 123 |
956185 | 956185 | 2021-01-23 | Mobile | Alabama | 1097 | 31435 | 569 |
956186 | 956186 | 2021-01-23 | Monroe | Alabama | 1099 | 1520 | 21 |
956187 | 956187 | 2021-01-23 | Montgomery | Alabama | 1101 | 19873 | 332 |
956188 | 956188 | 2021-01-23 | Morgan | Alabama | 1103 | 12594 | 142 |
956189 | 956189 | 2021-01-23 | Perry | Alabama | 1105 | 999 | 18 |
956190 | 956190 | 2021-01-23 | Pickens | Alabama | 1107 | 1995 | 31 |
956191 | 956191 | 2021-01-23 | Pike | Alabama | 1109 | 2624 | 31 |
956192 | 956192 | 2021-01-23 | Randolph | Alabama | 1111 | 1455 | 36 |
956193 | 956193 | 2021-01-23 | Russell | Alabama | 1113 | 3542 | 15 |
956194 | 956194 | 2021-01-23 | Shelby | Alabama | 1117 | 19248 | 132 |
956195 | 956195 | 2021-01-23 | St. Clair | Alabama | 1115 | 7808 | 130 |
956196 | 956196 | 2021-01-23 | Sumter | Alabama | 1119 | 905 | 27 |
956197 | 956197 | 2021-01-23 | Talladega | Alabama | 1121 | 6445 | 112 |
956198 | 956198 | 2021-01-23 | Tallapoosa | Alabama | 1123 | 3143 | 109 |
956199 | 956199 | 2021-01-23 | Tuscaloosa | Alabama | 1125 | 21492 | 275 |
956200 | 956200 | 2021-01-23 | Walker | Alabama | 1127 | 6028 | 183 |
956201 | 956201 | 2021-01-23 | Washington | Alabama | 1129 | 1417 | 27 |
956202 | 956202 | 2021-01-23 | Wilcox | Alabama | 1131 | 1079 | 22 |
956203 | 956203 | 2021-01-23 | Winston | Alabama | 1133 | 2333 | 42 |
952892 | 952892 | 2021-01-22 | Autauga | Alabama | 1001 | 5327 | 61 |
952893 | 952893 | 2021-01-22 | Baldwin | Alabama | 1003 | 16981 | 188 |
952894 | 952894 | 2021-01-22 | Barbour | Alabama | 1005 | 1793 | 37 |
952895 | 952895 | 2021-01-22 | Bibb | Alabama | 1007 | 2212 | 48 |
952896 | 952896 | 2021-01-22 | Blount | Alabama | 1009 | 5439 | 86 |
952897 | 952897 | 2021-01-22 | Bullock | Alabama | 1011 | 1022 | 28 |
952898 | 952898 | 2021-01-22 | Butler | Alabama | 1013 | 1724 | 59 |
952899 | 952899 | 2021-01-22 | Calhoun | Alabama | 1015 | 11441 | 206 |
952900 | 952900 | 2021-01-22 | Chambers | Alabama | 1017 | 3011 | 70 |
952901 | 952901 | 2021-01-22 | Cherokee | Alabama | 1019 | 1643 | 30 |
952902 | 952902 | 2021-01-22 | Chilton | Alabama | 1021 | 3428 | 73 |
952903 | 952903 | 2021-01-22 | Choctaw | Alabama | 1023 | 517 | 24 |
952904 | 952904 | 2021-01-22 | Clarke | Alabama | 1025 | 2933 | 36 |
952905 | 952905 | 2021-01-22 | Clay | Alabama | 1027 | 1291 | 46 |
952906 | 952906 | 2021-01-22 | Cleburne | Alabama | 1029 | 1207 | 24 |
952907 | 952907 | 2021-01-22 | Coffee | Alabama | 1031 | 4567 | 62 |
952908 | 952908 | 2021-01-22 | Colbert | Alabama | 1033 | 5452 | 76 |
952909 | 952909 | 2021-01-22 | Conecuh | Alabama | 1035 | 968 | 21 |
952910 | 952910 | 2021-01-22 | Coosa | Alabama | 1037 | 632 | 15 |
952911 | 952911 | 2021-01-22 | Covington | Alabama | 1039 | 3360 | 68 |
952912 | 952912 | 2021-01-22 | Crenshaw | Alabama | 1041 | 1229 | 44 |
952913 | 952913 | 2021-01-22 | Cullman | Alabama | 1043 | 8203 | 108 |
952914 | 952914 | 2021-01-22 | Dale | Alabama | 1045 | 4068 | 83 |
952915 | 952915 | 2021-01-22 | Dallas | Alabama | 1047 | 3120 | 96 |
952916 | 952916 | 2021-01-22 | DeKalb | Alabama | 1049 | 7828 | 103 |
952917 | 952917 | 2021-01-22 | Elmore | Alabama | 1051 | 8120 | 104 |
952918 | 952918 | 2021-01-22 | Escambia | Alabama | 1053 | 3301 | 44 |
952919 | 952919 | 2021-01-22 | Etowah | Alabama | 1055 | 11987 | 179 |
952920 | 952920 | 2021-01-22 | Fayette | Alabama | 1057 | 1770 | 29 |
952921 | 952921 | 2021-01-22 | Franklin | Alabama | 1059 | 3724 | 48 |
952922 | 952922 | 2021-01-22 | Geneva | Alabama | 1061 | 2087 | 46 |
952923 | 952923 | 2021-01-22 | Greene | Alabama | 1063 | 768 | 23 |
952924 | 952924 | 2021-01-22 | Hale | Alabama | 1065 | 1827 | 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);