ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 8045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174463 | 2174463 | 2022-02-02 | Garfield | Colorado | 8045 | 13498 | 83 |
2171210 | 2171210 | 2022-02-01 | Garfield | Colorado | 8045 | 13472 | 83 |
2167957 | 2167957 | 2022-01-31 | Garfield | Colorado | 8045 | 13442 | 84 |
2164702 | 2164702 | 2022-01-30 | Garfield | Colorado | 8045 | 13376 | 83 |
2161447 | 2161447 | 2022-01-29 | Garfield | Colorado | 8045 | 13316 | 81 |
2158191 | 2158191 | 2022-01-28 | Garfield | Colorado | 8045 | 13376 | 83 |
2154938 | 2154938 | 2022-01-27 | Garfield | Colorado | 8045 | 13316 | 81 |
2151685 | 2151685 | 2022-01-26 | Garfield | Colorado | 8045 | 13235 | 80 |
2148433 | 2148433 | 2022-01-25 | Garfield | Colorado | 8045 | 13155 | 80 |
2145181 | 2145181 | 2022-01-24 | Garfield | Colorado | 8045 | 13041 | 80 |
2141926 | 2141926 | 2022-01-23 | Garfield | Colorado | 8045 | 12815 | 80 |
2138671 | 2138671 | 2022-01-22 | Garfield | Colorado | 8045 | 12815 | 80 |
2135415 | 2135415 | 2022-01-21 | Garfield | Colorado | 8045 | 12815 | 80 |
2132163 | 2132163 | 2022-01-20 | Garfield | Colorado | 8045 | 12701 | 80 |
2128910 | 2128910 | 2022-01-19 | Garfield | Colorado | 8045 | 12502 | 80 |
2125656 | 2125656 | 2022-01-18 | Garfield | Colorado | 8045 | 12385 | 80 |
2122404 | 2122404 | 2022-01-17 | Garfield | Colorado | 8045 | 12318 | 80 |
2119152 | 2119152 | 2022-01-16 | Garfield | Colorado | 8045 | 11975 | 80 |
2115900 | 2115900 | 2022-01-15 | Garfield | Colorado | 8045 | 11975 | 80 |
2112649 | 2112649 | 2022-01-14 | Garfield | Colorado | 8045 | 11975 | 80 |
2109397 | 2109397 | 2022-01-13 | Garfield | Colorado | 8045 | 11675 | 80 |
2106146 | 2106146 | 2022-01-12 | Garfield | Colorado | 8045 | 11505 | 80 |
2102895 | 2102895 | 2022-01-11 | Garfield | Colorado | 8045 | 11420 | 80 |
2099644 | 2099644 | 2022-01-10 | Garfield | Colorado | 8045 | 11284 | 79 |
2096393 | 2096393 | 2022-01-09 | Garfield | Colorado | 8045 | 10459 | 79 |
2093141 | 2093141 | 2022-01-08 | Garfield | Colorado | 8045 | 10459 | 79 |
2089889 | 2089889 | 2022-01-07 | Garfield | Colorado | 8045 | 10459 | 79 |
2086638 | 2086638 | 2022-01-06 | Garfield | Colorado | 8045 | 10390 | 78 |
2083386 | 2083386 | 2022-01-05 | Garfield | Colorado | 8045 | 10332 | 78 |
2080134 | 2080134 | 2022-01-04 | Garfield | Colorado | 8045 | 10280 | 78 |
2076882 | 2076882 | 2022-01-03 | Garfield | Colorado | 8045 | 10184 | 78 |
2073631 | 2073631 | 2022-01-02 | Garfield | Colorado | 8045 | 9865 | 78 |
2070380 | 2070380 | 2022-01-01 | Garfield | Colorado | 8045 | 9865 | 78 |
2067129 | 2067129 | 2021-12-31 | Garfield | Colorado | 8045 | 9865 | 78 |
2063878 | 2063878 | 2021-12-30 | Garfield | Colorado | 8045 | 9808 | 78 |
2060628 | 2060628 | 2021-12-29 | Garfield | Colorado | 8045 | 9667 | 78 |
2057379 | 2057379 | 2021-12-28 | Garfield | Colorado | 8045 | 9575 | 77 |
2054130 | 2054130 | 2021-12-27 | Garfield | Colorado | 8045 | 9540 | 77 |
2050880 | 2050880 | 2021-12-26 | Garfield | Colorado | 8045 | 9429 | 77 |
2047630 | 2047630 | 2021-12-25 | Garfield | Colorado | 8045 | 9429 | 77 |
2044380 | 2044380 | 2021-12-24 | Garfield | Colorado | 8045 | 9429 | 77 |
2041131 | 2041131 | 2021-12-23 | Garfield | Colorado | 8045 | 9381 | 77 |
2037881 | 2037881 | 2021-12-22 | Garfield | Colorado | 8045 | 9337 | 77 |
2034631 | 2034631 | 2021-12-21 | Garfield | Colorado | 8045 | 9316 | 76 |
2031381 | 2031381 | 2021-12-20 | Garfield | Colorado | 8045 | 9283 | 76 |
2028130 | 2028130 | 2021-12-19 | Garfield | Colorado | 8045 | 9240 | 76 |
2024879 | 2024879 | 2021-12-18 | Garfield | Colorado | 8045 | 9240 | 76 |
2021628 | 2021628 | 2021-12-17 | Garfield | Colorado | 8045 | 9240 | 76 |
2018377 | 2018377 | 2021-12-16 | Garfield | Colorado | 8045 | 9206 | 76 |
2015127 | 2015127 | 2021-12-15 | Garfield | Colorado | 8045 | 9159 | 76 |
2011876 | 2011876 | 2021-12-14 | Garfield | Colorado | 8045 | 9132 | 75 |
2008625 | 2008625 | 2021-12-13 | Garfield | Colorado | 8045 | 9119 | 75 |
2005374 | 2005374 | 2021-12-12 | Garfield | Colorado | 8045 | 9081 | 75 |
2002123 | 2002123 | 2021-12-11 | Garfield | Colorado | 8045 | 9081 | 75 |
1998873 | 1998873 | 2021-12-10 | Garfield | Colorado | 8045 | 9081 | 75 |
1995622 | 1995622 | 2021-12-09 | Garfield | Colorado | 8045 | 9061 | 75 |
1992371 | 1992371 | 2021-12-08 | Garfield | Colorado | 8045 | 8996 | 75 |
1989120 | 1989120 | 2021-12-07 | Garfield | Colorado | 8045 | 8964 | 75 |
1985870 | 1985870 | 2021-12-06 | Garfield | Colorado | 8045 | 8940 | 74 |
1982620 | 1982620 | 2021-12-05 | Garfield | Colorado | 8045 | 8858 | 73 |
1979370 | 1979370 | 2021-12-04 | Garfield | Colorado | 8045 | 8858 | 73 |
1976120 | 1976120 | 2021-12-03 | Garfield | Colorado | 8045 | 8858 | 73 |
1972871 | 1972871 | 2021-12-02 | Garfield | Colorado | 8045 | 8831 | 72 |
1969621 | 1969621 | 2021-12-01 | Garfield | Colorado | 8045 | 8795 | 71 |
1966371 | 1966371 | 2021-11-30 | Garfield | Colorado | 8045 | 8739 | 69 |
1963119 | 1963119 | 2021-11-29 | Garfield | Colorado | 8045 | 8703 | 70 |
1959868 | 1959868 | 2021-11-28 | Garfield | Colorado | 8045 | 8635 | 69 |
1956617 | 1956617 | 2021-11-27 | Garfield | Colorado | 8045 | 8623 | 69 |
1953366 | 1953366 | 2021-11-26 | Garfield | Colorado | 8045 | 8623 | 69 |
1950115 | 1950115 | 2021-11-25 | Garfield | Colorado | 8045 | 8623 | 69 |
1946864 | 1946864 | 2021-11-24 | Garfield | Colorado | 8045 | 8615 | 69 |
1943613 | 1943613 | 2021-11-23 | Garfield | Colorado | 8045 | 8596 | 69 |
1940363 | 1940363 | 2021-11-22 | Garfield | Colorado | 8045 | 8560 | 68 |
1937113 | 1937113 | 2021-11-21 | Garfield | Colorado | 8045 | 8511 | 68 |
1933863 | 1933863 | 2021-11-20 | Garfield | Colorado | 8045 | 8511 | 68 |
1930611 | 1930611 | 2021-11-19 | Garfield | Colorado | 8045 | 8511 | 68 |
1927361 | 1927361 | 2021-11-18 | Garfield | Colorado | 8045 | 8495 | 68 |
1924111 | 1924111 | 2021-11-17 | Garfield | Colorado | 8045 | 8476 | 68 |
1920862 | 1920862 | 2021-11-16 | Garfield | Colorado | 8045 | 8409 | 68 |
1917612 | 1917612 | 2021-11-15 | Garfield | Colorado | 8045 | 8395 | 68 |
1914362 | 1914362 | 2021-11-14 | Garfield | Colorado | 8045 | 8354 | 65 |
1911112 | 1911112 | 2021-11-13 | Garfield | Colorado | 8045 | 8354 | 65 |
1907863 | 1907863 | 2021-11-12 | Garfield | Colorado | 8045 | 8354 | 65 |
1904614 | 1904614 | 2021-11-11 | Garfield | Colorado | 8045 | 8315 | 65 |
1901364 | 1901364 | 2021-11-10 | Garfield | Colorado | 8045 | 8282 | 65 |
1898114 | 1898114 | 2021-11-09 | Garfield | Colorado | 8045 | 8256 | 66 |
1894864 | 1894864 | 2021-11-08 | Garfield | Colorado | 8045 | 8241 | 66 |
1891614 | 1891614 | 2021-11-07 | Garfield | Colorado | 8045 | 8184 | 65 |
1888364 | 1888364 | 2021-11-06 | Garfield | Colorado | 8045 | 8184 | 65 |
1885114 | 1885114 | 2021-11-05 | Garfield | Colorado | 8045 | 8184 | 65 |
1881865 | 1881865 | 2021-11-04 | Garfield | Colorado | 8045 | 8165 | 65 |
1878616 | 1878616 | 2021-11-03 | Garfield | Colorado | 8045 | 8135 | 64 |
1875367 | 1875367 | 2021-11-02 | Garfield | Colorado | 8045 | 8105 | 63 |
1872118 | 1872118 | 2021-11-01 | Garfield | Colorado | 8045 | 8067 | 61 |
1868869 | 1868869 | 2021-10-31 | Garfield | Colorado | 8045 | 7992 | 61 |
1865620 | 1865620 | 2021-10-30 | Garfield | Colorado | 8045 | 7992 | 61 |
1862371 | 1862371 | 2021-10-29 | Garfield | Colorado | 8045 | 7992 | 61 |
1859122 | 1859122 | 2021-10-28 | Garfield | Colorado | 8045 | 7972 | 61 |
1855873 | 1855873 | 2021-10-27 | Garfield | Colorado | 8045 | 7942 | 60 |
1852624 | 1852624 | 2021-10-26 | Garfield | Colorado | 8045 | 7913 | 60 |
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);