ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Grand" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174465 | 2174465 | 2022-02-02 | Grand | Colorado | 8049 | 3313 | 23 |
2171212 | 2171212 | 2022-02-01 | Grand | Colorado | 8049 | 3307 | 22 |
2167959 | 2167959 | 2022-01-31 | Grand | Colorado | 8049 | 3302 | 22 |
2164704 | 2164704 | 2022-01-30 | Grand | Colorado | 8049 | 3292 | 22 |
2161449 | 2161449 | 2022-01-29 | Grand | Colorado | 8049 | 3271 | 22 |
2158193 | 2158193 | 2022-01-28 | Grand | Colorado | 8049 | 3292 | 22 |
2154940 | 2154940 | 2022-01-27 | Grand | Colorado | 8049 | 3271 | 22 |
2151687 | 2151687 | 2022-01-26 | Grand | Colorado | 8049 | 3248 | 22 |
2148435 | 2148435 | 2022-01-25 | Grand | Colorado | 8049 | 3232 | 22 |
2145183 | 2145183 | 2022-01-24 | Grand | Colorado | 8049 | 3219 | 22 |
2141928 | 2141928 | 2022-01-23 | Grand | Colorado | 8049 | 3169 | 20 |
2138673 | 2138673 | 2022-01-22 | Grand | Colorado | 8049 | 3169 | 20 |
2135417 | 2135417 | 2022-01-21 | Grand | Colorado | 8049 | 3169 | 20 |
2132165 | 2132165 | 2022-01-20 | Grand | Colorado | 8049 | 3143 | 20 |
2128912 | 2128912 | 2022-01-19 | Grand | Colorado | 8049 | 3116 | 20 |
2125658 | 2125658 | 2022-01-18 | Grand | Colorado | 8049 | 3092 | 20 |
2122406 | 2122406 | 2022-01-17 | Grand | Colorado | 8049 | 3088 | 20 |
2119154 | 2119154 | 2022-01-16 | Grand | Colorado | 8049 | 3039 | 20 |
2115902 | 2115902 | 2022-01-15 | Grand | Colorado | 8049 | 3039 | 20 |
2112651 | 2112651 | 2022-01-14 | Grand | Colorado | 8049 | 3039 | 20 |
2109399 | 2109399 | 2022-01-13 | Grand | Colorado | 8049 | 2995 | 20 |
2106148 | 2106148 | 2022-01-12 | Grand | Colorado | 8049 | 2894 | 20 |
2102897 | 2102897 | 2022-01-11 | Grand | Colorado | 8049 | 2885 | 20 |
2099646 | 2099646 | 2022-01-10 | Grand | Colorado | 8049 | 2874 | 20 |
2096395 | 2096395 | 2022-01-09 | Grand | Colorado | 8049 | 2709 | 20 |
2093143 | 2093143 | 2022-01-08 | Grand | Colorado | 8049 | 2709 | 20 |
2089891 | 2089891 | 2022-01-07 | Grand | Colorado | 8049 | 2709 | 20 |
2086640 | 2086640 | 2022-01-06 | Grand | Colorado | 8049 | 2676 | 20 |
2083388 | 2083388 | 2022-01-05 | Grand | Colorado | 8049 | 2666 | 20 |
2080136 | 2080136 | 2022-01-04 | Grand | Colorado | 8049 | 2649 | 20 |
2076884 | 2076884 | 2022-01-03 | Grand | Colorado | 8049 | 2640 | 20 |
2073633 | 2073633 | 2022-01-02 | Grand | Colorado | 8049 | 2571 | 20 |
2070382 | 2070382 | 2022-01-01 | Grand | Colorado | 8049 | 2571 | 20 |
2067131 | 2067131 | 2021-12-31 | Grand | Colorado | 8049 | 2571 | 20 |
2063880 | 2063880 | 2021-12-30 | Grand | Colorado | 8049 | 2530 | 20 |
2060630 | 2060630 | 2021-12-29 | Grand | Colorado | 8049 | 2480 | 20 |
2057381 | 2057381 | 2021-12-28 | Grand | Colorado | 8049 | 2462 | 20 |
2054132 | 2054132 | 2021-12-27 | Grand | Colorado | 8049 | 2453 | 20 |
2050882 | 2050882 | 2021-12-26 | Grand | Colorado | 8049 | 2424 | 20 |
2047632 | 2047632 | 2021-12-25 | Grand | Colorado | 8049 | 2424 | 20 |
2044382 | 2044382 | 2021-12-24 | Grand | Colorado | 8049 | 2424 | 20 |
2041133 | 2041133 | 2021-12-23 | Grand | Colorado | 8049 | 2419 | 19 |
2037883 | 2037883 | 2021-12-22 | Grand | Colorado | 8049 | 2405 | 18 |
2034633 | 2034633 | 2021-12-21 | Grand | Colorado | 8049 | 2395 | 18 |
2031383 | 2031383 | 2021-12-20 | Grand | Colorado | 8049 | 2388 | 18 |
2028132 | 2028132 | 2021-12-19 | Grand | Colorado | 8049 | 2377 | 18 |
2024881 | 2024881 | 2021-12-18 | Grand | Colorado | 8049 | 2377 | 18 |
2021630 | 2021630 | 2021-12-17 | Grand | Colorado | 8049 | 2377 | 18 |
2018379 | 2018379 | 2021-12-16 | Grand | Colorado | 8049 | 2367 | 18 |
2015129 | 2015129 | 2021-12-15 | Grand | Colorado | 8049 | 2364 | 18 |
2011878 | 2011878 | 2021-12-14 | Grand | Colorado | 8049 | 2364 | 18 |
2008627 | 2008627 | 2021-12-13 | Grand | Colorado | 8049 | 2364 | 17 |
2005376 | 2005376 | 2021-12-12 | Grand | Colorado | 8049 | 2358 | 17 |
2002125 | 2002125 | 2021-12-11 | Grand | Colorado | 8049 | 2358 | 17 |
1998875 | 1998875 | 2021-12-10 | Grand | Colorado | 8049 | 2358 | 17 |
1995624 | 1995624 | 2021-12-09 | Grand | Colorado | 8049 | 2356 | 17 |
1992373 | 1992373 | 2021-12-08 | Grand | Colorado | 8049 | 2343 | 17 |
1989122 | 1989122 | 2021-12-07 | Grand | Colorado | 8049 | 2339 | 17 |
1985872 | 1985872 | 2021-12-06 | Grand | Colorado | 8049 | 2332 | 16 |
1982622 | 1982622 | 2021-12-05 | Grand | Colorado | 8049 | 2316 | 16 |
1979372 | 1979372 | 2021-12-04 | Grand | Colorado | 8049 | 2316 | 16 |
1976122 | 1976122 | 2021-12-03 | Grand | Colorado | 8049 | 2316 | 16 |
1972873 | 1972873 | 2021-12-02 | Grand | Colorado | 8049 | 2312 | 16 |
1969623 | 1969623 | 2021-12-01 | Grand | Colorado | 8049 | 2301 | 16 |
1966373 | 1966373 | 2021-11-30 | Grand | Colorado | 8049 | 2300 | 16 |
1963121 | 1963121 | 2021-11-29 | Grand | Colorado | 8049 | 2295 | 16 |
1959870 | 1959870 | 2021-11-28 | Grand | Colorado | 8049 | 2284 | 16 |
1956619 | 1956619 | 2021-11-27 | Grand | Colorado | 8049 | 2284 | 16 |
1953368 | 1953368 | 2021-11-26 | Grand | Colorado | 8049 | 2284 | 16 |
1950117 | 1950117 | 2021-11-25 | Grand | Colorado | 8049 | 2284 | 16 |
1946866 | 1946866 | 2021-11-24 | Grand | Colorado | 8049 | 2275 | 16 |
1943615 | 1943615 | 2021-11-23 | Grand | Colorado | 8049 | 2272 | 16 |
1940365 | 1940365 | 2021-11-22 | Grand | Colorado | 8049 | 2268 | 16 |
1937115 | 1937115 | 2021-11-21 | Grand | Colorado | 8049 | 2262 | 16 |
1933865 | 1933865 | 2021-11-20 | Grand | Colorado | 8049 | 2262 | 16 |
1930613 | 1930613 | 2021-11-19 | Grand | Colorado | 8049 | 2262 | 16 |
1927363 | 1927363 | 2021-11-18 | Grand | Colorado | 8049 | 2254 | 16 |
1924113 | 1924113 | 2021-11-17 | Grand | Colorado | 8049 | 2247 | 16 |
1920864 | 1920864 | 2021-11-16 | Grand | Colorado | 8049 | 2234 | 16 |
1917614 | 1917614 | 2021-11-15 | Grand | Colorado | 8049 | 2233 | 16 |
1914364 | 1914364 | 2021-11-14 | Grand | Colorado | 8049 | 2216 | 16 |
1911114 | 1911114 | 2021-11-13 | Grand | Colorado | 8049 | 2216 | 16 |
1907865 | 1907865 | 2021-11-12 | Grand | Colorado | 8049 | 2216 | 16 |
1904616 | 1904616 | 2021-11-11 | Grand | Colorado | 8049 | 2207 | 16 |
1901366 | 1901366 | 2021-11-10 | Grand | Colorado | 8049 | 2201 | 16 |
1898116 | 1898116 | 2021-11-09 | Grand | Colorado | 8049 | 2201 | 16 |
1894866 | 1894866 | 2021-11-08 | Grand | Colorado | 8049 | 2197 | 16 |
1891616 | 1891616 | 2021-11-07 | Grand | Colorado | 8049 | 2188 | 16 |
1888366 | 1888366 | 2021-11-06 | Grand | Colorado | 8049 | 2188 | 16 |
1885116 | 1885116 | 2021-11-05 | Grand | Colorado | 8049 | 2188 | 16 |
1881867 | 1881867 | 2021-11-04 | Grand | Colorado | 8049 | 2181 | 16 |
1878618 | 1878618 | 2021-11-03 | Grand | Colorado | 8049 | 2179 | 16 |
1875369 | 1875369 | 2021-11-02 | Grand | Colorado | 8049 | 2176 | 16 |
1872120 | 1872120 | 2021-11-01 | Grand | Colorado | 8049 | 2171 | 16 |
1868871 | 1868871 | 2021-10-31 | Grand | Colorado | 8049 | 2162 | 16 |
1865622 | 1865622 | 2021-10-30 | Grand | Colorado | 8049 | 2162 | 16 |
1862373 | 1862373 | 2021-10-29 | Grand | Colorado | 8049 | 2162 | 16 |
1859124 | 1859124 | 2021-10-28 | Grand | Colorado | 8049 | 2158 | 16 |
1855875 | 1855875 | 2021-10-27 | Grand | Colorado | 8049 | 2156 | 16 |
1852626 | 1852626 | 2021-10-26 | Grand | Colorado | 8049 | 2156 | 16 |
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);