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 58,366
- Georgia 39,769
- Virginia 32,364
- Kentucky 28,732
- Missouri 27,355
- Illinois 24,768
- North Carolina 24,608
- Iowa 23,870
- Tennessee 23,647
- Kansas 23,257
- Indiana 22,942
- Ohio 21,850
- Minnesota 21,067
- Michigan 20,514
- Mississippi 20,466
- Nebraska 19,421
- Arkansas 18,524
- Oklahoma 18,428
- Wisconsin 17,687
- Florida 17,186
- Pennsylvania 16,797
- Alabama 16,601
- Puerto Rico 16,369
- Louisiana 16,323
- Colorado 15,479
- New York 14,836
- California 14,791
- South Dakota 14,440
- West Virginia 12,976
- North Dakota 11,772
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
771378 | 771378 | 2020-11-27 | San Joaquin | California | 6077 | 25738 | 502 |
771379 | 771379 | 2020-11-27 | San Luis Obispo | California | 6079 | 6129 | 36 |
771380 | 771380 | 2020-11-27 | San Mateo | California | 6081 | 13715 | 170 |
771381 | 771381 | 2020-11-27 | Santa Barbara | California | 6083 | 11277 | 135 |
771382 | 771382 | 2020-11-27 | Santa Clara | California | 6085 | 32985 | 477 |
771383 | 771383 | 2020-11-27 | Santa Cruz | California | 6087 | 4269 | 28 |
771384 | 771384 | 2020-11-27 | Shasta | California | 6089 | 4718 | 47 |
771385 | 771385 | 2020-11-27 | Sierra | California | 6091 | 15 | 0 |
771386 | 771386 | 2020-11-27 | Siskiyou | California | 6093 | 624 | 2 |
771387 | 771387 | 2020-11-27 | Solano | California | 6095 | 10041 | 81 |
771388 | 771388 | 2020-11-27 | Sonoma | California | 6097 | 12049 | 157 |
771389 | 771389 | 2020-11-27 | Stanislaus | California | 6099 | 22829 | 424 |
771390 | 771390 | 2020-11-27 | Sutter | California | 6101 | 3144 | 15 |
771391 | 771391 | 2020-11-27 | Tehama | California | 6103 | 1612 | 25 |
771392 | 771392 | 2020-11-27 | Trinity | California | 6105 | 140 | 0 |
771393 | 771393 | 2020-11-27 | Tulare | California | 6107 | 20649 | 308 |
771394 | 771394 | 2020-11-27 | Tuolumne | California | 6109 | 981 | 8 |
771395 | 771395 | 2020-11-27 | Ventura | California | 6111 | 19058 | 175 |
771396 | 771396 | 2020-11-27 | Yolo | California | 6113 | 4626 | 75 |
771397 | 771397 | 2020-11-27 | Yuba | California | 6115 | 1981 | 10 |
771398 | 771398 | 2020-11-27 | Adams | Colorado | 8001 | 28413 | 331 |
771399 | 771399 | 2020-11-27 | Alamosa | Colorado | 8003 | 588 | 13 |
771400 | 771400 | 2020-11-27 | Arapahoe | Colorado | 8005 | 26177 | 453 |
771401 | 771401 | 2020-11-27 | Archuleta | Colorado | 8007 | 224 | 0 |
771402 | 771402 | 2020-11-27 | Baca | Colorado | 8009 | 102 | 0 |
771403 | 771403 | 2020-11-27 | Bent | Colorado | 8011 | 147 | 1 |
771404 | 771404 | 2020-11-27 | Boulder | Colorado | 8013 | 10728 | 118 |
771405 | 771405 | 2020-11-27 | Broomfield | Colorado | 8014 | 1954 | 49 |
771406 | 771406 | 2020-11-27 | Chaffee | Colorado | 8015 | 611 | 21 |
771407 | 771407 | 2020-11-27 | Cheyenne | Colorado | 8017 | 57 | 0 |
771408 | 771408 | 2020-11-27 | Clear Creek | Colorado | 8019 | 184 | 2 |
771409 | 771409 | 2020-11-27 | Conejos | Colorado | 8021 | 165 | 3 |
771410 | 771410 | 2020-11-27 | Costilla | Colorado | 8023 | 84 | 1 |
771411 | 771411 | 2020-11-27 | Crowley | Colorado | 8025 | 1149 | 3 |
771412 | 771412 | 2020-11-27 | Custer | Colorado | 8027 | 67 | 0 |
771413 | 771413 | 2020-11-27 | Delta | Colorado | 8029 | 571 | 9 |
771414 | 771414 | 2020-11-27 | Denver | Colorado | 8031 | 35787 | 523 |
771415 | 771415 | 2020-11-27 | Dolores | Colorado | 8033 | 14 | 0 |
771416 | 771416 | 2020-11-27 | Douglas | Colorado | 8035 | 10391 | 100 |
771417 | 771417 | 2020-11-27 | Eagle | Colorado | 8037 | 2272 | 11 |
771418 | 771418 | 2020-11-27 | El Paso | Colorado | 8041 | 25946 | 267 |
771419 | 771419 | 2020-11-27 | Elbert | Colorado | 8039 | 570 | 5 |
771420 | 771420 | 2020-11-27 | Fremont | Colorado | 8043 | 2593 | 5 |
771421 | 771421 | 2020-11-27 | Garfield | Colorado | 8045 | 2098 | 6 |
771422 | 771422 | 2020-11-27 | Gilpin | Colorado | 8047 | 80 | 0 |
771423 | 771423 | 2020-11-27 | Grand | Colorado | 8049 | 376 | 1 |
771424 | 771424 | 2020-11-27 | Gunnison | Colorado | 8051 | 461 | 7 |
771425 | 771425 | 2020-11-27 | Hinsdale | Colorado | 8053 | 9 | 0 |
771426 | 771426 | 2020-11-27 | Huerfano | Colorado | 8055 | 149 | 4 |
771427 | 771427 | 2020-11-27 | Jackson | Colorado | 8057 | 21 | 0 |
771428 | 771428 | 2020-11-27 | Jefferson | Colorado | 8059 | 19704 | 436 |
771429 | 771429 | 2020-11-27 | Kiowa | Colorado | 8061 | 22 | 0 |
771430 | 771430 | 2020-11-27 | Kit Carson | Colorado | 8063 | 298 | 7 |
771431 | 771431 | 2020-11-27 | La Plata | Colorado | 8067 | 1253 | 4 |
771432 | 771432 | 2020-11-27 | Lake | Colorado | 8065 | 267 | 0 |
771433 | 771433 | 2020-11-27 | Larimer | Colorado | 8069 | 9726 | 74 |
771434 | 771434 | 2020-11-27 | Las Animas | Colorado | 8071 | 206 | 0 |
771435 | 771435 | 2020-11-27 | Lincoln | Colorado | 8073 | 136 | 0 |
771436 | 771436 | 2020-11-27 | Logan | Colorado | 8075 | 2202 | 33 |
771437 | 771437 | 2020-11-27 | Mesa | Colorado | 8077 | 5501 | 56 |
771438 | 771438 | 2020-11-27 | Mineral | Colorado | 8079 | 35 | 0 |
771439 | 771439 | 2020-11-27 | Moffat | Colorado | 8081 | 273 | 4 |
771440 | 771440 | 2020-11-27 | Montezuma | Colorado | 8083 | 669 | 7 |
771441 | 771441 | 2020-11-27 | Montrose | Colorado | 8085 | 999 | 15 |
771442 | 771442 | 2020-11-27 | Morgan | Colorado | 8087 | 1596 | 52 |
771443 | 771443 | 2020-11-27 | Otero | Colorado | 8089 | 551 | 11 |
771444 | 771444 | 2020-11-27 | Ouray | Colorado | 8091 | 117 | 2 |
771445 | 771445 | 2020-11-27 | Park | Colorado | 8093 | 228 | 4 |
771446 | 771446 | 2020-11-27 | Phillips | Colorado | 8095 | 180 | 2 |
771447 | 771447 | 2020-11-27 | Pitkin | Colorado | 8097 | 467 | 2 |
771448 | 771448 | 2020-11-27 | Prowers | Colorado | 8099 | 580 | 12 |
771449 | 771449 | 2020-11-27 | Pueblo | Colorado | 8101 | 7860 | 115 |
771450 | 771450 | 2020-11-27 | Rio Blanco | Colorado | 8103 | 140 | 1 |
771451 | 771451 | 2020-11-27 | Rio Grande | Colorado | 8105 | 224 | 4 |
771452 | 771452 | 2020-11-27 | Routt | Colorado | 8107 | 640 | 11 |
771453 | 771453 | 2020-11-27 | Saguache | Colorado | 8109 | 212 | 2 |
771454 | 771454 | 2020-11-27 | San Juan | Colorado | 8111 | 20 | 0 |
771455 | 771455 | 2020-11-27 | San Miguel | Colorado | 8113 | 192 | 0 |
771456 | 771456 | 2020-11-27 | Sedgwick | Colorado | 8115 | 107 | 2 |
771457 | 771457 | 2020-11-27 | Summit | Colorado | 8117 | 1451 | 4 |
771458 | 771458 | 2020-11-27 | Teller | Colorado | 8119 | 599 | 4 |
771459 | 771459 | 2020-11-27 | Washington | Colorado | 8121 | 206 | 6 |
771460 | 771460 | 2020-11-27 | Weld | Colorado | 8123 | 13579 | 193 |
771461 | 771461 | 2020-11-27 | Yuma | Colorado | 8125 | 316 | 2 |
771462 | 771462 | 2020-11-27 | Fairfield | Connecticut | 9001 | 37071 | 1491 |
771463 | 771463 | 2020-11-27 | Hartford | Connecticut | 9003 | 27844 | 1595 |
771464 | 771464 | 2020-11-27 | Litchfield | Connecticut | 9005 | 4231 | 161 |
771465 | 771465 | 2020-11-27 | Middlesex | Connecticut | 9007 | 3567 | 206 |
771466 | 771466 | 2020-11-27 | New Haven | Connecticut | 9009 | 27925 | 1238 |
771467 | 771467 | 2020-11-27 | New London | Connecticut | 9011 | 5867 | 168 |
771468 | 771468 | 2020-11-27 | Tolland | Connecticut | 9013 | 2977 | 74 |
771469 | 771469 | 2020-11-27 | Unknown | Connecticut | 631 | 0 | |
771470 | 771470 | 2020-11-27 | Windham | Connecticut | 9015 | 2468 | 28 |
771471 | 771471 | 2020-11-27 | Kent | Delaware | 10001 | 4798 | 128 |
771472 | 771472 | 2020-11-27 | New Castle | Delaware | 10003 | 19088 | 376 |
771473 | 771473 | 2020-11-27 | Sussex | Delaware | 10005 | 10175 | 259 |
771474 | 771474 | 2020-11-27 | Unknown | Delaware | 109 | 0 | |
771475 | 771475 | 2020-11-27 | District of Columbia | District of Columbia | 11001 | 20937 | 677 |
771476 | 771476 | 2020-11-27 | Alachua | Florida | 12001 | 12704 | 99 |
771477 | 771477 | 2020-11-27 | Baker | Florida | 12003 | 2003 | 32 |
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);