ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Santa Cruz" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946826 | 1946826 | 2021-11-24 | Santa Cruz | California | 6087 | 22028 | 222 |
1943575 | 1943575 | 2021-11-23 | Santa Cruz | California | 6087 | 21990 | 222 |
1940325 | 1940325 | 2021-11-22 | Santa Cruz | California | 6087 | 21965 | 222 |
1937075 | 1937075 | 2021-11-21 | Santa Cruz | California | 6087 | 21855 | 222 |
1933825 | 1933825 | 2021-11-20 | Santa Cruz | California | 6087 | 21855 | 222 |
1930573 | 1930573 | 2021-11-19 | Santa Cruz | California | 6087 | 21855 | 222 |
1927323 | 1927323 | 2021-11-18 | Santa Cruz | California | 6087 | 21799 | 222 |
1924073 | 1924073 | 2021-11-17 | Santa Cruz | California | 6087 | 21777 | 223 |
1920824 | 1920824 | 2021-11-16 | Santa Cruz | California | 6087 | 21723 | 223 |
1917574 | 1917574 | 2021-11-15 | Santa Cruz | California | 6087 | 21702 | 223 |
1914324 | 1914324 | 2021-11-14 | Santa Cruz | California | 6087 | 21658 | 223 |
1911074 | 1911074 | 2021-11-13 | Santa Cruz | California | 6087 | 21658 | 223 |
1907825 | 1907825 | 2021-11-12 | Santa Cruz | California | 6087 | 21572 | 222 |
1904576 | 1904576 | 2021-11-11 | Santa Cruz | California | 6087 | 21572 | 222 |
1901326 | 1901326 | 2021-11-10 | Santa Cruz | California | 6087 | 21546 | 222 |
1898076 | 1898076 | 2021-11-09 | Santa Cruz | California | 6087 | 21518 | 222 |
1894826 | 1894826 | 2021-11-08 | Santa Cruz | California | 6087 | 21480 | 222 |
1891576 | 1891576 | 2021-11-07 | Santa Cruz | California | 6087 | 21394 | 222 |
1888326 | 1888326 | 2021-11-06 | Santa Cruz | California | 6087 | 21394 | 222 |
1885076 | 1885076 | 2021-11-05 | Santa Cruz | California | 6087 | 21394 | 222 |
1881827 | 1881827 | 2021-11-04 | Santa Cruz | California | 6087 | 21358 | 222 |
1878578 | 1878578 | 2021-11-03 | Santa Cruz | California | 6087 | 21343 | 222 |
1875329 | 1875329 | 2021-11-02 | Santa Cruz | California | 6087 | 21315 | 221 |
1872080 | 1872080 | 2021-11-01 | Santa Cruz | California | 6087 | 21295 | 221 |
1868831 | 1868831 | 2021-10-31 | Santa Cruz | California | 6087 | 21211 | 221 |
1865582 | 1865582 | 2021-10-30 | Santa Cruz | California | 6087 | 21211 | 221 |
1862333 | 1862333 | 2021-10-29 | Santa Cruz | California | 6087 | 21211 | 221 |
1859084 | 1859084 | 2021-10-28 | Santa Cruz | California | 6087 | 21168 | 221 |
1855835 | 1855835 | 2021-10-27 | Santa Cruz | California | 6087 | 21134 | 221 |
1852586 | 1852586 | 2021-10-26 | Santa Cruz | California | 6087 | 21120 | 221 |
1849337 | 1849337 | 2021-10-25 | Santa Cruz | California | 6087 | 21034 | 221 |
1846087 | 1846087 | 2021-10-24 | Santa Cruz | California | 6087 | 21034 | 221 |
1842837 | 1842837 | 2021-10-23 | Santa Cruz | California | 6087 | 21034 | 221 |
1839587 | 1839587 | 2021-10-22 | Santa Cruz | California | 6087 | 21034 | 221 |
1836338 | 1836338 | 2021-10-21 | Santa Cruz | California | 6087 | 21018 | 219 |
1833089 | 1833089 | 2021-10-20 | Santa Cruz | California | 6087 | 20962 | 218 |
1829840 | 1829840 | 2021-10-19 | Santa Cruz | California | 6087 | 20943 | 218 |
1826591 | 1826591 | 2021-10-18 | Santa Cruz | California | 6087 | 20928 | 218 |
1823342 | 1823342 | 2021-10-17 | Santa Cruz | California | 6087 | 20861 | 218 |
1820093 | 1820093 | 2021-10-16 | Santa Cruz | California | 6087 | 20861 | 218 |
1816844 | 1816844 | 2021-10-15 | Santa Cruz | California | 6087 | 20861 | 218 |
1813596 | 1813596 | 2021-10-14 | Santa Cruz | California | 6087 | 20830 | 217 |
1810347 | 1810347 | 2021-10-13 | Santa Cruz | California | 6087 | 20819 | 218 |
1807098 | 1807098 | 2021-10-12 | Santa Cruz | California | 6087 | 20807 | 217 |
1803847 | 1803847 | 2021-10-11 | Santa Cruz | California | 6087 | 20789 | 217 |
1800598 | 1800598 | 2021-10-10 | Santa Cruz | California | 6087 | 20697 | 217 |
1797349 | 1797349 | 2021-10-09 | Santa Cruz | California | 6087 | 20697 | 217 |
1794100 | 1794100 | 2021-10-08 | Santa Cruz | California | 6087 | 20697 | 217 |
1790852 | 1790852 | 2021-10-07 | Santa Cruz | California | 6087 | 20666 | 217 |
1787603 | 1787603 | 2021-10-06 | Santa Cruz | California | 6087 | 20635 | 216 |
1784354 | 1784354 | 2021-10-05 | Santa Cruz | California | 6087 | 20612 | 216 |
1781105 | 1781105 | 2021-10-04 | Santa Cruz | California | 6087 | 20601 | 216 |
1777855 | 1777855 | 2021-10-03 | Santa Cruz | California | 6087 | 20514 | 214 |
1774605 | 1774605 | 2021-10-02 | Santa Cruz | California | 6087 | 20514 | 214 |
1771355 | 1771355 | 2021-10-01 | Santa Cruz | California | 6087 | 20514 | 214 |
1768106 | 1768106 | 2021-09-30 | Santa Cruz | California | 6087 | 20478 | 214 |
1764857 | 1764857 | 2021-09-29 | Santa Cruz | California | 6087 | 20379 | 214 |
1761608 | 1761608 | 2021-09-28 | Santa Cruz | California | 6087 | 20347 | 214 |
1758360 | 1758360 | 2021-09-27 | Santa Cruz | California | 6087 | 20334 | 214 |
1755112 | 1755112 | 2021-09-26 | Santa Cruz | California | 6087 | 20255 | 214 |
1751864 | 1751864 | 2021-09-25 | Santa Cruz | California | 6087 | 20255 | 214 |
1748615 | 1748615 | 2021-09-24 | Santa Cruz | California | 6087 | 20255 | 214 |
1745365 | 1745365 | 2021-09-23 | Santa Cruz | California | 6087 | 20232 | 214 |
1742116 | 1742116 | 2021-09-22 | Santa Cruz | California | 6087 | 20195 | 212 |
1738867 | 1738867 | 2021-09-21 | Santa Cruz | California | 6087 | 20176 | 211 |
1735618 | 1735618 | 2021-09-20 | Santa Cruz | California | 6087 | 20151 | 211 |
1732368 | 1732368 | 2021-09-19 | Santa Cruz | California | 6087 | 20134 | 211 |
1729118 | 1729118 | 2021-09-18 | Santa Cruz | California | 6087 | 20094 | 211 |
1725868 | 1725868 | 2021-09-17 | Santa Cruz | California | 6087 | 20066 | 211 |
1722619 | 1722619 | 2021-09-16 | Santa Cruz | California | 6087 | 20039 | 210 |
1719370 | 1719370 | 2021-09-15 | Santa Cruz | California | 6087 | 19999 | 210 |
1716122 | 1716122 | 2021-09-14 | Santa Cruz | California | 6087 | 19951 | 210 |
1712876 | 1712876 | 2021-09-13 | Santa Cruz | California | 6087 | 19926 | 210 |
1709629 | 1709629 | 2021-09-12 | Santa Cruz | California | 6087 | 19899 | 210 |
1706382 | 1706382 | 2021-09-11 | Santa Cruz | California | 6087 | 19819 | 210 |
1703134 | 1703134 | 2021-09-10 | Santa Cruz | California | 6087 | 19762 | 210 |
1699884 | 1699884 | 2021-09-09 | Santa Cruz | California | 6087 | 19733 | 210 |
1696635 | 1696635 | 2021-09-08 | Santa Cruz | California | 6087 | 19688 | 210 |
1693387 | 1693387 | 2021-09-07 | Santa Cruz | California | 6087 | 19634 | 210 |
1690138 | 1690138 | 2021-09-06 | Santa Cruz | California | 6087 | 19607 | 210 |
1686888 | 1686888 | 2021-09-05 | Santa Cruz | California | 6087 | 19598 | 210 |
1683638 | 1683638 | 2021-09-04 | Santa Cruz | California | 6087 | 19551 | 210 |
1680387 | 1680387 | 2021-09-03 | Santa Cruz | California | 6087 | 19492 | 210 |
1677139 | 1677139 | 2021-09-02 | Santa Cruz | California | 6087 | 19472 | 210 |
1673892 | 1673892 | 2021-09-01 | Santa Cruz | California | 6087 | 19398 | 210 |
1670644 | 1670644 | 2021-08-31 | Santa Cruz | California | 6087 | 19305 | 210 |
1667397 | 1667397 | 2021-08-30 | Santa Cruz | California | 6087 | 19264 | 210 |
1664150 | 1664150 | 2021-08-29 | Santa Cruz | California | 6087 | 19219 | 210 |
1660902 | 1660902 | 2021-08-28 | Santa Cruz | California | 6087 | 19142 | 210 |
1657654 | 1657654 | 2021-08-27 | Santa Cruz | California | 6087 | 19051 | 210 |
1654406 | 1654406 | 2021-08-26 | Santa Cruz | California | 6087 | 18966 | 210 |
1651159 | 1651159 | 2021-08-25 | Santa Cruz | California | 6087 | 18881 | 209 |
1647910 | 1647910 | 2021-08-24 | Santa Cruz | California | 6087 | 18824 | 209 |
1644662 | 1644662 | 2021-08-23 | Santa Cruz | California | 6087 | 18776 | 209 |
1641412 | 1641412 | 2021-08-22 | Santa Cruz | California | 6087 | 18716 | 209 |
1638162 | 1638162 | 2021-08-21 | Santa Cruz | California | 6087 | 18654 | 209 |
1634912 | 1634912 | 2021-08-20 | Santa Cruz | California | 6087 | 18597 | 209 |
1631663 | 1631663 | 2021-08-19 | Santa Cruz | California | 6087 | 18519 | 209 |
1628416 | 1628416 | 2021-08-18 | Santa Cruz | California | 6087 | 18415 | 209 |
1625169 | 1625169 | 2021-08-17 | Santa Cruz | California | 6087 | 18378 | 209 |
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);