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,472
- 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 912
- South Carolina 852
- Oklahoma 795
- Kansas 701
- Oregon 580
- New Jersey 565
- Maryland 502
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
38343 | 38343 | 2020-04-07 | Rio Blanco | Colorado | 8103 | 1 | 0 |
38344 | 38344 | 2020-04-07 | Rio Grande | Colorado | 8105 | 5 | 0 |
38345 | 38345 | 2020-04-07 | Routt | Colorado | 8107 | 32 | 0 |
38346 | 38346 | 2020-04-07 | Saguache | Colorado | 8109 | 3 | 0 |
38347 | 38347 | 2020-04-07 | San Miguel | Colorado | 8113 | 10 | 0 |
38348 | 38348 | 2020-04-07 | Summit | Colorado | 8117 | 53 | 0 |
38349 | 38349 | 2020-04-07 | Teller | Colorado | 8119 | 12 | 1 |
38350 | 38350 | 2020-04-07 | Unknown | Colorado | 249 | 0 | |
38351 | 38351 | 2020-04-07 | Washington | Colorado | 8121 | 1 | 0 |
38352 | 38352 | 2020-04-07 | Weld | Colorado | 8123 | 537 | 27 |
38353 | 38353 | 2020-04-07 | Yuma | Colorado | 8125 | 2 | 0 |
38354 | 38354 | 2020-04-07 | Fairfield | Connecticut | 9001 | 4136 | 132 |
38355 | 38355 | 2020-04-07 | Hartford | Connecticut | 9003 | 1045 | 48 |
38356 | 38356 | 2020-04-07 | Litchfield | Connecticut | 9005 | 255 | 9 |
38357 | 38357 | 2020-04-07 | Middlesex | Connecticut | 9007 | 150 | 7 |
38358 | 38358 | 2020-04-07 | New Haven | Connecticut | 9009 | 1664 | 60 |
38359 | 38359 | 2020-04-07 | New London | Connecticut | 9011 | 85 | 4 |
38360 | 38360 | 2020-04-07 | Tolland | Connecticut | 9013 | 111 | 13 |
38361 | 38361 | 2020-04-07 | Unknown | Connecticut | 292 | 3 | |
38362 | 38362 | 2020-04-07 | Windham | Connecticut | 9015 | 43 | 1 |
38363 | 38363 | 2020-04-07 | Kent | Delaware | 10001 | 147 | 3 |
38364 | 38364 | 2020-04-07 | New Castle | Delaware | 10003 | 571 | 9 |
38365 | 38365 | 2020-04-07 | Sussex | Delaware | 10005 | 210 | 4 |
38366 | 38366 | 2020-04-07 | District of Columbia | District of Columbia | 11001 | 1211 | 24 |
38367 | 38367 | 2020-04-07 | Alachua | Florida | 12001 | 139 | 0 |
38368 | 38368 | 2020-04-07 | Baker | Florida | 12003 | 15 | 1 |
38369 | 38369 | 2020-04-07 | Bay | Florida | 12005 | 25 | 1 |
38370 | 38370 | 2020-04-07 | Bradford | Florida | 12007 | 11 | 0 |
38371 | 38371 | 2020-04-07 | Brevard | Florida | 12009 | 98 | 2 |
38372 | 38372 | 2020-04-07 | Broward | Florida | 12011 | 2230 | 54 |
38373 | 38373 | 2020-04-07 | Calhoun | Florida | 12013 | 3 | 0 |
38374 | 38374 | 2020-04-07 | Charlotte | Florida | 12015 | 67 | 1 |
38375 | 38375 | 2020-04-07 | Citrus | Florida | 12017 | 51 | 2 |
38376 | 38376 | 2020-04-07 | Clay | Florida | 12019 | 88 | 7 |
38377 | 38377 | 2020-04-07 | Collier | Florida | 12021 | 271 | 3 |
38378 | 38378 | 2020-04-07 | Columbia | Florida | 12023 | 16 | 0 |
38379 | 38379 | 2020-04-07 | DeSoto | Florida | 12027 | 16 | 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);