ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Stanislaus" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174431 | 2174431 | 2022-02-02 | Stanislaus | California | 6099 | 127732 | 1544 |
2171178 | 2171178 | 2022-02-01 | Stanislaus | California | 6099 | 126644 | 1532 |
2167925 | 2167925 | 2022-01-31 | Stanislaus | California | 6099 | 126644 | 1532 |
2164670 | 2164670 | 2022-01-30 | Stanislaus | California | 6099 | 124561 | 1529 |
2161415 | 2161415 | 2022-01-29 | Stanislaus | California | 6099 | 124561 | 1529 |
2158159 | 2158159 | 2022-01-28 | Stanislaus | California | 6099 | 124561 | 1529 |
2154906 | 2154906 | 2022-01-27 | Stanislaus | California | 6099 | 123084 | 1527 |
2151653 | 2151653 | 2022-01-26 | Stanislaus | California | 6099 | 121527 | 1526 |
2148401 | 2148401 | 2022-01-25 | Stanislaus | California | 6099 | 120581 | 1525 |
2145149 | 2145149 | 2022-01-24 | Stanislaus | California | 6099 | 119285 | 1521 |
2141894 | 2141894 | 2022-01-23 | Stanislaus | California | 6099 | 115652 | 1517 |
2138639 | 2138639 | 2022-01-22 | Stanislaus | California | 6099 | 115652 | 1517 |
2135383 | 2135383 | 2022-01-21 | Stanislaus | California | 6099 | 115652 | 1517 |
2132131 | 2132131 | 2022-01-20 | Stanislaus | California | 6099 | 113759 | 1515 |
2128878 | 2128878 | 2022-01-19 | Stanislaus | California | 6099 | 112225 | 1512 |
2125624 | 2125624 | 2022-01-18 | Stanislaus | California | 6099 | 111038 | 1509 |
2122372 | 2122372 | 2022-01-17 | Stanislaus | California | 6099 | 109853 | 1504 |
2119120 | 2119120 | 2022-01-16 | Stanislaus | California | 6099 | 106512 | 1504 |
2115868 | 2115868 | 2022-01-15 | Stanislaus | California | 6099 | 106512 | 1504 |
2112617 | 2112617 | 2022-01-14 | Stanislaus | California | 6099 | 106512 | 1504 |
2109365 | 2109365 | 2022-01-13 | Stanislaus | California | 6099 | 105299 | 1503 |
2106114 | 2106114 | 2022-01-12 | Stanislaus | California | 6099 | 103712 | 1501 |
2102863 | 2102863 | 2022-01-11 | Stanislaus | California | 6099 | 102843 | 1499 |
2099612 | 2099612 | 2022-01-10 | Stanislaus | California | 6099 | 101694 | 1499 |
2096361 | 2096361 | 2022-01-09 | Stanislaus | California | 6099 | 98740 | 1497 |
2093109 | 2093109 | 2022-01-08 | Stanislaus | California | 6099 | 98740 | 1497 |
2089857 | 2089857 | 2022-01-07 | Stanislaus | California | 6099 | 98740 | 1497 |
2086606 | 2086606 | 2022-01-06 | Stanislaus | California | 6099 | 98063 | 1491 |
2083354 | 2083354 | 2022-01-05 | Stanislaus | California | 6099 | 96951 | 1481 |
2080102 | 2080102 | 2022-01-04 | Stanislaus | California | 6099 | 96951 | 1481 |
2076850 | 2076850 | 2022-01-03 | Stanislaus | California | 6099 | 96598 | 1478 |
2073599 | 2073599 | 2022-01-02 | Stanislaus | California | 6099 | 95133 | 1473 |
2070348 | 2070348 | 2022-01-01 | Stanislaus | California | 6099 | 95133 | 1473 |
2067097 | 2067097 | 2021-12-31 | Stanislaus | California | 6099 | 95133 | 1473 |
2063846 | 2063846 | 2021-12-30 | Stanislaus | California | 6099 | 95133 | 1473 |
2060596 | 2060596 | 2021-12-29 | Stanislaus | California | 6099 | 94829 | 1468 |
2057347 | 2057347 | 2021-12-28 | Stanislaus | California | 6099 | 94652 | 1464 |
2054098 | 2054098 | 2021-12-27 | Stanislaus | California | 6099 | 94492 | 1464 |
2050848 | 2050848 | 2021-12-26 | Stanislaus | California | 6099 | 94009 | 1464 |
2047598 | 2047598 | 2021-12-25 | Stanislaus | California | 6099 | 94009 | 1464 |
2044348 | 2044348 | 2021-12-24 | Stanislaus | California | 6099 | 94009 | 1464 |
2041099 | 2041099 | 2021-12-23 | Stanislaus | California | 6099 | 94009 | 1464 |
2037849 | 2037849 | 2021-12-22 | Stanislaus | California | 6099 | 93867 | 1464 |
2034599 | 2034599 | 2021-12-21 | Stanislaus | California | 6099 | 93783 | 1464 |
2031349 | 2031349 | 2021-12-20 | Stanislaus | California | 6099 | 93694 | 1462 |
2028098 | 2028098 | 2021-12-19 | Stanislaus | California | 6099 | 93408 | 1459 |
2024847 | 2024847 | 2021-12-18 | Stanislaus | California | 6099 | 93408 | 1459 |
2021596 | 2021596 | 2021-12-17 | Stanislaus | California | 6099 | 93408 | 1459 |
2018345 | 2018345 | 2021-12-16 | Stanislaus | California | 6099 | 93263 | 1459 |
2015095 | 2015095 | 2021-12-15 | Stanislaus | California | 6099 | 93074 | 1455 |
2011844 | 2011844 | 2021-12-14 | Stanislaus | California | 6099 | 93074 | 1455 |
2008593 | 2008593 | 2021-12-13 | Stanislaus | California | 6099 | 92973 | 1452 |
2005342 | 2005342 | 2021-12-12 | Stanislaus | California | 6099 | 92709 | 1452 |
2002091 | 2002091 | 2021-12-11 | Stanislaus | California | 6099 | 92709 | 1452 |
1998841 | 1998841 | 2021-12-10 | Stanislaus | California | 6099 | 92709 | 1452 |
1995590 | 1995590 | 2021-12-09 | Stanislaus | California | 6099 | 92542 | 1449 |
1992339 | 1992339 | 2021-12-08 | Stanislaus | California | 6099 | 92420 | 1441 |
1989088 | 1989088 | 2021-12-07 | Stanislaus | California | 6099 | 92332 | 1436 |
1985838 | 1985838 | 2021-12-06 | Stanislaus | California | 6099 | 92229 | 1434 |
1982588 | 1982588 | 2021-12-05 | Stanislaus | California | 6099 | 91964 | 1429 |
1979338 | 1979338 | 2021-12-04 | Stanislaus | California | 6099 | 91964 | 1429 |
1976088 | 1976088 | 2021-12-03 | Stanislaus | California | 6099 | 91964 | 1429 |
1972839 | 1972839 | 2021-12-02 | Stanislaus | California | 6099 | 91762 | 1424 |
1969589 | 1969589 | 2021-12-01 | Stanislaus | California | 6099 | 91620 | 1422 |
1966339 | 1966339 | 2021-11-30 | Stanislaus | California | 6099 | 91548 | 1417 |
1963087 | 1963087 | 2021-11-29 | Stanislaus | California | 6099 | 91465 | 1415 |
1959836 | 1959836 | 2021-11-28 | Stanislaus | California | 6099 | 91299 | 1413 |
1956585 | 1956585 | 2021-11-27 | Stanislaus | California | 6099 | 91299 | 1413 |
1953334 | 1953334 | 2021-11-26 | Stanislaus | California | 6099 | 91299 | 1413 |
1950083 | 1950083 | 2021-11-25 | Stanislaus | California | 6099 | 91064 | 1413 |
1946832 | 1946832 | 2021-11-24 | Stanislaus | California | 6099 | 91064 | 1413 |
1943581 | 1943581 | 2021-11-23 | Stanislaus | California | 6099 | 90969 | 1412 |
1940331 | 1940331 | 2021-11-22 | Stanislaus | California | 6099 | 90634 | 1406 |
1937081 | 1937081 | 2021-11-21 | Stanislaus | California | 6099 | 90634 | 1406 |
1933831 | 1933831 | 2021-11-20 | Stanislaus | California | 6099 | 90634 | 1406 |
1930579 | 1930579 | 2021-11-19 | Stanislaus | California | 6099 | 90634 | 1406 |
1927329 | 1927329 | 2021-11-18 | Stanislaus | California | 6099 | 90471 | 1404 |
1924079 | 1924079 | 2021-11-17 | Stanislaus | California | 6099 | 90231 | 1401 |
1920830 | 1920830 | 2021-11-16 | Stanislaus | California | 6099 | 90136 | 1398 |
1917580 | 1917580 | 2021-11-15 | Stanislaus | California | 6099 | 90005 | 1394 |
1914330 | 1914330 | 2021-11-14 | Stanislaus | California | 6099 | 89701 | 1387 |
1911080 | 1911080 | 2021-11-13 | Stanislaus | California | 6099 | 89701 | 1387 |
1907831 | 1907831 | 2021-11-12 | Stanislaus | California | 6099 | 89701 | 1387 |
1904582 | 1904582 | 2021-11-11 | Stanislaus | California | 6099 | 89331 | 1380 |
1901332 | 1901332 | 2021-11-10 | Stanislaus | California | 6099 | 89331 | 1380 |
1898082 | 1898082 | 2021-11-09 | Stanislaus | California | 6099 | 89331 | 1380 |
1894832 | 1894832 | 2021-11-08 | Stanislaus | California | 6099 | 89222 | 1378 |
1891582 | 1891582 | 2021-11-07 | Stanislaus | California | 6099 | 87998 | 1359 |
1888332 | 1888332 | 2021-11-06 | Stanislaus | California | 6099 | 87998 | 1359 |
1885082 | 1885082 | 2021-11-05 | Stanislaus | California | 6099 | 87998 | 1359 |
1881833 | 1881833 | 2021-11-04 | Stanislaus | California | 6099 | 87998 | 1359 |
1878584 | 1878584 | 2021-11-03 | Stanislaus | California | 6099 | 87998 | 1359 |
1875335 | 1875335 | 2021-11-02 | Stanislaus | California | 6099 | 87998 | 1359 |
1872086 | 1872086 | 2021-11-01 | Stanislaus | California | 6099 | 87908 | 1359 |
1868837 | 1868837 | 2021-10-31 | Stanislaus | California | 6099 | 87466 | 1357 |
1865588 | 1865588 | 2021-10-30 | Stanislaus | California | 6099 | 87466 | 1357 |
1862339 | 1862339 | 2021-10-29 | Stanislaus | California | 6099 | 87466 | 1357 |
1859090 | 1859090 | 2021-10-28 | Stanislaus | California | 6099 | 87219 | 1350 |
1855841 | 1855841 | 2021-10-27 | Stanislaus | California | 6099 | 87020 | 1347 |
1852592 | 1852592 | 2021-10-26 | Stanislaus | California | 6099 | 86874 | 1341 |
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);