ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where fips = 8009 and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174444 | 2174444 | 2022-02-02 | Baca | Colorado | 8009 | 721 | 8 |
2171191 | 2171191 | 2022-02-01 | Baca | Colorado | 8009 | 706 | 8 |
2167938 | 2167938 | 2022-01-31 | Baca | Colorado | 8009 | 703 | 8 |
2164683 | 2164683 | 2022-01-30 | Baca | Colorado | 8009 | 696 | 8 |
2161428 | 2161428 | 2022-01-29 | Baca | Colorado | 8009 | 694 | 8 |
2158172 | 2158172 | 2022-01-28 | Baca | Colorado | 8009 | 696 | 8 |
2154919 | 2154919 | 2022-01-27 | Baca | Colorado | 8009 | 694 | 8 |
2151666 | 2151666 | 2022-01-26 | Baca | Colorado | 8009 | 687 | 8 |
2148414 | 2148414 | 2022-01-25 | Baca | Colorado | 8009 | 673 | 8 |
2145162 | 2145162 | 2022-01-24 | Baca | Colorado | 8009 | 667 | 8 |
2141907 | 2141907 | 2022-01-23 | Baca | Colorado | 8009 | 658 | 8 |
2138652 | 2138652 | 2022-01-22 | Baca | Colorado | 8009 | 658 | 8 |
2135396 | 2135396 | 2022-01-21 | Baca | Colorado | 8009 | 658 | 8 |
2132144 | 2132144 | 2022-01-20 | Baca | Colorado | 8009 | 653 | 8 |
2128891 | 2128891 | 2022-01-19 | Baca | Colorado | 8009 | 642 | 8 |
2125637 | 2125637 | 2022-01-18 | Baca | Colorado | 8009 | 621 | 8 |
2122385 | 2122385 | 2022-01-17 | Baca | Colorado | 8009 | 615 | 8 |
2119133 | 2119133 | 2022-01-16 | Baca | Colorado | 8009 | 612 | 8 |
2115881 | 2115881 | 2022-01-15 | Baca | Colorado | 8009 | 612 | 8 |
2112630 | 2112630 | 2022-01-14 | Baca | Colorado | 8009 | 612 | 8 |
2109378 | 2109378 | 2022-01-13 | Baca | Colorado | 8009 | 610 | 8 |
2106127 | 2106127 | 2022-01-12 | Baca | Colorado | 8009 | 608 | 8 |
2102876 | 2102876 | 2022-01-11 | Baca | Colorado | 8009 | 603 | 7 |
2099625 | 2099625 | 2022-01-10 | Baca | Colorado | 8009 | 603 | 7 |
2096374 | 2096374 | 2022-01-09 | Baca | Colorado | 8009 | 600 | 7 |
2093122 | 2093122 | 2022-01-08 | Baca | Colorado | 8009 | 600 | 7 |
2089870 | 2089870 | 2022-01-07 | Baca | Colorado | 8009 | 600 | 7 |
2086619 | 2086619 | 2022-01-06 | Baca | Colorado | 8009 | 598 | 7 |
2083367 | 2083367 | 2022-01-05 | Baca | Colorado | 8009 | 596 | 7 |
2080115 | 2080115 | 2022-01-04 | Baca | Colorado | 8009 | 593 | 7 |
2076863 | 2076863 | 2022-01-03 | Baca | Colorado | 8009 | 592 | 7 |
2073612 | 2073612 | 2022-01-02 | Baca | Colorado | 8009 | 590 | 7 |
2070361 | 2070361 | 2022-01-01 | Baca | Colorado | 8009 | 590 | 7 |
2067110 | 2067110 | 2021-12-31 | Baca | Colorado | 8009 | 590 | 7 |
2063859 | 2063859 | 2021-12-30 | Baca | Colorado | 8009 | 590 | 7 |
2060609 | 2060609 | 2021-12-29 | Baca | Colorado | 8009 | 589 | 7 |
2057360 | 2057360 | 2021-12-28 | Baca | Colorado | 8009 | 589 | 7 |
2054111 | 2054111 | 2021-12-27 | Baca | Colorado | 8009 | 589 | 7 |
2050861 | 2050861 | 2021-12-26 | Baca | Colorado | 8009 | 589 | 7 |
2047611 | 2047611 | 2021-12-25 | Baca | Colorado | 8009 | 589 | 7 |
2044361 | 2044361 | 2021-12-24 | Baca | Colorado | 8009 | 589 | 7 |
2041112 | 2041112 | 2021-12-23 | Baca | Colorado | 8009 | 587 | 7 |
2037862 | 2037862 | 2021-12-22 | Baca | Colorado | 8009 | 586 | 7 |
2034612 | 2034612 | 2021-12-21 | Baca | Colorado | 8009 | 584 | 7 |
2031362 | 2031362 | 2021-12-20 | Baca | Colorado | 8009 | 582 | 7 |
2028111 | 2028111 | 2021-12-19 | Baca | Colorado | 8009 | 581 | 7 |
2024860 | 2024860 | 2021-12-18 | Baca | Colorado | 8009 | 581 | 7 |
2021609 | 2021609 | 2021-12-17 | Baca | Colorado | 8009 | 581 | 7 |
2018358 | 2018358 | 2021-12-16 | Baca | Colorado | 8009 | 581 | 7 |
2015108 | 2015108 | 2021-12-15 | Baca | Colorado | 8009 | 581 | 6 |
2011857 | 2011857 | 2021-12-14 | Baca | Colorado | 8009 | 578 | 6 |
2008606 | 2008606 | 2021-12-13 | Baca | Colorado | 8009 | 578 | 6 |
2005355 | 2005355 | 2021-12-12 | Baca | Colorado | 8009 | 576 | 6 |
2002104 | 2002104 | 2021-12-11 | Baca | Colorado | 8009 | 576 | 6 |
1998854 | 1998854 | 2021-12-10 | Baca | Colorado | 8009 | 576 | 6 |
1995603 | 1995603 | 2021-12-09 | Baca | Colorado | 8009 | 576 | 6 |
1992352 | 1992352 | 2021-12-08 | Baca | Colorado | 8009 | 573 | 6 |
1989101 | 1989101 | 2021-12-07 | Baca | Colorado | 8009 | 569 | 6 |
1985851 | 1985851 | 2021-12-06 | Baca | Colorado | 8009 | 567 | 6 |
1982601 | 1982601 | 2021-12-05 | Baca | Colorado | 8009 | 566 | 6 |
1979351 | 1979351 | 2021-12-04 | Baca | Colorado | 8009 | 566 | 6 |
1976101 | 1976101 | 2021-12-03 | Baca | Colorado | 8009 | 566 | 6 |
1972852 | 1972852 | 2021-12-02 | Baca | Colorado | 8009 | 566 | 6 |
1969602 | 1969602 | 2021-12-01 | Baca | Colorado | 8009 | 566 | 6 |
1966352 | 1966352 | 2021-11-30 | Baca | Colorado | 8009 | 563 | 6 |
1963100 | 1963100 | 2021-11-29 | Baca | Colorado | 8009 | 560 | 5 |
1959849 | 1959849 | 2021-11-28 | Baca | Colorado | 8009 | 559 | 5 |
1956598 | 1956598 | 2021-11-27 | Baca | Colorado | 8009 | 559 | 5 |
1953347 | 1953347 | 2021-11-26 | Baca | Colorado | 8009 | 559 | 5 |
1950096 | 1950096 | 2021-11-25 | Baca | Colorado | 8009 | 559 | 5 |
1946845 | 1946845 | 2021-11-24 | Baca | Colorado | 8009 | 557 | 5 |
1943594 | 1943594 | 2021-11-23 | Baca | Colorado | 8009 | 544 | 5 |
1940344 | 1940344 | 2021-11-22 | Baca | Colorado | 8009 | 543 | 5 |
1937094 | 1937094 | 2021-11-21 | Baca | Colorado | 8009 | 541 | 5 |
1933844 | 1933844 | 2021-11-20 | Baca | Colorado | 8009 | 541 | 5 |
1930592 | 1930592 | 2021-11-19 | Baca | Colorado | 8009 | 541 | 5 |
1927342 | 1927342 | 2021-11-18 | Baca | Colorado | 8009 | 540 | 5 |
1924092 | 1924092 | 2021-11-17 | Baca | Colorado | 8009 | 537 | 5 |
1920843 | 1920843 | 2021-11-16 | Baca | Colorado | 8009 | 532 | 5 |
1917593 | 1917593 | 2021-11-15 | Baca | Colorado | 8009 | 526 | 5 |
1914343 | 1914343 | 2021-11-14 | Baca | Colorado | 8009 | 523 | 5 |
1911093 | 1911093 | 2021-11-13 | Baca | Colorado | 8009 | 523 | 5 |
1907844 | 1907844 | 2021-11-12 | Baca | Colorado | 8009 | 523 | 5 |
1904595 | 1904595 | 2021-11-11 | Baca | Colorado | 8009 | 520 | 5 |
1901345 | 1901345 | 2021-11-10 | Baca | Colorado | 8009 | 517 | 5 |
1898095 | 1898095 | 2021-11-09 | Baca | Colorado | 8009 | 509 | 5 |
1894845 | 1894845 | 2021-11-08 | Baca | Colorado | 8009 | 502 | 5 |
1891595 | 1891595 | 2021-11-07 | Baca | Colorado | 8009 | 499 | 5 |
1888345 | 1888345 | 2021-11-06 | Baca | Colorado | 8009 | 499 | 5 |
1885095 | 1885095 | 2021-11-05 | Baca | Colorado | 8009 | 499 | 5 |
1881846 | 1881846 | 2021-11-04 | Baca | Colorado | 8009 | 491 | 5 |
1878597 | 1878597 | 2021-11-03 | Baca | Colorado | 8009 | 487 | 5 |
1875348 | 1875348 | 2021-11-02 | Baca | Colorado | 8009 | 475 | 5 |
1872099 | 1872099 | 2021-11-01 | Baca | Colorado | 8009 | 462 | 5 |
1868850 | 1868850 | 2021-10-31 | Baca | Colorado | 8009 | 454 | 5 |
1865601 | 1865601 | 2021-10-30 | Baca | Colorado | 8009 | 454 | 5 |
1862352 | 1862352 | 2021-10-29 | Baca | Colorado | 8009 | 454 | 5 |
1859103 | 1859103 | 2021-10-28 | Baca | Colorado | 8009 | 450 | 5 |
1855854 | 1855854 | 2021-10-27 | Baca | Colorado | 8009 | 449 | 5 |
1852605 | 1852605 | 2021-10-26 | Baca | Colorado | 8009 | 442 | 5 |
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);