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-10-19 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 |
---|---|---|---|---|---|---|---|
1829610 | 1829610 | 2021-10-19 | Autauga | Alabama | 1001 | 9909 | 146 |
1829611 | 1829611 | 2021-10-19 | Baldwin | Alabama | 1003 | 37127 | 543 |
1829612 | 1829612 | 2021-10-19 | Barbour | Alabama | 1005 | 3563 | 76 |
1829613 | 1829613 | 2021-10-19 | Bibb | Alabama | 1007 | 4232 | 86 |
1829614 | 1829614 | 2021-10-19 | Blount | Alabama | 1009 | 10113 | 175 |
1829615 | 1829615 | 2021-10-19 | Bullock | Alabama | 1011 | 1517 | 44 |
1829616 | 1829616 | 2021-10-19 | Butler | Alabama | 1013 | 3250 | 94 |
1829617 | 1829617 | 2021-10-19 | Calhoun | Alabama | 1015 | 22180 | 476 |
1829618 | 1829618 | 2021-10-19 | Chambers | Alabama | 1017 | 5562 | 142 |
1829619 | 1829619 | 2021-10-19 | Cherokee | Alabama | 1019 | 3009 | 58 |
1829620 | 1829620 | 2021-10-19 | Chilton | Alabama | 1021 | 6602 | 160 |
1829621 | 1829621 | 2021-10-19 | Choctaw | Alabama | 1023 | 870 | 27 |
1829622 | 1829622 | 2021-10-19 | Clarke | Alabama | 1025 | 4749 | 82 |
1829623 | 1829623 | 2021-10-19 | Clay | Alabama | 1027 | 2411 | 68 |
1829624 | 1829624 | 2021-10-19 | Cleburne | Alabama | 1029 | 2469 | 60 |
1829625 | 1829625 | 2021-10-19 | Coffee | Alabama | 1031 | 9185 | 191 |
1829626 | 1829626 | 2021-10-19 | Colbert | Alabama | 1033 | 8803 | 201 |
1829627 | 1829627 | 2021-10-19 | Conecuh | Alabama | 1035 | 1857 | 53 |
1829628 | 1829628 | 2021-10-19 | Coosa | Alabama | 1037 | 1792 | 38 |
1829629 | 1829629 | 2021-10-19 | Covington | Alabama | 1039 | 6692 | 183 |
1829630 | 1829630 | 2021-10-19 | Crenshaw | Alabama | 1041 | 2439 | 75 |
1829631 | 1829631 | 2021-10-19 | Cullman | Alabama | 1043 | 15354 | 291 |
1829632 | 1829632 | 2021-10-19 | Dale | Alabama | 1045 | 8873 | 184 |
1829633 | 1829633 | 2021-10-19 | Dallas | Alabama | 1047 | 4899 | 199 |
1829634 | 1829634 | 2021-10-19 | DeKalb | Alabama | 1049 | 12584 | 260 |
1829635 | 1829635 | 2021-10-19 | Elmore | Alabama | 1051 | 15110 | 284 |
1829636 | 1829636 | 2021-10-19 | Escambia | Alabama | 1053 | 6750 | 129 |
1829637 | 1829637 | 2021-10-19 | Etowah | Alabama | 1055 | 19764 | 497 |
1829638 | 1829638 | 2021-10-19 | Fayette | Alabama | 1057 | 2912 | 79 |
1829639 | 1829639 | 2021-10-19 | Franklin | Alabama | 1059 | 5943 | 105 |
1829640 | 1829640 | 2021-10-19 | Geneva | Alabama | 1061 | 4567 | 126 |
1829641 | 1829641 | 2021-10-19 | Greene | Alabama | 1063 | 1258 | 44 |
1829642 | 1829642 | 2021-10-19 | Hale | Alabama | 1065 | 3102 | 88 |
1829643 | 1829643 | 2021-10-19 | Henry | Alabama | 1067 | 3117 | 65 |
1829644 | 1829644 | 2021-10-19 | Houston | Alabama | 1069 | 17324 | 409 |
1829645 | 1829645 | 2021-10-19 | Jackson | Alabama | 1071 | 9808 | 182 |
1829646 | 1829646 | 2021-10-19 | Jefferson | Alabama | 1073 | 114391 | 1913 |
1829647 | 1829647 | 2021-10-19 | Lamar | Alabama | 1075 | 2188 | 46 |
1829648 | 1829648 | 2021-10-19 | Lauderdale | Alabama | 1077 | 14178 | 294 |
1829649 | 1829649 | 2021-10-19 | Lawrence | Alabama | 1079 | 4280 | 117 |
1829650 | 1829650 | 2021-10-19 | Lee | Alabama | 1081 | 23168 | 244 |
1829651 | 1829651 | 2021-10-19 | Limestone | Alabama | 1083 | 15258 | 198 |
1829652 | 1829652 | 2021-10-19 | Lowndes | Alabama | 1085 | 1743 | 62 |
1829653 | 1829653 | 2021-10-19 | Macon | Alabama | 1087 | 2312 | 62 |
1829654 | 1829654 | 2021-10-19 | Madison | Alabama | 1089 | 52078 | 689 |
1829655 | 1829655 | 2021-10-19 | Marengo | Alabama | 1091 | 3341 | 89 |
1829656 | 1829656 | 2021-10-19 | Marion | Alabama | 1093 | 4961 | 126 |
1829657 | 1829657 | 2021-10-19 | Marshall | Alabama | 1095 | 18265 | 302 |
1829658 | 1829658 | 2021-10-19 | Mobile | Alabama | 1097 | 72337 | 1328 |
1829659 | 1829659 | 2021-10-19 | Monroe | Alabama | 1099 | 3307 | 62 |
1829660 | 1829660 | 2021-10-19 | Montgomery | Alabama | 1101 | 34013 | 728 |
1829661 | 1829661 | 2021-10-19 | Morgan | Alabama | 1103 | 20693 | 374 |
1829662 | 1829662 | 2021-10-19 | Perry | Alabama | 1105 | 1382 | 40 |
1829663 | 1829663 | 2021-10-19 | Pickens | Alabama | 1107 | 3140 | 82 |
1829664 | 1829664 | 2021-10-19 | Pike | Alabama | 1109 | 4722 | 105 |
1829665 | 1829665 | 2021-10-19 | Randolph | Alabama | 1111 | 3279 | 63 |
1829666 | 1829666 | 2021-10-19 | Russell | Alabama | 1113 | 6265 | 58 |
1829667 | 1829667 | 2021-10-19 | Shelby | Alabama | 1117 | 37458 | 346 |
1829668 | 1829668 | 2021-10-19 | St. Clair | Alabama | 1115 | 15953 | 339 |
1829669 | 1829669 | 2021-10-19 | Sumter | Alabama | 1119 | 1313 | 38 |
1829670 | 1829670 | 2021-10-19 | Talladega | Alabama | 1121 | 13752 | 276 |
1829671 | 1829671 | 2021-10-19 | Tallapoosa | Alabama | 1123 | 7059 | 197 |
1829672 | 1829672 | 2021-10-19 | Tuscaloosa | Alabama | 1125 | 34997 | 605 |
1829673 | 1829673 | 2021-10-19 | Walker | Alabama | 1127 | 11119 | 368 |
1829674 | 1829674 | 2021-10-19 | Washington | Alabama | 1129 | 2511 | 51 |
1829675 | 1829675 | 2021-10-19 | Wilcox | Alabama | 1131 | 1677 | 38 |
1829676 | 1829676 | 2021-10-19 | Winston | Alabama | 1133 | 4488 | 103 |
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);