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-09-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 |
---|---|---|---|---|---|---|---|
550609 | 550609 | 2020-09-20 | Autauga | Alabama | 1001 | 1690 | 24 |
550610 | 550610 | 2020-09-20 | Baldwin | Alabama | 1003 | 5061 | 49 |
550611 | 550611 | 2020-09-20 | Barbour | Alabama | 1005 | 835 | 7 |
550612 | 550612 | 2020-09-20 | Bibb | Alabama | 1007 | 632 | 10 |
550613 | 550613 | 2020-09-20 | Blount | Alabama | 1009 | 1551 | 14 |
550614 | 550614 | 2020-09-20 | Bullock | Alabama | 1011 | 587 | 14 |
550615 | 550615 | 2020-09-20 | Butler | Alabama | 1013 | 909 | 38 |
550616 | 550616 | 2020-09-20 | Calhoun | Alabama | 1015 | 3338 | 39 |
550617 | 550617 | 2020-09-20 | Chambers | Alabama | 1017 | 1130 | 42 |
550618 | 550618 | 2020-09-20 | Cherokee | Alabama | 1019 | 565 | 16 |
550619 | 550619 | 2020-09-20 | Chilton | Alabama | 1021 | 1485 | 27 |
550620 | 550620 | 2020-09-20 | Choctaw | Alabama | 1023 | 345 | 12 |
550621 | 550621 | 2020-09-20 | Clarke | Alabama | 1025 | 1049 | 17 |
550622 | 550622 | 2020-09-20 | Clay | Alabama | 1027 | 542 | 7 |
550623 | 550623 | 2020-09-20 | Cleburne | Alabama | 1029 | 323 | 6 |
550624 | 550624 | 2020-09-20 | Coffee | Alabama | 1031 | 1277 | 8 |
550625 | 550625 | 2020-09-20 | Colbert | Alabama | 1033 | 1606 | 26 |
550626 | 550626 | 2020-09-20 | Conecuh | Alabama | 1035 | 523 | 11 |
550627 | 550627 | 2020-09-20 | Coosa | Alabama | 1037 | 164 | 3 |
550628 | 550628 | 2020-09-20 | Covington | Alabama | 1039 | 1309 | 27 |
550629 | 550629 | 2020-09-20 | Crenshaw | Alabama | 1041 | 523 | 31 |
550630 | 550630 | 2020-09-20 | Cullman | Alabama | 1043 | 1845 | 17 |
550631 | 550631 | 2020-09-20 | Dale | Alabama | 1045 | 1330 | 43 |
550632 | 550632 | 2020-09-20 | Dallas | Alabama | 1047 | 1748 | 26 |
550633 | 550633 | 2020-09-20 | DeKalb | Alabama | 1049 | 2355 | 19 |
550634 | 550634 | 2020-09-20 | Elmore | Alabama | 1051 | 2549 | 47 |
550635 | 550635 | 2020-09-20 | Escambia | Alabama | 1053 | 1562 | 25 |
550636 | 550636 | 2020-09-20 | Etowah | Alabama | 1055 | 3355 | 47 |
550637 | 550637 | 2020-09-20 | Fayette | Alabama | 1057 | 421 | 9 |
550638 | 550638 | 2020-09-20 | Franklin | Alabama | 1059 | 1743 | 28 |
550639 | 550639 | 2020-09-20 | Geneva | Alabama | 1061 | 572 | 4 |
550640 | 550640 | 2020-09-20 | Greene | Alabama | 1063 | 300 | 15 |
550641 | 550641 | 2020-09-20 | Hale | Alabama | 1065 | 615 | 28 |
550642 | 550642 | 2020-09-20 | Henry | Alabama | 1067 | 472 | 4 |
550643 | 550643 | 2020-09-20 | Houston | Alabama | 1069 | 2708 | 22 |
550644 | 550644 | 2020-09-20 | Jackson | Alabama | 1071 | 1506 | 11 |
550645 | 550645 | 2020-09-20 | Jefferson | Alabama | 1073 | 19015 | 337 |
550646 | 550646 | 2020-09-20 | Lamar | Alabama | 1075 | 346 | 2 |
550647 | 550647 | 2020-09-20 | Lauderdale | Alabama | 1077 | 1646 | 33 |
550648 | 550648 | 2020-09-20 | Lawrence | Alabama | 1079 | 585 | 20 |
550649 | 550649 | 2020-09-20 | Lee | Alabama | 1081 | 5713 | 59 |
550650 | 550650 | 2020-09-20 | Limestone | Alabama | 1083 | 1995 | 19 |
550651 | 550651 | 2020-09-20 | Lowndes | Alabama | 1085 | 648 | 27 |
550652 | 550652 | 2020-09-20 | Macon | Alabama | 1087 | 477 | 20 |
550653 | 550653 | 2020-09-20 | Madison | Alabama | 1089 | 7583 | 75 |
550654 | 550654 | 2020-09-20 | Marengo | Alabama | 1091 | 699 | 19 |
550655 | 550655 | 2020-09-20 | Marion | Alabama | 1093 | 942 | 28 |
550656 | 550656 | 2020-09-20 | Marshall | Alabama | 1095 | 3835 | 43 |
550657 | 550657 | 2020-09-20 | Mobile | Alabama | 1097 | 13066 | 289 |
550658 | 550658 | 2020-09-20 | Monroe | Alabama | 1099 | 575 | 8 |
550659 | 550659 | 2020-09-20 | Montgomery | Alabama | 1101 | 8674 | 173 |
550660 | 550660 | 2020-09-20 | Morgan | Alabama | 1103 | 3197 | 26 |
550661 | 550661 | 2020-09-20 | Perry | Alabama | 1105 | 537 | 6 |
550662 | 550662 | 2020-09-20 | Pickens | Alabama | 1107 | 635 | 14 |
550663 | 550663 | 2020-09-20 | Pike | Alabama | 1109 | 1155 | 9 |
550664 | 550664 | 2020-09-20 | Randolph | Alabama | 1111 | 608 | 12 |
550665 | 550665 | 2020-09-20 | Russell | Alabama | 1113 | 1713 | 2 |
550666 | 550666 | 2020-09-20 | Shelby | Alabama | 1117 | 5684 | 50 |
550667 | 550667 | 2020-09-20 | St. Clair | Alabama | 1115 | 2234 | 35 |
550668 | 550668 | 2020-09-20 | Sumter | Alabama | 1119 | 418 | 19 |
550669 | 550669 | 2020-09-20 | Talladega | Alabama | 1121 | 2069 | 26 |
550670 | 550670 | 2020-09-20 | Tallapoosa | Alabama | 1123 | 1136 | 83 |
550671 | 550671 | 2020-09-20 | Tuscaloosa | Alabama | 1125 | 7240 | 114 |
550672 | 550672 | 2020-09-20 | Walker | Alabama | 1127 | 2226 | 80 |
550673 | 550673 | 2020-09-20 | Washington | Alabama | 1129 | 546 | 13 |
550674 | 550674 | 2020-09-20 | Wilcox | Alabama | 1131 | 531 | 11 |
550675 | 550675 | 2020-09-20 | Winston | Alabama | 1133 | 709 | 12 |
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);