ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,439 rows where date = "2020-04-05" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 152
- Georgia 150
- Virginia 110
- Indiana 89
- Kentucky 89
- North Carolina 89
- Tennessee 88
- Mississippi 79
- Missouri 77
- Ohio 77
- Illinois 72
- Iowa 71
- Michigan 70
- Alabama 65
- Arkansas 65
- Pennsylvania 65
- Florida 63
- Louisiana 62
- Minnesota 61
- New York 59
- Wisconsin 57
- Oklahoma 56
- Colorado 55
- California 52
- Kansas 52
- South Carolina 46
- Washington 38
- Nebraska 32
- Idaho 31
- South Dakota 31
- …
fips >30
county >30
- Unknown 30
- Washington 29
- Franklin 21
- Jefferson 21
- Lincoln 20
- Jackson 18
- Madison 16
- Montgomery 16
- Union 15
- Monroe 14
- Clay 13
- Marion 13
- Warren 13
- Carroll 12
- Crawford 11
- Greene 11
- Johnson 11
- Lee 11
- Adams 10
- Clark 10
- Douglas 10
- Fayette 10
- Grant 10
- Wayne 10
- Clinton 9
- Henry 9
- Lawrence 9
- Marshall 9
- Morgan 9
- Pike 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
33158 | 33158 | 2020-04-05 | Autauga | Alabama | 1001 | 12 | 0 |
33159 | 33159 | 2020-04-05 | Baldwin | Alabama | 1003 | 34 | 1 |
33160 | 33160 | 2020-04-05 | Barbour | Alabama | 1005 | 2 | 0 |
33161 | 33161 | 2020-04-05 | Bibb | Alabama | 1007 | 7 | 0 |
33162 | 33162 | 2020-04-05 | Blount | Alabama | 1009 | 10 | 0 |
33163 | 33163 | 2020-04-05 | Bullock | Alabama | 1011 | 2 | 0 |
33164 | 33164 | 2020-04-05 | Butler | Alabama | 1013 | 1 | 0 |
33165 | 33165 | 2020-04-05 | Calhoun | Alabama | 1015 | 24 | 0 |
33166 | 33166 | 2020-04-05 | Chambers | Alabama | 1017 | 90 | 6 |
33167 | 33167 | 2020-04-05 | Cherokee | Alabama | 1019 | 6 | 0 |
33168 | 33168 | 2020-04-05 | Chilton | Alabama | 1021 | 18 | 0 |
33169 | 33169 | 2020-04-05 | Choctaw | Alabama | 1023 | 5 | 0 |
33170 | 33170 | 2020-04-05 | Clarke | Alabama | 1025 | 9 | 0 |
33171 | 33171 | 2020-04-05 | Clay | Alabama | 1027 | 9 | 0 |
33172 | 33172 | 2020-04-05 | Cleburne | Alabama | 1029 | 7 | 0 |
33173 | 33173 | 2020-04-05 | Coffee | Alabama | 1031 | 7 | 0 |
33174 | 33174 | 2020-04-05 | Colbert | Alabama | 1033 | 6 | 0 |
33175 | 33175 | 2020-04-05 | Conecuh | Alabama | 1035 | 2 | 0 |
33176 | 33176 | 2020-04-05 | Coosa | Alabama | 1037 | 7 | 0 |
33177 | 33177 | 2020-04-05 | Covington | Alabama | 1039 | 4 | 0 |
33178 | 33178 | 2020-04-05 | Crenshaw | Alabama | 1041 | 2 | 0 |
33179 | 33179 | 2020-04-05 | Cullman | Alabama | 1043 | 15 | 1 |
33180 | 33180 | 2020-04-05 | Dale | Alabama | 1045 | 2 | 0 |
33181 | 33181 | 2020-04-05 | Dallas | Alabama | 1047 | 7 | 0 |
33182 | 33182 | 2020-04-05 | DeKalb | Alabama | 1049 | 14 | 0 |
33183 | 33183 | 2020-04-05 | Elmore | Alabama | 1051 | 19 | 0 |
33184 | 33184 | 2020-04-05 | Escambia | Alabama | 1053 | 3 | 0 |
33185 | 33185 | 2020-04-05 | Etowah | Alabama | 1055 | 36 | 3 |
33186 | 33186 | 2020-04-05 | Fayette | Alabama | 1057 | 1 | 0 |
33187 | 33187 | 2020-04-05 | Franklin | Alabama | 1059 | 6 | 0 |
33188 | 33188 | 2020-04-05 | Greene | Alabama | 1063 | 6 | 0 |
33189 | 33189 | 2020-04-05 | Hale | Alabama | 1065 | 3 | 0 |
33190 | 33190 | 2020-04-05 | Henry | Alabama | 1067 | 3 | 0 |
33191 | 33191 | 2020-04-05 | Houston | Alabama | 1069 | 20 | 1 |
33192 | 33192 | 2020-04-05 | Jackson | Alabama | 1071 | 14 | 1 |
33193 | 33193 | 2020-04-05 | Jefferson | Alabama | 1073 | 418 | 9 |
33194 | 33194 | 2020-04-05 | Lamar | Alabama | 1075 | 3 | 0 |
33195 | 33195 | 2020-04-05 | Lauderdale | Alabama | 1077 | 16 | 2 |
33196 | 33196 | 2020-04-05 | Lawrence | Alabama | 1079 | 6 | 0 |
33197 | 33197 | 2020-04-05 | Lee | Alabama | 1081 | 110 | 3 |
33198 | 33198 | 2020-04-05 | Limestone | Alabama | 1083 | 32 | 0 |
33199 | 33199 | 2020-04-05 | Lowndes | Alabama | 1085 | 6 | 0 |
33200 | 33200 | 2020-04-05 | Macon | Alabama | 1087 | 5 | 0 |
33201 | 33201 | 2020-04-05 | Madison | Alabama | 1089 | 137 | 1 |
33202 | 33202 | 2020-04-05 | Marengo | Alabama | 1091 | 13 | 0 |
33203 | 33203 | 2020-04-05 | Marion | Alabama | 1093 | 19 | 2 |
33204 | 33204 | 2020-04-05 | Marshall | Alabama | 1095 | 26 | 0 |
33205 | 33205 | 2020-04-05 | Mobile | Alabama | 1097 | 127 | 6 |
33206 | 33206 | 2020-04-05 | Monroe | Alabama | 1099 | 5 | 0 |
33207 | 33207 | 2020-04-05 | Montgomery | Alabama | 1101 | 71 | 1 |
33208 | 33208 | 2020-04-05 | Morgan | Alabama | 1103 | 27 | 0 |
33209 | 33209 | 2020-04-05 | Pickens | Alabama | 1107 | 12 | 0 |
33210 | 33210 | 2020-04-05 | Pike | Alabama | 1109 | 14 | 0 |
33211 | 33211 | 2020-04-05 | Randolph | Alabama | 1111 | 11 | 1 |
33212 | 33212 | 2020-04-05 | Russell | Alabama | 1113 | 10 | 0 |
33213 | 33213 | 2020-04-05 | Shelby | Alabama | 1117 | 145 | 5 |
33214 | 33214 | 2020-04-05 | St. Clair | Alabama | 1115 | 28 | 0 |
33215 | 33215 | 2020-04-05 | Sumter | Alabama | 1119 | 7 | 0 |
33216 | 33216 | 2020-04-05 | Talladega | Alabama | 1121 | 20 | 0 |
33217 | 33217 | 2020-04-05 | Tallapoosa | Alabama | 1123 | 30 | 1 |
33218 | 33218 | 2020-04-05 | Tuscaloosa | Alabama | 1125 | 60 | 0 |
33219 | 33219 | 2020-04-05 | Walker | Alabama | 1127 | 49 | 0 |
33220 | 33220 | 2020-04-05 | Washington | Alabama | 1129 | 5 | 1 |
33221 | 33221 | 2020-04-05 | Wilcox | Alabama | 1131 | 12 | 0 |
33222 | 33222 | 2020-04-05 | Winston | Alabama | 1133 | 3 | 0 |
33223 | 33223 | 2020-04-05 | Anchorage | Alaska | 2020 | 85 | 3 |
33224 | 33224 | 2020-04-05 | Fairbanks North Star Borough | Alaska | 2090 | 53 | 1 |
33225 | 33225 | 2020-04-05 | Juneau City and Borough | Alaska | 2110 | 14 | 0 |
33226 | 33226 | 2020-04-05 | Kenai Peninsula Borough | Alaska | 2122 | 11 | 0 |
33227 | 33227 | 2020-04-05 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
33228 | 33228 | 2020-04-05 | Matanuska-Susitna Borough | Alaska | 2170 | 4 | 0 |
33229 | 33229 | 2020-04-05 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
33230 | 33230 | 2020-04-05 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
33231 | 33231 | 2020-04-05 | Apache | Arizona | 4001 | 23 | 0 |
33232 | 33232 | 2020-04-05 | Cochise | Arizona | 4003 | 8 | 0 |
33233 | 33233 | 2020-04-05 | Coconino | Arizona | 4005 | 155 | 10 |
33234 | 33234 | 2020-04-05 | Gila | Arizona | 4007 | 3 | 0 |
33235 | 33235 | 2020-04-05 | Graham | Arizona | 4009 | 2 | 0 |
33236 | 33236 | 2020-04-05 | Greenlee | Arizona | 4011 | 1 | 0 |
33237 | 33237 | 2020-04-05 | La Paz | Arizona | 4012 | 3 | 0 |
33238 | 33238 | 2020-04-05 | Maricopa | Arizona | 4013 | 1326 | 31 |
33239 | 33239 | 2020-04-05 | Mohave | Arizona | 4015 | 16 | 1 |
33240 | 33240 | 2020-04-05 | Navajo | Arizona | 4017 | 195 | 1 |
33241 | 33241 | 2020-04-05 | Pima | Arizona | 4019 | 372 | 12 |
33242 | 33242 | 2020-04-05 | Pinal | Arizona | 4021 | 103 | 0 |
33243 | 33243 | 2020-04-05 | Santa Cruz | Arizona | 4023 | 4 | 0 |
33244 | 33244 | 2020-04-05 | Unknown | Arizona | 0 | 9 | |
33245 | 33245 | 2020-04-05 | Yavapai | Arizona | 4025 | 45 | 0 |
33246 | 33246 | 2020-04-05 | Yuma | Arizona | 4027 | 13 | 0 |
33247 | 33247 | 2020-04-05 | Arkansas | Arkansas | 5001 | 1 | 0 |
33248 | 33248 | 2020-04-05 | Ashley | Arkansas | 5003 | 4 | 0 |
33249 | 33249 | 2020-04-05 | Baxter | Arkansas | 5005 | 3 | 0 |
33250 | 33250 | 2020-04-05 | Benton | Arkansas | 5007 | 42 | 0 |
33251 | 33251 | 2020-04-05 | Boone | Arkansas | 5009 | 3 | 0 |
33252 | 33252 | 2020-04-05 | Bradley | Arkansas | 5011 | 1 | 0 |
33253 | 33253 | 2020-04-05 | Carroll | Arkansas | 5015 | 1 | 0 |
33254 | 33254 | 2020-04-05 | Chicot | Arkansas | 5017 | 3 | 0 |
33255 | 33255 | 2020-04-05 | Clark | Arkansas | 5019 | 27 | 0 |
33256 | 33256 | 2020-04-05 | Cleburne | Arkansas | 5023 | 65 | 4 |
33257 | 33257 | 2020-04-05 | Cleveland | Arkansas | 5025 | 7 | 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);