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,223
- Georgia 32,729
- Virginia 26,512
- Kentucky 23,452
- Missouri 22,207
- Illinois 20,258
- North Carolina 20,208
- Iowa 19,470
- Tennessee 19,436
- Indiana 18,894
- Kansas 18,597
- Ohio 17,978
- Minnesota 17,195
- Mississippi 16,857
- Michigan 16,818
- Nebraska 15,310
- Arkansas 15,180
- Oklahoma 14,996
- Wisconsin 14,513
- Florida 14,194
- Pennsylvania 13,849
- Alabama 13,653
- Louisiana 13,463
- Puerto Rico 12,893
- Colorado 12,645
- New York 12,284
- California 12,219
- South Dakota 11,536
- West Virginia 10,556
- South Carolina 9,595
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
628657 | 628657 | 2020-10-14 | Douglas | Colorado | 8035 | 3241 | 63 |
628658 | 628658 | 2020-10-14 | Eagle | Colorado | 8037 | 1331 | 10 |
628659 | 628659 | 2020-10-14 | El Paso | Colorado | 8041 | 8001 | 188 |
628660 | 628660 | 2020-10-14 | Elbert | Colorado | 8039 | 177 | 3 |
628661 | 628661 | 2020-10-14 | Fremont | Colorado | 8043 | 275 | 1 |
628662 | 628662 | 2020-10-14 | Garfield | Colorado | 8045 | 1028 | 5 |
628663 | 628663 | 2020-10-14 | Gilpin | Colorado | 8047 | 21 | 0 |
628664 | 628664 | 2020-10-14 | Grand | Colorado | 8049 | 118 | 1 |
628665 | 628665 | 2020-10-14 | Gunnison | Colorado | 8051 | 297 | 7 |
628666 | 628666 | 2020-10-14 | Hinsdale | Colorado | 8053 | 3 | 0 |
628667 | 628667 | 2020-10-14 | Huerfano | Colorado | 8055 | 27 | 2 |
628668 | 628668 | 2020-10-14 | Jackson | Colorado | 8057 | 9 | 0 |
628669 | 628669 | 2020-10-14 | Jefferson | Colorado | 8059 | 6806 | 296 |
628670 | 628670 | 2020-10-14 | Kiowa | Colorado | 8061 | 1 | 0 |
628671 | 628671 | 2020-10-14 | Kit Carson | Colorado | 8063 | 98 | 3 |
628672 | 628672 | 2020-10-14 | La Plata | Colorado | 8067 | 302 | 2 |
628673 | 628673 | 2020-10-14 | Lake | Colorado | 8065 | 112 | 0 |
628674 | 628674 | 2020-10-14 | Larimer | Colorado | 8069 | 3259 | 55 |
628675 | 628675 | 2020-10-14 | Las Animas | Colorado | 8071 | 30 | 0 |
628676 | 628676 | 2020-10-14 | Lincoln | Colorado | 8073 | 24 | 0 |
628677 | 628677 | 2020-10-14 | Logan | Colorado | 8075 | 1035 | 10 |
628678 | 628678 | 2020-10-14 | Mesa | Colorado | 8077 | 837 | 8 |
628679 | 628679 | 2020-10-14 | Mineral | Colorado | 8079 | 20 | 0 |
628680 | 628680 | 2020-10-14 | Moffat | Colorado | 8081 | 48 | 1 |
628681 | 628681 | 2020-10-14 | Montezuma | Colorado | 8083 | 172 | 5 |
628682 | 628682 | 2020-10-14 | Montrose | Colorado | 8085 | 405 | 13 |
628683 | 628683 | 2020-10-14 | Morgan | Colorado | 8087 | 788 | 48 |
628684 | 628684 | 2020-10-14 | Otero | Colorado | 8089 | 113 | 6 |
628685 | 628685 | 2020-10-14 | Ouray | Colorado | 8091 | 32 | 1 |
628686 | 628686 | 2020-10-14 | Park | Colorado | 8093 | 65 | 1 |
628687 | 628687 | 2020-10-14 | Phillips | Colorado | 8095 | 35 | 0 |
628688 | 628688 | 2020-10-14 | Pitkin | Colorado | 8097 | 250 | 2 |
628689 | 628689 | 2020-10-14 | Prowers | Colorado | 8099 | 99 | 0 |
628690 | 628690 | 2020-10-14 | Pueblo | Colorado | 8101 | 1439 | 39 |
628691 | 628691 | 2020-10-14 | Rio Blanco | Colorado | 8103 | 25 | 0 |
628692 | 628692 | 2020-10-14 | Rio Grande | Colorado | 8105 | 110 | 2 |
628693 | 628693 | 2020-10-14 | Routt | Colorado | 8107 | 172 | 8 |
628694 | 628694 | 2020-10-14 | Saguache | Colorado | 8109 | 116 | 2 |
628695 | 628695 | 2020-10-14 | San Juan | Colorado | 8111 | 6 | 0 |
628696 | 628696 | 2020-10-14 | San Miguel | Colorado | 8113 | 97 | 0 |
628697 | 628697 | 2020-10-14 | Sedgwick | Colorado | 8115 | 16 | 1 |
628698 | 628698 | 2020-10-14 | Summit | Colorado | 8117 | 529 | 4 |
628699 | 628699 | 2020-10-14 | Teller | Colorado | 8119 | 184 | 4 |
628700 | 628700 | 2020-10-14 | Washington | Colorado | 8121 | 74 | 0 |
628701 | 628701 | 2020-10-14 | Weld | Colorado | 8123 | 5227 | 155 |
628702 | 628702 | 2020-10-14 | Yuma | Colorado | 8125 | 158 | 1 |
628703 | 628703 | 2020-10-14 | Fairfield | Connecticut | 9001 | 21128 | 1427 |
628704 | 628704 | 2020-10-14 | Hartford | Connecticut | 9003 | 16010 | 1443 |
628705 | 628705 | 2020-10-14 | Litchfield | Connecticut | 9005 | 1956 | 142 |
628706 | 628706 | 2020-10-14 | Middlesex | Connecticut | 9007 | 1720 | 193 |
628707 | 628707 | 2020-10-14 | New Haven | Connecticut | 9009 | 15263 | 1119 |
628708 | 628708 | 2020-10-14 | New London | Connecticut | 9011 | 2918 | 129 |
628709 | 628709 | 2020-10-14 | Tolland | Connecticut | 9013 | 1535 | 67 |
628710 | 628710 | 2020-10-14 | Unknown | Connecticut | 148 | 0 | |
628711 | 628711 | 2020-10-14 | Windham | Connecticut | 9015 | 1183 | 17 |
628712 | 628712 | 2020-10-14 | Kent | Delaware | 10001 | 3259 | 119 |
628713 | 628713 | 2020-10-14 | New Castle | Delaware | 10003 | 11787 | 329 |
628714 | 628714 | 2020-10-14 | Sussex | Delaware | 10005 | 7328 | 212 |
628715 | 628715 | 2020-10-14 | Unknown | Delaware | 91 | 0 | |
628716 | 628716 | 2020-10-14 | District of Columbia | District of Columbia | 11001 | 16132 | 638 |
628717 | 628717 | 2020-10-14 | Alachua | Florida | 12001 | 9133 | 70 |
628718 | 628718 | 2020-10-14 | Baker | Florida | 12003 | 1642 | 16 |
628719 | 628719 | 2020-10-14 | Bay | Florida | 12005 | 6366 | 122 |
628720 | 628720 | 2020-10-14 | Bradford | Florida | 12007 | 1187 | 11 |
628721 | 628721 | 2020-10-14 | Brevard | Florida | 12009 | 10110 | 331 |
628722 | 628722 | 2020-10-14 | Broward | Florida | 12011 | 79876 | 1484 |
628723 | 628723 | 2020-10-14 | Calhoun | Florida | 12013 | 653 | 14 |
628724 | 628724 | 2020-10-14 | Charlotte | Florida | 12015 | 3287 | 150 |
628725 | 628725 | 2020-10-14 | Citrus | Florida | 12017 | 2983 | 124 |
628726 | 628726 | 2020-10-14 | Clay | Florida | 12019 | 5556 | 111 |
628727 | 628727 | 2020-10-14 | Collier | Florida | 12021 | 13382 | 239 |
628728 | 628728 | 2020-10-14 | Columbia | Florida | 12023 | 4034 | 68 |
628729 | 628729 | 2020-10-14 | DeSoto | Florida | 12027 | 1609 | 27 |
628730 | 628730 | 2020-10-14 | Dixie | Florida | 12029 | 860 | 11 |
628731 | 628731 | 2020-10-14 | Duval | Florida | 12031 | 32311 | 494 |
628732 | 628732 | 2020-10-14 | Escambia | Florida | 12033 | 12737 | 264 |
628733 | 628733 | 2020-10-14 | Flagler | Florida | 12035 | 1892 | 33 |
628734 | 628734 | 2020-10-14 | Franklin | Florida | 12037 | 676 | 4 |
628735 | 628735 | 2020-10-14 | Gadsden | Florida | 12039 | 2991 | 51 |
628736 | 628736 | 2020-10-14 | Gilchrist | Florida | 12041 | 531 | 17 |
628737 | 628737 | 2020-10-14 | Glades | Florida | 12043 | 581 | 6 |
628738 | 628738 | 2020-10-14 | Gulf | Florida | 12045 | 911 | 15 |
628739 | 628739 | 2020-10-14 | Hamilton | Florida | 12047 | 889 | 9 |
628740 | 628740 | 2020-10-14 | Hardee | Florida | 12049 | 1479 | 11 |
628741 | 628741 | 2020-10-14 | Hendry | Florida | 12051 | 2128 | 43 |
628742 | 628742 | 2020-10-14 | Hernando | Florida | 12053 | 3324 | 149 |
628743 | 628743 | 2020-10-14 | Highlands | Florida | 12055 | 2398 | 100 |
628744 | 628744 | 2020-10-14 | Hillsborough | Florida | 12057 | 44652 | 720 |
628745 | 628745 | 2020-10-14 | Holmes | Florida | 12059 | 803 | 10 |
628746 | 628746 | 2020-10-14 | Indian River | Florida | 12061 | 3458 | 119 |
628747 | 628747 | 2020-10-14 | Jackson | Florida | 12063 | 2986 | 83 |
628748 | 628748 | 2020-10-14 | Jefferson | Florida | 12065 | 603 | 9 |
628749 | 628749 | 2020-10-14 | Lafayette | Florida | 12067 | 1253 | 15 |
628750 | 628750 | 2020-10-14 | Lake | Florida | 12069 | 8012 | 211 |
628751 | 628751 | 2020-10-14 | Lee | Florida | 12071 | 21488 | 485 |
628752 | 628752 | 2020-10-14 | Leon | Florida | 12073 | 11412 | 93 |
628753 | 628753 | 2020-10-14 | Levy | Florida | 12075 | 1089 | 10 |
628754 | 628754 | 2020-10-14 | Liberty | Florida | 12077 | 520 | 10 |
628755 | 628755 | 2020-10-14 | Madison | Florida | 12079 | 1047 | 24 |
628756 | 628756 | 2020-10-14 | Manatee | Florida | 12081 | 12270 | 310 |
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);