ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-01-12" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
920438 | 920438 | 2021-01-12 | Autauga | Alabama | 1001 | 4970 | 55 |
920439 | 920439 | 2021-01-12 | Baldwin | Alabama | 1003 | 15572 | 175 |
920440 | 920440 | 2021-01-12 | Barbour | Alabama | 1005 | 1679 | 35 |
920441 | 920441 | 2021-01-12 | Bibb | Alabama | 1007 | 2090 | 48 |
920442 | 920442 | 2021-01-12 | Blount | Alabama | 1009 | 5134 | 79 |
920443 | 920443 | 2021-01-12 | Bullock | Alabama | 1011 | 967 | 28 |
920444 | 920444 | 2021-01-12 | Butler | Alabama | 1013 | 1649 | 57 |
920445 | 920445 | 2021-01-12 | Calhoun | Alabama | 1015 | 10668 | 195 |
920446 | 920446 | 2021-01-12 | Chambers | Alabama | 1017 | 2697 | 66 |
920447 | 920447 | 2021-01-12 | Cherokee | Alabama | 1019 | 1568 | 29 |
920448 | 920448 | 2021-01-12 | Chilton | Alabama | 1021 | 3300 | 60 |
920449 | 920449 | 2021-01-12 | Choctaw | Alabama | 1023 | 503 | 22 |
920450 | 920450 | 2021-01-12 | Clarke | Alabama | 1025 | 2649 | 26 |
920451 | 920451 | 2021-01-12 | Clay | Alabama | 1027 | 1231 | 36 |
920452 | 920452 | 2021-01-12 | Cleburne | Alabama | 1029 | 1130 | 18 |
920453 | 920453 | 2021-01-12 | Coffee | Alabama | 1031 | 4227 | 42 |
920454 | 920454 | 2021-01-12 | Colbert | Alabama | 1033 | 5159 | 62 |
920455 | 920455 | 2021-01-12 | Conecuh | Alabama | 1035 | 921 | 18 |
920456 | 920456 | 2021-01-12 | Coosa | Alabama | 1037 | 591 | 11 |
920457 | 920457 | 2021-01-12 | Covington | Alabama | 1039 | 3206 | 53 |
920458 | 920458 | 2021-01-12 | Crenshaw | Alabama | 1041 | 1138 | 38 |
920459 | 920459 | 2021-01-12 | Cullman | Alabama | 1043 | 7796 | 81 |
920460 | 920460 | 2021-01-12 | Dale | Alabama | 1045 | 3800 | 69 |
920461 | 920461 | 2021-01-12 | Dallas | Alabama | 1047 | 2959 | 69 |
920462 | 920462 | 2021-01-12 | DeKalb | Alabama | 1049 | 7458 | 68 |
920463 | 920463 | 2021-01-12 | Elmore | Alabama | 1051 | 7533 | 91 |
920464 | 920464 | 2021-01-12 | Escambia | Alabama | 1053 | 3035 | 37 |
920465 | 920465 | 2021-01-12 | Etowah | Alabama | 1055 | 11257 | 125 |
920466 | 920466 | 2021-01-12 | Fayette | Alabama | 1057 | 1613 | 21 |
920467 | 920467 | 2021-01-12 | Franklin | Alabama | 1059 | 3571 | 42 |
920468 | 920468 | 2021-01-12 | Geneva | Alabama | 1061 | 1931 | 29 |
920469 | 920469 | 2021-01-12 | Greene | Alabama | 1063 | 738 | 20 |
920470 | 920470 | 2021-01-12 | Hale | Alabama | 1065 | 1695 | 42 |
920471 | 920471 | 2021-01-12 | Henry | Alabama | 1067 | 1458 | 13 |
920472 | 920472 | 2021-01-12 | Houston | Alabama | 1069 | 8266 | 83 |
920473 | 920473 | 2021-01-12 | Jackson | Alabama | 1071 | 5648 | 35 |
920474 | 920474 | 2021-01-12 | Jefferson | Alabama | 1073 | 59867 | 842 |
920475 | 920475 | 2021-01-12 | Lamar | Alabama | 1075 | 1153 | 17 |
920476 | 920476 | 2021-01-12 | Lauderdale | Alabama | 1077 | 7296 | 73 |
920477 | 920477 | 2021-01-12 | Lawrence | Alabama | 1079 | 2351 | 45 |
920478 | 920478 | 2021-01-12 | Lee | Alabama | 1081 | 11812 | 87 |
920479 | 920479 | 2021-01-12 | Limestone | Alabama | 1083 | 7722 | 64 |
920480 | 920480 | 2021-01-12 | Lowndes | Alabama | 1085 | 1071 | 35 |
920481 | 920481 | 2021-01-12 | Macon | Alabama | 1087 | 1106 | 35 |
920482 | 920482 | 2021-01-12 | Madison | Alabama | 1089 | 26012 | 181 |
920483 | 920483 | 2021-01-12 | Marengo | Alabama | 1091 | 1949 | 28 |
920484 | 920484 | 2021-01-12 | Marion | Alabama | 1093 | 2358 | 47 |
920485 | 920485 | 2021-01-12 | Marshall | Alabama | 1095 | 9907 | 98 |
920486 | 920486 | 2021-01-12 | Mobile | Alabama | 1097 | 29011 | 532 |
920487 | 920487 | 2021-01-12 | Monroe | Alabama | 1099 | 1416 | 12 |
920488 | 920488 | 2021-01-12 | Montgomery | Alabama | 1101 | 18315 | 295 |
920489 | 920489 | 2021-01-12 | Morgan | Alabama | 1103 | 11871 | 104 |
920490 | 920490 | 2021-01-12 | Perry | Alabama | 1105 | 930 | 19 |
920491 | 920491 | 2021-01-12 | Pickens | Alabama | 1107 | 1924 | 31 |
920492 | 920492 | 2021-01-12 | Pike | Alabama | 1109 | 2384 | 23 |
920493 | 920493 | 2021-01-12 | Randolph | Alabama | 1111 | 1358 | 32 |
920494 | 920494 | 2021-01-12 | Russell | Alabama | 1113 | 3105 | 7 |
920495 | 920495 | 2021-01-12 | Shelby | Alabama | 1117 | 17837 | 106 |
920496 | 920496 | 2021-01-12 | St. Clair | Alabama | 1115 | 7305 | 116 |
920497 | 920497 | 2021-01-12 | Sumter | Alabama | 1119 | 890 | 26 |
920498 | 920498 | 2021-01-12 | Talladega | Alabama | 1121 | 5892 | 108 |
920499 | 920499 | 2021-01-12 | Tallapoosa | Alabama | 1123 | 2592 | 107 |
920500 | 920500 | 2021-01-12 | Tuscaloosa | Alabama | 1125 | 20320 | 267 |
920501 | 920501 | 2021-01-12 | Walker | Alabama | 1127 | 5775 | 177 |
920502 | 920502 | 2021-01-12 | Washington | Alabama | 1129 | 1326 | 26 |
920503 | 920503 | 2021-01-12 | Wilcox | Alabama | 1131 | 986 | 20 |
920504 | 920504 | 2021-01-12 | Winston | Alabama | 1133 | 2200 | 35 |
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);