ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40147 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948822 | 1948822 | 2021-11-24 | Washington | Oklahoma | 40147 | 8639 | 200 |
1945571 | 1945571 | 2021-11-23 | Washington | Oklahoma | 40147 | 8578 | 200 |
1942320 | 1942320 | 2021-11-22 | Washington | Oklahoma | 40147 | 8578 | 200 |
1939070 | 1939070 | 2021-11-21 | Washington | Oklahoma | 40147 | 8578 | 200 |
1935820 | 1935820 | 2021-11-20 | Washington | Oklahoma | 40147 | 8578 | 200 |
1932570 | 1932570 | 2021-11-19 | Washington | Oklahoma | 40147 | 8578 | 200 |
1929319 | 1929319 | 2021-11-18 | Washington | Oklahoma | 40147 | 8578 | 200 |
1926069 | 1926069 | 2021-11-17 | Washington | Oklahoma | 40147 | 8578 | 200 |
1922819 | 1922819 | 2021-11-16 | Washington | Oklahoma | 40147 | 8531 | 200 |
1919570 | 1919570 | 2021-11-15 | Washington | Oklahoma | 40147 | 8531 | 200 |
1916320 | 1916320 | 2021-11-14 | Washington | Oklahoma | 40147 | 8531 | 200 |
1913070 | 1913070 | 2021-11-13 | Washington | Oklahoma | 40147 | 8531 | 200 |
1909820 | 1909820 | 2021-11-12 | Washington | Oklahoma | 40147 | 8531 | 200 |
1906571 | 1906571 | 2021-11-11 | Washington | Oklahoma | 40147 | 8531 | 200 |
1903322 | 1903322 | 2021-11-10 | Washington | Oklahoma | 40147 | 8531 | 200 |
1900072 | 1900072 | 2021-11-09 | Washington | Oklahoma | 40147 | 8488 | 200 |
1896822 | 1896822 | 2021-11-08 | Washington | Oklahoma | 40147 | 8488 | 200 |
1893572 | 1893572 | 2021-11-07 | Washington | Oklahoma | 40147 | 8488 | 200 |
1890322 | 1890322 | 2021-11-06 | Washington | Oklahoma | 40147 | 8488 | 200 |
1887072 | 1887072 | 2021-11-05 | Washington | Oklahoma | 40147 | 8488 | 200 |
1883822 | 1883822 | 2021-11-04 | Washington | Oklahoma | 40147 | 8488 | 200 |
1880573 | 1880573 | 2021-11-03 | Washington | Oklahoma | 40147 | 8488 | 200 |
1877324 | 1877324 | 2021-11-02 | Washington | Oklahoma | 40147 | 8413 | 196 |
1874075 | 1874075 | 2021-11-01 | Washington | Oklahoma | 40147 | 8413 | 196 |
1870826 | 1870826 | 2021-10-31 | Washington | Oklahoma | 40147 | 8413 | 196 |
1867577 | 1867577 | 2021-10-30 | Washington | Oklahoma | 40147 | 8413 | 196 |
1864328 | 1864328 | 2021-10-29 | Washington | Oklahoma | 40147 | 8413 | 196 |
1861079 | 1861079 | 2021-10-28 | Washington | Oklahoma | 40147 | 8413 | 196 |
1857830 | 1857830 | 2021-10-27 | Washington | Oklahoma | 40147 | 8413 | 196 |
1854581 | 1854581 | 2021-10-26 | Washington | Oklahoma | 40147 | 8365 | 193 |
1851332 | 1851332 | 2021-10-25 | Washington | Oklahoma | 40147 | 8365 | 193 |
1848082 | 1848082 | 2021-10-24 | Washington | Oklahoma | 40147 | 8365 | 193 |
1844832 | 1844832 | 2021-10-23 | Washington | Oklahoma | 40147 | 8365 | 193 |
1841582 | 1841582 | 2021-10-22 | Washington | Oklahoma | 40147 | 8365 | 193 |
1838333 | 1838333 | 2021-10-21 | Washington | Oklahoma | 40147 | 8365 | 193 |
1835084 | 1835084 | 2021-10-20 | Washington | Oklahoma | 40147 | 8365 | 193 |
1831835 | 1831835 | 2021-10-19 | Washington | Oklahoma | 40147 | 8310 | 183 |
1828586 | 1828586 | 2021-10-18 | Washington | Oklahoma | 40147 | 8310 | 183 |
1825337 | 1825337 | 2021-10-17 | Washington | Oklahoma | 40147 | 8310 | 183 |
1822088 | 1822088 | 2021-10-16 | Washington | Oklahoma | 40147 | 8310 | 183 |
1818839 | 1818839 | 2021-10-15 | Washington | Oklahoma | 40147 | 8310 | 183 |
1815590 | 1815590 | 2021-10-14 | Washington | Oklahoma | 40147 | 8310 | 183 |
1812342 | 1812342 | 2021-10-13 | Washington | Oklahoma | 40147 | 8310 | 183 |
1809093 | 1809093 | 2021-10-12 | Washington | Oklahoma | 40147 | 8219 | 179 |
1805843 | 1805843 | 2021-10-11 | Washington | Oklahoma | 40147 | 8219 | 179 |
1802593 | 1802593 | 2021-10-10 | Washington | Oklahoma | 40147 | 8219 | 179 |
1799344 | 1799344 | 2021-10-09 | Washington | Oklahoma | 40147 | 8219 | 179 |
1796095 | 1796095 | 2021-10-08 | Washington | Oklahoma | 40147 | 8219 | 179 |
1792846 | 1792846 | 2021-10-07 | Washington | Oklahoma | 40147 | 8219 | 179 |
1789597 | 1789597 | 2021-10-06 | Washington | Oklahoma | 40147 | 8219 | 179 |
1786349 | 1786349 | 2021-10-05 | Washington | Oklahoma | 40147 | 8159 | 171 |
1783100 | 1783100 | 2021-10-04 | Washington | Oklahoma | 40147 | 8159 | 171 |
1779851 | 1779851 | 2021-10-03 | Washington | Oklahoma | 40147 | 8159 | 171 |
1776601 | 1776601 | 2021-10-02 | Washington | Oklahoma | 40147 | 8159 | 171 |
1773351 | 1773351 | 2021-10-01 | Washington | Oklahoma | 40147 | 8159 | 171 |
1770101 | 1770101 | 2021-09-30 | Washington | Oklahoma | 40147 | 8159 | 171 |
1766852 | 1766852 | 2021-09-29 | Washington | Oklahoma | 40147 | 8159 | 171 |
1763603 | 1763603 | 2021-09-28 | Washington | Oklahoma | 40147 | 7819 | 164 |
1760354 | 1760354 | 2021-09-27 | Washington | Oklahoma | 40147 | 7819 | 164 |
1757106 | 1757106 | 2021-09-26 | Washington | Oklahoma | 40147 | 7819 | 164 |
1753858 | 1753858 | 2021-09-25 | Washington | Oklahoma | 40147 | 7819 | 164 |
1750610 | 1750610 | 2021-09-24 | Washington | Oklahoma | 40147 | 7819 | 164 |
1747360 | 1747360 | 2021-09-23 | Washington | Oklahoma | 40147 | 7819 | 164 |
1744111 | 1744111 | 2021-09-22 | Washington | Oklahoma | 40147 | 7819 | 164 |
1740862 | 1740862 | 2021-09-21 | Washington | Oklahoma | 40147 | 7655 | 159 |
1737613 | 1737613 | 2021-09-20 | Washington | Oklahoma | 40147 | 7655 | 159 |
1734363 | 1734363 | 2021-09-19 | Washington | Oklahoma | 40147 | 7655 | 159 |
1731113 | 1731113 | 2021-09-18 | Washington | Oklahoma | 40147 | 7655 | 159 |
1727863 | 1727863 | 2021-09-17 | Washington | Oklahoma | 40147 | 7655 | 159 |
1724614 | 1724614 | 2021-09-16 | Washington | Oklahoma | 40147 | 7655 | 159 |
1721365 | 1721365 | 2021-09-15 | Washington | Oklahoma | 40147 | 7655 | 159 |
1718117 | 1718117 | 2021-09-14 | Washington | Oklahoma | 40147 | 7466 | 151 |
1714869 | 1714869 | 2021-09-13 | Washington | Oklahoma | 40147 | 7466 | 151 |
1711623 | 1711623 | 2021-09-12 | Washington | Oklahoma | 40147 | 7466 | 151 |
1708376 | 1708376 | 2021-09-11 | Washington | Oklahoma | 40147 | 7466 | 151 |
1705129 | 1705129 | 2021-09-10 | Washington | Oklahoma | 40147 | 7466 | 151 |
1701879 | 1701879 | 2021-09-09 | Washington | Oklahoma | 40147 | 7466 | 151 |
1698630 | 1698630 | 2021-09-08 | Washington | Oklahoma | 40147 | 7466 | 151 |
1695382 | 1695382 | 2021-09-07 | Washington | Oklahoma | 40147 | 7142 | 142 |
1692134 | 1692134 | 2021-09-06 | Washington | Oklahoma | 40147 | 7142 | 142 |
1688885 | 1688885 | 2021-09-05 | Washington | Oklahoma | 40147 | 7142 | 142 |
1685635 | 1685635 | 2021-09-04 | Washington | Oklahoma | 40147 | 7142 | 142 |
1682384 | 1682384 | 2021-09-03 | Washington | Oklahoma | 40147 | 7142 | 142 |
1679134 | 1679134 | 2021-09-02 | Washington | Oklahoma | 40147 | 7142 | 142 |
1675886 | 1675886 | 2021-09-01 | Washington | Oklahoma | 40147 | 7142 | 142 |
1672639 | 1672639 | 2021-08-31 | Washington | Oklahoma | 40147 | 6824 | 132 |
1669391 | 1669391 | 2021-08-30 | Washington | Oklahoma | 40147 | 6824 | 132 |
1666144 | 1666144 | 2021-08-29 | Washington | Oklahoma | 40147 | 6824 | 132 |
1662896 | 1662896 | 2021-08-28 | Washington | Oklahoma | 40147 | 6824 | 132 |
1659648 | 1659648 | 2021-08-27 | Washington | Oklahoma | 40147 | 6824 | 132 |
1656399 | 1656399 | 2021-08-26 | Washington | Oklahoma | 40147 | 6824 | 132 |
1653152 | 1653152 | 2021-08-25 | Washington | Oklahoma | 40147 | 6824 | 132 |
1649905 | 1649905 | 2021-08-24 | Washington | Oklahoma | 40147 | 6540 | 130 |
1646656 | 1646656 | 2021-08-23 | Washington | Oklahoma | 40147 | 6540 | 130 |
1643407 | 1643407 | 2021-08-22 | Washington | Oklahoma | 40147 | 6540 | 130 |
1640157 | 1640157 | 2021-08-21 | Washington | Oklahoma | 40147 | 6540 | 130 |
1636907 | 1636907 | 2021-08-20 | Washington | Oklahoma | 40147 | 6540 | 130 |
1633657 | 1633657 | 2021-08-19 | Washington | Oklahoma | 40147 | 6540 | 130 |
1630410 | 1630410 | 2021-08-18 | Washington | Oklahoma | 40147 | 6540 | 130 |
1627163 | 1627163 | 2021-08-17 | Washington | Oklahoma | 40147 | 6229 | 124 |
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);