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-05-13 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1313255 | 1313255 | 2021-05-13 | Autauga | Alabama | 1001 | 6938 | 108 |
1313256 | 1313256 | 2021-05-13 | Baldwin | Alabama | 1003 | 21191 | 309 |
1313257 | 1313257 | 2021-05-13 | Barbour | Alabama | 1005 | 2317 | 56 |
1313258 | 1313258 | 2021-05-13 | Bibb | Alabama | 1007 | 2615 | 64 |
1313259 | 1313259 | 2021-05-13 | Blount | Alabama | 1009 | 6694 | 137 |
1313260 | 1313260 | 2021-05-13 | Bullock | Alabama | 1011 | 1228 | 41 |
1313261 | 1313261 | 2021-05-13 | Butler | Alabama | 1013 | 2164 | 69 |
1313262 | 1313262 | 2021-05-13 | Calhoun | Alabama | 1015 | 14522 | 316 |
1313263 | 1313263 | 2021-05-13 | Chambers | Alabama | 1017 | 3578 | 123 |
1313264 | 1313264 | 2021-05-13 | Cherokee | Alabama | 1019 | 1847 | 45 |
1313265 | 1313265 | 2021-05-13 | Chilton | Alabama | 1021 | 4308 | 112 |
1313266 | 1313266 | 2021-05-13 | Choctaw | Alabama | 1023 | 611 | 24 |
1313267 | 1313267 | 2021-05-13 | Clarke | Alabama | 1025 | 3511 | 61 |
1313268 | 1313268 | 2021-05-13 | Clay | Alabama | 1027 | 1568 | 57 |
1313269 | 1313269 | 2021-05-13 | Cleburne | Alabama | 1029 | 1491 | 41 |
1313270 | 1313270 | 2021-05-13 | Coffee | Alabama | 1031 | 5524 | 119 |
1313271 | 1313271 | 2021-05-13 | Colbert | Alabama | 1033 | 6310 | 134 |
1313272 | 1313272 | 2021-05-13 | Conecuh | Alabama | 1035 | 1106 | 29 |
1313273 | 1313273 | 2021-05-13 | Coosa | Alabama | 1037 | 1079 | 28 |
1313274 | 1313274 | 2021-05-13 | Covington | Alabama | 1039 | 4136 | 118 |
1313275 | 1313275 | 2021-05-13 | Crenshaw | Alabama | 1041 | 1527 | 57 |
1313276 | 1313276 | 2021-05-13 | Cullman | Alabama | 1043 | 9705 | 194 |
1313277 | 1313277 | 2021-05-13 | Dale | Alabama | 1045 | 4850 | 111 |
1313278 | 1313278 | 2021-05-13 | Dallas | Alabama | 1047 | 3557 | 152 |
1313279 | 1313279 | 2021-05-13 | DeKalb | Alabama | 1049 | 8846 | 187 |
1313280 | 1313280 | 2021-05-13 | Elmore | Alabama | 1051 | 10060 | 205 |
1313281 | 1313281 | 2021-05-13 | Escambia | Alabama | 1053 | 3939 | 77 |
1313282 | 1313282 | 2021-05-13 | Etowah | Alabama | 1055 | 13861 | 353 |
1313283 | 1313283 | 2021-05-13 | Fayette | Alabama | 1057 | 2125 | 62 |
1313284 | 1313284 | 2021-05-13 | Franklin | Alabama | 1059 | 4262 | 82 |
1313285 | 1313285 | 2021-05-13 | Geneva | Alabama | 1061 | 2514 | 77 |
1313286 | 1313286 | 2021-05-13 | Greene | Alabama | 1063 | 925 | 34 |
1313287 | 1313287 | 2021-05-13 | Hale | Alabama | 1065 | 2232 | 77 |
1313288 | 1313288 | 2021-05-13 | Henry | Alabama | 1067 | 1890 | 44 |
1313289 | 1313289 | 2021-05-13 | Houston | Alabama | 1069 | 10581 | 281 |
1313290 | 1313290 | 2021-05-13 | Jackson | Alabama | 1071 | 6815 | 112 |
1313291 | 1313291 | 2021-05-13 | Jefferson | Alabama | 1073 | 77143 | 1528 |
1313292 | 1313292 | 2021-05-13 | Lamar | Alabama | 1075 | 1429 | 35 |
1313293 | 1313293 | 2021-05-13 | Lauderdale | Alabama | 1077 | 9441 | 242 |
1313294 | 1313294 | 2021-05-13 | Lawrence | Alabama | 1079 | 3007 | 98 |
1313295 | 1313295 | 2021-05-13 | Lee | Alabama | 1081 | 15892 | 171 |
1313296 | 1313296 | 2021-05-13 | Limestone | Alabama | 1083 | 9986 | 151 |
1313297 | 1313297 | 2021-05-13 | Lowndes | Alabama | 1085 | 1390 | 53 |
1313298 | 1313298 | 2021-05-13 | Macon | Alabama | 1087 | 1599 | 50 |
1313299 | 1313299 | 2021-05-13 | Madison | Alabama | 1089 | 34837 | 505 |
1313300 | 1313300 | 2021-05-13 | Marengo | Alabama | 1091 | 2496 | 64 |
1313301 | 1313301 | 2021-05-13 | Marion | Alabama | 1093 | 3130 | 101 |
1313302 | 1313302 | 2021-05-13 | Marshall | Alabama | 1095 | 12250 | 223 |
1313303 | 1313303 | 2021-05-13 | Mobile | Alabama | 1097 | 41089 | 808 |
1313304 | 1313304 | 2021-05-13 | Monroe | Alabama | 1099 | 1780 | 40 |
1313305 | 1313305 | 2021-05-13 | Montgomery | Alabama | 1101 | 24355 | 588 |
1313306 | 1313306 | 2021-05-13 | Morgan | Alabama | 1103 | 14324 | 279 |
1313307 | 1313307 | 2021-05-13 | Perry | Alabama | 1105 | 1078 | 26 |
1313308 | 1313308 | 2021-05-13 | Pickens | Alabama | 1107 | 2347 | 61 |
1313309 | 1313309 | 2021-05-13 | Pike | Alabama | 1109 | 3113 | 77 |
1313310 | 1313310 | 2021-05-13 | Randolph | Alabama | 1111 | 1817 | 42 |
1313311 | 1313311 | 2021-05-13 | Russell | Alabama | 1113 | 4432 | 38 |
1313312 | 1313312 | 2021-05-13 | Shelby | Alabama | 1117 | 23730 | 249 |
1313313 | 1313313 | 2021-05-13 | St. Clair | Alabama | 1115 | 9702 | 243 |
1313314 | 1313314 | 2021-05-13 | Sumter | Alabama | 1119 | 1048 | 32 |
1313315 | 1313315 | 2021-05-13 | Talladega | Alabama | 1121 | 8255 | 176 |
1313316 | 1313316 | 2021-05-13 | Tallapoosa | Alabama | 1123 | 4039 | 152 |
1313317 | 1313317 | 2021-05-13 | Tuscaloosa | Alabama | 1125 | 25810 | 454 |
1313318 | 1313318 | 2021-05-13 | Walker | Alabama | 1127 | 7246 | 277 |
1313319 | 1313319 | 2021-05-13 | Washington | Alabama | 1129 | 1676 | 39 |
1313320 | 1313320 | 2021-05-13 | Wilcox | Alabama | 1131 | 1271 | 30 |
1313321 | 1313321 | 2021-05-13 | Winston | Alabama | 1133 | 2756 | 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);