ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-07-07" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
309197 | 309197 | 2020-07-07 | Autauga | Alabama | 1001 | 644 | 13 |
309198 | 309198 | 2020-07-07 | Baldwin | Alabama | 1003 | 997 | 10 |
309199 | 309199 | 2020-07-07 | Barbour | Alabama | 1005 | 360 | 2 |
309200 | 309200 | 2020-07-07 | Bibb | Alabama | 1007 | 199 | 1 |
309201 | 309201 | 2020-07-07 | Blount | Alabama | 1009 | 255 | 1 |
309202 | 309202 | 2020-07-07 | Bullock | Alabama | 1011 | 373 | 11 |
309203 | 309203 | 2020-07-07 | Butler | Alabama | 1013 | 634 | 28 |
309204 | 309204 | 2020-07-07 | Calhoun | Alabama | 1015 | 395 | 5 |
309205 | 309205 | 2020-07-07 | Chambers | Alabama | 1017 | 656 | 27 |
309206 | 309206 | 2020-07-07 | Cherokee | Alabama | 1019 | 106 | 7 |
309207 | 309207 | 2020-07-07 | Chilton | Alabama | 1021 | 270 | 3 |
309208 | 309208 | 2020-07-07 | Choctaw | Alabama | 1023 | 198 | 12 |
309209 | 309209 | 2020-07-07 | Clarke | Alabama | 1025 | 284 | 6 |
309210 | 309210 | 2020-07-07 | Clay | Alabama | 1027 | 69 | 2 |
309211 | 309211 | 2020-07-07 | Cleburne | Alabama | 1029 | 39 | 1 |
309212 | 309212 | 2020-07-07 | Coffee | Alabama | 1031 | 391 | 3 |
309213 | 309213 | 2020-07-07 | Colbert | Alabama | 1033 | 435 | 6 |
309214 | 309214 | 2020-07-07 | Conecuh | Alabama | 1035 | 219 | 7 |
309215 | 309215 | 2020-07-07 | Coosa | Alabama | 1037 | 59 | 1 |
309216 | 309216 | 2020-07-07 | Covington | Alabama | 1039 | 380 | 8 |
309217 | 309217 | 2020-07-07 | Crenshaw | Alabama | 1041 | 129 | 3 |
309218 | 309218 | 2020-07-07 | Cullman | Alabama | 1043 | 478 | 5 |
309219 | 309219 | 2020-07-07 | Dale | Alabama | 1045 | 305 | 0 |
309220 | 309220 | 2020-07-07 | Dallas | Alabama | 1047 | 918 | 9 |
309221 | 309221 | 2020-07-07 | DeKalb | Alabama | 1049 | 770 | 5 |
309222 | 309222 | 2020-07-07 | Elmore | Alabama | 1051 | 975 | 15 |
309223 | 309223 | 2020-07-07 | Escambia | Alabama | 1053 | 411 | 8 |
309224 | 309224 | 2020-07-07 | Etowah | Alabama | 1055 | 801 | 13 |
309225 | 309225 | 2020-07-07 | Fayette | Alabama | 1057 | 75 | 1 |
309226 | 309226 | 2020-07-07 | Franklin | Alabama | 1059 | 907 | 16 |
309227 | 309227 | 2020-07-07 | Geneva | Alabama | 1061 | 84 | 0 |
309228 | 309228 | 2020-07-07 | Greene | Alabama | 1063 | 186 | 8 |
309229 | 309229 | 2020-07-07 | Hale | Alabama | 1065 | 320 | 21 |
309230 | 309230 | 2020-07-07 | Henry | Alabama | 1067 | 137 | 4 |
309231 | 309231 | 2020-07-07 | Houston | Alabama | 1069 | 525 | 8 |
309232 | 309232 | 2020-07-07 | Jackson | Alabama | 1071 | 306 | 3 |
309233 | 309233 | 2020-07-07 | Jefferson | Alabama | 1073 | 5538 | 157 |
309234 | 309234 | 2020-07-07 | Lamar | Alabama | 1075 | 81 | 1 |
309235 | 309235 | 2020-07-07 | Lauderdale | Alabama | 1077 | 503 | 6 |
309236 | 309236 | 2020-07-07 | Lawrence | Alabama | 1079 | 112 | 0 |
309237 | 309237 | 2020-07-07 | Lee | Alabama | 1081 | 1459 | 38 |
309238 | 309238 | 2020-07-07 | Limestone | Alabama | 1083 | 523 | 1 |
309239 | 309239 | 2020-07-07 | Lowndes | Alabama | 1085 | 482 | 23 |
309240 | 309240 | 2020-07-07 | Macon | Alabama | 1087 | 203 | 9 |
309241 | 309241 | 2020-07-07 | Madison | Alabama | 1089 | 1579 | 9 |
309242 | 309242 | 2020-07-07 | Marengo | Alabama | 1091 | 319 | 11 |
309243 | 309243 | 2020-07-07 | Marion | Alabama | 1093 | 240 | 13 |
309244 | 309244 | 2020-07-07 | Marshall | Alabama | 1095 | 1781 | 11 |
309245 | 309245 | 2020-07-07 | Mobile | Alabama | 1097 | 4243 | 140 |
309246 | 309246 | 2020-07-07 | Monroe | Alabama | 1099 | 243 | 3 |
309247 | 309247 | 2020-07-07 | Montgomery | Alabama | 1101 | 4293 | 107 |
309248 | 309248 | 2020-07-07 | Morgan | Alabama | 1103 | 1142 | 5 |
309249 | 309249 | 2020-07-07 | Perry | Alabama | 1105 | 179 | 1 |
309250 | 309250 | 2020-07-07 | Pickens | Alabama | 1107 | 241 | 6 |
309251 | 309251 | 2020-07-07 | Pike | Alabama | 1109 | 459 | 5 |
309252 | 309252 | 2020-07-07 | Randolph | Alabama | 1111 | 218 | 9 |
309253 | 309253 | 2020-07-07 | Russell | Alabama | 1113 | 574 | 0 |
309254 | 309254 | 2020-07-07 | Shelby | Alabama | 1117 | 1376 | 24 |
309255 | 309255 | 2020-07-07 | St. Clair | Alabama | 1115 | 426 | 2 |
309256 | 309256 | 2020-07-07 | Sumter | Alabama | 1119 | 286 | 12 |
309257 | 309257 | 2020-07-07 | Talladega | Alabama | 1121 | 331 | 8 |
309258 | 309258 | 2020-07-07 | Tallapoosa | Alabama | 1123 | 612 | 70 |
309259 | 309259 | 2020-07-07 | Tuscaloosa | Alabama | 1125 | 2368 | 46 |
309260 | 309260 | 2020-07-07 | Walker | Alabama | 1127 | 998 | 25 |
309261 | 309261 | 2020-07-07 | Washington | Alabama | 1129 | 121 | 7 |
309262 | 309262 | 2020-07-07 | Wilcox | Alabama | 1131 | 296 | 8 |
309263 | 309263 | 2020-07-07 | Winston | Alabama | 1133 | 269 | 3 |
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);