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 2022-03-26 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2343310 | 2343310 | 2022-03-26 | Autauga | Alabama | 1001 | 15611 | 209 |
2343311 | 2343311 | 2022-03-26 | Baldwin | Alabama | 1003 | 55373 | 674 |
2343312 | 2343312 | 2022-03-26 | Barbour | Alabama | 1005 | 5478 | 97 |
2343313 | 2343313 | 2022-03-26 | Bibb | Alabama | 1007 | 6415 | 101 |
2343314 | 2343314 | 2022-03-26 | Blount | Alabama | 1009 | 14896 | 233 |
2343315 | 2343315 | 2022-03-26 | Bullock | Alabama | 1011 | 2283 | 52 |
2343316 | 2343316 | 2022-03-26 | Butler | Alabama | 1013 | 5048 | 127 |
2343317 | 2343317 | 2022-03-26 | Calhoun | Alabama | 1015 | 32344 | 614 |
2343318 | 2343318 | 2022-03-26 | Chambers | Alabama | 1017 | 8464 | 161 |
2343319 | 2343319 | 2022-03-26 | Cherokee | Alabama | 1019 | 5107 | 85 |
2343320 | 2343320 | 2022-03-26 | Chilton | Alabama | 1021 | 11022 | 201 |
2343321 | 2343321 | 2022-03-26 | Choctaw | Alabama | 1023 | 2044 | 36 |
2343322 | 2343322 | 2022-03-26 | Clarke | Alabama | 1025 | 7089 | 98 |
2343323 | 2343323 | 2022-03-26 | Clay | Alabama | 1027 | 4085 | 81 |
2343324 | 2343324 | 2022-03-26 | Cleburne | Alabama | 1029 | 3557 | 69 |
2343325 | 2343325 | 2022-03-26 | Coffee | Alabama | 1031 | 13344 | 230 |
2343326 | 2343326 | 2022-03-26 | Colbert | Alabama | 1033 | 16272 | 255 |
2343327 | 2343327 | 2022-03-26 | Conecuh | Alabama | 1035 | 2852 | 71 |
2343328 | 2343328 | 2022-03-26 | Coosa | Alabama | 1037 | 2950 | 58 |
2343329 | 2343329 | 2022-03-26 | Covington | Alabama | 1039 | 9277 | 226 |
2343330 | 2343330 | 2022-03-26 | Crenshaw | Alabama | 1041 | 3787 | 98 |
2343331 | 2343331 | 2022-03-26 | Cullman | Alabama | 1043 | 24495 | 364 |
2343332 | 2343332 | 2022-03-26 | Dale | Alabama | 1045 | 12502 | 227 |
2343333 | 2343333 | 2022-03-26 | Dallas | Alabama | 1047 | 8379 | 241 |
2343334 | 2343334 | 2022-03-26 | DeKalb | Alabama | 1049 | 18735 | 323 |
2343335 | 2343335 | 2022-03-26 | Elmore | Alabama | 1051 | 22968 | 340 |
2343336 | 2343336 | 2022-03-26 | Escambia | Alabama | 1053 | 9983 | 168 |
2343337 | 2343337 | 2022-03-26 | Etowah | Alabama | 1055 | 28768 | 638 |
2343338 | 2343338 | 2022-03-26 | Fayette | Alabama | 1057 | 4972 | 94 |
2343339 | 2343339 | 2022-03-26 | Franklin | Alabama | 1059 | 9851 | 137 |
2343340 | 2343340 | 2022-03-26 | Geneva | Alabama | 1061 | 6286 | 163 |
2343341 | 2343341 | 2022-03-26 | Greene | Alabama | 1063 | 1866 | 48 |
2343342 | 2343342 | 2022-03-26 | Hale | Alabama | 1065 | 4697 | 104 |
2343343 | 2343343 | 2022-03-26 | Henry | Alabama | 1067 | 4451 | 74 |
2343344 | 2343344 | 2022-03-26 | Houston | Alabama | 1069 | 25010 | 496 |
2343345 | 2343345 | 2022-03-26 | Jackson | Alabama | 1071 | 15015 | 234 |
2343346 | 2343346 | 2022-03-26 | Jefferson | Alabama | 1073 | 184302 | 2318 |
2343347 | 2343347 | 2022-03-26 | Lamar | Alabama | 1075 | 3712 | 63 |
2343348 | 2343348 | 2022-03-26 | Lauderdale | Alabama | 1077 | 24054 | 386 |
2343349 | 2343349 | 2022-03-26 | Lawrence | Alabama | 1079 | 7641 | 154 |
2343350 | 2343350 | 2022-03-26 | Lee | Alabama | 1081 | 37611 | 331 |
2343351 | 2343351 | 2022-03-26 | Limestone | Alabama | 1083 | 24842 | 287 |
2343352 | 2343352 | 2022-03-26 | Lowndes | Alabama | 1085 | 2609 | 75 |
2343353 | 2343353 | 2022-03-26 | Macon | Alabama | 1087 | 3857 | 83 |
2343354 | 2343354 | 2022-03-26 | Madison | Alabama | 1089 | 88960 | 943 |
2343355 | 2343355 | 2022-03-26 | Marengo | Alabama | 1091 | 5169 | 107 |
2343356 | 2343356 | 2022-03-26 | Marion | Alabama | 1093 | 8070 | 151 |
2343357 | 2343357 | 2022-03-26 | Marshall | Alabama | 1095 | 27323 | 388 |
2343358 | 2343358 | 2022-03-26 | Mobile | Alabama | 1097 | 113046 | 1617 |
2343359 | 2343359 | 2022-03-26 | Monroe | Alabama | 1099 | 5265 | 80 |
2343360 | 2343360 | 2022-03-26 | Montgomery | Alabama | 1101 | 54653 | 925 |
2343361 | 2343361 | 2022-03-26 | Morgan | Alabama | 1103 | 35969 | 506 |
2343362 | 2343362 | 2022-03-26 | Perry | Alabama | 1105 | 2091 | 44 |
2343363 | 2343363 | 2022-03-26 | Pickens | Alabama | 1107 | 5243 | 101 |
2343364 | 2343364 | 2022-03-26 | Pike | Alabama | 1109 | 7428 | 133 |
2343365 | 2343365 | 2022-03-26 | Randolph | Alabama | 1111 | 5078 | 74 |
2343366 | 2343366 | 2022-03-26 | Russell | Alabama | 1113 | 10029 | 86 |
2343367 | 2343367 | 2022-03-26 | Shelby | Alabama | 1117 | 60410 | 441 |
2343368 | 2343368 | 2022-03-26 | St. Clair | Alabama | 1115 | 25220 | 411 |
2343369 | 2343369 | 2022-03-26 | Sumter | Alabama | 1119 | 2570 | 49 |
2343370 | 2343370 | 2022-03-26 | Talladega | Alabama | 1121 | 22271 | 371 |
2343371 | 2343371 | 2022-03-26 | Tallapoosa | Alabama | 1123 | 11370 | 232 |
2343372 | 2343372 | 2022-03-26 | Tuscaloosa | Alabama | 1125 | 55736 | 758 |
2343373 | 2343373 | 2022-03-26 | Walker | Alabama | 1127 | 18536 | 436 |
2343374 | 2343374 | 2022-03-26 | Washington | Alabama | 1129 | 3725 | 59 |
2343375 | 2343375 | 2022-03-26 | Wilcox | Alabama | 1131 | 2873 | 46 |
2343376 | 2343376 | 2022-03-26 | Winston | Alabama | 1133 | 7569 | 128 |
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);