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-03-03 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2268498 | 2268498 | 2022-03-03 | Autauga | Alabama | 1001 | 15526 | 199 |
2268499 | 2268499 | 2022-03-03 | Baldwin | Alabama | 1003 | 55061 | 645 |
2268500 | 2268500 | 2022-03-03 | Barbour | Alabama | 1005 | 5447 | 94 |
2268501 | 2268501 | 2022-03-03 | Bibb | Alabama | 1007 | 6378 | 99 |
2268502 | 2268502 | 2022-03-03 | Blount | Alabama | 1009 | 14799 | 221 |
2268503 | 2268503 | 2022-03-03 | Bullock | Alabama | 1011 | 2280 | 49 |
2268504 | 2268504 | 2022-03-03 | Butler | Alabama | 1013 | 5037 | 120 |
2268505 | 2268505 | 2022-03-03 | Calhoun | Alabama | 1015 | 31871 | 589 |
2268506 | 2268506 | 2022-03-03 | Chambers | Alabama | 1017 | 8435 | 153 |
2268507 | 2268507 | 2022-03-03 | Cherokee | Alabama | 1019 | 5090 | 79 |
2268508 | 2268508 | 2022-03-03 | Chilton | Alabama | 1021 | 10644 | 187 |
2268509 | 2268509 | 2022-03-03 | Choctaw | Alabama | 1023 | 2033 | 35 |
2268510 | 2268510 | 2022-03-03 | Clarke | Alabama | 1025 | 7053 | 96 |
2268511 | 2268511 | 2022-03-03 | Clay | Alabama | 1027 | 4077 | 78 |
2268512 | 2268512 | 2022-03-03 | Cleburne | Alabama | 1029 | 3541 | 68 |
2268513 | 2268513 | 2022-03-03 | Coffee | Alabama | 1031 | 13310 | 222 |
2268514 | 2268514 | 2022-03-03 | Colbert | Alabama | 1033 | 16159 | 239 |
2268515 | 2268515 | 2022-03-03 | Conecuh | Alabama | 1035 | 2839 | 66 |
2268516 | 2268516 | 2022-03-03 | Coosa | Alabama | 1037 | 2920 | 55 |
2268517 | 2268517 | 2022-03-03 | Covington | Alabama | 1039 | 9246 | 219 |
2268518 | 2268518 | 2022-03-03 | Crenshaw | Alabama | 1041 | 3775 | 93 |
2268519 | 2268519 | 2022-03-03 | Cullman | Alabama | 1043 | 24427 | 352 |
2268520 | 2268520 | 2022-03-03 | Dale | Alabama | 1045 | 12431 | 219 |
2268521 | 2268521 | 2022-03-03 | Dallas | Alabama | 1047 | 8328 | 231 |
2268522 | 2268522 | 2022-03-03 | DeKalb | Alabama | 1049 | 18574 | 313 |
2268523 | 2268523 | 2022-03-03 | Elmore | Alabama | 1051 | 22889 | 330 |
2268524 | 2268524 | 2022-03-03 | Escambia | Alabama | 1053 | 9964 | 157 |
2268525 | 2268525 | 2022-03-03 | Etowah | Alabama | 1055 | 28691 | 601 |
2268526 | 2268526 | 2022-03-03 | Fayette | Alabama | 1057 | 4920 | 93 |
2268527 | 2268527 | 2022-03-03 | Franklin | Alabama | 1059 | 9818 | 137 |
2268528 | 2268528 | 2022-03-03 | Geneva | Alabama | 1061 | 6195 | 155 |
2268529 | 2268529 | 2022-03-03 | Greene | Alabama | 1063 | 1855 | 48 |
2268530 | 2268530 | 2022-03-03 | Hale | Alabama | 1065 | 4669 | 101 |
2268531 | 2268531 | 2022-03-03 | Henry | Alabama | 1067 | 4444 | 70 |
2268532 | 2268532 | 2022-03-03 | Houston | Alabama | 1069 | 24912 | 476 |
2268533 | 2268533 | 2022-03-03 | Jackson | Alabama | 1071 | 14931 | 228 |
2268534 | 2268534 | 2022-03-03 | Jefferson | Alabama | 1073 | 182078 | 2234 |
2268535 | 2268535 | 2022-03-03 | Lamar | Alabama | 1075 | 3663 | 63 |
2268536 | 2268536 | 2022-03-03 | Lauderdale | Alabama | 1077 | 23941 | 370 |
2268537 | 2268537 | 2022-03-03 | Lawrence | Alabama | 1079 | 7583 | 153 |
2268538 | 2268538 | 2022-03-03 | Lee | Alabama | 1081 | 37541 | 315 |
2268539 | 2268539 | 2022-03-03 | Limestone | Alabama | 1083 | 24694 | 271 |
2268540 | 2268540 | 2022-03-03 | Lowndes | Alabama | 1085 | 2600 | 73 |
2268541 | 2268541 | 2022-03-03 | Macon | Alabama | 1087 | 3834 | 76 |
2268542 | 2268542 | 2022-03-03 | Madison | Alabama | 1089 | 88394 | 892 |
2268543 | 2268543 | 2022-03-03 | Marengo | Alabama | 1091 | 5150 | 103 |
2268544 | 2268544 | 2022-03-03 | Marion | Alabama | 1093 | 7983 | 144 |
2268545 | 2268545 | 2022-03-03 | Marshall | Alabama | 1095 | 27117 | 370 |
2268546 | 2268546 | 2022-03-03 | Mobile | Alabama | 1097 | 112640 | 1566 |
2268547 | 2268547 | 2022-03-03 | Monroe | Alabama | 1099 | 5254 | 77 |
2268548 | 2268548 | 2022-03-03 | Montgomery | Alabama | 1101 | 54437 | 872 |
2268549 | 2268549 | 2022-03-03 | Morgan | Alabama | 1103 | 35862 | 479 |
2268550 | 2268550 | 2022-03-03 | Perry | Alabama | 1105 | 2090 | 43 |
2268551 | 2268551 | 2022-03-03 | Pickens | Alabama | 1107 | 5167 | 97 |
2268552 | 2268552 | 2022-03-03 | Pike | Alabama | 1109 | 7421 | 127 |
2268553 | 2268553 | 2022-03-03 | Randolph | Alabama | 1111 | 5046 | 74 |
2268554 | 2268554 | 2022-03-03 | Russell | Alabama | 1113 | 10000 | 81 |
2268555 | 2268555 | 2022-03-03 | Shelby | Alabama | 1117 | 58888 | 421 |
2268556 | 2268556 | 2022-03-03 | St. Clair | Alabama | 1115 | 24992 | 400 |
2268557 | 2268557 | 2022-03-03 | Sumter | Alabama | 1119 | 2559 | 46 |
2268558 | 2268558 | 2022-03-03 | Talladega | Alabama | 1121 | 22119 | 351 |
2268559 | 2268559 | 2022-03-03 | Tallapoosa | Alabama | 1123 | 11309 | 223 |
2268560 | 2268560 | 2022-03-03 | Tuscaloosa | Alabama | 1125 | 54844 | 732 |
2268561 | 2268561 | 2022-03-03 | Walker | Alabama | 1127 | 18480 | 419 |
2268562 | 2268562 | 2022-03-03 | Washington | Alabama | 1129 | 3714 | 56 |
2268563 | 2268563 | 2022-03-03 | Wilcox | Alabama | 1131 | 2861 | 42 |
2268564 | 2268564 | 2022-03-03 | Winston | Alabama | 1133 | 7542 | 120 |
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);