ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-02-23" 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 |
---|---|---|---|---|---|---|---|
2242489 | 2242489 | 2022-02-23 | Autauga | Alabama | 1001 | 15451 | 184 |
2242490 | 2242490 | 2022-02-23 | Baldwin | Alabama | 1003 | 54837 | 636 |
2242491 | 2242491 | 2022-02-23 | Barbour | Alabama | 1005 | 5433 | 92 |
2242492 | 2242492 | 2022-02-23 | Bibb | Alabama | 1007 | 6364 | 99 |
2242493 | 2242493 | 2022-02-23 | Blount | Alabama | 1009 | 14706 | 216 |
2242494 | 2242494 | 2022-02-23 | Bullock | Alabama | 1011 | 2278 | 49 |
2242495 | 2242495 | 2022-02-23 | Butler | Alabama | 1013 | 5028 | 115 |
2242496 | 2242496 | 2022-02-23 | Calhoun | Alabama | 1015 | 31469 | 581 |
2242497 | 2242497 | 2022-02-23 | Chambers | Alabama | 1017 | 8421 | 150 |
2242498 | 2242498 | 2022-02-23 | Cherokee | Alabama | 1019 | 5062 | 77 |
2242499 | 2242499 | 2022-02-23 | Chilton | Alabama | 1021 | 10501 | 187 |
2242500 | 2242500 | 2022-02-23 | Choctaw | Alabama | 1023 | 1998 | 34 |
2242501 | 2242501 | 2022-02-23 | Clarke | Alabama | 1025 | 7026 | 95 |
2242502 | 2242502 | 2022-02-23 | Clay | Alabama | 1027 | 4064 | 74 |
2242503 | 2242503 | 2022-02-23 | Cleburne | Alabama | 1029 | 3527 | 66 |
2242504 | 2242504 | 2022-02-23 | Coffee | Alabama | 1031 | 13279 | 216 |
2242505 | 2242505 | 2022-02-23 | Colbert | Alabama | 1033 | 16069 | 235 |
2242506 | 2242506 | 2022-02-23 | Conecuh | Alabama | 1035 | 2831 | 65 |
2242507 | 2242507 | 2022-02-23 | Coosa | Alabama | 1037 | 2904 | 54 |
2242508 | 2242508 | 2022-02-23 | Covington | Alabama | 1039 | 9223 | 216 |
2242509 | 2242509 | 2022-02-23 | Crenshaw | Alabama | 1041 | 3769 | 88 |
2242510 | 2242510 | 2022-02-23 | Cullman | Alabama | 1043 | 24258 | 341 |
2242511 | 2242511 | 2022-02-23 | Dale | Alabama | 1045 | 12404 | 215 |
2242512 | 2242512 | 2022-02-23 | Dallas | Alabama | 1047 | 8277 | 228 |
2242513 | 2242513 | 2022-02-23 | DeKalb | Alabama | 1049 | 18503 | 307 |
2242514 | 2242514 | 2022-02-23 | Elmore | Alabama | 1051 | 22819 | 324 |
2242515 | 2242515 | 2022-02-23 | Escambia | Alabama | 1053 | 9937 | 155 |
2242516 | 2242516 | 2022-02-23 | Etowah | Alabama | 1055 | 28625 | 585 |
2242517 | 2242517 | 2022-02-23 | Fayette | Alabama | 1057 | 4687 | 92 |
2242518 | 2242518 | 2022-02-23 | Franklin | Alabama | 1059 | 9779 | 129 |
2242519 | 2242519 | 2022-02-23 | Geneva | Alabama | 1061 | 6156 | 149 |
2242520 | 2242520 | 2022-02-23 | Greene | Alabama | 1063 | 1848 | 48 |
2242521 | 2242521 | 2022-02-23 | Hale | Alabama | 1065 | 4655 | 98 |
2242522 | 2242522 | 2022-02-23 | Henry | Alabama | 1067 | 4422 | 69 |
2242523 | 2242523 | 2022-02-23 | Houston | Alabama | 1069 | 24787 | 469 |
2242524 | 2242524 | 2022-02-23 | Jackson | Alabama | 1071 | 14872 | 221 |
2242525 | 2242525 | 2022-02-23 | Jefferson | Alabama | 1073 | 181521 | 2182 |
2242526 | 2242526 | 2022-02-23 | Lamar | Alabama | 1075 | 3598 | 63 |
2242527 | 2242527 | 2022-02-23 | Lauderdale | Alabama | 1077 | 23828 | 364 |
2242528 | 2242528 | 2022-02-23 | Lawrence | Alabama | 1079 | 7515 | 148 |
2242529 | 2242529 | 2022-02-23 | Lee | Alabama | 1081 | 37472 | 300 |
2242530 | 2242530 | 2022-02-23 | Limestone | Alabama | 1083 | 24559 | 260 |
2242531 | 2242531 | 2022-02-23 | Lowndes | Alabama | 1085 | 2595 | 70 |
2242532 | 2242532 | 2022-02-23 | Macon | Alabama | 1087 | 3825 | 74 |
2242533 | 2242533 | 2022-02-23 | Madison | Alabama | 1089 | 87846 | 869 |
2242534 | 2242534 | 2022-02-23 | Marengo | Alabama | 1091 | 5142 | 103 |
2242535 | 2242535 | 2022-02-23 | Marion | Alabama | 1093 | 7942 | 141 |
2242536 | 2242536 | 2022-02-23 | Marshall | Alabama | 1095 | 27068 | 362 |
2242537 | 2242537 | 2022-02-23 | Mobile | Alabama | 1097 | 111585 | 1548 |
2242538 | 2242538 | 2022-02-23 | Monroe | Alabama | 1099 | 5250 | 75 |
2242539 | 2242539 | 2022-02-23 | Montgomery | Alabama | 1101 | 54240 | 856 |
2242540 | 2242540 | 2022-02-23 | Morgan | Alabama | 1103 | 35682 | 474 |
2242541 | 2242541 | 2022-02-23 | Perry | Alabama | 1105 | 2078 | 43 |
2242542 | 2242542 | 2022-02-23 | Pickens | Alabama | 1107 | 5114 | 96 |
2242543 | 2242543 | 2022-02-23 | Pike | Alabama | 1109 | 7399 | 122 |
2242544 | 2242544 | 2022-02-23 | Randolph | Alabama | 1111 | 5035 | 72 |
2242545 | 2242545 | 2022-02-23 | Russell | Alabama | 1113 | 9969 | 78 |
2242546 | 2242546 | 2022-02-23 | Shelby | Alabama | 1117 | 58605 | 413 |
2242547 | 2242547 | 2022-02-23 | St. Clair | Alabama | 1115 | 24891 | 387 |
2242548 | 2242548 | 2022-02-23 | Sumter | Alabama | 1119 | 2526 | 45 |
2242549 | 2242549 | 2022-02-23 | Talladega | Alabama | 1121 | 21865 | 343 |
2242550 | 2242550 | 2022-02-23 | Tallapoosa | Alabama | 1123 | 11270 | 220 |
2242551 | 2242551 | 2022-02-23 | Tuscaloosa | Alabama | 1125 | 54247 | 716 |
2242552 | 2242552 | 2022-02-23 | Walker | Alabama | 1127 | 18407 | 411 |
2242553 | 2242553 | 2022-02-23 | Washington | Alabama | 1129 | 3663 | 54 |
2242554 | 2242554 | 2022-02-23 | Wilcox | Alabama | 1131 | 2849 | 42 |
2242555 | 2242555 | 2022-02-23 | Winston | Alabama | 1133 | 7500 | 117 |
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);