ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,598 rows where date = "2020-04-09" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 173
- Georgia 156
- Virginia 120
- Kentucky 96
- North Carolina 91
- Indiana 89
- Missouri 89
- Tennessee 89
- Ohio 85
- Illinois 82
- Mississippi 81
- Iowa 79
- Michigan 73
- Arkansas 70
- Florida 67
- Pennsylvania 67
- Alabama 66
- Minnesota 66
- Louisiana 64
- Wisconsin 61
- Oklahoma 60
- New York 58
- Colorado 57
- Kansas 57
- California 53
- South Carolina 46
- West Virginia 43
- Washington 38
- Nebraska 37
- South Dakota 34
- …
fips >30
county >30
- Washington 30
- Unknown 27
- Jefferson 24
- Franklin 23
- Jackson 20
- Lincoln 20
- Madison 19
- Montgomery 16
- Union 15
- Clay 14
- Marion 14
- Monroe 14
- Greene 13
- Warren 13
- Carroll 12
- Crawford 11
- Fayette 11
- Johnson 11
- Lee 11
- Polk 11
- Wayne 11
- Adams 10
- Clark 10
- Douglas 10
- Grant 10
- Henry 10
- Lawrence 10
- Marshall 10
- Morgan 10
- Clinton 9
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
43200 | 43200 | 2020-04-09 | Autauga | Alabama | 1001 | 17 | 1 |
43201 | 43201 | 2020-04-09 | Baldwin | Alabama | 1003 | 59 | 1 |
43202 | 43202 | 2020-04-09 | Barbour | Alabama | 1005 | 7 | 0 |
43203 | 43203 | 2020-04-09 | Bibb | Alabama | 1007 | 11 | 0 |
43204 | 43204 | 2020-04-09 | Blount | Alabama | 1009 | 11 | 0 |
43205 | 43205 | 2020-04-09 | Bullock | Alabama | 1011 | 4 | 0 |
43206 | 43206 | 2020-04-09 | Butler | Alabama | 1013 | 3 | 0 |
43207 | 43207 | 2020-04-09 | Calhoun | Alabama | 1015 | 54 | 0 |
43208 | 43208 | 2020-04-09 | Chambers | Alabama | 1017 | 161 | 8 |
43209 | 43209 | 2020-04-09 | Cherokee | Alabama | 1019 | 7 | 0 |
43210 | 43210 | 2020-04-09 | Chilton | Alabama | 1021 | 25 | 0 |
43211 | 43211 | 2020-04-09 | Choctaw | Alabama | 1023 | 6 | 0 |
43212 | 43212 | 2020-04-09 | Clarke | Alabama | 1025 | 13 | 0 |
43213 | 43213 | 2020-04-09 | Clay | Alabama | 1027 | 11 | 0 |
43214 | 43214 | 2020-04-09 | Cleburne | Alabama | 1029 | 12 | 0 |
43215 | 43215 | 2020-04-09 | Coffee | Alabama | 1031 | 14 | 0 |
43216 | 43216 | 2020-04-09 | Colbert | Alabama | 1033 | 8 | 1 |
43217 | 43217 | 2020-04-09 | Conecuh | Alabama | 1035 | 3 | 0 |
43218 | 43218 | 2020-04-09 | Coosa | Alabama | 1037 | 10 | 0 |
43219 | 43219 | 2020-04-09 | Covington | Alabama | 1039 | 10 | 0 |
43220 | 43220 | 2020-04-09 | Crenshaw | Alabama | 1041 | 2 | 0 |
43221 | 43221 | 2020-04-09 | Cullman | Alabama | 1043 | 29 | 1 |
43222 | 43222 | 2020-04-09 | Dale | Alabama | 1045 | 6 | 0 |
43223 | 43223 | 2020-04-09 | Dallas | Alabama | 1047 | 10 | 0 |
43224 | 43224 | 2020-04-09 | DeKalb | Alabama | 1049 | 16 | 0 |
43225 | 43225 | 2020-04-09 | Elmore | Alabama | 1051 | 29 | 0 |
43226 | 43226 | 2020-04-09 | Escambia | Alabama | 1053 | 5 | 0 |
43227 | 43227 | 2020-04-09 | Etowah | Alabama | 1055 | 53 | 5 |
43228 | 43228 | 2020-04-09 | Fayette | Alabama | 1057 | 1 | 0 |
43229 | 43229 | 2020-04-09 | Franklin | Alabama | 1059 | 8 | 0 |
43230 | 43230 | 2020-04-09 | Greene | Alabama | 1063 | 13 | 0 |
43231 | 43231 | 2020-04-09 | Hale | Alabama | 1065 | 7 | 0 |
43232 | 43232 | 2020-04-09 | Henry | Alabama | 1067 | 8 | 0 |
43233 | 43233 | 2020-04-09 | Houston | Alabama | 1069 | 33 | 1 |
43234 | 43234 | 2020-04-09 | Jackson | Alabama | 1071 | 22 | 2 |
43235 | 43235 | 2020-04-09 | Jefferson | Alabama | 1073 | 523 | 14 |
43236 | 43236 | 2020-04-09 | Lamar | Alabama | 1075 | 7 | 0 |
43237 | 43237 | 2020-04-09 | Lauderdale | Alabama | 1077 | 20 | 3 |
43238 | 43238 | 2020-04-09 | Lawrence | Alabama | 1079 | 8 | 0 |
43239 | 43239 | 2020-04-09 | Lee | Alabama | 1081 | 206 | 6 |
43240 | 43240 | 2020-04-09 | Limestone | Alabama | 1083 | 35 | 0 |
43241 | 43241 | 2020-04-09 | Lowndes | Alabama | 1085 | 12 | 0 |
43242 | 43242 | 2020-04-09 | Macon | Alabama | 1087 | 9 | 1 |
43243 | 43243 | 2020-04-09 | Madison | Alabama | 1089 | 177 | 3 |
43244 | 43244 | 2020-04-09 | Marengo | Alabama | 1091 | 14 | 1 |
43245 | 43245 | 2020-04-09 | Marion | Alabama | 1093 | 33 | 3 |
43246 | 43246 | 2020-04-09 | Marshall | Alabama | 1095 | 64 | 2 |
43247 | 43247 | 2020-04-09 | Mobile | Alabama | 1097 | 329 | 10 |
43248 | 43248 | 2020-04-09 | Monroe | Alabama | 1099 | 6 | 1 |
43249 | 43249 | 2020-04-09 | Montgomery | Alabama | 1101 | 90 | 3 |
43250 | 43250 | 2020-04-09 | Morgan | Alabama | 1103 | 36 | 0 |
43251 | 43251 | 2020-04-09 | Perry | Alabama | 1105 | 2 | 0 |
43252 | 43252 | 2020-04-09 | Pickens | Alabama | 1107 | 19 | 0 |
43253 | 43253 | 2020-04-09 | Pike | Alabama | 1109 | 18 | 0 |
43254 | 43254 | 2020-04-09 | Randolph | Alabama | 1111 | 20 | 3 |
43255 | 43255 | 2020-04-09 | Russell | Alabama | 1113 | 18 | 0 |
43256 | 43256 | 2020-04-09 | Shelby | Alabama | 1117 | 183 | 5 |
43257 | 43257 | 2020-04-09 | St. Clair | Alabama | 1115 | 37 | 0 |
43258 | 43258 | 2020-04-09 | Sumter | Alabama | 1119 | 17 | 0 |
43259 | 43259 | 2020-04-09 | Talladega | Alabama | 1121 | 30 | 0 |
43260 | 43260 | 2020-04-09 | Tallapoosa | Alabama | 1123 | 48 | 2 |
43261 | 43261 | 2020-04-09 | Tuscaloosa | Alabama | 1125 | 86 | 0 |
43262 | 43262 | 2020-04-09 | Walker | Alabama | 1127 | 72 | 0 |
43263 | 43263 | 2020-04-09 | Washington | Alabama | 1129 | 11 | 1 |
43264 | 43264 | 2020-04-09 | Wilcox | Alabama | 1131 | 17 | 0 |
43265 | 43265 | 2020-04-09 | Winston | Alabama | 1133 | 3 | 0 |
43266 | 43266 | 2020-04-09 | Anchorage | Alaska | 2020 | 109 | 4 |
43267 | 43267 | 2020-04-09 | Bethel Census Area | Alaska | 2050 | 1 | 0 |
43268 | 43268 | 2020-04-09 | Fairbanks North Star Borough | Alaska | 2090 | 73 | 1 |
43269 | 43269 | 2020-04-09 | Juneau City and Borough | Alaska | 2110 | 14 | 0 |
43270 | 43270 | 2020-04-09 | Kenai Peninsula Borough | Alaska | 2122 | 13 | 0 |
43271 | 43271 | 2020-04-09 | Ketchikan Gateway Borough | Alaska | 2130 | 14 | 0 |
43272 | 43272 | 2020-04-09 | Matanuska-Susitna Borough | Alaska | 2170 | 6 | 0 |
43273 | 43273 | 2020-04-09 | Petersburg Borough | Alaska | 2195 | 1 | 0 |
43274 | 43274 | 2020-04-09 | Southeast Fairbanks Census Area | Alaska | 2240 | 1 | 0 |
43275 | 43275 | 2020-04-09 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1 | 0 |
43276 | 43276 | 2020-04-09 | Apache | Arizona | 4001 | 52 | 3 |
43277 | 43277 | 2020-04-09 | Cochise | Arizona | 4003 | 11 | 0 |
43278 | 43278 | 2020-04-09 | Coconino | Arizona | 4005 | 210 | 15 |
43279 | 43279 | 2020-04-09 | Gila | Arizona | 4007 | 3 | 0 |
43280 | 43280 | 2020-04-09 | Graham | Arizona | 4009 | 2 | 0 |
43281 | 43281 | 2020-04-09 | Greenlee | Arizona | 4011 | 1 | 0 |
43282 | 43282 | 2020-04-09 | La Paz | Arizona | 4012 | 4 | 0 |
43283 | 43283 | 2020-04-09 | Maricopa | Arizona | 4013 | 1689 | 39 |
43284 | 43284 | 2020-04-09 | Mohave | Arizona | 4015 | 27 | 1 |
43285 | 43285 | 2020-04-09 | Navajo | Arizona | 4017 | 286 | 7 |
43286 | 43286 | 2020-04-09 | Pima | Arizona | 4019 | 512 | 20 |
43287 | 43287 | 2020-04-09 | Pinal | Arizona | 4021 | 137 | 3 |
43288 | 43288 | 2020-04-09 | Santa Cruz | Arizona | 4023 | 7 | 0 |
43289 | 43289 | 2020-04-09 | Yavapai | Arizona | 4025 | 62 | 1 |
43290 | 43290 | 2020-04-09 | Yuma | Arizona | 4027 | 15 | 0 |
43291 | 43291 | 2020-04-09 | Arkansas | Arkansas | 5001 | 2 | 0 |
43292 | 43292 | 2020-04-09 | Ashley | Arkansas | 5003 | 9 | 0 |
43293 | 43293 | 2020-04-09 | Baxter | Arkansas | 5005 | 4 | 0 |
43294 | 43294 | 2020-04-09 | Benton | Arkansas | 5007 | 47 | 0 |
43295 | 43295 | 2020-04-09 | Boone | Arkansas | 5009 | 3 | 0 |
43296 | 43296 | 2020-04-09 | Bradley | Arkansas | 5011 | 6 | 0 |
43297 | 43297 | 2020-04-09 | Carroll | Arkansas | 5015 | 2 | 0 |
43298 | 43298 | 2020-04-09 | Chicot | Arkansas | 5017 | 4 | 0 |
43299 | 43299 | 2020-04-09 | Clark | Arkansas | 5019 | 27 | 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);