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-08-10 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 |
---|---|---|---|---|---|---|---|
418120 | 418120 | 2020-08-10 | Autauga | Alabama | 1001 | 1222 | 22 |
418121 | 418121 | 2020-08-10 | Baldwin | Alabama | 1003 | 3714 | 28 |
418122 | 418122 | 2020-08-10 | Barbour | Alabama | 1005 | 631 | 5 |
418123 | 418123 | 2020-08-10 | Bibb | Alabama | 1007 | 450 | 5 |
418124 | 418124 | 2020-08-10 | Blount | Alabama | 1009 | 947 | 4 |
418125 | 418125 | 2020-08-10 | Bullock | Alabama | 1011 | 474 | 12 |
418126 | 418126 | 2020-08-10 | Butler | Alabama | 1013 | 782 | 37 |
418127 | 418127 | 2020-08-10 | Calhoun | Alabama | 1015 | 1883 | 17 |
418128 | 418128 | 2020-08-10 | Chambers | Alabama | 1017 | 909 | 38 |
418129 | 418129 | 2020-08-10 | Cherokee | Alabama | 1019 | 304 | 9 |
418130 | 418130 | 2020-08-10 | Chilton | Alabama | 1021 | 860 | 9 |
418131 | 418131 | 2020-08-10 | Choctaw | Alabama | 1023 | 292 | 12 |
418132 | 418132 | 2020-08-10 | Clarke | Alabama | 1025 | 855 | 10 |
418133 | 418133 | 2020-08-10 | Clay | Alabama | 1027 | 268 | 5 |
418134 | 418134 | 2020-08-10 | Cleburne | Alabama | 1029 | 130 | 1 |
418135 | 418135 | 2020-08-10 | Coffee | Alabama | 1031 | 814 | 6 |
418136 | 418136 | 2020-08-10 | Colbert | Alabama | 1033 | 1234 | 16 |
418137 | 418137 | 2020-08-10 | Conecuh | Alabama | 1035 | 417 | 10 |
418138 | 418138 | 2020-08-10 | Coosa | Alabama | 1037 | 116 | 3 |
418139 | 418139 | 2020-08-10 | Covington | Alabama | 1039 | 878 | 21 |
418140 | 418140 | 2020-08-10 | Crenshaw | Alabama | 1041 | 347 | 6 |
418141 | 418141 | 2020-08-10 | Cullman | Alabama | 1043 | 1312 | 12 |
418142 | 418142 | 2020-08-10 | Dale | Alabama | 1045 | 858 | 25 |
418143 | 418143 | 2020-08-10 | Dallas | Alabama | 1047 | 1423 | 23 |
418144 | 418144 | 2020-08-10 | DeKalb | Alabama | 1049 | 1889 | 16 |
418145 | 418145 | 2020-08-10 | Elmore | Alabama | 1051 | 1808 | 39 |
418146 | 418146 | 2020-08-10 | Escambia | Alabama | 1053 | 1199 | 17 |
418147 | 418147 | 2020-08-10 | Etowah | Alabama | 1055 | 2232 | 33 |
418148 | 418148 | 2020-08-10 | Fayette | Alabama | 1057 | 226 | 5 |
418149 | 418149 | 2020-08-10 | Franklin | Alabama | 1059 | 1306 | 20 |
418150 | 418150 | 2020-08-10 | Geneva | Alabama | 1061 | 282 | 2 |
418151 | 418151 | 2020-08-10 | Greene | Alabama | 1063 | 256 | 11 |
418152 | 418152 | 2020-08-10 | Hale | Alabama | 1065 | 496 | 26 |
418153 | 418153 | 2020-08-10 | Henry | Alabama | 1067 | 278 | 4 |
418154 | 418154 | 2020-08-10 | Houston | Alabama | 1069 | 1472 | 14 |
418155 | 418155 | 2020-08-10 | Jackson | Alabama | 1071 | 1044 | 6 |
418156 | 418156 | 2020-08-10 | Jefferson | Alabama | 1073 | 13530 | 246 |
418157 | 418157 | 2020-08-10 | Lamar | Alabama | 1075 | 237 | 2 |
418158 | 418158 | 2020-08-10 | Lauderdale | Alabama | 1077 | 1203 | 19 |
418159 | 418159 | 2020-08-10 | Lawrence | Alabama | 1079 | 361 | 2 |
418160 | 418160 | 2020-08-10 | Lee | Alabama | 1081 | 2877 | 51 |
418161 | 418161 | 2020-08-10 | Limestone | Alabama | 1083 | 1376 | 14 |
418162 | 418162 | 2020-08-10 | Lowndes | Alabama | 1085 | 586 | 26 |
418163 | 418163 | 2020-08-10 | Macon | Alabama | 1087 | 351 | 14 |
418164 | 418164 | 2020-08-10 | Madison | Alabama | 1089 | 5561 | 39 |
418165 | 418165 | 2020-08-10 | Marengo | Alabama | 1091 | 574 | 16 |
418166 | 418166 | 2020-08-10 | Marion | Alabama | 1093 | 614 | 26 |
418167 | 418167 | 2020-08-10 | Marshall | Alabama | 1095 | 3275 | 38 |
418168 | 418168 | 2020-08-10 | Mobile | Alabama | 1097 | 10599 | 212 |
418169 | 418169 | 2020-08-10 | Monroe | Alabama | 1099 | 476 | 6 |
418170 | 418170 | 2020-08-10 | Montgomery | Alabama | 1101 | 6970 | 152 |
418171 | 418171 | 2020-08-10 | Morgan | Alabama | 1103 | 2452 | 20 |
418172 | 418172 | 2020-08-10 | Perry | Alabama | 1105 | 475 | 4 |
418173 | 418173 | 2020-08-10 | Pickens | Alabama | 1107 | 415 | 10 |
418174 | 418174 | 2020-08-10 | Pike | Alabama | 1109 | 755 | 8 |
418175 | 418175 | 2020-08-10 | Randolph | Alabama | 1111 | 416 | 11 |
418176 | 418176 | 2020-08-10 | Russell | Alabama | 1113 | 1418 | 2 |
418177 | 418177 | 2020-08-10 | Shelby | Alabama | 1117 | 3520 | 38 |
418178 | 418178 | 2020-08-10 | St. Clair | Alabama | 1115 | 1457 | 19 |
418179 | 418179 | 2020-08-10 | Sumter | Alabama | 1119 | 369 | 18 |
418180 | 418180 | 2020-08-10 | Talladega | Alabama | 1121 | 1298 | 15 |
418181 | 418181 | 2020-08-10 | Tallapoosa | Alabama | 1123 | 935 | 80 |
418182 | 418182 | 2020-08-10 | Tuscaloosa | Alabama | 1125 | 4363 | 80 |
418183 | 418183 | 2020-08-10 | Walker | Alabama | 1127 | 1577 | 67 |
418184 | 418184 | 2020-08-10 | Washington | Alabama | 1129 | 450 | 12 |
418185 | 418185 | 2020-08-10 | Wilcox | Alabama | 1131 | 448 | 10 |
418186 | 418186 | 2020-08-10 | Winston | Alabama | 1133 | 474 | 11 |
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);