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-08-17 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1624940 | 1624940 | 2021-08-17 | Autauga | Alabama | 1001 | 8091 | 115 |
1624941 | 1624941 | 2021-08-17 | Baldwin | Alabama | 1003 | 29465 | 350 |
1624942 | 1624942 | 2021-08-17 | Barbour | Alabama | 1005 | 2785 | 65 |
1624943 | 1624943 | 2021-08-17 | Bibb | Alabama | 1007 | 3152 | 68 |
1624944 | 1624944 | 2021-08-17 | Blount | Alabama | 1009 | 7884 | 142 |
1624945 | 1624945 | 2021-08-17 | Bullock | Alabama | 1011 | 1314 | 41 |
1624946 | 1624946 | 2021-08-17 | Butler | Alabama | 1013 | 2604 | 72 |
1624947 | 1624947 | 2021-08-17 | Calhoun | Alabama | 1015 | 16407 | 344 |
1624948 | 1624948 | 2021-08-17 | Chambers | Alabama | 1017 | 4322 | 125 |
1624949 | 1624949 | 2021-08-17 | Cherokee | Alabama | 1019 | 2165 | 49 |
1624950 | 1624950 | 2021-08-17 | Chilton | Alabama | 1021 | 5122 | 118 |
1624951 | 1624951 | 2021-08-17 | Choctaw | Alabama | 1023 | 659 | 25 |
1624952 | 1624952 | 2021-08-17 | Clarke | Alabama | 1025 | 3955 | 63 |
1624953 | 1624953 | 2021-08-17 | Clay | Alabama | 1027 | 1774 | 60 |
1624954 | 1624954 | 2021-08-17 | Cleburne | Alabama | 1029 | 1694 | 45 |
1624955 | 1624955 | 2021-08-17 | Coffee | Alabama | 1031 | 7339 | 138 |
1624956 | 1624956 | 2021-08-17 | Colbert | Alabama | 1033 | 7214 | 145 |
1624957 | 1624957 | 2021-08-17 | Conecuh | Alabama | 1035 | 1361 | 33 |
1624958 | 1624958 | 2021-08-17 | Coosa | Alabama | 1037 | 1268 | 30 |
1624959 | 1624959 | 2021-08-17 | Covington | Alabama | 1039 | 5255 | 130 |
1624960 | 1624960 | 2021-08-17 | Crenshaw | Alabama | 1041 | 1847 | 59 |
1624961 | 1624961 | 2021-08-17 | Cullman | Alabama | 1043 | 11365 | 212 |
1624962 | 1624962 | 2021-08-17 | Dale | Alabama | 1045 | 6632 | 126 |
1624963 | 1624963 | 2021-08-17 | Dallas | Alabama | 1047 | 3965 | 165 |
1624964 | 1624964 | 2021-08-17 | DeKalb | Alabama | 1049 | 10147 | 197 |
1624965 | 1624965 | 2021-08-17 | Elmore | Alabama | 1051 | 11871 | 228 |
1624966 | 1624966 | 2021-08-17 | Escambia | Alabama | 1053 | 5181 | 84 |
1624967 | 1624967 | 2021-08-17 | Etowah | Alabama | 1055 | 16053 | 377 |
1624968 | 1624968 | 2021-08-17 | Fayette | Alabama | 1057 | 2381 | 65 |
1624969 | 1624969 | 2021-08-17 | Franklin | Alabama | 1059 | 4902 | 83 |
1624970 | 1624970 | 2021-08-17 | Geneva | Alabama | 1061 | 3285 | 86 |
1624971 | 1624971 | 2021-08-17 | Greene | Alabama | 1063 | 1035 | 39 |
1624972 | 1624972 | 2021-08-17 | Hale | Alabama | 1065 | 2473 | 79 |
1624973 | 1624973 | 2021-08-17 | Henry | Alabama | 1067 | 2447 | 45 |
1624974 | 1624974 | 2021-08-17 | Houston | Alabama | 1069 | 13491 | 302 |
1624975 | 1624975 | 2021-08-17 | Jackson | Alabama | 1071 | 7728 | 122 |
1624976 | 1624976 | 2021-08-17 | Jefferson | Alabama | 1073 | 92736 | 1616 |
1624977 | 1624977 | 2021-08-17 | Lamar | Alabama | 1075 | 1595 | 38 |
1624978 | 1624978 | 2021-08-17 | Lauderdale | Alabama | 1077 | 11064 | 256 |
1624979 | 1624979 | 2021-08-17 | Lawrence | Alabama | 1079 | 3433 | 100 |
1624980 | 1624980 | 2021-08-17 | Lee | Alabama | 1081 | 18623 | 189 |
1624981 | 1624981 | 2021-08-17 | Limestone | Alabama | 1083 | 11598 | 166 |
1624982 | 1624982 | 2021-08-17 | Lowndes | Alabama | 1085 | 1514 | 55 |
1624983 | 1624983 | 2021-08-17 | Macon | Alabama | 1087 | 1818 | 54 |
1624984 | 1624984 | 2021-08-17 | Madison | Alabama | 1089 | 40001 | 538 |
1624985 | 1624985 | 2021-08-17 | Marengo | Alabama | 1091 | 2782 | 67 |
1624986 | 1624986 | 2021-08-17 | Marion | Alabama | 1093 | 3761 | 108 |
1624987 | 1624987 | 2021-08-17 | Marshall | Alabama | 1095 | 14163 | 239 |
1624988 | 1624988 | 2021-08-17 | Mobile | Alabama | 1097 | 57593 | 927 |
1624989 | 1624989 | 2021-08-17 | Monroe | Alabama | 1099 | 2356 | 42 |
1624990 | 1624990 | 2021-08-17 | Montgomery | Alabama | 1101 | 28092 | 631 |
1624991 | 1624991 | 2021-08-17 | Morgan | Alabama | 1103 | 16030 | 291 |
1624992 | 1624992 | 2021-08-17 | Perry | Alabama | 1105 | 1161 | 28 |
1624993 | 1624993 | 2021-08-17 | Pickens | Alabama | 1107 | 2609 | 63 |
1624994 | 1624994 | 2021-08-17 | Pike | Alabama | 1109 | 3614 | 81 |
1624995 | 1624995 | 2021-08-17 | Randolph | Alabama | 1111 | 2181 | 53 |
1624996 | 1624996 | 2021-08-17 | Russell | Alabama | 1113 | 5130 | 51 |
1624997 | 1624997 | 2021-08-17 | Shelby | Alabama | 1117 | 29561 | 269 |
1624998 | 1624998 | 2021-08-17 | St. Clair | Alabama | 1115 | 11801 | 253 |
1624999 | 1624999 | 2021-08-17 | Sumter | Alabama | 1119 | 1149 | 34 |
1625000 | 1625000 | 2021-08-17 | Talladega | Alabama | 1121 | 9617 | 191 |
1625001 | 1625001 | 2021-08-17 | Tallapoosa | Alabama | 1123 | 5036 | 157 |
1625002 | 1625002 | 2021-08-17 | Tuscaloosa | Alabama | 1125 | 28597 | 473 |
1625003 | 1625003 | 2021-08-17 | Walker | Alabama | 1127 | 8426 | 291 |
1625004 | 1625004 | 2021-08-17 | Washington | Alabama | 1129 | 2091 | 39 |
1625005 | 1625005 | 2021-08-17 | Wilcox | Alabama | 1131 | 1367 | 31 |
1625006 | 1625006 | 2021-08-17 | Winston | Alabama | 1133 | 3254 | 74 |
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);