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-02-17 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1037277 | 1037277 | 2021-02-17 | Autauga | Alabama | 1001 | 6050 | 84 |
1037278 | 1037278 | 2021-02-17 | Baldwin | Alabama | 1003 | 19267 | 253 |
1037279 | 1037279 | 2021-02-17 | Barbour | Alabama | 1005 | 2053 | 49 |
1037280 | 1037280 | 2021-02-17 | Bibb | Alabama | 1007 | 2399 | 57 |
1037281 | 1037281 | 2021-02-17 | Blount | Alabama | 1009 | 5997 | 121 |
1037282 | 1037282 | 2021-02-17 | Bullock | Alabama | 1011 | 1143 | 33 |
1037283 | 1037283 | 2021-02-17 | Butler | Alabama | 1013 | 1924 | 64 |
1037284 | 1037284 | 2021-02-17 | Calhoun | Alabama | 1015 | 12784 | 264 |
1037285 | 1037285 | 2021-02-17 | Chambers | Alabama | 1017 | 3338 | 98 |
1037286 | 1037286 | 2021-02-17 | Cherokee | Alabama | 1019 | 1750 | 37 |
1037287 | 1037287 | 2021-02-17 | Chilton | Alabama | 1021 | 3750 | 92 |
1037288 | 1037288 | 2021-02-17 | Choctaw | Alabama | 1023 | 544 | 23 |
1037289 | 1037289 | 2021-02-17 | Clarke | Alabama | 1025 | 3413 | 47 |
1037290 | 1037290 | 2021-02-17 | Clay | Alabama | 1027 | 1403 | 53 |
1037291 | 1037291 | 2021-02-17 | Cleburne | Alabama | 1029 | 1341 | 35 |
1037292 | 1037292 | 2021-02-17 | Coffee | Alabama | 1031 | 5169 | 91 |
1037293 | 1037293 | 2021-02-17 | Colbert | Alabama | 1033 | 5931 | 117 |
1037294 | 1037294 | 2021-02-17 | Conecuh | Alabama | 1035 | 1058 | 23 |
1037295 | 1037295 | 2021-02-17 | Coosa | Alabama | 1037 | 843 | 22 |
1037296 | 1037296 | 2021-02-17 | Covington | Alabama | 1039 | 3877 | 98 |
1037297 | 1037297 | 2021-02-17 | Crenshaw | Alabama | 1041 | 1409 | 51 |
1037298 | 1037298 | 2021-02-17 | Cullman | Alabama | 1043 | 8805 | 171 |
1037299 | 1037299 | 2021-02-17 | Dale | Alabama | 1045 | 4549 | 105 |
1037300 | 1037300 | 2021-02-17 | Dallas | Alabama | 1047 | 3307 | 133 |
1037301 | 1037301 | 2021-02-17 | DeKalb | Alabama | 1049 | 8373 | 170 |
1037302 | 1037302 | 2021-02-17 | Elmore | Alabama | 1051 | 9155 | 170 |
1037303 | 1037303 | 2021-02-17 | Escambia | Alabama | 1053 | 3719 | 59 |
1037304 | 1037304 | 2021-02-17 | Etowah | Alabama | 1055 | 12995 | 300 |
1037305 | 1037305 | 2021-02-17 | Fayette | Alabama | 1057 | 1957 | 54 |
1037306 | 1037306 | 2021-02-17 | Franklin | Alabama | 1059 | 3949 | 75 |
1037307 | 1037307 | 2021-02-17 | Geneva | Alabama | 1061 | 2363 | 66 |
1037308 | 1037308 | 2021-02-17 | Greene | Alabama | 1063 | 857 | 32 |
1037309 | 1037309 | 2021-02-17 | Hale | Alabama | 1065 | 2031 | 62 |
1037310 | 1037310 | 2021-02-17 | Henry | Alabama | 1067 | 1792 | 40 |
1037311 | 1037311 | 2021-02-17 | Houston | Alabama | 1069 | 9947 | 251 |
1037312 | 1037312 | 2021-02-17 | Jackson | Alabama | 1071 | 6416 | 93 |
1037313 | 1037313 | 2021-02-17 | Jefferson | Alabama | 1073 | 69808 | 1308 |
1037314 | 1037314 | 2021-02-17 | Lamar | Alabama | 1075 | 1282 | 32 |
1037315 | 1037315 | 2021-02-17 | Lauderdale | Alabama | 1077 | 8480 | 205 |
1037316 | 1037316 | 2021-02-17 | Lawrence | Alabama | 1079 | 2781 | 85 |
1037317 | 1037317 | 2021-02-17 | Lee | Alabama | 1081 | 14684 | 141 |
1037318 | 1037318 | 2021-02-17 | Limestone | Alabama | 1083 | 9201 | 127 |
1037319 | 1037319 | 2021-02-17 | Lowndes | Alabama | 1085 | 1296 | 44 |
1037320 | 1037320 | 2021-02-17 | Macon | Alabama | 1087 | 1381 | 41 |
1037321 | 1037321 | 2021-02-17 | Madison | Alabama | 1089 | 31664 | 411 |
1037322 | 1037322 | 2021-02-17 | Marengo | Alabama | 1091 | 2281 | 52 |
1037323 | 1037323 | 2021-02-17 | Marion | Alabama | 1093 | 2716 | 91 |
1037324 | 1037324 | 2021-02-17 | Marshall | Alabama | 1095 | 11121 | 195 |
1037325 | 1037325 | 2021-02-17 | Mobile | Alabama | 1097 | 35054 | 688 |
1037326 | 1037326 | 2021-02-17 | Monroe | Alabama | 1099 | 1646 | 37 |
1037327 | 1037327 | 2021-02-17 | Montgomery | Alabama | 1101 | 22087 | 469 |
1037328 | 1037328 | 2021-02-17 | Morgan | Alabama | 1103 | 13424 | 237 |
1037329 | 1037329 | 2021-02-17 | Perry | Alabama | 1105 | 1046 | 26 |
1037330 | 1037330 | 2021-02-17 | Pickens | Alabama | 1107 | 2196 | 50 |
1037331 | 1037331 | 2021-02-17 | Pike | Alabama | 1109 | 2896 | 70 |
1037332 | 1037332 | 2021-02-17 | Randolph | Alabama | 1111 | 1594 | 38 |
1037333 | 1037333 | 2021-02-17 | Russell | Alabama | 1113 | 3953 | 30 |
1037334 | 1037334 | 2021-02-17 | Shelby | Alabama | 1117 | 21406 | 197 |
1037335 | 1037335 | 2021-02-17 | St. Clair | Alabama | 1115 | 8647 | 211 |
1037336 | 1037336 | 2021-02-17 | Sumter | Alabama | 1119 | 973 | 31 |
1037337 | 1037337 | 2021-02-17 | Talladega | Alabama | 1121 | 7326 | 153 |
1037338 | 1037338 | 2021-02-17 | Tallapoosa | Alabama | 1123 | 3458 | 137 |
1037339 | 1037339 | 2021-02-17 | Tuscaloosa | Alabama | 1125 | 23562 | 394 |
1037340 | 1037340 | 2021-02-17 | Walker | Alabama | 1127 | 6384 | 236 |
1037341 | 1037341 | 2021-02-17 | Washington | Alabama | 1129 | 1533 | 31 |
1037342 | 1037342 | 2021-02-17 | Wilcox | Alabama | 1131 | 1197 | 24 |
1037343 | 1037343 | 2021-02-17 | Winston | Alabama | 1133 | 2432 | 62 |
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);