ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
541 rows where deaths = 11 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Kit Carson 111
- Las Animas 100
- Summit 38
- Clear Creek 35
- Rio Blanco 32
- Washington 28
- Phillips 27
- Montrose 23
- Eagle 22
- Prowers 15
- Delta 10
- Park 10
- Custer 9
- Costilla 7
- Huerfano 7
- Montezuma 7
- Saguache 6
- Alamosa 5
- Elbert 5
- Gunnison 4
- Mesa 4
- Otero 4
- Teller 4
- Pueblo 3
- Routt 3
- Sedgwick 3
- Bent 2
- Conejos 2
- El Paso 2
- Rio Grande 2
- …
state 1
- Colorado · 541 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499878 | 2499878 | 2022-05-13 | Sedgwick | Colorado | 8115 | 490 | 11 |
2496620 | 2496620 | 2022-05-12 | Sedgwick | Colorado | 8115 | 490 | 11 |
2493362 | 2493362 | 2022-05-11 | Sedgwick | Colorado | 8115 | 489 | 11 |
2324046 | 2324046 | 2022-03-20 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2320792 | 2320792 | 2022-03-19 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2317538 | 2317538 | 2022-03-18 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2314285 | 2314285 | 2022-03-17 | Clear Creek | Colorado | 8019 | 1512 | 11 |
2311032 | 2311032 | 2022-03-16 | Clear Creek | Colorado | 8019 | 1510 | 11 |
2307779 | 2307779 | 2022-03-15 | Clear Creek | Colorado | 8019 | 1509 | 11 |
2304528 | 2304528 | 2022-03-14 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2301276 | 2301276 | 2022-03-13 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2298024 | 2298024 | 2022-03-12 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2294772 | 2294772 | 2022-03-11 | Clear Creek | Colorado | 8019 | 1505 | 11 |
2291520 | 2291520 | 2022-03-10 | Clear Creek | Colorado | 8019 | 1503 | 11 |
2288268 | 2288268 | 2022-03-09 | Clear Creek | Colorado | 8019 | 1503 | 11 |
2285017 | 2285017 | 2022-03-08 | Clear Creek | Colorado | 8019 | 1502 | 11 |
2281765 | 2281765 | 2022-03-07 | Clear Creek | Colorado | 8019 | 1502 | 11 |
2278512 | 2278512 | 2022-03-06 | Clear Creek | Colorado | 8019 | 1499 | 11 |
2275259 | 2275259 | 2022-03-05 | Clear Creek | Colorado | 8019 | 1499 | 11 |
2272006 | 2272006 | 2022-03-04 | Clear Creek | Colorado | 8019 | 1499 | 11 |
2268754 | 2268754 | 2022-03-03 | Clear Creek | Colorado | 8019 | 1496 | 11 |
2265501 | 2265501 | 2022-03-02 | Clear Creek | Colorado | 8019 | 1496 | 11 |
2262250 | 2262250 | 2022-03-01 | Clear Creek | Colorado | 8019 | 1493 | 11 |
2258999 | 2258999 | 2022-02-28 | Clear Creek | Colorado | 8019 | 1493 | 11 |
2255748 | 2255748 | 2022-02-27 | Clear Creek | Colorado | 8019 | 1493 | 11 |
2252497 | 2252497 | 2022-02-26 | Clear Creek | Colorado | 8019 | 1493 | 11 |
2249246 | 2249246 | 2022-02-25 | Clear Creek | Colorado | 8019 | 1493 | 11 |
2245995 | 2245995 | 2022-02-24 | Clear Creek | Colorado | 8019 | 1491 | 11 |
2242744 | 2242744 | 2022-02-23 | Clear Creek | Colorado | 8019 | 1491 | 11 |
2239493 | 2239493 | 2022-02-22 | Clear Creek | Colorado | 8019 | 1489 | 11 |
2236242 | 2236242 | 2022-02-21 | Clear Creek | Colorado | 8019 | 1489 | 11 |
2232991 | 2232991 | 2022-02-20 | Clear Creek | Colorado | 8019 | 1487 | 11 |
2229740 | 2229740 | 2022-02-19 | Clear Creek | Colorado | 8019 | 1487 | 11 |
2226489 | 2226489 | 2022-02-18 | Clear Creek | Colorado | 8019 | 1487 | 11 |
2223238 | 2223238 | 2022-02-17 | Clear Creek | Colorado | 8019 | 1487 | 11 |
2219987 | 2219987 | 2022-02-16 | Clear Creek | Colorado | 8019 | 1487 | 11 |
2216736 | 2216736 | 2022-02-15 | Clear Creek | Colorado | 8019 | 1487 | 11 |
2213485 | 2213485 | 2022-02-14 | Clear Creek | Colorado | 8019 | 1484 | 11 |
2197213 | 2197213 | 2022-02-09 | Archuleta | Colorado | 8007 | 2776 | 11 |
2187504 | 2187504 | 2022-02-06 | Saguache | Colorado | 8109 | 1060 | 11 |
2184251 | 2184251 | 2022-02-05 | Saguache | Colorado | 8109 | 1060 | 11 |
2180999 | 2180999 | 2022-02-04 | Saguache | Colorado | 8109 | 1060 | 11 |
2177748 | 2177748 | 2022-02-03 | Saguache | Colorado | 8109 | 1055 | 11 |
2174495 | 2174495 | 2022-02-02 | Saguache | Colorado | 8109 | 1046 | 11 |
2171242 | 2171242 | 2022-02-01 | Saguache | Colorado | 8109 | 1040 | 11 |
2096422 | 2096422 | 2022-01-09 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2093170 | 2093170 | 2022-01-08 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2089918 | 2089918 | 2022-01-07 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2086667 | 2086667 | 2022-01-06 | Rio Blanco | Colorado | 8103 | 1310 | 11 |
2080163 | 2080163 | 2022-01-04 | Rio Blanco | Colorado | 8103 | 1303 | 11 |
2076911 | 2076911 | 2022-01-03 | Rio Blanco | Colorado | 8103 | 1296 | 11 |
2073660 | 2073660 | 2022-01-02 | Rio Blanco | Colorado | 8103 | 1289 | 11 |
2070409 | 2070409 | 2022-01-01 | Rio Blanco | Colorado | 8103 | 1289 | 11 |
2067158 | 2067158 | 2021-12-31 | Rio Blanco | Colorado | 8103 | 1289 | 11 |
2063907 | 2063907 | 2021-12-30 | Rio Blanco | Colorado | 8103 | 1287 | 11 |
2060657 | 2060657 | 2021-12-29 | Rio Blanco | Colorado | 8103 | 1283 | 11 |
2057408 | 2057408 | 2021-12-28 | Rio Blanco | Colorado | 8103 | 1282 | 11 |
2054159 | 2054159 | 2021-12-27 | Rio Blanco | Colorado | 8103 | 1276 | 11 |
2050909 | 2050909 | 2021-12-26 | Rio Blanco | Colorado | 8103 | 1275 | 11 |
2047659 | 2047659 | 2021-12-25 | Rio Blanco | Colorado | 8103 | 1275 | 11 |
2044409 | 2044409 | 2021-12-24 | Rio Blanco | Colorado | 8103 | 1275 | 11 |
2041160 | 2041160 | 2021-12-23 | Rio Blanco | Colorado | 8103 | 1268 | 11 |
2037910 | 2037910 | 2021-12-22 | Rio Blanco | Colorado | 8103 | 1267 | 11 |
2034660 | 2034660 | 2021-12-21 | Rio Blanco | Colorado | 8103 | 1264 | 11 |
2031410 | 2031410 | 2021-12-20 | Rio Blanco | Colorado | 8103 | 1260 | 11 |
2028159 | 2028159 | 2021-12-19 | Rio Blanco | Colorado | 8103 | 1256 | 11 |
2024908 | 2024908 | 2021-12-18 | Rio Blanco | Colorado | 8103 | 1256 | 11 |
2021657 | 2021657 | 2021-12-17 | Rio Blanco | Colorado | 8103 | 1256 | 11 |
2018406 | 2018406 | 2021-12-16 | Rio Blanco | Colorado | 8103 | 1254 | 11 |
2015156 | 2015156 | 2021-12-15 | Rio Blanco | Colorado | 8103 | 1252 | 11 |
2011905 | 2011905 | 2021-12-14 | Rio Blanco | Colorado | 8103 | 1249 | 11 |
2008654 | 2008654 | 2021-12-13 | Rio Blanco | Colorado | 8103 | 1244 | 11 |
2005403 | 2005403 | 2021-12-12 | Rio Blanco | Colorado | 8103 | 1243 | 11 |
2002152 | 2002152 | 2021-12-11 | Rio Blanco | Colorado | 8103 | 1243 | 11 |
1998902 | 1998902 | 2021-12-10 | Rio Blanco | Colorado | 8103 | 1243 | 11 |
1995651 | 1995651 | 2021-12-09 | Rio Blanco | Colorado | 8103 | 1241 | 11 |
1992400 | 1992400 | 2021-12-08 | Rio Blanco | Colorado | 8103 | 1236 | 11 |
1966362 | 1966362 | 2021-11-30 | Custer | Colorado | 8027 | 466 | 11 |
1963110 | 1963110 | 2021-11-29 | Custer | Colorado | 8027 | 462 | 11 |
1959859 | 1959859 | 2021-11-28 | Custer | Colorado | 8027 | 459 | 11 |
1959892 | 1959892 | 2021-11-28 | Park | Colorado | 8093 | 1678 | 11 |
1956608 | 1956608 | 2021-11-27 | Custer | Colorado | 8027 | 457 | 11 |
1956641 | 1956641 | 2021-11-27 | Park | Colorado | 8093 | 1675 | 11 |
1953357 | 1953357 | 2021-11-26 | Custer | Colorado | 8027 | 457 | 11 |
1953390 | 1953390 | 2021-11-26 | Park | Colorado | 8093 | 1675 | 11 |
1950106 | 1950106 | 2021-11-25 | Custer | Colorado | 8027 | 457 | 11 |
1950139 | 1950139 | 2021-11-25 | Park | Colorado | 8093 | 1675 | 11 |
1946855 | 1946855 | 2021-11-24 | Custer | Colorado | 8027 | 457 | 11 |
1946888 | 1946888 | 2021-11-24 | Park | Colorado | 8093 | 1668 | 11 |
1943604 | 1943604 | 2021-11-23 | Custer | Colorado | 8027 | 456 | 11 |
1943637 | 1943637 | 2021-11-23 | Park | Colorado | 8093 | 1651 | 11 |
1940354 | 1940354 | 2021-11-22 | Custer | Colorado | 8027 | 455 | 11 |
1940387 | 1940387 | 2021-11-22 | Park | Colorado | 8093 | 1638 | 11 |
1937137 | 1937137 | 2021-11-21 | Park | Colorado | 8093 | 1625 | 11 |
1937149 | 1937149 | 2021-11-21 | Summit | Colorado | 8117 | 5196 | 11 |
1933887 | 1933887 | 2021-11-20 | Park | Colorado | 8093 | 1625 | 11 |
1933899 | 1933899 | 2021-11-20 | Summit | Colorado | 8117 | 5196 | 11 |
1930635 | 1930635 | 2021-11-19 | Park | Colorado | 8093 | 1625 | 11 |
1930647 | 1930647 | 2021-11-19 | Summit | Colorado | 8117 | 5196 | 11 |
1924147 | 1924147 | 2021-11-17 | Summit | Colorado | 8117 | 5138 | 11 |
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);