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 56,334
- Georgia 38,489
- Virginia 31,300
- Kentucky 27,772
- Missouri 26,419
- Illinois 23,952
- North Carolina 23,808
- Iowa 23,070
- Tennessee 22,879
- Kansas 22,409
- Indiana 22,206
- Ohio 21,146
- Minnesota 20,363
- Michigan 19,842
- Mississippi 19,810
- Nebraska 18,676
- Arkansas 17,916
- Oklahoma 17,804
- Wisconsin 17,111
- Florida 16,642
- Pennsylvania 16,261
- Alabama 16,065
- Louisiana 15,803
- Puerto Rico 15,737
- Colorado 14,967
- New York 14,372
- California 14,324
- South Dakota 13,912
- West Virginia 12,536
- North Dakota 11,340
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
745415 | 745415 | 2020-11-19 | Santa Barbara | California | 6083 | 10768 | 133 |
745416 | 745416 | 2020-11-19 | Santa Clara | California | 6085 | 29631 | 460 |
745417 | 745417 | 2020-11-19 | Santa Cruz | California | 6087 | 3685 | 27 |
745418 | 745418 | 2020-11-19 | Shasta | California | 6089 | 3570 | 37 |
745419 | 745419 | 2020-11-19 | Sierra | California | 6091 | 11 | 0 |
745420 | 745420 | 2020-11-19 | Siskiyou | California | 6093 | 466 | 1 |
745421 | 745421 | 2020-11-19 | Solano | California | 6095 | 9296 | 80 |
745422 | 745422 | 2020-11-19 | Sonoma | California | 6097 | 11316 | 150 |
745423 | 745423 | 2020-11-19 | Stanislaus | California | 6099 | 20926 | 415 |
745424 | 745424 | 2020-11-19 | Sutter | California | 6101 | 2601 | 13 |
745425 | 745425 | 2020-11-19 | Tehama | California | 6103 | 1338 | 19 |
745426 | 745426 | 2020-11-19 | Trinity | California | 6105 | 96 | 0 |
745427 | 745427 | 2020-11-19 | Tulare | California | 6107 | 19553 | 303 |
745428 | 745428 | 2020-11-19 | Tuolumne | California | 6109 | 675 | 8 |
745429 | 745429 | 2020-11-19 | Ventura | California | 6111 | 17169 | 174 |
745430 | 745430 | 2020-11-19 | Yolo | California | 6113 | 3981 | 72 |
745431 | 745431 | 2020-11-19 | Yuba | California | 6115 | 1706 | 10 |
745432 | 745432 | 2020-11-19 | Adams | Colorado | 8001 | 24504 | 302 |
745433 | 745433 | 2020-11-19 | Alamosa | Colorado | 8003 | 488 | 11 |
745434 | 745434 | 2020-11-19 | Arapahoe | Colorado | 8005 | 22200 | 425 |
745435 | 745435 | 2020-11-19 | Archuleta | Colorado | 8007 | 120 | 0 |
745436 | 745436 | 2020-11-19 | Baca | Colorado | 8009 | 52 | 0 |
745437 | 745437 | 2020-11-19 | Bent | Colorado | 8011 | 46 | 0 |
745438 | 745438 | 2020-11-19 | Boulder | Colorado | 8013 | 9362 | 112 |
745439 | 745439 | 2020-11-19 | Broomfield | Colorado | 8014 | 1656 | 48 |
745440 | 745440 | 2020-11-19 | Chaffee | Colorado | 8015 | 518 | 21 |
745441 | 745441 | 2020-11-19 | Cheyenne | Colorado | 8017 | 41 | 0 |
745442 | 745442 | 2020-11-19 | Clear Creek | Colorado | 8019 | 157 | 1 |
745443 | 745443 | 2020-11-19 | Conejos | Colorado | 8021 | 139 | 2 |
745444 | 745444 | 2020-11-19 | Costilla | Colorado | 8023 | 63 | 1 |
745445 | 745445 | 2020-11-19 | Crowley | Colorado | 8025 | 796 | 1 |
745446 | 745446 | 2020-11-19 | Custer | Colorado | 8027 | 54 | 0 |
745447 | 745447 | 2020-11-19 | Delta | Colorado | 8029 | 417 | 7 |
745448 | 745448 | 2020-11-19 | Denver | Colorado | 8031 | 30631 | 493 |
745449 | 745449 | 2020-11-19 | Dolores | Colorado | 8033 | 7 | 0 |
745450 | 745450 | 2020-11-19 | Douglas | Colorado | 8035 | 8321 | 94 |
745451 | 745451 | 2020-11-19 | Eagle | Colorado | 8037 | 1987 | 11 |
745452 | 745452 | 2020-11-19 | El Paso | Colorado | 8041 | 21110 | 243 |
745453 | 745453 | 2020-11-19 | Elbert | Colorado | 8039 | 447 | 5 |
745454 | 745454 | 2020-11-19 | Fremont | Colorado | 8043 | 1875 | 2 |
745455 | 745455 | 2020-11-19 | Garfield | Colorado | 8045 | 1744 | 6 |
745456 | 745456 | 2020-11-19 | Gilpin | Colorado | 8047 | 73 | 0 |
745457 | 745457 | 2020-11-19 | Grand | Colorado | 8049 | 251 | 1 |
745458 | 745458 | 2020-11-19 | Gunnison | Colorado | 8051 | 428 | 7 |
745459 | 745459 | 2020-11-19 | Hinsdale | Colorado | 8053 | 6 | 0 |
745460 | 745460 | 2020-11-19 | Huerfano | Colorado | 8055 | 98 | 4 |
745461 | 745461 | 2020-11-19 | Jackson | Colorado | 8057 | 14 | 0 |
745462 | 745462 | 2020-11-19 | Jefferson | Colorado | 8059 | 16299 | 404 |
745463 | 745463 | 2020-11-19 | Kiowa | Colorado | 8061 | 18 | 0 |
745464 | 745464 | 2020-11-19 | Kit Carson | Colorado | 8063 | 242 | 3 |
745465 | 745465 | 2020-11-19 | La Plata | Colorado | 8067 | 710 | 3 |
745466 | 745466 | 2020-11-19 | Lake | Colorado | 8065 | 221 | 0 |
745467 | 745467 | 2020-11-19 | Larimer | Colorado | 8069 | 7937 | 65 |
745468 | 745468 | 2020-11-19 | Las Animas | Colorado | 8071 | 143 | 0 |
745469 | 745469 | 2020-11-19 | Lincoln | Colorado | 8073 | 102 | 0 |
745470 | 745470 | 2020-11-19 | Logan | Colorado | 8075 | 1903 | 25 |
745471 | 745471 | 2020-11-19 | Mesa | Colorado | 8077 | 4354 | 48 |
745472 | 745472 | 2020-11-19 | Mineral | Colorado | 8079 | 21 | 0 |
745473 | 745473 | 2020-11-19 | Moffat | Colorado | 8081 | 192 | 2 |
745474 | 745474 | 2020-11-19 | Montezuma | Colorado | 8083 | 483 | 6 |
745475 | 745475 | 2020-11-19 | Montrose | Colorado | 8085 | 714 | 15 |
745476 | 745476 | 2020-11-19 | Morgan | Colorado | 8087 | 1357 | 51 |
745477 | 745477 | 2020-11-19 | Otero | Colorado | 8089 | 363 | 8 |
745478 | 745478 | 2020-11-19 | Ouray | Colorado | 8091 | 104 | 2 |
745479 | 745479 | 2020-11-19 | Park | Colorado | 8093 | 186 | 3 |
745480 | 745480 | 2020-11-19 | Phillips | Colorado | 8095 | 145 | 1 |
745481 | 745481 | 2020-11-19 | Pitkin | Colorado | 8097 | 413 | 2 |
745482 | 745482 | 2020-11-19 | Prowers | Colorado | 8099 | 410 | 11 |
745483 | 745483 | 2020-11-19 | Pueblo | Colorado | 8101 | 5736 | 80 |
745484 | 745484 | 2020-11-19 | Rio Blanco | Colorado | 8103 | 80 | 0 |
745485 | 745485 | 2020-11-19 | Rio Grande | Colorado | 8105 | 185 | 4 |
745486 | 745486 | 2020-11-19 | Routt | Colorado | 8107 | 472 | 9 |
745487 | 745487 | 2020-11-19 | Saguache | Colorado | 8109 | 195 | 2 |
745488 | 745488 | 2020-11-19 | San Juan | Colorado | 8111 | 19 | 0 |
745489 | 745489 | 2020-11-19 | San Miguel | Colorado | 8113 | 173 | 0 |
745490 | 745490 | 2020-11-19 | Sedgwick | Colorado | 8115 | 91 | 1 |
745491 | 745491 | 2020-11-19 | Summit | Colorado | 8117 | 1230 | 4 |
745492 | 745492 | 2020-11-19 | Teller | Colorado | 8119 | 483 | 4 |
745493 | 745493 | 2020-11-19 | Washington | Colorado | 8121 | 173 | 5 |
745494 | 745494 | 2020-11-19 | Weld | Colorado | 8123 | 11218 | 178 |
745495 | 745495 | 2020-11-19 | Yuma | Colorado | 8125 | 283 | 1 |
745496 | 745496 | 2020-11-19 | Fairfield | Connecticut | 9001 | 33067 | 1466 |
745497 | 745497 | 2020-11-19 | Hartford | Connecticut | 9003 | 24706 | 1548 |
745498 | 745498 | 2020-11-19 | Litchfield | Connecticut | 9005 | 3500 | 156 |
745499 | 745499 | 2020-11-19 | Middlesex | Connecticut | 9007 | 3025 | 197 |
745500 | 745500 | 2020-11-19 | New Haven | Connecticut | 9009 | 24733 | 1180 |
745501 | 745501 | 2020-11-19 | New London | Connecticut | 9011 | 5256 | 162 |
745502 | 745502 | 2020-11-19 | Tolland | Connecticut | 9013 | 2573 | 71 |
745503 | 745503 | 2020-11-19 | Unknown | Connecticut | 403 | 0 | |
745504 | 745504 | 2020-11-19 | Windham | Connecticut | 9015 | 2118 | 25 |
745505 | 745505 | 2020-11-19 | Kent | Delaware | 10001 | 4225 | 122 |
745506 | 745506 | 2020-11-19 | New Castle | Delaware | 10003 | 16490 | 369 |
745507 | 745507 | 2020-11-19 | Sussex | Delaware | 10005 | 9341 | 251 |
745508 | 745508 | 2020-11-19 | Unknown | Delaware | 97 | 0 | |
745509 | 745509 | 2020-11-19 | District of Columbia | District of Columbia | 11001 | 19678 | 667 |
745510 | 745510 | 2020-11-19 | Alachua | Florida | 12001 | 12113 | 91 |
745511 | 745511 | 2020-11-19 | Baker | Florida | 12003 | 1941 | 29 |
745512 | 745512 | 2020-11-19 | Bay | Florida | 12005 | 7912 | 146 |
745513 | 745513 | 2020-11-19 | Bradford | Florida | 12007 | 1344 | 16 |
745514 | 745514 | 2020-11-19 | Brevard | Florida | 12009 | 14112 | 418 |
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);