ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,493 rows where deaths = 5 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Park 232
- Logan 113
- Ouray 100
- Montezuma 98
- Baca 97
- Rio Blanco 83
- Cheyenne 80
- Costilla 75
- Garfield 63
- Summit 61
- Grand 54
- Pitkin 53
- Dolores 49
- San Miguel 49
- Saguache 32
- Clear Creek 29
- Elbert 28
- Mesa 28
- Rio Grande 26
- Sedgwick 20
- Gunnison 19
- Lincoln 14
- Custer 11
- Eagle 10
- La Plata 8
- Kiowa 7
- Crowley 6
- Washington 6
- Archuleta 5
- Fremont 5
- …
state 1
- Colorado · 1,493 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496586 | 2496586 | 2022-05-12 | Gilpin | Colorado | 8047 | 975 | 5 |
2493328 | 2493328 | 2022-05-11 | Gilpin | Colorado | 8047 | 973 | 5 |
2187480 | 2187480 | 2022-02-06 | Kiowa | Colorado | 8061 | 315 | 5 |
2184227 | 2184227 | 2022-02-05 | Kiowa | Colorado | 8061 | 315 | 5 |
2180975 | 2180975 | 2022-02-04 | Kiowa | Colorado | 8061 | 315 | 5 |
2177724 | 2177724 | 2022-02-03 | Kiowa | Colorado | 8061 | 315 | 5 |
2174471 | 2174471 | 2022-02-02 | Kiowa | Colorado | 8061 | 313 | 5 |
2171218 | 2171218 | 2022-02-01 | Kiowa | Colorado | 8061 | 313 | 5 |
2167965 | 2167965 | 2022-01-31 | Kiowa | Colorado | 8061 | 313 | 5 |
2054124 | 2054124 | 2021-12-27 | Dolores | Colorado | 8033 | 282 | 5 |
2050874 | 2050874 | 2021-12-26 | Dolores | Colorado | 8033 | 283 | 5 |
2047624 | 2047624 | 2021-12-25 | Dolores | Colorado | 8033 | 283 | 5 |
2044374 | 2044374 | 2021-12-24 | Dolores | Colorado | 8033 | 283 | 5 |
2041125 | 2041125 | 2021-12-23 | Dolores | Colorado | 8033 | 277 | 5 |
2037875 | 2037875 | 2021-12-22 | Dolores | Colorado | 8033 | 276 | 5 |
2034625 | 2034625 | 2021-12-21 | Dolores | Colorado | 8033 | 275 | 5 |
2031375 | 2031375 | 2021-12-20 | Dolores | Colorado | 8033 | 274 | 5 |
2028124 | 2028124 | 2021-12-19 | Dolores | Colorado | 8033 | 273 | 5 |
2028164 | 2028164 | 2021-12-19 | San Miguel | Colorado | 8113 | 1322 | 5 |
2024873 | 2024873 | 2021-12-18 | Dolores | Colorado | 8033 | 273 | 5 |
2024913 | 2024913 | 2021-12-18 | San Miguel | Colorado | 8113 | 1322 | 5 |
2021622 | 2021622 | 2021-12-17 | Dolores | Colorado | 8033 | 273 | 5 |
2021662 | 2021662 | 2021-12-17 | San Miguel | Colorado | 8113 | 1322 | 5 |
2018371 | 2018371 | 2021-12-16 | Dolores | Colorado | 8033 | 272 | 5 |
2018411 | 2018411 | 2021-12-16 | San Miguel | Colorado | 8113 | 1311 | 5 |
2015121 | 2015121 | 2021-12-15 | Dolores | Colorado | 8033 | 272 | 5 |
2015161 | 2015161 | 2021-12-15 | San Miguel | Colorado | 8113 | 1308 | 5 |
2011870 | 2011870 | 2021-12-14 | Dolores | Colorado | 8033 | 272 | 5 |
2011910 | 2011910 | 2021-12-14 | San Miguel | Colorado | 8113 | 1307 | 5 |
2008619 | 2008619 | 2021-12-13 | Dolores | Colorado | 8033 | 272 | 5 |
2008659 | 2008659 | 2021-12-13 | San Miguel | Colorado | 8113 | 1302 | 5 |
2005368 | 2005368 | 2021-12-12 | Dolores | Colorado | 8033 | 271 | 5 |
2005408 | 2005408 | 2021-12-12 | San Miguel | Colorado | 8113 | 1298 | 5 |
2002117 | 2002117 | 2021-12-11 | Dolores | Colorado | 8033 | 271 | 5 |
2002157 | 2002157 | 2021-12-11 | San Miguel | Colorado | 8113 | 1298 | 5 |
1998867 | 1998867 | 2021-12-10 | Dolores | Colorado | 8033 | 271 | 5 |
1998907 | 1998907 | 2021-12-10 | San Miguel | Colorado | 8113 | 1298 | 5 |
1995616 | 1995616 | 2021-12-09 | Dolores | Colorado | 8033 | 269 | 5 |
1995656 | 1995656 | 2021-12-09 | San Miguel | Colorado | 8113 | 1294 | 5 |
1992365 | 1992365 | 2021-12-08 | Dolores | Colorado | 8033 | 268 | 5 |
1992405 | 1992405 | 2021-12-08 | San Miguel | Colorado | 8113 | 1288 | 5 |
1989114 | 1989114 | 2021-12-07 | Dolores | Colorado | 8033 | 265 | 5 |
1989154 | 1989154 | 2021-12-07 | San Miguel | Colorado | 8113 | 1286 | 5 |
1985864 | 1985864 | 2021-12-06 | Dolores | Colorado | 8033 | 264 | 5 |
1985904 | 1985904 | 2021-12-06 | San Miguel | Colorado | 8113 | 1281 | 5 |
1982614 | 1982614 | 2021-12-05 | Dolores | Colorado | 8033 | 263 | 5 |
1982654 | 1982654 | 2021-12-05 | San Miguel | Colorado | 8113 | 1279 | 5 |
1979364 | 1979364 | 2021-12-04 | Dolores | Colorado | 8033 | 263 | 5 |
1979404 | 1979404 | 2021-12-04 | San Miguel | Colorado | 8113 | 1279 | 5 |
1976114 | 1976114 | 2021-12-03 | Dolores | Colorado | 8033 | 263 | 5 |
1976154 | 1976154 | 2021-12-03 | San Miguel | Colorado | 8113 | 1279 | 5 |
1972865 | 1972865 | 2021-12-02 | Dolores | Colorado | 8033 | 262 | 5 |
1972905 | 1972905 | 2021-12-02 | San Miguel | Colorado | 8113 | 1278 | 5 |
1969615 | 1969615 | 2021-12-01 | Dolores | Colorado | 8033 | 258 | 5 |
1969655 | 1969655 | 2021-12-01 | San Miguel | Colorado | 8113 | 1271 | 5 |
1966365 | 1966365 | 2021-11-30 | Dolores | Colorado | 8033 | 257 | 5 |
1966405 | 1966405 | 2021-11-30 | San Miguel | Colorado | 8113 | 1270 | 5 |
1963100 | 1963100 | 2021-11-29 | Baca | Colorado | 8009 | 560 | 5 |
1963113 | 1963113 | 2021-11-29 | Dolores | Colorado | 8033 | 256 | 5 |
1963153 | 1963153 | 2021-11-29 | San Miguel | Colorado | 8113 | 1268 | 5 |
1959849 | 1959849 | 2021-11-28 | Baca | Colorado | 8009 | 559 | 5 |
1959862 | 1959862 | 2021-11-28 | Dolores | Colorado | 8033 | 256 | 5 |
1959902 | 1959902 | 2021-11-28 | San Miguel | Colorado | 8113 | 1263 | 5 |
1956598 | 1956598 | 2021-11-27 | Baca | Colorado | 8009 | 559 | 5 |
1956611 | 1956611 | 2021-11-27 | Dolores | Colorado | 8033 | 256 | 5 |
1956651 | 1956651 | 2021-11-27 | San Miguel | Colorado | 8113 | 1263 | 5 |
1953347 | 1953347 | 2021-11-26 | Baca | Colorado | 8009 | 559 | 5 |
1953360 | 1953360 | 2021-11-26 | Dolores | Colorado | 8033 | 256 | 5 |
1953400 | 1953400 | 2021-11-26 | San Miguel | Colorado | 8113 | 1263 | 5 |
1950096 | 1950096 | 2021-11-25 | Baca | Colorado | 8009 | 559 | 5 |
1950109 | 1950109 | 2021-11-25 | Dolores | Colorado | 8033 | 256 | 5 |
1950149 | 1950149 | 2021-11-25 | San Miguel | Colorado | 8113 | 1263 | 5 |
1946845 | 1946845 | 2021-11-24 | Baca | Colorado | 8009 | 557 | 5 |
1946858 | 1946858 | 2021-11-24 | Dolores | Colorado | 8033 | 256 | 5 |
1946898 | 1946898 | 2021-11-24 | San Miguel | Colorado | 8113 | 1260 | 5 |
1943594 | 1943594 | 2021-11-23 | Baca | Colorado | 8009 | 544 | 5 |
1943607 | 1943607 | 2021-11-23 | Dolores | Colorado | 8033 | 255 | 5 |
1943647 | 1943647 | 2021-11-23 | San Miguel | Colorado | 8113 | 1259 | 5 |
1943648 | 1943648 | 2021-11-23 | Sedgwick | Colorado | 8115 | 352 | 5 |
1940344 | 1940344 | 2021-11-22 | Baca | Colorado | 8009 | 543 | 5 |
1940357 | 1940357 | 2021-11-22 | Dolores | Colorado | 8033 | 255 | 5 |
1940397 | 1940397 | 2021-11-22 | San Miguel | Colorado | 8113 | 1259 | 5 |
1940398 | 1940398 | 2021-11-22 | Sedgwick | Colorado | 8115 | 350 | 5 |
1937094 | 1937094 | 2021-11-21 | Baca | Colorado | 8009 | 541 | 5 |
1937107 | 1937107 | 2021-11-21 | Dolores | Colorado | 8033 | 253 | 5 |
1937147 | 1937147 | 2021-11-21 | San Miguel | Colorado | 8113 | 1253 | 5 |
1937148 | 1937148 | 2021-11-21 | Sedgwick | Colorado | 8115 | 343 | 5 |
1933844 | 1933844 | 2021-11-20 | Baca | Colorado | 8009 | 541 | 5 |
1933857 | 1933857 | 2021-11-20 | Dolores | Colorado | 8033 | 253 | 5 |
1933897 | 1933897 | 2021-11-20 | San Miguel | Colorado | 8113 | 1253 | 5 |
1933898 | 1933898 | 2021-11-20 | Sedgwick | Colorado | 8115 | 343 | 5 |
1930592 | 1930592 | 2021-11-19 | Baca | Colorado | 8009 | 541 | 5 |
1930605 | 1930605 | 2021-11-19 | Dolores | Colorado | 8033 | 253 | 5 |
1930645 | 1930645 | 2021-11-19 | San Miguel | Colorado | 8113 | 1253 | 5 |
1930646 | 1930646 | 2021-11-19 | Sedgwick | Colorado | 8115 | 343 | 5 |
1927342 | 1927342 | 2021-11-18 | Baca | Colorado | 8009 | 540 | 5 |
1927355 | 1927355 | 2021-11-18 | Dolores | Colorado | 8033 | 253 | 5 |
1927384 | 1927384 | 2021-11-18 | Ouray | Colorado | 8091 | 497 | 5 |
1927395 | 1927395 | 2021-11-18 | San Miguel | Colorado | 8113 | 1243 | 5 |
1927396 | 1927396 | 2021-11-18 | Sedgwick | Colorado | 8115 | 342 | 5 |
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);