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-05-05 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473512 | 2473512 | 2022-05-05 | Autauga | Alabama | 1001 | 15840 | 216 |
2473513 | 2473513 | 2022-05-05 | Baldwin | Alabama | 1003 | 55713 | 680 |
2473514 | 2473514 | 2022-05-05 | Barbour | Alabama | 1005 | 5671 | 98 |
2473515 | 2473515 | 2022-05-05 | Bibb | Alabama | 1007 | 6444 | 104 |
2473516 | 2473516 | 2022-05-05 | Blount | Alabama | 1009 | 14985 | 243 |
2473517 | 2473517 | 2022-05-05 | Bullock | Alabama | 1011 | 2318 | 54 |
2473518 | 2473518 | 2022-05-05 | Butler | Alabama | 1013 | 5067 | 129 |
2473519 | 2473519 | 2022-05-05 | Calhoun | Alabama | 1015 | 32419 | 626 |
2473520 | 2473520 | 2022-05-05 | Chambers | Alabama | 1017 | 8492 | 162 |
2473521 | 2473521 | 2022-05-05 | Cherokee | Alabama | 1019 | 5126 | 86 |
2473522 | 2473522 | 2022-05-05 | Chilton | Alabama | 1021 | 11124 | 207 |
2473523 | 2473523 | 2022-05-05 | Choctaw | Alabama | 1023 | 2050 | 36 |
2473524 | 2473524 | 2022-05-05 | Clarke | Alabama | 1025 | 7145 | 101 |
2473525 | 2473525 | 2022-05-05 | Clay | Alabama | 1027 | 4090 | 82 |
2473526 | 2473526 | 2022-05-05 | Cleburne | Alabama | 1029 | 3560 | 69 |
2473527 | 2473527 | 2022-05-05 | Coffee | Alabama | 1031 | 13614 | 231 |
2473528 | 2473528 | 2022-05-05 | Colbert | Alabama | 1033 | 16341 | 260 |
2473529 | 2473529 | 2022-05-05 | Conecuh | Alabama | 1035 | 2868 | 70 |
2473530 | 2473530 | 2022-05-05 | Coosa | Alabama | 1037 | 2970 | 58 |
2473531 | 2473531 | 2022-05-05 | Covington | Alabama | 1039 | 9343 | 232 |
2473532 | 2473532 | 2022-05-05 | Crenshaw | Alabama | 1041 | 3830 | 99 |
2473533 | 2473533 | 2022-05-05 | Cullman | Alabama | 1043 | 24612 | 366 |
2473534 | 2473534 | 2022-05-05 | Dale | Alabama | 1045 | 12915 | 231 |
2473535 | 2473535 | 2022-05-05 | Dallas | Alabama | 1047 | 8422 | 244 |
2473536 | 2473536 | 2022-05-05 | DeKalb | Alabama | 1049 | 18763 | 328 |
2473537 | 2473537 | 2022-05-05 | Elmore | Alabama | 1051 | 23389 | 347 |
2473538 | 2473538 | 2022-05-05 | Escambia | Alabama | 1053 | 10060 | 170 |
2473539 | 2473539 | 2022-05-05 | Etowah | Alabama | 1055 | 28773 | 650 |
2473540 | 2473540 | 2022-05-05 | Fayette | Alabama | 1057 | 4983 | 96 |
2473541 | 2473541 | 2022-05-05 | Franklin | Alabama | 1059 | 9898 | 139 |
2473542 | 2473542 | 2022-05-05 | Geneva | Alabama | 1061 | 6482 | 164 |
2473543 | 2473543 | 2022-05-05 | Greene | Alabama | 1063 | 1875 | 49 |
2473544 | 2473544 | 2022-05-05 | Hale | Alabama | 1065 | 4732 | 106 |
2473545 | 2473545 | 2022-05-05 | Henry | Alabama | 1067 | 4572 | 76 |
2473546 | 2473546 | 2022-05-05 | Houston | Alabama | 1069 | 25745 | 506 |
2473547 | 2473547 | 2022-05-05 | Jackson | Alabama | 1071 | 15040 | 241 |
2473548 | 2473548 | 2022-05-05 | Jefferson | Alabama | 1073 | 185461 | 2371 |
2473549 | 2473549 | 2022-05-05 | Lamar | Alabama | 1075 | 3734 | 65 |
2473550 | 2473550 | 2022-05-05 | Lauderdale | Alabama | 1077 | 24161 | 396 |
2473551 | 2473551 | 2022-05-05 | Lawrence | Alabama | 1079 | 7677 | 158 |
2473552 | 2473552 | 2022-05-05 | Lee | Alabama | 1081 | 37815 | 340 |
2473553 | 2473553 | 2022-05-05 | Limestone | Alabama | 1083 | 24995 | 292 |
2473554 | 2473554 | 2022-05-05 | Lowndes | Alabama | 1085 | 2621 | 77 |
2473555 | 2473555 | 2022-05-05 | Macon | Alabama | 1087 | 3874 | 84 |
2473556 | 2473556 | 2022-05-05 | Madison | Alabama | 1089 | 90030 | 963 |
2473557 | 2473557 | 2022-05-05 | Marengo | Alabama | 1091 | 5191 | 108 |
2473558 | 2473558 | 2022-05-05 | Marion | Alabama | 1093 | 8137 | 152 |
2473559 | 2473559 | 2022-05-05 | Marshall | Alabama | 1095 | 27398 | 393 |
2473560 | 2473560 | 2022-05-05 | Mobile | Alabama | 1097 | 113192 | 1651 |
2473561 | 2473561 | 2022-05-05 | Monroe | Alabama | 1099 | 5275 | 80 |
2473562 | 2473562 | 2022-05-05 | Montgomery | Alabama | 1101 | 55157 | 948 |
2473563 | 2473563 | 2022-05-05 | Morgan | Alabama | 1103 | 36113 | 516 |
2473564 | 2473564 | 2022-05-05 | Perry | Alabama | 1105 | 2095 | 46 |
2473565 | 2473565 | 2022-05-05 | Pickens | Alabama | 1107 | 5262 | 102 |
2473566 | 2473566 | 2022-05-05 | Pike | Alabama | 1109 | 7580 | 134 |
2473567 | 2473567 | 2022-05-05 | Randolph | Alabama | 1111 | 5088 | 74 |
2473568 | 2473568 | 2022-05-05 | Russell | Alabama | 1113 | 10099 | 93 |
2473569 | 2473569 | 2022-05-05 | Shelby | Alabama | 1117 | 61083 | 451 |
2473570 | 2473570 | 2022-05-05 | St. Clair | Alabama | 1115 | 25354 | 416 |
2473571 | 2473571 | 2022-05-05 | Sumter | Alabama | 1119 | 2587 | 51 |
2473572 | 2473572 | 2022-05-05 | Talladega | Alabama | 1121 | 22355 | 376 |
2473573 | 2473573 | 2022-05-05 | Tallapoosa | Alabama | 1123 | 11428 | 234 |
2473574 | 2473574 | 2022-05-05 | Tuscaloosa | Alabama | 1125 | 56188 | 785 |
2473575 | 2473575 | 2022-05-05 | Walker | Alabama | 1127 | 18745 | 445 |
2473576 | 2473576 | 2022-05-05 | Washington | Alabama | 1129 | 3731 | 59 |
2473577 | 2473577 | 2022-05-05 | Wilcox | Alabama | 1131 | 2889 | 46 |
2473578 | 2473578 | 2022-05-05 | Winston | Alabama | 1133 | 7569 | 131 |
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);