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 2020-11-15 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732204 | 732204 | 2020-11-15 | Autauga | Alabama | 1001 | 2456 | 36 |
732205 | 732205 | 2020-11-15 | Baldwin | Alabama | 1003 | 7646 | 84 |
732206 | 732206 | 2020-11-15 | Barbour | Alabama | 1005 | 1128 | 9 |
732207 | 732207 | 2020-11-15 | Bibb | Alabama | 1007 | 986 | 17 |
732208 | 732208 | 2020-11-15 | Blount | Alabama | 1009 | 2549 | 34 |
732209 | 732209 | 2020-11-15 | Bullock | Alabama | 1011 | 677 | 19 |
732210 | 732210 | 2020-11-15 | Butler | Alabama | 1013 | 1087 | 41 |
732211 | 732211 | 2020-11-15 | Calhoun | Alabama | 1015 | 5608 | 77 |
732212 | 732212 | 2020-11-15 | Chambers | Alabama | 1017 | 1570 | 48 |
732213 | 732213 | 2020-11-15 | Cherokee | Alabama | 1019 | 908 | 15 |
732214 | 732214 | 2020-11-15 | Chilton | Alabama | 1021 | 2078 | 36 |
732215 | 732215 | 2020-11-15 | Choctaw | Alabama | 1023 | 411 | 12 |
732216 | 732216 | 2020-11-15 | Clarke | Alabama | 1025 | 1503 | 18 |
732217 | 732217 | 2020-11-15 | Clay | Alabama | 1027 | 850 | 13 |
732218 | 732218 | 2020-11-15 | Cleburne | Alabama | 1029 | 669 | 11 |
732219 | 732219 | 2020-11-15 | Coffee | Alabama | 1031 | 2170 | 14 |
732220 | 732220 | 2020-11-15 | Colbert | Alabama | 1033 | 2736 | 38 |
732221 | 732221 | 2020-11-15 | Conecuh | Alabama | 1035 | 645 | 14 |
732222 | 732222 | 2020-11-15 | Coosa | Alabama | 1037 | 269 | 3 |
732223 | 732223 | 2020-11-15 | Covington | Alabama | 1039 | 2039 | 32 |
732224 | 732224 | 2020-11-15 | Crenshaw | Alabama | 1041 | 675 | 30 |
732225 | 732225 | 2020-11-15 | Cullman | Alabama | 1043 | 3701 | 30 |
732226 | 732226 | 2020-11-15 | Dale | Alabama | 1045 | 2175 | 54 |
732227 | 732227 | 2020-11-15 | Dallas | Alabama | 1047 | 2062 | 28 |
732228 | 732228 | 2020-11-15 | DeKalb | Alabama | 1049 | 4209 | 34 |
732229 | 732229 | 2020-11-15 | Elmore | Alabama | 1051 | 3648 | 61 |
732230 | 732230 | 2020-11-15 | Escambia | Alabama | 1053 | 1881 | 31 |
732231 | 732231 | 2020-11-15 | Etowah | Alabama | 1055 | 5348 | 61 |
732232 | 732232 | 2020-11-15 | Fayette | Alabama | 1057 | 735 | 15 |
732233 | 732233 | 2020-11-15 | Franklin | Alabama | 1059 | 2336 | 33 |
732234 | 732234 | 2020-11-15 | Geneva | Alabama | 1061 | 1101 | 8 |
732235 | 732235 | 2020-11-15 | Greene | Alabama | 1063 | 375 | 17 |
732236 | 732236 | 2020-11-15 | Hale | Alabama | 1065 | 873 | 30 |
732237 | 732237 | 2020-11-15 | Henry | Alabama | 1067 | 815 | 6 |
732238 | 732238 | 2020-11-15 | Houston | Alabama | 1069 | 4761 | 37 |
732239 | 732239 | 2020-11-15 | Jackson | Alabama | 1071 | 2719 | 23 |
732240 | 732240 | 2020-11-15 | Jefferson | Alabama | 1073 | 27884 | 461 |
732241 | 732241 | 2020-11-15 | Lamar | Alabama | 1075 | 584 | 7 |
732242 | 732242 | 2020-11-15 | Lauderdale | Alabama | 1077 | 3298 | 51 |
732243 | 732243 | 2020-11-15 | Lawrence | Alabama | 1079 | 1076 | 35 |
732244 | 732244 | 2020-11-15 | Lee | Alabama | 1081 | 7212 | 65 |
732245 | 732245 | 2020-11-15 | Limestone | Alabama | 1083 | 3653 | 41 |
732246 | 732246 | 2020-11-15 | Lowndes | Alabama | 1085 | 760 | 29 |
732247 | 732247 | 2020-11-15 | Macon | Alabama | 1087 | 654 | 20 |
732248 | 732248 | 2020-11-15 | Madison | Alabama | 1089 | 11305 | 118 |
732249 | 732249 | 2020-11-15 | Marengo | Alabama | 1091 | 1132 | 24 |
732250 | 732250 | 2020-11-15 | Marion | Alabama | 1093 | 1276 | 32 |
732251 | 732251 | 2020-11-15 | Marshall | Alabama | 1095 | 5330 | 53 |
732252 | 732252 | 2020-11-15 | Mobile | Alabama | 1097 | 18524 | 339 |
732253 | 732253 | 2020-11-15 | Monroe | Alabama | 1099 | 732 | 10 |
732254 | 732254 | 2020-11-15 | Montgomery | Alabama | 1101 | 11596 | 224 |
732255 | 732255 | 2020-11-15 | Morgan | Alabama | 1103 | 5400 | 41 |
732256 | 732256 | 2020-11-15 | Perry | Alabama | 1105 | 639 | 6 |
732257 | 732257 | 2020-11-15 | Pickens | Alabama | 1107 | 1073 | 18 |
732258 | 732258 | 2020-11-15 | Pike | Alabama | 1109 | 1494 | 14 |
732259 | 732259 | 2020-11-15 | Randolph | Alabama | 1111 | 950 | 20 |
732260 | 732260 | 2020-11-15 | Russell | Alabama | 1113 | 2073 | 3 |
732261 | 732261 | 2020-11-15 | Shelby | Alabama | 1117 | 9011 | 73 |
732262 | 732262 | 2020-11-15 | St. Clair | Alabama | 1115 | 3736 | 55 |
732263 | 732263 | 2020-11-15 | Sumter | Alabama | 1119 | 533 | 21 |
732264 | 732264 | 2020-11-15 | Talladega | Alabama | 1121 | 3171 | 41 |
732265 | 732265 | 2020-11-15 | Tallapoosa | Alabama | 1123 | 1604 | 88 |
732266 | 732266 | 2020-11-15 | Tuscaloosa | Alabama | 1125 | 11810 | 148 |
732267 | 732267 | 2020-11-15 | Walker | Alabama | 1127 | 3294 | 96 |
732268 | 732268 | 2020-11-15 | Washington | Alabama | 1129 | 875 | 12 |
732269 | 732269 | 2020-11-15 | Wilcox | Alabama | 1131 | 606 | 12 |
732270 | 732270 | 2020-11-15 | Winston | Alabama | 1133 | 1138 | 22 |
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);