ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where "date" is on date 2020-09-16 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537903 | 537903 | 2020-09-16 | Adams | Colorado | 8001 | 8260 | 213 |
537904 | 537904 | 2020-09-16 | Alamosa | Colorado | 8003 | 241 | 9 |
537905 | 537905 | 2020-09-16 | Arapahoe | Colorado | 8005 | 8792 | 370 |
537906 | 537906 | 2020-09-16 | Archuleta | Colorado | 8007 | 48 | 0 |
537907 | 537907 | 2020-09-16 | Baca | Colorado | 8009 | 17 | 0 |
537908 | 537908 | 2020-09-16 | Bent | Colorado | 8011 | 11 | 0 |
537909 | 537909 | 2020-09-16 | Boulder | Colorado | 8013 | 3060 | 79 |
537910 | 537910 | 2020-09-16 | Broomfield | Colorado | 8014 | 578 | 33 |
537911 | 537911 | 2020-09-16 | Chaffee | Colorado | 8015 | 319 | 19 |
537912 | 537912 | 2020-09-16 | Cheyenne | Colorado | 8017 | 11 | 0 |
537913 | 537913 | 2020-09-16 | Clear Creek | Colorado | 8019 | 36 | 1 |
537914 | 537914 | 2020-09-16 | Conejos | Colorado | 8021 | 31 | 0 |
537915 | 537915 | 2020-09-16 | Costilla | Colorado | 8023 | 32 | 1 |
537916 | 537916 | 2020-09-16 | Crowley | Colorado | 8025 | 73 | 1 |
537917 | 537917 | 2020-09-16 | Custer | Colorado | 8027 | 17 | 0 |
537918 | 537918 | 2020-09-16 | Delta | Colorado | 8029 | 177 | 3 |
537919 | 537919 | 2020-09-16 | Denver | Colorado | 8031 | 12055 | 437 |
537920 | 537920 | 2020-09-16 | Dolores | Colorado | 8033 | 3 | 0 |
537921 | 537921 | 2020-09-16 | Douglas | Colorado | 8035 | 2370 | 60 |
537922 | 537922 | 2020-09-16 | Eagle | Colorado | 8037 | 1221 | 9 |
537923 | 537923 | 2020-09-16 | El Paso | Colorado | 8041 | 6574 | 165 |
537924 | 537924 | 2020-09-16 | Elbert | Colorado | 8039 | 144 | 3 |
537925 | 537925 | 2020-09-16 | Fremont | Colorado | 8043 | 167 | 1 |
537926 | 537926 | 2020-09-16 | Garfield | Colorado | 8045 | 906 | 5 |
537927 | 537927 | 2020-09-16 | Gilpin | Colorado | 8047 | 18 | 0 |
537928 | 537928 | 2020-09-16 | Grand | Colorado | 8049 | 71 | 1 |
537929 | 537929 | 2020-09-16 | Gunnison | Colorado | 8051 | 296 | 7 |
537930 | 537930 | 2020-09-16 | Hinsdale | Colorado | 8053 | 3 | 0 |
537931 | 537931 | 2020-09-16 | Huerfano | Colorado | 8055 | 12 | 1 |
537932 | 537932 | 2020-09-16 | Jackson | Colorado | 8057 | 9 | 0 |
537933 | 537933 | 2020-09-16 | Jefferson | Colorado | 8059 | 5194 | 247 |
537934 | 537934 | 2020-09-16 | Kit Carson | Colorado | 8063 | 78 | 3 |
537935 | 537935 | 2020-09-16 | La Plata | Colorado | 8067 | 248 | 2 |
537936 | 537936 | 2020-09-16 | Lake | Colorado | 8065 | 87 | 0 |
537937 | 537937 | 2020-09-16 | Larimer | Colorado | 8069 | 2236 | 48 |
537938 | 537938 | 2020-09-16 | Las Animas | Colorado | 8071 | 21 | 0 |
537939 | 537939 | 2020-09-16 | Lincoln | Colorado | 8073 | 8 | 0 |
537940 | 537940 | 2020-09-16 | Logan | Colorado | 8075 | 800 | 5 |
537941 | 537941 | 2020-09-16 | Mesa | Colorado | 8077 | 503 | 6 |
537942 | 537942 | 2020-09-16 | Mineral | Colorado | 8079 | 20 | 0 |
537943 | 537943 | 2020-09-16 | Moffat | Colorado | 8081 | 37 | 1 |
537944 | 537944 | 2020-09-16 | Montezuma | Colorado | 8083 | 128 | 5 |
537945 | 537945 | 2020-09-16 | Montrose | Colorado | 8085 | 359 | 13 |
537946 | 537946 | 2020-09-16 | Morgan | Colorado | 8087 | 727 | 48 |
537947 | 537947 | 2020-09-16 | Otero | Colorado | 8089 | 86 | 6 |
537948 | 537948 | 2020-09-16 | Ouray | Colorado | 8091 | 25 | 1 |
537949 | 537949 | 2020-09-16 | Park | Colorado | 8093 | 46 | 1 |
537950 | 537950 | 2020-09-16 | Phillips | Colorado | 8095 | 33 | 0 |
537951 | 537951 | 2020-09-16 | Pitkin | Colorado | 8097 | 213 | 2 |
537952 | 537952 | 2020-09-16 | Prowers | Colorado | 8099 | 92 | 0 |
537953 | 537953 | 2020-09-16 | Pueblo | Colorado | 8101 | 1001 | 34 |
537954 | 537954 | 2020-09-16 | Rio Blanco | Colorado | 8103 | 24 | 0 |
537955 | 537955 | 2020-09-16 | Rio Grande | Colorado | 8105 | 95 | 2 |
537956 | 537956 | 2020-09-16 | Routt | Colorado | 8107 | 139 | 8 |
537957 | 537957 | 2020-09-16 | Saguache | Colorado | 8109 | 111 | 2 |
537958 | 537958 | 2020-09-16 | San Juan | Colorado | 8111 | 6 | 0 |
537959 | 537959 | 2020-09-16 | San Miguel | Colorado | 8113 | 94 | 0 |
537960 | 537960 | 2020-09-16 | Sedgwick | Colorado | 8115 | 12 | 1 |
537961 | 537961 | 2020-09-16 | Summit | Colorado | 8117 | 391 | 4 |
537962 | 537962 | 2020-09-16 | Teller | Colorado | 8119 | 169 | 4 |
537963 | 537963 | 2020-09-16 | Washington | Colorado | 8121 | 56 | 0 |
537964 | 537964 | 2020-09-16 | Weld | Colorado | 8123 | 4401 | 149 |
537965 | 537965 | 2020-09-16 | Yuma | Colorado | 8125 | 76 | 0 |
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);