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 2021-04-02 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 |
---|---|---|---|---|---|---|---|
1180118 | 1180118 | 2021-04-02 | Autauga | Alabama | 1001 | 6606 | 99 |
1180119 | 1180119 | 2021-04-02 | Baldwin | Alabama | 1003 | 20519 | 301 |
1180120 | 1180120 | 2021-04-02 | Barbour | Alabama | 1005 | 2228 | 55 |
1180121 | 1180121 | 2021-04-02 | Bibb | Alabama | 1007 | 2544 | 58 |
1180122 | 1180122 | 2021-04-02 | Blount | Alabama | 1009 | 6455 | 132 |
1180123 | 1180123 | 2021-04-02 | Bullock | Alabama | 1011 | 1207 | 40 |
1180124 | 1180124 | 2021-04-02 | Butler | Alabama | 1013 | 2106 | 66 |
1180125 | 1180125 | 2021-04-02 | Calhoun | Alabama | 1015 | 14233 | 310 |
1180126 | 1180126 | 2021-04-02 | Chambers | Alabama | 1017 | 3489 | 119 |
1180127 | 1180127 | 2021-04-02 | Cherokee | Alabama | 1019 | 1811 | 43 |
1180128 | 1180128 | 2021-04-02 | Chilton | Alabama | 1021 | 4053 | 109 |
1180129 | 1180129 | 2021-04-02 | Choctaw | Alabama | 1023 | 583 | 24 |
1180130 | 1180130 | 2021-04-02 | Clarke | Alabama | 1025 | 3453 | 60 |
1180131 | 1180131 | 2021-04-02 | Clay | Alabama | 1027 | 1485 | 54 |
1180132 | 1180132 | 2021-04-02 | Cleburne | Alabama | 1029 | 1454 | 41 |
1180133 | 1180133 | 2021-04-02 | Coffee | Alabama | 1031 | 5388 | 111 |
1180134 | 1180134 | 2021-04-02 | Colbert | Alabama | 1033 | 6177 | 126 |
1180135 | 1180135 | 2021-04-02 | Conecuh | Alabama | 1035 | 1086 | 27 |
1180136 | 1180136 | 2021-04-02 | Coosa | Alabama | 1037 | 951 | 24 |
1180137 | 1180137 | 2021-04-02 | Covington | Alabama | 1039 | 4045 | 111 |
1180138 | 1180138 | 2021-04-02 | Crenshaw | Alabama | 1041 | 1502 | 57 |
1180139 | 1180139 | 2021-04-02 | Cullman | Alabama | 1043 | 9394 | 186 |
1180140 | 1180140 | 2021-04-02 | Dale | Alabama | 1045 | 4766 | 109 |
1180141 | 1180141 | 2021-04-02 | Dallas | Alabama | 1047 | 3513 | 149 |
1180142 | 1180142 | 2021-04-02 | DeKalb | Alabama | 1049 | 8702 | 180 |
1180143 | 1180143 | 2021-04-02 | Elmore | Alabama | 1051 | 9982 | 202 |
1180144 | 1180144 | 2021-04-02 | Escambia | Alabama | 1053 | 3864 | 74 |
1180145 | 1180145 | 2021-04-02 | Etowah | Alabama | 1055 | 13650 | 344 |
1180146 | 1180146 | 2021-04-02 | Fayette | Alabama | 1057 | 2068 | 59 |
1180147 | 1180147 | 2021-04-02 | Franklin | Alabama | 1059 | 4187 | 82 |
1180148 | 1180148 | 2021-04-02 | Geneva | Alabama | 1061 | 2453 | 74 |
1180149 | 1180149 | 2021-04-02 | Greene | Alabama | 1063 | 904 | 34 |
1180150 | 1180150 | 2021-04-02 | Hale | Alabama | 1065 | 2167 | 73 |
1180151 | 1180151 | 2021-04-02 | Henry | Alabama | 1067 | 1871 | 43 |
1180152 | 1180152 | 2021-04-02 | Houston | Alabama | 1069 | 10347 | 275 |
1180153 | 1180153 | 2021-04-02 | Jackson | Alabama | 1071 | 6738 | 107 |
1180154 | 1180154 | 2021-04-02 | Jefferson | Alabama | 1073 | 74855 | 1466 |
1180155 | 1180155 | 2021-04-02 | Lamar | Alabama | 1075 | 1392 | 33 |
1180156 | 1180156 | 2021-04-02 | Lauderdale | Alabama | 1077 | 9148 | 223 |
1180157 | 1180157 | 2021-04-02 | Lawrence | Alabama | 1079 | 2931 | 94 |
1180158 | 1180158 | 2021-04-02 | Lee | Alabama | 1081 | 15444 | 166 |
1180159 | 1180159 | 2021-04-02 | Limestone | Alabama | 1083 | 9761 | 146 |
1180160 | 1180160 | 2021-04-02 | Lowndes | Alabama | 1085 | 1363 | 53 |
1180161 | 1180161 | 2021-04-02 | Macon | Alabama | 1087 | 1540 | 47 |
1180162 | 1180162 | 2021-04-02 | Madison | Alabama | 1089 | 33619 | 493 |
1180163 | 1180163 | 2021-04-02 | Marengo | Alabama | 1091 | 2502 | 58 |
1180164 | 1180164 | 2021-04-02 | Marion | Alabama | 1093 | 3064 | 101 |
1180165 | 1180165 | 2021-04-02 | Marshall | Alabama | 1095 | 11877 | 217 |
1180166 | 1180166 | 2021-04-02 | Mobile | Alabama | 1097 | 37555 | 792 |
1180167 | 1180167 | 2021-04-02 | Monroe | Alabama | 1099 | 1707 | 40 |
1180168 | 1180168 | 2021-04-02 | Montgomery | Alabama | 1101 | 23800 | 558 |
1180169 | 1180169 | 2021-04-02 | Morgan | Alabama | 1103 | 14139 | 265 |
1180170 | 1180170 | 2021-04-02 | Perry | Alabama | 1105 | 1083 | 27 |
1180171 | 1180171 | 2021-04-02 | Pickens | Alabama | 1107 | 2329 | 57 |
1180172 | 1180172 | 2021-04-02 | Pike | Alabama | 1109 | 3045 | 74 |
1180173 | 1180173 | 2021-04-02 | Randolph | Alabama | 1111 | 1755 | 41 |
1180174 | 1180174 | 2021-04-02 | Russell | Alabama | 1113 | 4233 | 37 |
1180175 | 1180175 | 2021-04-02 | Shelby | Alabama | 1117 | 23097 | 235 |
1180176 | 1180176 | 2021-04-02 | St. Clair | Alabama | 1115 | 9364 | 234 |
1180177 | 1180177 | 2021-04-02 | Sumter | Alabama | 1119 | 1028 | 32 |
1180178 | 1180178 | 2021-04-02 | Talladega | Alabama | 1121 | 8019 | 168 |
1180179 | 1180179 | 2021-04-02 | Tallapoosa | Alabama | 1123 | 3873 | 146 |
1180180 | 1180180 | 2021-04-02 | Tuscaloosa | Alabama | 1125 | 25096 | 437 |
1180181 | 1180181 | 2021-04-02 | Walker | Alabama | 1127 | 7066 | 274 |
1180182 | 1180182 | 2021-04-02 | Washington | Alabama | 1129 | 1640 | 38 |
1180183 | 1180183 | 2021-04-02 | Wilcox | Alabama | 1131 | 1242 | 26 |
1180184 | 1180184 | 2021-04-02 | Winston | Alabama | 1133 | 2718 | 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);