ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-11-16" 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 |
---|---|---|---|---|---|---|---|
1920594 | 1920594 | 2021-11-16 | Autauga | Alabama | 1001 | 10419 | 154 |
1920595 | 1920595 | 2021-11-16 | Baldwin | Alabama | 1003 | 37891 | 583 |
1920596 | 1920596 | 2021-11-16 | Barbour | Alabama | 1005 | 3653 | 79 |
1920597 | 1920597 | 2021-11-16 | Bibb | Alabama | 1007 | 4323 | 92 |
1920598 | 1920598 | 2021-11-16 | Blount | Alabama | 1009 | 10548 | 188 |
1920599 | 1920599 | 2021-11-16 | Bullock | Alabama | 1011 | 1524 | 44 |
1920600 | 1920600 | 2021-11-16 | Butler | Alabama | 1013 | 3393 | 100 |
1920601 | 1920601 | 2021-11-16 | Calhoun | Alabama | 1015 | 22506 | 515 |
1920602 | 1920602 | 2021-11-16 | Chambers | Alabama | 1017 | 5810 | 145 |
1920603 | 1920603 | 2021-11-16 | Cherokee | Alabama | 1019 | 3124 | 62 |
1920604 | 1920604 | 2021-11-16 | Chilton | Alabama | 1021 | 6923 | 169 |
1920605 | 1920605 | 2021-11-16 | Choctaw | Alabama | 1023 | 923 | 28 |
1920606 | 1920606 | 2021-11-16 | Clarke | Alabama | 1025 | 4826 | 86 |
1920607 | 1920607 | 2021-11-16 | Clay | Alabama | 1027 | 2496 | 69 |
1920608 | 1920608 | 2021-11-16 | Cleburne | Alabama | 1029 | 2528 | 60 |
1920609 | 1920609 | 2021-11-16 | Coffee | Alabama | 1031 | 9374 | 191 |
1920610 | 1920610 | 2021-11-16 | Colbert | Alabama | 1033 | 9244 | 207 |
1920611 | 1920611 | 2021-11-16 | Conecuh | Alabama | 1035 | 1914 | 60 |
1920612 | 1920612 | 2021-11-16 | Coosa | Alabama | 1037 | 1822 | 43 |
1920613 | 1920613 | 2021-11-16 | Covington | Alabama | 1039 | 6858 | 191 |
1920614 | 1920614 | 2021-11-16 | Crenshaw | Alabama | 1041 | 2569 | 75 |
1920615 | 1920615 | 2021-11-16 | Cullman | Alabama | 1043 | 15918 | 299 |
1920616 | 1920616 | 2021-11-16 | Dale | Alabama | 1045 | 8998 | 190 |
1920617 | 1920617 | 2021-11-16 | Dallas | Alabama | 1047 | 5269 | 207 |
1920618 | 1920618 | 2021-11-16 | DeKalb | Alabama | 1049 | 12817 | 268 |
1920619 | 1920619 | 2021-11-16 | Elmore | Alabama | 1051 | 15871 | 294 |
1920620 | 1920620 | 2021-11-16 | Escambia | Alabama | 1053 | 6921 | 139 |
1920621 | 1920621 | 2021-11-16 | Etowah | Alabama | 1055 | 19977 | 517 |
1920622 | 1920622 | 2021-11-16 | Fayette | Alabama | 1057 | 3227 | 85 |
1920623 | 1920623 | 2021-11-16 | Franklin | Alabama | 1059 | 6231 | 108 |
1920624 | 1920624 | 2021-11-16 | Geneva | Alabama | 1061 | 4621 | 134 |
1920625 | 1920625 | 2021-11-16 | Greene | Alabama | 1063 | 1296 | 45 |
1920626 | 1920626 | 2021-11-16 | Hale | Alabama | 1065 | 3157 | 89 |
1920627 | 1920627 | 2021-11-16 | Henry | Alabama | 1067 | 3183 | 66 |
1920628 | 1920628 | 2021-11-16 | Houston | Alabama | 1069 | 17651 | 420 |
1920629 | 1920629 | 2021-11-16 | Jackson | Alabama | 1071 | 10140 | 194 |
1920630 | 1920630 | 2021-11-16 | Jefferson | Alabama | 1073 | 116006 | 1999 |
1920631 | 1920631 | 2021-11-16 | Lamar | Alabama | 1075 | 2458 | 52 |
1920632 | 1920632 | 2021-11-16 | Lauderdale | Alabama | 1077 | 14843 | 306 |
1920633 | 1920633 | 2021-11-16 | Lawrence | Alabama | 1079 | 4727 | 126 |
1920634 | 1920634 | 2021-11-16 | Lee | Alabama | 1081 | 25436 | 259 |
1920635 | 1920635 | 2021-11-16 | Limestone | Alabama | 1083 | 16031 | 217 |
1920636 | 1920636 | 2021-11-16 | Lowndes | Alabama | 1085 | 1779 | 67 |
1920637 | 1920637 | 2021-11-16 | Macon | Alabama | 1087 | 2439 | 64 |
1920638 | 1920638 | 2021-11-16 | Madison | Alabama | 1089 | 52999 | 724 |
1920639 | 1920639 | 2021-11-16 | Marengo | Alabama | 1091 | 3420 | 92 |
1920640 | 1920640 | 2021-11-16 | Marion | Alabama | 1093 | 5366 | 128 |
1920641 | 1920641 | 2021-11-16 | Marshall | Alabama | 1095 | 18725 | 317 |
1920642 | 1920642 | 2021-11-16 | Mobile | Alabama | 1097 | 73825 | 1374 |
1920643 | 1920643 | 2021-11-16 | Monroe | Alabama | 1099 | 3352 | 66 |
1920644 | 1920644 | 2021-11-16 | Montgomery | Alabama | 1101 | 34406 | 780 |
1920645 | 1920645 | 2021-11-16 | Morgan | Alabama | 1103 | 22272 | 401 |
1920646 | 1920646 | 2021-11-16 | Perry | Alabama | 1105 | 1416 | 40 |
1920647 | 1920647 | 2021-11-16 | Pickens | Alabama | 1107 | 3312 | 85 |
1920648 | 1920648 | 2021-11-16 | Pike | Alabama | 1109 | 5066 | 108 |
1920649 | 1920649 | 2021-11-16 | Randolph | Alabama | 1111 | 3333 | 67 |
1920650 | 1920650 | 2021-11-16 | Russell | Alabama | 1113 | 7042 | 64 |
1920651 | 1920651 | 2021-11-16 | Shelby | Alabama | 1117 | 38122 | 365 |
1920652 | 1920652 | 2021-11-16 | St. Clair | Alabama | 1115 | 16795 | 354 |
1920653 | 1920653 | 2021-11-16 | Sumter | Alabama | 1119 | 1365 | 40 |
1920654 | 1920654 | 2021-11-16 | Talladega | Alabama | 1121 | 14091 | 297 |
1920655 | 1920655 | 2021-11-16 | Tallapoosa | Alabama | 1123 | 7219 | 202 |
1920656 | 1920656 | 2021-11-16 | Tuscaloosa | Alabama | 1125 | 35768 | 636 |
1920657 | 1920657 | 2021-11-16 | Walker | Alabama | 1127 | 11883 | 377 |
1920658 | 1920658 | 2021-11-16 | Washington | Alabama | 1129 | 2552 | 52 |
1920659 | 1920659 | 2021-11-16 | Wilcox | Alabama | 1131 | 1743 | 38 |
1920660 | 1920660 | 2021-11-16 | Winston | Alabama | 1133 | 4759 | 106 |
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);