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-03-29 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1167129 | 1167129 | 2021-03-29 | Autauga | Alabama | 1001 | 6577 | 99 |
1167130 | 1167130 | 2021-03-29 | Baldwin | Alabama | 1003 | 20487 | 301 |
1167131 | 1167131 | 2021-03-29 | Barbour | Alabama | 1005 | 2226 | 54 |
1167132 | 1167132 | 2021-03-29 | Bibb | Alabama | 1007 | 2536 | 58 |
1167133 | 1167133 | 2021-03-29 | Blount | Alabama | 1009 | 6426 | 131 |
1167134 | 1167134 | 2021-03-29 | Bullock | Alabama | 1011 | 1204 | 39 |
1167135 | 1167135 | 2021-03-29 | Butler | Alabama | 1013 | 2097 | 66 |
1167136 | 1167136 | 2021-03-29 | Calhoun | Alabama | 1015 | 14206 | 304 |
1167137 | 1167137 | 2021-03-29 | Chambers | Alabama | 1017 | 3485 | 116 |
1167138 | 1167138 | 2021-03-29 | Cherokee | Alabama | 1019 | 1804 | 43 |
1167139 | 1167139 | 2021-03-29 | Chilton | Alabama | 1021 | 4029 | 109 |
1167140 | 1167140 | 2021-03-29 | Choctaw | Alabama | 1023 | 584 | 24 |
1167141 | 1167141 | 2021-03-29 | Clarke | Alabama | 1025 | 3462 | 58 |
1167142 | 1167142 | 2021-03-29 | Clay | Alabama | 1027 | 1480 | 54 |
1167143 | 1167143 | 2021-03-29 | Cleburne | Alabama | 1029 | 1451 | 41 |
1167144 | 1167144 | 2021-03-29 | Coffee | Alabama | 1031 | 5379 | 108 |
1167145 | 1167145 | 2021-03-29 | Colbert | Alabama | 1033 | 6160 | 125 |
1167146 | 1167146 | 2021-03-29 | Conecuh | Alabama | 1035 | 1086 | 26 |
1167147 | 1167147 | 2021-03-29 | Coosa | Alabama | 1037 | 942 | 24 |
1167148 | 1167148 | 2021-03-29 | Covington | Alabama | 1039 | 4037 | 111 |
1167149 | 1167149 | 2021-03-29 | Crenshaw | Alabama | 1041 | 1502 | 57 |
1167150 | 1167150 | 2021-03-29 | Cullman | Alabama | 1043 | 9356 | 186 |
1167151 | 1167151 | 2021-03-29 | Dale | Alabama | 1045 | 4755 | 109 |
1167152 | 1167152 | 2021-03-29 | Dallas | Alabama | 1047 | 3515 | 148 |
1167153 | 1167153 | 2021-03-29 | DeKalb | Alabama | 1049 | 8693 | 179 |
1167154 | 1167154 | 2021-03-29 | Elmore | Alabama | 1051 | 9941 | 201 |
1167155 | 1167155 | 2021-03-29 | Escambia | Alabama | 1053 | 3858 | 74 |
1167156 | 1167156 | 2021-03-29 | Etowah | Alabama | 1055 | 13636 | 342 |
1167157 | 1167157 | 2021-03-29 | Fayette | Alabama | 1057 | 2061 | 59 |
1167158 | 1167158 | 2021-03-29 | Franklin | Alabama | 1059 | 4184 | 82 |
1167159 | 1167159 | 2021-03-29 | Geneva | Alabama | 1061 | 2445 | 73 |
1167160 | 1167160 | 2021-03-29 | Greene | Alabama | 1063 | 903 | 34 |
1167161 | 1167161 | 2021-03-29 | Hale | Alabama | 1065 | 2159 | 73 |
1167162 | 1167162 | 2021-03-29 | Henry | Alabama | 1067 | 1865 | 42 |
1167163 | 1167163 | 2021-03-29 | Houston | Alabama | 1069 | 10315 | 271 |
1167164 | 1167164 | 2021-03-29 | Jackson | Alabama | 1071 | 6722 | 106 |
1167165 | 1167165 | 2021-03-29 | Jefferson | Alabama | 1073 | 74571 | 1455 |
1167166 | 1167166 | 2021-03-29 | Lamar | Alabama | 1075 | 1384 | 33 |
1167167 | 1167167 | 2021-03-29 | Lauderdale | Alabama | 1077 | 9102 | 218 |
1167168 | 1167168 | 2021-03-29 | Lawrence | Alabama | 1079 | 2922 | 94 |
1167169 | 1167169 | 2021-03-29 | Lee | Alabama | 1081 | 15394 | 166 |
1167170 | 1167170 | 2021-03-29 | Limestone | Alabama | 1083 | 9728 | 145 |
1167171 | 1167171 | 2021-03-29 | Lowndes | Alabama | 1085 | 1359 | 53 |
1167172 | 1167172 | 2021-03-29 | Macon | Alabama | 1087 | 1535 | 47 |
1167173 | 1167173 | 2021-03-29 | Madison | Alabama | 1089 | 33480 | 488 |
1167174 | 1167174 | 2021-03-29 | Marengo | Alabama | 1091 | 2496 | 58 |
1167175 | 1167175 | 2021-03-29 | Marion | Alabama | 1093 | 3050 | 99 |
1167176 | 1167176 | 2021-03-29 | Marshall | Alabama | 1095 | 11842 | 217 |
1167177 | 1167177 | 2021-03-29 | Mobile | Alabama | 1097 | 37458 | 789 |
1167178 | 1167178 | 2021-03-29 | Monroe | Alabama | 1099 | 1702 | 39 |
1167179 | 1167179 | 2021-03-29 | Montgomery | Alabama | 1101 | 23687 | 550 |
1167180 | 1167180 | 2021-03-29 | Morgan | Alabama | 1103 | 14116 | 263 |
1167181 | 1167181 | 2021-03-29 | Perry | Alabama | 1105 | 1078 | 27 |
1167182 | 1167182 | 2021-03-29 | Pickens | Alabama | 1107 | 2322 | 57 |
1167183 | 1167183 | 2021-03-29 | Pike | Alabama | 1109 | 3037 | 74 |
1167184 | 1167184 | 2021-03-29 | Randolph | Alabama | 1111 | 1749 | 41 |
1167185 | 1167185 | 2021-03-29 | Russell | Alabama | 1113 | 4218 | 36 |
1167186 | 1167186 | 2021-03-29 | Shelby | Alabama | 1117 | 22994 | 232 |
1167187 | 1167187 | 2021-03-29 | St. Clair | Alabama | 1115 | 9331 | 232 |
1167188 | 1167188 | 2021-03-29 | Sumter | Alabama | 1119 | 1022 | 32 |
1167189 | 1167189 | 2021-03-29 | Talladega | Alabama | 1121 | 7967 | 167 |
1167190 | 1167190 | 2021-03-29 | Tallapoosa | Alabama | 1123 | 3845 | 144 |
1167191 | 1167191 | 2021-03-29 | Tuscaloosa | Alabama | 1125 | 25015 | 434 |
1167192 | 1167192 | 2021-03-29 | Walker | Alabama | 1127 | 7046 | 274 |
1167193 | 1167193 | 2021-03-29 | Washington | Alabama | 1129 | 1638 | 38 |
1167194 | 1167194 | 2021-03-29 | Wilcox | Alabama | 1131 | 1247 | 26 |
1167195 | 1167195 | 2021-03-29 | Winston | Alabama | 1133 | 2716 | 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);