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-08-29 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
479440 | 479440 | 2020-08-29 | Autauga | Alabama | 1001 | 1400 | 23 |
479441 | 479441 | 2020-08-29 | Baldwin | Alabama | 1003 | 4424 | 40 |
479442 | 479442 | 2020-08-29 | Barbour | Alabama | 1005 | 753 | 7 |
479443 | 479443 | 2020-08-29 | Bibb | Alabama | 1007 | 540 | 7 |
479444 | 479444 | 2020-08-29 | Blount | Alabama | 1009 | 1248 | 9 |
479445 | 479445 | 2020-08-29 | Bullock | Alabama | 1011 | 546 | 14 |
479446 | 479446 | 2020-08-29 | Butler | Alabama | 1013 | 855 | 37 |
479447 | 479447 | 2020-08-29 | Calhoun | Alabama | 1015 | 2499 | 35 |
479448 | 479448 | 2020-08-29 | Chambers | Alabama | 1017 | 1024 | 40 |
479449 | 479449 | 2020-08-29 | Cherokee | Alabama | 1019 | 398 | 12 |
479450 | 479450 | 2020-08-29 | Chilton | Alabama | 1021 | 1135 | 13 |
479451 | 479451 | 2020-08-29 | Choctaw | Alabama | 1023 | 326 | 12 |
479452 | 479452 | 2020-08-29 | Clarke | Alabama | 1025 | 980 | 14 |
479453 | 479453 | 2020-08-29 | Clay | Alabama | 1027 | 360 | 6 |
479454 | 479454 | 2020-08-29 | Cleburne | Alabama | 1029 | 204 | 5 |
479455 | 479455 | 2020-08-29 | Coffee | Alabama | 1031 | 1065 | 7 |
479456 | 479456 | 2020-08-29 | Colbert | Alabama | 1033 | 1448 | 22 |
479457 | 479457 | 2020-08-29 | Conecuh | Alabama | 1035 | 483 | 11 |
479458 | 479458 | 2020-08-29 | Coosa | Alabama | 1037 | 133 | 3 |
479459 | 479459 | 2020-08-29 | Covington | Alabama | 1039 | 1088 | 26 |
479460 | 479460 | 2020-08-29 | Crenshaw | Alabama | 1041 | 462 | 27 |
479461 | 479461 | 2020-08-29 | Cullman | Alabama | 1043 | 1612 | 13 |
479462 | 479462 | 2020-08-29 | Dale | Alabama | 1045 | 1081 | 37 |
479463 | 479463 | 2020-08-29 | Dallas | Alabama | 1047 | 1601 | 25 |
479464 | 479464 | 2020-08-29 | DeKalb | Alabama | 1049 | 2136 | 16 |
479465 | 479465 | 2020-08-29 | Elmore | Alabama | 1051 | 2159 | 44 |
479466 | 479466 | 2020-08-29 | Escambia | Alabama | 1053 | 1396 | 22 |
479467 | 479467 | 2020-08-29 | Etowah | Alabama | 1055 | 2775 | 39 |
479468 | 479468 | 2020-08-29 | Fayette | Alabama | 1057 | 311 | 6 |
479469 | 479469 | 2020-08-29 | Franklin | Alabama | 1059 | 1554 | 27 |
479470 | 479470 | 2020-08-29 | Geneva | Alabama | 1061 | 422 | 4 |
479471 | 479471 | 2020-08-29 | Greene | Alabama | 1063 | 281 | 15 |
479472 | 479472 | 2020-08-29 | Hale | Alabama | 1065 | 556 | 28 |
479473 | 479473 | 2020-08-29 | Henry | Alabama | 1067 | 359 | 4 |
479474 | 479474 | 2020-08-29 | Houston | Alabama | 1069 | 2004 | 18 |
479475 | 479475 | 2020-08-29 | Jackson | Alabama | 1071 | 1301 | 9 |
479476 | 479476 | 2020-08-29 | Jefferson | Alabama | 1073 | 16133 | 303 |
479477 | 479477 | 2020-08-29 | Lamar | Alabama | 1075 | 286 | 2 |
479478 | 479478 | 2020-08-29 | Lauderdale | Alabama | 1077 | 1422 | 23 |
479479 | 479479 | 2020-08-29 | Lawrence | Alabama | 1079 | 455 | 5 |
479480 | 479480 | 2020-08-29 | Lee | Alabama | 1081 | 4383 | 53 |
479481 | 479481 | 2020-08-29 | Limestone | Alabama | 1083 | 1658 | 16 |
479482 | 479482 | 2020-08-29 | Lowndes | Alabama | 1085 | 617 | 26 |
479483 | 479483 | 2020-08-29 | Macon | Alabama | 1087 | 429 | 18 |
479484 | 479484 | 2020-08-29 | Madison | Alabama | 1089 | 6366 | 52 |
479485 | 479485 | 2020-08-29 | Marengo | Alabama | 1091 | 637 | 18 |
479486 | 479486 | 2020-08-29 | Marion | Alabama | 1093 | 781 | 28 |
479487 | 479487 | 2020-08-29 | Marshall | Alabama | 1095 | 3605 | 42 |
479488 | 479488 | 2020-08-29 | Mobile | Alabama | 1097 | 12136 | 257 |
479489 | 479489 | 2020-08-29 | Monroe | Alabama | 1099 | 541 | 7 |
479490 | 479490 | 2020-08-29 | Montgomery | Alabama | 1101 | 7881 | 163 |
479491 | 479491 | 2020-08-29 | Morgan | Alabama | 1103 | 2874 | 24 |
479492 | 479492 | 2020-08-29 | Perry | Alabama | 1105 | 516 | 5 |
479493 | 479493 | 2020-08-29 | Pickens | Alabama | 1107 | 555 | 11 |
479494 | 479494 | 2020-08-29 | Pike | Alabama | 1109 | 948 | 8 |
479495 | 479495 | 2020-08-29 | Randolph | Alabama | 1111 | 500 | 12 |
479496 | 479496 | 2020-08-29 | Russell | Alabama | 1113 | 1609 | 2 |
479497 | 479497 | 2020-08-29 | Shelby | Alabama | 1117 | 4381 | 47 |
479498 | 479498 | 2020-08-29 | St. Clair | Alabama | 1115 | 1811 | 28 |
479499 | 479499 | 2020-08-29 | Sumter | Alabama | 1119 | 402 | 19 |
479500 | 479500 | 2020-08-29 | Talladega | Alabama | 1121 | 1733 | 19 |
479501 | 479501 | 2020-08-29 | Tallapoosa | Alabama | 1123 | 1041 | 82 |
479502 | 479502 | 2020-08-29 | Tuscaloosa | Alabama | 1125 | 5774 | 96 |
479503 | 479503 | 2020-08-29 | Walker | Alabama | 1127 | 1900 | 75 |
479504 | 479504 | 2020-08-29 | Washington | Alabama | 1129 | 515 | 13 |
479505 | 479505 | 2020-08-29 | Wilcox | Alabama | 1131 | 513 | 10 |
479506 | 479506 | 2020-08-29 | Winston | Alabama | 1133 | 568 | 11 |
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);