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 39,920
- Georgia 28,089
- Virginia 22,655
- Kentucky 19,972
- Missouri 18,814
- North Carolina 17,308
- Illinois 17,271
- Tennessee 16,656
- Iowa 16,570
- Indiana 16,226
- Kansas 15,542
- Ohio 15,426
- Minnesota 14,643
- Mississippi 14,479
- Michigan 14,382
- Arkansas 12,976
- Oklahoma 12,734
- Nebraska 12,612
- Wisconsin 12,396
- Florida 12,222
- Pennsylvania 11,906
- Alabama 11,710
- Louisiana 11,578
- Colorado 10,803
- New York 10,602
- Puerto Rico 10,602
- California 10,537
- South Dakota 9,622
- West Virginia 8,961
- South Carolina 8,261
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
534679 | 534679 | 2020-09-15 | Costilla | Colorado | 8023 | 32 | 1 |
534680 | 534680 | 2020-09-15 | Crowley | Colorado | 8025 | 73 | 1 |
534681 | 534681 | 2020-09-15 | Custer | Colorado | 8027 | 17 | 0 |
534682 | 534682 | 2020-09-15 | Delta | Colorado | 8029 | 176 | 3 |
534683 | 534683 | 2020-09-15 | Denver | Colorado | 8031 | 11976 | 437 |
534684 | 534684 | 2020-09-15 | Dolores | Colorado | 8033 | 3 | 0 |
534685 | 534685 | 2020-09-15 | Douglas | Colorado | 8035 | 2350 | 60 |
534686 | 534686 | 2020-09-15 | Eagle | Colorado | 8037 | 1215 | 9 |
534687 | 534687 | 2020-09-15 | El Paso | Colorado | 8041 | 6522 | 163 |
534688 | 534688 | 2020-09-15 | Elbert | Colorado | 8039 | 141 | 3 |
534689 | 534689 | 2020-09-15 | Fremont | Colorado | 8043 | 167 | 1 |
534690 | 534690 | 2020-09-15 | Garfield | Colorado | 8045 | 900 | 5 |
534691 | 534691 | 2020-09-15 | Gilpin | Colorado | 8047 | 18 | 0 |
534692 | 534692 | 2020-09-15 | Grand | Colorado | 8049 | 69 | 1 |
534693 | 534693 | 2020-09-15 | Gunnison | Colorado | 8051 | 296 | 7 |
534694 | 534694 | 2020-09-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
534695 | 534695 | 2020-09-15 | Huerfano | Colorado | 8055 | 10 | 1 |
534696 | 534696 | 2020-09-15 | Jackson | Colorado | 8057 | 9 | 0 |
534697 | 534697 | 2020-09-15 | Jefferson | Colorado | 8059 | 5160 | 246 |
534698 | 534698 | 2020-09-15 | Kit Carson | Colorado | 8063 | 78 | 3 |
534699 | 534699 | 2020-09-15 | La Plata | Colorado | 8067 | 248 | 2 |
534700 | 534700 | 2020-09-15 | Lake | Colorado | 8065 | 87 | 0 |
534701 | 534701 | 2020-09-15 | Larimer | Colorado | 8069 | 2220 | 47 |
534702 | 534702 | 2020-09-15 | Las Animas | Colorado | 8071 | 21 | 0 |
534703 | 534703 | 2020-09-15 | Lincoln | Colorado | 8073 | 8 | 0 |
534704 | 534704 | 2020-09-15 | Logan | Colorado | 8075 | 792 | 5 |
534705 | 534705 | 2020-09-15 | Mesa | Colorado | 8077 | 500 | 6 |
534706 | 534706 | 2020-09-15 | Mineral | Colorado | 8079 | 20 | 0 |
534707 | 534707 | 2020-09-15 | Moffat | Colorado | 8081 | 38 | 1 |
534708 | 534708 | 2020-09-15 | Montezuma | Colorado | 8083 | 128 | 5 |
534709 | 534709 | 2020-09-15 | Montrose | Colorado | 8085 | 358 | 13 |
534710 | 534710 | 2020-09-15 | Morgan | Colorado | 8087 | 726 | 48 |
534711 | 534711 | 2020-09-15 | Otero | Colorado | 8089 | 84 | 6 |
534712 | 534712 | 2020-09-15 | Ouray | Colorado | 8091 | 25 | 1 |
534713 | 534713 | 2020-09-15 | Park | Colorado | 8093 | 46 | 1 |
534714 | 534714 | 2020-09-15 | Phillips | Colorado | 8095 | 32 | 0 |
534715 | 534715 | 2020-09-15 | Pitkin | Colorado | 8097 | 208 | 2 |
534716 | 534716 | 2020-09-15 | Prowers | Colorado | 8099 | 91 | 0 |
534717 | 534717 | 2020-09-15 | Pueblo | Colorado | 8101 | 989 | 34 |
534718 | 534718 | 2020-09-15 | Rio Blanco | Colorado | 8103 | 24 | 0 |
534719 | 534719 | 2020-09-15 | Rio Grande | Colorado | 8105 | 95 | 2 |
534720 | 534720 | 2020-09-15 | Routt | Colorado | 8107 | 139 | 8 |
534721 | 534721 | 2020-09-15 | Saguache | Colorado | 8109 | 111 | 2 |
534722 | 534722 | 2020-09-15 | San Juan | Colorado | 8111 | 6 | 0 |
534723 | 534723 | 2020-09-15 | San Miguel | Colorado | 8113 | 93 | 0 |
534724 | 534724 | 2020-09-15 | Sedgwick | Colorado | 8115 | 12 | 1 |
534725 | 534725 | 2020-09-15 | Summit | Colorado | 8117 | 377 | 4 |
534726 | 534726 | 2020-09-15 | Teller | Colorado | 8119 | 168 | 4 |
534727 | 534727 | 2020-09-15 | Washington | Colorado | 8121 | 56 | 0 |
534728 | 534728 | 2020-09-15 | Weld | Colorado | 8123 | 4356 | 149 |
534729 | 534729 | 2020-09-15 | Yuma | Colorado | 8125 | 75 | 0 |
534730 | 534730 | 2020-09-15 | Fairfield | Connecticut | 9001 | 19558 | 1419 |
534731 | 534731 | 2020-09-15 | Hartford | Connecticut | 9003 | 14099 | 1431 |
534732 | 534732 | 2020-09-15 | Litchfield | Connecticut | 9005 | 1798 | 140 |
534733 | 534733 | 2020-09-15 | Middlesex | Connecticut | 9007 | 1527 | 193 |
534734 | 534734 | 2020-09-15 | New Haven | Connecticut | 9009 | 14082 | 1111 |
534735 | 534735 | 2020-09-15 | New London | Connecticut | 9011 | 1682 | 111 |
534736 | 534736 | 2020-09-15 | Tolland | Connecticut | 9013 | 1281 | 65 |
534737 | 534737 | 2020-09-15 | Unknown | Connecticut | 126 | 0 | |
534738 | 534738 | 2020-09-15 | Windham | Connecticut | 9015 | 878 | 15 |
534739 | 534739 | 2020-09-15 | Kent | Delaware | 10001 | 2815 | 113 |
534740 | 534740 | 2020-09-15 | New Castle | Delaware | 10003 | 9262 | 306 |
534741 | 534741 | 2020-09-15 | Sussex | Delaware | 10005 | 6567 | 199 |
534742 | 534742 | 2020-09-15 | Unknown | Delaware | 493 | 0 | |
534743 | 534743 | 2020-09-15 | District of Columbia | District of Columbia | 11001 | 14687 | 616 |
534744 | 534744 | 2020-09-15 | Alachua | Florida | 12001 | 6657 | 42 |
534745 | 534745 | 2020-09-15 | Baker | Florida | 12003 | 1341 | 8 |
534746 | 534746 | 2020-09-15 | Bay | Florida | 12005 | 5719 | 93 |
534747 | 534747 | 2020-09-15 | Bradford | Florida | 12007 | 945 | 6 |
534748 | 534748 | 2020-09-15 | Brevard | Florida | 12009 | 8050 | 263 |
534749 | 534749 | 2020-09-15 | Broward | Florida | 12011 | 74689 | 1288 |
534750 | 534750 | 2020-09-15 | Calhoun | Florida | 12013 | 602 | 9 |
534751 | 534751 | 2020-09-15 | Charlotte | Florida | 12015 | 2881 | 125 |
534752 | 534752 | 2020-09-15 | Citrus | Florida | 12017 | 2493 | 75 |
534753 | 534753 | 2020-09-15 | Clay | Florida | 12019 | 4607 | 88 |
534754 | 534754 | 2020-09-15 | Collier | Florida | 12021 | 12254 | 193 |
534755 | 534755 | 2020-09-15 | Columbia | Florida | 12023 | 3559 | 45 |
534756 | 534756 | 2020-09-15 | DeSoto | Florida | 12027 | 1539 | 23 |
534757 | 534757 | 2020-09-15 | Dixie | Florida | 12029 | 799 | 5 |
534758 | 534758 | 2020-09-15 | Duval | Florida | 12031 | 28632 | 326 |
534759 | 534759 | 2020-09-15 | Escambia | Florida | 12033 | 11944 | 210 |
534760 | 534760 | 2020-09-15 | Flagler | Florida | 12035 | 1589 | 19 |
534761 | 534761 | 2020-09-15 | Franklin | Florida | 12037 | 582 | 3 |
534762 | 534762 | 2020-09-15 | Gadsden | Florida | 12039 | 2625 | 44 |
534763 | 534763 | 2020-09-15 | Gilchrist | Florida | 12041 | 490 | 12 |
534764 | 534764 | 2020-09-15 | Glades | Florida | 12043 | 476 | 4 |
534765 | 534765 | 2020-09-15 | Gulf | Florida | 12045 | 862 | 13 |
534766 | 534766 | 2020-09-15 | Hamilton | Florida | 12047 | 785 | 8 |
534767 | 534767 | 2020-09-15 | Hardee | Florida | 12049 | 1242 | 9 |
534768 | 534768 | 2020-09-15 | Hendry | Florida | 12051 | 2026 | 42 |
534769 | 534769 | 2020-09-15 | Hernando | Florida | 12053 | 2901 | 107 |
534770 | 534770 | 2020-09-15 | Highlands | Florida | 12055 | 2018 | 79 |
534771 | 534771 | 2020-09-15 | Hillsborough | Florida | 12057 | 39751 | 591 |
534772 | 534772 | 2020-09-15 | Holmes | Florida | 12059 | 711 | 5 |
534773 | 534773 | 2020-09-15 | Indian River | Florida | 12061 | 3000 | 107 |
534774 | 534774 | 2020-09-15 | Jackson | Florida | 12063 | 2632 | 73 |
534775 | 534775 | 2020-09-15 | Jefferson | Florida | 12065 | 534 | 8 |
534776 | 534776 | 2020-09-15 | Lafayette | Florida | 12067 | 1222 | 10 |
534777 | 534777 | 2020-09-15 | Lake | Florida | 12069 | 7092 | 156 |
534778 | 534778 | 2020-09-15 | Lee | Florida | 12071 | 19565 | 451 |
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);