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-06-23 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1446343 | 1446343 | 2021-06-23 | Autauga | Alabama | 1001 | 7244 | 113 |
1446344 | 1446344 | 2021-06-23 | Baldwin | Alabama | 1003 | 21921 | 314 |
1446345 | 1446345 | 2021-06-23 | Barbour | Alabama | 1005 | 2344 | 60 |
1446346 | 1446346 | 2021-06-23 | Bibb | Alabama | 1007 | 2686 | 64 |
1446347 | 1446347 | 2021-06-23 | Blount | Alabama | 1009 | 6957 | 139 |
1446348 | 1446348 | 2021-06-23 | Bullock | Alabama | 1011 | 1246 | 42 |
1446349 | 1446349 | 2021-06-23 | Butler | Alabama | 1013 | 2250 | 71 |
1446350 | 1446350 | 2021-06-23 | Calhoun | Alabama | 1015 | 14725 | 329 |
1446351 | 1446351 | 2021-06-23 | Chambers | Alabama | 1017 | 3731 | 124 |
1446352 | 1446352 | 2021-06-23 | Cherokee | Alabama | 1019 | 1875 | 45 |
1446353 | 1446353 | 2021-06-23 | Chilton | Alabama | 1021 | 4476 | 116 |
1446354 | 1446354 | 2021-06-23 | Choctaw | Alabama | 1023 | 621 | 25 |
1446355 | 1446355 | 2021-06-23 | Clarke | Alabama | 1025 | 3533 | 61 |
1446356 | 1446356 | 2021-06-23 | Clay | Alabama | 1027 | 1601 | 59 |
1446357 | 1446357 | 2021-06-23 | Cleburne | Alabama | 1029 | 1537 | 44 |
1446358 | 1446358 | 2021-06-23 | Coffee | Alabama | 1031 | 5650 | 128 |
1446359 | 1446359 | 2021-06-23 | Colbert | Alabama | 1033 | 6418 | 140 |
1446360 | 1446360 | 2021-06-23 | Conecuh | Alabama | 1035 | 1138 | 30 |
1446361 | 1446361 | 2021-06-23 | Coosa | Alabama | 1037 | 1121 | 29 |
1446362 | 1446362 | 2021-06-23 | Covington | Alabama | 1039 | 4283 | 123 |
1446363 | 1446363 | 2021-06-23 | Crenshaw | Alabama | 1041 | 1561 | 57 |
1446364 | 1446364 | 2021-06-23 | Cullman | Alabama | 1043 | 9975 | 201 |
1446365 | 1446365 | 2021-06-23 | Dale | Alabama | 1045 | 4931 | 116 |
1446366 | 1446366 | 2021-06-23 | Dallas | Alabama | 1047 | 3609 | 158 |
1446367 | 1446367 | 2021-06-23 | DeKalb | Alabama | 1049 | 8978 | 190 |
1446368 | 1446368 | 2021-06-23 | Elmore | Alabama | 1051 | 10302 | 214 |
1446369 | 1446369 | 2021-06-23 | Escambia | Alabama | 1053 | 4023 | 80 |
1446370 | 1446370 | 2021-06-23 | Etowah | Alabama | 1055 | 14192 | 364 |
1446371 | 1446371 | 2021-06-23 | Fayette | Alabama | 1057 | 2197 | 63 |
1446372 | 1446372 | 2021-06-23 | Franklin | Alabama | 1059 | 4320 | 82 |
1446373 | 1446373 | 2021-06-23 | Geneva | Alabama | 1061 | 2587 | 82 |
1446374 | 1446374 | 2021-06-23 | Greene | Alabama | 1063 | 937 | 34 |
1446375 | 1446375 | 2021-06-23 | Hale | Alabama | 1065 | 2270 | 78 |
1446376 | 1446376 | 2021-06-23 | Henry | Alabama | 1067 | 1948 | 44 |
1446377 | 1446377 | 2021-06-23 | Houston | Alabama | 1069 | 10798 | 289 |
1446378 | 1446378 | 2021-06-23 | Jackson | Alabama | 1071 | 6993 | 113 |
1446379 | 1446379 | 2021-06-23 | Jefferson | Alabama | 1073 | 81085 | 1571 |
1446380 | 1446380 | 2021-06-23 | Lamar | Alabama | 1075 | 1472 | 37 |
1446381 | 1446381 | 2021-06-23 | Lauderdale | Alabama | 1077 | 9621 | 250 |
1446382 | 1446382 | 2021-06-23 | Lawrence | Alabama | 1079 | 3135 | 100 |
1446383 | 1446383 | 2021-06-23 | Lee | Alabama | 1081 | 16301 | 176 |
1446384 | 1446384 | 2021-06-23 | Limestone | Alabama | 1083 | 10191 | 157 |
1446385 | 1446385 | 2021-06-23 | Lowndes | Alabama | 1085 | 1421 | 54 |
1446386 | 1446386 | 2021-06-23 | Macon | Alabama | 1087 | 1630 | 51 |
1446387 | 1446387 | 2021-06-23 | Madison | Alabama | 1089 | 35733 | 524 |
1446388 | 1446388 | 2021-06-23 | Marengo | Alabama | 1091 | 2505 | 66 |
1446389 | 1446389 | 2021-06-23 | Marion | Alabama | 1093 | 3264 | 107 |
1446390 | 1446390 | 2021-06-23 | Marshall | Alabama | 1095 | 12465 | 230 |
1446391 | 1446391 | 2021-06-23 | Mobile | Alabama | 1097 | 42180 | 832 |
1446392 | 1446392 | 2021-06-23 | Monroe | Alabama | 1099 | 1810 | 41 |
1446393 | 1446393 | 2021-06-23 | Montgomery | Alabama | 1101 | 25103 | 615 |
1446394 | 1446394 | 2021-06-23 | Morgan | Alabama | 1103 | 14650 | 286 |
1446395 | 1446395 | 2021-06-23 | Perry | Alabama | 1105 | 1088 | 26 |
1446396 | 1446396 | 2021-06-23 | Pickens | Alabama | 1107 | 2370 | 62 |
1446397 | 1446397 | 2021-06-23 | Pike | Alabama | 1109 | 3148 | 78 |
1446398 | 1446398 | 2021-06-23 | Randolph | Alabama | 1111 | 1877 | 44 |
1446399 | 1446399 | 2021-06-23 | Russell | Alabama | 1113 | 4552 | 41 |
1446400 | 1446400 | 2021-06-23 | Shelby | Alabama | 1117 | 25638 | 255 |
1446401 | 1446401 | 2021-06-23 | St. Clair | Alabama | 1115 | 10166 | 251 |
1446402 | 1446402 | 2021-06-23 | Sumter | Alabama | 1119 | 1060 | 32 |
1446403 | 1446403 | 2021-06-23 | Talladega | Alabama | 1121 | 8467 | 184 |
1446404 | 1446404 | 2021-06-23 | Tallapoosa | Alabama | 1123 | 4137 | 155 |
1446405 | 1446405 | 2021-06-23 | Tuscaloosa | Alabama | 1125 | 26186 | 460 |
1446406 | 1446406 | 2021-06-23 | Walker | Alabama | 1127 | 7351 | 281 |
1446407 | 1446407 | 2021-06-23 | Washington | Alabama | 1129 | 1706 | 39 |
1446408 | 1446408 | 2021-06-23 | Wilcox | Alabama | 1131 | 1268 | 30 |
1446409 | 1446409 | 2021-06-23 | Winston | Alabama | 1133 | 2836 | 72 |
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);