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 80,464
- Georgia 53,689
- Virginia 43,935
- Kentucky 39,172
- Missouri 37,534
- Illinois 33,667
- North Carolina 33,309
- Iowa 32,570
- Kansas 32,479
- Tennessee 31,999
- Indiana 30,946
- Ohio 29,506
- Minnesota 28,723
- Michigan 27,822
- Mississippi 27,600
- Nebraska 27,512
- Oklahoma 25,214
- Arkansas 25,136
- Wisconsin 23,951
- Puerto Rico 23,242
- Florida 23,102
- Pennsylvania 22,626
- Alabama 22,430
- Louisiana 21,978
- Colorado 21,047
- South Dakota 20,182
- New York 19,882
- California 19,861
- West Virginia 17,761
- North Dakota 16,469
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053706 | 1053706 | 2021-02-22 | Kern | California | 6029 | 101849 | 783 |
1053707 | 1053707 | 2021-02-22 | Kings | California | 6031 | 21881 | 216 |
1053708 | 1053708 | 2021-02-22 | Lake | California | 6033 | 3100 | 40 |
1053709 | 1053709 | 2021-02-22 | Lassen | California | 6035 | 5591 | 19 |
1053710 | 1053710 | 2021-02-22 | Los Angeles | California | 6037 | 1181994 | 19904 |
1053711 | 1053711 | 2021-02-22 | Madera | California | 6039 | 15298 | 201 |
1053712 | 1053712 | 2021-02-22 | Marin | California | 6041 | 12968 | 195 |
1053713 | 1053713 | 2021-02-22 | Mariposa | California | 6043 | 393 | 7 |
1053714 | 1053714 | 2021-02-22 | Mendocino | California | 6045 | 3786 | 43 |
1053715 | 1053715 | 2021-02-22 | Merced | California | 6047 | 28655 | 391 |
1053716 | 1053716 | 2021-02-22 | Modoc | California | 6049 | 446 | 4 |
1053717 | 1053717 | 2021-02-22 | Mono | California | 6051 | 1189 | 4 |
1053718 | 1053718 | 2021-02-22 | Monterey | California | 6053 | 41884 | 315 |
1053719 | 1053719 | 2021-02-22 | Napa | California | 6055 | 8930 | 67 |
1053720 | 1053720 | 2021-02-22 | Nevada | California | 6057 | 3899 | 74 |
1053721 | 1053721 | 2021-02-22 | Orange | California | 6059 | 259581 | 3848 |
1053722 | 1053722 | 2021-02-22 | Placer | California | 6061 | 19646 | 230 |
1053723 | 1053723 | 2021-02-22 | Plumas | California | 6063 | 625 | 6 |
1053724 | 1053724 | 2021-02-22 | Riverside | California | 6065 | 287822 | 3664 |
1053725 | 1053725 | 2021-02-22 | Sacramento | California | 6067 | 92427 | 1438 |
1053726 | 1053726 | 2021-02-22 | San Benito | California | 6069 | 5716 | 57 |
1053727 | 1053727 | 2021-02-22 | San Bernardino | California | 6071 | 284866 | 2637 |
1053728 | 1053728 | 2021-02-22 | San Diego | California | 6073 | 257414 | 3190 |
1053729 | 1053729 | 2021-02-22 | San Francisco | California | 6075 | 33894 | 394 |
1053730 | 1053730 | 2021-02-22 | San Joaquin | California | 6077 | 66046 | 1039 |
1053731 | 1053731 | 2021-02-22 | San Luis Obispo | California | 6079 | 19458 | 220 |
1053732 | 1053732 | 2021-02-22 | San Mateo | California | 6081 | 38448 | 497 |
1053733 | 1053733 | 2021-02-22 | Santa Barbara | California | 6083 | 31567 | 396 |
1053734 | 1053734 | 2021-02-22 | Santa Clara | California | 6085 | 109276 | 1737 |
1053735 | 1053735 | 2021-02-22 | Santa Cruz | California | 6087 | 14495 | 172 |
1053736 | 1053736 | 2021-02-22 | Shasta | California | 6089 | 10868 | 172 |
1053737 | 1053737 | 2021-02-22 | Sierra | California | 6091 | 47 | 0 |
1053738 | 1053738 | 2021-02-22 | Siskiyou | California | 6093 | 1716 | 13 |
1053739 | 1053739 | 2021-02-22 | Solano | California | 6095 | 29864 | 161 |
1053740 | 1053740 | 2021-02-22 | Sonoma | California | 6097 | 27793 | 295 |
1053741 | 1053741 | 2021-02-22 | Stanislaus | California | 6099 | 55347 | 931 |
1053742 | 1053742 | 2021-02-22 | Sutter | California | 6101 | 8802 | 96 |
1053743 | 1053743 | 2021-02-22 | Tehama | California | 6103 | 4547 | 52 |
1053744 | 1053744 | 2021-02-22 | Trinity | California | 6105 | 287 | 5 |
1053745 | 1053745 | 2021-02-22 | Tulare | California | 6107 | 47562 | 722 |
1053746 | 1053746 | 2021-02-22 | Tuolumne | California | 6109 | 3914 | 59 |
1053747 | 1053747 | 2021-02-22 | Ventura | California | 6111 | 76862 | 794 |
1053748 | 1053748 | 2021-02-22 | Yolo | California | 6113 | 12670 | 181 |
1053749 | 1053749 | 2021-02-22 | Yuba | California | 6115 | 5711 | 36 |
1053750 | 1053750 | 2021-02-22 | Adams | Colorado | 8001 | 48712 | 627 |
1053751 | 1053751 | 2021-02-22 | Alamosa | Colorado | 8003 | 1255 | 28 |
1053752 | 1053752 | 2021-02-22 | Arapahoe | Colorado | 8005 | 48730 | 688 |
1053753 | 1053753 | 2021-02-22 | Archuleta | Colorado | 8007 | 630 | 1 |
1053754 | 1053754 | 2021-02-22 | Baca | Colorado | 8009 | 270 | 4 |
1053755 | 1053755 | 2021-02-22 | Bent | Colorado | 8011 | 1468 | 21 |
1053756 | 1053756 | 2021-02-22 | Boulder | Colorado | 8013 | 18633 | 245 |
1053757 | 1053757 | 2021-02-22 | Broomfield | Colorado | 8014 | 3665 | 74 |
1053758 | 1053758 | 2021-02-22 | Chaffee | Colorado | 8015 | 1411 | 23 |
1053759 | 1053759 | 2021-02-22 | Cheyenne | Colorado | 8017 | 125 | 5 |
1053760 | 1053760 | 2021-02-22 | Clear Creek | Colorado | 8019 | 359 | 2 |
1053761 | 1053761 | 2021-02-22 | Conejos | Colorado | 8021 | 433 | 7 |
1053762 | 1053762 | 2021-02-22 | Costilla | Colorado | 8023 | 182 | 2 |
1053763 | 1053763 | 2021-02-22 | Crowley | Colorado | 8025 | 1959 | 14 |
1053764 | 1053764 | 2021-02-22 | Custer | Colorado | 8027 | 164 | 1 |
1053765 | 1053765 | 2021-02-22 | Delta | Colorado | 8029 | 2444 | 58 |
1053766 | 1053766 | 2021-02-22 | Denver | Colorado | 8031 | 58688 | 766 |
1053767 | 1053767 | 2021-02-22 | Dolores | Colorado | 8033 | 67 | 0 |
1053768 | 1053768 | 2021-02-22 | Douglas | Colorado | 8035 | 21347 | 230 |
1053769 | 1053769 | 2021-02-22 | Eagle | Colorado | 8037 | 4907 | 20 |
1053770 | 1053770 | 2021-02-22 | El Paso | Colorado | 8041 | 51145 | 742 |
1053771 | 1053771 | 2021-02-22 | Elbert | Colorado | 8039 | 1257 | 12 |
1053772 | 1053772 | 2021-02-22 | Fremont | Colorado | 8043 | 5418 | 48 |
1053773 | 1053773 | 2021-02-22 | Garfield | Colorado | 8045 | 5026 | 38 |
1053774 | 1053774 | 2021-02-22 | Gilpin | Colorado | 8047 | 165 | 3 |
1053775 | 1053775 | 2021-02-22 | Grand | Colorado | 8049 | 1242 | 5 |
1053776 | 1053776 | 2021-02-22 | Gunnison | Colorado | 8051 | 1182 | 6 |
1053777 | 1053777 | 2021-02-22 | Hinsdale | Colorado | 8053 | 16 | 0 |
1053778 | 1053778 | 2021-02-22 | Huerfano | Colorado | 8055 | 300 | 17 |
1053779 | 1053779 | 2021-02-22 | Jackson | Colorado | 8057 | 51 | 0 |
1053780 | 1053780 | 2021-02-22 | Jefferson | Colorado | 8059 | 36588 | 706 |
1053781 | 1053781 | 2021-02-22 | Kiowa | Colorado | 8061 | 91 | 3 |
1053782 | 1053782 | 2021-02-22 | Kit Carson | Colorado | 8063 | 524 | 10 |
1053783 | 1053783 | 2021-02-22 | La Plata | Colorado | 8067 | 2890 | 37 |
1053784 | 1053784 | 2021-02-22 | Lake | Colorado | 8065 | 651 | 0 |
1053785 | 1053785 | 2021-02-22 | Larimer | Colorado | 8069 | 19594 | 219 |
1053786 | 1053786 | 2021-02-22 | Las Animas | Colorado | 8071 | 982 | 11 |
1053787 | 1053787 | 2021-02-22 | Lincoln | Colorado | 8073 | 996 | 3 |
1053788 | 1053788 | 2021-02-22 | Logan | Colorado | 8075 | 3705 | 63 |
1053789 | 1053789 | 2021-02-22 | Mesa | Colorado | 8077 | 13097 | 190 |
1053790 | 1053790 | 2021-02-22 | Mineral | Colorado | 8079 | 61 | 1 |
1053791 | 1053791 | 2021-02-22 | Moffat | Colorado | 8081 | 657 | 22 |
1053792 | 1053792 | 2021-02-22 | Montezuma | Colorado | 8083 | 1708 | 22 |
1053793 | 1053793 | 2021-02-22 | Montrose | Colorado | 8085 | 3195 | 52 |
1053794 | 1053794 | 2021-02-22 | Morgan | Colorado | 8087 | 2415 | 90 |
1053795 | 1053795 | 2021-02-22 | Otero | Colorado | 8089 | 1840 | 61 |
1053796 | 1053796 | 2021-02-22 | Ouray | Colorado | 8091 | 247 | 3 |
1053797 | 1053797 | 2021-02-22 | Park | Colorado | 8093 | 540 | 5 |
1053798 | 1053798 | 2021-02-22 | Phillips | Colorado | 8095 | 333 | 12 |
1053799 | 1053799 | 2021-02-22 | Pitkin | Colorado | 8097 | 1947 | 4 |
1053800 | 1053800 | 2021-02-22 | Prowers | Colorado | 8099 | 1157 | 21 |
1053801 | 1053801 | 2021-02-22 | Pueblo | Colorado | 8101 | 14881 | 362 |
1053802 | 1053802 | 2021-02-22 | Rio Blanco | Colorado | 8103 | 455 | 3 |
1053803 | 1053803 | 2021-02-22 | Rio Grande | Colorado | 8105 | 685 | 12 |
1053804 | 1053804 | 2021-02-22 | Routt | Colorado | 8107 | 1832 | 19 |
1053805 | 1053805 | 2021-02-22 | Saguache | Colorado | 8109 | 313 | 4 |
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);