ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-11-19" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1930343 | 1930343 | 2021-11-19 | Autauga | Alabama | 1001 | 10457 | 156 |
1930344 | 1930344 | 2021-11-19 | Baldwin | Alabama | 1003 | 37959 | 586 |
1930345 | 1930345 | 2021-11-19 | Barbour | Alabama | 1005 | 3660 | 79 |
1930346 | 1930346 | 2021-11-19 | Bibb | Alabama | 1007 | 4333 | 93 |
1930347 | 1930347 | 2021-11-19 | Blount | Alabama | 1009 | 10621 | 190 |
1930348 | 1930348 | 2021-11-19 | Bullock | Alabama | 1011 | 1524 | 45 |
1930349 | 1930349 | 2021-11-19 | Butler | Alabama | 1013 | 3409 | 100 |
1930350 | 1930350 | 2021-11-19 | Calhoun | Alabama | 1015 | 22522 | 518 |
1930351 | 1930351 | 2021-11-19 | Chambers | Alabama | 1017 | 5795 | 142 |
1930352 | 1930352 | 2021-11-19 | Cherokee | Alabama | 1019 | 3133 | 62 |
1930353 | 1930353 | 2021-11-19 | Chilton | Alabama | 1021 | 6955 | 170 |
1930354 | 1930354 | 2021-11-19 | Choctaw | Alabama | 1023 | 928 | 28 |
1930355 | 1930355 | 2021-11-19 | Clarke | Alabama | 1025 | 4836 | 86 |
1930356 | 1930356 | 2021-11-19 | Clay | Alabama | 1027 | 2507 | 69 |
1930357 | 1930357 | 2021-11-19 | Cleburne | Alabama | 1029 | 2533 | 60 |
1930358 | 1930358 | 2021-11-19 | Coffee | Alabama | 1031 | 9381 | 191 |
1930359 | 1930359 | 2021-11-19 | Colbert | Alabama | 1033 | 9280 | 207 |
1930360 | 1930360 | 2021-11-19 | Conecuh | Alabama | 1035 | 1921 | 62 |
1930361 | 1930361 | 2021-11-19 | Coosa | Alabama | 1037 | 1833 | 44 |
1930362 | 1930362 | 2021-11-19 | Covington | Alabama | 1039 | 6872 | 191 |
1930363 | 1930363 | 2021-11-19 | Crenshaw | Alabama | 1041 | 2576 | 76 |
1930364 | 1930364 | 2021-11-19 | Cullman | Alabama | 1043 | 15953 | 302 |
1930365 | 1930365 | 2021-11-19 | Dale | Alabama | 1045 | 9006 | 191 |
1930366 | 1930366 | 2021-11-19 | Dallas | Alabama | 1047 | 5280 | 208 |
1930367 | 1930367 | 2021-11-19 | DeKalb | Alabama | 1049 | 12858 | 269 |
1930368 | 1930368 | 2021-11-19 | Elmore | Alabama | 1051 | 15888 | 294 |
1930369 | 1930369 | 2021-11-19 | Escambia | Alabama | 1053 | 6930 | 140 |
1930370 | 1930370 | 2021-11-19 | Etowah | Alabama | 1055 | 19987 | 517 |
1930371 | 1930371 | 2021-11-19 | Fayette | Alabama | 1057 | 3275 | 85 |
1930372 | 1930372 | 2021-11-19 | Franklin | Alabama | 1059 | 6264 | 108 |
1930373 | 1930373 | 2021-11-19 | Geneva | Alabama | 1061 | 4623 | 134 |
1930374 | 1930374 | 2021-11-19 | Greene | Alabama | 1063 | 1298 | 45 |
1930375 | 1930375 | 2021-11-19 | Hale | Alabama | 1065 | 3163 | 89 |
1930376 | 1930376 | 2021-11-19 | Henry | Alabama | 1067 | 3195 | 66 |
1930377 | 1930377 | 2021-11-19 | Houston | Alabama | 1069 | 17684 | 423 |
1930378 | 1930378 | 2021-11-19 | Jackson | Alabama | 1071 | 10137 | 194 |
1930379 | 1930379 | 2021-11-19 | Jefferson | Alabama | 1073 | 115983 | 2002 |
1930380 | 1930380 | 2021-11-19 | Lamar | Alabama | 1075 | 2486 | 53 |
1930381 | 1930381 | 2021-11-19 | Lauderdale | Alabama | 1077 | 14883 | 306 |
1930382 | 1930382 | 2021-11-19 | Lawrence | Alabama | 1079 | 4780 | 127 |
1930383 | 1930383 | 2021-11-19 | Lee | Alabama | 1081 | 25478 | 261 |
1930384 | 1930384 | 2021-11-19 | Limestone | Alabama | 1083 | 16075 | 218 |
1930385 | 1930385 | 2021-11-19 | Lowndes | Alabama | 1085 | 1779 | 68 |
1930386 | 1930386 | 2021-11-19 | Macon | Alabama | 1087 | 2437 | 64 |
1930387 | 1930387 | 2021-11-19 | Madison | Alabama | 1089 | 53064 | 729 |
1930388 | 1930388 | 2021-11-19 | Marengo | Alabama | 1091 | 3423 | 93 |
1930389 | 1930389 | 2021-11-19 | Marion | Alabama | 1093 | 5375 | 129 |
1930390 | 1930390 | 2021-11-19 | Marshall | Alabama | 1095 | 18741 | 318 |
1930391 | 1930391 | 2021-11-19 | Mobile | Alabama | 1097 | 73989 | 1377 |
1930392 | 1930392 | 2021-11-19 | Monroe | Alabama | 1099 | 3358 | 66 |
1930393 | 1930393 | 2021-11-19 | Montgomery | Alabama | 1101 | 34431 | 781 |
1930394 | 1930394 | 2021-11-19 | Morgan | Alabama | 1103 | 22318 | 405 |
1930395 | 1930395 | 2021-11-19 | Perry | Alabama | 1105 | 1418 | 40 |
1930396 | 1930396 | 2021-11-19 | Pickens | Alabama | 1107 | 3319 | 88 |
1930397 | 1930397 | 2021-11-19 | Pike | Alabama | 1109 | 5061 | 109 |
1930398 | 1930398 | 2021-11-19 | Randolph | Alabama | 1111 | 3342 | 67 |
1930399 | 1930399 | 2021-11-19 | Russell | Alabama | 1113 | 7057 | 65 |
1930400 | 1930400 | 2021-11-19 | Shelby | Alabama | 1117 | 38202 | 367 |
1930401 | 1930401 | 2021-11-19 | St. Clair | Alabama | 1115 | 16832 | 355 |
1930402 | 1930402 | 2021-11-19 | Sumter | Alabama | 1119 | 1372 | 40 |
1930403 | 1930403 | 2021-11-19 | Talladega | Alabama | 1121 | 14137 | 298 |
1930404 | 1930404 | 2021-11-19 | Tallapoosa | Alabama | 1123 | 7186 | 202 |
1930405 | 1930405 | 2021-11-19 | Tuscaloosa | Alabama | 1125 | 35839 | 638 |
1930406 | 1930406 | 2021-11-19 | Walker | Alabama | 1127 | 11928 | 379 |
1930407 | 1930407 | 2021-11-19 | Washington | Alabama | 1129 | 2558 | 52 |
1930408 | 1930408 | 2021-11-19 | Wilcox | Alabama | 1131 | 1760 | 38 |
1930409 | 1930409 | 2021-11-19 | Winston | Alabama | 1133 | 4769 | 108 |
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);