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-05-14 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 |
---|---|---|---|---|---|---|---|
1316501 | 1316501 | 2021-05-14 | Autauga | Alabama | 1001 | 6971 | 108 |
1316502 | 1316502 | 2021-05-14 | Baldwin | Alabama | 1003 | 21290 | 309 |
1316503 | 1316503 | 2021-05-14 | Barbour | Alabama | 1005 | 2319 | 56 |
1316504 | 1316504 | 2021-05-14 | Bibb | Alabama | 1007 | 2630 | 64 |
1316505 | 1316505 | 2021-05-14 | Blount | Alabama | 1009 | 6750 | 139 |
1316506 | 1316506 | 2021-05-14 | Bullock | Alabama | 1011 | 1230 | 41 |
1316507 | 1316507 | 2021-05-14 | Butler | Alabama | 1013 | 2178 | 69 |
1316508 | 1316508 | 2021-05-14 | Calhoun | Alabama | 1015 | 14556 | 319 |
1316509 | 1316509 | 2021-05-14 | Chambers | Alabama | 1017 | 3581 | 123 |
1316510 | 1316510 | 2021-05-14 | Cherokee | Alabama | 1019 | 1843 | 45 |
1316511 | 1316511 | 2021-05-14 | Chilton | Alabama | 1021 | 4343 | 113 |
1316512 | 1316512 | 2021-05-14 | Choctaw | Alabama | 1023 | 610 | 24 |
1316513 | 1316513 | 2021-05-14 | Clarke | Alabama | 1025 | 3513 | 61 |
1316514 | 1316514 | 2021-05-14 | Clay | Alabama | 1027 | 1569 | 57 |
1316515 | 1316515 | 2021-05-14 | Cleburne | Alabama | 1029 | 1492 | 41 |
1316516 | 1316516 | 2021-05-14 | Coffee | Alabama | 1031 | 5546 | 119 |
1316517 | 1316517 | 2021-05-14 | Colbert | Alabama | 1033 | 6317 | 134 |
1316518 | 1316518 | 2021-05-14 | Conecuh | Alabama | 1035 | 1106 | 29 |
1316519 | 1316519 | 2021-05-14 | Coosa | Alabama | 1037 | 1089 | 28 |
1316520 | 1316520 | 2021-05-14 | Covington | Alabama | 1039 | 4138 | 118 |
1316521 | 1316521 | 2021-05-14 | Crenshaw | Alabama | 1041 | 1533 | 57 |
1316522 | 1316522 | 2021-05-14 | Cullman | Alabama | 1043 | 9730 | 194 |
1316523 | 1316523 | 2021-05-14 | Dale | Alabama | 1045 | 4869 | 113 |
1316524 | 1316524 | 2021-05-14 | Dallas | Alabama | 1047 | 3564 | 153 |
1316525 | 1316525 | 2021-05-14 | DeKalb | Alabama | 1049 | 8853 | 188 |
1316526 | 1316526 | 2021-05-14 | Elmore | Alabama | 1051 | 10115 | 206 |
1316527 | 1316527 | 2021-05-14 | Escambia | Alabama | 1053 | 3945 | 77 |
1316528 | 1316528 | 2021-05-14 | Etowah | Alabama | 1055 | 13890 | 353 |
1316529 | 1316529 | 2021-05-14 | Fayette | Alabama | 1057 | 2124 | 62 |
1316530 | 1316530 | 2021-05-14 | Franklin | Alabama | 1059 | 4262 | 82 |
1316531 | 1316531 | 2021-05-14 | Geneva | Alabama | 1061 | 2525 | 77 |
1316532 | 1316532 | 2021-05-14 | Greene | Alabama | 1063 | 926 | 34 |
1316533 | 1316533 | 2021-05-14 | Hale | Alabama | 1065 | 2236 | 77 |
1316534 | 1316534 | 2021-05-14 | Henry | Alabama | 1067 | 1896 | 44 |
1316535 | 1316535 | 2021-05-14 | Houston | Alabama | 1069 | 10602 | 282 |
1316536 | 1316536 | 2021-05-14 | Jackson | Alabama | 1071 | 6830 | 112 |
1316537 | 1316537 | 2021-05-14 | Jefferson | Alabama | 1073 | 79169 | 1529 |
1316538 | 1316538 | 2021-05-14 | Lamar | Alabama | 1075 | 1430 | 35 |
1316539 | 1316539 | 2021-05-14 | Lauderdale | Alabama | 1077 | 9449 | 243 |
1316540 | 1316540 | 2021-05-14 | Lawrence | Alabama | 1079 | 3022 | 98 |
1316541 | 1316541 | 2021-05-14 | Lee | Alabama | 1081 | 15946 | 171 |
1316542 | 1316542 | 2021-05-14 | Limestone | Alabama | 1083 | 10031 | 151 |
1316543 | 1316543 | 2021-05-14 | Lowndes | Alabama | 1085 | 1396 | 53 |
1316544 | 1316544 | 2021-05-14 | Macon | Alabama | 1087 | 1607 | 50 |
1316545 | 1316545 | 2021-05-14 | Madison | Alabama | 1089 | 35002 | 507 |
1316546 | 1316546 | 2021-05-14 | Marengo | Alabama | 1091 | 2496 | 64 |
1316547 | 1316547 | 2021-05-14 | Marion | Alabama | 1093 | 3137 | 101 |
1316548 | 1316548 | 2021-05-14 | Marshall | Alabama | 1095 | 12262 | 223 |
1316549 | 1316549 | 2021-05-14 | Mobile | Alabama | 1097 | 41177 | 808 |
1316550 | 1316550 | 2021-05-14 | Monroe | Alabama | 1099 | 1781 | 40 |
1316551 | 1316551 | 2021-05-14 | Montgomery | Alabama | 1101 | 24549 | 591 |
1316552 | 1316552 | 2021-05-14 | Morgan | Alabama | 1103 | 14364 | 280 |
1316553 | 1316553 | 2021-05-14 | Perry | Alabama | 1105 | 1078 | 26 |
1316554 | 1316554 | 2021-05-14 | Pickens | Alabama | 1107 | 2348 | 62 |
1316555 | 1316555 | 2021-05-14 | Pike | Alabama | 1109 | 3119 | 77 |
1316556 | 1316556 | 2021-05-14 | Randolph | Alabama | 1111 | 1820 | 42 |
1316557 | 1316557 | 2021-05-14 | Russell | Alabama | 1113 | 4443 | 38 |
1316558 | 1316558 | 2021-05-14 | Shelby | Alabama | 1117 | 25076 | 249 |
1316559 | 1316559 | 2021-05-14 | St. Clair | Alabama | 1115 | 9890 | 245 |
1316560 | 1316560 | 2021-05-14 | Sumter | Alabama | 1119 | 1049 | 32 |
1316561 | 1316561 | 2021-05-14 | Talladega | Alabama | 1121 | 8325 | 176 |
1316562 | 1316562 | 2021-05-14 | Tallapoosa | Alabama | 1123 | 4040 | 152 |
1316563 | 1316563 | 2021-05-14 | Tuscaloosa | Alabama | 1125 | 25871 | 454 |
1316564 | 1316564 | 2021-05-14 | Walker | Alabama | 1127 | 7259 | 277 |
1316565 | 1316565 | 2021-05-14 | Washington | Alabama | 1129 | 1676 | 39 |
1316566 | 1316566 | 2021-05-14 | Wilcox | Alabama | 1131 | 1274 | 30 |
1316567 | 1316567 | 2021-05-14 | Winston | Alabama | 1133 | 2756 | 73 |
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);