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 2022-01-10 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 |
---|---|---|---|---|---|---|---|
2099375 | 2099375 | 2022-01-10 | Autauga | Alabama | 1001 | 12029 | 162 |
2099376 | 2099376 | 2022-01-10 | Baldwin | Alabama | 1003 | 43583 | 603 |
2099377 | 2099377 | 2022-01-10 | Barbour | Alabama | 1005 | 4305 | 83 |
2099378 | 2099378 | 2022-01-10 | Bibb | Alabama | 1007 | 4939 | 95 |
2099379 | 2099379 | 2022-01-10 | Blount | Alabama | 1009 | 11893 | 202 |
2099380 | 2099380 | 2022-01-10 | Bullock | Alabama | 1011 | 1857 | 46 |
2099381 | 2099381 | 2022-01-10 | Butler | Alabama | 1013 | 4021 | 102 |
2099382 | 2099382 | 2022-01-10 | Calhoun | Alabama | 1015 | 24948 | 535 |
2099383 | 2099383 | 2022-01-10 | Chambers | Alabama | 1017 | 6959 | 147 |
2099384 | 2099384 | 2022-01-10 | Cherokee | Alabama | 1019 | 3648 | 66 |
2099385 | 2099385 | 2022-01-10 | Chilton | Alabama | 1021 | 8014 | 175 |
2099386 | 2099386 | 2022-01-10 | Choctaw | Alabama | 1023 | 1176 | 30 |
2099387 | 2099387 | 2022-01-10 | Clarke | Alabama | 1025 | 5319 | 89 |
2099388 | 2099388 | 2022-01-10 | Clay | Alabama | 1027 | 2910 | 70 |
2099389 | 2099389 | 2022-01-10 | Cleburne | Alabama | 1029 | 2778 | 61 |
2099390 | 2099390 | 2022-01-10 | Coffee | Alabama | 1031 | 10526 | 201 |
2099391 | 2099391 | 2022-01-10 | Colbert | Alabama | 1033 | 10827 | 217 |
2099392 | 2099392 | 2022-01-10 | Conecuh | Alabama | 1035 | 2216 | 62 |
2099393 | 2099393 | 2022-01-10 | Coosa | Alabama | 1037 | 2163 | 48 |
2099394 | 2099394 | 2022-01-10 | Covington | Alabama | 1039 | 7507 | 203 |
2099395 | 2099395 | 2022-01-10 | Crenshaw | Alabama | 1041 | 3000 | 80 |
2099396 | 2099396 | 2022-01-10 | Cullman | Alabama | 1043 | 18191 | 315 |
2099397 | 2099397 | 2022-01-10 | Dale | Alabama | 1045 | 10073 | 198 |
2099398 | 2099398 | 2022-01-10 | Dallas | Alabama | 1047 | 6258 | 213 |
2099399 | 2099399 | 2022-01-10 | DeKalb | Alabama | 1049 | 14246 | 283 |
2099400 | 2099400 | 2022-01-10 | Elmore | Alabama | 1051 | 18022 | 301 |
2099401 | 2099401 | 2022-01-10 | Escambia | Alabama | 1053 | 8001 | 150 |
2099402 | 2099402 | 2022-01-10 | Etowah | Alabama | 1055 | 22017 | 530 |
2099403 | 2099403 | 2022-01-10 | Fayette | Alabama | 1057 | 3575 | 86 |
2099404 | 2099404 | 2022-01-10 | Franklin | Alabama | 1059 | 6910 | 113 |
2099405 | 2099405 | 2022-01-10 | Geneva | Alabama | 1061 | 4929 | 138 |
2099406 | 2099406 | 2022-01-10 | Greene | Alabama | 1063 | 1466 | 47 |
2099407 | 2099407 | 2022-01-10 | Hale | Alabama | 1065 | 3613 | 91 |
2099408 | 2099408 | 2022-01-10 | Henry | Alabama | 1067 | 3513 | 67 |
2099409 | 2099409 | 2022-01-10 | Houston | Alabama | 1069 | 19759 | 437 |
2099410 | 2099410 | 2022-01-10 | Jackson | Alabama | 1071 | 11143 | 203 |
2099411 | 2099411 | 2022-01-10 | Jefferson | Alabama | 1073 | 142396 | 2033 |
2099412 | 2099412 | 2022-01-10 | Lamar | Alabama | 1075 | 2698 | 60 |
2099413 | 2099413 | 2022-01-10 | Lauderdale | Alabama | 1077 | 17273 | 320 |
2099414 | 2099414 | 2022-01-10 | Lawrence | Alabama | 1079 | 5458 | 138 |
2099415 | 2099415 | 2022-01-10 | Lee | Alabama | 1081 | 29985 | 271 |
2099416 | 2099416 | 2022-01-10 | Limestone | Alabama | 1083 | 18644 | 231 |
2099417 | 2099417 | 2022-01-10 | Lowndes | Alabama | 1085 | 2117 | 68 |
2099418 | 2099418 | 2022-01-10 | Macon | Alabama | 1087 | 2987 | 69 |
2099419 | 2099419 | 2022-01-10 | Madison | Alabama | 1089 | 64761 | 776 |
2099420 | 2099420 | 2022-01-10 | Marengo | Alabama | 1091 | 3742 | 93 |
2099421 | 2099421 | 2022-01-10 | Marion | Alabama | 1093 | 5863 | 132 |
2099422 | 2099422 | 2022-01-10 | Marshall | Alabama | 1095 | 20681 | 329 |
2099423 | 2099423 | 2022-01-10 | Mobile | Alabama | 1097 | 88562 | 1401 |
2099424 | 2099424 | 2022-01-10 | Monroe | Alabama | 1099 | 3968 | 66 |
2099425 | 2099425 | 2022-01-10 | Montgomery | Alabama | 1101 | 43660 | 802 |
2099426 | 2099426 | 2022-01-10 | Morgan | Alabama | 1103 | 25883 | 431 |
2099427 | 2099427 | 2022-01-10 | Perry | Alabama | 1105 | 1642 | 41 |
2099428 | 2099428 | 2022-01-10 | Pickens | Alabama | 1107 | 3826 | 92 |
2099429 | 2099429 | 2022-01-10 | Pike | Alabama | 1109 | 5878 | 112 |
2099430 | 2099430 | 2022-01-10 | Randolph | Alabama | 1111 | 4001 | 68 |
2099431 | 2099431 | 2022-01-10 | Russell | Alabama | 1113 | 8132 | 68 |
2099432 | 2099432 | 2022-01-10 | Shelby | Alabama | 1117 | 45367 | 383 |
2099433 | 2099433 | 2022-01-10 | St. Clair | Alabama | 1115 | 19537 | 367 |
2099434 | 2099434 | 2022-01-10 | Sumter | Alabama | 1119 | 1692 | 42 |
2099435 | 2099435 | 2022-01-10 | Talladega | Alabama | 1121 | 16560 | 313 |
2099436 | 2099436 | 2022-01-10 | Tallapoosa | Alabama | 1123 | 8669 | 207 |
2099437 | 2099437 | 2022-01-10 | Tuscaloosa | Alabama | 1125 | 41162 | 666 |
2099438 | 2099438 | 2022-01-10 | Walker | Alabama | 1127 | 13397 | 392 |
2099439 | 2099439 | 2022-01-10 | Washington | Alabama | 1129 | 2770 | 52 |
2099440 | 2099440 | 2022-01-10 | Wilcox | Alabama | 1131 | 2019 | 38 |
2099441 | 2099441 | 2022-01-10 | Winston | Alabama | 1133 | 5218 | 114 |
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);