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-04-08 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1199606 | 1199606 | 2021-04-08 | Autauga | Alabama | 1001 | 6702 | 103 |
1199607 | 1199607 | 2021-04-08 | Baldwin | Alabama | 1003 | 20588 | 300 |
1199608 | 1199608 | 2021-04-08 | Barbour | Alabama | 1005 | 2244 | 55 |
1199609 | 1199609 | 2021-04-08 | Bibb | Alabama | 1007 | 2560 | 58 |
1199610 | 1199610 | 2021-04-08 | Blount | Alabama | 1009 | 6472 | 134 |
1199611 | 1199611 | 2021-04-08 | Bullock | Alabama | 1011 | 1213 | 40 |
1199612 | 1199612 | 2021-04-08 | Butler | Alabama | 1013 | 2119 | 66 |
1199613 | 1199613 | 2021-04-08 | Calhoun | Alabama | 1015 | 14263 | 310 |
1199614 | 1199614 | 2021-04-08 | Chambers | Alabama | 1017 | 3494 | 122 |
1199615 | 1199615 | 2021-04-08 | Cherokee | Alabama | 1019 | 1818 | 43 |
1199616 | 1199616 | 2021-04-08 | Chilton | Alabama | 1021 | 4073 | 109 |
1199617 | 1199617 | 2021-04-08 | Choctaw | Alabama | 1023 | 585 | 24 |
1199618 | 1199618 | 2021-04-08 | Clarke | Alabama | 1025 | 3457 | 60 |
1199619 | 1199619 | 2021-04-08 | Clay | Alabama | 1027 | 1490 | 54 |
1199620 | 1199620 | 2021-04-08 | Cleburne | Alabama | 1029 | 1458 | 41 |
1199621 | 1199621 | 2021-04-08 | Coffee | Alabama | 1031 | 5393 | 112 |
1199622 | 1199622 | 2021-04-08 | Colbert | Alabama | 1033 | 6196 | 129 |
1199623 | 1199623 | 2021-04-08 | Conecuh | Alabama | 1035 | 1090 | 28 |
1199624 | 1199624 | 2021-04-08 | Coosa | Alabama | 1037 | 989 | 27 |
1199625 | 1199625 | 2021-04-08 | Covington | Alabama | 1039 | 4053 | 112 |
1199626 | 1199626 | 2021-04-08 | Crenshaw | Alabama | 1041 | 1491 | 57 |
1199627 | 1199627 | 2021-04-08 | Cullman | Alabama | 1043 | 9450 | 188 |
1199628 | 1199628 | 2021-04-08 | Dale | Alabama | 1045 | 4764 | 109 |
1199629 | 1199629 | 2021-04-08 | Dallas | Alabama | 1047 | 3519 | 149 |
1199630 | 1199630 | 2021-04-08 | DeKalb | Alabama | 1049 | 8727 | 181 |
1199631 | 1199631 | 2021-04-08 | Elmore | Alabama | 1051 | 9977 | 199 |
1199632 | 1199632 | 2021-04-08 | Escambia | Alabama | 1053 | 3872 | 74 |
1199633 | 1199633 | 2021-04-08 | Etowah | Alabama | 1055 | 13654 | 345 |
1199634 | 1199634 | 2021-04-08 | Fayette | Alabama | 1057 | 2086 | 60 |
1199635 | 1199635 | 2021-04-08 | Franklin | Alabama | 1059 | 4195 | 82 |
1199636 | 1199636 | 2021-04-08 | Geneva | Alabama | 1061 | 2457 | 75 |
1199637 | 1199637 | 2021-04-08 | Greene | Alabama | 1063 | 906 | 34 |
1199638 | 1199638 | 2021-04-08 | Hale | Alabama | 1065 | 2186 | 75 |
1199639 | 1199639 | 2021-04-08 | Henry | Alabama | 1067 | 1876 | 44 |
1199640 | 1199640 | 2021-04-08 | Houston | Alabama | 1069 | 10370 | 277 |
1199641 | 1199641 | 2021-04-08 | Jackson | Alabama | 1071 | 6749 | 108 |
1199642 | 1199642 | 2021-04-08 | Jefferson | Alabama | 1073 | 75199 | 1485 |
1199643 | 1199643 | 2021-04-08 | Lamar | Alabama | 1075 | 1392 | 34 |
1199644 | 1199644 | 2021-04-08 | Lauderdale | Alabama | 1077 | 9188 | 227 |
1199645 | 1199645 | 2021-04-08 | Lawrence | Alabama | 1079 | 2950 | 95 |
1199646 | 1199646 | 2021-04-08 | Lee | Alabama | 1081 | 15480 | 165 |
1199647 | 1199647 | 2021-04-08 | Limestone | Alabama | 1083 | 9791 | 146 |
1199648 | 1199648 | 2021-04-08 | Lowndes | Alabama | 1085 | 1363 | 53 |
1199649 | 1199649 | 2021-04-08 | Macon | Alabama | 1087 | 1545 | 48 |
1199650 | 1199650 | 2021-04-08 | Madison | Alabama | 1089 | 33754 | 490 |
1199651 | 1199651 | 2021-04-08 | Marengo | Alabama | 1091 | 2485 | 60 |
1199652 | 1199652 | 2021-04-08 | Marion | Alabama | 1093 | 3064 | 100 |
1199653 | 1199653 | 2021-04-08 | Marshall | Alabama | 1095 | 11935 | 218 |
1199654 | 1199654 | 2021-04-08 | Mobile | Alabama | 1097 | 37661 | 796 |
1199655 | 1199655 | 2021-04-08 | Monroe | Alabama | 1099 | 1712 | 40 |
1199656 | 1199656 | 2021-04-08 | Montgomery | Alabama | 1101 | 23905 | 561 |
1199657 | 1199657 | 2021-04-08 | Morgan | Alabama | 1103 | 14131 | 268 |
1199658 | 1199658 | 2021-04-08 | Perry | Alabama | 1105 | 1079 | 26 |
1199659 | 1199659 | 2021-04-08 | Pickens | Alabama | 1107 | 2329 | 58 |
1199660 | 1199660 | 2021-04-08 | Pike | Alabama | 1109 | 3052 | 75 |
1199661 | 1199661 | 2021-04-08 | Randolph | Alabama | 1111 | 1763 | 41 |
1199662 | 1199662 | 2021-04-08 | Russell | Alabama | 1113 | 4261 | 37 |
1199663 | 1199663 | 2021-04-08 | Shelby | Alabama | 1117 | 23085 | 237 |
1199664 | 1199664 | 2021-04-08 | St. Clair | Alabama | 1115 | 9409 | 234 |
1199665 | 1199665 | 2021-04-08 | Sumter | Alabama | 1119 | 1031 | 32 |
1199666 | 1199666 | 2021-04-08 | Talladega | Alabama | 1121 | 8023 | 168 |
1199667 | 1199667 | 2021-04-08 | Tallapoosa | Alabama | 1123 | 3889 | 147 |
1199668 | 1199668 | 2021-04-08 | Tuscaloosa | Alabama | 1125 | 25221 | 441 |
1199669 | 1199669 | 2021-04-08 | Walker | Alabama | 1127 | 7080 | 274 |
1199670 | 1199670 | 2021-04-08 | Washington | Alabama | 1129 | 1638 | 38 |
1199671 | 1199671 | 2021-04-08 | Wilcox | Alabama | 1131 | 1243 | 26 |
1199672 | 1199672 | 2021-04-08 | Winston | Alabama | 1133 | 2722 | 71 |
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);