ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "San Joaquin" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1940320 | 1940320 | 2021-11-22 | San Joaquin | California | 6077 | 106896 | 1837 |
1937070 | 1937070 | 2021-11-21 | San Joaquin | California | 6077 | 106554 | 1835 |
1933820 | 1933820 | 2021-11-20 | San Joaquin | California | 6077 | 106554 | 1835 |
1930568 | 1930568 | 2021-11-19 | San Joaquin | California | 6077 | 106554 | 1835 |
1927318 | 1927318 | 2021-11-18 | San Joaquin | California | 6077 | 106396 | 1832 |
1924068 | 1924068 | 2021-11-17 | San Joaquin | California | 6077 | 106203 | 1832 |
1920819 | 1920819 | 2021-11-16 | San Joaquin | California | 6077 | 106153 | 1803 |
1917569 | 1917569 | 2021-11-15 | San Joaquin | California | 6077 | 106084 | 1803 |
1914319 | 1914319 | 2021-11-14 | San Joaquin | California | 6077 | 105829 | 1803 |
1911069 | 1911069 | 2021-11-13 | San Joaquin | California | 6077 | 105829 | 1803 |
1907820 | 1907820 | 2021-11-12 | San Joaquin | California | 6077 | 105503 | 1803 |
1904571 | 1904571 | 2021-11-11 | San Joaquin | California | 6077 | 105503 | 1803 |
1901321 | 1901321 | 2021-11-10 | San Joaquin | California | 6077 | 105333 | 1798 |
1898071 | 1898071 | 2021-11-09 | San Joaquin | California | 6077 | 105221 | 1798 |
1894821 | 1894821 | 2021-11-08 | San Joaquin | California | 6077 | 105181 | 1794 |
1891571 | 1891571 | 2021-11-07 | San Joaquin | California | 6077 | 104857 | 1782 |
1888321 | 1888321 | 2021-11-06 | San Joaquin | California | 6077 | 104857 | 1782 |
1885071 | 1885071 | 2021-11-05 | San Joaquin | California | 6077 | 104857 | 1782 |
1881822 | 1881822 | 2021-11-04 | San Joaquin | California | 6077 | 104673 | 1779 |
1878573 | 1878573 | 2021-11-03 | San Joaquin | California | 6077 | 104488 | 1779 |
1875324 | 1875324 | 2021-11-02 | San Joaquin | California | 6077 | 104381 | 1775 |
1872075 | 1872075 | 2021-11-01 | San Joaquin | California | 6077 | 104305 | 1775 |
1868826 | 1868826 | 2021-10-31 | San Joaquin | California | 6077 | 103726 | 1768 |
1865577 | 1865577 | 2021-10-30 | San Joaquin | California | 6077 | 103726 | 1768 |
1862328 | 1862328 | 2021-10-29 | San Joaquin | California | 6077 | 103726 | 1768 |
1859079 | 1859079 | 2021-10-28 | San Joaquin | California | 6077 | 103580 | 1758 |
1855830 | 1855830 | 2021-10-27 | San Joaquin | California | 6077 | 103372 | 1748 |
1852581 | 1852581 | 2021-10-26 | San Joaquin | California | 6077 | 103316 | 1745 |
1849332 | 1849332 | 2021-10-25 | San Joaquin | California | 6077 | 102776 | 1745 |
1846082 | 1846082 | 2021-10-24 | San Joaquin | California | 6077 | 102776 | 1731 |
1842832 | 1842832 | 2021-10-23 | San Joaquin | California | 6077 | 102776 | 1731 |
1839582 | 1839582 | 2021-10-22 | San Joaquin | California | 6077 | 102776 | 1731 |
1836333 | 1836333 | 2021-10-21 | San Joaquin | California | 6077 | 102582 | 1726 |
1833084 | 1833084 | 2021-10-20 | San Joaquin | California | 6077 | 102405 | 1726 |
1829835 | 1829835 | 2021-10-19 | San Joaquin | California | 6077 | 102341 | 1726 |
1826586 | 1826586 | 2021-10-18 | San Joaquin | California | 6077 | 102250 | 1726 |
1823337 | 1823337 | 2021-10-17 | San Joaquin | California | 6077 | 101807 | 1721 |
1820088 | 1820088 | 2021-10-16 | San Joaquin | California | 6077 | 101807 | 1721 |
1816839 | 1816839 | 2021-10-15 | San Joaquin | California | 6077 | 101807 | 1721 |
1813591 | 1813591 | 2021-10-14 | San Joaquin | California | 6077 | 101643 | 1702 |
1810342 | 1810342 | 2021-10-13 | San Joaquin | California | 6077 | 101461 | 1702 |
1807093 | 1807093 | 2021-10-12 | San Joaquin | California | 6077 | 101376 | 1687 |
1803842 | 1803842 | 2021-10-11 | San Joaquin | California | 6077 | 101308 | 1687 |
1800593 | 1800593 | 2021-10-10 | San Joaquin | California | 6077 | 100830 | 1681 |
1797344 | 1797344 | 2021-10-09 | San Joaquin | California | 6077 | 100830 | 1681 |
1794095 | 1794095 | 2021-10-08 | San Joaquin | California | 6077 | 100830 | 1681 |
1790847 | 1790847 | 2021-10-07 | San Joaquin | California | 6077 | 100642 | 1668 |
1787598 | 1787598 | 2021-10-06 | San Joaquin | California | 6077 | 100447 | 1668 |
1784349 | 1784349 | 2021-10-05 | San Joaquin | California | 6077 | 100369 | 1658 |
1781100 | 1781100 | 2021-10-04 | San Joaquin | California | 6077 | 100304 | 1658 |
1777850 | 1777850 | 2021-10-03 | San Joaquin | California | 6077 | 99770 | 1658 |
1774600 | 1774600 | 2021-10-02 | San Joaquin | California | 6077 | 99770 | 1658 |
1771350 | 1771350 | 2021-10-01 | San Joaquin | California | 6077 | 99770 | 1658 |
1768101 | 1768101 | 2021-09-30 | San Joaquin | California | 6077 | 99527 | 1654 |
1764852 | 1764852 | 2021-09-29 | San Joaquin | California | 6077 | 99272 | 1654 |
1761603 | 1761603 | 2021-09-28 | San Joaquin | California | 6077 | 99163 | 1642 |
1758355 | 1758355 | 2021-09-27 | San Joaquin | California | 6077 | 99013 | 1642 |
1755107 | 1755107 | 2021-09-26 | San Joaquin | California | 6077 | 98351 | 1641 |
1751859 | 1751859 | 2021-09-25 | San Joaquin | California | 6077 | 98351 | 1641 |
1748610 | 1748610 | 2021-09-24 | San Joaquin | California | 6077 | 98351 | 1641 |
1745360 | 1745360 | 2021-09-23 | San Joaquin | California | 6077 | 98088 | 1638 |
1742111 | 1742111 | 2021-09-22 | San Joaquin | California | 6077 | 97682 | 1638 |
1738862 | 1738862 | 2021-09-21 | San Joaquin | California | 6077 | 97534 | 1629 |
1735613 | 1735613 | 2021-09-20 | San Joaquin | California | 6077 | 97387 | 1629 |
1732363 | 1732363 | 2021-09-19 | San Joaquin | California | 6077 | 97162 | 1624 |
1729113 | 1729113 | 2021-09-18 | San Joaquin | California | 6077 | 96897 | 1624 |
1725863 | 1725863 | 2021-09-17 | San Joaquin | California | 6077 | 96570 | 1624 |
1722614 | 1722614 | 2021-09-16 | San Joaquin | California | 6077 | 96242 | 1619 |
1719365 | 1719365 | 2021-09-15 | San Joaquin | California | 6077 | 95861 | 1619 |
1716117 | 1716117 | 2021-09-14 | San Joaquin | California | 6077 | 95699 | 1581 |
1712871 | 1712871 | 2021-09-13 | San Joaquin | California | 6077 | 95463 | 1581 |
1709624 | 1709624 | 2021-09-12 | San Joaquin | California | 6077 | 95215 | 1581 |
1706377 | 1706377 | 2021-09-11 | San Joaquin | California | 6077 | 94941 | 1573 |
1703129 | 1703129 | 2021-09-10 | San Joaquin | California | 6077 | 94607 | 1570 |
1699879 | 1699879 | 2021-09-09 | San Joaquin | California | 6077 | 94364 | 1561 |
1696630 | 1696630 | 2021-09-08 | San Joaquin | California | 6077 | 94105 | 1548 |
1693382 | 1693382 | 2021-09-07 | San Joaquin | California | 6077 | 93930 | 1548 |
1690133 | 1690133 | 2021-09-06 | San Joaquin | California | 6077 | 93758 | 1548 |
1686883 | 1686883 | 2021-09-05 | San Joaquin | California | 6077 | 93483 | 1548 |
1683633 | 1683633 | 2021-09-04 | San Joaquin | California | 6077 | 93003 | 1540 |
1680382 | 1680382 | 2021-09-03 | San Joaquin | California | 6077 | 92693 | 1540 |
1677134 | 1677134 | 2021-09-02 | San Joaquin | California | 6077 | 92277 | 1540 |
1673887 | 1673887 | 2021-09-01 | San Joaquin | California | 6077 | 91954 | 1540 |
1670639 | 1670639 | 2021-08-31 | San Joaquin | California | 6077 | 90792 | 1528 |
1667392 | 1667392 | 2021-08-30 | San Joaquin | California | 6077 | 90511 | 1528 |
1664145 | 1664145 | 2021-08-29 | San Joaquin | California | 6077 | 90070 | 1527 |
1660897 | 1660897 | 2021-08-28 | San Joaquin | California | 6077 | 89538 | 1524 |
1657649 | 1657649 | 2021-08-27 | San Joaquin | California | 6077 | 89018 | 1513 |
1654401 | 1654401 | 2021-08-26 | San Joaquin | California | 6077 | 88591 | 1510 |
1651154 | 1651154 | 2021-08-25 | San Joaquin | California | 6077 | 88151 | 1508 |
1647905 | 1647905 | 2021-08-24 | San Joaquin | California | 6077 | 87933 | 1499 |
1644657 | 1644657 | 2021-08-23 | San Joaquin | California | 6077 | 87588 | 1498 |
1641407 | 1641407 | 2021-08-22 | San Joaquin | California | 6077 | 87292 | 1498 |
1638157 | 1638157 | 2021-08-21 | San Joaquin | California | 6077 | 86886 | 1496 |
1634907 | 1634907 | 2021-08-20 | San Joaquin | California | 6077 | 86514 | 1491 |
1631658 | 1631658 | 2021-08-19 | San Joaquin | California | 6077 | 86068 | 1491 |
1628411 | 1628411 | 2021-08-18 | San Joaquin | California | 6077 | 85520 | 1489 |
1625164 | 1625164 | 2021-08-17 | San Joaquin | California | 6077 | 85307 | 1488 |
1621917 | 1621917 | 2021-08-16 | San Joaquin | California | 6077 | 85052 | 1491 |
1618670 | 1618670 | 2021-08-15 | San Joaquin | California | 6077 | 84805 | 1491 |
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);