ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
49,527 rows where state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Douglas 324
- Jefferson 324
- Denver 323
- Eagle 323
- El Paso 323
- Arapahoe 320
- Larimer 320
- Gunnison 319
- Pitkin 318
- Adams 317
- Clear Creek 316
- Pueblo 316
- Routt 316
- Summit 316
- Weld 316
- Boulder 315
- Mesa 315
- Garfield 314
- Yuma 311
- Crowley 310
- Grand 310
- Morgan 310
- Broomfield 309
- Park 309
- San Miguel 309
- Chaffee 308
- Elbert 308
- Hinsdale 308
- Montrose 308
- La Plata 306
- …
state 1
- Colorado · 19,063 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
953136 | 953136 | 2021-01-22 | Adams | Colorado | 8001 | 45305 | 582 |
953137 | 953137 | 2021-01-22 | Alamosa | Colorado | 8003 | 1107 | 27 |
953138 | 953138 | 2021-01-22 | Arapahoe | Colorado | 8005 | 44230 | 641 |
953139 | 953139 | 2021-01-22 | Archuleta | Colorado | 8007 | 590 | 1 |
953140 | 953140 | 2021-01-22 | Baca | Colorado | 8009 | 256 | 2 |
953141 | 953141 | 2021-01-22 | Bent | Colorado | 8011 | 1280 | 19 |
953142 | 953142 | 2021-01-22 | Boulder | Colorado | 8013 | 16729 | 219 |
953143 | 953143 | 2021-01-22 | Broomfield | Colorado | 8014 | 3267 | 69 |
953144 | 953144 | 2021-01-22 | Chaffee | Colorado | 8015 | 1254 | 23 |
953145 | 953145 | 2021-01-22 | Cheyenne | Colorado | 8017 | 112 | 5 |
953146 | 953146 | 2021-01-22 | Clear Creek | Colorado | 8019 | 337 | 2 |
953147 | 953147 | 2021-01-22 | Conejos | Colorado | 8021 | 382 | 3 |
953148 | 953148 | 2021-01-22 | Costilla | Colorado | 8023 | 175 | 2 |
953149 | 953149 | 2021-01-22 | Crowley | Colorado | 8025 | 1762 | 14 |
953150 | 953150 | 2021-01-22 | Custer | Colorado | 8027 | 157 | 1 |
953151 | 953151 | 2021-01-22 | Delta | Colorado | 8029 | 2201 | 42 |
953152 | 953152 | 2021-01-22 | Denver | Colorado | 8031 | 54163 | 728 |
953153 | 953153 | 2021-01-22 | Dolores | Colorado | 8033 | 60 | 0 |
953154 | 953154 | 2021-01-22 | Douglas | Colorado | 8035 | 18602 | 224 |
953155 | 953155 | 2021-01-22 | Eagle | Colorado | 8037 | 4147 | 18 |
953156 | 953156 | 2021-01-22 | El Paso | Colorado | 8041 | 46597 | 680 |
953157 | 953157 | 2021-01-22 | Elbert | Colorado | 8039 | 1106 | 12 |
953158 | 953158 | 2021-01-22 | Fremont | Colorado | 8043 | 5028 | 33 |
953159 | 953159 | 2021-01-22 | Garfield | Colorado | 8045 | 4608 | 36 |
953160 | 953160 | 2021-01-22 | Gilpin | Colorado | 8047 | 141 | 2 |
953161 | 953161 | 2021-01-22 | Grand | Colorado | 8049 | 863 | 5 |
953162 | 953162 | 2021-01-22 | Gunnison | Colorado | 8051 | 962 | 6 |
953163 | 953163 | 2021-01-22 | Hinsdale | Colorado | 8053 | 15 | 0 |
953164 | 953164 | 2021-01-22 | Huerfano | Colorado | 8055 | 287 | 17 |
953165 | 953165 | 2021-01-22 | Jackson | Colorado | 8057 | 44 | 0 |
953166 | 953166 | 2021-01-22 | Jefferson | Colorado | 8059 | 33489 | 676 |
953167 | 953167 | 2021-01-22 | Kiowa | Colorado | 8061 | 85 | 2 |
953168 | 953168 | 2021-01-22 | Kit Carson | Colorado | 8063 | 496 | 10 |
953169 | 953169 | 2021-01-22 | La Plata | Colorado | 8067 | 2634 | 30 |
953170 | 953170 | 2021-01-22 | Lake | Colorado | 8065 | 486 | 0 |
953171 | 953171 | 2021-01-22 | Larimer | Colorado | 8069 | 17331 | 180 |
953172 | 953172 | 2021-01-22 | Las Animas | Colorado | 8071 | 893 | 10 |
953173 | 953173 | 2021-01-22 | Lincoln | Colorado | 8073 | 835 | 3 |
953174 | 953174 | 2021-01-22 | Logan | Colorado | 8075 | 3558 | 57 |
953175 | 953175 | 2021-01-22 | Mesa | Colorado | 8077 | 11378 | 160 |
953176 | 953176 | 2021-01-22 | Mineral | Colorado | 8079 | 57 | 1 |
953177 | 953177 | 2021-01-22 | Moffat | Colorado | 8081 | 607 | 23 |
953178 | 953178 | 2021-01-22 | Montezuma | Colorado | 8083 | 1566 | 19 |
953179 | 953179 | 2021-01-22 | Montrose | Colorado | 8085 | 2819 | 41 |
953180 | 953180 | 2021-01-22 | Morgan | Colorado | 8087 | 2335 | 86 |
953181 | 953181 | 2021-01-22 | Otero | Colorado | 8089 | 1771 | 57 |
953182 | 953182 | 2021-01-22 | Ouray | Colorado | 8091 | 182 | 3 |
953183 | 953183 | 2021-01-22 | Park | Colorado | 8093 | 466 | 5 |
953184 | 953184 | 2021-01-22 | Phillips | Colorado | 8095 | 318 | 11 |
953185 | 953185 | 2021-01-22 | Pitkin | Colorado | 8097 | 1748 | 4 |
953186 | 953186 | 2021-01-22 | Prowers | Colorado | 8099 | 1102 | 21 |
953187 | 953187 | 2021-01-22 | Pueblo | Colorado | 8101 | 14131 | 355 |
953188 | 953188 | 2021-01-22 | Rio Blanco | Colorado | 8103 | 363 | 3 |
953189 | 953189 | 2021-01-22 | Rio Grande | Colorado | 8105 | 563 | 10 |
953190 | 953190 | 2021-01-22 | Routt | Colorado | 8107 | 1443 | 19 |
953191 | 953191 | 2021-01-22 | Saguache | Colorado | 8109 | 286 | 4 |
953192 | 953192 | 2021-01-22 | San Juan | Colorado | 8111 | 35 | 0 |
953193 | 953193 | 2021-01-22 | San Miguel | Colorado | 8113 | 583 | 0 |
953194 | 953194 | 2021-01-22 | Sedgwick | Colorado | 8115 | 182 | 2 |
953195 | 953195 | 2021-01-22 | Summit | Colorado | 8117 | 2476 | 5 |
953196 | 953196 | 2021-01-22 | Teller | Colorado | 8119 | 1132 | 13 |
953197 | 953197 | 2021-01-22 | Washington | Colorado | 8121 | 362 | 11 |
953198 | 953198 | 2021-01-22 | Weld | Colorado | 8123 | 23042 | 300 |
953199 | 953199 | 2021-01-22 | Yuma | Colorado | 8125 | 632 | 14 |
949891 | 949891 | 2021-01-21 | Adams | Colorado | 8001 | 44980 | 578 |
949892 | 949892 | 2021-01-21 | Alamosa | Colorado | 8003 | 1098 | 27 |
949893 | 949893 | 2021-01-21 | Arapahoe | Colorado | 8005 | 43837 | 639 |
949894 | 949894 | 2021-01-21 | Archuleta | Colorado | 8007 | 580 | 1 |
949895 | 949895 | 2021-01-21 | Baca | Colorado | 8009 | 256 | 2 |
949896 | 949896 | 2021-01-21 | Bent | Colorado | 8011 | 1279 | 19 |
949897 | 949897 | 2021-01-21 | Boulder | Colorado | 8013 | 16649 | 217 |
949898 | 949898 | 2021-01-21 | Broomfield | Colorado | 8014 | 3240 | 69 |
949899 | 949899 | 2021-01-21 | Chaffee | Colorado | 8015 | 1239 | 23 |
949900 | 949900 | 2021-01-21 | Cheyenne | Colorado | 8017 | 113 | 5 |
949901 | 949901 | 2021-01-21 | Clear Creek | Colorado | 8019 | 337 | 2 |
949902 | 949902 | 2021-01-21 | Conejos | Colorado | 8021 | 377 | 3 |
949903 | 949903 | 2021-01-21 | Costilla | Colorado | 8023 | 175 | 2 |
949904 | 949904 | 2021-01-21 | Crowley | Colorado | 8025 | 1743 | 14 |
949905 | 949905 | 2021-01-21 | Custer | Colorado | 8027 | 156 | 1 |
949906 | 949906 | 2021-01-21 | Delta | Colorado | 8029 | 2187 | 41 |
949907 | 949907 | 2021-01-21 | Denver | Colorado | 8031 | 54006 | 728 |
949908 | 949908 | 2021-01-21 | Dolores | Colorado | 8033 | 58 | 0 |
949909 | 949909 | 2021-01-21 | Douglas | Colorado | 8035 | 18411 | 222 |
949910 | 949910 | 2021-01-21 | Eagle | Colorado | 8037 | 4121 | 17 |
949911 | 949911 | 2021-01-21 | El Paso | Colorado | 8041 | 46446 | 677 |
949912 | 949912 | 2021-01-21 | Elbert | Colorado | 8039 | 1103 | 12 |
949913 | 949913 | 2021-01-21 | Fremont | Colorado | 8043 | 5012 | 33 |
949914 | 949914 | 2021-01-21 | Garfield | Colorado | 8045 | 4585 | 36 |
949915 | 949915 | 2021-01-21 | Gilpin | Colorado | 8047 | 140 | 2 |
949916 | 949916 | 2021-01-21 | Grand | Colorado | 8049 | 842 | 4 |
949917 | 949917 | 2021-01-21 | Gunnison | Colorado | 8051 | 949 | 6 |
949918 | 949918 | 2021-01-21 | Hinsdale | Colorado | 8053 | 16 | 0 |
949919 | 949919 | 2021-01-21 | Huerfano | Colorado | 8055 | 287 | 17 |
949920 | 949920 | 2021-01-21 | Jackson | Colorado | 8057 | 44 | 0 |
949921 | 949921 | 2021-01-21 | Jefferson | Colorado | 8059 | 33321 | 672 |
949922 | 949922 | 2021-01-21 | Kiowa | Colorado | 8061 | 83 | 2 |
949923 | 949923 | 2021-01-21 | Kit Carson | Colorado | 8063 | 483 | 10 |
949924 | 949924 | 2021-01-21 | La Plata | Colorado | 8067 | 2626 | 30 |
949925 | 949925 | 2021-01-21 | Lake | Colorado | 8065 | 482 | 0 |
949926 | 949926 | 2021-01-21 | Larimer | Colorado | 8069 | 17259 | 179 |
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);