ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,718 rows where date = "2020-04-15" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 186
- Georgia 158
- Virginia 124
- Kentucky 106
- Missouri 93
- North Carolina 93
- Indiana 92
- Tennessee 91
- Illinois 90
- Ohio 87
- Iowa 82
- Mississippi 81
- Michigan 78
- Arkansas 72
- Minnesota 72
- Alabama 67
- Florida 67
- Pennsylvania 67
- Kansas 65
- Louisiana 65
- Wisconsin 65
- Oklahoma 64
- New York 58
- Colorado 57
- California 53
- West Virginia 48
- Nebraska 46
- South Carolina 46
- South Dakota 39
- Washington 39
- …
fips >30
county >30
- Washington 30
- Jefferson 25
- Unknown 25
- Franklin 24
- Jackson 22
- Lincoln 21
- Madison 19
- Montgomery 17
- Union 17
- Clay 16
- Marion 15
- Monroe 15
- Greene 14
- Warren 14
- Carroll 12
- Johnson 12
- Polk 12
- Wayne 12
- Crawford 11
- Fayette 11
- Grant 11
- Lee 11
- Morgan 11
- Adams 10
- Clark 10
- Douglas 10
- Henry 10
- Lake 10
- Lawrence 10
- Marshall 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
59166 | 59166 | 2020-04-15 | Autauga | Alabama | 1001 | 25 | 1 |
59167 | 59167 | 2020-04-15 | Baldwin | Alabama | 1003 | 98 | 2 |
59168 | 59168 | 2020-04-15 | Barbour | Alabama | 1005 | 13 | 0 |
59169 | 59169 | 2020-04-15 | Bibb | Alabama | 1007 | 19 | 0 |
59170 | 59170 | 2020-04-15 | Blount | Alabama | 1009 | 17 | 0 |
59171 | 59171 | 2020-04-15 | Bullock | Alabama | 1011 | 8 | 0 |
59172 | 59172 | 2020-04-15 | Butler | Alabama | 1013 | 11 | 0 |
59173 | 59173 | 2020-04-15 | Calhoun | Alabama | 1015 | 62 | 0 |
59174 | 59174 | 2020-04-15 | Chambers | Alabama | 1017 | 227 | 10 |
59175 | 59175 | 2020-04-15 | Cherokee | Alabama | 1019 | 10 | 0 |
59176 | 59176 | 2020-04-15 | Chilton | Alabama | 1021 | 37 | 0 |
59177 | 59177 | 2020-04-15 | Choctaw | Alabama | 1023 | 13 | 0 |
59178 | 59178 | 2020-04-15 | Clarke | Alabama | 1025 | 22 | 0 |
59179 | 59179 | 2020-04-15 | Clay | Alabama | 1027 | 14 | 0 |
59180 | 59180 | 2020-04-15 | Cleburne | Alabama | 1029 | 12 | 0 |
59181 | 59181 | 2020-04-15 | Coffee | Alabama | 1031 | 43 | 0 |
59182 | 59182 | 2020-04-15 | Colbert | Alabama | 1033 | 11 | 1 |
59183 | 59183 | 2020-04-15 | Conecuh | Alabama | 1035 | 6 | 0 |
59184 | 59184 | 2020-04-15 | Coosa | Alabama | 1037 | 20 | 1 |
59185 | 59185 | 2020-04-15 | Covington | Alabama | 1039 | 18 | 0 |
59186 | 59186 | 2020-04-15 | Crenshaw | Alabama | 1041 | 4 | 0 |
59187 | 59187 | 2020-04-15 | Cullman | Alabama | 1043 | 40 | 1 |
59188 | 59188 | 2020-04-15 | Dale | Alabama | 1045 | 13 | 0 |
59189 | 59189 | 2020-04-15 | Dallas | Alabama | 1047 | 22 | 2 |
59190 | 59190 | 2020-04-15 | DeKalb | Alabama | 1049 | 31 | 0 |
59191 | 59191 | 2020-04-15 | Elmore | Alabama | 1051 | 49 | 0 |
59192 | 59192 | 2020-04-15 | Escambia | Alabama | 1053 | 11 | 0 |
59193 | 59193 | 2020-04-15 | Etowah | Alabama | 1055 | 84 | 8 |
59194 | 59194 | 2020-04-15 | Fayette | Alabama | 1057 | 4 | 0 |
59195 | 59195 | 2020-04-15 | Franklin | Alabama | 1059 | 17 | 1 |
59196 | 59196 | 2020-04-15 | Geneva | Alabama | 1061 | 2 | 0 |
59197 | 59197 | 2020-04-15 | Greene | Alabama | 1063 | 19 | 0 |
59198 | 59198 | 2020-04-15 | Hale | Alabama | 1065 | 20 | 0 |
59199 | 59199 | 2020-04-15 | Henry | Alabama | 1067 | 15 | 0 |
59200 | 59200 | 2020-04-15 | Houston | Alabama | 1069 | 55 | 3 |
59201 | 59201 | 2020-04-15 | Jackson | Alabama | 1071 | 31 | 2 |
59202 | 59202 | 2020-04-15 | Jefferson | Alabama | 1073 | 628 | 17 |
59203 | 59203 | 2020-04-15 | Lamar | Alabama | 1075 | 7 | 0 |
59204 | 59204 | 2020-04-15 | Lauderdale | Alabama | 1077 | 22 | 4 |
59205 | 59205 | 2020-04-15 | Lawrence | Alabama | 1079 | 8 | 0 |
59206 | 59206 | 2020-04-15 | Lee | Alabama | 1081 | 285 | 12 |
59207 | 59207 | 2020-04-15 | Limestone | Alabama | 1083 | 38 | 0 |
59208 | 59208 | 2020-04-15 | Lowndes | Alabama | 1085 | 23 | 0 |
59209 | 59209 | 2020-04-15 | Macon | Alabama | 1087 | 19 | 2 |
59210 | 59210 | 2020-04-15 | Madison | Alabama | 1089 | 194 | 4 |
59211 | 59211 | 2020-04-15 | Marengo | Alabama | 1091 | 24 | 1 |
59212 | 59212 | 2020-04-15 | Marion | Alabama | 1093 | 58 | 4 |
59213 | 59213 | 2020-04-15 | Marshall | Alabama | 1095 | 109 | 2 |
59214 | 59214 | 2020-04-15 | Mobile | Alabama | 1097 | 561 | 19 |
59215 | 59215 | 2020-04-15 | Monroe | Alabama | 1099 | 7 | 1 |
59216 | 59216 | 2020-04-15 | Montgomery | Alabama | 1101 | 189 | 5 |
59217 | 59217 | 2020-04-15 | Morgan | Alabama | 1103 | 44 | 0 |
59218 | 59218 | 2020-04-15 | Perry | Alabama | 1105 | 7 | 0 |
59219 | 59219 | 2020-04-15 | Pickens | Alabama | 1107 | 30 | 0 |
59220 | 59220 | 2020-04-15 | Pike | Alabama | 1109 | 27 | 0 |
59221 | 59221 | 2020-04-15 | Randolph | Alabama | 1111 | 45 | 4 |
59222 | 59222 | 2020-04-15 | Russell | Alabama | 1113 | 31 | 0 |
59223 | 59223 | 2020-04-15 | Shelby | Alabama | 1117 | 241 | 7 |
59224 | 59224 | 2020-04-15 | St. Clair | Alabama | 1115 | 49 | 0 |
59225 | 59225 | 2020-04-15 | Sumter | Alabama | 1119 | 30 | 0 |
59226 | 59226 | 2020-04-15 | Talladega | Alabama | 1121 | 40 | 1 |
59227 | 59227 | 2020-04-15 | Tallapoosa | Alabama | 1123 | 149 | 7 |
59228 | 59228 | 2020-04-15 | Tuscaloosa | Alabama | 1125 | 131 | 0 |
59229 | 59229 | 2020-04-15 | Walker | Alabama | 1127 | 85 | 0 |
59230 | 59230 | 2020-04-15 | Washington | Alabama | 1129 | 12 | 1 |
59231 | 59231 | 2020-04-15 | Wilcox | Alabama | 1131 | 38 | 0 |
59232 | 59232 | 2020-04-15 | Winston | Alabama | 1133 | 7 | 0 |
59233 | 59233 | 2020-04-15 | Anchorage | Alaska | 2020 | 139 | 4 |
59234 | 59234 | 2020-04-15 | Bethel Census Area | Alaska | 2050 | 1 | 0 |
59235 | 59235 | 2020-04-15 | Fairbanks North Star Borough | Alaska | 2090 | 79 | 2 |
59236 | 59236 | 2020-04-15 | Juneau City and Borough | Alaska | 2110 | 21 | 0 |
59237 | 59237 | 2020-04-15 | Kenai Peninsula Borough | Alaska | 2122 | 15 | 0 |
59238 | 59238 | 2020-04-15 | Ketchikan Gateway Borough | Alaska | 2130 | 15 | 0 |
59239 | 59239 | 2020-04-15 | Matanuska-Susitna Borough | Alaska | 2170 | 15 | 1 |
59240 | 59240 | 2020-04-15 | Nome Census Area | Alaska | 2180 | 1 | 0 |
59241 | 59241 | 2020-04-15 | Petersburg Borough | Alaska | 2195 | 1 | 0 |
59242 | 59242 | 2020-04-15 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 2 | 0 |
59243 | 59243 | 2020-04-15 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
59244 | 59244 | 2020-04-15 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
59245 | 59245 | 2020-04-15 | Apache | Arizona | 4001 | 110 | 4 |
59246 | 59246 | 2020-04-15 | Cochise | Arizona | 4003 | 15 | 0 |
59247 | 59247 | 2020-04-15 | Coconino | Arizona | 4005 | 266 | 24 |
59248 | 59248 | 2020-04-15 | Gila | Arizona | 4007 | 3 | 0 |
59249 | 59249 | 2020-04-15 | Graham | Arizona | 4009 | 2 | 0 |
59250 | 59250 | 2020-04-15 | Greenlee | Arizona | 4011 | 2 | 0 |
59251 | 59251 | 2020-04-15 | La Paz | Arizona | 4012 | 5 | 1 |
59252 | 59252 | 2020-04-15 | Maricopa | Arizona | 4013 | 2146 | 60 |
59253 | 59253 | 2020-04-15 | Mohave | Arizona | 4015 | 45 | 2 |
59254 | 59254 | 2020-04-15 | Navajo | Arizona | 4017 | 390 | 10 |
59255 | 59255 | 2020-04-15 | Pima | Arizona | 4019 | 700 | 34 |
59256 | 59256 | 2020-04-15 | Pinal | Arizona | 4021 | 182 | 5 |
59257 | 59257 | 2020-04-15 | Santa Cruz | Arizona | 4023 | 12 | 0 |
59258 | 59258 | 2020-04-15 | Yavapai | Arizona | 4025 | 66 | 1 |
59259 | 59259 | 2020-04-15 | Yuma | Arizona | 4027 | 18 | 1 |
59260 | 59260 | 2020-04-15 | Arkansas | Arkansas | 5001 | 2 | 0 |
59261 | 59261 | 2020-04-15 | Ashley | Arkansas | 5003 | 11 | 0 |
59262 | 59262 | 2020-04-15 | Baxter | Arkansas | 5005 | 4 | 0 |
59263 | 59263 | 2020-04-15 | Benton | Arkansas | 5007 | 62 | 0 |
59264 | 59264 | 2020-04-15 | Boone | Arkansas | 5009 | 3 | 0 |
59265 | 59265 | 2020-04-15 | Bradley | Arkansas | 5011 | 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);