ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Pontotoc" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948809 | 1948809 | 2021-11-24 | Pontotoc | Oklahoma | 40123 | 7057 | 101 |
1945558 | 1945558 | 2021-11-23 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1942307 | 1942307 | 2021-11-22 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1939057 | 1939057 | 2021-11-21 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1935807 | 1935807 | 2021-11-20 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1932557 | 1932557 | 2021-11-19 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1929306 | 1929306 | 2021-11-18 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1926056 | 1926056 | 2021-11-17 | Pontotoc | Oklahoma | 40123 | 6999 | 101 |
1922806 | 1922806 | 2021-11-16 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1919557 | 1919557 | 2021-11-15 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1916307 | 1916307 | 2021-11-14 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1913057 | 1913057 | 2021-11-13 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1909807 | 1909807 | 2021-11-12 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1906558 | 1906558 | 2021-11-11 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1903309 | 1903309 | 2021-11-10 | Pontotoc | Oklahoma | 40123 | 6934 | 101 |
1900059 | 1900059 | 2021-11-09 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1896809 | 1896809 | 2021-11-08 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1893559 | 1893559 | 2021-11-07 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1890309 | 1890309 | 2021-11-06 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1887059 | 1887059 | 2021-11-05 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1883809 | 1883809 | 2021-11-04 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1880560 | 1880560 | 2021-11-03 | Pontotoc | Oklahoma | 40123 | 6891 | 101 |
1877311 | 1877311 | 2021-11-02 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1874062 | 1874062 | 2021-11-01 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1870813 | 1870813 | 2021-10-31 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1867564 | 1867564 | 2021-10-30 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1864315 | 1864315 | 2021-10-29 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1861066 | 1861066 | 2021-10-28 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1857817 | 1857817 | 2021-10-27 | Pontotoc | Oklahoma | 40123 | 6834 | 97 |
1854568 | 1854568 | 2021-10-26 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1851319 | 1851319 | 2021-10-25 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1848069 | 1848069 | 2021-10-24 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1844819 | 1844819 | 2021-10-23 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1841569 | 1841569 | 2021-10-22 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1838320 | 1838320 | 2021-10-21 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1835071 | 1835071 | 2021-10-20 | Pontotoc | Oklahoma | 40123 | 6764 | 97 |
1831822 | 1831822 | 2021-10-19 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1828573 | 1828573 | 2021-10-18 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1825324 | 1825324 | 2021-10-17 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1822075 | 1822075 | 2021-10-16 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1818826 | 1818826 | 2021-10-15 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1815577 | 1815577 | 2021-10-14 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1812329 | 1812329 | 2021-10-13 | Pontotoc | Oklahoma | 40123 | 6701 | 93 |
1809080 | 1809080 | 2021-10-12 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1805830 | 1805830 | 2021-10-11 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1802580 | 1802580 | 2021-10-10 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1799331 | 1799331 | 2021-10-09 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1796082 | 1796082 | 2021-10-08 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1792833 | 1792833 | 2021-10-07 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1789584 | 1789584 | 2021-10-06 | Pontotoc | Oklahoma | 40123 | 6595 | 91 |
1786336 | 1786336 | 2021-10-05 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1783087 | 1783087 | 2021-10-04 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1779838 | 1779838 | 2021-10-03 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1776588 | 1776588 | 2021-10-02 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1773338 | 1773338 | 2021-10-01 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1770088 | 1770088 | 2021-09-30 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1766839 | 1766839 | 2021-09-29 | Pontotoc | Oklahoma | 40123 | 6508 | 90 |
1763590 | 1763590 | 2021-09-28 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1760341 | 1760341 | 2021-09-27 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1757093 | 1757093 | 2021-09-26 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1753845 | 1753845 | 2021-09-25 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1750597 | 1750597 | 2021-09-24 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1747347 | 1747347 | 2021-09-23 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1744098 | 1744098 | 2021-09-22 | Pontotoc | Oklahoma | 40123 | 6330 | 87 |
1740849 | 1740849 | 2021-09-21 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1737600 | 1737600 | 2021-09-20 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1734350 | 1734350 | 2021-09-19 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1731100 | 1731100 | 2021-09-18 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1727850 | 1727850 | 2021-09-17 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1724601 | 1724601 | 2021-09-16 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1721352 | 1721352 | 2021-09-15 | Pontotoc | Oklahoma | 40123 | 6216 | 86 |
1718104 | 1718104 | 2021-09-14 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1714856 | 1714856 | 2021-09-13 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1711610 | 1711610 | 2021-09-12 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1708363 | 1708363 | 2021-09-11 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1705116 | 1705116 | 2021-09-10 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1701866 | 1701866 | 2021-09-09 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1698617 | 1698617 | 2021-09-08 | Pontotoc | Oklahoma | 40123 | 6075 | 83 |
1695369 | 1695369 | 2021-09-07 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1692121 | 1692121 | 2021-09-06 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1688872 | 1688872 | 2021-09-05 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1685622 | 1685622 | 2021-09-04 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1682371 | 1682371 | 2021-09-03 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1679121 | 1679121 | 2021-09-02 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1675873 | 1675873 | 2021-09-01 | Pontotoc | Oklahoma | 40123 | 5920 | 83 |
1672626 | 1672626 | 2021-08-31 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1669378 | 1669378 | 2021-08-30 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1666131 | 1666131 | 2021-08-29 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1662883 | 1662883 | 2021-08-28 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1659635 | 1659635 | 2021-08-27 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1656386 | 1656386 | 2021-08-26 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1653139 | 1653139 | 2021-08-25 | Pontotoc | Oklahoma | 40123 | 5663 | 83 |
1649892 | 1649892 | 2021-08-24 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1646643 | 1646643 | 2021-08-23 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1643394 | 1643394 | 2021-08-22 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1640144 | 1640144 | 2021-08-21 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1636894 | 1636894 | 2021-08-20 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1633644 | 1633644 | 2021-08-19 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1630397 | 1630397 | 2021-08-18 | Pontotoc | Oklahoma | 40123 | 5578 | 81 |
1627150 | 1627150 | 2021-08-17 | Pontotoc | Oklahoma | 40123 | 5477 | 80 |
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);