ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
688 rows where county = "Jackson" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174469 | 2174469 | 2022-02-02 | Jackson | Colorado | 8057 | 147 | 0 |
2171216 | 2171216 | 2022-02-01 | Jackson | Colorado | 8057 | 143 | 0 |
2167963 | 2167963 | 2022-01-31 | Jackson | Colorado | 8057 | 146 | 0 |
2164708 | 2164708 | 2022-01-30 | Jackson | Colorado | 8057 | 143 | 0 |
2161453 | 2161453 | 2022-01-29 | Jackson | Colorado | 8057 | 143 | 0 |
2158197 | 2158197 | 2022-01-28 | Jackson | Colorado | 8057 | 143 | 0 |
2154944 | 2154944 | 2022-01-27 | Jackson | Colorado | 8057 | 143 | 0 |
2151691 | 2151691 | 2022-01-26 | Jackson | Colorado | 8057 | 141 | 0 |
2148439 | 2148439 | 2022-01-25 | Jackson | Colorado | 8057 | 141 | 0 |
2145187 | 2145187 | 2022-01-24 | Jackson | Colorado | 8057 | 141 | 0 |
2141932 | 2141932 | 2022-01-23 | Jackson | Colorado | 8057 | 137 | 0 |
2138677 | 2138677 | 2022-01-22 | Jackson | Colorado | 8057 | 137 | 0 |
2135421 | 2135421 | 2022-01-21 | Jackson | Colorado | 8057 | 137 | 0 |
2132169 | 2132169 | 2022-01-20 | Jackson | Colorado | 8057 | 136 | 0 |
2128916 | 2128916 | 2022-01-19 | Jackson | Colorado | 8057 | 134 | 0 |
2125662 | 2125662 | 2022-01-18 | Jackson | Colorado | 8057 | 134 | 0 |
2122410 | 2122410 | 2022-01-17 | Jackson | Colorado | 8057 | 134 | 0 |
2119158 | 2119158 | 2022-01-16 | Jackson | Colorado | 8057 | 132 | 0 |
2115906 | 2115906 | 2022-01-15 | Jackson | Colorado | 8057 | 132 | 0 |
2112655 | 2112655 | 2022-01-14 | Jackson | Colorado | 8057 | 132 | 0 |
2109403 | 2109403 | 2022-01-13 | Jackson | Colorado | 8057 | 132 | 0 |
2106152 | 2106152 | 2022-01-12 | Jackson | Colorado | 8057 | 130 | 0 |
2102901 | 2102901 | 2022-01-11 | Jackson | Colorado | 8057 | 130 | 0 |
2099650 | 2099650 | 2022-01-10 | Jackson | Colorado | 8057 | 130 | 0 |
2096399 | 2096399 | 2022-01-09 | Jackson | Colorado | 8057 | 131 | 0 |
2093147 | 2093147 | 2022-01-08 | Jackson | Colorado | 8057 | 131 | 0 |
2089895 | 2089895 | 2022-01-07 | Jackson | Colorado | 8057 | 131 | 0 |
2086644 | 2086644 | 2022-01-06 | Jackson | Colorado | 8057 | 130 | 0 |
2083392 | 2083392 | 2022-01-05 | Jackson | Colorado | 8057 | 130 | 0 |
2080140 | 2080140 | 2022-01-04 | Jackson | Colorado | 8057 | 130 | 0 |
2076888 | 2076888 | 2022-01-03 | Jackson | Colorado | 8057 | 130 | 0 |
2073637 | 2073637 | 2022-01-02 | Jackson | Colorado | 8057 | 128 | 0 |
2070386 | 2070386 | 2022-01-01 | Jackson | Colorado | 8057 | 128 | 0 |
2067135 | 2067135 | 2021-12-31 | Jackson | Colorado | 8057 | 128 | 0 |
2063884 | 2063884 | 2021-12-30 | Jackson | Colorado | 8057 | 127 | 0 |
2060634 | 2060634 | 2021-12-29 | Jackson | Colorado | 8057 | 127 | 0 |
2057385 | 2057385 | 2021-12-28 | Jackson | Colorado | 8057 | 126 | 0 |
2054136 | 2054136 | 2021-12-27 | Jackson | Colorado | 8057 | 126 | 0 |
2050886 | 2050886 | 2021-12-26 | Jackson | Colorado | 8057 | 126 | 0 |
2047636 | 2047636 | 2021-12-25 | Jackson | Colorado | 8057 | 126 | 0 |
2044386 | 2044386 | 2021-12-24 | Jackson | Colorado | 8057 | 126 | 0 |
2041137 | 2041137 | 2021-12-23 | Jackson | Colorado | 8057 | 126 | 0 |
2037887 | 2037887 | 2021-12-22 | Jackson | Colorado | 8057 | 126 | 0 |
2034637 | 2034637 | 2021-12-21 | Jackson | Colorado | 8057 | 125 | 0 |
2031387 | 2031387 | 2021-12-20 | Jackson | Colorado | 8057 | 125 | 0 |
2028136 | 2028136 | 2021-12-19 | Jackson | Colorado | 8057 | 125 | 0 |
2024885 | 2024885 | 2021-12-18 | Jackson | Colorado | 8057 | 125 | 0 |
2021634 | 2021634 | 2021-12-17 | Jackson | Colorado | 8057 | 125 | 0 |
2018383 | 2018383 | 2021-12-16 | Jackson | Colorado | 8057 | 126 | 0 |
2015133 | 2015133 | 2021-12-15 | Jackson | Colorado | 8057 | 126 | 0 |
2011882 | 2011882 | 2021-12-14 | Jackson | Colorado | 8057 | 126 | 0 |
2008631 | 2008631 | 2021-12-13 | Jackson | Colorado | 8057 | 126 | 0 |
2005380 | 2005380 | 2021-12-12 | Jackson | Colorado | 8057 | 126 | 0 |
2002129 | 2002129 | 2021-12-11 | Jackson | Colorado | 8057 | 126 | 0 |
1998879 | 1998879 | 2021-12-10 | Jackson | Colorado | 8057 | 126 | 0 |
1995628 | 1995628 | 2021-12-09 | Jackson | Colorado | 8057 | 126 | 0 |
1992377 | 1992377 | 2021-12-08 | Jackson | Colorado | 8057 | 125 | 0 |
1989126 | 1989126 | 2021-12-07 | Jackson | Colorado | 8057 | 125 | 0 |
1985876 | 1985876 | 2021-12-06 | Jackson | Colorado | 8057 | 124 | 0 |
1982626 | 1982626 | 2021-12-05 | Jackson | Colorado | 8057 | 125 | 0 |
1979376 | 1979376 | 2021-12-04 | Jackson | Colorado | 8057 | 125 | 0 |
1976126 | 1976126 | 2021-12-03 | Jackson | Colorado | 8057 | 125 | 0 |
1972877 | 1972877 | 2021-12-02 | Jackson | Colorado | 8057 | 124 | 0 |
1969627 | 1969627 | 2021-12-01 | Jackson | Colorado | 8057 | 122 | 0 |
1966377 | 1966377 | 2021-11-30 | Jackson | Colorado | 8057 | 122 | 0 |
1963125 | 1963125 | 2021-11-29 | Jackson | Colorado | 8057 | 122 | 0 |
1959874 | 1959874 | 2021-11-28 | Jackson | Colorado | 8057 | 122 | 0 |
1956623 | 1956623 | 2021-11-27 | Jackson | Colorado | 8057 | 122 | 0 |
1953372 | 1953372 | 2021-11-26 | Jackson | Colorado | 8057 | 122 | 0 |
1950121 | 1950121 | 2021-11-25 | Jackson | Colorado | 8057 | 122 | 0 |
1946870 | 1946870 | 2021-11-24 | Jackson | Colorado | 8057 | 122 | 0 |
1943619 | 1943619 | 2021-11-23 | Jackson | Colorado | 8057 | 121 | 0 |
1940369 | 1940369 | 2021-11-22 | Jackson | Colorado | 8057 | 118 | 0 |
1937119 | 1937119 | 2021-11-21 | Jackson | Colorado | 8057 | 118 | 0 |
1933869 | 1933869 | 2021-11-20 | Jackson | Colorado | 8057 | 118 | 0 |
1930617 | 1930617 | 2021-11-19 | Jackson | Colorado | 8057 | 118 | 0 |
1927367 | 1927367 | 2021-11-18 | Jackson | Colorado | 8057 | 118 | 0 |
1924117 | 1924117 | 2021-11-17 | Jackson | Colorado | 8057 | 117 | 0 |
1920868 | 1920868 | 2021-11-16 | Jackson | Colorado | 8057 | 117 | 0 |
1917618 | 1917618 | 2021-11-15 | Jackson | Colorado | 8057 | 117 | 0 |
1914368 | 1914368 | 2021-11-14 | Jackson | Colorado | 8057 | 116 | 0 |
1911118 | 1911118 | 2021-11-13 | Jackson | Colorado | 8057 | 116 | 0 |
1907869 | 1907869 | 2021-11-12 | Jackson | Colorado | 8057 | 116 | 0 |
1904620 | 1904620 | 2021-11-11 | Jackson | Colorado | 8057 | 116 | 0 |
1901370 | 1901370 | 2021-11-10 | Jackson | Colorado | 8057 | 116 | 0 |
1898120 | 1898120 | 2021-11-09 | Jackson | Colorado | 8057 | 116 | 0 |
1894870 | 1894870 | 2021-11-08 | Jackson | Colorado | 8057 | 116 | 0 |
1891620 | 1891620 | 2021-11-07 | Jackson | Colorado | 8057 | 115 | 0 |
1888370 | 1888370 | 2021-11-06 | Jackson | Colorado | 8057 | 115 | 0 |
1885120 | 1885120 | 2021-11-05 | Jackson | Colorado | 8057 | 115 | 0 |
1881871 | 1881871 | 2021-11-04 | Jackson | Colorado | 8057 | 115 | 0 |
1878622 | 1878622 | 2021-11-03 | Jackson | Colorado | 8057 | 115 | 0 |
1875373 | 1875373 | 2021-11-02 | Jackson | Colorado | 8057 | 114 | 0 |
1872124 | 1872124 | 2021-11-01 | Jackson | Colorado | 8057 | 114 | 0 |
1868875 | 1868875 | 2021-10-31 | Jackson | Colorado | 8057 | 114 | 0 |
1865626 | 1865626 | 2021-10-30 | Jackson | Colorado | 8057 | 114 | 0 |
1862377 | 1862377 | 2021-10-29 | Jackson | Colorado | 8057 | 114 | 0 |
1859128 | 1859128 | 2021-10-28 | Jackson | Colorado | 8057 | 114 | 0 |
1855879 | 1855879 | 2021-10-27 | Jackson | Colorado | 8057 | 114 | 0 |
1852630 | 1852630 | 2021-10-26 | Jackson | Colorado | 8057 | 114 | 0 |
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);