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 47,982
- Georgia 33,209
- Virginia 26,911
- Kentucky 23,812
- Missouri 22,558
- Illinois 20,567
- North Carolina 20,508
- Iowa 19,770
- Tennessee 19,723
- Indiana 19,170
- Kansas 18,915
- Ohio 18,242
- Minnesota 17,459
- Mississippi 17,103
- Michigan 17,070
- Nebraska 15,592
- Arkansas 15,408
- Oklahoma 15,230
- Wisconsin 14,732
- Florida 14,398
- Pennsylvania 14,050
- Alabama 13,854
- Louisiana 13,658
- Puerto Rico 13,130
- Colorado 12,855
- New York 12,458
- California 12,395
- South Dakota 11,734
- West Virginia 10,721
- South Carolina 9,733
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
638372 | 638372 | 2020-10-17 | Yolo | California | 6113 | 3046 | 56 |
638373 | 638373 | 2020-10-17 | Yuba | California | 6115 | 1253 | 10 |
638374 | 638374 | 2020-10-17 | Adams | Colorado | 8001 | 11698 | 248 |
638375 | 638375 | 2020-10-17 | Alamosa | Colorado | 8003 | 282 | 9 |
638376 | 638376 | 2020-10-17 | Arapahoe | Colorado | 8005 | 11148 | 390 |
638377 | 638377 | 2020-10-17 | Archuleta | Colorado | 8007 | 59 | 0 |
638378 | 638378 | 2020-10-17 | Baca | Colorado | 8009 | 23 | 0 |
638379 | 638379 | 2020-10-17 | Bent | Colorado | 8011 | 12 | 0 |
638380 | 638380 | 2020-10-17 | Boulder | Colorado | 8013 | 5043 | 84 |
638381 | 638381 | 2020-10-17 | Broomfield | Colorado | 8014 | 778 | 39 |
638382 | 638382 | 2020-10-17 | Chaffee | Colorado | 8015 | 369 | 20 |
638383 | 638383 | 2020-10-17 | Cheyenne | Colorado | 8017 | 14 | 0 |
638384 | 638384 | 2020-10-17 | Clear Creek | Colorado | 8019 | 61 | 1 |
638385 | 638385 | 2020-10-17 | Conejos | Colorado | 8021 | 50 | 0 |
638386 | 638386 | 2020-10-17 | Costilla | Colorado | 8023 | 34 | 1 |
638387 | 638387 | 2020-10-17 | Crowley | Colorado | 8025 | 80 | 1 |
638388 | 638388 | 2020-10-17 | Custer | Colorado | 8027 | 19 | 0 |
638389 | 638389 | 2020-10-17 | Delta | Colorado | 8029 | 195 | 4 |
638390 | 638390 | 2020-10-17 | Denver | Colorado | 8031 | 15821 | 449 |
638391 | 638391 | 2020-10-17 | Dolores | Colorado | 8033 | 3 | 0 |
638392 | 638392 | 2020-10-17 | Douglas | Colorado | 8035 | 3368 | 63 |
638393 | 638393 | 2020-10-17 | Eagle | Colorado | 8037 | 1340 | 10 |
638394 | 638394 | 2020-10-17 | El Paso | Colorado | 8041 | 8435 | 188 |
638395 | 638395 | 2020-10-17 | Elbert | Colorado | 8039 | 180 | 3 |
638396 | 638396 | 2020-10-17 | Fremont | Colorado | 8043 | 462 | 1 |
638397 | 638397 | 2020-10-17 | Garfield | Colorado | 8045 | 1058 | 5 |
638398 | 638398 | 2020-10-17 | Gilpin | Colorado | 8047 | 21 | 0 |
638399 | 638399 | 2020-10-17 | Grand | Colorado | 8049 | 133 | 1 |
638400 | 638400 | 2020-10-17 | Gunnison | Colorado | 8051 | 296 | 7 |
638401 | 638401 | 2020-10-17 | Hinsdale | Colorado | 8053 | 3 | 0 |
638402 | 638402 | 2020-10-17 | Huerfano | Colorado | 8055 | 28 | 2 |
638403 | 638403 | 2020-10-17 | Jackson | Colorado | 8057 | 9 | 0 |
638404 | 638404 | 2020-10-17 | Jefferson | Colorado | 8059 | 7076 | 299 |
638405 | 638405 | 2020-10-17 | Kiowa | Colorado | 8061 | 3 | 0 |
638406 | 638406 | 2020-10-17 | Kit Carson | Colorado | 8063 | 103 | 3 |
638407 | 638407 | 2020-10-17 | La Plata | Colorado | 8067 | 320 | 2 |
638408 | 638408 | 2020-10-17 | Lake | Colorado | 8065 | 117 | 0 |
638409 | 638409 | 2020-10-17 | Larimer | Colorado | 8069 | 3462 | 55 |
638410 | 638410 | 2020-10-17 | Las Animas | Colorado | 8071 | 37 | 1 |
638411 | 638411 | 2020-10-17 | Lincoln | Colorado | 8073 | 24 | 0 |
638412 | 638412 | 2020-10-17 | Logan | Colorado | 8075 | 1062 | 10 |
638413 | 638413 | 2020-10-17 | Mesa | Colorado | 8077 | 992 | 8 |
638414 | 638414 | 2020-10-17 | Mineral | Colorado | 8079 | 21 | 0 |
638415 | 638415 | 2020-10-17 | Moffat | Colorado | 8081 | 51 | 1 |
638416 | 638416 | 2020-10-17 | Montezuma | Colorado | 8083 | 176 | 5 |
638417 | 638417 | 2020-10-17 | Montrose | Colorado | 8085 | 417 | 13 |
638418 | 638418 | 2020-10-17 | Morgan | Colorado | 8087 | 809 | 48 |
638419 | 638419 | 2020-10-17 | Otero | Colorado | 8089 | 115 | 6 |
638420 | 638420 | 2020-10-17 | Ouray | Colorado | 8091 | 32 | 1 |
638421 | 638421 | 2020-10-17 | Park | Colorado | 8093 | 79 | 1 |
638422 | 638422 | 2020-10-17 | Phillips | Colorado | 8095 | 36 | 0 |
638423 | 638423 | 2020-10-17 | Pitkin | Colorado | 8097 | 255 | 2 |
638424 | 638424 | 2020-10-17 | Prowers | Colorado | 8099 | 115 | 0 |
638425 | 638425 | 2020-10-17 | Pueblo | Colorado | 8101 | 1544 | 40 |
638426 | 638426 | 2020-10-17 | Rio Blanco | Colorado | 8103 | 25 | 0 |
638427 | 638427 | 2020-10-17 | Rio Grande | Colorado | 8105 | 114 | 2 |
638428 | 638428 | 2020-10-17 | Routt | Colorado | 8107 | 185 | 8 |
638429 | 638429 | 2020-10-17 | Saguache | Colorado | 8109 | 119 | 2 |
638430 | 638430 | 2020-10-17 | San Juan | Colorado | 8111 | 6 | 0 |
638431 | 638431 | 2020-10-17 | San Miguel | Colorado | 8113 | 100 | 0 |
638432 | 638432 | 2020-10-17 | Sedgwick | Colorado | 8115 | 22 | 1 |
638433 | 638433 | 2020-10-17 | Summit | Colorado | 8117 | 549 | 4 |
638434 | 638434 | 2020-10-17 | Teller | Colorado | 8119 | 192 | 4 |
638435 | 638435 | 2020-10-17 | Washington | Colorado | 8121 | 78 | 0 |
638436 | 638436 | 2020-10-17 | Weld | Colorado | 8123 | 5367 | 156 |
638437 | 638437 | 2020-10-17 | Yuma | Colorado | 8125 | 179 | 1 |
638438 | 638438 | 2020-10-17 | Fairfield | Connecticut | 9001 | 21368 | 1427 |
638439 | 638439 | 2020-10-17 | Hartford | Connecticut | 9003 | 16273 | 1445 |
638440 | 638440 | 2020-10-17 | Litchfield | Connecticut | 9005 | 1991 | 143 |
638441 | 638441 | 2020-10-17 | Middlesex | Connecticut | 9007 | 1754 | 194 |
638442 | 638442 | 2020-10-17 | New Haven | Connecticut | 9009 | 15455 | 1119 |
638443 | 638443 | 2020-10-17 | New London | Connecticut | 9011 | 3083 | 130 |
638444 | 638444 | 2020-10-17 | Tolland | Connecticut | 9013 | 1565 | 67 |
638445 | 638445 | 2020-10-17 | Unknown | Connecticut | 125 | 0 | |
638446 | 638446 | 2020-10-17 | Windham | Connecticut | 9015 | 1216 | 17 |
638447 | 638447 | 2020-10-17 | Kent | Delaware | 10001 | 3316 | 119 |
638448 | 638448 | 2020-10-17 | New Castle | Delaware | 10003 | 12059 | 332 |
638449 | 638449 | 2020-10-17 | Sussex | Delaware | 10005 | 7476 | 213 |
638450 | 638450 | 2020-10-17 | Unknown | Delaware | 91 | 0 | |
638451 | 638451 | 2020-10-17 | District of Columbia | District of Columbia | 11001 | 16334 | 641 |
638452 | 638452 | 2020-10-17 | Alachua | Florida | 12001 | 9412 | 71 |
638453 | 638453 | 2020-10-17 | Baker | Florida | 12003 | 1681 | 17 |
638454 | 638454 | 2020-10-17 | Bay | Florida | 12005 | 6436 | 126 |
638455 | 638455 | 2020-10-17 | Bradford | Florida | 12007 | 1201 | 12 |
638456 | 638456 | 2020-10-17 | Brevard | Florida | 12009 | 10349 | 345 |
638457 | 638457 | 2020-10-17 | Broward | Florida | 12011 | 80820 | 1506 |
638458 | 638458 | 2020-10-17 | Calhoun | Florida | 12013 | 668 | 14 |
638459 | 638459 | 2020-10-17 | Charlotte | Florida | 12015 | 3349 | 153 |
638460 | 638460 | 2020-10-17 | Citrus | Florida | 12017 | 3030 | 126 |
638461 | 638461 | 2020-10-17 | Clay | Florida | 12019 | 5684 | 115 |
638462 | 638462 | 2020-10-17 | Collier | Florida | 12021 | 13588 | 244 |
638463 | 638463 | 2020-10-17 | Columbia | Florida | 12023 | 4100 | 71 |
638464 | 638464 | 2020-10-17 | DeSoto | Florida | 12027 | 1620 | 28 |
638465 | 638465 | 2020-10-17 | Dixie | Florida | 12029 | 867 | 11 |
638466 | 638466 | 2020-10-17 | Duval | Florida | 12031 | 32772 | 505 |
638467 | 638467 | 2020-10-17 | Escambia | Florida | 12033 | 12959 | 269 |
638468 | 638468 | 2020-10-17 | Flagler | Florida | 12035 | 1945 | 35 |
638469 | 638469 | 2020-10-17 | Franklin | Florida | 12037 | 691 | 4 |
638470 | 638470 | 2020-10-17 | Gadsden | Florida | 12039 | 3018 | 53 |
638471 | 638471 | 2020-10-17 | Gilchrist | Florida | 12041 | 540 | 17 |
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);