ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 8069 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174475 | 2174475 | 2022-02-02 | Larimer | Colorado | 8069 | 69750 | 435 |
2171222 | 2171222 | 2022-02-01 | Larimer | Colorado | 8069 | 69366 | 435 |
2167969 | 2167969 | 2022-01-31 | Larimer | Colorado | 8069 | 69144 | 435 |
2164714 | 2164714 | 2022-01-30 | Larimer | Colorado | 8069 | 68337 | 431 |
2161459 | 2161459 | 2022-01-29 | Larimer | Colorado | 8069 | 67741 | 427 |
2158203 | 2158203 | 2022-01-28 | Larimer | Colorado | 8069 | 68337 | 431 |
2154950 | 2154950 | 2022-01-27 | Larimer | Colorado | 8069 | 67741 | 427 |
2151697 | 2151697 | 2022-01-26 | Larimer | Colorado | 8069 | 66957 | 424 |
2148445 | 2148445 | 2022-01-25 | Larimer | Colorado | 8069 | 66585 | 424 |
2145193 | 2145193 | 2022-01-24 | Larimer | Colorado | 8069 | 66175 | 420 |
2141938 | 2141938 | 2022-01-23 | Larimer | Colorado | 8069 | 64693 | 420 |
2138683 | 2138683 | 2022-01-22 | Larimer | Colorado | 8069 | 64693 | 420 |
2135427 | 2135427 | 2022-01-21 | Larimer | Colorado | 8069 | 64693 | 420 |
2132175 | 2132175 | 2022-01-20 | Larimer | Colorado | 8069 | 63857 | 418 |
2128922 | 2128922 | 2022-01-19 | Larimer | Colorado | 8069 | 62550 | 418 |
2125668 | 2125668 | 2022-01-18 | Larimer | Colorado | 8069 | 62031 | 416 |
2122416 | 2122416 | 2022-01-17 | Larimer | Colorado | 8069 | 61398 | 416 |
2119164 | 2119164 | 2022-01-16 | Larimer | Colorado | 8069 | 59489 | 410 |
2115912 | 2115912 | 2022-01-15 | Larimer | Colorado | 8069 | 59489 | 410 |
2112661 | 2112661 | 2022-01-14 | Larimer | Colorado | 8069 | 59489 | 410 |
2109409 | 2109409 | 2022-01-13 | Larimer | Colorado | 8069 | 58661 | 410 |
2106158 | 2106158 | 2022-01-12 | Larimer | Colorado | 8069 | 57778 | 410 |
2102907 | 2102907 | 2022-01-11 | Larimer | Colorado | 8069 | 57176 | 409 |
2099656 | 2099656 | 2022-01-10 | Larimer | Colorado | 8069 | 56006 | 408 |
2096405 | 2096405 | 2022-01-09 | Larimer | Colorado | 8069 | 53277 | 403 |
2093153 | 2093153 | 2022-01-08 | Larimer | Colorado | 8069 | 53277 | 403 |
2089901 | 2089901 | 2022-01-07 | Larimer | Colorado | 8069 | 53277 | 403 |
2086650 | 2086650 | 2022-01-06 | Larimer | Colorado | 8069 | 52613 | 403 |
2083398 | 2083398 | 2022-01-05 | Larimer | Colorado | 8069 | 52281 | 402 |
2080146 | 2080146 | 2022-01-04 | Larimer | Colorado | 8069 | 51899 | 401 |
2076894 | 2076894 | 2022-01-03 | Larimer | Colorado | 8069 | 51468 | 401 |
2073643 | 2073643 | 2022-01-02 | Larimer | Colorado | 8069 | 50188 | 400 |
2070392 | 2070392 | 2022-01-01 | Larimer | Colorado | 8069 | 50188 | 400 |
2067141 | 2067141 | 2021-12-31 | Larimer | Colorado | 8069 | 50188 | 400 |
2063890 | 2063890 | 2021-12-30 | Larimer | Colorado | 8069 | 49744 | 399 |
2060640 | 2060640 | 2021-12-29 | Larimer | Colorado | 8069 | 49193 | 399 |
2057391 | 2057391 | 2021-12-28 | Larimer | Colorado | 8069 | 48848 | 399 |
2054142 | 2054142 | 2021-12-27 | Larimer | Colorado | 8069 | 48655 | 396 |
2050892 | 2050892 | 2021-12-26 | Larimer | Colorado | 8069 | 48130 | 396 |
2047642 | 2047642 | 2021-12-25 | Larimer | Colorado | 8069 | 48130 | 396 |
2044392 | 2044392 | 2021-12-24 | Larimer | Colorado | 8069 | 48130 | 396 |
2041143 | 2041143 | 2021-12-23 | Larimer | Colorado | 8069 | 47955 | 396 |
2037893 | 2037893 | 2021-12-22 | Larimer | Colorado | 8069 | 47763 | 395 |
2034643 | 2034643 | 2021-12-21 | Larimer | Colorado | 8069 | 47548 | 395 |
2031393 | 2031393 | 2021-12-20 | Larimer | Colorado | 8069 | 47444 | 393 |
2028142 | 2028142 | 2021-12-19 | Larimer | Colorado | 8069 | 47225 | 391 |
2024891 | 2024891 | 2021-12-18 | Larimer | Colorado | 8069 | 47225 | 391 |
2021640 | 2021640 | 2021-12-17 | Larimer | Colorado | 8069 | 47225 | 391 |
2018389 | 2018389 | 2021-12-16 | Larimer | Colorado | 8069 | 47094 | 391 |
2015139 | 2015139 | 2021-12-15 | Larimer | Colorado | 8069 | 46964 | 390 |
2011888 | 2011888 | 2021-12-14 | Larimer | Colorado | 8069 | 46830 | 389 |
2008637 | 2008637 | 2021-12-13 | Larimer | Colorado | 8069 | 46752 | 387 |
2005386 | 2005386 | 2021-12-12 | Larimer | Colorado | 8069 | 46491 | 386 |
2002135 | 2002135 | 2021-12-11 | Larimer | Colorado | 8069 | 46491 | 386 |
1998885 | 1998885 | 2021-12-10 | Larimer | Colorado | 8069 | 46491 | 386 |
1995634 | 1995634 | 2021-12-09 | Larimer | Colorado | 8069 | 46359 | 384 |
1992383 | 1992383 | 2021-12-08 | Larimer | Colorado | 8069 | 46211 | 382 |
1989132 | 1989132 | 2021-12-07 | Larimer | Colorado | 8069 | 46055 | 382 |
1985882 | 1985882 | 2021-12-06 | Larimer | Colorado | 8069 | 45890 | 379 |
1982632 | 1982632 | 2021-12-05 | Larimer | Colorado | 8069 | 45611 | 378 |
1979382 | 1979382 | 2021-12-04 | Larimer | Colorado | 8069 | 45611 | 378 |
1976132 | 1976132 | 2021-12-03 | Larimer | Colorado | 8069 | 45611 | 378 |
1972883 | 1972883 | 2021-12-02 | Larimer | Colorado | 8069 | 45425 | 378 |
1969633 | 1969633 | 2021-12-01 | Larimer | Colorado | 8069 | 45253 | 375 |
1966383 | 1966383 | 2021-11-30 | Larimer | Colorado | 8069 | 45018 | 373 |
1963131 | 1963131 | 2021-11-29 | Larimer | Colorado | 8069 | 44901 | 369 |
1959880 | 1959880 | 2021-11-28 | Larimer | Colorado | 8069 | 44649 | 367 |
1956629 | 1956629 | 2021-11-27 | Larimer | Colorado | 8069 | 44574 | 365 |
1953378 | 1953378 | 2021-11-26 | Larimer | Colorado | 8069 | 44574 | 365 |
1950127 | 1950127 | 2021-11-25 | Larimer | Colorado | 8069 | 44574 | 365 |
1946876 | 1946876 | 2021-11-24 | Larimer | Colorado | 8069 | 44436 | 364 |
1943625 | 1943625 | 2021-11-23 | Larimer | Colorado | 8069 | 44262 | 361 |
1940375 | 1940375 | 2021-11-22 | Larimer | Colorado | 8069 | 44161 | 355 |
1937125 | 1937125 | 2021-11-21 | Larimer | Colorado | 8069 | 43801 | 353 |
1933875 | 1933875 | 2021-11-20 | Larimer | Colorado | 8069 | 43801 | 353 |
1930623 | 1930623 | 2021-11-19 | Larimer | Colorado | 8069 | 43801 | 353 |
1927373 | 1927373 | 2021-11-18 | Larimer | Colorado | 8069 | 43623 | 351 |
1924123 | 1924123 | 2021-11-17 | Larimer | Colorado | 8069 | 43359 | 348 |
1920874 | 1920874 | 2021-11-16 | Larimer | Colorado | 8069 | 43050 | 345 |
1917624 | 1917624 | 2021-11-15 | Larimer | Colorado | 8069 | 42915 | 342 |
1914374 | 1914374 | 2021-11-14 | Larimer | Colorado | 8069 | 42489 | 336 |
1911124 | 1911124 | 2021-11-13 | Larimer | Colorado | 8069 | 42489 | 336 |
1907875 | 1907875 | 2021-11-12 | Larimer | Colorado | 8069 | 42489 | 336 |
1904626 | 1904626 | 2021-11-11 | Larimer | Colorado | 8069 | 42257 | 332 |
1901376 | 1901376 | 2021-11-10 | Larimer | Colorado | 8069 | 42016 | 327 |
1898126 | 1898126 | 2021-11-09 | Larimer | Colorado | 8069 | 41749 | 325 |
1894876 | 1894876 | 2021-11-08 | Larimer | Colorado | 8069 | 41595 | 325 |
1891626 | 1891626 | 2021-11-07 | Larimer | Colorado | 8069 | 41147 | 319 |
1888376 | 1888376 | 2021-11-06 | Larimer | Colorado | 8069 | 41147 | 319 |
1885126 | 1885126 | 2021-11-05 | Larimer | Colorado | 8069 | 41147 | 319 |
1881877 | 1881877 | 2021-11-04 | Larimer | Colorado | 8069 | 40935 | 319 |
1878628 | 1878628 | 2021-11-03 | Larimer | Colorado | 8069 | 40635 | 314 |
1875379 | 1875379 | 2021-11-02 | Larimer | Colorado | 8069 | 40408 | 314 |
1872130 | 1872130 | 2021-11-01 | Larimer | Colorado | 8069 | 40256 | 313 |
1868881 | 1868881 | 2021-10-31 | Larimer | Colorado | 8069 | 39807 | 313 |
1865632 | 1865632 | 2021-10-30 | Larimer | Colorado | 8069 | 39807 | 313 |
1862383 | 1862383 | 2021-10-29 | Larimer | Colorado | 8069 | 39807 | 313 |
1859134 | 1859134 | 2021-10-28 | Larimer | Colorado | 8069 | 39512 | 312 |
1855885 | 1855885 | 2021-10-27 | Larimer | Colorado | 8069 | 39295 | 309 |
1852636 | 1852636 | 2021-10-26 | Larimer | Colorado | 8069 | 38986 | 306 |
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);