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-03-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 |
---|---|---|---|---|---|---|---|
1108685 | 1108685 | 2021-03-11 | Autauga | Alabama | 1001 | 6409 | 95 |
1108686 | 1108686 | 2021-03-11 | Baldwin | Alabama | 1003 | 20044 | 294 |
1108687 | 1108687 | 2021-03-11 | Barbour | Alabama | 1005 | 2171 | 52 |
1108688 | 1108688 | 2021-03-11 | Bibb | Alabama | 1007 | 2474 | 58 |
1108689 | 1108689 | 2021-03-11 | Blount | Alabama | 1009 | 6274 | 129 |
1108690 | 1108690 | 2021-03-11 | Bullock | Alabama | 1011 | 1181 | 39 |
1108691 | 1108691 | 2021-03-11 | Butler | Alabama | 1013 | 2035 | 66 |
1108692 | 1108692 | 2021-03-11 | Calhoun | Alabama | 1015 | 14007 | 297 |
1108693 | 1108693 | 2021-03-11 | Chambers | Alabama | 1017 | 3438 | 113 |
1108694 | 1108694 | 2021-03-11 | Cherokee | Alabama | 1019 | 1785 | 42 |
1108695 | 1108695 | 2021-03-11 | Chilton | Alabama | 1021 | 3944 | 105 |
1108696 | 1108696 | 2021-03-11 | Choctaw | Alabama | 1023 | 566 | 23 |
1108697 | 1108697 | 2021-03-11 | Clarke | Alabama | 1025 | 3455 | 55 |
1108698 | 1108698 | 2021-03-11 | Clay | Alabama | 1027 | 1466 | 54 |
1108699 | 1108699 | 2021-03-11 | Cleburne | Alabama | 1029 | 1409 | 41 |
1108700 | 1108700 | 2021-03-11 | Coffee | Alabama | 1031 | 5285 | 104 |
1108701 | 1108701 | 2021-03-11 | Colbert | Alabama | 1033 | 6018 | 124 |
1108702 | 1108702 | 2021-03-11 | Conecuh | Alabama | 1035 | 1074 | 24 |
1108703 | 1108703 | 2021-03-11 | Coosa | Alabama | 1037 | 908 | 24 |
1108704 | 1108704 | 2021-03-11 | Covington | Alabama | 1039 | 4006 | 108 |
1108705 | 1108705 | 2021-03-11 | Crenshaw | Alabama | 1041 | 1483 | 55 |
1108706 | 1108706 | 2021-03-11 | Cullman | Alabama | 1043 | 9048 | 183 |
1108707 | 1108707 | 2021-03-11 | Dale | Alabama | 1045 | 4697 | 108 |
1108708 | 1108708 | 2021-03-11 | Dallas | Alabama | 1047 | 3445 | 143 |
1108709 | 1108709 | 2021-03-11 | DeKalb | Alabama | 1049 | 8543 | 178 |
1108710 | 1108710 | 2021-03-11 | Elmore | Alabama | 1051 | 9611 | 192 |
1108711 | 1108711 | 2021-03-11 | Escambia | Alabama | 1053 | 3807 | 73 |
1108712 | 1108712 | 2021-03-11 | Etowah | Alabama | 1055 | 13467 | 332 |
1108713 | 1108713 | 2021-03-11 | Fayette | Alabama | 1057 | 2033 | 58 |
1108714 | 1108714 | 2021-03-11 | Franklin | Alabama | 1059 | 4042 | 82 |
1108715 | 1108715 | 2021-03-11 | Geneva | Alabama | 1061 | 2414 | 71 |
1108716 | 1108716 | 2021-03-11 | Greene | Alabama | 1063 | 889 | 32 |
1108717 | 1108717 | 2021-03-11 | Hale | Alabama | 1065 | 2130 | 72 |
1108718 | 1108718 | 2021-03-11 | Henry | Alabama | 1067 | 1839 | 41 |
1108719 | 1108719 | 2021-03-11 | Houston | Alabama | 1069 | 10180 | 266 |
1108720 | 1108720 | 2021-03-11 | Jackson | Alabama | 1071 | 6568 | 105 |
1108721 | 1108721 | 2021-03-11 | Jefferson | Alabama | 1073 | 72484 | 1417 |
1108722 | 1108722 | 2021-03-11 | Lamar | Alabama | 1075 | 1351 | 33 |
1108723 | 1108723 | 2021-03-11 | Lauderdale | Alabama | 1077 | 8662 | 214 |
1108724 | 1108724 | 2021-03-11 | Lawrence | Alabama | 1079 | 2869 | 92 |
1108725 | 1108725 | 2021-03-11 | Lee | Alabama | 1081 | 15117 | 162 |
1108726 | 1108726 | 2021-03-11 | Limestone | Alabama | 1083 | 9471 | 142 |
1108727 | 1108727 | 2021-03-11 | Lowndes | Alabama | 1085 | 1338 | 51 |
1108728 | 1108728 | 2021-03-11 | Macon | Alabama | 1087 | 1486 | 45 |
1108729 | 1108729 | 2021-03-11 | Madison | Alabama | 1089 | 32818 | 478 |
1108730 | 1108730 | 2021-03-11 | Marengo | Alabama | 1091 | 2459 | 58 |
1108731 | 1108731 | 2021-03-11 | Marion | Alabama | 1093 | 2939 | 97 |
1108732 | 1108732 | 2021-03-11 | Marshall | Alabama | 1095 | 11488 | 216 |
1108733 | 1108733 | 2021-03-11 | Mobile | Alabama | 1097 | 36598 | 749 |
1108734 | 1108734 | 2021-03-11 | Monroe | Alabama | 1099 | 1671 | 39 |
1108735 | 1108735 | 2021-03-11 | Montgomery | Alabama | 1101 | 22926 | 530 |
1108736 | 1108736 | 2021-03-11 | Morgan | Alabama | 1103 | 13845 | 258 |
1108737 | 1108737 | 2021-03-11 | Perry | Alabama | 1105 | 1072 | 27 |
1108738 | 1108738 | 2021-03-11 | Pickens | Alabama | 1107 | 2271 | 57 |
1108739 | 1108739 | 2021-03-11 | Pike | Alabama | 1109 | 2949 | 74 |
1108740 | 1108740 | 2021-03-11 | Randolph | Alabama | 1111 | 1670 | 41 |
1108741 | 1108741 | 2021-03-11 | Russell | Alabama | 1113 | 4103 | 34 |
1108742 | 1108742 | 2021-03-11 | Shelby | Alabama | 1117 | 22417 | 226 |
1108743 | 1108743 | 2021-03-11 | St. Clair | Alabama | 1115 | 9115 | 229 |
1108744 | 1108744 | 2021-03-11 | Sumter | Alabama | 1119 | 1013 | 31 |
1108745 | 1108745 | 2021-03-11 | Talladega | Alabama | 1121 | 7686 | 167 |
1108746 | 1108746 | 2021-03-11 | Tallapoosa | Alabama | 1123 | 3668 | 143 |
1108747 | 1108747 | 2021-03-11 | Tuscaloosa | Alabama | 1125 | 24532 | 428 |
1108748 | 1108748 | 2021-03-11 | Walker | Alabama | 1127 | 6680 | 266 |
1108749 | 1108749 | 2021-03-11 | Washington | Alabama | 1129 | 1579 | 38 |
1108750 | 1108750 | 2021-03-11 | Wilcox | Alabama | 1131 | 1242 | 26 |
1108751 | 1108751 | 2021-03-11 | Winston | Alabama | 1133 | 2599 | 68 |
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);