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-11-30 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1966103 | 1966103 | 2021-11-30 | Autauga | Alabama | 1001 | 10526 | 157 |
1966104 | 1966104 | 2021-11-30 | Baldwin | Alabama | 1003 | 38104 | 589 |
1966105 | 1966105 | 2021-11-30 | Barbour | Alabama | 1005 | 3699 | 80 |
1966106 | 1966106 | 2021-11-30 | Bibb | Alabama | 1007 | 4345 | 94 |
1966107 | 1966107 | 2021-11-30 | Blount | Alabama | 1009 | 10729 | 192 |
1966108 | 1966108 | 2021-11-30 | Bullock | Alabama | 1011 | 1525 | 45 |
1966109 | 1966109 | 2021-11-30 | Butler | Alabama | 1013 | 3439 | 100 |
1966110 | 1966110 | 2021-11-30 | Calhoun | Alabama | 1015 | 22598 | 518 |
1966111 | 1966111 | 2021-11-30 | Chambers | Alabama | 1017 | 5785 | 142 |
1966112 | 1966112 | 2021-11-30 | Cherokee | Alabama | 1019 | 3183 | 63 |
1966113 | 1966113 | 2021-11-30 | Chilton | Alabama | 1021 | 7042 | 170 |
1966114 | 1966114 | 2021-11-30 | Choctaw | Alabama | 1023 | 932 | 28 |
1966115 | 1966115 | 2021-11-30 | Clarke | Alabama | 1025 | 4848 | 86 |
1966116 | 1966116 | 2021-11-30 | Clay | Alabama | 1027 | 2511 | 69 |
1966117 | 1966117 | 2021-11-30 | Cleburne | Alabama | 1029 | 2545 | 60 |
1966118 | 1966118 | 2021-11-30 | Coffee | Alabama | 1031 | 9425 | 192 |
1966119 | 1966119 | 2021-11-30 | Colbert | Alabama | 1033 | 9341 | 208 |
1966120 | 1966120 | 2021-11-30 | Conecuh | Alabama | 1035 | 1931 | 62 |
1966121 | 1966121 | 2021-11-30 | Coosa | Alabama | 1037 | 1855 | 47 |
1966122 | 1966122 | 2021-11-30 | Covington | Alabama | 1039 | 6943 | 195 |
1966123 | 1966123 | 2021-11-30 | Crenshaw | Alabama | 1041 | 2607 | 77 |
1966124 | 1966124 | 2021-11-30 | Cullman | Alabama | 1043 | 16067 | 303 |
1966125 | 1966125 | 2021-11-30 | Dale | Alabama | 1045 | 9024 | 192 |
1966126 | 1966126 | 2021-11-30 | Dallas | Alabama | 1047 | 5295 | 209 |
1966127 | 1966127 | 2021-11-30 | DeKalb | Alabama | 1049 | 12985 | 269 |
1966128 | 1966128 | 2021-11-30 | Elmore | Alabama | 1051 | 15912 | 294 |
1966129 | 1966129 | 2021-11-30 | Escambia | Alabama | 1053 | 6956 | 143 |
1966130 | 1966130 | 2021-11-30 | Etowah | Alabama | 1055 | 20026 | 518 |
1966131 | 1966131 | 2021-11-30 | Fayette | Alabama | 1057 | 3300 | 85 |
1966132 | 1966132 | 2021-11-30 | Franklin | Alabama | 1059 | 6338 | 108 |
1966133 | 1966133 | 2021-11-30 | Geneva | Alabama | 1061 | 4643 | 136 |
1966134 | 1966134 | 2021-11-30 | Greene | Alabama | 1063 | 1302 | 45 |
1966135 | 1966135 | 2021-11-30 | Hale | Alabama | 1065 | 3184 | 89 |
1966136 | 1966136 | 2021-11-30 | Henry | Alabama | 1067 | 3207 | 66 |
1966137 | 1966137 | 2021-11-30 | Houston | Alabama | 1069 | 17741 | 425 |
1966138 | 1966138 | 2021-11-30 | Jackson | Alabama | 1071 | 10170 | 194 |
1966139 | 1966139 | 2021-11-30 | Jefferson | Alabama | 1073 | 116186 | 2004 |
1966140 | 1966140 | 2021-11-30 | Lamar | Alabama | 1075 | 2519 | 53 |
1966141 | 1966141 | 2021-11-30 | Lauderdale | Alabama | 1077 | 14991 | 306 |
1966142 | 1966142 | 2021-11-30 | Lawrence | Alabama | 1079 | 4831 | 129 |
1966143 | 1966143 | 2021-11-30 | Lee | Alabama | 1081 | 25590 | 263 |
1966144 | 1966144 | 2021-11-30 | Limestone | Alabama | 1083 | 16153 | 219 |
1966145 | 1966145 | 2021-11-30 | Lowndes | Alabama | 1085 | 1782 | 68 |
1966146 | 1966146 | 2021-11-30 | Macon | Alabama | 1087 | 2450 | 64 |
1966147 | 1966147 | 2021-11-30 | Madison | Alabama | 1089 | 53315 | 732 |
1966148 | 1966148 | 2021-11-30 | Marengo | Alabama | 1091 | 3423 | 93 |
1966149 | 1966149 | 2021-11-30 | Marion | Alabama | 1093 | 5413 | 130 |
1966150 | 1966150 | 2021-11-30 | Marshall | Alabama | 1095 | 18790 | 316 |
1966151 | 1966151 | 2021-11-30 | Mobile | Alabama | 1097 | 74241 | 1381 |
1966152 | 1966152 | 2021-11-30 | Monroe | Alabama | 1099 | 3374 | 66 |
1966153 | 1966153 | 2021-11-30 | Montgomery | Alabama | 1101 | 34492 | 781 |
1966154 | 1966154 | 2021-11-30 | Morgan | Alabama | 1103 | 22459 | 406 |
1966155 | 1966155 | 2021-11-30 | Perry | Alabama | 1105 | 1418 | 40 |
1966156 | 1966156 | 2021-11-30 | Pickens | Alabama | 1107 | 3339 | 88 |
1966157 | 1966157 | 2021-11-30 | Pike | Alabama | 1109 | 5123 | 109 |
1966158 | 1966158 | 2021-11-30 | Randolph | Alabama | 1111 | 3348 | 67 |
1966159 | 1966159 | 2021-11-30 | Russell | Alabama | 1113 | 7088 | 65 |
1966160 | 1966160 | 2021-11-30 | Shelby | Alabama | 1117 | 38351 | 369 |
1966161 | 1966161 | 2021-11-30 | St. Clair | Alabama | 1115 | 16904 | 358 |
1966162 | 1966162 | 2021-11-30 | Sumter | Alabama | 1119 | 1392 | 41 |
1966163 | 1966163 | 2021-11-30 | Talladega | Alabama | 1121 | 14209 | 299 |
1966164 | 1966164 | 2021-11-30 | Tallapoosa | Alabama | 1123 | 7273 | 201 |
1966165 | 1966165 | 2021-11-30 | Tuscaloosa | Alabama | 1125 | 36052 | 641 |
1966166 | 1966166 | 2021-11-30 | Walker | Alabama | 1127 | 12067 | 380 |
1966167 | 1966167 | 2021-11-30 | Washington | Alabama | 1129 | 2569 | 52 |
1966168 | 1966168 | 2021-11-30 | Wilcox | Alabama | 1131 | 1776 | 38 |
1966169 | 1966169 | 2021-11-30 | Winston | Alabama | 1133 | 4780 | 110 |
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);