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,476
- Georgia 32,889
- Virginia 26,645
- Kentucky 23,572
- Missouri 22,324
- Illinois 20,361
- North Carolina 20,308
- Iowa 19,570
- Tennessee 19,532
- Indiana 18,986
- Kansas 18,703
- Ohio 18,066
- Minnesota 17,283
- Mississippi 16,939
- Michigan 16,902
- Nebraska 15,404
- Arkansas 15,256
- Oklahoma 15,074
- Wisconsin 14,586
- Florida 14,262
- Pennsylvania 13,916
- Alabama 13,720
- Louisiana 13,528
- Puerto Rico 12,972
- Colorado 12,727
- New York 12,342
- California 12,293
- South Dakota 11,602
- West Virginia 10,611
- South Carolina 9,641
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631867 | 631867 | 2020-10-15 | Santa Clara | California | 6085 | 22859 | 368 |
631868 | 631868 | 2020-10-15 | Santa Cruz | California | 6087 | 2670 | 23 |
631869 | 631869 | 2020-10-15 | Shasta | California | 6089 | 1640 | 28 |
631870 | 631870 | 2020-10-15 | Sierra | California | 6091 | 6 | 0 |
631871 | 631871 | 2020-10-15 | Siskiyou | California | 6093 | 183 | 0 |
631872 | 631872 | 2020-10-15 | Solano | California | 6095 | 6956 | 74 |
631873 | 631873 | 2020-10-15 | Sonoma | California | 6097 | 8684 | 128 |
631874 | 631874 | 2020-10-15 | Stanislaus | California | 6099 | 17160 | 389 |
631875 | 631875 | 2020-10-15 | Sutter | California | 6101 | 1793 | 12 |
631876 | 631876 | 2020-10-15 | Tehama | California | 6103 | 721 | 8 |
631877 | 631877 | 2020-10-15 | Trinity | California | 6105 | 21 | 0 |
631878 | 631878 | 2020-10-15 | Tulare | California | 6107 | 17072 | 274 |
631879 | 631879 | 2020-10-15 | Tuolumne | California | 6109 | 244 | 4 |
631880 | 631880 | 2020-10-15 | Ventura | California | 6111 | 13697 | 159 |
631881 | 631881 | 2020-10-15 | Yolo | California | 6113 | 3015 | 56 |
631882 | 631882 | 2020-10-15 | Yuba | California | 6115 | 1246 | 10 |
631883 | 631883 | 2020-10-15 | Adams | Colorado | 8001 | 11340 | 245 |
631884 | 631884 | 2020-10-15 | Alamosa | Colorado | 8003 | 271 | 9 |
631885 | 631885 | 2020-10-15 | Arapahoe | Colorado | 8005 | 10916 | 390 |
631886 | 631886 | 2020-10-15 | Archuleta | Colorado | 8007 | 58 | 0 |
631887 | 631887 | 2020-10-15 | Baca | Colorado | 8009 | 23 | 0 |
631888 | 631888 | 2020-10-15 | Bent | Colorado | 8011 | 12 | 0 |
631889 | 631889 | 2020-10-15 | Boulder | Colorado | 8013 | 4954 | 83 |
631890 | 631890 | 2020-10-15 | Broomfield | Colorado | 8014 | 763 | 37 |
631891 | 631891 | 2020-10-15 | Chaffee | Colorado | 8015 | 358 | 20 |
631892 | 631892 | 2020-10-15 | Cheyenne | Colorado | 8017 | 14 | 0 |
631893 | 631893 | 2020-10-15 | Clear Creek | Colorado | 8019 | 61 | 1 |
631894 | 631894 | 2020-10-15 | Conejos | Colorado | 8021 | 44 | 0 |
631895 | 631895 | 2020-10-15 | Costilla | Colorado | 8023 | 34 | 1 |
631896 | 631896 | 2020-10-15 | Crowley | Colorado | 8025 | 78 | 1 |
631897 | 631897 | 2020-10-15 | Custer | Colorado | 8027 | 19 | 0 |
631898 | 631898 | 2020-10-15 | Delta | Colorado | 8029 | 194 | 4 |
631899 | 631899 | 2020-10-15 | Denver | Colorado | 8031 | 15466 | 449 |
631900 | 631900 | 2020-10-15 | Dolores | Colorado | 8033 | 3 | 0 |
631901 | 631901 | 2020-10-15 | Douglas | Colorado | 8035 | 3297 | 63 |
631902 | 631902 | 2020-10-15 | Eagle | Colorado | 8037 | 1335 | 10 |
631903 | 631903 | 2020-10-15 | El Paso | Colorado | 8041 | 8182 | 188 |
631904 | 631904 | 2020-10-15 | Elbert | Colorado | 8039 | 177 | 3 |
631905 | 631905 | 2020-10-15 | Fremont | Colorado | 8043 | 310 | 1 |
631906 | 631906 | 2020-10-15 | Garfield | Colorado | 8045 | 1047 | 5 |
631907 | 631907 | 2020-10-15 | Gilpin | Colorado | 8047 | 21 | 0 |
631908 | 631908 | 2020-10-15 | Grand | Colorado | 8049 | 123 | 1 |
631909 | 631909 | 2020-10-15 | Gunnison | Colorado | 8051 | 296 | 7 |
631910 | 631910 | 2020-10-15 | Hinsdale | Colorado | 8053 | 3 | 0 |
631911 | 631911 | 2020-10-15 | Huerfano | Colorado | 8055 | 27 | 2 |
631912 | 631912 | 2020-10-15 | Jackson | Colorado | 8057 | 9 | 0 |
631913 | 631913 | 2020-10-15 | Jefferson | Colorado | 8059 | 6887 | 296 |
631914 | 631914 | 2020-10-15 | Kiowa | Colorado | 8061 | 2 | 0 |
631915 | 631915 | 2020-10-15 | Kit Carson | Colorado | 8063 | 98 | 3 |
631916 | 631916 | 2020-10-15 | La Plata | Colorado | 8067 | 305 | 2 |
631917 | 631917 | 2020-10-15 | Lake | Colorado | 8065 | 114 | 0 |
631918 | 631918 | 2020-10-15 | Larimer | Colorado | 8069 | 3327 | 55 |
631919 | 631919 | 2020-10-15 | Las Animas | Colorado | 8071 | 31 | 0 |
631920 | 631920 | 2020-10-15 | Lincoln | Colorado | 8073 | 24 | 0 |
631921 | 631921 | 2020-10-15 | Logan | Colorado | 8075 | 1038 | 10 |
631922 | 631922 | 2020-10-15 | Mesa | Colorado | 8077 | 847 | 8 |
631923 | 631923 | 2020-10-15 | Mineral | Colorado | 8079 | 21 | 0 |
631924 | 631924 | 2020-10-15 | Moffat | Colorado | 8081 | 49 | 1 |
631925 | 631925 | 2020-10-15 | Montezuma | Colorado | 8083 | 173 | 5 |
631926 | 631926 | 2020-10-15 | Montrose | Colorado | 8085 | 412 | 13 |
631927 | 631927 | 2020-10-15 | Morgan | Colorado | 8087 | 800 | 48 |
631928 | 631928 | 2020-10-15 | Otero | Colorado | 8089 | 114 | 6 |
631929 | 631929 | 2020-10-15 | Ouray | Colorado | 8091 | 32 | 1 |
631930 | 631930 | 2020-10-15 | Park | Colorado | 8093 | 65 | 1 |
631931 | 631931 | 2020-10-15 | Phillips | Colorado | 8095 | 35 | 0 |
631932 | 631932 | 2020-10-15 | Pitkin | Colorado | 8097 | 253 | 2 |
631933 | 631933 | 2020-10-15 | Prowers | Colorado | 8099 | 102 | 0 |
631934 | 631934 | 2020-10-15 | Pueblo | Colorado | 8101 | 1492 | 39 |
631935 | 631935 | 2020-10-15 | Rio Blanco | Colorado | 8103 | 25 | 0 |
631936 | 631936 | 2020-10-15 | Rio Grande | Colorado | 8105 | 112 | 2 |
631937 | 631937 | 2020-10-15 | Routt | Colorado | 8107 | 175 | 8 |
631938 | 631938 | 2020-10-15 | Saguache | Colorado | 8109 | 117 | 2 |
631939 | 631939 | 2020-10-15 | San Juan | Colorado | 8111 | 6 | 0 |
631940 | 631940 | 2020-10-15 | San Miguel | Colorado | 8113 | 99 | 0 |
631941 | 631941 | 2020-10-15 | Sedgwick | Colorado | 8115 | 16 | 1 |
631942 | 631942 | 2020-10-15 | Summit | Colorado | 8117 | 537 | 4 |
631943 | 631943 | 2020-10-15 | Teller | Colorado | 8119 | 186 | 4 |
631944 | 631944 | 2020-10-15 | Washington | Colorado | 8121 | 77 | 0 |
631945 | 631945 | 2020-10-15 | Weld | Colorado | 8123 | 5264 | 155 |
631946 | 631946 | 2020-10-15 | Yuma | Colorado | 8125 | 173 | 1 |
631947 | 631947 | 2020-10-15 | Fairfield | Connecticut | 9001 | 21183 | 1427 |
631948 | 631948 | 2020-10-15 | Hartford | Connecticut | 9003 | 16058 | 1445 |
631949 | 631949 | 2020-10-15 | Litchfield | Connecticut | 9005 | 1959 | 143 |
631950 | 631950 | 2020-10-15 | Middlesex | Connecticut | 9007 | 1733 | 193 |
631951 | 631951 | 2020-10-15 | New Haven | Connecticut | 9009 | 15310 | 1119 |
631952 | 631952 | 2020-10-15 | New London | Connecticut | 9011 | 2924 | 129 |
631953 | 631953 | 2020-10-15 | Tolland | Connecticut | 9013 | 1539 | 67 |
631954 | 631954 | 2020-10-15 | Unknown | Connecticut | 129 | 0 | |
631955 | 631955 | 2020-10-15 | Windham | Connecticut | 9015 | 1193 | 17 |
631956 | 631956 | 2020-10-15 | Kent | Delaware | 10001 | 3272 | 119 |
631957 | 631957 | 2020-10-15 | New Castle | Delaware | 10003 | 11851 | 330 |
631958 | 631958 | 2020-10-15 | Sussex | Delaware | 10005 | 7346 | 212 |
631959 | 631959 | 2020-10-15 | Unknown | Delaware | 91 | 0 | |
631960 | 631960 | 2020-10-15 | District of Columbia | District of Columbia | 11001 | 16166 | 638 |
631961 | 631961 | 2020-10-15 | Alachua | Florida | 12001 | 9190 | 70 |
631962 | 631962 | 2020-10-15 | Baker | Florida | 12003 | 1655 | 17 |
631963 | 631963 | 2020-10-15 | Bay | Florida | 12005 | 6394 | 125 |
631964 | 631964 | 2020-10-15 | Bradford | Florida | 12007 | 1194 | 11 |
631965 | 631965 | 2020-10-15 | Brevard | Florida | 12009 | 10183 | 337 |
631966 | 631966 | 2020-10-15 | Broward | Florida | 12011 | 80112 | 1492 |
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);