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 2022-02-11 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2203472 | 2203472 | 2022-02-11 | Autauga | Alabama | 1001 | 15216 | 173 |
2203473 | 2203473 | 2022-02-11 | Baldwin | Alabama | 1003 | 54301 | 626 |
2203474 | 2203474 | 2022-02-11 | Barbour | Alabama | 1005 | 5402 | 87 |
2203475 | 2203475 | 2022-02-11 | Bibb | Alabama | 1007 | 6294 | 97 |
2203476 | 2203476 | 2022-02-11 | Blount | Alabama | 1009 | 14516 | 212 |
2203477 | 2203477 | 2022-02-11 | Bullock | Alabama | 1011 | 2267 | 49 |
2203478 | 2203478 | 2022-02-11 | Butler | Alabama | 1013 | 4985 | 111 |
2203479 | 2203479 | 2022-02-11 | Calhoun | Alabama | 1015 | 31148 | 566 |
2203480 | 2203480 | 2022-02-11 | Chambers | Alabama | 1017 | 8349 | 149 |
2203481 | 2203481 | 2022-02-11 | Cherokee | Alabama | 1019 | 4989 | 72 |
2203482 | 2203482 | 2022-02-11 | Chilton | Alabama | 1021 | 10320 | 185 |
2203483 | 2203483 | 2022-02-11 | Choctaw | Alabama | 1023 | 1930 | 33 |
2203484 | 2203484 | 2022-02-11 | Clarke | Alabama | 1025 | 6950 | 93 |
2203485 | 2203485 | 2022-02-11 | Clay | Alabama | 1027 | 4026 | 73 |
2203486 | 2203486 | 2022-02-11 | Cleburne | Alabama | 1029 | 3502 | 65 |
2203487 | 2203487 | 2022-02-11 | Coffee | Alabama | 1031 | 13180 | 213 |
2203488 | 2203488 | 2022-02-11 | Colbert | Alabama | 1033 | 15856 | 223 |
2203489 | 2203489 | 2022-02-11 | Conecuh | Alabama | 1035 | 2813 | 63 |
2203490 | 2203490 | 2022-02-11 | Coosa | Alabama | 1037 | 2863 | 53 |
2203491 | 2203491 | 2022-02-11 | Covington | Alabama | 1039 | 9127 | 212 |
2203492 | 2203492 | 2022-02-11 | Crenshaw | Alabama | 1041 | 3739 | 84 |
2203493 | 2203493 | 2022-02-11 | Cullman | Alabama | 1043 | 23967 | 332 |
2203494 | 2203494 | 2022-02-11 | Dale | Alabama | 1045 | 12288 | 210 |
2203495 | 2203495 | 2022-02-11 | Dallas | Alabama | 1047 | 8158 | 226 |
2203496 | 2203496 | 2022-02-11 | DeKalb | Alabama | 1049 | 18286 | 299 |
2203497 | 2203497 | 2022-02-11 | Elmore | Alabama | 1051 | 22646 | 315 |
2203498 | 2203498 | 2022-02-11 | Escambia | Alabama | 1053 | 9872 | 153 |
2203499 | 2203499 | 2022-02-11 | Etowah | Alabama | 1055 | 28151 | 559 |
2203500 | 2203500 | 2022-02-11 | Fayette | Alabama | 1057 | 4513 | 87 |
2203501 | 2203501 | 2022-02-11 | Franklin | Alabama | 1059 | 9649 | 123 |
2203502 | 2203502 | 2022-02-11 | Geneva | Alabama | 1061 | 6084 | 146 |
2203503 | 2203503 | 2022-02-11 | Greene | Alabama | 1063 | 1777 | 48 |
2203504 | 2203504 | 2022-02-11 | Hale | Alabama | 1065 | 4497 | 96 |
2203505 | 2203505 | 2022-02-11 | Henry | Alabama | 1067 | 4374 | 68 |
2203506 | 2203506 | 2022-02-11 | Houston | Alabama | 1069 | 24546 | 457 |
2203507 | 2203507 | 2022-02-11 | Jackson | Alabama | 1071 | 14716 | 214 |
2203508 | 2203508 | 2022-02-11 | Jefferson | Alabama | 1073 | 180124 | 2122 |
2203509 | 2203509 | 2022-02-11 | Lamar | Alabama | 1075 | 3527 | 62 |
2203510 | 2203510 | 2022-02-11 | Lauderdale | Alabama | 1077 | 23502 | 348 |
2203511 | 2203511 | 2022-02-11 | Lawrence | Alabama | 1079 | 7384 | 145 |
2203512 | 2203512 | 2022-02-11 | Lee | Alabama | 1081 | 37125 | 290 |
2203513 | 2203513 | 2022-02-11 | Limestone | Alabama | 1083 | 24204 | 249 |
2203514 | 2203514 | 2022-02-11 | Lowndes | Alabama | 1085 | 2585 | 69 |
2203515 | 2203515 | 2022-02-11 | Macon | Alabama | 1087 | 3793 | 72 |
2203516 | 2203516 | 2022-02-11 | Madison | Alabama | 1089 | 86415 | 836 |
2203517 | 2203517 | 2022-02-11 | Marengo | Alabama | 1091 | 4647 | 97 |
2203518 | 2203518 | 2022-02-11 | Marion | Alabama | 1093 | 7830 | 139 |
2203519 | 2203519 | 2022-02-11 | Marshall | Alabama | 1095 | 26853 | 347 |
2203520 | 2203520 | 2022-02-11 | Mobile | Alabama | 1097 | 110338 | 1511 |
2203521 | 2203521 | 2022-02-11 | Monroe | Alabama | 1099 | 5202 | 71 |
2203522 | 2203522 | 2022-02-11 | Montgomery | Alabama | 1101 | 53744 | 831 |
2203523 | 2203523 | 2022-02-11 | Morgan | Alabama | 1103 | 35167 | 458 |
2203524 | 2203524 | 2022-02-11 | Perry | Alabama | 1105 | 2005 | 41 |
2203525 | 2203525 | 2022-02-11 | Pickens | Alabama | 1107 | 4989 | 95 |
2203526 | 2203526 | 2022-02-11 | Pike | Alabama | 1109 | 7320 | 119 |
2203527 | 2203527 | 2022-02-11 | Randolph | Alabama | 1111 | 4997 | 71 |
2203528 | 2203528 | 2022-02-11 | Russell | Alabama | 1113 | 9720 | 75 |
2203529 | 2203529 | 2022-02-11 | Shelby | Alabama | 1117 | 58009 | 404 |
2203530 | 2203530 | 2022-02-11 | St. Clair | Alabama | 1115 | 24615 | 383 |
2203531 | 2203531 | 2022-02-11 | Sumter | Alabama | 1119 | 2343 | 44 |
2203532 | 2203532 | 2022-02-11 | Talladega | Alabama | 1121 | 21590 | 330 |
2203533 | 2203533 | 2022-02-11 | Tallapoosa | Alabama | 1123 | 11166 | 216 |
2203534 | 2203534 | 2022-02-11 | Tuscaloosa | Alabama | 1125 | 53228 | 698 |
2203535 | 2203535 | 2022-02-11 | Walker | Alabama | 1127 | 18101 | 401 |
2203536 | 2203536 | 2022-02-11 | Washington | Alabama | 1129 | 3629 | 53 |
2203537 | 2203537 | 2022-02-11 | Wilcox | Alabama | 1131 | 2801 | 40 |
2203538 | 2203538 | 2022-02-11 | Winston | Alabama | 1133 | 7330 | 116 |
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);