ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "La Plata" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174473 | 2174473 | 2022-02-02 | La Plata | Colorado | 8067 | 11701 | 73 |
2171220 | 2171220 | 2022-02-01 | La Plata | Colorado | 8067 | 11591 | 73 |
2167967 | 2167967 | 2022-01-31 | La Plata | Colorado | 8067 | 11648 | 73 |
2164712 | 2164712 | 2022-01-30 | La Plata | Colorado | 8067 | 11495 | 73 |
2161457 | 2161457 | 2022-01-29 | La Plata | Colorado | 8067 | 11423 | 73 |
2158201 | 2158201 | 2022-01-28 | La Plata | Colorado | 8067 | 11495 | 73 |
2154948 | 2154948 | 2022-01-27 | La Plata | Colorado | 8067 | 11423 | 73 |
2151695 | 2151695 | 2022-01-26 | La Plata | Colorado | 8067 | 11289 | 73 |
2148443 | 2148443 | 2022-01-25 | La Plata | Colorado | 8067 | 11165 | 74 |
2145191 | 2145191 | 2022-01-24 | La Plata | Colorado | 8067 | 11076 | 74 |
2141936 | 2141936 | 2022-01-23 | La Plata | Colorado | 8067 | 10797 | 72 |
2138681 | 2138681 | 2022-01-22 | La Plata | Colorado | 8067 | 10797 | 72 |
2135425 | 2135425 | 2022-01-21 | La Plata | Colorado | 8067 | 10797 | 72 |
2132173 | 2132173 | 2022-01-20 | La Plata | Colorado | 8067 | 10597 | 70 |
2128920 | 2128920 | 2022-01-19 | La Plata | Colorado | 8067 | 10392 | 69 |
2125666 | 2125666 | 2022-01-18 | La Plata | Colorado | 8067 | 10205 | 68 |
2122414 | 2122414 | 2022-01-17 | La Plata | Colorado | 8067 | 10136 | 68 |
2119162 | 2119162 | 2022-01-16 | La Plata | Colorado | 8067 | 9849 | 68 |
2115910 | 2115910 | 2022-01-15 | La Plata | Colorado | 8067 | 9849 | 68 |
2112659 | 2112659 | 2022-01-14 | La Plata | Colorado | 8067 | 9849 | 68 |
2109407 | 2109407 | 2022-01-13 | La Plata | Colorado | 8067 | 9639 | 68 |
2106156 | 2106156 | 2022-01-12 | La Plata | Colorado | 8067 | 9336 | 68 |
2102905 | 2102905 | 2022-01-11 | La Plata | Colorado | 8067 | 9198 | 68 |
2099654 | 2099654 | 2022-01-10 | La Plata | Colorado | 8067 | 8904 | 68 |
2096403 | 2096403 | 2022-01-09 | La Plata | Colorado | 8067 | 8307 | 68 |
2093151 | 2093151 | 2022-01-08 | La Plata | Colorado | 8067 | 8307 | 68 |
2089899 | 2089899 | 2022-01-07 | La Plata | Colorado | 8067 | 8307 | 68 |
2086648 | 2086648 | 2022-01-06 | La Plata | Colorado | 8067 | 8145 | 68 |
2083396 | 2083396 | 2022-01-05 | La Plata | Colorado | 8067 | 8052 | 68 |
2080144 | 2080144 | 2022-01-04 | La Plata | Colorado | 8067 | 8008 | 67 |
2076892 | 2076892 | 2022-01-03 | La Plata | Colorado | 8067 | 7928 | 67 |
2073641 | 2073641 | 2022-01-02 | La Plata | Colorado | 8067 | 7730 | 67 |
2070390 | 2070390 | 2022-01-01 | La Plata | Colorado | 8067 | 7730 | 67 |
2067139 | 2067139 | 2021-12-31 | La Plata | Colorado | 8067 | 7730 | 67 |
2063888 | 2063888 | 2021-12-30 | La Plata | Colorado | 8067 | 7673 | 67 |
2060638 | 2060638 | 2021-12-29 | La Plata | Colorado | 8067 | 7586 | 67 |
2057389 | 2057389 | 2021-12-28 | La Plata | Colorado | 8067 | 7475 | 67 |
2054140 | 2054140 | 2021-12-27 | La Plata | Colorado | 8067 | 7465 | 67 |
2050890 | 2050890 | 2021-12-26 | La Plata | Colorado | 8067 | 7428 | 67 |
2047640 | 2047640 | 2021-12-25 | La Plata | Colorado | 8067 | 7428 | 67 |
2044390 | 2044390 | 2021-12-24 | La Plata | Colorado | 8067 | 7428 | 67 |
2041141 | 2041141 | 2021-12-23 | La Plata | Colorado | 8067 | 7391 | 67 |
2037891 | 2037891 | 2021-12-22 | La Plata | Colorado | 8067 | 7376 | 67 |
2034641 | 2034641 | 2021-12-21 | La Plata | Colorado | 8067 | 7342 | 67 |
2031391 | 2031391 | 2021-12-20 | La Plata | Colorado | 8067 | 7327 | 66 |
2028140 | 2028140 | 2021-12-19 | La Plata | Colorado | 8067 | 7289 | 65 |
2024889 | 2024889 | 2021-12-18 | La Plata | Colorado | 8067 | 7289 | 65 |
2021638 | 2021638 | 2021-12-17 | La Plata | Colorado | 8067 | 7289 | 65 |
2018387 | 2018387 | 2021-12-16 | La Plata | Colorado | 8067 | 7265 | 65 |
2015137 | 2015137 | 2021-12-15 | La Plata | Colorado | 8067 | 7245 | 65 |
2011886 | 2011886 | 2021-12-14 | La Plata | Colorado | 8067 | 7221 | 65 |
2008635 | 2008635 | 2021-12-13 | La Plata | Colorado | 8067 | 7207 | 64 |
2005384 | 2005384 | 2021-12-12 | La Plata | Colorado | 8067 | 7169 | 64 |
2002133 | 2002133 | 2021-12-11 | La Plata | Colorado | 8067 | 7169 | 64 |
1998883 | 1998883 | 2021-12-10 | La Plata | Colorado | 8067 | 7169 | 64 |
1995632 | 1995632 | 2021-12-09 | La Plata | Colorado | 8067 | 7140 | 63 |
1992381 | 1992381 | 2021-12-08 | La Plata | Colorado | 8067 | 7114 | 63 |
1989130 | 1989130 | 2021-12-07 | La Plata | Colorado | 8067 | 7084 | 63 |
1985880 | 1985880 | 2021-12-06 | La Plata | Colorado | 8067 | 7068 | 63 |
1982630 | 1982630 | 2021-12-05 | La Plata | Colorado | 8067 | 7021 | 63 |
1979380 | 1979380 | 2021-12-04 | La Plata | Colorado | 8067 | 7021 | 63 |
1976130 | 1976130 | 2021-12-03 | La Plata | Colorado | 8067 | 7021 | 63 |
1972881 | 1972881 | 2021-12-02 | La Plata | Colorado | 8067 | 6991 | 63 |
1969631 | 1969631 | 2021-12-01 | La Plata | Colorado | 8067 | 6962 | 62 |
1966381 | 1966381 | 2021-11-30 | La Plata | Colorado | 8067 | 6934 | 62 |
1963129 | 1963129 | 2021-11-29 | La Plata | Colorado | 8067 | 6918 | 59 |
1959878 | 1959878 | 2021-11-28 | La Plata | Colorado | 8067 | 6872 | 59 |
1956627 | 1956627 | 2021-11-27 | La Plata | Colorado | 8067 | 6867 | 59 |
1953376 | 1953376 | 2021-11-26 | La Plata | Colorado | 8067 | 6867 | 59 |
1950125 | 1950125 | 2021-11-25 | La Plata | Colorado | 8067 | 6867 | 59 |
1946874 | 1946874 | 2021-11-24 | La Plata | Colorado | 8067 | 6842 | 59 |
1943623 | 1943623 | 2021-11-23 | La Plata | Colorado | 8067 | 6798 | 60 |
1940373 | 1940373 | 2021-11-22 | La Plata | Colorado | 8067 | 6767 | 58 |
1937123 | 1937123 | 2021-11-21 | La Plata | Colorado | 8067 | 6697 | 58 |
1933873 | 1933873 | 2021-11-20 | La Plata | Colorado | 8067 | 6697 | 58 |
1930621 | 1930621 | 2021-11-19 | La Plata | Colorado | 8067 | 6697 | 58 |
1927371 | 1927371 | 2021-11-18 | La Plata | Colorado | 8067 | 6652 | 58 |
1924121 | 1924121 | 2021-11-17 | La Plata | Colorado | 8067 | 6617 | 57 |
1920872 | 1920872 | 2021-11-16 | La Plata | Colorado | 8067 | 6586 | 57 |
1917622 | 1917622 | 2021-11-15 | La Plata | Colorado | 8067 | 6536 | 55 |
1914372 | 1914372 | 2021-11-14 | La Plata | Colorado | 8067 | 6436 | 55 |
1911122 | 1911122 | 2021-11-13 | La Plata | Colorado | 8067 | 6436 | 55 |
1907873 | 1907873 | 2021-11-12 | La Plata | Colorado | 8067 | 6436 | 55 |
1904624 | 1904624 | 2021-11-11 | La Plata | Colorado | 8067 | 6362 | 55 |
1901374 | 1901374 | 2021-11-10 | La Plata | Colorado | 8067 | 6313 | 55 |
1898124 | 1898124 | 2021-11-09 | La Plata | Colorado | 8067 | 6252 | 55 |
1894874 | 1894874 | 2021-11-08 | La Plata | Colorado | 8067 | 6225 | 55 |
1891624 | 1891624 | 2021-11-07 | La Plata | Colorado | 8067 | 6141 | 55 |
1888374 | 1888374 | 2021-11-06 | La Plata | Colorado | 8067 | 6141 | 55 |
1885124 | 1885124 | 2021-11-05 | La Plata | Colorado | 8067 | 6141 | 55 |
1881875 | 1881875 | 2021-11-04 | La Plata | Colorado | 8067 | 6105 | 55 |
1878626 | 1878626 | 2021-11-03 | La Plata | Colorado | 8067 | 6071 | 55 |
1875377 | 1875377 | 2021-11-02 | La Plata | Colorado | 8067 | 6027 | 55 |
1872128 | 1872128 | 2021-11-01 | La Plata | Colorado | 8067 | 6000 | 54 |
1868879 | 1868879 | 2021-10-31 | La Plata | Colorado | 8067 | 5922 | 54 |
1865630 | 1865630 | 2021-10-30 | La Plata | Colorado | 8067 | 5922 | 54 |
1862381 | 1862381 | 2021-10-29 | La Plata | Colorado | 8067 | 5922 | 54 |
1859132 | 1859132 | 2021-10-28 | La Plata | Colorado | 8067 | 5878 | 54 |
1855883 | 1855883 | 2021-10-27 | La Plata | Colorado | 8067 | 5828 | 54 |
1852634 | 1852634 | 2021-10-26 | La Plata | Colorado | 8067 | 5804 | 52 |
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);