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-10-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 |
---|---|---|---|---|---|---|---|
1852356 | 1852356 | 2021-10-26 | Autauga | Alabama | 1001 | 10061 | 148 |
1852357 | 1852357 | 2021-10-26 | Baldwin | Alabama | 1003 | 37285 | 552 |
1852358 | 1852358 | 2021-10-26 | Barbour | Alabama | 1005 | 3583 | 76 |
1852359 | 1852359 | 2021-10-26 | Bibb | Alabama | 1007 | 4256 | 86 |
1852360 | 1852360 | 2021-10-26 | Blount | Alabama | 1009 | 10227 | 176 |
1852361 | 1852361 | 2021-10-26 | Bullock | Alabama | 1011 | 1518 | 44 |
1852362 | 1852362 | 2021-10-26 | Butler | Alabama | 1013 | 3285 | 96 |
1852363 | 1852363 | 2021-10-26 | Calhoun | Alabama | 1015 | 22255 | 490 |
1852364 | 1852364 | 2021-10-26 | Chambers | Alabama | 1017 | 5615 | 142 |
1852365 | 1852365 | 2021-10-26 | Cherokee | Alabama | 1019 | 3032 | 60 |
1852366 | 1852366 | 2021-10-26 | Chilton | Alabama | 1021 | 6658 | 162 |
1852367 | 1852367 | 2021-10-26 | Choctaw | Alabama | 1023 | 885 | 27 |
1852368 | 1852368 | 2021-10-26 | Clarke | Alabama | 1025 | 4772 | 84 |
1852369 | 1852369 | 2021-10-26 | Clay | Alabama | 1027 | 2455 | 68 |
1852370 | 1852370 | 2021-10-26 | Cleburne | Alabama | 1029 | 2479 | 60 |
1852371 | 1852371 | 2021-10-26 | Coffee | Alabama | 1031 | 9215 | 191 |
1852372 | 1852372 | 2021-10-26 | Colbert | Alabama | 1033 | 8907 | 201 |
1852373 | 1852373 | 2021-10-26 | Conecuh | Alabama | 1035 | 1866 | 54 |
1852374 | 1852374 | 2021-10-26 | Coosa | Alabama | 1037 | 1809 | 40 |
1852375 | 1852375 | 2021-10-26 | Covington | Alabama | 1039 | 6724 | 183 |
1852376 | 1852376 | 2021-10-26 | Crenshaw | Alabama | 1041 | 2454 | 75 |
1852377 | 1852377 | 2021-10-26 | Cullman | Alabama | 1043 | 15493 | 293 |
1852378 | 1852378 | 2021-10-26 | Dale | Alabama | 1045 | 8912 | 186 |
1852379 | 1852379 | 2021-10-26 | Dallas | Alabama | 1047 | 5013 | 202 |
1852380 | 1852380 | 2021-10-26 | DeKalb | Alabama | 1049 | 12670 | 261 |
1852381 | 1852381 | 2021-10-26 | Elmore | Alabama | 1051 | 15292 | 286 |
1852382 | 1852382 | 2021-10-26 | Escambia | Alabama | 1053 | 6782 | 134 |
1852383 | 1852383 | 2021-10-26 | Etowah | Alabama | 1055 | 19844 | 500 |
1852384 | 1852384 | 2021-10-26 | Fayette | Alabama | 1057 | 2945 | 80 |
1852385 | 1852385 | 2021-10-26 | Franklin | Alabama | 1059 | 5992 | 105 |
1852386 | 1852386 | 2021-10-26 | Geneva | Alabama | 1061 | 4577 | 127 |
1852387 | 1852387 | 2021-10-26 | Greene | Alabama | 1063 | 1267 | 44 |
1852388 | 1852388 | 2021-10-26 | Hale | Alabama | 1065 | 3119 | 88 |
1852389 | 1852389 | 2021-10-26 | Henry | Alabama | 1067 | 3131 | 66 |
1852390 | 1852390 | 2021-10-26 | Houston | Alabama | 1069 | 17406 | 412 |
1852391 | 1852391 | 2021-10-26 | Jackson | Alabama | 1071 | 9909 | 185 |
1852392 | 1852392 | 2021-10-26 | Jefferson | Alabama | 1073 | 114905 | 1930 |
1852393 | 1852393 | 2021-10-26 | Lamar | Alabama | 1075 | 2257 | 47 |
1852394 | 1852394 | 2021-10-26 | Lauderdale | Alabama | 1077 | 14366 | 295 |
1852395 | 1852395 | 2021-10-26 | Lawrence | Alabama | 1079 | 4352 | 117 |
1852396 | 1852396 | 2021-10-26 | Lee | Alabama | 1081 | 23556 | 246 |
1852397 | 1852397 | 2021-10-26 | Limestone | Alabama | 1083 | 15402 | 199 |
1852398 | 1852398 | 2021-10-26 | Lowndes | Alabama | 1085 | 1757 | 64 |
1852399 | 1852399 | 2021-10-26 | Macon | Alabama | 1087 | 2355 | 63 |
1852400 | 1852400 | 2021-10-26 | Madison | Alabama | 1089 | 52400 | 699 |
1852401 | 1852401 | 2021-10-26 | Marengo | Alabama | 1091 | 3383 | 90 |
1852402 | 1852402 | 2021-10-26 | Marion | Alabama | 1093 | 5016 | 127 |
1852403 | 1852403 | 2021-10-26 | Marshall | Alabama | 1095 | 18390 | 304 |
1852404 | 1852404 | 2021-10-26 | Mobile | Alabama | 1097 | 72665 | 1340 |
1852405 | 1852405 | 2021-10-26 | Monroe | Alabama | 1099 | 3320 | 64 |
1852406 | 1852406 | 2021-10-26 | Montgomery | Alabama | 1101 | 34130 | 740 |
1852407 | 1852407 | 2021-10-26 | Morgan | Alabama | 1103 | 21037 | 378 |
1852408 | 1852408 | 2021-10-26 | Perry | Alabama | 1105 | 1392 | 40 |
1852409 | 1852409 | 2021-10-26 | Pickens | Alabama | 1107 | 3173 | 84 |
1852410 | 1852410 | 2021-10-26 | Pike | Alabama | 1109 | 4799 | 106 |
1852411 | 1852411 | 2021-10-26 | Randolph | Alabama | 1111 | 3302 | 64 |
1852412 | 1852412 | 2021-10-26 | Russell | Alabama | 1113 | 6376 | 59 |
1852413 | 1852413 | 2021-10-26 | Shelby | Alabama | 1117 | 37685 | 350 |
1852414 | 1852414 | 2021-10-26 | St. Clair | Alabama | 1115 | 16091 | 339 |
1852415 | 1852415 | 2021-10-26 | Sumter | Alabama | 1119 | 1333 | 38 |
1852416 | 1852416 | 2021-10-26 | Talladega | Alabama | 1121 | 13870 | 283 |
1852417 | 1852417 | 2021-10-26 | Tallapoosa | Alabama | 1123 | 7103 | 198 |
1852418 | 1852418 | 2021-10-26 | Tuscaloosa | Alabama | 1125 | 35147 | 613 |
1852419 | 1852419 | 2021-10-26 | Walker | Alabama | 1127 | 11255 | 370 |
1852420 | 1852420 | 2021-10-26 | Washington | Alabama | 1129 | 2516 | 51 |
1852421 | 1852421 | 2021-10-26 | Wilcox | Alabama | 1131 | 1691 | 39 |
1852422 | 1852422 | 2021-10-26 | Winston | Alabama | 1133 | 4538 | 103 |
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);