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-05-25 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
175453 | 175453 | 2020-05-25 | Autauga | Alabama | 1001 | 168 | 3 |
175454 | 175454 | 2020-05-25 | Baldwin | Alabama | 1003 | 274 | 9 |
175455 | 175455 | 2020-05-25 | Barbour | Alabama | 1005 | 113 | 1 |
175456 | 175456 | 2020-05-25 | Bibb | Alabama | 1007 | 59 | 1 |
175457 | 175457 | 2020-05-25 | Blount | Alabama | 1009 | 49 | 1 |
175458 | 175458 | 2020-05-25 | Bullock | Alabama | 1011 | 133 | 3 |
175459 | 175459 | 2020-05-25 | Butler | Alabama | 1013 | 359 | 12 |
175460 | 175460 | 2020-05-25 | Calhoun | Alabama | 1015 | 146 | 3 |
175461 | 175461 | 2020-05-25 | Chambers | Alabama | 1017 | 337 | 24 |
175462 | 175462 | 2020-05-25 | Cherokee | Alabama | 1019 | 33 | 2 |
175463 | 175463 | 2020-05-25 | Chilton | Alabama | 1021 | 87 | 1 |
175464 | 175464 | 2020-05-25 | Choctaw | Alabama | 1023 | 144 | 4 |
175465 | 175465 | 2020-05-25 | Clarke | Alabama | 1025 | 109 | 2 |
175466 | 175466 | 2020-05-25 | Clay | Alabama | 1027 | 27 | 2 |
175467 | 175467 | 2020-05-25 | Cleburne | Alabama | 1029 | 13 | 1 |
175468 | 175468 | 2020-05-25 | Coffee | Alabama | 1031 | 206 | 1 |
175469 | 175469 | 2020-05-25 | Colbert | Alabama | 1033 | 142 | 2 |
175470 | 175470 | 2020-05-25 | Conecuh | Alabama | 1035 | 28 | 1 |
175471 | 175471 | 2020-05-25 | Coosa | Alabama | 1037 | 34 | 1 |
175472 | 175472 | 2020-05-25 | Covington | Alabama | 1039 | 67 | 1 |
175473 | 175473 | 2020-05-25 | Crenshaw | Alabama | 1041 | 60 | 2 |
175474 | 175474 | 2020-05-25 | Cullman | Alabama | 1043 | 78 | 0 |
175475 | 175475 | 2020-05-25 | Dale | Alabama | 1045 | 85 | 0 |
175476 | 175476 | 2020-05-25 | Dallas | Alabama | 1047 | 206 | 3 |
175477 | 175477 | 2020-05-25 | DeKalb | Alabama | 1049 | 226 | 3 |
175478 | 175478 | 2020-05-25 | Elmore | Alabama | 1051 | 270 | 7 |
175479 | 175479 | 2020-05-25 | Escambia | Alabama | 1053 | 43 | 3 |
175480 | 175480 | 2020-05-25 | Etowah | Alabama | 1055 | 238 | 11 |
175481 | 175481 | 2020-05-25 | Fayette | Alabama | 1057 | 11 | 0 |
175482 | 175482 | 2020-05-25 | Franklin | Alabama | 1059 | 467 | 6 |
175483 | 175483 | 2020-05-25 | Geneva | Alabama | 1061 | 35 | 0 |
175484 | 175484 | 2020-05-25 | Greene | Alabama | 1063 | 91 | 4 |
175485 | 175485 | 2020-05-25 | Hale | Alabama | 1065 | 132 | 4 |
175486 | 175486 | 2020-05-25 | Henry | Alabama | 1067 | 64 | 2 |
175487 | 175487 | 2020-05-25 | Houston | Alabama | 1069 | 172 | 4 |
175488 | 175488 | 2020-05-25 | Jackson | Alabama | 1071 | 71 | 2 |
175489 | 175489 | 2020-05-25 | Jefferson | Alabama | 1073 | 1630 | 91 |
175490 | 175490 | 2020-05-25 | Lamar | Alabama | 1075 | 20 | 0 |
175491 | 175491 | 2020-05-25 | Lauderdale | Alabama | 1077 | 135 | 2 |
175492 | 175492 | 2020-05-25 | Lawrence | Alabama | 1079 | 43 | 0 |
175493 | 175493 | 2020-05-25 | Lee | Alabama | 1081 | 510 | 32 |
175494 | 175494 | 2020-05-25 | Limestone | Alabama | 1083 | 77 | 0 |
175495 | 175495 | 2020-05-25 | Lowndes | Alabama | 1085 | 193 | 10 |
175496 | 175496 | 2020-05-25 | Macon | Alabama | 1087 | 62 | 2 |
175497 | 175497 | 2020-05-25 | Madison | Alabama | 1089 | 302 | 4 |
175498 | 175498 | 2020-05-25 | Marengo | Alabama | 1091 | 141 | 6 |
175499 | 175499 | 2020-05-25 | Marion | Alabama | 1093 | 114 | 10 |
175500 | 175500 | 2020-05-25 | Marshall | Alabama | 1095 | 650 | 9 |
175501 | 175501 | 2020-05-25 | Mobile | Alabama | 1097 | 2033 | 111 |
175502 | 175502 | 2020-05-25 | Monroe | Alabama | 1099 | 33 | 2 |
175503 | 175503 | 2020-05-25 | Montgomery | Alabama | 1101 | 1274 | 33 |
175504 | 175504 | 2020-05-25 | Morgan | Alabama | 1103 | 176 | 1 |
175505 | 175505 | 2020-05-25 | Perry | Alabama | 1105 | 35 | 0 |
175506 | 175506 | 2020-05-25 | Pickens | Alabama | 1107 | 93 | 4 |
175507 | 175507 | 2020-05-25 | Pike | Alabama | 1109 | 145 | 0 |
175508 | 175508 | 2020-05-25 | Randolph | Alabama | 1111 | 124 | 7 |
175509 | 175509 | 2020-05-25 | Russell | Alabama | 1113 | 137 | 0 |
175510 | 175510 | 2020-05-25 | Shelby | Alabama | 1117 | 447 | 19 |
175511 | 175511 | 2020-05-25 | St. Clair | Alabama | 1115 | 104 | 1 |
175512 | 175512 | 2020-05-25 | Sumter | Alabama | 1119 | 193 | 6 |
175513 | 175513 | 2020-05-25 | Talladega | Alabama | 1121 | 91 | 2 |
175514 | 175514 | 2020-05-25 | Tallapoosa | Alabama | 1123 | 400 | 63 |
175515 | 175515 | 2020-05-25 | Tuscaloosa | Alabama | 1125 | 558 | 12 |
175516 | 175516 | 2020-05-25 | Walker | Alabama | 1127 | 239 | 1 |
175517 | 175517 | 2020-05-25 | Washington | Alabama | 1129 | 65 | 5 |
175518 | 175518 | 2020-05-25 | Wilcox | Alabama | 1131 | 118 | 7 |
175519 | 175519 | 2020-05-25 | Winston | Alabama | 1133 | 67 | 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);