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,824
- New York 12,458
- California 12,393
- South Dakota 11,734
- West Virginia 10,721
- South Carolina 9,733
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
638472 | 638472 | 2020-10-17 | Glades | Florida | 12043 | 587 | 6 |
638473 | 638473 | 2020-10-17 | Gulf | Florida | 12045 | 921 | 15 |
638474 | 638474 | 2020-10-17 | Hamilton | Florida | 12047 | 890 | 9 |
638475 | 638475 | 2020-10-17 | Hardee | Florida | 12049 | 1524 | 11 |
638476 | 638476 | 2020-10-17 | Hendry | Florida | 12051 | 2147 | 43 |
638477 | 638477 | 2020-10-17 | Hernando | Florida | 12053 | 3425 | 154 |
638478 | 638478 | 2020-10-17 | Highlands | Florida | 12055 | 2431 | 102 |
638479 | 638479 | 2020-10-17 | Hillsborough | Florida | 12057 | 45275 | 745 |
638480 | 638480 | 2020-10-17 | Holmes | Florida | 12059 | 836 | 11 |
638481 | 638481 | 2020-10-17 | Indian River | Florida | 12061 | 3520 | 122 |
638482 | 638482 | 2020-10-17 | Jackson | Florida | 12063 | 3035 | 83 |
638483 | 638483 | 2020-10-17 | Jefferson | Florida | 12065 | 620 | 9 |
638484 | 638484 | 2020-10-17 | Lafayette | Florida | 12067 | 1260 | 15 |
638485 | 638485 | 2020-10-17 | Lake | Florida | 12069 | 8130 | 216 |
638486 | 638486 | 2020-10-17 | Lee | Florida | 12071 | 21882 | 492 |
638487 | 638487 | 2020-10-17 | Leon | Florida | 12073 | 11615 | 98 |
638488 | 638488 | 2020-10-17 | Levy | Florida | 12075 | 1100 | 11 |
638489 | 638489 | 2020-10-17 | Liberty | Florida | 12077 | 523 | 10 |
638490 | 638490 | 2020-10-17 | Madison | Florida | 12079 | 1053 | 24 |
638491 | 638491 | 2020-10-17 | Manatee | Florida | 12081 | 12488 | 319 |
638492 | 638492 | 2020-10-17 | Marion | Florida | 12083 | 10416 | 334 |
638493 | 638493 | 2020-10-17 | Martin | Florida | 12085 | 5169 | 154 |
638494 | 638494 | 2020-10-17 | Miami-Dade | Florida | 12086 | 177892 | 3537 |
638495 | 638495 | 2020-10-17 | Monroe | Florida | 12087 | 2038 | 25 |
638496 | 638496 | 2020-10-17 | Nassau | Florida | 12089 | 2335 | 50 |
638497 | 638497 | 2020-10-17 | Okaloosa | Florida | 12091 | 5755 | 128 |
638498 | 638498 | 2020-10-17 | Okeechobee | Florida | 12093 | 1663 | 37 |
638499 | 638499 | 2020-10-17 | Orange | Florida | 12095 | 43301 | 529 |
638500 | 638500 | 2020-10-17 | Osceola | Florida | 12097 | 13436 | 181 |
638501 | 638501 | 2020-10-17 | Palm Beach | Florida | 12099 | 48868 | 1487 |
638502 | 638502 | 2020-10-17 | Pasco | Florida | 12101 | 10169 | 223 |
638503 | 638503 | 2020-10-17 | Pinellas | Florida | 12103 | 23982 | 798 |
638504 | 638504 | 2020-10-17 | Polk | Florida | 12105 | 21713 | 582 |
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);