ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2021-12-08" 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 |
---|---|---|---|---|---|---|---|
1992103 | 1992103 | 2021-12-08 | Autauga | Alabama | 1001 | 10575 | 157 |
1992104 | 1992104 | 2021-12-08 | Baldwin | Alabama | 1003 | 38247 | 590 |
1992105 | 1992105 | 2021-12-08 | Barbour | Alabama | 1005 | 3712 | 80 |
1992106 | 1992106 | 2021-12-08 | Bibb | Alabama | 1007 | 4371 | 95 |
1992107 | 1992107 | 2021-12-08 | Blount | Alabama | 1009 | 10817 | 193 |
1992108 | 1992108 | 2021-12-08 | Bullock | Alabama | 1011 | 1532 | 45 |
1992109 | 1992109 | 2021-12-08 | Butler | Alabama | 1013 | 3448 | 101 |
1992110 | 1992110 | 2021-12-08 | Calhoun | Alabama | 1015 | 22662 | 520 |
1992111 | 1992111 | 2021-12-08 | Chambers | Alabama | 1017 | 5819 | 142 |
1992112 | 1992112 | 2021-12-08 | Cherokee | Alabama | 1019 | 3222 | 64 |
1992113 | 1992113 | 2021-12-08 | Chilton | Alabama | 1021 | 7112 | 171 |
1992114 | 1992114 | 2021-12-08 | Choctaw | Alabama | 1023 | 951 | 28 |
1992115 | 1992115 | 2021-12-08 | Clarke | Alabama | 1025 | 4862 | 86 |
1992116 | 1992116 | 2021-12-08 | Clay | Alabama | 1027 | 2532 | 69 |
1992117 | 1992117 | 2021-12-08 | Cleburne | Alabama | 1029 | 2557 | 60 |
1992118 | 1992118 | 2021-12-08 | Coffee | Alabama | 1031 | 9449 | 192 |
1992119 | 1992119 | 2021-12-08 | Colbert | Alabama | 1033 | 9396 | 210 |
1992120 | 1992120 | 2021-12-08 | Conecuh | Alabama | 1035 | 1941 | 62 |
1992121 | 1992121 | 2021-12-08 | Coosa | Alabama | 1037 | 1867 | 48 |
1992122 | 1992122 | 2021-12-08 | Covington | Alabama | 1039 | 6994 | 197 |
1992123 | 1992123 | 2021-12-08 | Crenshaw | Alabama | 1041 | 2624 | 78 |
1992124 | 1992124 | 2021-12-08 | Cullman | Alabama | 1043 | 16203 | 306 |
1992125 | 1992125 | 2021-12-08 | Dale | Alabama | 1045 | 9063 | 192 |
1992126 | 1992126 | 2021-12-08 | Dallas | Alabama | 1047 | 5308 | 210 |
1992127 | 1992127 | 2021-12-08 | DeKalb | Alabama | 1049 | 13117 | 271 |
1992128 | 1992128 | 2021-12-08 | Elmore | Alabama | 1051 | 15980 | 295 |
1992129 | 1992129 | 2021-12-08 | Escambia | Alabama | 1053 | 6970 | 146 |
1992130 | 1992130 | 2021-12-08 | Etowah | Alabama | 1055 | 20102 | 522 |
1992131 | 1992131 | 2021-12-08 | Fayette | Alabama | 1057 | 3331 | 85 |
1992132 | 1992132 | 2021-12-08 | Franklin | Alabama | 1059 | 6394 | 108 |
1992133 | 1992133 | 2021-12-08 | Geneva | Alabama | 1061 | 4662 | 137 |
1992134 | 1992134 | 2021-12-08 | Greene | Alabama | 1063 | 1310 | 45 |
1992135 | 1992135 | 2021-12-08 | Hale | Alabama | 1065 | 3206 | 89 |
1992136 | 1992136 | 2021-12-08 | Henry | Alabama | 1067 | 3224 | 66 |
1992137 | 1992137 | 2021-12-08 | Houston | Alabama | 1069 | 17818 | 426 |
1992138 | 1992138 | 2021-12-08 | Jackson | Alabama | 1071 | 10245 | 196 |
1992139 | 1992139 | 2021-12-08 | Jefferson | Alabama | 1073 | 116541 | 2005 |
1992140 | 1992140 | 2021-12-08 | Lamar | Alabama | 1075 | 2542 | 55 |
1992141 | 1992141 | 2021-12-08 | Lauderdale | Alabama | 1077 | 15151 | 308 |
1992142 | 1992142 | 2021-12-08 | Lawrence | Alabama | 1079 | 4863 | 130 |
1992143 | 1992143 | 2021-12-08 | Lee | Alabama | 1081 | 25747 | 265 |
1992144 | 1992144 | 2021-12-08 | Limestone | Alabama | 1083 | 16230 | 222 |
1992145 | 1992145 | 2021-12-08 | Lowndes | Alabama | 1085 | 1784 | 68 |
1992146 | 1992146 | 2021-12-08 | Macon | Alabama | 1087 | 2467 | 67 |
1992147 | 1992147 | 2021-12-08 | Madison | Alabama | 1089 | 53666 | 739 |
1992148 | 1992148 | 2021-12-08 | Marengo | Alabama | 1091 | 3426 | 93 |
1992149 | 1992149 | 2021-12-08 | Marion | Alabama | 1093 | 5454 | 132 |
1992150 | 1992150 | 2021-12-08 | Marshall | Alabama | 1095 | 18891 | 318 |
1992151 | 1992151 | 2021-12-08 | Mobile | Alabama | 1097 | 74536 | 1385 |
1992152 | 1992152 | 2021-12-08 | Monroe | Alabama | 1099 | 3383 | 66 |
1992153 | 1992153 | 2021-12-08 | Montgomery | Alabama | 1101 | 34620 | 784 |
1992154 | 1992154 | 2021-12-08 | Morgan | Alabama | 1103 | 22597 | 411 |
1992155 | 1992155 | 2021-12-08 | Perry | Alabama | 1105 | 1419 | 40 |
1992156 | 1992156 | 2021-12-08 | Pickens | Alabama | 1107 | 3355 | 90 |
1992157 | 1992157 | 2021-12-08 | Pike | Alabama | 1109 | 5147 | 109 |
1992158 | 1992158 | 2021-12-08 | Randolph | Alabama | 1111 | 3390 | 67 |
1992159 | 1992159 | 2021-12-08 | Russell | Alabama | 1113 | 7129 | 65 |
1992160 | 1992160 | 2021-12-08 | Shelby | Alabama | 1117 | 38507 | 373 |
1992161 | 1992161 | 2021-12-08 | St. Clair | Alabama | 1115 | 16995 | 359 |
1992162 | 1992162 | 2021-12-08 | Sumter | Alabama | 1119 | 1402 | 41 |
1992163 | 1992163 | 2021-12-08 | Talladega | Alabama | 1121 | 14289 | 302 |
1992164 | 1992164 | 2021-12-08 | Tallapoosa | Alabama | 1123 | 7295 | 202 |
1992165 | 1992165 | 2021-12-08 | Tuscaloosa | Alabama | 1125 | 36254 | 644 |
1992166 | 1992166 | 2021-12-08 | Walker | Alabama | 1127 | 12223 | 380 |
1992167 | 1992167 | 2021-12-08 | Washington | Alabama | 1129 | 2575 | 52 |
1992168 | 1992168 | 2021-12-08 | Wilcox | Alabama | 1131 | 1786 | 38 |
1992169 | 1992169 | 2021-12-08 | Winston | Alabama | 1133 | 4809 | 111 |
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);