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 44,953
- Georgia 31,289
- Virginia 25,315
- Kentucky 22,372
- Missouri 21,154
- Illinois 19,331
- North Carolina 19,308
- Tennessee 18,572
- Iowa 18,570
- Indiana 18,066
- Kansas 17,649
- Ohio 17,186
- Minnesota 16,403
- Mississippi 16,119
- Michigan 16,062
- Arkansas 14,496
- Nebraska 14,465
- Oklahoma 14,294
- Wisconsin 13,856
- Florida 13,582
- Pennsylvania 13,246
- Alabama 13,050
- Louisiana 12,878
- Puerto Rico 12,182
- Colorado 12,087
- New York 11,762
- California 11,754
- South Dakota 10,942
- West Virginia 10,061
- South Carolina 9,181
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
599400 | 599400 | 2020-10-05 | Alpine | California | 6003 | 2 | 0 |
599401 | 599401 | 2020-10-05 | Amador | California | 6005 | 296 | 16 |
599402 | 599402 | 2020-10-05 | Butte | California | 6007 | 2903 | 45 |
599403 | 599403 | 2020-10-05 | Calaveras | California | 6009 | 324 | 14 |
599404 | 599404 | 2020-10-05 | Colusa | California | 6011 | 539 | 6 |
599405 | 599405 | 2020-10-05 | Contra Costa | California | 6013 | 17322 | 213 |
599406 | 599406 | 2020-10-05 | Del Norte | California | 6015 | 152 | 1 |
599407 | 599407 | 2020-10-05 | El Dorado | California | 6017 | 1196 | 4 |
599408 | 599408 | 2020-10-05 | Fresno | California | 6019 | 29065 | 399 |
599409 | 599409 | 2020-10-05 | Glenn | California | 6021 | 601 | 3 |
599410 | 599410 | 2020-10-05 | Humboldt | California | 6023 | 522 | 8 |
599411 | 599411 | 2020-10-05 | Imperial | California | 6025 | 12076 | 325 |
599412 | 599412 | 2020-10-05 | Inyo | California | 6027 | 195 | 15 |
599413 | 599413 | 2020-10-05 | Kern | California | 6029 | 32522 | 386 |
599414 | 599414 | 2020-10-05 | Kings | California | 6031 | 7919 | 82 |
599415 | 599415 | 2020-10-05 | Lake | California | 6033 | 589 | 11 |
599416 | 599416 | 2020-10-05 | Lassen | California | 6035 | 744 | 0 |
599417 | 599417 | 2020-10-05 | Los Angeles | California | 6037 | 274942 | 6654 |
599418 | 599418 | 2020-10-05 | Madera | California | 6039 | 4706 | 70 |
599419 | 599419 | 2020-10-05 | Marin | California | 6041 | 6798 | 119 |
599420 | 599420 | 2020-10-05 | Mariposa | California | 6043 | 76 | 2 |
599421 | 599421 | 2020-10-05 | Mendocino | California | 6045 | 1010 | 20 |
599422 | 599422 | 2020-10-05 | Merced | California | 6047 | 9081 | 148 |
599423 | 599423 | 2020-10-05 | Modoc | California | 6049 | 28 | 0 |
599424 | 599424 | 2020-10-05 | Mono | California | 6051 | 169 | 2 |
599425 | 599425 | 2020-10-05 | Monterey | California | 6053 | 10402 | 75 |
599426 | 599426 | 2020-10-05 | Napa | California | 6055 | 1760 | 13 |
599427 | 599427 | 2020-10-05 | Nevada | California | 6057 | 550 | 7 |
599428 | 599428 | 2020-10-05 | Orange | California | 6059 | 56346 | 1287 |
599429 | 599429 | 2020-10-05 | Placer | California | 6061 | 3684 | 49 |
599430 | 599430 | 2020-10-05 | Plumas | California | 6063 | 49 | 0 |
599431 | 599431 | 2020-10-05 | Riverside | California | 6065 | 60738 | 1238 |
599432 | 599432 | 2020-10-05 | Sacramento | California | 6067 | 23244 | 432 |
599433 | 599433 | 2020-10-05 | San Benito | California | 6069 | 1367 | 12 |
599434 | 599434 | 2020-10-05 | San Bernardino | California | 6071 | 56400 | 962 |
599435 | 599435 | 2020-10-05 | San Diego | California | 6073 | 48723 | 803 |
599436 | 599436 | 2020-10-05 | San Francisco | California | 6075 | 11483 | 108 |
599437 | 599437 | 2020-10-05 | San Joaquin | California | 6077 | 20569 | 471 |
599438 | 599438 | 2020-10-05 | San Luis Obispo | California | 6079 | 3742 | 31 |
599439 | 599439 | 2020-10-05 | San Mateo | California | 6081 | 10275 | 152 |
599440 | 599440 | 2020-10-05 | Santa Barbara | California | 6083 | 9319 | 115 |
599441 | 599441 | 2020-10-05 | Santa Clara | California | 6085 | 21926 | 346 |
599442 | 599442 | 2020-10-05 | Santa Cruz | California | 6087 | 2519 | 12 |
599443 | 599443 | 2020-10-05 | Shasta | California | 6089 | 1158 | 22 |
599444 | 599444 | 2020-10-05 | Sierra | California | 6091 | 6 | 0 |
599445 | 599445 | 2020-10-05 | Siskiyou | California | 6093 | 171 | 0 |
599446 | 599446 | 2020-10-05 | Solano | California | 6095 | 6606 | 72 |
599447 | 599447 | 2020-10-05 | Sonoma | California | 6097 | 7940 | 122 |
599448 | 599448 | 2020-10-05 | Stanislaus | California | 6099 | 16759 | 374 |
599449 | 599449 | 2020-10-05 | Sutter | California | 6101 | 1763 | 12 |
599450 | 599450 | 2020-10-05 | Tehama | California | 6103 | 637 | 7 |
599451 | 599451 | 2020-10-05 | Trinity | California | 6105 | 22 | 0 |
599452 | 599452 | 2020-10-05 | Tulare | California | 6107 | 16490 | 265 |
599453 | 599453 | 2020-10-05 | Tuolumne | California | 6109 | 233 | 4 |
599454 | 599454 | 2020-10-05 | Ventura | California | 6111 | 13197 | 154 |
599455 | 599455 | 2020-10-05 | Yolo | California | 6113 | 2893 | 56 |
599456 | 599456 | 2020-10-05 | Yuba | California | 6115 | 1207 | 10 |
599457 | 599457 | 2020-10-05 | Adams | Colorado | 8001 | 9943 | 231 |
599458 | 599458 | 2020-10-05 | Alamosa | Colorado | 8003 | 252 | 9 |
599459 | 599459 | 2020-10-05 | Arapahoe | Colorado | 8005 | 9935 | 374 |
599460 | 599460 | 2020-10-05 | Archuleta | Colorado | 8007 | 54 | 0 |
599461 | 599461 | 2020-10-05 | Baca | Colorado | 8009 | 18 | 0 |
599462 | 599462 | 2020-10-05 | Bent | Colorado | 8011 | 11 | 0 |
599463 | 599463 | 2020-10-05 | Boulder | Colorado | 8013 | 4658 | 81 |
599464 | 599464 | 2020-10-05 | Broomfield | Colorado | 8014 | 695 | 34 |
599465 | 599465 | 2020-10-05 | Chaffee | Colorado | 8015 | 337 | 20 |
599466 | 599466 | 2020-10-05 | Cheyenne | Colorado | 8017 | 14 | 0 |
599467 | 599467 | 2020-10-05 | Clear Creek | Colorado | 8019 | 47 | 1 |
599468 | 599468 | 2020-10-05 | Conejos | Colorado | 8021 | 36 | 0 |
599469 | 599469 | 2020-10-05 | Costilla | Colorado | 8023 | 33 | 1 |
599470 | 599470 | 2020-10-05 | Crowley | Colorado | 8025 | 74 | 1 |
599471 | 599471 | 2020-10-05 | Custer | Colorado | 8027 | 18 | 0 |
599472 | 599472 | 2020-10-05 | Delta | Colorado | 8029 | 191 | 3 |
599473 | 599473 | 2020-10-05 | Denver | Colorado | 8031 | 13956 | 447 |
599474 | 599474 | 2020-10-05 | Dolores | Colorado | 8033 | 3 | 0 |
599475 | 599475 | 2020-10-05 | Douglas | Colorado | 8035 | 2947 | 61 |
599476 | 599476 | 2020-10-05 | Eagle | Colorado | 8037 | 1275 | 10 |
599477 | 599477 | 2020-10-05 | El Paso | Colorado | 8041 | 7265 | 179 |
599478 | 599478 | 2020-10-05 | Elbert | Colorado | 8039 | 168 | 3 |
599479 | 599479 | 2020-10-05 | Fremont | Colorado | 8043 | 185 | 1 |
599480 | 599480 | 2020-10-05 | Garfield | Colorado | 8045 | 972 | 5 |
599481 | 599481 | 2020-10-05 | Gilpin | Colorado | 8047 | 19 | 0 |
599482 | 599482 | 2020-10-05 | Grand | Colorado | 8049 | 96 | 1 |
599483 | 599483 | 2020-10-05 | Gunnison | Colorado | 8051 | 296 | 7 |
599484 | 599484 | 2020-10-05 | Hinsdale | Colorado | 8053 | 3 | 0 |
599485 | 599485 | 2020-10-05 | Huerfano | Colorado | 8055 | 25 | 1 |
599486 | 599486 | 2020-10-05 | Jackson | Colorado | 8057 | 9 | 0 |
599487 | 599487 | 2020-10-05 | Jefferson | Colorado | 8059 | 6095 | 255 |
599488 | 599488 | 2020-10-05 | Kiowa | Colorado | 8061 | 1 | 0 |
599489 | 599489 | 2020-10-05 | Kit Carson | Colorado | 8063 | 81 | 3 |
599490 | 599490 | 2020-10-05 | La Plata | Colorado | 8067 | 268 | 2 |
599491 | 599491 | 2020-10-05 | Lake | Colorado | 8065 | 99 | 0 |
599492 | 599492 | 2020-10-05 | Larimer | Colorado | 8069 | 2775 | 55 |
599493 | 599493 | 2020-10-05 | Las Animas | Colorado | 8071 | 25 | 0 |
599494 | 599494 | 2020-10-05 | Lincoln | Colorado | 8073 | 20 | 0 |
599495 | 599495 | 2020-10-05 | Logan | Colorado | 8075 | 943 | 6 |
599496 | 599496 | 2020-10-05 | Mesa | Colorado | 8077 | 712 | 7 |
599497 | 599497 | 2020-10-05 | Mineral | Colorado | 8079 | 20 | 0 |
599498 | 599498 | 2020-10-05 | Moffat | Colorado | 8081 | 44 | 1 |
599499 | 599499 | 2020-10-05 | Montezuma | Colorado | 8083 | 147 | 5 |
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);