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-20 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
450372 | 450372 | 2020-08-20 | Autauga | Alabama | 1001 | 1298 | 23 |
450373 | 450373 | 2020-08-20 | Baldwin | Alabama | 1003 | 4035 | 34 |
450374 | 450374 | 2020-08-20 | Barbour | Alabama | 1005 | 692 | 7 |
450375 | 450375 | 2020-08-20 | Bibb | Alabama | 1007 | 507 | 6 |
450376 | 450376 | 2020-08-20 | Blount | Alabama | 1009 | 1077 | 5 |
450377 | 450377 | 2020-08-20 | Bullock | Alabama | 1011 | 536 | 14 |
450378 | 450378 | 2020-08-20 | Butler | Alabama | 1013 | 816 | 37 |
450379 | 450379 | 2020-08-20 | Calhoun | Alabama | 1015 | 2214 | 25 |
450380 | 450380 | 2020-08-20 | Chambers | Alabama | 1017 | 949 | 38 |
450381 | 450381 | 2020-08-20 | Cherokee | Alabama | 1019 | 356 | 10 |
450382 | 450382 | 2020-08-20 | Chilton | Alabama | 1021 | 949 | 12 |
450383 | 450383 | 2020-08-20 | Choctaw | Alabama | 1023 | 310 | 12 |
450384 | 450384 | 2020-08-20 | Clarke | Alabama | 1025 | 911 | 11 |
450385 | 450385 | 2020-08-20 | Clay | Alabama | 1027 | 326 | 5 |
450386 | 450386 | 2020-08-20 | Cleburne | Alabama | 1029 | 174 | 2 |
450387 | 450387 | 2020-08-20 | Coffee | Alabama | 1031 | 925 | 7 |
450388 | 450388 | 2020-08-20 | Colbert | Alabama | 1033 | 1347 | 19 |
450389 | 450389 | 2020-08-20 | Conecuh | Alabama | 1035 | 447 | 11 |
450390 | 450390 | 2020-08-20 | Coosa | Alabama | 1037 | 125 | 3 |
450391 | 450391 | 2020-08-20 | Covington | Alabama | 1039 | 980 | 23 |
450392 | 450392 | 2020-08-20 | Crenshaw | Alabama | 1041 | 410 | 12 |
450393 | 450393 | 2020-08-20 | Cullman | Alabama | 1043 | 1441 | 11 |
450394 | 450394 | 2020-08-20 | Dale | Alabama | 1045 | 925 | 32 |
450395 | 450395 | 2020-08-20 | Dallas | Alabama | 1047 | 1516 | 25 |
450396 | 450396 | 2020-08-20 | DeKalb | Alabama | 1049 | 2025 | 16 |
450397 | 450397 | 2020-08-20 | Elmore | Alabama | 1051 | 1981 | 42 |
450398 | 450398 | 2020-08-20 | Escambia | Alabama | 1053 | 1295 | 17 |
450399 | 450399 | 2020-08-20 | Etowah | Alabama | 1055 | 2491 | 37 |
450400 | 450400 | 2020-08-20 | Fayette | Alabama | 1057 | 277 | 6 |
450401 | 450401 | 2020-08-20 | Franklin | Alabama | 1059 | 1428 | 22 |
450402 | 450402 | 2020-08-20 | Geneva | Alabama | 1061 | 332 | 3 |
450403 | 450403 | 2020-08-20 | Greene | Alabama | 1063 | 274 | 14 |
450404 | 450404 | 2020-08-20 | Hale | Alabama | 1065 | 530 | 26 |
450405 | 450405 | 2020-08-20 | Henry | Alabama | 1067 | 297 | 4 |
450406 | 450406 | 2020-08-20 | Houston | Alabama | 1069 | 1635 | 16 |
450407 | 450407 | 2020-08-20 | Jackson | Alabama | 1071 | 1208 | 7 |
450408 | 450408 | 2020-08-20 | Jefferson | Alabama | 1073 | 14782 | 278 |
450409 | 450409 | 2020-08-20 | Lamar | Alabama | 1075 | 269 | 2 |
450410 | 450410 | 2020-08-20 | Lauderdale | Alabama | 1077 | 1307 | 22 |
450411 | 450411 | 2020-08-20 | Lawrence | Alabama | 1079 | 396 | 4 |
450412 | 450412 | 2020-08-20 | Lee | Alabama | 1081 | 3209 | 51 |
450413 | 450413 | 2020-08-20 | Limestone | Alabama | 1083 | 1530 | 15 |
450414 | 450414 | 2020-08-20 | Lowndes | Alabama | 1085 | 600 | 26 |
450415 | 450415 | 2020-08-20 | Macon | Alabama | 1087 | 385 | 16 |
450416 | 450416 | 2020-08-20 | Madison | Alabama | 1089 | 5946 | 43 |
450417 | 450417 | 2020-08-20 | Marengo | Alabama | 1091 | 609 | 18 |
450418 | 450418 | 2020-08-20 | Marion | Alabama | 1093 | 688 | 27 |
450419 | 450419 | 2020-08-20 | Marshall | Alabama | 1095 | 3429 | 39 |
450420 | 450420 | 2020-08-20 | Mobile | Alabama | 1097 | 11445 | 240 |
450421 | 450421 | 2020-08-20 | Monroe | Alabama | 1099 | 508 | 7 |
450422 | 450422 | 2020-08-20 | Montgomery | Alabama | 1101 | 7457 | 159 |
450423 | 450423 | 2020-08-20 | Morgan | Alabama | 1103 | 2636 | 24 |
450424 | 450424 | 2020-08-20 | Perry | Alabama | 1105 | 494 | 4 |
450425 | 450425 | 2020-08-20 | Pickens | Alabama | 1107 | 485 | 11 |
450426 | 450426 | 2020-08-20 | Pike | Alabama | 1109 | 839 | 8 |
450427 | 450427 | 2020-08-20 | Randolph | Alabama | 1111 | 442 | 12 |
450428 | 450428 | 2020-08-20 | Russell | Alabama | 1113 | 1509 | 2 |
450429 | 450429 | 2020-08-20 | Shelby | Alabama | 1117 | 3851 | 41 |
450430 | 450430 | 2020-08-20 | St. Clair | Alabama | 1115 | 1614 | 24 |
450431 | 450431 | 2020-08-20 | Sumter | Alabama | 1119 | 387 | 19 |
450432 | 450432 | 2020-08-20 | Talladega | Alabama | 1121 | 1520 | 16 |
450433 | 450433 | 2020-08-20 | Tallapoosa | Alabama | 1123 | 991 | 79 |
450434 | 450434 | 2020-08-20 | Tuscaloosa | Alabama | 1125 | 4850 | 89 |
450435 | 450435 | 2020-08-20 | Walker | Alabama | 1127 | 1749 | 70 |
450436 | 450436 | 2020-08-20 | Washington | Alabama | 1129 | 490 | 13 |
450437 | 450437 | 2020-08-20 | Wilcox | Alabama | 1131 | 482 | 10 |
450438 | 450438 | 2020-08-20 | Winston | Alabama | 1133 | 511 | 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);