ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,099 rows where deaths = 3 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Gilpin 330
- Kiowa 243
- Ouray 213
- Kit Carson 190
- Clear Creek 146
- Sedgwick 98
- Lincoln 86
- Rio Blanco 73
- Montezuma 71
- Elbert 60
- Conejos 59
- Delta 53
- Archuleta 52
- San Miguel 43
- Costilla 35
- Teller 33
- Alamosa 21
- Baca 21
- Logan 21
- La Plata 20
- Rio Grande 19
- Cheyenne 16
- Las Animas 16
- Summit 16
- Pitkin 13
- Dolores 11
- Gunnison 11
- Phillips 11
- Custer 10
- Yuma 10
- …
state 1
- Colorado · 2,099 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2132174 | 2132174 | 2022-01-20 | Lake | Colorado | 8065 | 1649 | 3 |
2128921 | 2128921 | 2022-01-19 | Lake | Colorado | 8065 | 1631 | 3 |
2083387 | 2083387 | 2022-01-05 | Gilpin | Colorado | 8047 | 656 | 3 |
2080135 | 2080135 | 2022-01-04 | Gilpin | Colorado | 8047 | 637 | 3 |
2076883 | 2076883 | 2022-01-03 | Gilpin | Colorado | 8047 | 630 | 3 |
2073632 | 2073632 | 2022-01-02 | Gilpin | Colorado | 8047 | 616 | 3 |
2070381 | 2070381 | 2022-01-01 | Gilpin | Colorado | 8047 | 616 | 3 |
2067130 | 2067130 | 2021-12-31 | Gilpin | Colorado | 8047 | 616 | 3 |
2063879 | 2063879 | 2021-12-30 | Gilpin | Colorado | 8047 | 611 | 3 |
2060629 | 2060629 | 2021-12-29 | Gilpin | Colorado | 8047 | 590 | 3 |
2057380 | 2057380 | 2021-12-28 | Gilpin | Colorado | 8047 | 582 | 3 |
2054131 | 2054131 | 2021-12-27 | Gilpin | Colorado | 8047 | 579 | 3 |
2050881 | 2050881 | 2021-12-26 | Gilpin | Colorado | 8047 | 575 | 3 |
2047631 | 2047631 | 2021-12-25 | Gilpin | Colorado | 8047 | 575 | 3 |
2044381 | 2044381 | 2021-12-24 | Gilpin | Colorado | 8047 | 575 | 3 |
2041132 | 2041132 | 2021-12-23 | Gilpin | Colorado | 8047 | 571 | 3 |
2037882 | 2037882 | 2021-12-22 | Gilpin | Colorado | 8047 | 566 | 3 |
2034632 | 2034632 | 2021-12-21 | Gilpin | Colorado | 8047 | 565 | 3 |
2031382 | 2031382 | 2021-12-20 | Gilpin | Colorado | 8047 | 560 | 3 |
2028131 | 2028131 | 2021-12-19 | Gilpin | Colorado | 8047 | 557 | 3 |
2024880 | 2024880 | 2021-12-18 | Gilpin | Colorado | 8047 | 557 | 3 |
2021629 | 2021629 | 2021-12-17 | Gilpin | Colorado | 8047 | 557 | 3 |
2018378 | 2018378 | 2021-12-16 | Gilpin | Colorado | 8047 | 554 | 3 |
2015128 | 2015128 | 2021-12-15 | Gilpin | Colorado | 8047 | 553 | 3 |
1982621 | 1982621 | 2021-12-05 | Gilpin | Colorado | 8047 | 538 | 3 |
1979371 | 1979371 | 2021-12-04 | Gilpin | Colorado | 8047 | 538 | 3 |
1976121 | 1976121 | 2021-12-03 | Gilpin | Colorado | 8047 | 538 | 3 |
1972872 | 1972872 | 2021-12-02 | Gilpin | Colorado | 8047 | 538 | 3 |
1969622 | 1969622 | 2021-12-01 | Gilpin | Colorado | 8047 | 531 | 3 |
1966372 | 1966372 | 2021-11-30 | Gilpin | Colorado | 8047 | 531 | 3 |
1963120 | 1963120 | 2021-11-29 | Gilpin | Colorado | 8047 | 531 | 3 |
1959869 | 1959869 | 2021-11-28 | Gilpin | Colorado | 8047 | 529 | 3 |
1956618 | 1956618 | 2021-11-27 | Gilpin | Colorado | 8047 | 529 | 3 |
1953367 | 1953367 | 2021-11-26 | Gilpin | Colorado | 8047 | 529 | 3 |
1950116 | 1950116 | 2021-11-25 | Gilpin | Colorado | 8047 | 529 | 3 |
1946865 | 1946865 | 2021-11-24 | Gilpin | Colorado | 8047 | 524 | 3 |
1943614 | 1943614 | 2021-11-23 | Gilpin | Colorado | 8047 | 523 | 3 |
1940364 | 1940364 | 2021-11-22 | Gilpin | Colorado | 8047 | 522 | 3 |
1937114 | 1937114 | 2021-11-21 | Gilpin | Colorado | 8047 | 520 | 3 |
1933864 | 1933864 | 2021-11-20 | Gilpin | Colorado | 8047 | 520 | 3 |
1930612 | 1930612 | 2021-11-19 | Gilpin | Colorado | 8047 | 520 | 3 |
1927362 | 1927362 | 2021-11-18 | Gilpin | Colorado | 8047 | 518 | 3 |
1924112 | 1924112 | 2021-11-17 | Gilpin | Colorado | 8047 | 513 | 3 |
1920863 | 1920863 | 2021-11-16 | Gilpin | Colorado | 8047 | 517 | 3 |
1917613 | 1917613 | 2021-11-15 | Gilpin | Colorado | 8047 | 510 | 3 |
1914363 | 1914363 | 2021-11-14 | Gilpin | Colorado | 8047 | 497 | 3 |
1911113 | 1911113 | 2021-11-13 | Gilpin | Colorado | 8047 | 497 | 3 |
1907864 | 1907864 | 2021-11-12 | Gilpin | Colorado | 8047 | 497 | 3 |
1904615 | 1904615 | 2021-11-11 | Gilpin | Colorado | 8047 | 497 | 3 |
1901365 | 1901365 | 2021-11-10 | Gilpin | Colorado | 8047 | 493 | 3 |
1898115 | 1898115 | 2021-11-09 | Gilpin | Colorado | 8047 | 487 | 3 |
1894865 | 1894865 | 2021-11-08 | Gilpin | Colorado | 8047 | 487 | 3 |
1891615 | 1891615 | 2021-11-07 | Gilpin | Colorado | 8047 | 480 | 3 |
1888365 | 1888365 | 2021-11-06 | Gilpin | Colorado | 8047 | 480 | 3 |
1885115 | 1885115 | 2021-11-05 | Gilpin | Colorado | 8047 | 480 | 3 |
1881859 | 1881859 | 2021-11-04 | Dolores | Colorado | 8033 | 239 | 3 |
1881866 | 1881866 | 2021-11-04 | Gilpin | Colorado | 8047 | 473 | 3 |
1878610 | 1878610 | 2021-11-03 | Dolores | Colorado | 8033 | 239 | 3 |
1878617 | 1878617 | 2021-11-03 | Gilpin | Colorado | 8047 | 467 | 3 |
1875361 | 1875361 | 2021-11-02 | Dolores | Colorado | 8033 | 239 | 3 |
1875368 | 1875368 | 2021-11-02 | Gilpin | Colorado | 8047 | 461 | 3 |
1872112 | 1872112 | 2021-11-01 | Dolores | Colorado | 8033 | 237 | 3 |
1872119 | 1872119 | 2021-11-01 | Gilpin | Colorado | 8047 | 459 | 3 |
1868863 | 1868863 | 2021-10-31 | Dolores | Colorado | 8033 | 237 | 3 |
1868870 | 1868870 | 2021-10-31 | Gilpin | Colorado | 8047 | 454 | 3 |
1865614 | 1865614 | 2021-10-30 | Dolores | Colorado | 8033 | 237 | 3 |
1865621 | 1865621 | 2021-10-30 | Gilpin | Colorado | 8047 | 454 | 3 |
1862365 | 1862365 | 2021-10-29 | Dolores | Colorado | 8033 | 237 | 3 |
1862372 | 1862372 | 2021-10-29 | Gilpin | Colorado | 8047 | 454 | 3 |
1859116 | 1859116 | 2021-10-28 | Dolores | Colorado | 8033 | 237 | 3 |
1859123 | 1859123 | 2021-10-28 | Gilpin | Colorado | 8047 | 453 | 3 |
1855867 | 1855867 | 2021-10-27 | Dolores | Colorado | 8033 | 237 | 3 |
1855874 | 1855874 | 2021-10-27 | Gilpin | Colorado | 8047 | 448 | 3 |
1852618 | 1852618 | 2021-10-26 | Dolores | Colorado | 8033 | 237 | 3 |
1852625 | 1852625 | 2021-10-26 | Gilpin | Colorado | 8047 | 438 | 3 |
1849369 | 1849369 | 2021-10-25 | Dolores | Colorado | 8033 | 237 | 3 |
1849376 | 1849376 | 2021-10-25 | Gilpin | Colorado | 8047 | 437 | 3 |
1846126 | 1846126 | 2021-10-24 | Gilpin | Colorado | 8047 | 432 | 3 |
1842876 | 1842876 | 2021-10-23 | Gilpin | Colorado | 8047 | 432 | 3 |
1839626 | 1839626 | 2021-10-22 | Gilpin | Colorado | 8047 | 432 | 3 |
1836377 | 1836377 | 2021-10-21 | Gilpin | Colorado | 8047 | 427 | 3 |
1833128 | 1833128 | 2021-10-20 | Gilpin | Colorado | 8047 | 424 | 3 |
1829879 | 1829879 | 2021-10-19 | Gilpin | Colorado | 8047 | 419 | 3 |
1826630 | 1826630 | 2021-10-18 | Gilpin | Colorado | 8047 | 417 | 3 |
1823381 | 1823381 | 2021-10-17 | Gilpin | Colorado | 8047 | 416 | 3 |
1820132 | 1820132 | 2021-10-16 | Gilpin | Colorado | 8047 | 416 | 3 |
1816883 | 1816883 | 2021-10-15 | Gilpin | Colorado | 8047 | 416 | 3 |
1813635 | 1813635 | 2021-10-14 | Gilpin | Colorado | 8047 | 415 | 3 |
1810386 | 1810386 | 2021-10-13 | Gilpin | Colorado | 8047 | 412 | 3 |
1807137 | 1807137 | 2021-10-12 | Gilpin | Colorado | 8047 | 410 | 3 |
1807170 | 1807170 | 2021-10-12 | San Miguel | Colorado | 8113 | 1148 | 3 |
1803886 | 1803886 | 2021-10-11 | Gilpin | Colorado | 8047 | 410 | 3 |
1803919 | 1803919 | 2021-10-11 | San Miguel | Colorado | 8113 | 1147 | 3 |
1800637 | 1800637 | 2021-10-10 | Gilpin | Colorado | 8047 | 407 | 3 |
1800670 | 1800670 | 2021-10-10 | San Miguel | Colorado | 8113 | 1142 | 3 |
1797388 | 1797388 | 2021-10-09 | Gilpin | Colorado | 8047 | 407 | 3 |
1797421 | 1797421 | 2021-10-09 | San Miguel | Colorado | 8113 | 1142 | 3 |
1794139 | 1794139 | 2021-10-08 | Gilpin | Colorado | 8047 | 407 | 3 |
1794172 | 1794172 | 2021-10-08 | San Miguel | Colorado | 8113 | 1142 | 3 |
1790891 | 1790891 | 2021-10-07 | Gilpin | Colorado | 8047 | 406 | 3 |
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);