ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where "date" is on date 2021-01-26 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
966117 | 966117 | 2021-01-26 | Adams | Colorado | 8001 | 45750 | 590 |
966118 | 966118 | 2021-01-26 | Alamosa | Colorado | 8003 | 1127 | 27 |
966119 | 966119 | 2021-01-26 | Arapahoe | Colorado | 8005 | 44857 | 647 |
966120 | 966120 | 2021-01-26 | Archuleta | Colorado | 8007 | 599 | 1 |
966121 | 966121 | 2021-01-26 | Baca | Colorado | 8009 | 262 | 3 |
966122 | 966122 | 2021-01-26 | Bent | Colorado | 8011 | 1285 | 20 |
966123 | 966123 | 2021-01-26 | Boulder | Colorado | 8013 | 16956 | 229 |
966124 | 966124 | 2021-01-26 | Broomfield | Colorado | 8014 | 3332 | 69 |
966125 | 966125 | 2021-01-26 | Chaffee | Colorado | 8015 | 1271 | 23 |
966126 | 966126 | 2021-01-26 | Cheyenne | Colorado | 8017 | 115 | 5 |
966127 | 966127 | 2021-01-26 | Clear Creek | Colorado | 8019 | 340 | 2 |
966128 | 966128 | 2021-01-26 | Conejos | Colorado | 8021 | 397 | 3 |
966129 | 966129 | 2021-01-26 | Costilla | Colorado | 8023 | 176 | 2 |
966130 | 966130 | 2021-01-26 | Crowley | Colorado | 8025 | 1766 | 14 |
966131 | 966131 | 2021-01-26 | Custer | Colorado | 8027 | 159 | 1 |
966132 | 966132 | 2021-01-26 | Delta | Colorado | 8029 | 2277 | 48 |
966133 | 966133 | 2021-01-26 | Denver | Colorado | 8031 | 54812 | 736 |
966134 | 966134 | 2021-01-26 | Dolores | Colorado | 8033 | 62 | 0 |
966135 | 966135 | 2021-01-26 | Douglas | Colorado | 8035 | 18861 | 225 |
966136 | 966136 | 2021-01-26 | Eagle | Colorado | 8037 | 4268 | 18 |
966137 | 966137 | 2021-01-26 | El Paso | Colorado | 8041 | 47195 | 684 |
966138 | 966138 | 2021-01-26 | Elbert | Colorado | 8039 | 1123 | 12 |
966139 | 966139 | 2021-01-26 | Fremont | Colorado | 8043 | 5078 | 35 |
966140 | 966140 | 2021-01-26 | Garfield | Colorado | 8045 | 4712 | 36 |
966141 | 966141 | 2021-01-26 | Gilpin | Colorado | 8047 | 145 | 2 |
966142 | 966142 | 2021-01-26 | Grand | Colorado | 8049 | 908 | 5 |
966143 | 966143 | 2021-01-26 | Gunnison | Colorado | 8051 | 1014 | 6 |
966144 | 966144 | 2021-01-26 | Hinsdale | Colorado | 8053 | 15 | 0 |
966145 | 966145 | 2021-01-26 | Huerfano | Colorado | 8055 | 288 | 17 |
966146 | 966146 | 2021-01-26 | Jackson | Colorado | 8057 | 44 | 0 |
966147 | 966147 | 2021-01-26 | Jefferson | Colorado | 8059 | 33960 | 679 |
966148 | 966148 | 2021-01-26 | Kiowa | Colorado | 8061 | 85 | 3 |
966149 | 966149 | 2021-01-26 | Kit Carson | Colorado | 8063 | 500 | 10 |
966150 | 966150 | 2021-01-26 | La Plata | Colorado | 8067 | 2658 | 33 |
966151 | 966151 | 2021-01-26 | Lake | Colorado | 8065 | 495 | 0 |
966152 | 966152 | 2021-01-26 | Larimer | Colorado | 8069 | 17637 | 182 |
966153 | 966153 | 2021-01-26 | Las Animas | Colorado | 8071 | 902 | 11 |
966154 | 966154 | 2021-01-26 | Lincoln | Colorado | 8073 | 885 | 3 |
966155 | 966155 | 2021-01-26 | Logan | Colorado | 8075 | 3583 | 58 |
966156 | 966156 | 2021-01-26 | Mesa | Colorado | 8077 | 11681 | 163 |
966157 | 966157 | 2021-01-26 | Mineral | Colorado | 8079 | 57 | 1 |
966158 | 966158 | 2021-01-26 | Moffat | Colorado | 8081 | 614 | 22 |
966159 | 966159 | 2021-01-26 | Montezuma | Colorado | 8083 | 1604 | 21 |
966160 | 966160 | 2021-01-26 | Montrose | Colorado | 8085 | 2918 | 42 |
966161 | 966161 | 2021-01-26 | Morgan | Colorado | 8087 | 2342 | 88 |
966162 | 966162 | 2021-01-26 | Otero | Colorado | 8089 | 1781 | 57 |
966163 | 966163 | 2021-01-26 | Ouray | Colorado | 8091 | 194 | 3 |
966164 | 966164 | 2021-01-26 | Park | Colorado | 8093 | 473 | 5 |
966165 | 966165 | 2021-01-26 | Phillips | Colorado | 8095 | 322 | 11 |
966166 | 966166 | 2021-01-26 | Pitkin | Colorado | 8097 | 1795 | 4 |
966167 | 966167 | 2021-01-26 | Prowers | Colorado | 8099 | 1112 | 21 |
966168 | 966168 | 2021-01-26 | Pueblo | Colorado | 8101 | 14199 | 357 |
966169 | 966169 | 2021-01-26 | Rio Blanco | Colorado | 8103 | 387 | 3 |
966170 | 966170 | 2021-01-26 | Rio Grande | Colorado | 8105 | 590 | 10 |
966171 | 966171 | 2021-01-26 | Routt | Colorado | 8107 | 1529 | 19 |
966172 | 966172 | 2021-01-26 | Saguache | Colorado | 8109 | 290 | 4 |
966173 | 966173 | 2021-01-26 | San Juan | Colorado | 8111 | 42 | 0 |
966174 | 966174 | 2021-01-26 | San Miguel | Colorado | 8113 | 611 | 0 |
966175 | 966175 | 2021-01-26 | Sedgwick | Colorado | 8115 | 184 | 2 |
966176 | 966176 | 2021-01-26 | Summit | Colorado | 8117 | 2566 | 5 |
966177 | 966177 | 2021-01-26 | Teller | Colorado | 8119 | 1153 | 13 |
966178 | 966178 | 2021-01-26 | Washington | Colorado | 8121 | 364 | 11 |
966179 | 966179 | 2021-01-26 | Weld | Colorado | 8123 | 23303 | 301 |
966180 | 966180 | 2021-01-26 | Yuma | Colorado | 8125 | 652 | 15 |
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);