ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 2,391
- Texas 2,231
- Virginia 1,584
- California 1,507
- Indiana 1,424
- North Carolina 1,384
- Tennessee 1,366
- Mississippi 1,348
- Ohio 1,285
- Florida 1,280
- New York 1,262
- Michigan 1,167
- Kentucky 1,140
- Pennsylvania 1,119
- Louisiana 1,116
- Illinois 1,085
- Missouri 1,072
- Colorado 1,020
- Iowa 983
- Minnesota 967
- Washington 949
- Wisconsin 948
- Alabama 930
- Arkansas 914
- South Carolina 852
- Oklahoma 795
- Kansas 701
- Oregon 580
- New Jersey 565
- Maryland 502
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
38243 | 38243 | 2020-04-07 | Woodruff | Arkansas | 5147 | 1 | 0 |
38244 | 38244 | 2020-04-07 | Yell | Arkansas | 5149 | 1 | 0 |
38245 | 38245 | 2020-04-07 | Alameda | California | 6001 | 655 | 15 |
38246 | 38246 | 2020-04-07 | Alpine | California | 6003 | 2 | 0 |
38247 | 38247 | 2020-04-07 | Amador | California | 6005 | 2 | 0 |
38248 | 38248 | 2020-04-07 | Butte | California | 6007 | 13 | 0 |
38249 | 38249 | 2020-04-07 | Calaveras | California | 6009 | 5 | 0 |
38250 | 38250 | 2020-04-07 | Colusa | California | 6011 | 3 | 0 |
38251 | 38251 | 2020-04-07 | Contra Costa | California | 6013 | 442 | 7 |
38252 | 38252 | 2020-04-07 | Del Norte | California | 6015 | 2 | 0 |
38253 | 38253 | 2020-04-07 | El Dorado | California | 6017 | 28 | 0 |
38254 | 38254 | 2020-04-07 | Fresno | California | 6019 | 146 | 3 |
38255 | 38255 | 2020-04-07 | Glenn | California | 6021 | 2 | 0 |
38256 | 38256 | 2020-04-07 | Humboldt | California | 6023 | 50 | 0 |
38257 | 38257 | 2020-04-07 | Imperial | California | 6025 | 73 | 2 |
38258 | 38258 | 2020-04-07 | Inyo | California | 6027 | 11 | 0 |
38259 | 38259 | 2020-04-07 | Kern | California | 6029 | 267 | 2 |
38260 | 38260 | 2020-04-07 | Kings | California | 6031 | 5 | 0 |
38261 | 38261 | 2020-04-07 | Lake | California | 6033 | 2 | 0 |
38262 | 38262 | 2020-04-07 | Los Angeles | California | 6037 | 6910 | 169 |
38263 | 38263 | 2020-04-07 | Madera | California | 6039 | 30 | 2 |
38264 | 38264 | 2020-04-07 | Marin | California | 6041 | 148 | 10 |
38265 | 38265 | 2020-04-07 | Mendocino | California | 6045 | 4 | 0 |
38266 | 38266 | 2020-04-07 | Merced | California | 6047 | 34 | 1 |
38267 | 38267 | 2020-04-07 | Mono | California | 6051 | 19 | 1 |
38268 | 38268 | 2020-04-07 | Monterey | California | 6053 | 64 | 2 |
38269 | 38269 | 2020-04-07 | Napa | California | 6055 | 24 | 2 |
38270 | 38270 | 2020-04-07 | Nevada | California | 6057 | 34 | 1 |
38271 | 38271 | 2020-04-07 | Orange | California | 6059 | 931 | 15 |
38272 | 38272 | 2020-04-07 | Placer | California | 6061 | 115 | 3 |
38273 | 38273 | 2020-04-07 | Plumas | California | 6063 | 3 | 0 |
38274 | 38274 | 2020-04-07 | Riverside | California | 6065 | 1016 | 28 |
38275 | 38275 | 2020-04-07 | Sacramento | California | 6067 | 524 | 21 |
38276 | 38276 | 2020-04-07 | San Benito | California | 6069 | 31 | 2 |
38277 | 38277 | 2020-04-07 | San Bernardino | California | 6071 | 547 | 17 |
38278 | 38278 | 2020-04-07 | San Diego | California | 6073 | 1454 | 31 |
38279 | 38279 | 2020-04-07 | San Francisco | California | 6075 | 622 | 9 |
38280 | 38280 | 2020-04-07 | San Joaquin | California | 6077 | 223 | 13 |
38281 | 38281 | 2020-04-07 | San Luis Obispo | California | 6079 | 99 | 1 |
38282 | 38282 | 2020-04-07 | San Mateo | California | 6081 | 589 | 21 |
38283 | 38283 | 2020-04-07 | Santa Barbara | California | 6083 | 218 | 2 |
38284 | 38284 | 2020-04-07 | Santa Clara | California | 6085 | 1285 | 44 |
38285 | 38285 | 2020-04-07 | Santa Cruz | California | 6087 | 76 | 1 |
38286 | 38286 | 2020-04-07 | Shasta | California | 6089 | 23 | 3 |
38287 | 38287 | 2020-04-07 | Siskiyou | California | 6093 | 4 | 0 |
38288 | 38288 | 2020-04-07 | Solano | California | 6095 | 104 | 2 |
38289 | 38289 | 2020-04-07 | Sonoma | California | 6097 | 120 | 1 |
38290 | 38290 | 2020-04-07 | Stanislaus | California | 6099 | 90 | 0 |
38291 | 38291 | 2020-04-07 | Sutter | California | 6101 | 19 | 2 |
38292 | 38292 | 2020-04-07 | Tehama | California | 6103 | 1 | 0 |
38293 | 38293 | 2020-04-07 | Tulare | California | 6107 | 157 | 6 |
38294 | 38294 | 2020-04-07 | Tuolumne | California | 6109 | 1 | 0 |
38295 | 38295 | 2020-04-07 | Unknown | California | 1 | 0 | |
38296 | 38296 | 2020-04-07 | Ventura | California | 6111 | 243 | 6 |
38297 | 38297 | 2020-04-07 | Yolo | California | 6113 | 56 | 2 |
38298 | 38298 | 2020-04-07 | Yuba | California | 6115 | 13 | 0 |
38299 | 38299 | 2020-04-07 | Adams | Colorado | 8001 | 388 | 14 |
38300 | 38300 | 2020-04-07 | Alamosa | Colorado | 8003 | 4 | 0 |
38301 | 38301 | 2020-04-07 | Arapahoe | Colorado | 8005 | 718 | 16 |
38302 | 38302 | 2020-04-07 | Archuleta | Colorado | 8007 | 6 | 0 |
38303 | 38303 | 2020-04-07 | Baca | Colorado | 8009 | 9 | 0 |
38304 | 38304 | 2020-04-07 | Boulder | Colorado | 8013 | 206 | 3 |
38305 | 38305 | 2020-04-07 | Broomfield | Colorado | 8014 | 50 | 2 |
38306 | 38306 | 2020-04-07 | Chaffee | Colorado | 8015 | 22 | 2 |
38307 | 38307 | 2020-04-07 | Clear Creek | Colorado | 8019 | 7 | 0 |
38308 | 38308 | 2020-04-07 | Costilla | Colorado | 8023 | 3 | 0 |
38309 | 38309 | 2020-04-07 | Crowley | Colorado | 8025 | 1 | 1 |
38310 | 38310 | 2020-04-07 | Custer | Colorado | 8027 | 2 | 0 |
38311 | 38311 | 2020-04-07 | Delta | Colorado | 8029 | 5 | 0 |
38312 | 38312 | 2020-04-07 | Denver | Colorado | 8031 | 884 | 31 |
38313 | 38313 | 2020-04-07 | Douglas | Colorado | 8035 | 232 | 8 |
38314 | 38314 | 2020-04-07 | Eagle | Colorado | 8037 | 372 | 5 |
38315 | 38315 | 2020-04-07 | El Paso | Colorado | 8041 | 457 | 28 |
38316 | 38316 | 2020-04-07 | Elbert | Colorado | 8039 | 9 | 1 |
38317 | 38317 | 2020-04-07 | Fremont | Colorado | 8043 | 4 | 0 |
38318 | 38318 | 2020-04-07 | Garfield | Colorado | 8045 | 48 | 1 |
38319 | 38319 | 2020-04-07 | Grand | Colorado | 8049 | 4 | 0 |
38320 | 38320 | 2020-04-07 | Gunnison | Colorado | 8051 | 95 | 1 |
38321 | 38321 | 2020-04-07 | Hinsdale | Colorado | 8053 | 1 | 0 |
38322 | 38322 | 2020-04-07 | Huerfano | Colorado | 8055 | 1 | 0 |
38323 | 38323 | 2020-04-07 | Jefferson | Colorado | 8059 | 579 | 21 |
38324 | 38324 | 2020-04-07 | Kit Carson | Colorado | 8063 | 5 | 0 |
38325 | 38325 | 2020-04-07 | La Plata | Colorado | 8067 | 34 | 0 |
38326 | 38326 | 2020-04-07 | Lake | Colorado | 8065 | 3 | 0 |
38327 | 38327 | 2020-04-07 | Larimer | Colorado | 8069 | 161 | 8 |
38328 | 38328 | 2020-04-07 | Las Animas | Colorado | 8071 | 1 | 0 |
38329 | 38329 | 2020-04-07 | Lincoln | Colorado | 8073 | 1 | 0 |
38330 | 38330 | 2020-04-07 | Logan | Colorado | 8075 | 13 | 0 |
38331 | 38331 | 2020-04-07 | Mesa | Colorado | 8077 | 27 | 0 |
38332 | 38332 | 2020-04-07 | Mineral | Colorado | 8079 | 2 | 0 |
38333 | 38333 | 2020-04-07 | Moffat | Colorado | 8081 | 4 | 0 |
38334 | 38334 | 2020-04-07 | Montezuma | Colorado | 8083 | 8 | 1 |
38335 | 38335 | 2020-04-07 | Montrose | Colorado | 8085 | 35 | 3 |
38336 | 38336 | 2020-04-07 | Morgan | Colorado | 8087 | 23 | 0 |
38337 | 38337 | 2020-04-07 | Otero | Colorado | 8089 | 4 | 0 |
38338 | 38338 | 2020-04-07 | Ouray | Colorado | 8091 | 3 | 0 |
38339 | 38339 | 2020-04-07 | Park | Colorado | 8093 | 5 | 0 |
38340 | 38340 | 2020-04-07 | Phillips | Colorado | 8095 | 3 | 0 |
38341 | 38341 | 2020-04-07 | Pitkin | Colorado | 8097 | 39 | 2 |
38342 | 38342 | 2020-04-07 | Pueblo | Colorado | 8101 | 46 | 3 |
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);