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-05-22 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1342476 | 1342476 | 2021-05-22 | Autauga | Alabama | 1001 | 7113 | 110 |
1342477 | 1342477 | 2021-05-22 | Baldwin | Alabama | 1003 | 21535 | 310 |
1342478 | 1342478 | 2021-05-22 | Barbour | Alabama | 1005 | 2328 | 58 |
1342479 | 1342479 | 2021-05-22 | Bibb | Alabama | 1007 | 2656 | 64 |
1342480 | 1342480 | 2021-05-22 | Blount | Alabama | 1009 | 6829 | 139 |
1342481 | 1342481 | 2021-05-22 | Bullock | Alabama | 1011 | 1233 | 42 |
1342482 | 1342482 | 2021-05-22 | Butler | Alabama | 1013 | 2201 | 70 |
1342483 | 1342483 | 2021-05-22 | Calhoun | Alabama | 1015 | 14595 | 322 |
1342484 | 1342484 | 2021-05-22 | Chambers | Alabama | 1017 | 3636 | 123 |
1342485 | 1342485 | 2021-05-22 | Cherokee | Alabama | 1019 | 1854 | 45 |
1342486 | 1342486 | 2021-05-22 | Chilton | Alabama | 1021 | 4409 | 115 |
1342487 | 1342487 | 2021-05-22 | Choctaw | Alabama | 1023 | 613 | 25 |
1342488 | 1342488 | 2021-05-22 | Clarke | Alabama | 1025 | 3517 | 61 |
1342489 | 1342489 | 2021-05-22 | Clay | Alabama | 1027 | 1578 | 57 |
1342490 | 1342490 | 2021-05-22 | Cleburne | Alabama | 1029 | 1502 | 42 |
1342491 | 1342491 | 2021-05-22 | Coffee | Alabama | 1031 | 5592 | 120 |
1342492 | 1342492 | 2021-05-22 | Colbert | Alabama | 1033 | 6335 | 137 |
1342493 | 1342493 | 2021-05-22 | Conecuh | Alabama | 1035 | 1111 | 30 |
1342494 | 1342494 | 2021-05-22 | Coosa | Alabama | 1037 | 1097 | 29 |
1342495 | 1342495 | 2021-05-22 | Covington | Alabama | 1039 | 4175 | 119 |
1342496 | 1342496 | 2021-05-22 | Crenshaw | Alabama | 1041 | 1537 | 57 |
1342497 | 1342497 | 2021-05-22 | Cullman | Alabama | 1043 | 9812 | 197 |
1342498 | 1342498 | 2021-05-22 | Dale | Alabama | 1045 | 4890 | 114 |
1342499 | 1342499 | 2021-05-22 | Dallas | Alabama | 1047 | 3584 | 153 |
1342500 | 1342500 | 2021-05-22 | DeKalb | Alabama | 1049 | 8886 | 188 |
1342501 | 1342501 | 2021-05-22 | Elmore | Alabama | 1051 | 10213 | 207 |
1342502 | 1342502 | 2021-05-22 | Escambia | Alabama | 1053 | 3957 | 77 |
1342503 | 1342503 | 2021-05-22 | Etowah | Alabama | 1055 | 13954 | 357 |
1342504 | 1342504 | 2021-05-22 | Fayette | Alabama | 1057 | 2136 | 62 |
1342505 | 1342505 | 2021-05-22 | Franklin | Alabama | 1059 | 4266 | 82 |
1342506 | 1342506 | 2021-05-22 | Geneva | Alabama | 1061 | 2552 | 81 |
1342507 | 1342507 | 2021-05-22 | Greene | Alabama | 1063 | 927 | 34 |
1342508 | 1342508 | 2021-05-22 | Hale | Alabama | 1065 | 2246 | 78 |
1342509 | 1342509 | 2021-05-22 | Henry | Alabama | 1067 | 1917 | 43 |
1342510 | 1342510 | 2021-05-22 | Houston | Alabama | 1069 | 10689 | 284 |
1342511 | 1342511 | 2021-05-22 | Jackson | Alabama | 1071 | 6854 | 112 |
1342512 | 1342512 | 2021-05-22 | Jefferson | Alabama | 1073 | 80041 | 1535 |
1342513 | 1342513 | 2021-05-22 | Lamar | Alabama | 1075 | 1441 | 37 |
1342514 | 1342514 | 2021-05-22 | Lauderdale | Alabama | 1077 | 9495 | 245 |
1342515 | 1342515 | 2021-05-22 | Lawrence | Alabama | 1079 | 3059 | 99 |
1342516 | 1342516 | 2021-05-22 | Lee | Alabama | 1081 | 16040 | 173 |
1342517 | 1342517 | 2021-05-22 | Limestone | Alabama | 1083 | 10100 | 154 |
1342518 | 1342518 | 2021-05-22 | Lowndes | Alabama | 1085 | 1413 | 53 |
1342519 | 1342519 | 2021-05-22 | Macon | Alabama | 1087 | 1616 | 50 |
1342520 | 1342520 | 2021-05-22 | Madison | Alabama | 1089 | 35266 | 511 |
1342521 | 1342521 | 2021-05-22 | Marengo | Alabama | 1091 | 2501 | 65 |
1342522 | 1342522 | 2021-05-22 | Marion | Alabama | 1093 | 3154 | 102 |
1342523 | 1342523 | 2021-05-22 | Marshall | Alabama | 1095 | 12323 | 227 |
1342524 | 1342524 | 2021-05-22 | Mobile | Alabama | 1097 | 41408 | 814 |
1342525 | 1342525 | 2021-05-22 | Monroe | Alabama | 1099 | 1786 | 41 |
1342526 | 1342526 | 2021-05-22 | Montgomery | Alabama | 1101 | 24820 | 596 |
1342527 | 1342527 | 2021-05-22 | Morgan | Alabama | 1103 | 14485 | 281 |
1342528 | 1342528 | 2021-05-22 | Perry | Alabama | 1105 | 1080 | 26 |
1342529 | 1342529 | 2021-05-22 | Pickens | Alabama | 1107 | 2352 | 62 |
1342530 | 1342530 | 2021-05-22 | Pike | Alabama | 1109 | 3125 | 77 |
1342531 | 1342531 | 2021-05-22 | Randolph | Alabama | 1111 | 1837 | 43 |
1342532 | 1342532 | 2021-05-22 | Russell | Alabama | 1113 | 4484 | 39 |
1342533 | 1342533 | 2021-05-22 | Shelby | Alabama | 1117 | 25347 | 251 |
1342534 | 1342534 | 2021-05-22 | St. Clair | Alabama | 1115 | 9982 | 246 |
1342535 | 1342535 | 2021-05-22 | Sumter | Alabama | 1119 | 1053 | 32 |
1342536 | 1342536 | 2021-05-22 | Talladega | Alabama | 1121 | 8362 | 179 |
1342537 | 1342537 | 2021-05-22 | Tallapoosa | Alabama | 1123 | 4058 | 152 |
1342538 | 1342538 | 2021-05-22 | Tuscaloosa | Alabama | 1125 | 25984 | 457 |
1342539 | 1342539 | 2021-05-22 | Walker | Alabama | 1127 | 7270 | 279 |
1342540 | 1342540 | 2021-05-22 | Washington | Alabama | 1129 | 1682 | 39 |
1342541 | 1342541 | 2021-05-22 | Wilcox | Alabama | 1131 | 1274 | 30 |
1342542 | 1342542 | 2021-05-22 | Winston | Alabama | 1133 | 2761 | 73 |
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);