ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2021-12-13 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2008357 | 2008357 | 2021-12-13 | Autauga | Alabama | 1001 | 10605 | 158 |
2008358 | 2008358 | 2021-12-13 | Baldwin | Alabama | 1003 | 38321 | 591 |
2008359 | 2008359 | 2021-12-13 | Barbour | Alabama | 1005 | 3716 | 81 |
2008360 | 2008360 | 2021-12-13 | Bibb | Alabama | 1007 | 4379 | 95 |
2008361 | 2008361 | 2021-12-13 | Blount | Alabama | 1009 | 10864 | 193 |
2008362 | 2008362 | 2021-12-13 | Bullock | Alabama | 1011 | 1537 | 46 |
2008363 | 2008363 | 2021-12-13 | Butler | Alabama | 1013 | 3467 | 102 |
2008364 | 2008364 | 2021-12-13 | Calhoun | Alabama | 1015 | 22705 | 522 |
2008365 | 2008365 | 2021-12-13 | Chambers | Alabama | 1017 | 5833 | 143 |
2008366 | 2008366 | 2021-12-13 | Cherokee | Alabama | 1019 | 3232 | 64 |
2008367 | 2008367 | 2021-12-13 | Chilton | Alabama | 1021 | 7156 | 172 |
2008368 | 2008368 | 2021-12-13 | Choctaw | Alabama | 1023 | 956 | 28 |
2008369 | 2008369 | 2021-12-13 | Clarke | Alabama | 1025 | 4865 | 86 |
2008370 | 2008370 | 2021-12-13 | Clay | Alabama | 1027 | 2535 | 69 |
2008371 | 2008371 | 2021-12-13 | Cleburne | Alabama | 1029 | 2568 | 60 |
2008372 | 2008372 | 2021-12-13 | Coffee | Alabama | 1031 | 9469 | 192 |
2008373 | 2008373 | 2021-12-13 | Colbert | Alabama | 1033 | 9422 | 212 |
2008374 | 2008374 | 2021-12-13 | Conecuh | Alabama | 1035 | 1942 | 62 |
2008375 | 2008375 | 2021-12-13 | Coosa | Alabama | 1037 | 1876 | 48 |
2008376 | 2008376 | 2021-12-13 | Covington | Alabama | 1039 | 7019 | 197 |
2008377 | 2008377 | 2021-12-13 | Crenshaw | Alabama | 1041 | 2627 | 79 |
2008378 | 2008378 | 2021-12-13 | Cullman | Alabama | 1043 | 16308 | 307 |
2008379 | 2008379 | 2021-12-13 | Dale | Alabama | 1045 | 9083 | 193 |
2008380 | 2008380 | 2021-12-13 | Dallas | Alabama | 1047 | 5328 | 211 |
2008381 | 2008381 | 2021-12-13 | DeKalb | Alabama | 1049 | 13174 | 273 |
2008382 | 2008382 | 2021-12-13 | Elmore | Alabama | 1051 | 16039 | 296 |
2008383 | 2008383 | 2021-12-13 | Escambia | Alabama | 1053 | 6980 | 147 |
2008384 | 2008384 | 2021-12-13 | Etowah | Alabama | 1055 | 20153 | 524 |
2008385 | 2008385 | 2021-12-13 | Fayette | Alabama | 1057 | 3343 | 85 |
2008386 | 2008386 | 2021-12-13 | Franklin | Alabama | 1059 | 6410 | 108 |
2008387 | 2008387 | 2021-12-13 | Geneva | Alabama | 1061 | 4677 | 137 |
2008388 | 2008388 | 2021-12-13 | Greene | Alabama | 1063 | 1311 | 45 |
2008389 | 2008389 | 2021-12-13 | Hale | Alabama | 1065 | 3214 | 89 |
2008390 | 2008390 | 2021-12-13 | Henry | Alabama | 1067 | 3236 | 66 |
2008391 | 2008391 | 2021-12-13 | Houston | Alabama | 1069 | 17870 | 427 |
2008392 | 2008392 | 2021-12-13 | Jackson | Alabama | 1071 | 10301 | 199 |
2008393 | 2008393 | 2021-12-13 | Jefferson | Alabama | 1073 | 116718 | 2004 |
2008394 | 2008394 | 2021-12-13 | Lamar | Alabama | 1075 | 2547 | 55 |
2008395 | 2008395 | 2021-12-13 | Lauderdale | Alabama | 1077 | 15218 | 309 |
2008396 | 2008396 | 2021-12-13 | Lawrence | Alabama | 1079 | 4886 | 130 |
2008397 | 2008397 | 2021-12-13 | Lee | Alabama | 1081 | 25783 | 265 |
2008398 | 2008398 | 2021-12-13 | Limestone | Alabama | 1083 | 16307 | 222 |
2008399 | 2008399 | 2021-12-13 | Lowndes | Alabama | 1085 | 1785 | 68 |
2008400 | 2008400 | 2021-12-13 | Macon | Alabama | 1087 | 2475 | 68 |
2008401 | 2008401 | 2021-12-13 | Madison | Alabama | 1089 | 53951 | 747 |
2008402 | 2008402 | 2021-12-13 | Marengo | Alabama | 1091 | 3430 | 93 |
2008403 | 2008403 | 2021-12-13 | Marion | Alabama | 1093 | 5461 | 132 |
2008404 | 2008404 | 2021-12-13 | Marshall | Alabama | 1095 | 18942 | 320 |
2008405 | 2008405 | 2021-12-13 | Mobile | Alabama | 1097 | 74641 | 1386 |
2008406 | 2008406 | 2021-12-13 | Monroe | Alabama | 1099 | 3386 | 66 |
2008407 | 2008407 | 2021-12-13 | Montgomery | Alabama | 1101 | 34691 | 788 |
2008408 | 2008408 | 2021-12-13 | Morgan | Alabama | 1103 | 22711 | 414 |
2008409 | 2008409 | 2021-12-13 | Perry | Alabama | 1105 | 1423 | 41 |
2008410 | 2008410 | 2021-12-13 | Pickens | Alabama | 1107 | 3359 | 91 |
2008411 | 2008411 | 2021-12-13 | Pike | Alabama | 1109 | 5169 | 109 |
2008412 | 2008412 | 2021-12-13 | Randolph | Alabama | 1111 | 3405 | 67 |
2008413 | 2008413 | 2021-12-13 | Russell | Alabama | 1113 | 7154 | 66 |
2008414 | 2008414 | 2021-12-13 | Shelby | Alabama | 1117 | 38637 | 375 |
2008415 | 2008415 | 2021-12-13 | St. Clair | Alabama | 1115 | 17064 | 361 |
2008416 | 2008416 | 2021-12-13 | Sumter | Alabama | 1119 | 1406 | 42 |
2008417 | 2008417 | 2021-12-13 | Talladega | Alabama | 1121 | 14326 | 304 |
2008418 | 2008418 | 2021-12-13 | Tallapoosa | Alabama | 1123 | 7327 | 203 |
2008419 | 2008419 | 2021-12-13 | Tuscaloosa | Alabama | 1125 | 36371 | 646 |
2008420 | 2008420 | 2021-12-13 | Walker | Alabama | 1127 | 12292 | 386 |
2008421 | 2008421 | 2021-12-13 | Washington | Alabama | 1129 | 2575 | 51 |
2008422 | 2008422 | 2021-12-13 | Wilcox | Alabama | 1131 | 1789 | 38 |
2008423 | 2008423 | 2021-12-13 | Winston | Alabama | 1133 | 4824 | 111 |
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);