ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
965 rows where deaths = 7 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Gunnison 159
- Cheyenne 123
- Grand 111
- Summit 87
- San Miguel 65
- Park 43
- Dolores 39
- Clear Creek 30
- Baca 27
- Mesa 23
- Eagle 22
- Custer 20
- Saguache 19
- Rio Blanco 18
- Alamosa 14
- Archuleta 13
- Teller 13
- Conejos 12
- Otero 11
- Pitkin 11
- Las Animas 10
- Kit Carson 9
- Huerfano 8
- Sedgwick 8
- Fremont 7
- Garfield 6
- Montezuma 6
- Lincoln 5
- Rio Grande 5
- Delta 4
- …
state 1
- Colorado · 965 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499869 | 2499869 | 2022-05-13 | Pitkin | Colorado | 8097 | 6676 | 7 |
2496611 | 2496611 | 2022-05-12 | Pitkin | Colorado | 8097 | 6671 | 7 |
2493353 | 2493353 | 2022-05-11 | Pitkin | Colorado | 8097 | 6631 | 7 |
2490095 | 2490095 | 2022-05-10 | Pitkin | Colorado | 8097 | 6624 | 7 |
2486838 | 2486838 | 2022-05-09 | Pitkin | Colorado | 8097 | 6623 | 7 |
2483580 | 2483580 | 2022-05-08 | Pitkin | Colorado | 8097 | 6620 | 7 |
2480322 | 2480322 | 2022-05-07 | Pitkin | Colorado | 8097 | 6620 | 7 |
2477064 | 2477064 | 2022-05-06 | Pitkin | Colorado | 8097 | 6620 | 7 |
2473806 | 2473806 | 2022-05-05 | Pitkin | Colorado | 8097 | 6620 | 7 |
2470549 | 2470549 | 2022-05-04 | Pitkin | Colorado | 8097 | 6618 | 7 |
2467293 | 2467293 | 2022-05-03 | Pitkin | Colorado | 8097 | 6617 | 7 |
2255755 | 2255755 | 2022-02-27 | Dolores | Colorado | 8033 | 347 | 7 |
2252504 | 2252504 | 2022-02-26 | Dolores | Colorado | 8033 | 347 | 7 |
2249253 | 2249253 | 2022-02-25 | Dolores | Colorado | 8033 | 347 | 7 |
2246002 | 2246002 | 2022-02-24 | Dolores | Colorado | 8033 | 348 | 7 |
2242751 | 2242751 | 2022-02-23 | Dolores | Colorado | 8033 | 347 | 7 |
2242791 | 2242791 | 2022-02-23 | San Miguel | Colorado | 8113 | 2214 | 7 |
2239500 | 2239500 | 2022-02-22 | Dolores | Colorado | 8033 | 347 | 7 |
2239540 | 2239540 | 2022-02-22 | San Miguel | Colorado | 8113 | 2211 | 7 |
2236249 | 2236249 | 2022-02-21 | Dolores | Colorado | 8033 | 346 | 7 |
2236289 | 2236289 | 2022-02-21 | San Miguel | Colorado | 8113 | 2212 | 7 |
2232998 | 2232998 | 2022-02-20 | Dolores | Colorado | 8033 | 346 | 7 |
2233038 | 2233038 | 2022-02-20 | San Miguel | Colorado | 8113 | 2202 | 7 |
2229747 | 2229747 | 2022-02-19 | Dolores | Colorado | 8033 | 346 | 7 |
2229787 | 2229787 | 2022-02-19 | San Miguel | Colorado | 8113 | 2202 | 7 |
2226496 | 2226496 | 2022-02-18 | Dolores | Colorado | 8033 | 346 | 7 |
2226536 | 2226536 | 2022-02-18 | San Miguel | Colorado | 8113 | 2202 | 7 |
2223245 | 2223245 | 2022-02-17 | Dolores | Colorado | 8033 | 345 | 7 |
2223285 | 2223285 | 2022-02-17 | San Miguel | Colorado | 8113 | 2199 | 7 |
2219994 | 2219994 | 2022-02-16 | Dolores | Colorado | 8033 | 346 | 7 |
2220034 | 2220034 | 2022-02-16 | San Miguel | Colorado | 8113 | 2197 | 7 |
2216743 | 2216743 | 2022-02-15 | Dolores | Colorado | 8033 | 346 | 7 |
2216783 | 2216783 | 2022-02-15 | San Miguel | Colorado | 8113 | 2162 | 7 |
2213492 | 2213492 | 2022-02-14 | Dolores | Colorado | 8033 | 344 | 7 |
2213532 | 2213532 | 2022-02-14 | San Miguel | Colorado | 8113 | 2159 | 7 |
2210240 | 2210240 | 2022-02-13 | Dolores | Colorado | 8033 | 343 | 7 |
2210280 | 2210280 | 2022-02-13 | San Miguel | Colorado | 8113 | 2155 | 7 |
2206987 | 2206987 | 2022-02-12 | Dolores | Colorado | 8033 | 343 | 7 |
2207027 | 2207027 | 2022-02-12 | San Miguel | Colorado | 8113 | 2155 | 7 |
2203734 | 2203734 | 2022-02-11 | Dolores | Colorado | 8033 | 343 | 7 |
2203774 | 2203774 | 2022-02-11 | San Miguel | Colorado | 8113 | 2155 | 7 |
2200481 | 2200481 | 2022-02-10 | Dolores | Colorado | 8033 | 341 | 7 |
2200521 | 2200521 | 2022-02-10 | San Miguel | Colorado | 8113 | 2154 | 7 |
2197227 | 2197227 | 2022-02-09 | Dolores | Colorado | 8033 | 342 | 7 |
2197267 | 2197267 | 2022-02-09 | San Miguel | Colorado | 8113 | 2148 | 7 |
2193973 | 2193973 | 2022-02-08 | Dolores | Colorado | 8033 | 342 | 7 |
2194013 | 2194013 | 2022-02-08 | San Miguel | Colorado | 8113 | 2142 | 7 |
2190719 | 2190719 | 2022-02-07 | Dolores | Colorado | 8033 | 339 | 7 |
2190759 | 2190759 | 2022-02-07 | San Miguel | Colorado | 8113 | 2142 | 7 |
2187466 | 2187466 | 2022-02-06 | Dolores | Colorado | 8033 | 337 | 7 |
2187506 | 2187506 | 2022-02-06 | San Miguel | Colorado | 8113 | 2132 | 7 |
2184213 | 2184213 | 2022-02-05 | Dolores | Colorado | 8033 | 337 | 7 |
2184253 | 2184253 | 2022-02-05 | San Miguel | Colorado | 8113 | 2132 | 7 |
2180961 | 2180961 | 2022-02-04 | Dolores | Colorado | 8033 | 337 | 7 |
2181001 | 2181001 | 2022-02-04 | San Miguel | Colorado | 8113 | 2132 | 7 |
2177710 | 2177710 | 2022-02-03 | Dolores | Colorado | 8033 | 338 | 7 |
2177750 | 2177750 | 2022-02-03 | San Miguel | Colorado | 8113 | 2130 | 7 |
2174457 | 2174457 | 2022-02-02 | Dolores | Colorado | 8033 | 334 | 7 |
2174497 | 2174497 | 2022-02-02 | San Miguel | Colorado | 8113 | 2111 | 7 |
2171204 | 2171204 | 2022-02-01 | Dolores | Colorado | 8033 | 335 | 7 |
2171244 | 2171244 | 2022-02-01 | San Miguel | Colorado | 8113 | 2108 | 7 |
2167951 | 2167951 | 2022-01-31 | Dolores | Colorado | 8033 | 332 | 7 |
2167991 | 2167991 | 2022-01-31 | San Miguel | Colorado | 8113 | 2108 | 7 |
2164696 | 2164696 | 2022-01-30 | Dolores | Colorado | 8033 | 329 | 7 |
2164736 | 2164736 | 2022-01-30 | San Miguel | Colorado | 8113 | 2093 | 7 |
2161441 | 2161441 | 2022-01-29 | Dolores | Colorado | 8033 | 326 | 7 |
2161481 | 2161481 | 2022-01-29 | San Miguel | Colorado | 8113 | 2068 | 7 |
2158185 | 2158185 | 2022-01-28 | Dolores | Colorado | 8033 | 329 | 7 |
2158225 | 2158225 | 2022-01-28 | San Miguel | Colorado | 8113 | 2093 | 7 |
2154932 | 2154932 | 2022-01-27 | Dolores | Colorado | 8033 | 326 | 7 |
2154972 | 2154972 | 2022-01-27 | San Miguel | Colorado | 8113 | 2068 | 7 |
2151679 | 2151679 | 2022-01-26 | Dolores | Colorado | 8033 | 326 | 7 |
2151719 | 2151719 | 2022-01-26 | San Miguel | Colorado | 8113 | 2062 | 7 |
2148427 | 2148427 | 2022-01-25 | Dolores | Colorado | 8033 | 323 | 7 |
2148467 | 2148467 | 2022-01-25 | San Miguel | Colorado | 8113 | 2057 | 7 |
2145175 | 2145175 | 2022-01-24 | Dolores | Colorado | 8033 | 323 | 7 |
2145215 | 2145215 | 2022-01-24 | San Miguel | Colorado | 8113 | 2049 | 7 |
2145216 | 2145216 | 2022-01-24 | Sedgwick | Colorado | 8115 | 412 | 7 |
2141920 | 2141920 | 2022-01-23 | Dolores | Colorado | 8033 | 318 | 7 |
2141960 | 2141960 | 2022-01-23 | San Miguel | Colorado | 8113 | 2024 | 7 |
2141961 | 2141961 | 2022-01-23 | Sedgwick | Colorado | 8115 | 401 | 7 |
2138665 | 2138665 | 2022-01-22 | Dolores | Colorado | 8033 | 318 | 7 |
2138705 | 2138705 | 2022-01-22 | San Miguel | Colorado | 8113 | 2024 | 7 |
2138706 | 2138706 | 2022-01-22 | Sedgwick | Colorado | 8115 | 401 | 7 |
2135409 | 2135409 | 2022-01-21 | Dolores | Colorado | 8033 | 318 | 7 |
2135449 | 2135449 | 2022-01-21 | San Miguel | Colorado | 8113 | 2024 | 7 |
2135450 | 2135450 | 2022-01-21 | Sedgwick | Colorado | 8115 | 401 | 7 |
2132157 | 2132157 | 2022-01-20 | Dolores | Colorado | 8033 | 311 | 7 |
2132197 | 2132197 | 2022-01-20 | San Miguel | Colorado | 8113 | 2022 | 7 |
2132198 | 2132198 | 2022-01-20 | Sedgwick | Colorado | 8115 | 401 | 7 |
2128944 | 2128944 | 2022-01-19 | San Miguel | Colorado | 8113 | 2000 | 7 |
2128945 | 2128945 | 2022-01-19 | Sedgwick | Colorado | 8115 | 398 | 7 |
2125690 | 2125690 | 2022-01-18 | San Miguel | Colorado | 8113 | 1994 | 7 |
2125691 | 2125691 | 2022-01-18 | Sedgwick | Colorado | 8115 | 388 | 7 |
2122438 | 2122438 | 2022-01-17 | San Miguel | Colorado | 8113 | 1990 | 7 |
2122439 | 2122439 | 2022-01-17 | Sedgwick | Colorado | 8115 | 388 | 7 |
2119186 | 2119186 | 2022-01-16 | San Miguel | Colorado | 8113 | 1966 | 7 |
2115934 | 2115934 | 2022-01-15 | San Miguel | Colorado | 8113 | 1966 | 7 |
2112683 | 2112683 | 2022-01-14 | San Miguel | Colorado | 8113 | 1966 | 7 |
2109431 | 2109431 | 2022-01-13 | San Miguel | Colorado | 8113 | 1947 | 7 |
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);