ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
145 rows where deaths = 42 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2304526 | 2304526 | 2022-03-14 | Chaffee | Colorado | 8015 | 4349 | 42 |
2301274 | 2301274 | 2022-03-13 | Chaffee | Colorado | 8015 | 4347 | 42 |
2298022 | 2298022 | 2022-03-12 | Chaffee | Colorado | 8015 | 4347 | 42 |
2294770 | 2294770 | 2022-03-11 | Chaffee | Colorado | 8015 | 4347 | 42 |
2291518 | 2291518 | 2022-03-10 | Chaffee | Colorado | 8015 | 4344 | 42 |
2288266 | 2288266 | 2022-03-09 | Chaffee | Colorado | 8015 | 4343 | 42 |
2285015 | 2285015 | 2022-03-08 | Chaffee | Colorado | 8015 | 4335 | 42 |
2281763 | 2281763 | 2022-03-07 | Chaffee | Colorado | 8015 | 4332 | 42 |
2278510 | 2278510 | 2022-03-06 | Chaffee | Colorado | 8015 | 4302 | 42 |
2275257 | 2275257 | 2022-03-05 | Chaffee | Colorado | 8015 | 4302 | 42 |
2272004 | 2272004 | 2022-03-04 | Chaffee | Colorado | 8015 | 4302 | 42 |
2268752 | 2268752 | 2022-03-03 | Chaffee | Colorado | 8015 | 4305 | 42 |
2265499 | 2265499 | 2022-03-02 | Chaffee | Colorado | 8015 | 4305 | 42 |
2262248 | 2262248 | 2022-03-01 | Chaffee | Colorado | 8015 | 4298 | 42 |
2258997 | 2258997 | 2022-02-28 | Chaffee | Colorado | 8015 | 4291 | 42 |
2255746 | 2255746 | 2022-02-27 | Chaffee | Colorado | 8015 | 4281 | 42 |
2252495 | 2252495 | 2022-02-26 | Chaffee | Colorado | 8015 | 4281 | 42 |
2249244 | 2249244 | 2022-02-25 | Chaffee | Colorado | 8015 | 4281 | 42 |
2245993 | 2245993 | 2022-02-24 | Chaffee | Colorado | 8015 | 4278 | 42 |
2242742 | 2242742 | 2022-02-23 | Chaffee | Colorado | 8015 | 4270 | 42 |
2239491 | 2239491 | 2022-02-22 | Chaffee | Colorado | 8015 | 4264 | 42 |
2236240 | 2236240 | 2022-02-21 | Chaffee | Colorado | 8015 | 4263 | 42 |
2223236 | 2223236 | 2022-02-17 | Chaffee | Colorado | 8015 | 4238 | 42 |
2219985 | 2219985 | 2022-02-16 | Chaffee | Colorado | 8015 | 4232 | 42 |
2216734 | 2216734 | 2022-02-15 | Chaffee | Colorado | 8015 | 4213 | 42 |
2213483 | 2213483 | 2022-02-14 | Chaffee | Colorado | 8015 | 4195 | 42 |
2174493 | 2174493 | 2022-02-02 | Rio Grande | Colorado | 8105 | 2531 | 42 |
2171240 | 2171240 | 2022-02-01 | Rio Grande | Colorado | 8105 | 2514 | 42 |
2167987 | 2167987 | 2022-01-31 | Rio Grande | Colorado | 8105 | 2499 | 42 |
2073613 | 2073613 | 2022-01-02 | Bent | Colorado | 8011 | 1958 | 42 |
2070362 | 2070362 | 2022-01-01 | Bent | Colorado | 8011 | 1958 | 42 |
2067111 | 2067111 | 2021-12-31 | Bent | Colorado | 8011 | 1958 | 42 |
2063860 | 2063860 | 2021-12-30 | Bent | Colorado | 8011 | 1954 | 42 |
2060610 | 2060610 | 2021-12-29 | Bent | Colorado | 8011 | 1950 | 42 |
2057361 | 2057361 | 2021-12-28 | Bent | Colorado | 8011 | 1948 | 42 |
2054157 | 2054157 | 2021-12-27 | Prowers | Colorado | 8099 | 2035 | 42 |
2050907 | 2050907 | 2021-12-26 | Prowers | Colorado | 8099 | 2032 | 42 |
2047657 | 2047657 | 2021-12-25 | Prowers | Colorado | 8099 | 2032 | 42 |
2044407 | 2044407 | 2021-12-24 | Prowers | Colorado | 8099 | 2032 | 42 |
2041158 | 2041158 | 2021-12-23 | Prowers | Colorado | 8099 | 2030 | 42 |
2037908 | 2037908 | 2021-12-22 | Prowers | Colorado | 8099 | 2030 | 42 |
2034658 | 2034658 | 2021-12-21 | Prowers | Colorado | 8099 | 2027 | 42 |
2031408 | 2031408 | 2021-12-20 | Prowers | Colorado | 8099 | 2026 | 42 |
2028157 | 2028157 | 2021-12-19 | Prowers | Colorado | 8099 | 2023 | 42 |
2024906 | 2024906 | 2021-12-18 | Prowers | Colorado | 8099 | 2023 | 42 |
2021655 | 2021655 | 2021-12-17 | Prowers | Colorado | 8099 | 2023 | 42 |
2018404 | 2018404 | 2021-12-16 | Prowers | Colorado | 8099 | 2020 | 42 |
2015154 | 2015154 | 2021-12-15 | Prowers | Colorado | 8099 | 2017 | 42 |
2011903 | 2011903 | 2021-12-14 | Prowers | Colorado | 8099 | 2003 | 42 |
2005362 | 2005362 | 2021-12-12 | Conejos | Colorado | 8021 | 1162 | 42 |
2002111 | 2002111 | 2021-12-11 | Conejos | Colorado | 8021 | 1162 | 42 |
1998861 | 1998861 | 2021-12-10 | Conejos | Colorado | 8021 | 1162 | 42 |
1995610 | 1995610 | 2021-12-09 | Conejos | Colorado | 8021 | 1159 | 42 |
1992359 | 1992359 | 2021-12-08 | Conejos | Colorado | 8021 | 1155 | 42 |
1989108 | 1989108 | 2021-12-07 | Conejos | Colorado | 8021 | 1150 | 42 |
1985858 | 1985858 | 2021-12-06 | Conejos | Colorado | 8021 | 1147 | 42 |
1982608 | 1982608 | 2021-12-05 | Conejos | Colorado | 8021 | 1141 | 42 |
1979358 | 1979358 | 2021-12-04 | Conejos | Colorado | 8021 | 1141 | 42 |
1976108 | 1976108 | 2021-12-03 | Conejos | Colorado | 8021 | 1141 | 42 |
1972859 | 1972859 | 2021-12-02 | Conejos | Colorado | 8021 | 1138 | 42 |
1969609 | 1969609 | 2021-12-01 | Conejos | Colorado | 8021 | 1136 | 42 |
1969658 | 1969658 | 2021-12-01 | Teller | Colorado | 8119 | 3319 | 42 |
1966359 | 1966359 | 2021-11-30 | Conejos | Colorado | 8021 | 1131 | 42 |
1966408 | 1966408 | 2021-11-30 | Teller | Colorado | 8119 | 3303 | 42 |
1963107 | 1963107 | 2021-11-29 | Conejos | Colorado | 8021 | 1131 | 42 |
1959856 | 1959856 | 2021-11-28 | Conejos | Colorado | 8021 | 1127 | 42 |
1956605 | 1956605 | 2021-11-27 | Conejos | Colorado | 8021 | 1125 | 42 |
1953354 | 1953354 | 2021-11-26 | Conejos | Colorado | 8021 | 1125 | 42 |
1950103 | 1950103 | 2021-11-25 | Conejos | Colorado | 8021 | 1125 | 42 |
1946852 | 1946852 | 2021-11-24 | Conejos | Colorado | 8021 | 1123 | 42 |
1943601 | 1943601 | 2021-11-23 | Conejos | Colorado | 8021 | 1120 | 42 |
1924130 | 1924130 | 2021-11-17 | Montezuma | Colorado | 8083 | 3685 | 42 |
1920881 | 1920881 | 2021-11-16 | Montezuma | Colorado | 8083 | 3673 | 42 |
1855891 | 1855891 | 2021-10-27 | Moffat | Colorado | 8081 | 1974 | 42 |
1852642 | 1852642 | 2021-10-26 | Moffat | Colorado | 8081 | 1967 | 42 |
1849393 | 1849393 | 2021-10-25 | Moffat | Colorado | 8081 | 1962 | 42 |
1800614 | 1800614 | 2021-10-10 | Alamosa | Colorado | 8003 | 2250 | 42 |
1797365 | 1797365 | 2021-10-09 | Alamosa | Colorado | 8003 | 2250 | 42 |
1794116 | 1794116 | 2021-10-08 | Alamosa | Colorado | 8003 | 2250 | 42 |
1784370 | 1784370 | 2021-10-05 | Alamosa | Colorado | 8003 | 2206 | 42 |
1781121 | 1781121 | 2021-10-04 | Alamosa | Colorado | 8003 | 2187 | 42 |
1777871 | 1777871 | 2021-10-03 | Alamosa | Colorado | 8003 | 2173 | 42 |
1774621 | 1774621 | 2021-10-02 | Alamosa | Colorado | 8003 | 2173 | 42 |
1771371 | 1771371 | 2021-10-01 | Alamosa | Colorado | 8003 | 2173 | 42 |
1768122 | 1768122 | 2021-09-30 | Alamosa | Colorado | 8003 | 2147 | 42 |
1764873 | 1764873 | 2021-09-29 | Alamosa | Colorado | 8003 | 2133 | 42 |
1761624 | 1761624 | 2021-09-28 | Alamosa | Colorado | 8003 | 2116 | 42 |
1758376 | 1758376 | 2021-09-27 | Alamosa | Colorado | 8003 | 2094 | 42 |
1755128 | 1755128 | 2021-09-26 | Alamosa | Colorado | 8003 | 2077 | 42 |
1751880 | 1751880 | 2021-09-25 | Alamosa | Colorado | 8003 | 2077 | 42 |
1748631 | 1748631 | 2021-09-24 | Alamosa | Colorado | 8003 | 2077 | 42 |
1745381 | 1745381 | 2021-09-23 | Alamosa | Colorado | 8003 | 2062 | 42 |
1742132 | 1742132 | 2021-09-22 | Alamosa | Colorado | 8003 | 2054 | 42 |
1738883 | 1738883 | 2021-09-21 | Alamosa | Colorado | 8003 | 2048 | 42 |
1735634 | 1735634 | 2021-09-20 | Alamosa | Colorado | 8003 | 2041 | 42 |
1732384 | 1732384 | 2021-09-19 | Alamosa | Colorado | 8003 | 2020 | 42 |
1729134 | 1729134 | 2021-09-18 | Alamosa | Colorado | 8003 | 2020 | 42 |
1725884 | 1725884 | 2021-09-17 | Alamosa | Colorado | 8003 | 2020 | 42 |
1722635 | 1722635 | 2021-09-16 | Alamosa | Colorado | 8003 | 2008 | 42 |
1719386 | 1719386 | 2021-09-15 | Alamosa | Colorado | 8003 | 2006 | 42 |
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);