ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-03-23" 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 |
---|---|---|---|---|---|---|---|
1147644 | 1147644 | 2021-03-23 | Autauga | Alabama | 1001 | 6525 | 99 |
1147645 | 1147645 | 2021-03-23 | Baldwin | Alabama | 1003 | 20354 | 297 |
1147646 | 1147646 | 2021-03-23 | Barbour | Alabama | 1005 | 2213 | 54 |
1147647 | 1147647 | 2021-03-23 | Bibb | Alabama | 1007 | 2530 | 58 |
1147648 | 1147648 | 2021-03-23 | Blount | Alabama | 1009 | 6388 | 130 |
1147649 | 1147649 | 2021-03-23 | Bullock | Alabama | 1011 | 1195 | 39 |
1147650 | 1147650 | 2021-03-23 | Butler | Alabama | 1013 | 2073 | 66 |
1147651 | 1147651 | 2021-03-23 | Calhoun | Alabama | 1015 | 14162 | 304 |
1147652 | 1147652 | 2021-03-23 | Chambers | Alabama | 1017 | 3470 | 114 |
1147653 | 1147653 | 2021-03-23 | Cherokee | Alabama | 1019 | 1794 | 42 |
1147654 | 1147654 | 2021-03-23 | Chilton | Alabama | 1021 | 4006 | 108 |
1147655 | 1147655 | 2021-03-23 | Choctaw | Alabama | 1023 | 582 | 24 |
1147656 | 1147656 | 2021-03-23 | Clarke | Alabama | 1025 | 3478 | 57 |
1147657 | 1147657 | 2021-03-23 | Clay | Alabama | 1027 | 1479 | 54 |
1147658 | 1147658 | 2021-03-23 | Cleburne | Alabama | 1029 | 1445 | 41 |
1147659 | 1147659 | 2021-03-23 | Coffee | Alabama | 1031 | 5346 | 107 |
1147660 | 1147660 | 2021-03-23 | Colbert | Alabama | 1033 | 6127 | 125 |
1147661 | 1147661 | 2021-03-23 | Conecuh | Alabama | 1035 | 1085 | 25 |
1147662 | 1147662 | 2021-03-23 | Coosa | Alabama | 1037 | 943 | 24 |
1147663 | 1147663 | 2021-03-23 | Covington | Alabama | 1039 | 4030 | 110 |
1147664 | 1147664 | 2021-03-23 | Crenshaw | Alabama | 1041 | 1490 | 57 |
1147665 | 1147665 | 2021-03-23 | Cullman | Alabama | 1043 | 9294 | 186 |
1147666 | 1147666 | 2021-03-23 | Dale | Alabama | 1045 | 4727 | 109 |
1147667 | 1147667 | 2021-03-23 | Dallas | Alabama | 1047 | 3505 | 146 |
1147668 | 1147668 | 2021-03-23 | DeKalb | Alabama | 1049 | 8670 | 179 |
1147669 | 1147669 | 2021-03-23 | Elmore | Alabama | 1051 | 9851 | 199 |
1147670 | 1147670 | 2021-03-23 | Escambia | Alabama | 1053 | 3845 | 74 |
1147671 | 1147671 | 2021-03-23 | Etowah | Alabama | 1055 | 13608 | 339 |
1147672 | 1147672 | 2021-03-23 | Fayette | Alabama | 1057 | 2051 | 58 |
1147673 | 1147673 | 2021-03-23 | Franklin | Alabama | 1059 | 4180 | 82 |
1147674 | 1147674 | 2021-03-23 | Geneva | Alabama | 1061 | 2432 | 71 |
1147675 | 1147675 | 2021-03-23 | Greene | Alabama | 1063 | 899 | 33 |
1147676 | 1147676 | 2021-03-23 | Hale | Alabama | 1065 | 2149 | 72 |
1147677 | 1147677 | 2021-03-23 | Henry | Alabama | 1067 | 1859 | 42 |
1147678 | 1147678 | 2021-03-23 | Houston | Alabama | 1069 | 10257 | 269 |
1147679 | 1147679 | 2021-03-23 | Jackson | Alabama | 1071 | 6702 | 105 |
1147680 | 1147680 | 2021-03-23 | Jefferson | Alabama | 1073 | 74093 | 1447 |
1147681 | 1147681 | 2021-03-23 | Lamar | Alabama | 1075 | 1372 | 33 |
1147682 | 1147682 | 2021-03-23 | Lauderdale | Alabama | 1077 | 9034 | 217 |
1147683 | 1147683 | 2021-03-23 | Lawrence | Alabama | 1079 | 2910 | 92 |
1147684 | 1147684 | 2021-03-23 | Lee | Alabama | 1081 | 15292 | 166 |
1147685 | 1147685 | 2021-03-23 | Limestone | Alabama | 1083 | 9676 | 142 |
1147686 | 1147686 | 2021-03-23 | Lowndes | Alabama | 1085 | 1357 | 52 |
1147687 | 1147687 | 2021-03-23 | Macon | Alabama | 1087 | 1521 | 47 |
1147688 | 1147688 | 2021-03-23 | Madison | Alabama | 1089 | 33285 | 485 |
1147689 | 1147689 | 2021-03-23 | Marengo | Alabama | 1091 | 2489 | 58 |
1147690 | 1147690 | 2021-03-23 | Marion | Alabama | 1093 | 3040 | 99 |
1147691 | 1147691 | 2021-03-23 | Marshall | Alabama | 1095 | 11806 | 218 |
1147692 | 1147692 | 2021-03-23 | Mobile | Alabama | 1097 | 37320 | 777 |
1147693 | 1147693 | 2021-03-23 | Monroe | Alabama | 1099 | 1695 | 39 |
1147694 | 1147694 | 2021-03-23 | Montgomery | Alabama | 1101 | 23451 | 543 |
1147695 | 1147695 | 2021-03-23 | Morgan | Alabama | 1103 | 14072 | 260 |
1147696 | 1147696 | 2021-03-23 | Perry | Alabama | 1105 | 1077 | 27 |
1147697 | 1147697 | 2021-03-23 | Pickens | Alabama | 1107 | 2321 | 57 |
1147698 | 1147698 | 2021-03-23 | Pike | Alabama | 1109 | 2995 | 74 |
1147699 | 1147699 | 2021-03-23 | Randolph | Alabama | 1111 | 1734 | 41 |
1147700 | 1147700 | 2021-03-23 | Russell | Alabama | 1113 | 4194 | 36 |
1147701 | 1147701 | 2021-03-23 | Shelby | Alabama | 1117 | 22824 | 230 |
1147702 | 1147702 | 2021-03-23 | St. Clair | Alabama | 1115 | 9277 | 231 |
1147703 | 1147703 | 2021-03-23 | Sumter | Alabama | 1119 | 1024 | 31 |
1147704 | 1147704 | 2021-03-23 | Talladega | Alabama | 1121 | 7882 | 167 |
1147705 | 1147705 | 2021-03-23 | Tallapoosa | Alabama | 1123 | 3834 | 144 |
1147706 | 1147706 | 2021-03-23 | Tuscaloosa | Alabama | 1125 | 24871 | 434 |
1147707 | 1147707 | 2021-03-23 | Walker | Alabama | 1127 | 7017 | 269 |
1147708 | 1147708 | 2021-03-23 | Washington | Alabama | 1129 | 1634 | 38 |
1147709 | 1147709 | 2021-03-23 | Wilcox | Alabama | 1131 | 1246 | 26 |
1147710 | 1147710 | 2021-03-23 | Winston | Alabama | 1133 | 2702 | 71 |
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);