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 45,961
- Georgia 31,929
- Virginia 25,847
- Kentucky 22,852
- Missouri 21,622
- Illinois 19,743
- North Carolina 19,708
- Iowa 18,970
- Tennessee 18,956
- Indiana 18,434
- Kansas 18,071
- Ohio 17,538
- Minnesota 16,755
- Mississippi 16,447
- Michigan 16,398
- Nebraska 14,840
- Arkansas 14,800
- Oklahoma 14,606
- Wisconsin 14,148
- Florida 13,854
- Pennsylvania 13,514
- Alabama 13,318
- Louisiana 13,138
- Puerto Rico 12,498
- Colorado 12,316
- New York 11,994
- California 11,929
- South Dakota 11,206
- West Virginia 10,281
- South Carolina 9,365
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
612454 | 612454 | 2020-10-09 | Hinsdale | Colorado | 8053 | 3 | 0 |
612455 | 612455 | 2020-10-09 | Huerfano | Colorado | 8055 | 26 | 1 |
612456 | 612456 | 2020-10-09 | Jackson | Colorado | 8057 | 9 | 0 |
612457 | 612457 | 2020-10-09 | Jefferson | Colorado | 8059 | 6387 | 262 |
612458 | 612458 | 2020-10-09 | Kiowa | Colorado | 8061 | 1 | 0 |
612459 | 612459 | 2020-10-09 | Kit Carson | Colorado | 8063 | 81 | 3 |
612460 | 612460 | 2020-10-09 | La Plata | Colorado | 8067 | 287 | 2 |
612461 | 612461 | 2020-10-09 | Lake | Colorado | 8065 | 104 | 0 |
612462 | 612462 | 2020-10-09 | Larimer | Colorado | 8069 | 2992 | 55 |
612463 | 612463 | 2020-10-09 | Las Animas | Colorado | 8071 | 28 | 0 |
612464 | 612464 | 2020-10-09 | Lincoln | Colorado | 8073 | 24 | 0 |
612465 | 612465 | 2020-10-09 | Logan | Colorado | 8075 | 979 | 7 |
612466 | 612466 | 2020-10-09 | Mesa | Colorado | 8077 | 766 | 7 |
612467 | 612467 | 2020-10-09 | Mineral | Colorado | 8079 | 20 | 0 |
612468 | 612468 | 2020-10-09 | Moffat | Colorado | 8081 | 45 | 1 |
612469 | 612469 | 2020-10-09 | Montezuma | Colorado | 8083 | 158 | 5 |
612470 | 612470 | 2020-10-09 | Montrose | Colorado | 8085 | 393 | 13 |
612471 | 612471 | 2020-10-09 | Morgan | Colorado | 8087 | 775 | 48 |
612472 | 612472 | 2020-10-09 | Otero | Colorado | 8089 | 109 | 6 |
612473 | 612473 | 2020-10-09 | Ouray | Colorado | 8091 | 29 | 1 |
612474 | 612474 | 2020-10-09 | Park | Colorado | 8093 | 61 | 1 |
612475 | 612475 | 2020-10-09 | Phillips | Colorado | 8095 | 33 | 0 |
612476 | 612476 | 2020-10-09 | Pitkin | Colorado | 8097 | 236 | 2 |
612477 | 612477 | 2020-10-09 | Prowers | Colorado | 8099 | 97 | 0 |
612478 | 612478 | 2020-10-09 | Pueblo | Colorado | 8101 | 1317 | 37 |
612479 | 612479 | 2020-10-09 | Rio Blanco | Colorado | 8103 | 26 | 0 |
612480 | 612480 | 2020-10-09 | Rio Grande | Colorado | 8105 | 102 | 2 |
612481 | 612481 | 2020-10-09 | Routt | Colorado | 8107 | 171 | 8 |
612482 | 612482 | 2020-10-09 | Saguache | Colorado | 8109 | 113 | 2 |
612483 | 612483 | 2020-10-09 | San Juan | Colorado | 8111 | 6 | 0 |
612484 | 612484 | 2020-10-09 | San Miguel | Colorado | 8113 | 98 | 0 |
612485 | 612485 | 2020-10-09 | Sedgwick | Colorado | 8115 | 15 | 1 |
612486 | 612486 | 2020-10-09 | Summit | Colorado | 8117 | 512 | 4 |
612487 | 612487 | 2020-10-09 | Teller | Colorado | 8119 | 181 | 4 |
612488 | 612488 | 2020-10-09 | Washington | Colorado | 8121 | 71 | 0 |
612489 | 612489 | 2020-10-09 | Weld | Colorado | 8123 | 5083 | 152 |
612490 | 612490 | 2020-10-09 | Yuma | Colorado | 8125 | 150 | 1 |
612491 | 612491 | 2020-10-09 | Fairfield | Connecticut | 9001 | 20752 | 1426 |
612492 | 612492 | 2020-10-09 | Hartford | Connecticut | 9003 | 15520 | 1442 |
612493 | 612493 | 2020-10-09 | Litchfield | Connecticut | 9005 | 1919 | 141 |
612494 | 612494 | 2020-10-09 | Middlesex | Connecticut | 9007 | 1667 | 193 |
612495 | 612495 | 2020-10-09 | New Haven | Connecticut | 9009 | 14877 | 1118 |
612496 | 612496 | 2020-10-09 | New London | Connecticut | 9011 | 2570 | 126 |
612497 | 612497 | 2020-10-09 | Tolland | Connecticut | 9013 | 1502 | 67 |
612498 | 612498 | 2020-10-09 | Unknown | Connecticut | 123 | 0 | |
612499 | 612499 | 2020-10-09 | Windham | Connecticut | 9015 | 1108 | 17 |
612500 | 612500 | 2020-10-09 | Kent | Delaware | 10001 | 3190 | 118 |
612501 | 612501 | 2020-10-09 | New Castle | Delaware | 10003 | 11399 | 323 |
612502 | 612502 | 2020-10-09 | Sussex | Delaware | 10005 | 7148 | 210 |
612503 | 612503 | 2020-10-09 | Unknown | Delaware | 90 | 0 | |
612504 | 612504 | 2020-10-09 | District of Columbia | District of Columbia | 11001 | 15843 | 634 |
612505 | 612505 | 2020-10-09 | Alachua | Florida | 12001 | 8817 | 68 |
612506 | 612506 | 2020-10-09 | Baker | Florida | 12003 | 1604 | 15 |
612507 | 612507 | 2020-10-09 | Bay | Florida | 12005 | 6268 | 120 |
612508 | 612508 | 2020-10-09 | Bradford | Florida | 12007 | 1166 | 10 |
612509 | 612509 | 2020-10-09 | Brevard | Florida | 12009 | 9777 | 317 |
612510 | 612510 | 2020-10-09 | Broward | Florida | 12011 | 78795 | 1455 |
612511 | 612511 | 2020-10-09 | Calhoun | Florida | 12013 | 638 | 14 |
612512 | 612512 | 2020-10-09 | Charlotte | Florida | 12015 | 3202 | 143 |
612513 | 612513 | 2020-10-09 | Citrus | Florida | 12017 | 2914 | 115 |
612514 | 612514 | 2020-10-09 | Clay | Florida | 12019 | 5407 | 110 |
612515 | 612515 | 2020-10-09 | Collier | Florida | 12021 | 13139 | 234 |
612516 | 612516 | 2020-10-09 | Columbia | Florida | 12023 | 3966 | 62 |
612517 | 612517 | 2020-10-09 | DeSoto | Florida | 12027 | 1597 | 27 |
612518 | 612518 | 2020-10-09 | Dixie | Florida | 12029 | 845 | 11 |
612519 | 612519 | 2020-10-09 | Duval | Florida | 12031 | 31669 | 474 |
612520 | 612520 | 2020-10-09 | Escambia | Florida | 12033 | 12611 | 255 |
612521 | 612521 | 2020-10-09 | Flagler | Florida | 12035 | 1838 | 31 |
612522 | 612522 | 2020-10-09 | Franklin | Florida | 12037 | 662 | 4 |
612523 | 612523 | 2020-10-09 | Gadsden | Florida | 12039 | 2952 | 50 |
612524 | 612524 | 2020-10-09 | Gilchrist | Florida | 12041 | 523 | 16 |
612525 | 612525 | 2020-10-09 | Glades | Florida | 12043 | 577 | 5 |
612526 | 612526 | 2020-10-09 | Gulf | Florida | 12045 | 894 | 15 |
612527 | 612527 | 2020-10-09 | Hamilton | Florida | 12047 | 879 | 8 |
612528 | 612528 | 2020-10-09 | Hardee | Florida | 12049 | 1439 | 11 |
612529 | 612529 | 2020-10-09 | Hendry | Florida | 12051 | 2103 | 42 |
612530 | 612530 | 2020-10-09 | Hernando | Florida | 12053 | 3311 | 146 |
612531 | 612531 | 2020-10-09 | Highlands | Florida | 12055 | 2313 | 97 |
612532 | 612532 | 2020-10-09 | Hillsborough | Florida | 12057 | 43808 | 691 |
612533 | 612533 | 2020-10-09 | Holmes | Florida | 12059 | 784 | 9 |
612534 | 612534 | 2020-10-09 | Indian River | Florida | 12061 | 3416 | 119 |
612535 | 612535 | 2020-10-09 | Jackson | Florida | 12063 | 2932 | 83 |
612536 | 612536 | 2020-10-09 | Jefferson | Florida | 12065 | 586 | 9 |
612537 | 612537 | 2020-10-09 | Lafayette | Florida | 12067 | 1248 | 15 |
612538 | 612538 | 2020-10-09 | Lake | Florida | 12069 | 7862 | 202 |
612539 | 612539 | 2020-10-09 | Lee | Florida | 12071 | 21174 | 481 |
612540 | 612540 | 2020-10-09 | Leon | Florida | 12073 | 11131 | 90 |
612541 | 612541 | 2020-10-09 | Levy | Florida | 12075 | 1075 | 10 |
612542 | 612542 | 2020-10-09 | Liberty | Florida | 12077 | 520 | 9 |
612543 | 612543 | 2020-10-09 | Madison | Florida | 12079 | 1035 | 22 |
612544 | 612544 | 2020-10-09 | Manatee | Florida | 12081 | 11999 | 300 |
612545 | 612545 | 2020-10-09 | Marion | Florida | 12083 | 10102 | 317 |
612546 | 612546 | 2020-10-09 | Martin | Florida | 12085 | 5050 | 145 |
612547 | 612547 | 2020-10-09 | Miami-Dade | Florida | 12086 | 174111 | 3409 |
612548 | 612548 | 2020-10-09 | Monroe | Florida | 12087 | 1927 | 24 |
612549 | 612549 | 2020-10-09 | Nassau | Florida | 12089 | 2224 | 49 |
612550 | 612550 | 2020-10-09 | Okaloosa | Florida | 12091 | 5322 | 122 |
612551 | 612551 | 2020-10-09 | Okeechobee | Florida | 12093 | 1631 | 32 |
612552 | 612552 | 2020-10-09 | Orange | Florida | 12095 | 41821 | 501 |
612553 | 612553 | 2020-10-09 | Osceola | Florida | 12097 | 13023 | 172 |
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);