ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6019 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1716088 | 1716088 | 2021-09-14 | Fresno | California | 6019 | 133272 | 1853 |
1712842 | 1712842 | 2021-09-13 | Fresno | California | 6019 | 133029 | 1853 |
1709595 | 1709595 | 2021-09-12 | Fresno | California | 6019 | 132846 | 1853 |
1706348 | 1706348 | 2021-09-11 | Fresno | California | 6019 | 132281 | 1846 |
1703100 | 1703100 | 2021-09-10 | Fresno | California | 6019 | 131662 | 1838 |
1699850 | 1699850 | 2021-09-09 | Fresno | California | 6019 | 131266 | 1831 |
1696601 | 1696601 | 2021-09-08 | Fresno | California | 6019 | 130757 | 1828 |
1693353 | 1693353 | 2021-09-07 | Fresno | California | 6019 | 130227 | 1828 |
1690104 | 1690104 | 2021-09-06 | Fresno | California | 6019 | 129873 | 1828 |
1686854 | 1686854 | 2021-09-05 | Fresno | California | 6019 | 129522 | 1828 |
1683604 | 1683604 | 2021-09-04 | Fresno | California | 6019 | 128997 | 1822 |
1680353 | 1680353 | 2021-09-03 | Fresno | California | 6019 | 128463 | 1804 |
1677105 | 1677105 | 2021-09-02 | Fresno | California | 6019 | 127981 | 1800 |
1673858 | 1673858 | 2021-09-01 | Fresno | California | 6019 | 127396 | 1801 |
1670610 | 1670610 | 2021-08-31 | Fresno | California | 6019 | 126108 | 1790 |
1667363 | 1667363 | 2021-08-30 | Fresno | California | 6019 | 125743 | 1790 |
1664116 | 1664116 | 2021-08-29 | Fresno | California | 6019 | 125320 | 1792 |
1660868 | 1660868 | 2021-08-28 | Fresno | California | 6019 | 124722 | 1774 |
1657620 | 1657620 | 2021-08-27 | Fresno | California | 6019 | 124095 | 1770 |
1654372 | 1654372 | 2021-08-26 | Fresno | California | 6019 | 123625 | 1761 |
1651125 | 1651125 | 2021-08-25 | Fresno | California | 6019 | 123026 | 1761 |
1647876 | 1647876 | 2021-08-24 | Fresno | California | 6019 | 122447 | 1759 |
1644628 | 1644628 | 2021-08-23 | Fresno | California | 6019 | 122059 | 1759 |
1641378 | 1641378 | 2021-08-22 | Fresno | California | 6019 | 121767 | 1759 |
1638128 | 1638128 | 2021-08-21 | Fresno | California | 6019 | 121317 | 1759 |
1634878 | 1634878 | 2021-08-20 | Fresno | California | 6019 | 120949 | 1759 |
1631629 | 1631629 | 2021-08-19 | Fresno | California | 6019 | 120525 | 1759 |
1628382 | 1628382 | 2021-08-18 | Fresno | California | 6019 | 119941 | 1755 |
1625135 | 1625135 | 2021-08-17 | Fresno | California | 6019 | 119301 | 1753 |
1621888 | 1621888 | 2021-08-16 | Fresno | California | 6019 | 119060 | 1753 |
1618641 | 1618641 | 2021-08-15 | Fresno | California | 6019 | 118734 | 1753 |
1615393 | 1615393 | 2021-08-14 | Fresno | California | 6019 | 118316 | 1753 |
1612144 | 1612144 | 2021-08-13 | Fresno | California | 6019 | 117871 | 1753 |
1608896 | 1608896 | 2021-08-12 | Fresno | California | 6019 | 117451 | 1751 |
1605647 | 1605647 | 2021-08-11 | Fresno | California | 6019 | 117294 | 1747 |
1602398 | 1602398 | 2021-08-10 | Fresno | California | 6019 | 116988 | 1747 |
1599149 | 1599149 | 2021-08-09 | Fresno | California | 6019 | 116756 | 1747 |
1595900 | 1595900 | 2021-08-08 | Fresno | California | 6019 | 116539 | 1747 |
1592651 | 1592651 | 2021-08-07 | Fresno | California | 6019 | 115897 | 1747 |
1589402 | 1589402 | 2021-08-06 | Fresno | California | 6019 | 115897 | 1747 |
1586153 | 1586153 | 2021-08-05 | Fresno | California | 6019 | 115577 | 1747 |
1582903 | 1582903 | 2021-08-04 | Fresno | California | 6019 | 115322 | 1746 |
1579653 | 1579653 | 2021-08-03 | Fresno | California | 6019 | 115061 | 1744 |
1576405 | 1576405 | 2021-08-02 | Fresno | California | 6019 | 114929 | 1744 |
1573157 | 1573157 | 2021-08-01 | Fresno | California | 6019 | 114229 | 1744 |
1569909 | 1569909 | 2021-07-31 | Fresno | California | 6019 | 114229 | 1744 |
1566661 | 1566661 | 2021-07-30 | Fresno | California | 6019 | 114229 | 1744 |
1563413 | 1563413 | 2021-07-29 | Fresno | California | 6019 | 114048 | 1744 |
1560165 | 1560165 | 2021-07-28 | Fresno | California | 6019 | 113764 | 1746 |
1556918 | 1556918 | 2021-07-27 | Fresno | California | 6019 | 113619 | 1742 |
1553671 | 1553671 | 2021-07-26 | Fresno | California | 6019 | 113495 | 1742 |
1550424 | 1550424 | 2021-07-25 | Fresno | California | 6019 | 113113 | 1736 |
1547177 | 1547177 | 2021-07-24 | Fresno | California | 6019 | 113113 | 1736 |
1543930 | 1543930 | 2021-07-23 | Fresno | California | 6019 | 113113 | 1736 |
1540682 | 1540682 | 2021-07-22 | Fresno | California | 6019 | 112980 | 1736 |
1537435 | 1537435 | 2021-07-21 | Fresno | California | 6019 | 112705 | 1736 |
1534187 | 1534187 | 2021-07-20 | Fresno | California | 6019 | 112617 | 1731 |
1530940 | 1530940 | 2021-07-19 | Fresno | California | 6019 | 112565 | 1731 |
1527693 | 1527693 | 2021-07-18 | Fresno | California | 6019 | 112322 | 1730 |
1524446 | 1524446 | 2021-07-17 | Fresno | California | 6019 | 112322 | 1730 |
1521198 | 1521198 | 2021-07-16 | Fresno | California | 6019 | 112322 | 1730 |
1517950 | 1517950 | 2021-07-15 | Fresno | California | 6019 | 112233 | 1728 |
1514703 | 1514703 | 2021-07-14 | Fresno | California | 6019 | 112176 | 1727 |
1511457 | 1511457 | 2021-07-13 | Fresno | California | 6019 | 112120 | 1728 |
1508210 | 1508210 | 2021-07-12 | Fresno | California | 6019 | 112080 | 1728 |
1504964 | 1504964 | 2021-07-11 | Fresno | California | 6019 | 111942 | 1730 |
1501718 | 1501718 | 2021-07-10 | Fresno | California | 6019 | 111942 | 1730 |
1498472 | 1498472 | 2021-07-09 | Fresno | California | 6019 | 111942 | 1730 |
1495225 | 1495225 | 2021-07-08 | Fresno | California | 6019 | 111906 | 1729 |
1491978 | 1491978 | 2021-07-07 | Fresno | California | 6019 | 102616 | 1727 |
1488731 | 1488731 | 2021-07-06 | Fresno | California | 6019 | 102592 | 1727 |
1485484 | 1485484 | 2021-07-05 | Fresno | California | 6019 | 102512 | 1727 |
1482238 | 1482238 | 2021-07-04 | Fresno | California | 6019 | 102512 | 1727 |
1478991 | 1478991 | 2021-07-03 | Fresno | California | 6019 | 102512 | 1727 |
1475745 | 1475745 | 2021-07-02 | Fresno | California | 6019 | 102512 | 1727 |
1472499 | 1472499 | 2021-07-01 | Fresno | California | 6019 | 102490 | 1727 |
1469254 | 1469254 | 2021-06-30 | Fresno | California | 6019 | 102464 | 1725 |
1466009 | 1466009 | 2021-06-29 | Fresno | California | 6019 | 103121 | 1727 |
1462764 | 1462764 | 2021-06-28 | Fresno | California | 6019 | 103110 | 1727 |
1459519 | 1459519 | 2021-06-27 | Fresno | California | 6019 | 103091 | 1727 |
1456274 | 1456274 | 2021-06-26 | Fresno | California | 6019 | 103073 | 1727 |
1453029 | 1453029 | 2021-06-25 | Fresno | California | 6019 | 103061 | 1727 |
1449783 | 1449783 | 2021-06-24 | Fresno | California | 6019 | 103020 | 1724 |
1446538 | 1446538 | 2021-06-23 | Fresno | California | 6019 | 102996 | 1724 |
1443293 | 1443293 | 2021-06-22 | Fresno | California | 6019 | 102971 | 1724 |
1440048 | 1440048 | 2021-06-21 | Fresno | California | 6019 | 102947 | 1724 |
1436801 | 1436801 | 2021-06-20 | Fresno | California | 6019 | 102922 | 1724 |
1433554 | 1433554 | 2021-06-19 | Fresno | California | 6019 | 102894 | 1722 |
1430308 | 1430308 | 2021-06-18 | Fresno | California | 6019 | 102867 | 1722 |
1427063 | 1427063 | 2021-06-17 | Fresno | California | 6019 | 102842 | 1722 |
1423818 | 1423818 | 2021-06-16 | Fresno | California | 6019 | 102828 | 1722 |
1420570 | 1420570 | 2021-06-15 | Fresno | California | 6019 | 102812 | 1719 |
1417325 | 1417325 | 2021-06-14 | Fresno | California | 6019 | 102795 | 1719 |
1414079 | 1414079 | 2021-06-13 | Fresno | California | 6019 | 102783 | 1720 |
1410834 | 1410834 | 2021-06-12 | Fresno | California | 6019 | 102770 | 1720 |
1407589 | 1407589 | 2021-06-11 | Fresno | California | 6019 | 102724 | 1717 |
1404343 | 1404343 | 2021-06-10 | Fresno | California | 6019 | 102690 | 1717 |
1401098 | 1401098 | 2021-06-09 | Fresno | California | 6019 | 102680 | 1717 |
1397853 | 1397853 | 2021-06-08 | Fresno | California | 6019 | 102659 | 1717 |
1394606 | 1394606 | 2021-06-07 | Fresno | California | 6019 | 102642 | 1717 |
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);