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-06-08 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
218423 | 218423 | 2020-06-08 | Autauga | Alabama | 1001 | 273 | 5 |
218424 | 218424 | 2020-06-08 | Baldwin | Alabama | 1003 | 335 | 9 |
218425 | 218425 | 2020-06-08 | Barbour | Alabama | 1005 | 198 | 1 |
218426 | 218426 | 2020-06-08 | Bibb | Alabama | 1007 | 82 | 1 |
218427 | 218427 | 2020-06-08 | Blount | Alabama | 1009 | 75 | 1 |
218428 | 218428 | 2020-06-08 | Bullock | Alabama | 1011 | 240 | 9 |
218429 | 218429 | 2020-06-08 | Butler | Alabama | 1013 | 457 | 24 |
218430 | 218430 | 2020-06-08 | Calhoun | Alabama | 1015 | 186 | 3 |
218431 | 218431 | 2020-06-08 | Chambers | Alabama | 1017 | 395 | 26 |
218432 | 218432 | 2020-06-08 | Cherokee | Alabama | 1019 | 43 | 4 |
218433 | 218433 | 2020-06-08 | Chilton | Alabama | 1021 | 116 | 2 |
218434 | 218434 | 2020-06-08 | Choctaw | Alabama | 1023 | 157 | 10 |
218435 | 218435 | 2020-06-08 | Clarke | Alabama | 1025 | 159 | 3 |
218436 | 218436 | 2020-06-08 | Clay | Alabama | 1027 | 29 | 2 |
218437 | 218437 | 2020-06-08 | Cleburne | Alabama | 1029 | 19 | 1 |
218438 | 218438 | 2020-06-08 | Coffee | Alabama | 1031 | 251 | 1 |
218439 | 218439 | 2020-06-08 | Colbert | Alabama | 1033 | 217 | 4 |
218440 | 218440 | 2020-06-08 | Conecuh | Alabama | 1035 | 54 | 1 |
218441 | 218441 | 2020-06-08 | Coosa | Alabama | 1037 | 40 | 1 |
218442 | 218442 | 2020-06-08 | Covington | Alabama | 1039 | 93 | 1 |
218443 | 218443 | 2020-06-08 | Crenshaw | Alabama | 1041 | 91 | 3 |
218444 | 218444 | 2020-06-08 | Cullman | Alabama | 1043 | 204 | 1 |
218445 | 218445 | 2020-06-08 | Dale | Alabama | 1045 | 137 | 0 |
218446 | 218446 | 2020-06-08 | Dallas | Alabama | 1047 | 341 | 4 |
218447 | 218447 | 2020-06-08 | DeKalb | Alabama | 1049 | 276 | 3 |
218448 | 218448 | 2020-06-08 | Elmore | Alabama | 1051 | 438 | 10 |
218449 | 218449 | 2020-06-08 | Escambia | Alabama | 1053 | 88 | 3 |
218450 | 218450 | 2020-06-08 | Etowah | Alabama | 1055 | 280 | 12 |
218451 | 218451 | 2020-06-08 | Fayette | Alabama | 1057 | 21 | 0 |
218452 | 218452 | 2020-06-08 | Franklin | Alabama | 1059 | 628 | 10 |
218453 | 218453 | 2020-06-08 | Geneva | Alabama | 1061 | 46 | 0 |
218454 | 218454 | 2020-06-08 | Greene | Alabama | 1063 | 99 | 5 |
218455 | 218455 | 2020-06-08 | Hale | Alabama | 1065 | 211 | 11 |
218456 | 218456 | 2020-06-08 | Henry | Alabama | 1067 | 89 | 2 |
218457 | 218457 | 2020-06-08 | Houston | Alabama | 1069 | 256 | 5 |
218458 | 218458 | 2020-06-08 | Jackson | Alabama | 1071 | 97 | 3 |
218459 | 218459 | 2020-06-08 | Jefferson | Alabama | 1073 | 2109 | 110 |
218460 | 218460 | 2020-06-08 | Lamar | Alabama | 1075 | 30 | 0 |
218461 | 218461 | 2020-06-08 | Lauderdale | Alabama | 1077 | 189 | 3 |
218462 | 218462 | 2020-06-08 | Lawrence | Alabama | 1079 | 56 | 0 |
218463 | 218463 | 2020-06-08 | Lee | Alabama | 1081 | 610 | 34 |
218464 | 218464 | 2020-06-08 | Limestone | Alabama | 1083 | 137 | 0 |
218465 | 218465 | 2020-06-08 | Lowndes | Alabama | 1085 | 294 | 14 |
218466 | 218466 | 2020-06-08 | Macon | Alabama | 1087 | 101 | 5 |
218467 | 218467 | 2020-06-08 | Madison | Alabama | 1089 | 407 | 5 |
218468 | 218468 | 2020-06-08 | Marengo | Alabama | 1091 | 188 | 6 |
218469 | 218469 | 2020-06-08 | Marion | Alabama | 1093 | 130 | 11 |
218470 | 218470 | 2020-06-08 | Marshall | Alabama | 1095 | 748 | 9 |
218471 | 218471 | 2020-06-08 | Mobile | Alabama | 1097 | 2478 | 124 |
218472 | 218472 | 2020-06-08 | Monroe | Alabama | 1099 | 62 | 2 |
218473 | 218473 | 2020-06-08 | Montgomery | Alabama | 1101 | 2158 | 55 |
218474 | 218474 | 2020-06-08 | Morgan | Alabama | 1103 | 401 | 1 |
218475 | 218475 | 2020-06-08 | Perry | Alabama | 1105 | 50 | 0 |
218476 | 218476 | 2020-06-08 | Pickens | Alabama | 1107 | 125 | 6 |
218477 | 218477 | 2020-06-08 | Pike | Alabama | 1109 | 252 | 1 |
218478 | 218478 | 2020-06-08 | Randolph | Alabama | 1111 | 135 | 8 |
218479 | 218479 | 2020-06-08 | Russell | Alabama | 1113 | 214 | 0 |
218480 | 218480 | 2020-06-08 | Shelby | Alabama | 1117 | 573 | 19 |
218481 | 218481 | 2020-06-08 | St. Clair | Alabama | 1115 | 149 | 2 |
218482 | 218482 | 2020-06-08 | Sumter | Alabama | 1119 | 248 | 9 |
218483 | 218483 | 2020-06-08 | Talladega | Alabama | 1121 | 139 | 5 |
218484 | 218484 | 2020-06-08 | Tallapoosa | Alabama | 1123 | 451 | 67 |
218485 | 218485 | 2020-06-08 | Tuscaloosa | Alabama | 1125 | 948 | 23 |
218486 | 218486 | 2020-06-08 | Walker | Alabama | 1127 | 470 | 5 |
218487 | 218487 | 2020-06-08 | Washington | Alabama | 1129 | 81 | 6 |
218488 | 218488 | 2020-06-08 | Wilcox | Alabama | 1131 | 175 | 7 |
218489 | 218489 | 2020-06-08 | Winston | Alabama | 1133 | 96 | 0 |
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);