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-08-03 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1579458 | 1579458 | 2021-08-03 | Autauga | Alabama | 1001 | 7615 | 114 |
1579459 | 1579459 | 2021-08-03 | Baldwin | Alabama | 1003 | 25860 | 329 |
1579460 | 1579460 | 2021-08-03 | Barbour | Alabama | 1005 | 2537 | 61 |
1579461 | 1579461 | 2021-08-03 | Bibb | Alabama | 1007 | 2928 | 65 |
1579462 | 1579462 | 2021-08-03 | Blount | Alabama | 1009 | 7417 | 139 |
1579463 | 1579463 | 2021-08-03 | Bullock | Alabama | 1011 | 1265 | 42 |
1579464 | 1579464 | 2021-08-03 | Butler | Alabama | 1013 | 2424 | 72 |
1579465 | 1579465 | 2021-08-03 | Calhoun | Alabama | 1015 | 15498 | 334 |
1579466 | 1579466 | 2021-08-03 | Chambers | Alabama | 1017 | 3987 | 125 |
1579467 | 1579467 | 2021-08-03 | Cherokee | Alabama | 1019 | 2007 | 48 |
1579468 | 1579468 | 2021-08-03 | Chilton | Alabama | 1021 | 4810 | 117 |
1579469 | 1579469 | 2021-08-03 | Choctaw | Alabama | 1023 | 644 | 25 |
1579470 | 1579470 | 2021-08-03 | Clarke | Alabama | 1025 | 3722 | 63 |
1579471 | 1579471 | 2021-08-03 | Clay | Alabama | 1027 | 1671 | 59 |
1579472 | 1579472 | 2021-08-03 | Cleburne | Alabama | 1029 | 1618 | 45 |
1579473 | 1579473 | 2021-08-03 | Coffee | Alabama | 1031 | 6443 | 132 |
1579474 | 1579474 | 2021-08-03 | Colbert | Alabama | 1033 | 6752 | 142 |
1579475 | 1579475 | 2021-08-03 | Conecuh | Alabama | 1035 | 1221 | 32 |
1579476 | 1579476 | 2021-08-03 | Coosa | Alabama | 1037 | 1195 | 29 |
1579477 | 1579477 | 2021-08-03 | Covington | Alabama | 1039 | 4804 | 125 |
1579478 | 1579478 | 2021-08-03 | Crenshaw | Alabama | 1041 | 1706 | 58 |
1579479 | 1579479 | 2021-08-03 | Cullman | Alabama | 1043 | 10610 | 206 |
1579480 | 1579480 | 2021-08-03 | Dale | Alabama | 1045 | 5723 | 117 |
1579481 | 1579481 | 2021-08-03 | Dallas | Alabama | 1047 | 3751 | 163 |
1579482 | 1579482 | 2021-08-03 | DeKalb | Alabama | 1049 | 9594 | 192 |
1579483 | 1579483 | 2021-08-03 | Elmore | Alabama | 1051 | 10977 | 219 |
1579484 | 1579484 | 2021-08-03 | Escambia | Alabama | 1053 | 4510 | 83 |
1579485 | 1579485 | 2021-08-03 | Etowah | Alabama | 1055 | 15060 | 370 |
1579486 | 1579486 | 2021-08-03 | Fayette | Alabama | 1057 | 2281 | 65 |
1579487 | 1579487 | 2021-08-03 | Franklin | Alabama | 1059 | 4627 | 81 |
1579488 | 1579488 | 2021-08-03 | Geneva | Alabama | 1061 | 2883 | 83 |
1579489 | 1579489 | 2021-08-03 | Greene | Alabama | 1063 | 993 | 37 |
1579490 | 1579490 | 2021-08-03 | Hale | Alabama | 1065 | 2367 | 78 |
1579491 | 1579491 | 2021-08-03 | Henry | Alabama | 1067 | 2165 | 45 |
1579492 | 1579492 | 2021-08-03 | Houston | Alabama | 1069 | 12191 | 293 |
1579493 | 1579493 | 2021-08-03 | Jackson | Alabama | 1071 | 7431 | 117 |
1579494 | 1579494 | 2021-08-03 | Jefferson | Alabama | 1073 | 86109 | 1591 |
1579495 | 1579495 | 2021-08-03 | Lamar | Alabama | 1075 | 1519 | 38 |
1579496 | 1579496 | 2021-08-03 | Lauderdale | Alabama | 1077 | 10305 | 254 |
1579497 | 1579497 | 2021-08-03 | Lawrence | Alabama | 1079 | 3277 | 100 |
1579498 | 1579498 | 2021-08-03 | Lee | Alabama | 1081 | 17336 | 181 |
1579499 | 1579499 | 2021-08-03 | Limestone | Alabama | 1083 | 10816 | 158 |
1579500 | 1579500 | 2021-08-03 | Lowndes | Alabama | 1085 | 1462 | 55 |
1579501 | 1579501 | 2021-08-03 | Macon | Alabama | 1087 | 1715 | 52 |
1579502 | 1579502 | 2021-08-03 | Madison | Alabama | 1089 | 37714 | 533 |
1579503 | 1579503 | 2021-08-03 | Marengo | Alabama | 1091 | 2629 | 67 |
1579504 | 1579504 | 2021-08-03 | Marion | Alabama | 1093 | 3470 | 107 |
1579505 | 1579505 | 2021-08-03 | Marshall | Alabama | 1095 | 13198 | 236 |
1579506 | 1579506 | 2021-08-03 | Mobile | Alabama | 1097 | 49771 | 865 |
1579507 | 1579507 | 2021-08-03 | Monroe | Alabama | 1099 | 2045 | 41 |
1579508 | 1579508 | 2021-08-03 | Montgomery | Alabama | 1101 | 26343 | 628 |
1579509 | 1579509 | 2021-08-03 | Morgan | Alabama | 1103 | 15225 | 291 |
1579510 | 1579510 | 2021-08-03 | Perry | Alabama | 1105 | 1112 | 28 |
1579511 | 1579511 | 2021-08-03 | Pickens | Alabama | 1107 | 2477 | 62 |
1579512 | 1579512 | 2021-08-03 | Pike | Alabama | 1109 | 3340 | 79 |
1579513 | 1579513 | 2021-08-03 | Randolph | Alabama | 1111 | 2028 | 44 |
1579514 | 1579514 | 2021-08-03 | Russell | Alabama | 1113 | 4822 | 43 |
1579515 | 1579515 | 2021-08-03 | Shelby | Alabama | 1117 | 27501 | 259 |
1579516 | 1579516 | 2021-08-03 | St. Clair | Alabama | 1115 | 10852 | 252 |
1579517 | 1579517 | 2021-08-03 | Sumter | Alabama | 1119 | 1106 | 33 |
1579518 | 1579518 | 2021-08-03 | Talladega | Alabama | 1121 | 9005 | 188 |
1579519 | 1579519 | 2021-08-03 | Tallapoosa | Alabama | 1123 | 4571 | 156 |
1579520 | 1579520 | 2021-08-03 | Tuscaloosa | Alabama | 1125 | 27344 | 465 |
1579521 | 1579521 | 2021-08-03 | Walker | Alabama | 1127 | 7840 | 288 |
1579522 | 1579522 | 2021-08-03 | Washington | Alabama | 1129 | 1868 | 39 |
1579523 | 1579523 | 2021-08-03 | Wilcox | Alabama | 1131 | 1323 | 31 |
1579524 | 1579524 | 2021-08-03 | Winston | Alabama | 1133 | 3007 | 73 |
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);