ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Otero" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174485 | 2174485 | 2022-02-02 | Otero | Colorado | 8089 | 4012 | 123 |
2171232 | 2171232 | 2022-02-01 | Otero | Colorado | 8089 | 3989 | 123 |
2167979 | 2167979 | 2022-01-31 | Otero | Colorado | 8089 | 3968 | 122 |
2164724 | 2164724 | 2022-01-30 | Otero | Colorado | 8089 | 3938 | 121 |
2161469 | 2161469 | 2022-01-29 | Otero | Colorado | 8089 | 3908 | 120 |
2158213 | 2158213 | 2022-01-28 | Otero | Colorado | 8089 | 3938 | 121 |
2154960 | 2154960 | 2022-01-27 | Otero | Colorado | 8089 | 3908 | 120 |
2151707 | 2151707 | 2022-01-26 | Otero | Colorado | 8089 | 3862 | 119 |
2148455 | 2148455 | 2022-01-25 | Otero | Colorado | 8089 | 3848 | 119 |
2145203 | 2145203 | 2022-01-24 | Otero | Colorado | 8089 | 3831 | 118 |
2141948 | 2141948 | 2022-01-23 | Otero | Colorado | 8089 | 3775 | 118 |
2138693 | 2138693 | 2022-01-22 | Otero | Colorado | 8089 | 3775 | 118 |
2135437 | 2135437 | 2022-01-21 | Otero | Colorado | 8089 | 3775 | 118 |
2132185 | 2132185 | 2022-01-20 | Otero | Colorado | 8089 | 3728 | 118 |
2128932 | 2128932 | 2022-01-19 | Otero | Colorado | 8089 | 3693 | 118 |
2125678 | 2125678 | 2022-01-18 | Otero | Colorado | 8089 | 3669 | 118 |
2122426 | 2122426 | 2022-01-17 | Otero | Colorado | 8089 | 3644 | 118 |
2119174 | 2119174 | 2022-01-16 | Otero | Colorado | 8089 | 3562 | 118 |
2115922 | 2115922 | 2022-01-15 | Otero | Colorado | 8089 | 3562 | 118 |
2112671 | 2112671 | 2022-01-14 | Otero | Colorado | 8089 | 3562 | 118 |
2109419 | 2109419 | 2022-01-13 | Otero | Colorado | 8089 | 3544 | 118 |
2106168 | 2106168 | 2022-01-12 | Otero | Colorado | 8089 | 3532 | 118 |
2102917 | 2102917 | 2022-01-11 | Otero | Colorado | 8089 | 3512 | 118 |
2099666 | 2099666 | 2022-01-10 | Otero | Colorado | 8089 | 3482 | 117 |
2096415 | 2096415 | 2022-01-09 | Otero | Colorado | 8089 | 3427 | 117 |
2093163 | 2093163 | 2022-01-08 | Otero | Colorado | 8089 | 3427 | 117 |
2089911 | 2089911 | 2022-01-07 | Otero | Colorado | 8089 | 3427 | 117 |
2086660 | 2086660 | 2022-01-06 | Otero | Colorado | 8089 | 3420 | 117 |
2083408 | 2083408 | 2022-01-05 | Otero | Colorado | 8089 | 3410 | 116 |
2080156 | 2080156 | 2022-01-04 | Otero | Colorado | 8089 | 3396 | 116 |
2076904 | 2076904 | 2022-01-03 | Otero | Colorado | 8089 | 3380 | 116 |
2073653 | 2073653 | 2022-01-02 | Otero | Colorado | 8089 | 3368 | 116 |
2070402 | 2070402 | 2022-01-01 | Otero | Colorado | 8089 | 3368 | 116 |
2067151 | 2067151 | 2021-12-31 | Otero | Colorado | 8089 | 3368 | 116 |
2063900 | 2063900 | 2021-12-30 | Otero | Colorado | 8089 | 3357 | 116 |
2060650 | 2060650 | 2021-12-29 | Otero | Colorado | 8089 | 3342 | 115 |
2057401 | 2057401 | 2021-12-28 | Otero | Colorado | 8089 | 3335 | 115 |
2054152 | 2054152 | 2021-12-27 | Otero | Colorado | 8089 | 3329 | 115 |
2050902 | 2050902 | 2021-12-26 | Otero | Colorado | 8089 | 3323 | 115 |
2047652 | 2047652 | 2021-12-25 | Otero | Colorado | 8089 | 3323 | 115 |
2044402 | 2044402 | 2021-12-24 | Otero | Colorado | 8089 | 3323 | 115 |
2041153 | 2041153 | 2021-12-23 | Otero | Colorado | 8089 | 3321 | 115 |
2037903 | 2037903 | 2021-12-22 | Otero | Colorado | 8089 | 3315 | 115 |
2034653 | 2034653 | 2021-12-21 | Otero | Colorado | 8089 | 3313 | 115 |
2031403 | 2031403 | 2021-12-20 | Otero | Colorado | 8089 | 3310 | 114 |
2028152 | 2028152 | 2021-12-19 | Otero | Colorado | 8089 | 3305 | 114 |
2024901 | 2024901 | 2021-12-18 | Otero | Colorado | 8089 | 3305 | 114 |
2021650 | 2021650 | 2021-12-17 | Otero | Colorado | 8089 | 3305 | 114 |
2018399 | 2018399 | 2021-12-16 | Otero | Colorado | 8089 | 3302 | 114 |
2015149 | 2015149 | 2021-12-15 | Otero | Colorado | 8089 | 3299 | 113 |
2011898 | 2011898 | 2021-12-14 | Otero | Colorado | 8089 | 3294 | 113 |
2008647 | 2008647 | 2021-12-13 | Otero | Colorado | 8089 | 3291 | 112 |
2005396 | 2005396 | 2021-12-12 | Otero | Colorado | 8089 | 3282 | 108 |
2002145 | 2002145 | 2021-12-11 | Otero | Colorado | 8089 | 3282 | 108 |
1998895 | 1998895 | 2021-12-10 | Otero | Colorado | 8089 | 3282 | 108 |
1995644 | 1995644 | 2021-12-09 | Otero | Colorado | 8089 | 3274 | 108 |
1992393 | 1992393 | 2021-12-08 | Otero | Colorado | 8089 | 3264 | 107 |
1989142 | 1989142 | 2021-12-07 | Otero | Colorado | 8089 | 3255 | 106 |
1985892 | 1985892 | 2021-12-06 | Otero | Colorado | 8089 | 3248 | 103 |
1982642 | 1982642 | 2021-12-05 | Otero | Colorado | 8089 | 3232 | 103 |
1979392 | 1979392 | 2021-12-04 | Otero | Colorado | 8089 | 3232 | 103 |
1976142 | 1976142 | 2021-12-03 | Otero | Colorado | 8089 | 3232 | 103 |
1972893 | 1972893 | 2021-12-02 | Otero | Colorado | 8089 | 3227 | 103 |
1969643 | 1969643 | 2021-12-01 | Otero | Colorado | 8089 | 3208 | 102 |
1966393 | 1966393 | 2021-11-30 | Otero | Colorado | 8089 | 3189 | 95 |
1963141 | 1963141 | 2021-11-29 | Otero | Colorado | 8089 | 3177 | 95 |
1959890 | 1959890 | 2021-11-28 | Otero | Colorado | 8089 | 3161 | 94 |
1956639 | 1956639 | 2021-11-27 | Otero | Colorado | 8089 | 3162 | 94 |
1953388 | 1953388 | 2021-11-26 | Otero | Colorado | 8089 | 3162 | 94 |
1950137 | 1950137 | 2021-11-25 | Otero | Colorado | 8089 | 3162 | 94 |
1946886 | 1946886 | 2021-11-24 | Otero | Colorado | 8089 | 3146 | 94 |
1943635 | 1943635 | 2021-11-23 | Otero | Colorado | 8089 | 3125 | 93 |
1940385 | 1940385 | 2021-11-22 | Otero | Colorado | 8089 | 3095 | 91 |
1937135 | 1937135 | 2021-11-21 | Otero | Colorado | 8089 | 3069 | 90 |
1933885 | 1933885 | 2021-11-20 | Otero | Colorado | 8089 | 3069 | 90 |
1930633 | 1930633 | 2021-11-19 | Otero | Colorado | 8089 | 3069 | 90 |
1927383 | 1927383 | 2021-11-18 | Otero | Colorado | 8089 | 3038 | 89 |
1924133 | 1924133 | 2021-11-17 | Otero | Colorado | 8089 | 3021 | 89 |
1920884 | 1920884 | 2021-11-16 | Otero | Colorado | 8089 | 3002 | 89 |
1917634 | 1917634 | 2021-11-15 | Otero | Colorado | 8089 | 2964 | 88 |
1914384 | 1914384 | 2021-11-14 | Otero | Colorado | 8089 | 2923 | 86 |
1911134 | 1911134 | 2021-11-13 | Otero | Colorado | 8089 | 2923 | 86 |
1907885 | 1907885 | 2021-11-12 | Otero | Colorado | 8089 | 2923 | 86 |
1904636 | 1904636 | 2021-11-11 | Otero | Colorado | 8089 | 2899 | 85 |
1901386 | 1901386 | 2021-11-10 | Otero | Colorado | 8089 | 2882 | 85 |
1898136 | 1898136 | 2021-11-09 | Otero | Colorado | 8089 | 2856 | 85 |
1894886 | 1894886 | 2021-11-08 | Otero | Colorado | 8089 | 2824 | 84 |
1891636 | 1891636 | 2021-11-07 | Otero | Colorado | 8089 | 2790 | 84 |
1888386 | 1888386 | 2021-11-06 | Otero | Colorado | 8089 | 2790 | 84 |
1885136 | 1885136 | 2021-11-05 | Otero | Colorado | 8089 | 2790 | 84 |
1881887 | 1881887 | 2021-11-04 | Otero | Colorado | 8089 | 2764 | 84 |
1878638 | 1878638 | 2021-11-03 | Otero | Colorado | 8089 | 2752 | 84 |
1875389 | 1875389 | 2021-11-02 | Otero | Colorado | 8089 | 2740 | 84 |
1872140 | 1872140 | 2021-11-01 | Otero | Colorado | 8089 | 2725 | 84 |
1868891 | 1868891 | 2021-10-31 | Otero | Colorado | 8089 | 2707 | 83 |
1865642 | 1865642 | 2021-10-30 | Otero | Colorado | 8089 | 2707 | 83 |
1862393 | 1862393 | 2021-10-29 | Otero | Colorado | 8089 | 2707 | 83 |
1859144 | 1859144 | 2021-10-28 | Otero | Colorado | 8089 | 2692 | 83 |
1855895 | 1855895 | 2021-10-27 | Otero | Colorado | 8089 | 2684 | 81 |
1852646 | 1852646 | 2021-10-26 | Otero | Colorado | 8089 | 2667 | 81 |
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);