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 111
- Limestone 111
- Montgomery 111
- Tuscaloosa 111
- Elmore 110
- Baldwin 109
- Lee 109
- Shelby 109
- Madison 107
- St. Clair 107
- Talladega 106
- Calhoun 105
- Mobile 105
- Walker 105
- Chambers 104
- Jackson 104
- Lamar 104
- Lauderdale 104
- Washington 104
- Cullman 103
- Marion 103
- Houston 101
- Tallapoosa 101
- Franklin 100
- Morgan 100
- Autauga 99
- Lawrence 99
- Marshall 99
- Pickens 99
- Pike 99
- …
state 1
- Alabama · 6,652 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
290263 | 290263 | 2020-07-01 | Henry | Alabama | 1067 | 131 | 4 |
290264 | 290264 | 2020-07-01 | Houston | Alabama | 1069 | 449 | 6 |
290265 | 290265 | 2020-07-01 | Jackson | Alabama | 1071 | 242 | 3 |
290266 | 290266 | 2020-07-01 | Jefferson | Alabama | 1073 | 4436 | 144 |
290267 | 290267 | 2020-07-01 | Lamar | Alabama | 1075 | 72 | 1 |
290268 | 290268 | 2020-07-01 | Lauderdale | Alabama | 1077 | 446 | 6 |
290269 | 290269 | 2020-07-01 | Lawrence | Alabama | 1079 | 104 | 0 |
290270 | 290270 | 2020-07-01 | Lee | Alabama | 1081 | 1211 | 38 |
290271 | 290271 | 2020-07-01 | Limestone | Alabama | 1083 | 413 | 0 |
290272 | 290272 | 2020-07-01 | Lowndes | Alabama | 1085 | 463 | 21 |
290273 | 290273 | 2020-07-01 | Macon | Alabama | 1087 | 172 | 8 |
290274 | 290274 | 2020-07-01 | Madison | Alabama | 1089 | 1084 | 8 |
290275 | 290275 | 2020-07-01 | Marengo | Alabama | 1091 | 287 | 11 |
290276 | 290276 | 2020-07-01 | Marion | Alabama | 1093 | 208 | 12 |
290277 | 290277 | 2020-07-01 | Marshall | Alabama | 1095 | 1548 | 10 |
290278 | 290278 | 2020-07-01 | Mobile | Alabama | 1097 | 3724 | 138 |
290279 | 290279 | 2020-07-01 | Monroe | Alabama | 1099 | 198 | 2 |
290280 | 290280 | 2020-07-01 | Montgomery | Alabama | 1101 | 3890 | 102 |
290281 | 290281 | 2020-07-01 | Morgan | Alabama | 1103 | 993 | 3 |
290282 | 290282 | 2020-07-01 | Perry | Alabama | 1105 | 145 | 1 |
290283 | 290283 | 2020-07-01 | Pickens | Alabama | 1107 | 212 | 6 |
290284 | 290284 | 2020-07-01 | Pike | Alabama | 1109 | 407 | 5 |
290285 | 290285 | 2020-07-01 | Randolph | Alabama | 1111 | 172 | 9 |
290286 | 290286 | 2020-07-01 | Russell | Alabama | 1113 | 489 | 0 |
290287 | 290287 | 2020-07-01 | Shelby | Alabama | 1117 | 1103 | 23 |
290288 | 290288 | 2020-07-01 | St. Clair | Alabama | 1115 | 314 | 2 |
290289 | 290289 | 2020-07-01 | Sumter | Alabama | 1119 | 277 | 12 |
290290 | 290290 | 2020-07-01 | Talladega | Alabama | 1121 | 275 | 8 |
290291 | 290291 | 2020-07-01 | Tallapoosa | Alabama | 1123 | 570 | 70 |
290292 | 290292 | 2020-07-01 | Tuscaloosa | Alabama | 1125 | 2071 | 40 |
290293 | 290293 | 2020-07-01 | Walker | Alabama | 1127 | 880 | 23 |
290294 | 290294 | 2020-07-01 | Washington | Alabama | 1129 | 103 | 7 |
290295 | 290295 | 2020-07-01 | Wilcox | Alabama | 1131 | 282 | 8 |
290296 | 290296 | 2020-07-01 | Winston | Alabama | 1133 | 235 | 3 |
287080 | 287080 | 2020-06-30 | Autauga | Alabama | 1001 | 537 | 12 |
287081 | 287081 | 2020-06-30 | Baldwin | Alabama | 1003 | 680 | 10 |
287082 | 287082 | 2020-06-30 | Barbour | Alabama | 1005 | 325 | 1 |
287083 | 287083 | 2020-06-30 | Bibb | Alabama | 1007 | 170 | 1 |
287084 | 287084 | 2020-06-30 | Blount | Alabama | 1009 | 208 | 1 |
287085 | 287085 | 2020-06-30 | Bullock | Alabama | 1011 | 365 | 10 |
287086 | 287086 | 2020-06-30 | Butler | Alabama | 1013 | 607 | 27 |
287087 | 287087 | 2020-06-30 | Calhoun | Alabama | 1015 | 276 | 5 |
287088 | 287088 | 2020-06-30 | Chambers | Alabama | 1017 | 590 | 27 |
287089 | 287089 | 2020-06-30 | Cherokee | Alabama | 1019 | 74 | 7 |
287090 | 287090 | 2020-06-30 | Chilton | Alabama | 1021 | 214 | 3 |
287091 | 287091 | 2020-06-30 | Choctaw | Alabama | 1023 | 192 | 12 |
287092 | 287092 | 2020-06-30 | Clarke | Alabama | 1025 | 265 | 5 |
287093 | 287093 | 2020-06-30 | Clay | Alabama | 1027 | 53 | 2 |
287094 | 287094 | 2020-06-30 | Cleburne | Alabama | 1029 | 29 | 1 |
287095 | 287095 | 2020-06-30 | Coffee | Alabama | 1031 | 357 | 2 |
287096 | 287096 | 2020-06-30 | Colbert | Alabama | 1033 | 372 | 5 |
287097 | 287097 | 2020-06-30 | Conecuh | Alabama | 1035 | 180 | 6 |
287098 | 287098 | 2020-06-30 | Coosa | Alabama | 1037 | 55 | 1 |
287099 | 287099 | 2020-06-30 | Covington | Alabama | 1039 | 316 | 7 |
287100 | 287100 | 2020-06-30 | Crenshaw | Alabama | 1041 | 126 | 3 |
287101 | 287101 | 2020-06-30 | Cullman | Alabama | 1043 | 408 | 3 |
287102 | 287102 | 2020-06-30 | Dale | Alabama | 1045 | 244 | 0 |
287103 | 287103 | 2020-06-30 | Dallas | Alabama | 1047 | 814 | 8 |
287104 | 287104 | 2020-06-30 | DeKalb | Alabama | 1049 | 583 | 5 |
287105 | 287105 | 2020-06-30 | Elmore | Alabama | 1051 | 822 | 14 |
287106 | 287106 | 2020-06-30 | Escambia | Alabama | 1053 | 258 | 6 |
287107 | 287107 | 2020-06-30 | Etowah | Alabama | 1055 | 615 | 13 |
287108 | 287108 | 2020-06-30 | Fayette | Alabama | 1057 | 69 | 1 |
287109 | 287109 | 2020-06-30 | Franklin | Alabama | 1059 | 847 | 13 |
287110 | 287110 | 2020-06-30 | Geneva | Alabama | 1061 | 63 | 0 |
287111 | 287111 | 2020-06-30 | Greene | Alabama | 1063 | 164 | 7 |
287112 | 287112 | 2020-06-30 | Hale | Alabama | 1065 | 290 | 20 |
287113 | 287113 | 2020-06-30 | Henry | Alabama | 1067 | 130 | 4 |
287114 | 287114 | 2020-06-30 | Houston | Alabama | 1069 | 439 | 6 |
287115 | 287115 | 2020-06-30 | Jackson | Alabama | 1071 | 214 | 3 |
287116 | 287116 | 2020-06-30 | Jefferson | Alabama | 1073 | 4258 | 142 |
287117 | 287117 | 2020-06-30 | Lamar | Alabama | 1075 | 72 | 1 |
287118 | 287118 | 2020-06-30 | Lauderdale | Alabama | 1077 | 412 | 5 |
287119 | 287119 | 2020-06-30 | Lawrence | Alabama | 1079 | 103 | 0 |
287120 | 287120 | 2020-06-30 | Lee | Alabama | 1081 | 1188 | 37 |
287121 | 287121 | 2020-06-30 | Limestone | Alabama | 1083 | 407 | 0 |
287122 | 287122 | 2020-06-30 | Lowndes | Alabama | 1085 | 462 | 20 |
287123 | 287123 | 2020-06-30 | Macon | Alabama | 1087 | 168 | 8 |
287124 | 287124 | 2020-06-30 | Madison | Alabama | 1089 | 1047 | 7 |
287125 | 287125 | 2020-06-30 | Marengo | Alabama | 1091 | 278 | 11 |
287126 | 287126 | 2020-06-30 | Marion | Alabama | 1093 | 205 | 12 |
287127 | 287127 | 2020-06-30 | Marshall | Alabama | 1095 | 1505 | 9 |
287128 | 287128 | 2020-06-30 | Mobile | Alabama | 1097 | 3660 | 138 |
287129 | 287129 | 2020-06-30 | Monroe | Alabama | 1099 | 195 | 2 |
287130 | 287130 | 2020-06-30 | Montgomery | Alabama | 1101 | 3839 | 97 |
287131 | 287131 | 2020-06-30 | Morgan | Alabama | 1103 | 966 | 3 |
287132 | 287132 | 2020-06-30 | Perry | Alabama | 1105 | 135 | 0 |
287133 | 287133 | 2020-06-30 | Pickens | Alabama | 1107 | 205 | 6 |
287134 | 287134 | 2020-06-30 | Pike | Alabama | 1109 | 404 | 5 |
287135 | 287135 | 2020-06-30 | Randolph | Alabama | 1111 | 171 | 9 |
287136 | 287136 | 2020-06-30 | Russell | Alabama | 1113 | 474 | 0 |
287137 | 287137 | 2020-06-30 | Shelby | Alabama | 1117 | 1077 | 23 |
287138 | 287138 | 2020-06-30 | St. Clair | Alabama | 1115 | 302 | 2 |
287139 | 287139 | 2020-06-30 | Sumter | Alabama | 1119 | 276 | 12 |
287140 | 287140 | 2020-06-30 | Talladega | Alabama | 1121 | 265 | 7 |
287141 | 287141 | 2020-06-30 | Tallapoosa | Alabama | 1123 | 567 | 70 |
287142 | 287142 | 2020-06-30 | Tuscaloosa | Alabama | 1125 | 1986 | 38 |
287143 | 287143 | 2020-06-30 | Walker | Alabama | 1127 | 855 | 17 |
287144 | 287144 | 2020-06-30 | Washington | Alabama | 1129 | 101 | 7 |
287145 | 287145 | 2020-06-30 | Wilcox | Alabama | 1131 | 280 | 8 |
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);