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-07-14 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1514508 | 1514508 | 2021-07-14 | Autauga | Alabama | 1001 | 7320 | 113 |
1514509 | 1514509 | 2021-07-14 | Baldwin | Alabama | 1003 | 22464 | 321 |
1514510 | 1514510 | 2021-07-14 | Barbour | Alabama | 1005 | 2373 | 60 |
1514511 | 1514511 | 2021-07-14 | Bibb | Alabama | 1007 | 2708 | 65 |
1514512 | 1514512 | 2021-07-14 | Blount | Alabama | 1009 | 7055 | 139 |
1514513 | 1514513 | 2021-07-14 | Bullock | Alabama | 1011 | 1250 | 42 |
1514514 | 1514514 | 2021-07-14 | Butler | Alabama | 1013 | 2288 | 71 |
1514515 | 1514515 | 2021-07-14 | Calhoun | Alabama | 1015 | 14861 | 331 |
1514516 | 1514516 | 2021-07-14 | Chambers | Alabama | 1017 | 3773 | 124 |
1514517 | 1514517 | 2021-07-14 | Cherokee | Alabama | 1019 | 1898 | 47 |
1514518 | 1514518 | 2021-07-14 | Chilton | Alabama | 1021 | 4532 | 116 |
1514519 | 1514519 | 2021-07-14 | Choctaw | Alabama | 1023 | 627 | 25 |
1514520 | 1514520 | 2021-07-14 | Clarke | Alabama | 1025 | 3559 | 62 |
1514521 | 1514521 | 2021-07-14 | Clay | Alabama | 1027 | 1610 | 59 |
1514522 | 1514522 | 2021-07-14 | Cleburne | Alabama | 1029 | 1555 | 43 |
1514523 | 1514523 | 2021-07-14 | Coffee | Alabama | 1031 | 5794 | 130 |
1514524 | 1514524 | 2021-07-14 | Colbert | Alabama | 1033 | 6473 | 141 |
1514525 | 1514525 | 2021-07-14 | Conecuh | Alabama | 1035 | 1161 | 30 |
1514526 | 1514526 | 2021-07-14 | Coosa | Alabama | 1037 | 1130 | 29 |
1514527 | 1514527 | 2021-07-14 | Covington | Alabama | 1039 | 4401 | 125 |
1514528 | 1514528 | 2021-07-14 | Crenshaw | Alabama | 1041 | 1610 | 57 |
1514529 | 1514529 | 2021-07-14 | Cullman | Alabama | 1043 | 10081 | 203 |
1514530 | 1514530 | 2021-07-14 | Dale | Alabama | 1045 | 5067 | 117 |
1514531 | 1514531 | 2021-07-14 | Dallas | Alabama | 1047 | 3645 | 161 |
1514532 | 1514532 | 2021-07-14 | DeKalb | Alabama | 1049 | 9082 | 191 |
1514533 | 1514533 | 2021-07-14 | Elmore | Alabama | 1051 | 10429 | 216 |
1514534 | 1514534 | 2021-07-14 | Escambia | Alabama | 1053 | 4067 | 82 |
1514535 | 1514535 | 2021-07-14 | Etowah | Alabama | 1055 | 14336 | 367 |
1514536 | 1514536 | 2021-07-14 | Fayette | Alabama | 1057 | 2213 | 63 |
1514537 | 1514537 | 2021-07-14 | Franklin | Alabama | 1059 | 4344 | 81 |
1514538 | 1514538 | 2021-07-14 | Geneva | Alabama | 1061 | 2628 | 82 |
1514539 | 1514539 | 2021-07-14 | Greene | Alabama | 1063 | 944 | 35 |
1514540 | 1514540 | 2021-07-14 | Hale | Alabama | 1065 | 2291 | 78 |
1514541 | 1514541 | 2021-07-14 | Henry | Alabama | 1067 | 1986 | 44 |
1514542 | 1514542 | 2021-07-14 | Houston | Alabama | 1069 | 11038 | 291 |
1514543 | 1514543 | 2021-07-14 | Jackson | Alabama | 1071 | 7129 | 116 |
1514544 | 1514544 | 2021-07-14 | Jefferson | Alabama | 1073 | 81862 | 1581 |
1514545 | 1514545 | 2021-07-14 | Lamar | Alabama | 1075 | 1481 | 38 |
1514546 | 1514546 | 2021-07-14 | Lauderdale | Alabama | 1077 | 9754 | 253 |
1514547 | 1514547 | 2021-07-14 | Lawrence | Alabama | 1079 | 3155 | 101 |
1514548 | 1514548 | 2021-07-14 | Lee | Alabama | 1081 | 16483 | 179 |
1514549 | 1514549 | 2021-07-14 | Limestone | Alabama | 1083 | 10299 | 158 |
1514550 | 1514550 | 2021-07-14 | Lowndes | Alabama | 1085 | 1429 | 54 |
1514551 | 1514551 | 2021-07-14 | Macon | Alabama | 1087 | 1646 | 52 |
1514552 | 1514552 | 2021-07-14 | Madison | Alabama | 1089 | 36125 | 529 |
1514553 | 1514553 | 2021-07-14 | Marengo | Alabama | 1091 | 2535 | 67 |
1514554 | 1514554 | 2021-07-14 | Marion | Alabama | 1093 | 3317 | 106 |
1514555 | 1514555 | 2021-07-14 | Marshall | Alabama | 1095 | 12594 | 233 |
1514556 | 1514556 | 2021-07-14 | Mobile | Alabama | 1097 | 43301 | 844 |
1514557 | 1514557 | 2021-07-14 | Monroe | Alabama | 1099 | 1852 | 41 |
1514558 | 1514558 | 2021-07-14 | Montgomery | Alabama | 1101 | 25325 | 622 |
1514559 | 1514559 | 2021-07-14 | Morgan | Alabama | 1103 | 14761 | 288 |
1514560 | 1514560 | 2021-07-14 | Perry | Alabama | 1105 | 1092 | 28 |
1514561 | 1514561 | 2021-07-14 | Pickens | Alabama | 1107 | 2376 | 62 |
1514562 | 1514562 | 2021-07-14 | Pike | Alabama | 1109 | 3186 | 78 |
1514563 | 1514563 | 2021-07-14 | Randolph | Alabama | 1111 | 1899 | 44 |
1514564 | 1514564 | 2021-07-14 | Russell | Alabama | 1113 | 4594 | 42 |
1514565 | 1514565 | 2021-07-14 | Shelby | Alabama | 1117 | 26024 | 255 |
1514566 | 1514566 | 2021-07-14 | St. Clair | Alabama | 1115 | 10261 | 251 |
1514567 | 1514567 | 2021-07-14 | Sumter | Alabama | 1119 | 1069 | 32 |
1514568 | 1514568 | 2021-07-14 | Talladega | Alabama | 1121 | 8559 | 185 |
1514569 | 1514569 | 2021-07-14 | Tallapoosa | Alabama | 1123 | 4245 | 156 |
1514570 | 1514570 | 2021-07-14 | Tuscaloosa | Alabama | 1125 | 26369 | 465 |
1514571 | 1514571 | 2021-07-14 | Walker | Alabama | 1127 | 7449 | 285 |
1514572 | 1514572 | 2021-07-14 | Washington | Alabama | 1129 | 1721 | 39 |
1514573 | 1514573 | 2021-07-14 | Wilcox | Alabama | 1131 | 1277 | 31 |
1514574 | 1514574 | 2021-07-14 | Winston | Alabama | 1133 | 2851 | 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);