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-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 |
---|---|---|---|---|---|---|---|
709499 | 709499 | 2020-11-08 | Autauga | Alabama | 1001 | 2283 | 30 |
709500 | 709500 | 2020-11-08 | Baldwin | Alabama | 1003 | 7226 | 83 |
709501 | 709501 | 2020-11-08 | Barbour | Alabama | 1005 | 1095 | 9 |
709502 | 709502 | 2020-11-08 | Bibb | Alabama | 1007 | 926 | 16 |
709503 | 709503 | 2020-11-08 | Blount | Alabama | 1009 | 2297 | 26 |
709504 | 709504 | 2020-11-08 | Bullock | Alabama | 1011 | 664 | 17 |
709505 | 709505 | 2020-11-08 | Butler | Alabama | 1013 | 1052 | 41 |
709506 | 709506 | 2020-11-08 | Calhoun | Alabama | 1015 | 5181 | 67 |
709507 | 709507 | 2020-11-08 | Chambers | Alabama | 1017 | 1485 | 48 |
709508 | 709508 | 2020-11-08 | Cherokee | Alabama | 1019 | 840 | 15 |
709509 | 709509 | 2020-11-08 | Chilton | Alabama | 1021 | 2011 | 35 |
709510 | 709510 | 2020-11-08 | Choctaw | Alabama | 1023 | 407 | 12 |
709511 | 709511 | 2020-11-08 | Clarke | Alabama | 1025 | 1443 | 18 |
709512 | 709512 | 2020-11-08 | Clay | Alabama | 1027 | 816 | 13 |
709513 | 709513 | 2020-11-08 | Cleburne | Alabama | 1029 | 627 | 11 |
709514 | 709514 | 2020-11-08 | Coffee | Alabama | 1031 | 1985 | 12 |
709515 | 709515 | 2020-11-08 | Colbert | Alabama | 1033 | 2461 | 33 |
709516 | 709516 | 2020-11-08 | Conecuh | Alabama | 1035 | 605 | 13 |
709517 | 709517 | 2020-11-08 | Coosa | Alabama | 1037 | 235 | 3 |
709518 | 709518 | 2020-11-08 | Covington | Alabama | 1039 | 1941 | 32 |
709519 | 709519 | 2020-11-08 | Crenshaw | Alabama | 1041 | 644 | 30 |
709520 | 709520 | 2020-11-08 | Cullman | Alabama | 1043 | 3195 | 27 |
709521 | 709521 | 2020-11-08 | Dale | Alabama | 1045 | 2043 | 55 |
709522 | 709522 | 2020-11-08 | Dallas | Alabama | 1047 | 1986 | 27 |
709523 | 709523 | 2020-11-08 | DeKalb | Alabama | 1049 | 3896 | 32 |
709524 | 709524 | 2020-11-08 | Elmore | Alabama | 1051 | 3454 | 59 |
709525 | 709525 | 2020-11-08 | Escambia | Alabama | 1053 | 1829 | 31 |
709526 | 709526 | 2020-11-08 | Etowah | Alabama | 1055 | 4887 | 58 |
709527 | 709527 | 2020-11-08 | Fayette | Alabama | 1057 | 664 | 15 |
709528 | 709528 | 2020-11-08 | Franklin | Alabama | 1059 | 2250 | 34 |
709529 | 709529 | 2020-11-08 | Geneva | Alabama | 1061 | 1025 | 8 |
709530 | 709530 | 2020-11-08 | Greene | Alabama | 1063 | 361 | 17 |
709531 | 709531 | 2020-11-08 | Hale | Alabama | 1065 | 825 | 30 |
709532 | 709532 | 2020-11-08 | Henry | Alabama | 1067 | 777 | 6 |
709533 | 709533 | 2020-11-08 | Houston | Alabama | 1069 | 4485 | 36 |
709534 | 709534 | 2020-11-08 | Jackson | Alabama | 1071 | 2476 | 22 |
709535 | 709535 | 2020-11-08 | Jefferson | Alabama | 1073 | 25827 | 403 |
709536 | 709536 | 2020-11-08 | Lamar | Alabama | 1075 | 554 | 7 |
709537 | 709537 | 2020-11-08 | Lauderdale | Alabama | 1077 | 2937 | 47 |
709538 | 709538 | 2020-11-08 | Lawrence | Alabama | 1079 | 1003 | 35 |
709539 | 709539 | 2020-11-08 | Lee | Alabama | 1081 | 6903 | 65 |
709540 | 709540 | 2020-11-08 | Limestone | Alabama | 1083 | 3350 | 37 |
709541 | 709541 | 2020-11-08 | Lowndes | Alabama | 1085 | 745 | 29 |
709542 | 709542 | 2020-11-08 | Macon | Alabama | 1087 | 610 | 20 |
709543 | 709543 | 2020-11-08 | Madison | Alabama | 1089 | 10358 | 105 |
709544 | 709544 | 2020-11-08 | Marengo | Alabama | 1091 | 1095 | 24 |
709545 | 709545 | 2020-11-08 | Marion | Alabama | 1093 | 1211 | 31 |
709546 | 709546 | 2020-11-08 | Marshall | Alabama | 1095 | 4852 | 53 |
709547 | 709547 | 2020-11-08 | Mobile | Alabama | 1097 | 17782 | 328 |
709548 | 709548 | 2020-11-08 | Monroe | Alabama | 1099 | 692 | 10 |
709549 | 709549 | 2020-11-08 | Montgomery | Alabama | 1101 | 11119 | 219 |
709550 | 709550 | 2020-11-08 | Morgan | Alabama | 1103 | 4877 | 40 |
709551 | 709551 | 2020-11-08 | Perry | Alabama | 1105 | 618 | 6 |
709552 | 709552 | 2020-11-08 | Pickens | Alabama | 1107 | 994 | 18 |
709553 | 709553 | 2020-11-08 | Pike | Alabama | 1109 | 1429 | 14 |
709554 | 709554 | 2020-11-08 | Randolph | Alabama | 1111 | 890 | 18 |
709555 | 709555 | 2020-11-08 | Russell | Alabama | 1113 | 2022 | 3 |
709556 | 709556 | 2020-11-08 | Shelby | Alabama | 1117 | 8251 | 71 |
709557 | 709557 | 2020-11-08 | St. Clair | Alabama | 1115 | 3477 | 52 |
709558 | 709558 | 2020-11-08 | Sumter | Alabama | 1119 | 509 | 21 |
709559 | 709559 | 2020-11-08 | Talladega | Alabama | 1121 | 2941 | 40 |
709560 | 709560 | 2020-11-08 | Tallapoosa | Alabama | 1123 | 1476 | 87 |
709561 | 709561 | 2020-11-08 | Tuscaloosa | Alabama | 1125 | 11205 | 146 |
709562 | 709562 | 2020-11-08 | Walker | Alabama | 1127 | 3141 | 96 |
709563 | 709563 | 2020-11-08 | Washington | Alabama | 1129 | 812 | 12 |
709564 | 709564 | 2020-11-08 | Wilcox | Alabama | 1131 | 591 | 12 |
709565 | 709565 | 2020-11-08 | Winston | Alabama | 1133 | 1039 | 14 |
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);