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
- Texas 163,014
- Georgia 105,689
- Virginia 87,162
- Kentucky 78,172
- Missouri 75,560
- Illinois 67,142
- Kansas 66,658
- North Carolina 65,809
- Iowa 65,070
- Tennessee 63,199
- Indiana 60,846
- Ohio 58,421
- Nebraska 57,975
- Minnesota 57,323
- Michigan 55,122
- Mississippi 54,250
- Oklahoma 50,563
- Arkansas 49,836
- Puerto Rico 48,917
- Wisconsin 47,353
- Florida 45,202
- Pennsylvania 44,401
- Alabama 44,205
- Louisiana 43,102
- Colorado 41,847
- South Dakota 41,632
- New York 38,732
- California 38,720
- West Virginia 35,638
- North Dakota 34,019
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109328 | 2109328 | 2022-01-13 | Imperial | California | 6025 | 47613 | 813 |
2109329 | 2109329 | 2022-01-13 | Inyo | California | 6027 | 3407 | 49 |
2109330 | 2109330 | 2022-01-13 | Kern | California | 6029 | 179110 | 1958 |
2109331 | 2109331 | 2022-01-13 | Kings | California | 6031 | 39230 | 391 |
2109332 | 2109332 | 2022-01-13 | Lake | California | 6033 | 7861 | 117 |
2109333 | 2109333 | 2022-01-13 | Lassen | California | 6035 | 8535 | 61 |
2109334 | 2109334 | 2022-01-13 | Los Angeles | California | 6037 | 2132227 | 27985 |
2109335 | 2109335 | 2022-01-13 | Madera | California | 6039 | 29794 | 329 |
2109336 | 2109336 | 2022-01-13 | Marin | California | 6041 | 26028 | 251 |
2109337 | 2109337 | 2022-01-13 | Mariposa | California | 6043 | 2081 | 18 |
2109338 | 2109338 | 2022-01-13 | Mendocino | California | 6045 | 10417 | 109 |
2109339 | 2109339 | 2022-01-13 | Merced | California | 6047 | 52218 | 720 |
2109340 | 2109340 | 2022-01-13 | Modoc | California | 6049 | 1199 | 11 |
2109341 | 2109341 | 2022-01-13 | Mono | California | 6051 | 2552 | 4 |
2109342 | 2109342 | 2022-01-13 | Monterey | California | 6053 | 62561 | 653 |
2109343 | 2109343 | 2022-01-13 | Napa | California | 6055 | 17646 | 109 |
2109344 | 2109344 | 2022-01-13 | Nevada | California | 6057 | 12089 | 111 |
2109345 | 2109345 | 2022-01-13 | Orange | California | 6059 | 451612 | 5916 |
2109346 | 2109346 | 2022-01-13 | Placer | California | 6061 | 51997 | 501 |
2109347 | 2109347 | 2022-01-13 | Plumas | California | 6063 | 2232 | 12 |
2109348 | 2109348 | 2022-01-13 | Riverside | California | 6065 | 478326 | 5661 |
2109349 | 2109349 | 2022-01-13 | Sacramento | California | 6067 | 216000 | 2582 |
2109350 | 2109350 | 2022-01-13 | San Benito | California | 6069 | 10046 | 87 |
2109351 | 2109351 | 2022-01-13 | San Bernardino | California | 6071 | 463256 | 6222 |
2109352 | 2109352 | 2022-01-13 | San Diego | California | 6073 | 587767 | 4529 |
2109353 | 2109353 | 2022-01-13 | San Francisco | California | 6075 | 92571 | 691 |
2109354 | 2109354 | 2022-01-13 | San Joaquin | California | 6077 | 129868 | 1948 |
2109355 | 2109355 | 2022-01-13 | San Luis Obispo | California | 6079 | 39929 | 373 |
2109356 | 2109356 | 2022-01-13 | San Mateo | California | 6081 | 85171 | 638 |
2109357 | 2109357 | 2022-01-13 | Santa Barbara | California | 6083 | 63270 | 578 |
2109358 | 2109358 | 2022-01-13 | Santa Clara | California | 6085 | 218660 | 1972 |
2109359 | 2109359 | 2022-01-13 | Santa Cruz | California | 6087 | 29900 | 235 |
2109360 | 2109360 | 2022-01-13 | Shasta | California | 6089 | 28544 | 502 |
2109361 | 2109361 | 2022-01-13 | Sierra | California | 6091 | 253 | 0 |
2109362 | 2109362 | 2022-01-13 | Siskiyou | California | 6093 | 5337 | 81 |
2109363 | 2109363 | 2022-01-13 | Solano | California | 6095 | 59459 | 386 |
2109364 | 2109364 | 2022-01-13 | Sonoma | California | 6097 | 57381 | 422 |
2109365 | 2109365 | 2022-01-13 | Stanislaus | California | 6099 | 105299 | 1503 |
2109366 | 2109366 | 2022-01-13 | Sutter | California | 6101 | 16944 | 204 |
2109367 | 2109367 | 2022-01-13 | Tehama | California | 6103 | 11315 | 141 |
2109368 | 2109368 | 2022-01-13 | Trinity | California | 6105 | 1092 | 19 |
2109369 | 2109369 | 2022-01-13 | Tulare | California | 6107 | 96787 | 1192 |
2109370 | 2109370 | 2022-01-13 | Tuolumne | California | 6109 | 9266 | 152 |
2109371 | 2109371 | 2022-01-13 | Ventura | California | 6111 | 138203 | 1222 |
2109372 | 2109372 | 2022-01-13 | Yolo | California | 6113 | 28837 | 270 |
2109373 | 2109373 | 2022-01-13 | Yuba | California | 6115 | 12811 | 101 |
2109374 | 2109374 | 2022-01-13 | Adams | Colorado | 8001 | 111905 | 1137 |
2109375 | 2109375 | 2022-01-13 | Alamosa | Colorado | 8003 | 3404 | 58 |
2109376 | 2109376 | 2022-01-13 | Arapahoe | Colorado | 8005 | 125573 | 1107 |
2109377 | 2109377 | 2022-01-13 | Archuleta | Colorado | 8007 | 2342 | 9 |
2109378 | 2109378 | 2022-01-13 | Baca | Colorado | 8009 | 610 | 8 |
2109379 | 2109379 | 2022-01-13 | Bent | Colorado | 8011 | 2003 | 45 |
2109380 | 2109380 | 2022-01-13 | Boulder | Colorado | 8013 | 48602 | 333 |
2109381 | 2109381 | 2022-01-13 | Broomfield | Colorado | 8014 | 10493 | 99 |
2109382 | 2109382 | 2022-01-13 | Chaffee | Colorado | 8015 | 3520 | 38 |
2109383 | 2109383 | 2022-01-13 | Cheyenne | Colorado | 8017 | 268 | 9 |
2109384 | 2109384 | 2022-01-13 | Clear Creek | Colorado | 8019 | 1227 | 10 |
2109385 | 2109385 | 2022-01-13 | Conejos | Colorado | 8021 | 1298 | 48 |
2109386 | 2109386 | 2022-01-13 | Costilla | Colorado | 8023 | 508 | 14 |
2109387 | 2109387 | 2022-01-13 | Crowley | Colorado | 8025 | 2597 | 27 |
2109388 | 2109388 | 2022-01-13 | Custer | Colorado | 8027 | 525 | 16 |
2109389 | 2109389 | 2022-01-13 | Delta | Colorado | 8029 | 4938 | 124 |
2109390 | 2109390 | 2022-01-13 | Denver | Colorado | 8031 | 140752 | 1117 |
2109391 | 2109391 | 2022-01-13 | Dolores | Colorado | 8033 | 297 | 6 |
2109392 | 2109392 | 2022-01-13 | Douglas | Colorado | 8035 | 63077 | 382 |
2109393 | 2109393 | 2022-01-13 | Eagle | Colorado | 8037 | 13794 | 32 |
2109394 | 2109394 | 2022-01-13 | El Paso | Colorado | 8041 | 146181 | 1456 |
2109395 | 2109395 | 2022-01-13 | Elbert | Colorado | 8039 | 3861 | 31 |
2109396 | 2109396 | 2022-01-13 | Fremont | Colorado | 8043 | 11304 | 163 |
2109397 | 2109397 | 2022-01-13 | Garfield | Colorado | 8045 | 11675 | 80 |
2109398 | 2109398 | 2022-01-13 | Gilpin | Colorado | 8047 | 758 | 4 |
2109399 | 2109399 | 2022-01-13 | Grand | Colorado | 8049 | 2995 | 20 |
2109400 | 2109400 | 2022-01-13 | Gunnison | Colorado | 8051 | 2685 | 13 |
2109401 | 2109401 | 2022-01-13 | Hinsdale | Colorado | 8053 | 94 | 0 |
2109402 | 2109402 | 2022-01-13 | Huerfano | Colorado | 8055 | 1050 | 28 |
2109403 | 2109403 | 2022-01-13 | Jackson | Colorado | 8057 | 132 | 0 |
2109404 | 2109404 | 2022-01-13 | Jefferson | Colorado | 8059 | 98226 | 1138 |
2109405 | 2109405 | 2022-01-13 | Kiowa | Colorado | 8061 | 293 | 4 |
2109406 | 2109406 | 2022-01-13 | Kit Carson | Colorado | 8063 | 1366 | 28 |
2109407 | 2109407 | 2022-01-13 | La Plata | Colorado | 8067 | 9639 | 68 |
2109408 | 2109408 | 2022-01-13 | Lake | Colorado | 8065 | 1564 | 2 |
2109409 | 2109409 | 2022-01-13 | Larimer | Colorado | 8069 | 58661 | 410 |
2109410 | 2109410 | 2022-01-13 | Las Animas | Colorado | 8071 | 2686 | 35 |
2109411 | 2109411 | 2022-01-13 | Lincoln | Colorado | 8073 | 1643 | 9 |
2109412 | 2109412 | 2022-01-13 | Logan | Colorado | 8075 | 5642 | 98 |
2109413 | 2109413 | 2022-01-13 | Mesa | Colorado | 8077 | 32998 | 481 |
2109414 | 2109414 | 2022-01-13 | Mineral | Colorado | 8079 | 169 | 1 |
2109415 | 2109415 | 2022-01-13 | Moffat | Colorado | 8081 | 2455 | 49 |
2109416 | 2109416 | 2022-01-13 | Montezuma | Colorado | 8083 | 4598 | 58 |
2109417 | 2109417 | 2022-01-13 | Montrose | Colorado | 8085 | 7544 | 149 |
2109418 | 2109418 | 2022-01-13 | Morgan | Colorado | 8087 | 4632 | 128 |
2109419 | 2109419 | 2022-01-13 | Otero | Colorado | 8089 | 3544 | 118 |
2109420 | 2109420 | 2022-01-13 | Ouray | Colorado | 8091 | 718 | 6 |
2109421 | 2109421 | 2022-01-13 | Park | Colorado | 8093 | 2336 | 16 |
2109422 | 2109422 | 2022-01-13 | Phillips | Colorado | 8095 | 666 | 15 |
2109423 | 2109423 | 2022-01-13 | Pitkin | Colorado | 8097 | 5454 | 6 |
2109424 | 2109424 | 2022-01-13 | Prowers | Colorado | 8099 | 2153 | 44 |
2109425 | 2109425 | 2022-01-13 | Pueblo | Colorado | 8101 | 35565 | 695 |
2109426 | 2109426 | 2022-01-13 | Rio Blanco | Colorado | 8103 | 1357 | 13 |
2109427 | 2109427 | 2022-01-13 | Rio Grande | Colorado | 8105 | 2152 | 41 |
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);