ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
616 rows where deaths = 22 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Moffat 136
- Bent 99
- Prowers 81
- Eagle 75
- Yuma 45
- Montezuma 35
- Routt 29
- Las Animas 13
- Chaffee 12
- Crowley 12
- Rio Grande 10
- Conejos 9
- Grand 9
- Alamosa 6
- Elbert 6
- Morgan 6
- Broomfield 5
- Huerfano 4
- Montrose 4
- Pueblo 4
- Teller 4
- Douglas 2
- La Plata 2
- Delta 1
- El Paso 1
- Kit Carson 1
- Larimer 1
- Logan 1
- Mesa 1
- Otero 1
- …
state 1
- Colorado · 616 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2210286 | 2210286 | 2022-02-13 | Yuma | Colorado | 8125 | 1811 | 22 |
2207033 | 2207033 | 2022-02-12 | Yuma | Colorado | 8125 | 1811 | 22 |
2203780 | 2203780 | 2022-02-11 | Yuma | Colorado | 8125 | 1811 | 22 |
2200527 | 2200527 | 2022-02-10 | Yuma | Colorado | 8125 | 1811 | 22 |
2197273 | 2197273 | 2022-02-09 | Yuma | Colorado | 8125 | 1808 | 22 |
2194019 | 2194019 | 2022-02-08 | Yuma | Colorado | 8125 | 1805 | 22 |
2190765 | 2190765 | 2022-02-07 | Yuma | Colorado | 8125 | 1798 | 22 |
2187512 | 2187512 | 2022-02-06 | Yuma | Colorado | 8125 | 1784 | 22 |
2184259 | 2184259 | 2022-02-05 | Yuma | Colorado | 8125 | 1784 | 22 |
2181007 | 2181007 | 2022-02-04 | Yuma | Colorado | 8125 | 1784 | 22 |
2177756 | 2177756 | 2022-02-03 | Yuma | Colorado | 8125 | 1777 | 22 |
2174503 | 2174503 | 2022-02-02 | Yuma | Colorado | 8125 | 1771 | 22 |
2171212 | 2171212 | 2022-02-01 | Grand | Colorado | 8049 | 3307 | 22 |
2171250 | 2171250 | 2022-02-01 | Yuma | Colorado | 8125 | 1755 | 22 |
2167959 | 2167959 | 2022-01-31 | Grand | Colorado | 8049 | 3302 | 22 |
2167997 | 2167997 | 2022-01-31 | Yuma | Colorado | 8125 | 1737 | 22 |
2164704 | 2164704 | 2022-01-30 | Grand | Colorado | 8049 | 3292 | 22 |
2164742 | 2164742 | 2022-01-30 | Yuma | Colorado | 8125 | 1715 | 22 |
2161449 | 2161449 | 2022-01-29 | Grand | Colorado | 8049 | 3271 | 22 |
2161487 | 2161487 | 2022-01-29 | Yuma | Colorado | 8125 | 1703 | 22 |
2158193 | 2158193 | 2022-01-28 | Grand | Colorado | 8049 | 3292 | 22 |
2158231 | 2158231 | 2022-01-28 | Yuma | Colorado | 8125 | 1715 | 22 |
2154940 | 2154940 | 2022-01-27 | Grand | Colorado | 8049 | 3271 | 22 |
2154978 | 2154978 | 2022-01-27 | Yuma | Colorado | 8125 | 1703 | 22 |
2151687 | 2151687 | 2022-01-26 | Grand | Colorado | 8049 | 3248 | 22 |
2151725 | 2151725 | 2022-01-26 | Yuma | Colorado | 8125 | 1687 | 22 |
2148435 | 2148435 | 2022-01-25 | Grand | Colorado | 8049 | 3232 | 22 |
2148473 | 2148473 | 2022-01-25 | Yuma | Colorado | 8125 | 1674 | 22 |
2145183 | 2145183 | 2022-01-24 | Grand | Colorado | 8049 | 3219 | 22 |
2145221 | 2145221 | 2022-01-24 | Yuma | Colorado | 8125 | 1663 | 22 |
2141966 | 2141966 | 2022-01-23 | Yuma | Colorado | 8125 | 1644 | 22 |
2138711 | 2138711 | 2022-01-22 | Yuma | Colorado | 8125 | 1644 | 22 |
2135455 | 2135455 | 2022-01-21 | Yuma | Colorado | 8125 | 1644 | 22 |
2132203 | 2132203 | 2022-01-20 | Yuma | Colorado | 8125 | 1629 | 22 |
2128950 | 2128950 | 2022-01-19 | Yuma | Colorado | 8125 | 1622 | 22 |
2125696 | 2125696 | 2022-01-18 | Yuma | Colorado | 8125 | 1615 | 22 |
2122444 | 2122444 | 2022-01-17 | Yuma | Colorado | 8125 | 1600 | 22 |
2119192 | 2119192 | 2022-01-16 | Yuma | Colorado | 8125 | 1583 | 22 |
2115940 | 2115940 | 2022-01-15 | Yuma | Colorado | 8125 | 1583 | 22 |
2112689 | 2112689 | 2022-01-14 | Yuma | Colorado | 8125 | 1583 | 22 |
2109437 | 2109437 | 2022-01-13 | Yuma | Colorado | 8125 | 1574 | 22 |
2106186 | 2106186 | 2022-01-12 | Yuma | Colorado | 8125 | 1564 | 22 |
2102935 | 2102935 | 2022-01-11 | Yuma | Colorado | 8125 | 1557 | 22 |
2099684 | 2099684 | 2022-01-10 | Yuma | Colorado | 8125 | 1537 | 22 |
2096433 | 2096433 | 2022-01-09 | Yuma | Colorado | 8125 | 1517 | 22 |
2093181 | 2093181 | 2022-01-08 | Yuma | Colorado | 8125 | 1517 | 22 |
2089929 | 2089929 | 2022-01-07 | Yuma | Colorado | 8125 | 1517 | 22 |
2086678 | 2086678 | 2022-01-06 | Yuma | Colorado | 8125 | 1514 | 22 |
2083426 | 2083426 | 2022-01-05 | Yuma | Colorado | 8125 | 1509 | 22 |
2080174 | 2080174 | 2022-01-04 | Yuma | Colorado | 8125 | 1504 | 22 |
2076922 | 2076922 | 2022-01-03 | Yuma | Colorado | 8125 | 1494 | 22 |
2073671 | 2073671 | 2022-01-02 | Yuma | Colorado | 8125 | 1481 | 22 |
2070420 | 2070420 | 2022-01-01 | Yuma | Colorado | 8125 | 1481 | 22 |
2067169 | 2067169 | 2021-12-31 | Yuma | Colorado | 8125 | 1481 | 22 |
1985875 | 1985875 | 2021-12-06 | Huerfano | Colorado | 8055 | 848 | 22 |
1982625 | 1982625 | 2021-12-05 | Huerfano | Colorado | 8055 | 845 | 22 |
1979375 | 1979375 | 2021-12-04 | Huerfano | Colorado | 8055 | 845 | 22 |
1976125 | 1976125 | 2021-12-03 | Huerfano | Colorado | 8055 | 845 | 22 |
1969630 | 1969630 | 2021-12-01 | Kit Carson | Colorado | 8063 | 1155 | 22 |
1872131 | 1872131 | 2021-11-01 | Las Animas | Colorado | 8071 | 1889 | 22 |
1868882 | 1868882 | 2021-10-31 | Las Animas | Colorado | 8071 | 1870 | 22 |
1868899 | 1868899 | 2021-10-31 | Rio Grande | Colorado | 8105 | 1537 | 22 |
1865633 | 1865633 | 2021-10-30 | Las Animas | Colorado | 8071 | 1870 | 22 |
1865650 | 1865650 | 2021-10-30 | Rio Grande | Colorado | 8105 | 1537 | 22 |
1862384 | 1862384 | 2021-10-29 | Las Animas | Colorado | 8071 | 1870 | 22 |
1862401 | 1862401 | 2021-10-29 | Rio Grande | Colorado | 8105 | 1537 | 22 |
1859135 | 1859135 | 2021-10-28 | Las Animas | Colorado | 8071 | 1858 | 22 |
1859152 | 1859152 | 2021-10-28 | Rio Grande | Colorado | 8105 | 1527 | 22 |
1855886 | 1855886 | 2021-10-27 | Las Animas | Colorado | 8071 | 1850 | 22 |
1855903 | 1855903 | 2021-10-27 | Rio Grande | Colorado | 8105 | 1520 | 22 |
1852637 | 1852637 | 2021-10-26 | Las Animas | Colorado | 8071 | 1822 | 22 |
1852654 | 1852654 | 2021-10-26 | Rio Grande | Colorado | 8105 | 1505 | 22 |
1849388 | 1849388 | 2021-10-25 | Las Animas | Colorado | 8071 | 1811 | 22 |
1849405 | 1849405 | 2021-10-25 | Rio Grande | Colorado | 8105 | 1491 | 22 |
1846115 | 1846115 | 2021-10-24 | Crowley | Colorado | 8025 | 2378 | 22 |
1846138 | 1846138 | 2021-10-24 | Las Animas | Colorado | 8071 | 1801 | 22 |
1846155 | 1846155 | 2021-10-24 | Rio Grande | Colorado | 8105 | 1477 | 22 |
1842865 | 1842865 | 2021-10-23 | Crowley | Colorado | 8025 | 2378 | 22 |
1842888 | 1842888 | 2021-10-23 | Las Animas | Colorado | 8071 | 1801 | 22 |
1842905 | 1842905 | 2021-10-23 | Rio Grande | Colorado | 8105 | 1477 | 22 |
1839615 | 1839615 | 2021-10-22 | Crowley | Colorado | 8025 | 2378 | 22 |
1839638 | 1839638 | 2021-10-22 | Las Animas | Colorado | 8071 | 1801 | 22 |
1839655 | 1839655 | 2021-10-22 | Rio Grande | Colorado | 8105 | 1477 | 22 |
1836366 | 1836366 | 2021-10-21 | Crowley | Colorado | 8025 | 2375 | 22 |
1836389 | 1836389 | 2021-10-21 | Las Animas | Colorado | 8071 | 1777 | 22 |
1833117 | 1833117 | 2021-10-20 | Crowley | Colorado | 8025 | 2372 | 22 |
1833140 | 1833140 | 2021-10-20 | Las Animas | Colorado | 8071 | 1767 | 22 |
1829868 | 1829868 | 2021-10-19 | Crowley | Colorado | 8025 | 2368 | 22 |
1826619 | 1826619 | 2021-10-18 | Crowley | Colorado | 8025 | 2365 | 22 |
1826627 | 1826627 | 2021-10-18 | Elbert | Colorado | 8039 | 2622 | 22 |
1823370 | 1823370 | 2021-10-17 | Crowley | Colorado | 8025 | 2357 | 22 |
1823378 | 1823378 | 2021-10-17 | Elbert | Colorado | 8039 | 2597 | 22 |
1820121 | 1820121 | 2021-10-16 | Crowley | Colorado | 8025 | 2357 | 22 |
1820129 | 1820129 | 2021-10-16 | Elbert | Colorado | 8039 | 2597 | 22 |
1816872 | 1816872 | 2021-10-15 | Crowley | Colorado | 8025 | 2357 | 22 |
1816880 | 1816880 | 2021-10-15 | Elbert | Colorado | 8039 | 2597 | 22 |
1813624 | 1813624 | 2021-10-14 | Crowley | Colorado | 8025 | 2341 | 22 |
1813632 | 1813632 | 2021-10-14 | Elbert | Colorado | 8039 | 2585 | 22 |
1810375 | 1810375 | 2021-10-13 | Crowley | Colorado | 8025 | 2337 | 22 |
1810383 | 1810383 | 2021-10-13 | Elbert | Colorado | 8039 | 2567 | 22 |
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);