ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 39 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 |
---|---|---|---|---|---|---|---|
2464010 | 2464010 | 2022-05-02 | Elbert | Colorado | 8039 | 4814 | 39 |
2460754 | 2460754 | 2022-05-01 | Elbert | Colorado | 8039 | 4813 | 39 |
2457498 | 2457498 | 2022-04-30 | Elbert | Colorado | 8039 | 4813 | 39 |
2454242 | 2454242 | 2022-04-29 | Elbert | Colorado | 8039 | 4813 | 39 |
2450986 | 2450986 | 2022-04-28 | Elbert | Colorado | 8039 | 4813 | 39 |
2447730 | 2447730 | 2022-04-27 | Elbert | Colorado | 8039 | 4810 | 39 |
2444474 | 2444474 | 2022-04-26 | Elbert | Colorado | 8039 | 4809 | 39 |
2441218 | 2441218 | 2022-04-25 | Elbert | Colorado | 8039 | 4806 | 39 |
2437962 | 2437962 | 2022-04-24 | Elbert | Colorado | 8039 | 4800 | 39 |
2434706 | 2434706 | 2022-04-23 | Elbert | Colorado | 8039 | 4800 | 39 |
2431450 | 2431450 | 2022-04-22 | Elbert | Colorado | 8039 | 4800 | 39 |
2428194 | 2428194 | 2022-04-21 | Elbert | Colorado | 8039 | 4798 | 39 |
2278538 | 2278538 | 2022-03-06 | Las Animas | Colorado | 8071 | 3427 | 39 |
2275285 | 2275285 | 2022-03-05 | Las Animas | Colorado | 8071 | 3427 | 39 |
2272032 | 2272032 | 2022-03-04 | Las Animas | Colorado | 8071 | 3427 | 39 |
2268780 | 2268780 | 2022-03-03 | Las Animas | Colorado | 8071 | 3424 | 39 |
2265527 | 2265527 | 2022-03-02 | Las Animas | Colorado | 8071 | 3429 | 39 |
2262276 | 2262276 | 2022-03-01 | Las Animas | Colorado | 8071 | 3419 | 39 |
2259025 | 2259025 | 2022-02-28 | Las Animas | Colorado | 8071 | 3414 | 39 |
2255774 | 2255774 | 2022-02-27 | Las Animas | Colorado | 8071 | 3405 | 39 |
2252523 | 2252523 | 2022-02-26 | Las Animas | Colorado | 8071 | 3405 | 39 |
2249272 | 2249272 | 2022-02-25 | Las Animas | Colorado | 8071 | 3405 | 39 |
2246021 | 2246021 | 2022-02-24 | Las Animas | Colorado | 8071 | 3403 | 39 |
2242770 | 2242770 | 2022-02-23 | Las Animas | Colorado | 8071 | 3402 | 39 |
2239519 | 2239519 | 2022-02-22 | Las Animas | Colorado | 8071 | 3396 | 39 |
2236268 | 2236268 | 2022-02-21 | Las Animas | Colorado | 8071 | 3390 | 39 |
2233017 | 2233017 | 2022-02-20 | Las Animas | Colorado | 8071 | 3376 | 39 |
2229766 | 2229766 | 2022-02-19 | Las Animas | Colorado | 8071 | 3376 | 39 |
2226515 | 2226515 | 2022-02-18 | Las Animas | Colorado | 8071 | 3376 | 39 |
2223264 | 2223264 | 2022-02-17 | Las Animas | Colorado | 8071 | 3365 | 39 |
2220013 | 2220013 | 2022-02-16 | Las Animas | Colorado | 8071 | 3359 | 39 |
2216762 | 2216762 | 2022-02-15 | Las Animas | Colorado | 8071 | 3351 | 39 |
2213511 | 2213511 | 2022-02-14 | Las Animas | Colorado | 8071 | 3343 | 39 |
2210259 | 2210259 | 2022-02-13 | Las Animas | Colorado | 8071 | 3329 | 39 |
2207006 | 2207006 | 2022-02-12 | Las Animas | Colorado | 8071 | 3329 | 39 |
2203753 | 2203753 | 2022-02-11 | Las Animas | Colorado | 8071 | 3329 | 39 |
2200500 | 2200500 | 2022-02-10 | Las Animas | Colorado | 8071 | 3310 | 39 |
2197246 | 2197246 | 2022-02-09 | Las Animas | Colorado | 8071 | 3307 | 39 |
2193992 | 2193992 | 2022-02-08 | Las Animas | Colorado | 8071 | 3292 | 39 |
2190738 | 2190738 | 2022-02-07 | Las Animas | Colorado | 8071 | 3268 | 39 |
2164687 | 2164687 | 2022-01-30 | Chaffee | Colorado | 8015 | 3972 | 39 |
2161432 | 2161432 | 2022-01-29 | Chaffee | Colorado | 8015 | 3953 | 39 |
2158176 | 2158176 | 2022-01-28 | Chaffee | Colorado | 8015 | 3972 | 39 |
2154923 | 2154923 | 2022-01-27 | Chaffee | Colorado | 8015 | 3953 | 39 |
2151670 | 2151670 | 2022-01-26 | Chaffee | Colorado | 8015 | 3932 | 39 |
2148418 | 2148418 | 2022-01-25 | Chaffee | Colorado | 8015 | 3891 | 39 |
2145166 | 2145166 | 2022-01-24 | Chaffee | Colorado | 8015 | 3848 | 39 |
2141911 | 2141911 | 2022-01-23 | Chaffee | Colorado | 8015 | 3806 | 39 |
2138656 | 2138656 | 2022-01-22 | Chaffee | Colorado | 8015 | 3806 | 39 |
2135400 | 2135400 | 2022-01-21 | Chaffee | Colorado | 8015 | 3806 | 39 |
2132148 | 2132148 | 2022-01-20 | Chaffee | Colorado | 8015 | 3766 | 39 |
2128895 | 2128895 | 2022-01-19 | Chaffee | Colorado | 8015 | 3731 | 39 |
2125641 | 2125641 | 2022-01-18 | Chaffee | Colorado | 8015 | 3700 | 39 |
2122389 | 2122389 | 2022-01-17 | Chaffee | Colorado | 8015 | 3672 | 39 |
2034613 | 2034613 | 2021-12-21 | Bent | Colorado | 8011 | 1943 | 39 |
2028160 | 2028160 | 2021-12-19 | Rio Grande | Colorado | 8105 | 1928 | 39 |
2024909 | 2024909 | 2021-12-18 | Rio Grande | Colorado | 8105 | 1928 | 39 |
2021658 | 2021658 | 2021-12-17 | Rio Grande | Colorado | 8105 | 1928 | 39 |
2018407 | 2018407 | 2021-12-16 | Rio Grande | Colorado | 8105 | 1925 | 39 |
1995649 | 1995649 | 2021-12-09 | Prowers | Colorado | 8099 | 1988 | 39 |
1992398 | 1992398 | 2021-12-08 | Prowers | Colorado | 8099 | 1982 | 39 |
1989147 | 1989147 | 2021-12-07 | Prowers | Colorado | 8099 | 1978 | 39 |
1985897 | 1985897 | 2021-12-06 | Prowers | Colorado | 8099 | 1966 | 39 |
1982647 | 1982647 | 2021-12-05 | Prowers | Colorado | 8099 | 1948 | 39 |
1979397 | 1979397 | 2021-12-04 | Prowers | Colorado | 8099 | 1948 | 39 |
1976147 | 1976147 | 2021-12-03 | Prowers | Colorado | 8099 | 1948 | 39 |
1940400 | 1940400 | 2021-11-22 | Teller | Colorado | 8119 | 3212 | 39 |
1937150 | 1937150 | 2021-11-21 | Teller | Colorado | 8119 | 3188 | 39 |
1933900 | 1933900 | 2021-11-20 | Teller | Colorado | 8119 | 3188 | 39 |
1930648 | 1930648 | 2021-11-19 | Teller | Colorado | 8119 | 3188 | 39 |
1927398 | 1927398 | 2021-11-18 | Teller | Colorado | 8119 | 3174 | 39 |
1924099 | 1924099 | 2021-11-17 | Conejos | Colorado | 8021 | 1094 | 39 |
1924148 | 1924148 | 2021-11-17 | Teller | Colorado | 8119 | 3142 | 39 |
1920850 | 1920850 | 2021-11-16 | Conejos | Colorado | 8021 | 1090 | 39 |
1920899 | 1920899 | 2021-11-16 | Teller | Colorado | 8119 | 3135 | 39 |
1823398 | 1823398 | 2021-10-17 | Moffat | Colorado | 8081 | 1905 | 39 |
1820149 | 1820149 | 2021-10-16 | Moffat | Colorado | 8081 | 1905 | 39 |
1816900 | 1816900 | 2021-10-15 | Moffat | Colorado | 8081 | 1905 | 39 |
1813652 | 1813652 | 2021-10-14 | Moffat | Colorado | 8081 | 1889 | 39 |
1693403 | 1693403 | 2021-09-07 | Alamosa | Colorado | 8003 | 1963 | 39 |
1690154 | 1690154 | 2021-09-06 | Alamosa | Colorado | 8003 | 1956 | 39 |
1686904 | 1686904 | 2021-09-05 | Alamosa | Colorado | 8003 | 1940 | 39 |
1683654 | 1683654 | 2021-09-04 | Alamosa | Colorado | 8003 | 1940 | 39 |
1680403 | 1680403 | 2021-09-03 | Alamosa | Colorado | 8003 | 1940 | 39 |
1677155 | 1677155 | 2021-09-02 | Alamosa | Colorado | 8003 | 1929 | 39 |
1673908 | 1673908 | 2021-09-01 | Alamosa | Colorado | 8003 | 1924 | 39 |
1670660 | 1670660 | 2021-08-31 | Alamosa | Colorado | 8003 | 1910 | 39 |
1667413 | 1667413 | 2021-08-30 | Alamosa | Colorado | 8003 | 1894 | 39 |
1664166 | 1664166 | 2021-08-29 | Alamosa | Colorado | 8003 | 1882 | 39 |
1660918 | 1660918 | 2021-08-28 | Alamosa | Colorado | 8003 | 1882 | 39 |
1657670 | 1657670 | 2021-08-27 | Alamosa | Colorado | 8003 | 1882 | 39 |
1654422 | 1654422 | 2021-08-26 | Alamosa | Colorado | 8003 | 1877 | 39 |
1651175 | 1651175 | 2021-08-25 | Alamosa | Colorado | 8003 | 1873 | 39 |
1647926 | 1647926 | 2021-08-24 | Alamosa | Colorado | 8003 | 1870 | 39 |
1644678 | 1644678 | 2021-08-23 | Alamosa | Colorado | 8003 | 1870 | 39 |
1641428 | 1641428 | 2021-08-22 | Alamosa | Colorado | 8003 | 1864 | 39 |
1638178 | 1638178 | 2021-08-21 | Alamosa | Colorado | 8003 | 1864 | 39 |
1634928 | 1634928 | 2021-08-20 | Alamosa | Colorado | 8003 | 1864 | 39 |
1631679 | 1631679 | 2021-08-19 | Alamosa | Colorado | 8003 | 1862 | 39 |
1628432 | 1628432 | 2021-08-18 | Alamosa | Colorado | 8003 | 1860 | 39 |
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);