ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Yuma" and state = "Colorado" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174503 | 2174503 | 2022-02-02 | Yuma | Colorado | 8125 | 1771 | 22 |
2171250 | 2171250 | 2022-02-01 | Yuma | Colorado | 8125 | 1755 | 22 |
2167997 | 2167997 | 2022-01-31 | Yuma | Colorado | 8125 | 1737 | 22 |
2164742 | 2164742 | 2022-01-30 | Yuma | Colorado | 8125 | 1715 | 22 |
2161487 | 2161487 | 2022-01-29 | Yuma | Colorado | 8125 | 1703 | 22 |
2158231 | 2158231 | 2022-01-28 | Yuma | Colorado | 8125 | 1715 | 22 |
2154978 | 2154978 | 2022-01-27 | Yuma | Colorado | 8125 | 1703 | 22 |
2151725 | 2151725 | 2022-01-26 | Yuma | Colorado | 8125 | 1687 | 22 |
2148473 | 2148473 | 2022-01-25 | Yuma | Colorado | 8125 | 1674 | 22 |
2145221 | 2145221 | 2022-01-24 | Yuma | Colorado | 8125 | 1663 | 22 |
2141966 | 2141966 | 2022-01-23 | Yuma | Colorado | 8125 | 1644 | 22 |
2138711 | 2138711 | 2022-01-22 | Yuma | Colorado | 8125 | 1644 | 22 |
2135455 | 2135455 | 2022-01-21 | Yuma | Colorado | 8125 | 1644 | 22 |
2132203 | 2132203 | 2022-01-20 | Yuma | Colorado | 8125 | 1629 | 22 |
2128950 | 2128950 | 2022-01-19 | Yuma | Colorado | 8125 | 1622 | 22 |
2125696 | 2125696 | 2022-01-18 | Yuma | Colorado | 8125 | 1615 | 22 |
2122444 | 2122444 | 2022-01-17 | Yuma | Colorado | 8125 | 1600 | 22 |
2119192 | 2119192 | 2022-01-16 | Yuma | Colorado | 8125 | 1583 | 22 |
2115940 | 2115940 | 2022-01-15 | Yuma | Colorado | 8125 | 1583 | 22 |
2112689 | 2112689 | 2022-01-14 | Yuma | Colorado | 8125 | 1583 | 22 |
2109437 | 2109437 | 2022-01-13 | Yuma | Colorado | 8125 | 1574 | 22 |
2106186 | 2106186 | 2022-01-12 | Yuma | Colorado | 8125 | 1564 | 22 |
2102935 | 2102935 | 2022-01-11 | Yuma | Colorado | 8125 | 1557 | 22 |
2099684 | 2099684 | 2022-01-10 | Yuma | Colorado | 8125 | 1537 | 22 |
2096433 | 2096433 | 2022-01-09 | Yuma | Colorado | 8125 | 1517 | 22 |
2093181 | 2093181 | 2022-01-08 | Yuma | Colorado | 8125 | 1517 | 22 |
2089929 | 2089929 | 2022-01-07 | Yuma | Colorado | 8125 | 1517 | 22 |
2086678 | 2086678 | 2022-01-06 | Yuma | Colorado | 8125 | 1514 | 22 |
2083426 | 2083426 | 2022-01-05 | Yuma | Colorado | 8125 | 1509 | 22 |
2080174 | 2080174 | 2022-01-04 | Yuma | Colorado | 8125 | 1504 | 22 |
2076922 | 2076922 | 2022-01-03 | Yuma | Colorado | 8125 | 1494 | 22 |
2073671 | 2073671 | 2022-01-02 | Yuma | Colorado | 8125 | 1481 | 22 |
2070420 | 2070420 | 2022-01-01 | Yuma | Colorado | 8125 | 1481 | 22 |
2067169 | 2067169 | 2021-12-31 | Yuma | Colorado | 8125 | 1481 | 22 |
2063918 | 2063918 | 2021-12-30 | Yuma | Colorado | 8125 | 1478 | 21 |
2060668 | 2060668 | 2021-12-29 | Yuma | Colorado | 8125 | 1476 | 21 |
2057419 | 2057419 | 2021-12-28 | Yuma | Colorado | 8125 | 1469 | 21 |
2054170 | 2054170 | 2021-12-27 | Yuma | Colorado | 8125 | 1463 | 21 |
2050920 | 2050920 | 2021-12-26 | Yuma | Colorado | 8125 | 1458 | 21 |
2047670 | 2047670 | 2021-12-25 | Yuma | Colorado | 8125 | 1458 | 21 |
2044420 | 2044420 | 2021-12-24 | Yuma | Colorado | 8125 | 1458 | 21 |
2041171 | 2041171 | 2021-12-23 | Yuma | Colorado | 8125 | 1456 | 21 |
2037921 | 2037921 | 2021-12-22 | Yuma | Colorado | 8125 | 1456 | 21 |
2034671 | 2034671 | 2021-12-21 | Yuma | Colorado | 8125 | 1451 | 21 |
2031421 | 2031421 | 2021-12-20 | Yuma | Colorado | 8125 | 1446 | 20 |
2028170 | 2028170 | 2021-12-19 | Yuma | Colorado | 8125 | 1440 | 20 |
2024919 | 2024919 | 2021-12-18 | Yuma | Colorado | 8125 | 1440 | 20 |
2021668 | 2021668 | 2021-12-17 | Yuma | Colorado | 8125 | 1440 | 20 |
2018417 | 2018417 | 2021-12-16 | Yuma | Colorado | 8125 | 1436 | 20 |
2015167 | 2015167 | 2021-12-15 | Yuma | Colorado | 8125 | 1434 | 20 |
2011916 | 2011916 | 2021-12-14 | Yuma | Colorado | 8125 | 1428 | 20 |
2008665 | 2008665 | 2021-12-13 | Yuma | Colorado | 8125 | 1422 | 20 |
2005414 | 2005414 | 2021-12-12 | Yuma | Colorado | 8125 | 1409 | 20 |
2002163 | 2002163 | 2021-12-11 | Yuma | Colorado | 8125 | 1409 | 20 |
1998913 | 1998913 | 2021-12-10 | Yuma | Colorado | 8125 | 1409 | 20 |
1995662 | 1995662 | 2021-12-09 | Yuma | Colorado | 8125 | 1406 | 20 |
1992411 | 1992411 | 2021-12-08 | Yuma | Colorado | 8125 | 1405 | 20 |
1989160 | 1989160 | 2021-12-07 | Yuma | Colorado | 8125 | 1403 | 18 |
1985910 | 1985910 | 2021-12-06 | Yuma | Colorado | 8125 | 1395 | 18 |
1982660 | 1982660 | 2021-12-05 | Yuma | Colorado | 8125 | 1386 | 18 |
1979410 | 1979410 | 2021-12-04 | Yuma | Colorado | 8125 | 1386 | 18 |
1976160 | 1976160 | 2021-12-03 | Yuma | Colorado | 8125 | 1386 | 18 |
1972911 | 1972911 | 2021-12-02 | Yuma | Colorado | 8125 | 1377 | 18 |
1969661 | 1969661 | 2021-12-01 | Yuma | Colorado | 8125 | 1373 | 18 |
1966411 | 1966411 | 2021-11-30 | Yuma | Colorado | 8125 | 1370 | 18 |
1963159 | 1963159 | 2021-11-29 | Yuma | Colorado | 8125 | 1367 | 18 |
1959908 | 1959908 | 2021-11-28 | Yuma | Colorado | 8125 | 1365 | 18 |
1956657 | 1956657 | 2021-11-27 | Yuma | Colorado | 8125 | 1365 | 18 |
1953406 | 1953406 | 2021-11-26 | Yuma | Colorado | 8125 | 1365 | 18 |
1950155 | 1950155 | 2021-11-25 | Yuma | Colorado | 8125 | 1365 | 18 |
1946904 | 1946904 | 2021-11-24 | Yuma | Colorado | 8125 | 1360 | 18 |
1943653 | 1943653 | 2021-11-23 | Yuma | Colorado | 8125 | 1360 | 18 |
1940403 | 1940403 | 2021-11-22 | Yuma | Colorado | 8125 | 1351 | 18 |
1937153 | 1937153 | 2021-11-21 | Yuma | Colorado | 8125 | 1350 | 18 |
1933903 | 1933903 | 2021-11-20 | Yuma | Colorado | 8125 | 1350 | 18 |
1930651 | 1930651 | 2021-11-19 | Yuma | Colorado | 8125 | 1350 | 18 |
1927401 | 1927401 | 2021-11-18 | Yuma | Colorado | 8125 | 1349 | 18 |
1924151 | 1924151 | 2021-11-17 | Yuma | Colorado | 8125 | 1342 | 18 |
1920902 | 1920902 | 2021-11-16 | Yuma | Colorado | 8125 | 1337 | 18 |
1917652 | 1917652 | 2021-11-15 | Yuma | Colorado | 8125 | 1326 | 18 |
1914402 | 1914402 | 2021-11-14 | Yuma | Colorado | 8125 | 1320 | 18 |
1911152 | 1911152 | 2021-11-13 | Yuma | Colorado | 8125 | 1320 | 18 |
1907903 | 1907903 | 2021-11-12 | Yuma | Colorado | 8125 | 1320 | 18 |
1904654 | 1904654 | 2021-11-11 | Yuma | Colorado | 8125 | 1317 | 18 |
1901404 | 1901404 | 2021-11-10 | Yuma | Colorado | 8125 | 1312 | 18 |
1898154 | 1898154 | 2021-11-09 | Yuma | Colorado | 8125 | 1303 | 18 |
1894904 | 1894904 | 2021-11-08 | Yuma | Colorado | 8125 | 1296 | 18 |
1891654 | 1891654 | 2021-11-07 | Yuma | Colorado | 8125 | 1289 | 18 |
1888404 | 1888404 | 2021-11-06 | Yuma | Colorado | 8125 | 1289 | 18 |
1885154 | 1885154 | 2021-11-05 | Yuma | Colorado | 8125 | 1289 | 18 |
1881905 | 1881905 | 2021-11-04 | Yuma | Colorado | 8125 | 1281 | 18 |
1878656 | 1878656 | 2021-11-03 | Yuma | Colorado | 8125 | 1272 | 18 |
1875407 | 1875407 | 2021-11-02 | Yuma | Colorado | 8125 | 1266 | 18 |
1872158 | 1872158 | 2021-11-01 | Yuma | Colorado | 8125 | 1262 | 18 |
1868909 | 1868909 | 2021-10-31 | Yuma | Colorado | 8125 | 1254 | 18 |
1865660 | 1865660 | 2021-10-30 | Yuma | Colorado | 8125 | 1254 | 18 |
1862411 | 1862411 | 2021-10-29 | Yuma | Colorado | 8125 | 1254 | 18 |
1859162 | 1859162 | 2021-10-28 | Yuma | Colorado | 8125 | 1248 | 18 |
1855913 | 1855913 | 2021-10-27 | Yuma | Colorado | 8125 | 1242 | 18 |
1852664 | 1852664 | 2021-10-26 | Yuma | Colorado | 8125 | 1234 | 18 |
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);