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-09-18 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
544133 | 544133 | 2020-09-18 | Autauga | Alabama | 1001 | 1664 | 24 |
544134 | 544134 | 2020-09-18 | Baldwin | Alabama | 1003 | 5033 | 48 |
544135 | 544135 | 2020-09-18 | Barbour | Alabama | 1005 | 824 | 7 |
544136 | 544136 | 2020-09-18 | Bibb | Alabama | 1007 | 619 | 10 |
544137 | 544137 | 2020-09-18 | Blount | Alabama | 1009 | 1527 | 14 |
544138 | 544138 | 2020-09-18 | Bullock | Alabama | 1011 | 585 | 14 |
544139 | 544139 | 2020-09-18 | Butler | Alabama | 1013 | 906 | 38 |
544140 | 544140 | 2020-09-18 | Calhoun | Alabama | 1015 | 3249 | 39 |
544141 | 544141 | 2020-09-18 | Chambers | Alabama | 1017 | 1117 | 42 |
544142 | 544142 | 2020-09-18 | Cherokee | Alabama | 1019 | 548 | 16 |
544143 | 544143 | 2020-09-18 | Chilton | Alabama | 1021 | 1463 | 27 |
544144 | 544144 | 2020-09-18 | Choctaw | Alabama | 1023 | 344 | 12 |
544145 | 544145 | 2020-09-18 | Clarke | Alabama | 1025 | 1046 | 17 |
544146 | 544146 | 2020-09-18 | Clay | Alabama | 1027 | 531 | 7 |
544147 | 544147 | 2020-09-18 | Cleburne | Alabama | 1029 | 316 | 6 |
544148 | 544148 | 2020-09-18 | Coffee | Alabama | 1031 | 1248 | 8 |
544149 | 544149 | 2020-09-18 | Colbert | Alabama | 1033 | 1581 | 26 |
544150 | 544150 | 2020-09-18 | Conecuh | Alabama | 1035 | 517 | 11 |
544151 | 544151 | 2020-09-18 | Coosa | Alabama | 1037 | 160 | 3 |
544152 | 544152 | 2020-09-18 | Covington | Alabama | 1039 | 1303 | 27 |
544153 | 544153 | 2020-09-18 | Crenshaw | Alabama | 1041 | 519 | 31 |
544154 | 544154 | 2020-09-18 | Cullman | Alabama | 1043 | 1808 | 17 |
544155 | 544155 | 2020-09-18 | Dale | Alabama | 1045 | 1300 | 43 |
544156 | 544156 | 2020-09-18 | Dallas | Alabama | 1047 | 1732 | 26 |
544157 | 544157 | 2020-09-18 | DeKalb | Alabama | 1049 | 2326 | 19 |
544158 | 544158 | 2020-09-18 | Elmore | Alabama | 1051 | 2497 | 47 |
544159 | 544159 | 2020-09-18 | Escambia | Alabama | 1053 | 1554 | 24 |
544160 | 544160 | 2020-09-18 | Etowah | Alabama | 1055 | 3306 | 45 |
544161 | 544161 | 2020-09-18 | Fayette | Alabama | 1057 | 415 | 9 |
544162 | 544162 | 2020-09-18 | Franklin | Alabama | 1059 | 1734 | 28 |
544163 | 544163 | 2020-09-18 | Geneva | Alabama | 1061 | 556 | 4 |
544164 | 544164 | 2020-09-18 | Greene | Alabama | 1063 | 300 | 15 |
544165 | 544165 | 2020-09-18 | Hale | Alabama | 1065 | 610 | 28 |
544166 | 544166 | 2020-09-18 | Henry | Alabama | 1067 | 459 | 4 |
544167 | 544167 | 2020-09-18 | Houston | Alabama | 1069 | 2644 | 22 |
544168 | 544168 | 2020-09-18 | Jackson | Alabama | 1071 | 1485 | 11 |
544169 | 544169 | 2020-09-18 | Jefferson | Alabama | 1073 | 18772 | 333 |
544170 | 544170 | 2020-09-18 | Lamar | Alabama | 1075 | 337 | 2 |
544171 | 544171 | 2020-09-18 | Lauderdale | Alabama | 1077 | 1616 | 33 |
544172 | 544172 | 2020-09-18 | Lawrence | Alabama | 1079 | 578 | 20 |
544173 | 544173 | 2020-09-18 | Lee | Alabama | 1081 | 5603 | 59 |
544174 | 544174 | 2020-09-18 | Limestone | Alabama | 1083 | 1942 | 19 |
544175 | 544175 | 2020-09-18 | Lowndes | Alabama | 1085 | 645 | 27 |
544176 | 544176 | 2020-09-18 | Macon | Alabama | 1087 | 467 | 20 |
544177 | 544177 | 2020-09-18 | Madison | Alabama | 1089 | 7422 | 75 |
544178 | 544178 | 2020-09-18 | Marengo | Alabama | 1091 | 696 | 19 |
544179 | 544179 | 2020-09-18 | Marion | Alabama | 1093 | 921 | 28 |
544180 | 544180 | 2020-09-18 | Marshall | Alabama | 1095 | 3784 | 42 |
544181 | 544181 | 2020-09-18 | Mobile | Alabama | 1097 | 12975 | 289 |
544182 | 544182 | 2020-09-18 | Monroe | Alabama | 1099 | 573 | 8 |
544183 | 544183 | 2020-09-18 | Montgomery | Alabama | 1101 | 8598 | 173 |
544184 | 544184 | 2020-09-18 | Morgan | Alabama | 1103 | 3142 | 26 |
544185 | 544185 | 2020-09-18 | Perry | Alabama | 1105 | 536 | 6 |
544186 | 544186 | 2020-09-18 | Pickens | Alabama | 1107 | 628 | 14 |
544187 | 544187 | 2020-09-18 | Pike | Alabama | 1109 | 1135 | 9 |
544188 | 544188 | 2020-09-18 | Randolph | Alabama | 1111 | 591 | 12 |
544189 | 544189 | 2020-09-18 | Russell | Alabama | 1113 | 1692 | 2 |
544190 | 544190 | 2020-09-18 | Shelby | Alabama | 1117 | 5572 | 50 |
544191 | 544191 | 2020-09-18 | St. Clair | Alabama | 1115 | 2198 | 35 |
544192 | 544192 | 2020-09-18 | Sumter | Alabama | 1119 | 417 | 19 |
544193 | 544193 | 2020-09-18 | Talladega | Alabama | 1121 | 2034 | 26 |
544194 | 544194 | 2020-09-18 | Tallapoosa | Alabama | 1123 | 1129 | 83 |
544195 | 544195 | 2020-09-18 | Tuscaloosa | Alabama | 1125 | 7081 | 114 |
544196 | 544196 | 2020-09-18 | Walker | Alabama | 1127 | 2191 | 80 |
544197 | 544197 | 2020-09-18 | Washington | Alabama | 1129 | 545 | 13 |
544198 | 544198 | 2020-09-18 | Wilcox | Alabama | 1131 | 530 | 11 |
544199 | 544199 | 2020-09-18 | Winston | Alabama | 1133 | 687 | 12 |
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);