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-06-10 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1404148 | 1404148 | 2021-06-10 | Autauga | Alabama | 1001 | 7211 | 113 |
1404149 | 1404149 | 2021-06-10 | Baldwin | Alabama | 1003 | 21765 | 313 |
1404150 | 1404150 | 2021-06-10 | Barbour | Alabama | 1005 | 2345 | 59 |
1404151 | 1404151 | 2021-06-10 | Bibb | Alabama | 1007 | 2671 | 64 |
1404152 | 1404152 | 2021-06-10 | Blount | Alabama | 1009 | 6921 | 139 |
1404153 | 1404153 | 2021-06-10 | Bullock | Alabama | 1011 | 1243 | 42 |
1404154 | 1404154 | 2021-06-10 | Butler | Alabama | 1013 | 2230 | 71 |
1404155 | 1404155 | 2021-06-10 | Calhoun | Alabama | 1015 | 14692 | 325 |
1404156 | 1404156 | 2021-06-10 | Chambers | Alabama | 1017 | 3716 | 124 |
1404157 | 1404157 | 2021-06-10 | Cherokee | Alabama | 1019 | 1872 | 45 |
1404158 | 1404158 | 2021-06-10 | Chilton | Alabama | 1021 | 4458 | 116 |
1404159 | 1404159 | 2021-06-10 | Choctaw | Alabama | 1023 | 617 | 25 |
1404160 | 1404160 | 2021-06-10 | Clarke | Alabama | 1025 | 3525 | 61 |
1404161 | 1404161 | 2021-06-10 | Clay | Alabama | 1027 | 1593 | 59 |
1404162 | 1404162 | 2021-06-10 | Cleburne | Alabama | 1029 | 1524 | 43 |
1404163 | 1404163 | 2021-06-10 | Coffee | Alabama | 1031 | 5617 | 125 |
1404164 | 1404164 | 2021-06-10 | Colbert | Alabama | 1033 | 6392 | 139 |
1404165 | 1404165 | 2021-06-10 | Conecuh | Alabama | 1035 | 1130 | 30 |
1404166 | 1404166 | 2021-06-10 | Coosa | Alabama | 1037 | 1107 | 29 |
1404167 | 1404167 | 2021-06-10 | Covington | Alabama | 1039 | 4256 | 121 |
1404168 | 1404168 | 2021-06-10 | Crenshaw | Alabama | 1041 | 1552 | 57 |
1404169 | 1404169 | 2021-06-10 | Cullman | Alabama | 1043 | 9919 | 200 |
1404170 | 1404170 | 2021-06-10 | Dale | Alabama | 1045 | 4929 | 114 |
1404171 | 1404171 | 2021-06-10 | Dallas | Alabama | 1047 | 3603 | 154 |
1404172 | 1404172 | 2021-06-10 | DeKalb | Alabama | 1049 | 8953 | 188 |
1404173 | 1404173 | 2021-06-10 | Elmore | Alabama | 1051 | 10300 | 211 |
1404174 | 1404174 | 2021-06-10 | Escambia | Alabama | 1053 | 3997 | 80 |
1404175 | 1404175 | 2021-06-10 | Etowah | Alabama | 1055 | 14130 | 361 |
1404176 | 1404176 | 2021-06-10 | Fayette | Alabama | 1057 | 2163 | 62 |
1404177 | 1404177 | 2021-06-10 | Franklin | Alabama | 1059 | 4306 | 83 |
1404178 | 1404178 | 2021-06-10 | Geneva | Alabama | 1061 | 2569 | 81 |
1404179 | 1404179 | 2021-06-10 | Greene | Alabama | 1063 | 934 | 34 |
1404180 | 1404180 | 2021-06-10 | Hale | Alabama | 1065 | 2262 | 78 |
1404181 | 1404181 | 2021-06-10 | Henry | Alabama | 1067 | 1938 | 43 |
1404182 | 1404182 | 2021-06-10 | Houston | Alabama | 1069 | 10739 | 287 |
1404183 | 1404183 | 2021-06-10 | Jackson | Alabama | 1071 | 6901 | 113 |
1404184 | 1404184 | 2021-06-10 | Jefferson | Alabama | 1073 | 80745 | 1560 |
1404185 | 1404185 | 2021-06-10 | Lamar | Alabama | 1075 | 1458 | 37 |
1404186 | 1404186 | 2021-06-10 | Lauderdale | Alabama | 1077 | 9578 | 248 |
1404187 | 1404187 | 2021-06-10 | Lawrence | Alabama | 1079 | 3118 | 100 |
1404188 | 1404188 | 2021-06-10 | Lee | Alabama | 1081 | 16227 | 174 |
1404189 | 1404189 | 2021-06-10 | Limestone | Alabama | 1083 | 10178 | 157 |
1404190 | 1404190 | 2021-06-10 | Lowndes | Alabama | 1085 | 1420 | 54 |
1404191 | 1404191 | 2021-06-10 | Macon | Alabama | 1087 | 1631 | 51 |
1404192 | 1404192 | 2021-06-10 | Madison | Alabama | 1089 | 35604 | 522 |
1404193 | 1404193 | 2021-06-10 | Marengo | Alabama | 1091 | 2505 | 65 |
1404194 | 1404194 | 2021-06-10 | Marion | Alabama | 1093 | 3237 | 105 |
1404195 | 1404195 | 2021-06-10 | Marshall | Alabama | 1095 | 12439 | 228 |
1404196 | 1404196 | 2021-06-10 | Mobile | Alabama | 1097 | 41913 | 826 |
1404197 | 1404197 | 2021-06-10 | Monroe | Alabama | 1099 | 1790 | 41 |
1404198 | 1404198 | 2021-06-10 | Montgomery | Alabama | 1101 | 25065 | 609 |
1404199 | 1404199 | 2021-06-10 | Morgan | Alabama | 1103 | 14604 | 284 |
1404200 | 1404200 | 2021-06-10 | Perry | Alabama | 1105 | 1087 | 26 |
1404201 | 1404201 | 2021-06-10 | Pickens | Alabama | 1107 | 2364 | 62 |
1404202 | 1404202 | 2021-06-10 | Pike | Alabama | 1109 | 3139 | 78 |
1404203 | 1404203 | 2021-06-10 | Randolph | Alabama | 1111 | 1865 | 43 |
1404204 | 1404204 | 2021-06-10 | Russell | Alabama | 1113 | 4539 | 41 |
1404205 | 1404205 | 2021-06-10 | Shelby | Alabama | 1117 | 25554 | 254 |
1404206 | 1404206 | 2021-06-10 | St. Clair | Alabama | 1115 | 10142 | 250 |
1404207 | 1404207 | 2021-06-10 | Sumter | Alabama | 1119 | 1057 | 32 |
1404208 | 1404208 | 2021-06-10 | Talladega | Alabama | 1121 | 8439 | 183 |
1404209 | 1404209 | 2021-06-10 | Tallapoosa | Alabama | 1123 | 4114 | 155 |
1404210 | 1404210 | 2021-06-10 | Tuscaloosa | Alabama | 1125 | 26119 | 457 |
1404211 | 1404211 | 2021-06-10 | Walker | Alabama | 1127 | 7316 | 279 |
1404212 | 1404212 | 2021-06-10 | Washington | Alabama | 1129 | 1704 | 39 |
1404213 | 1404213 | 2021-06-10 | Wilcox | Alabama | 1131 | 1270 | 30 |
1404214 | 1404214 | 2021-06-10 | Winston | Alabama | 1133 | 2834 | 73 |
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);