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 2020-06-11 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
227712 | 227712 | 2020-06-11 | Autauga | Alabama | 1001 | 316 | 6 |
227713 | 227713 | 2020-06-11 | Baldwin | Alabama | 1003 | 358 | 9 |
227714 | 227714 | 2020-06-11 | Barbour | Alabama | 1005 | 215 | 1 |
227715 | 227715 | 2020-06-11 | Bibb | Alabama | 1007 | 96 | 1 |
227716 | 227716 | 2020-06-11 | Blount | Alabama | 1009 | 89 | 1 |
227717 | 227717 | 2020-06-11 | Bullock | Alabama | 1011 | 255 | 9 |
227718 | 227718 | 2020-06-11 | Butler | Alabama | 1013 | 487 | 25 |
227719 | 227719 | 2020-06-11 | Calhoun | Alabama | 1015 | 192 | 3 |
227720 | 227720 | 2020-06-11 | Chambers | Alabama | 1017 | 431 | 26 |
227721 | 227721 | 2020-06-11 | Cherokee | Alabama | 1019 | 44 | 4 |
227722 | 227722 | 2020-06-11 | Chilton | Alabama | 1021 | 127 | 2 |
227723 | 227723 | 2020-06-11 | Choctaw | Alabama | 1023 | 163 | 11 |
227724 | 227724 | 2020-06-11 | Clarke | Alabama | 1025 | 166 | 3 |
227725 | 227725 | 2020-06-11 | Clay | Alabama | 1027 | 30 | 2 |
227726 | 227726 | 2020-06-11 | Cleburne | Alabama | 1029 | 20 | 1 |
227727 | 227727 | 2020-06-11 | Coffee | Alabama | 1031 | 264 | 1 |
227728 | 227728 | 2020-06-11 | Colbert | Alabama | 1033 | 238 | 5 |
227729 | 227729 | 2020-06-11 | Conecuh | Alabama | 1035 | 72 | 1 |
227730 | 227730 | 2020-06-11 | Coosa | Alabama | 1037 | 43 | 1 |
227731 | 227731 | 2020-06-11 | Covington | Alabama | 1039 | 103 | 1 |
227732 | 227732 | 2020-06-11 | Crenshaw | Alabama | 1041 | 102 | 3 |
227733 | 227733 | 2020-06-11 | Cullman | Alabama | 1043 | 227 | 1 |
227734 | 227734 | 2020-06-11 | Dale | Alabama | 1045 | 152 | 0 |
227735 | 227735 | 2020-06-11 | Dallas | Alabama | 1047 | 410 | 6 |
227736 | 227736 | 2020-06-11 | DeKalb | Alabama | 1049 | 295 | 5 |
227737 | 227737 | 2020-06-11 | Elmore | Alabama | 1051 | 483 | 9 |
227738 | 227738 | 2020-06-11 | Escambia | Alabama | 1053 | 93 | 3 |
227739 | 227739 | 2020-06-11 | Etowah | Alabama | 1055 | 291 | 12 |
227740 | 227740 | 2020-06-11 | Fayette | Alabama | 1057 | 26 | 0 |
227741 | 227741 | 2020-06-11 | Franklin | Alabama | 1059 | 655 | 10 |
227742 | 227742 | 2020-06-11 | Geneva | Alabama | 1061 | 46 | 0 |
227743 | 227743 | 2020-06-11 | Greene | Alabama | 1063 | 112 | 5 |
227744 | 227744 | 2020-06-11 | Hale | Alabama | 1065 | 224 | 11 |
227745 | 227745 | 2020-06-11 | Henry | Alabama | 1067 | 94 | 2 |
227746 | 227746 | 2020-06-11 | Houston | Alabama | 1069 | 280 | 5 |
227747 | 227747 | 2020-06-11 | Jackson | Alabama | 1071 | 110 | 3 |
227748 | 227748 | 2020-06-11 | Jefferson | Alabama | 1073 | 2282 | 117 |
227749 | 227749 | 2020-06-11 | Lamar | Alabama | 1075 | 31 | 0 |
227750 | 227750 | 2020-06-11 | Lauderdale | Alabama | 1077 | 209 | 3 |
227751 | 227751 | 2020-06-11 | Lawrence | Alabama | 1079 | 61 | 0 |
227752 | 227752 | 2020-06-11 | Lee | Alabama | 1081 | 641 | 35 |
227753 | 227753 | 2020-06-11 | Limestone | Alabama | 1083 | 164 | 0 |
227754 | 227754 | 2020-06-11 | Lowndes | Alabama | 1085 | 330 | 14 |
227755 | 227755 | 2020-06-11 | Macon | Alabama | 1087 | 111 | 5 |
227756 | 227756 | 2020-06-11 | Madison | Alabama | 1089 | 449 | 5 |
227757 | 227757 | 2020-06-11 | Marengo | Alabama | 1091 | 201 | 7 |
227758 | 227758 | 2020-06-11 | Marion | Alabama | 1093 | 133 | 12 |
227759 | 227759 | 2020-06-11 | Marshall | Alabama | 1095 | 791 | 9 |
227760 | 227760 | 2020-06-11 | Mobile | Alabama | 1097 | 2612 | 128 |
227761 | 227761 | 2020-06-11 | Monroe | Alabama | 1099 | 95 | 2 |
227762 | 227762 | 2020-06-11 | Montgomery | Alabama | 1101 | 2472 | 66 |
227763 | 227763 | 2020-06-11 | Morgan | Alabama | 1103 | 483 | 1 |
227764 | 227764 | 2020-06-11 | Perry | Alabama | 1105 | 56 | 0 |
227765 | 227765 | 2020-06-11 | Pickens | Alabama | 1107 | 132 | 6 |
227766 | 227766 | 2020-06-11 | Pike | Alabama | 1109 | 285 | 1 |
227767 | 227767 | 2020-06-11 | Randolph | Alabama | 1111 | 139 | 8 |
227768 | 227768 | 2020-06-11 | Russell | Alabama | 1113 | 253 | 0 |
227769 | 227769 | 2020-06-11 | Shelby | Alabama | 1117 | 599 | 20 |
227770 | 227770 | 2020-06-11 | St. Clair | Alabama | 1115 | 161 | 2 |
227771 | 227771 | 2020-06-11 | Sumter | Alabama | 1119 | 254 | 11 |
227772 | 227772 | 2020-06-11 | Talladega | Alabama | 1121 | 153 | 5 |
227773 | 227773 | 2020-06-11 | Tallapoosa | Alabama | 1123 | 461 | 67 |
227774 | 227774 | 2020-06-11 | Tuscaloosa | Alabama | 1125 | 1083 | 23 |
227775 | 227775 | 2020-06-11 | Walker | Alabama | 1127 | 510 | 6 |
227776 | 227776 | 2020-06-11 | Washington | Alabama | 1129 | 86 | 6 |
227777 | 227777 | 2020-06-11 | Wilcox | Alabama | 1131 | 192 | 8 |
227778 | 227778 | 2020-06-11 | Winston | Alabama | 1133 | 107 | 0 |
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);