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 19,960
- Georgia 15,289
- Virginia 12,025
- Kentucky 10,375
- Missouri 9,464
- North Carolina 9,308
- Illinois 9,036
- Tennessee 8,990
- Indiana 8,866
- Iowa 8,573
- Ohio 8,384
- Mississippi 7,915
- Michigan 7,668
- Minnesota 7,630
- Kansas 7,342
- Arkansas 6,901
- Florida 6,782
- Oklahoma 6,558
- Wisconsin 6,556
- Pennsylvania 6,546
- Louisiana 6,378
- Alabama 6,350
- New York 5,962
- California 5,943
- Colorado 5,810
- Nebraska 5,736
- West Virginia 4,596
- South Carolina 4,578
- South Dakota 4,457
- Puerto Rico 4,282
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
277865 | 277865 | 2020-06-27 | Shasta | California | 6089 | 101 | 5 |
277866 | 277866 | 2020-06-27 | Sierra | California | 6091 | 1 | 0 |
277867 | 277867 | 2020-06-27 | Siskiyou | California | 6093 | 27 | 0 |
277868 | 277868 | 2020-06-27 | Solano | California | 6095 | 1073 | 23 |
277869 | 277869 | 2020-06-27 | Sonoma | California | 6097 | 1092 | 5 |
277870 | 277870 | 2020-06-27 | Stanislaus | California | 6099 | 2157 | 38 |
277871 | 277871 | 2020-06-27 | Sutter | California | 6101 | 152 | 3 |
277872 | 277872 | 2020-06-27 | Tehama | California | 6103 | 63 | 1 |
277873 | 277873 | 2020-06-27 | Trinity | California | 6105 | 3 | 0 |
277874 | 277874 | 2020-06-27 | Tulare | California | 6107 | 3720 | 122 |
277875 | 277875 | 2020-06-27 | Tuolumne | California | 6109 | 22 | 0 |
277876 | 277876 | 2020-06-27 | Ventura | California | 6111 | 2444 | 44 |
277877 | 277877 | 2020-06-27 | Yolo | California | 6113 | 458 | 24 |
277878 | 277878 | 2020-06-27 | Yuba | California | 6115 | 61 | 1 |
277879 | 277879 | 2020-06-27 | Adams | Colorado | 8001 | 4093 | 154 |
277880 | 277880 | 2020-06-27 | Alamosa | Colorado | 8003 | 184 | 3 |
277881 | 277881 | 2020-06-27 | Arapahoe | Colorado | 8005 | 5127 | 342 |
277882 | 277882 | 2020-06-27 | Archuleta | Colorado | 8007 | 8 | 0 |
277883 | 277883 | 2020-06-27 | Baca | Colorado | 8009 | 13 | 0 |
277884 | 277884 | 2020-06-27 | Bent | Colorado | 8011 | 4 | 0 |
277885 | 277885 | 2020-06-27 | Boulder | Colorado | 8013 | 1347 | 71 |
277886 | 277886 | 2020-06-27 | Broomfield | Colorado | 8014 | 291 | 29 |
277887 | 277887 | 2020-06-27 | Chaffee | Colorado | 8015 | 77 | 19 |
277888 | 277888 | 2020-06-27 | Cheyenne | Colorado | 8017 | 5 | 0 |
277889 | 277889 | 2020-06-27 | Clear Creek | Colorado | 8019 | 18 | 1 |
277890 | 277890 | 2020-06-27 | Conejos | Colorado | 8021 | 13 | 0 |
277891 | 277891 | 2020-06-27 | Costilla | Colorado | 8023 | 20 | 0 |
277892 | 277892 | 2020-06-27 | Crowley | Colorado | 8025 | 70 | 1 |
277893 | 277893 | 2020-06-27 | Custer | Colorado | 8027 | 2 | 0 |
277894 | 277894 | 2020-06-27 | Delta | Colorado | 8029 | 82 | 1 |
277895 | 277895 | 2020-06-27 | Denver | Colorado | 8031 | 6947 | 374 |
277896 | 277896 | 2020-06-27 | Douglas | Colorado | 8035 | 922 | 52 |
277897 | 277897 | 2020-06-27 | Eagle | Colorado | 8037 | 685 | 8 |
277898 | 277898 | 2020-06-27 | El Paso | Colorado | 8041 | 2296 | 119 |
277899 | 277899 | 2020-06-27 | Elbert | Colorado | 8039 | 56 | 2 |
277900 | 277900 | 2020-06-27 | Fremont | Colorado | 8043 | 34 | 0 |
277901 | 277901 | 2020-06-27 | Garfield | Colorado | 8045 | 266 | 2 |
277902 | 277902 | 2020-06-27 | Gilpin | Colorado | 8047 | 7 | 0 |
277903 | 277903 | 2020-06-27 | Grand | Colorado | 8049 | 18 | 0 |
277904 | 277904 | 2020-06-27 | Gunnison | Colorado | 8051 | 186 | 6 |
277905 | 277905 | 2020-06-27 | Hinsdale | Colorado | 8053 | 3 | 0 |
277906 | 277906 | 2020-06-27 | Huerfano | Colorado | 8055 | 4 | 0 |
277907 | 277907 | 2020-06-27 | Jackson | Colorado | 8057 | 1 | 0 |
277908 | 277908 | 2020-06-27 | Jefferson | Colorado | 8059 | 2633 | 208 |
277909 | 277909 | 2020-06-27 | Kit Carson | Colorado | 8063 | 31 | 3 |
277910 | 277910 | 2020-06-27 | La Plata | Colorado | 8067 | 94 | 1 |
277911 | 277911 | 2020-06-27 | Lake | Colorado | 8065 | 50 | 0 |
277912 | 277912 | 2020-06-27 | Larimer | Colorado | 8069 | 713 | 29 |
277913 | 277913 | 2020-06-27 | Las Animas | Colorado | 8071 | 7 | 0 |
277914 | 277914 | 2020-06-27 | Lincoln | Colorado | 8073 | 4 | 0 |
277915 | 277915 | 2020-06-27 | Logan | Colorado | 8075 | 636 | 5 |
277916 | 277916 | 2020-06-27 | Mesa | Colorado | 8077 | 89 | 0 |
277917 | 277917 | 2020-06-27 | Mineral | Colorado | 8079 | 5 | 0 |
277918 | 277918 | 2020-06-27 | Moffat | Colorado | 8081 | 10 | 0 |
277919 | 277919 | 2020-06-27 | Montezuma | Colorado | 8083 | 70 | 3 |
277920 | 277920 | 2020-06-27 | Montrose | Colorado | 8085 | 203 | 12 |
277921 | 277921 | 2020-06-27 | Morgan | Colorado | 8087 | 651 | 46 |
277922 | 277922 | 2020-06-27 | Otero | Colorado | 8089 | 22 | 1 |
277923 | 277923 | 2020-06-27 | Ouray | Colorado | 8091 | 10 | 1 |
277924 | 277924 | 2020-06-27 | Park | Colorado | 8093 | 27 | 0 |
277925 | 277925 | 2020-06-27 | Phillips | Colorado | 8095 | 15 | 0 |
277926 | 277926 | 2020-06-27 | Pitkin | Colorado | 8097 | 92 | 2 |
277927 | 277927 | 2020-06-27 | Prowers | Colorado | 8099 | 18 | 0 |
277928 | 277928 | 2020-06-27 | Pueblo | Colorado | 8101 | 378 | 28 |
277929 | 277929 | 2020-06-27 | Rio Blanco | Colorado | 8103 | 3 | 0 |
277930 | 277930 | 2020-06-27 | Rio Grande | Colorado | 8105 | 73 | 2 |
277931 | 277931 | 2020-06-27 | Routt | Colorado | 8107 | 71 | 6 |
277932 | 277932 | 2020-06-27 | Saguache | Colorado | 8109 | 100 | 2 |
277933 | 277933 | 2020-06-27 | San Juan | Colorado | 8111 | 1 | 0 |
277934 | 277934 | 2020-06-27 | San Miguel | Colorado | 8113 | 35 | 0 |
277935 | 277935 | 2020-06-27 | Summit | Colorado | 8117 | 267 | 3 |
277936 | 277936 | 2020-06-27 | Teller | Colorado | 8119 | 41 | 2 |
277937 | 277937 | 2020-06-27 | Washington | Colorado | 8121 | 44 | 0 |
277938 | 277938 | 2020-06-27 | Weld | Colorado | 8123 | 2783 | 136 |
277939 | 277939 | 2020-06-27 | Yuma | Colorado | 8125 | 51 | 0 |
277940 | 277940 | 2020-06-27 | Fairfield | Connecticut | 9001 | 16606 | 1375 |
277941 | 277941 | 2020-06-27 | Hartford | Connecticut | 9003 | 11558 | 1369 |
277942 | 277942 | 2020-06-27 | Litchfield | Connecticut | 9005 | 1482 | 136 |
277943 | 277943 | 2020-06-27 | Middlesex | Connecticut | 9007 | 1287 | 182 |
277944 | 277944 | 2020-06-27 | New Haven | Connecticut | 9009 | 12275 | 1069 |
277945 | 277945 | 2020-06-27 | New London | Connecticut | 9011 | 1241 | 102 |
277946 | 277946 | 2020-06-27 | Tolland | Connecticut | 9013 | 906 | 64 |
277947 | 277947 | 2020-06-27 | Unknown | Connecticut | 252 | 0 | |
277948 | 277948 | 2020-06-27 | Windham | Connecticut | 9015 | 599 | 14 |
277949 | 277949 | 2020-06-27 | Kent | Delaware | 10001 | 1652 | 89 |
277950 | 277950 | 2020-06-27 | New Castle | Delaware | 10003 | 4871 | 242 |
277951 | 277951 | 2020-06-27 | Sussex | Delaware | 10005 | 4542 | 176 |
277952 | 277952 | 2020-06-27 | Unknown | Delaware | 26 | 0 | |
277953 | 277953 | 2020-06-27 | District of Columbia | District of Columbia | 11001 | 10216 | 548 |
277954 | 277954 | 2020-06-27 | Alachua | Florida | 12001 | 1033 | 12 |
277955 | 277955 | 2020-06-27 | Baker | Florida | 12003 | 51 | 4 |
277956 | 277956 | 2020-06-27 | Bay | Florida | 12005 | 305 | 4 |
277957 | 277957 | 2020-06-27 | Bradford | Florida | 12007 | 80 | 2 |
277958 | 277958 | 2020-06-27 | Brevard | Florida | 12009 | 1547 | 17 |
277959 | 277959 | 2020-06-27 | Broward | Florida | 12011 | 14046 | 382 |
277960 | 277960 | 2020-06-27 | Calhoun | Florida | 12013 | 72 | 6 |
277961 | 277961 | 2020-06-27 | Charlotte | Florida | 12015 | 687 | 76 |
277962 | 277962 | 2020-06-27 | Citrus | Florida | 12017 | 264 | 12 |
277963 | 277963 | 2020-06-27 | Clay | Florida | 12019 | 616 | 34 |
277964 | 277964 | 2020-06-27 | Collier | Florida | 12021 | 3966 | 70 |
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);