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-21 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2034363 | 2034363 | 2021-12-21 | Autauga | Alabama | 1001 | 10692 | 160 |
2034364 | 2034364 | 2021-12-21 | Baldwin | Alabama | 1003 | 38569 | 592 |
2034365 | 2034365 | 2021-12-21 | Barbour | Alabama | 1005 | 3725 | 81 |
2034366 | 2034366 | 2021-12-21 | Bibb | Alabama | 1007 | 4406 | 95 |
2034367 | 2034367 | 2021-12-21 | Blount | Alabama | 1009 | 10990 | 197 |
2034368 | 2034368 | 2021-12-21 | Bullock | Alabama | 1011 | 1545 | 46 |
2034369 | 2034369 | 2021-12-21 | Butler | Alabama | 1013 | 3494 | 102 |
2034370 | 2034370 | 2021-12-21 | Calhoun | Alabama | 1015 | 22825 | 526 |
2034371 | 2034371 | 2021-12-21 | Chambers | Alabama | 1017 | 5880 | 145 |
2034372 | 2034372 | 2021-12-21 | Cherokee | Alabama | 1019 | 3272 | 64 |
2034373 | 2034373 | 2021-12-21 | Chilton | Alabama | 1021 | 7225 | 172 |
2034374 | 2034374 | 2021-12-21 | Choctaw | Alabama | 1023 | 962 | 30 |
2034375 | 2034375 | 2021-12-21 | Clarke | Alabama | 1025 | 4878 | 87 |
2034376 | 2034376 | 2021-12-21 | Clay | Alabama | 1027 | 2562 | 69 |
2034377 | 2034377 | 2021-12-21 | Cleburne | Alabama | 1029 | 2573 | 60 |
2034378 | 2034378 | 2021-12-21 | Coffee | Alabama | 1031 | 9526 | 194 |
2034379 | 2034379 | 2021-12-21 | Colbert | Alabama | 1033 | 9476 | 213 |
2034380 | 2034380 | 2021-12-21 | Conecuh | Alabama | 1035 | 1948 | 62 |
2034381 | 2034381 | 2021-12-21 | Coosa | Alabama | 1037 | 1894 | 48 |
2034382 | 2034382 | 2021-12-21 | Covington | Alabama | 1039 | 7054 | 199 |
2034383 | 2034383 | 2021-12-21 | Crenshaw | Alabama | 1041 | 2644 | 79 |
2034384 | 2034384 | 2021-12-21 | Cullman | Alabama | 1043 | 16513 | 307 |
2034385 | 2034385 | 2021-12-21 | Dale | Alabama | 1045 | 9148 | 193 |
2034386 | 2034386 | 2021-12-21 | Dallas | Alabama | 1047 | 5363 | 212 |
2034387 | 2034387 | 2021-12-21 | DeKalb | Alabama | 1049 | 13272 | 276 |
2034388 | 2034388 | 2021-12-21 | Elmore | Alabama | 1051 | 16233 | 296 |
2034389 | 2034389 | 2021-12-21 | Escambia | Alabama | 1053 | 7003 | 148 |
2034390 | 2034390 | 2021-12-21 | Etowah | Alabama | 1055 | 20248 | 526 |
2034391 | 2034391 | 2021-12-21 | Fayette | Alabama | 1057 | 3363 | 86 |
2034392 | 2034392 | 2021-12-21 | Franklin | Alabama | 1059 | 6452 | 109 |
2034393 | 2034393 | 2021-12-21 | Geneva | Alabama | 1061 | 4709 | 137 |
2034394 | 2034394 | 2021-12-21 | Greene | Alabama | 1063 | 1316 | 45 |
2034395 | 2034395 | 2021-12-21 | Hale | Alabama | 1065 | 3235 | 89 |
2034396 | 2034396 | 2021-12-21 | Henry | Alabama | 1067 | 3263 | 66 |
2034397 | 2034397 | 2021-12-21 | Houston | Alabama | 1069 | 18034 | 429 |
2034398 | 2034398 | 2021-12-21 | Jackson | Alabama | 1071 | 10398 | 200 |
2034399 | 2034399 | 2021-12-21 | Jefferson | Alabama | 1073 | 117886 | 2021 |
2034400 | 2034400 | 2021-12-21 | Lamar | Alabama | 1075 | 2560 | 56 |
2034401 | 2034401 | 2021-12-21 | Lauderdale | Alabama | 1077 | 15309 | 312 |
2034402 | 2034402 | 2021-12-21 | Lawrence | Alabama | 1079 | 4922 | 133 |
2034403 | 2034403 | 2021-12-21 | Lee | Alabama | 1081 | 25964 | 269 |
2034404 | 2034404 | 2021-12-21 | Limestone | Alabama | 1083 | 16467 | 227 |
2034405 | 2034405 | 2021-12-21 | Lowndes | Alabama | 1085 | 1790 | 68 |
2034406 | 2034406 | 2021-12-21 | Macon | Alabama | 1087 | 2500 | 68 |
2034407 | 2034407 | 2021-12-21 | Madison | Alabama | 1089 | 54600 | 755 |
2034408 | 2034408 | 2021-12-21 | Marengo | Alabama | 1091 | 3440 | 93 |
2034409 | 2034409 | 2021-12-21 | Marion | Alabama | 1093 | 5486 | 132 |
2034410 | 2034410 | 2021-12-21 | Marshall | Alabama | 1095 | 19116 | 321 |
2034411 | 2034411 | 2021-12-21 | Mobile | Alabama | 1097 | 75014 | 1391 |
2034412 | 2034412 | 2021-12-21 | Monroe | Alabama | 1099 | 3399 | 66 |
2034413 | 2034413 | 2021-12-21 | Montgomery | Alabama | 1101 | 35080 | 790 |
2034414 | 2034414 | 2021-12-21 | Morgan | Alabama | 1103 | 22945 | 420 |
2034415 | 2034415 | 2021-12-21 | Perry | Alabama | 1105 | 1424 | 41 |
2034416 | 2034416 | 2021-12-21 | Pickens | Alabama | 1107 | 3384 | 91 |
2034417 | 2034417 | 2021-12-21 | Pike | Alabama | 1109 | 5199 | 111 |
2034418 | 2034418 | 2021-12-21 | Randolph | Alabama | 1111 | 3435 | 67 |
2034419 | 2034419 | 2021-12-21 | Russell | Alabama | 1113 | 7206 | 66 |
2034420 | 2034420 | 2021-12-21 | Shelby | Alabama | 1117 | 39051 | 378 |
2034421 | 2034421 | 2021-12-21 | St. Clair | Alabama | 1115 | 17232 | 364 |
2034422 | 2034422 | 2021-12-21 | Sumter | Alabama | 1119 | 1413 | 42 |
2034423 | 2034423 | 2021-12-21 | Talladega | Alabama | 1121 | 14455 | 304 |
2034424 | 2034424 | 2021-12-21 | Tallapoosa | Alabama | 1123 | 7449 | 204 |
2034425 | 2034425 | 2021-12-21 | Tuscaloosa | Alabama | 1125 | 36591 | 649 |
2034426 | 2034426 | 2021-12-21 | Walker | Alabama | 1127 | 12410 | 388 |
2034427 | 2034427 | 2021-12-21 | Washington | Alabama | 1129 | 2578 | 51 |
2034428 | 2034428 | 2021-12-21 | Wilcox | Alabama | 1131 | 1799 | 38 |
2034429 | 2034429 | 2021-12-21 | Winston | Alabama | 1133 | 4856 | 112 |
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);