ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Adair" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948748 | 1948748 | 2021-11-24 | Adair | Oklahoma | 40001 | 4995 | 62 |
1945497 | 1945497 | 2021-11-23 | Adair | Oklahoma | 40001 | 4962 | 62 |
1942246 | 1942246 | 2021-11-22 | Adair | Oklahoma | 40001 | 4962 | 62 |
1938996 | 1938996 | 2021-11-21 | Adair | Oklahoma | 40001 | 4962 | 62 |
1935746 | 1935746 | 2021-11-20 | Adair | Oklahoma | 40001 | 4962 | 62 |
1932496 | 1932496 | 2021-11-19 | Adair | Oklahoma | 40001 | 4962 | 62 |
1929245 | 1929245 | 2021-11-18 | Adair | Oklahoma | 40001 | 4962 | 62 |
1925995 | 1925995 | 2021-11-17 | Adair | Oklahoma | 40001 | 4962 | 62 |
1922745 | 1922745 | 2021-11-16 | Adair | Oklahoma | 40001 | 4932 | 62 |
1919496 | 1919496 | 2021-11-15 | Adair | Oklahoma | 40001 | 4932 | 62 |
1916246 | 1916246 | 2021-11-14 | Adair | Oklahoma | 40001 | 4932 | 62 |
1912996 | 1912996 | 2021-11-13 | Adair | Oklahoma | 40001 | 4932 | 62 |
1909746 | 1909746 | 2021-11-12 | Adair | Oklahoma | 40001 | 4932 | 62 |
1906497 | 1906497 | 2021-11-11 | Adair | Oklahoma | 40001 | 4932 | 62 |
1903248 | 1903248 | 2021-11-10 | Adair | Oklahoma | 40001 | 4932 | 62 |
1899998 | 1899998 | 2021-11-09 | Adair | Oklahoma | 40001 | 4901 | 62 |
1896748 | 1896748 | 2021-11-08 | Adair | Oklahoma | 40001 | 4901 | 62 |
1893498 | 1893498 | 2021-11-07 | Adair | Oklahoma | 40001 | 4901 | 62 |
1890248 | 1890248 | 2021-11-06 | Adair | Oklahoma | 40001 | 4901 | 62 |
1886998 | 1886998 | 2021-11-05 | Adair | Oklahoma | 40001 | 4901 | 62 |
1883748 | 1883748 | 2021-11-04 | Adair | Oklahoma | 40001 | 4901 | 62 |
1880499 | 1880499 | 2021-11-03 | Adair | Oklahoma | 40001 | 4901 | 62 |
1877250 | 1877250 | 2021-11-02 | Adair | Oklahoma | 40001 | 4878 | 61 |
1874001 | 1874001 | 2021-11-01 | Adair | Oklahoma | 40001 | 4878 | 61 |
1870752 | 1870752 | 2021-10-31 | Adair | Oklahoma | 40001 | 4878 | 61 |
1867503 | 1867503 | 2021-10-30 | Adair | Oklahoma | 40001 | 4878 | 61 |
1864254 | 1864254 | 2021-10-29 | Adair | Oklahoma | 40001 | 4878 | 61 |
1861005 | 1861005 | 2021-10-28 | Adair | Oklahoma | 40001 | 4878 | 61 |
1857756 | 1857756 | 2021-10-27 | Adair | Oklahoma | 40001 | 4878 | 61 |
1854507 | 1854507 | 2021-10-26 | Adair | Oklahoma | 40001 | 4850 | 61 |
1851258 | 1851258 | 2021-10-25 | Adair | Oklahoma | 40001 | 4850 | 61 |
1848008 | 1848008 | 2021-10-24 | Adair | Oklahoma | 40001 | 4850 | 61 |
1844758 | 1844758 | 2021-10-23 | Adair | Oklahoma | 40001 | 4850 | 61 |
1841508 | 1841508 | 2021-10-22 | Adair | Oklahoma | 40001 | 4850 | 61 |
1838259 | 1838259 | 2021-10-21 | Adair | Oklahoma | 40001 | 4850 | 61 |
1835010 | 1835010 | 2021-10-20 | Adair | Oklahoma | 40001 | 4850 | 61 |
1831761 | 1831761 | 2021-10-19 | Adair | Oklahoma | 40001 | 4818 | 57 |
1828512 | 1828512 | 2021-10-18 | Adair | Oklahoma | 40001 | 4818 | 57 |
1825263 | 1825263 | 2021-10-17 | Adair | Oklahoma | 40001 | 4818 | 57 |
1822014 | 1822014 | 2021-10-16 | Adair | Oklahoma | 40001 | 4818 | 57 |
1818765 | 1818765 | 2021-10-15 | Adair | Oklahoma | 40001 | 4818 | 57 |
1815516 | 1815516 | 2021-10-14 | Adair | Oklahoma | 40001 | 4818 | 57 |
1812268 | 1812268 | 2021-10-13 | Adair | Oklahoma | 40001 | 4818 | 57 |
1809019 | 1809019 | 2021-10-12 | Adair | Oklahoma | 40001 | 4783 | 56 |
1805769 | 1805769 | 2021-10-11 | Adair | Oklahoma | 40001 | 4783 | 56 |
1802519 | 1802519 | 2021-10-10 | Adair | Oklahoma | 40001 | 4783 | 56 |
1799270 | 1799270 | 2021-10-09 | Adair | Oklahoma | 40001 | 4783 | 56 |
1796021 | 1796021 | 2021-10-08 | Adair | Oklahoma | 40001 | 4783 | 56 |
1792772 | 1792772 | 2021-10-07 | Adair | Oklahoma | 40001 | 4783 | 56 |
1789523 | 1789523 | 2021-10-06 | Adair | Oklahoma | 40001 | 4783 | 56 |
1786275 | 1786275 | 2021-10-05 | Adair | Oklahoma | 40001 | 4729 | 55 |
1783026 | 1783026 | 2021-10-04 | Adair | Oklahoma | 40001 | 4729 | 55 |
1779777 | 1779777 | 2021-10-03 | Adair | Oklahoma | 40001 | 4729 | 55 |
1776527 | 1776527 | 2021-10-02 | Adair | Oklahoma | 40001 | 4729 | 55 |
1773277 | 1773277 | 2021-10-01 | Adair | Oklahoma | 40001 | 4729 | 55 |
1770027 | 1770027 | 2021-09-30 | Adair | Oklahoma | 40001 | 4729 | 55 |
1766778 | 1766778 | 2021-09-29 | Adair | Oklahoma | 40001 | 4729 | 55 |
1763529 | 1763529 | 2021-09-28 | Adair | Oklahoma | 40001 | 4690 | 55 |
1760280 | 1760280 | 2021-09-27 | Adair | Oklahoma | 40001 | 4690 | 55 |
1757032 | 1757032 | 2021-09-26 | Adair | Oklahoma | 40001 | 4690 | 55 |
1753784 | 1753784 | 2021-09-25 | Adair | Oklahoma | 40001 | 4690 | 55 |
1750536 | 1750536 | 2021-09-24 | Adair | Oklahoma | 40001 | 4690 | 55 |
1747286 | 1747286 | 2021-09-23 | Adair | Oklahoma | 40001 | 4690 | 55 |
1744037 | 1744037 | 2021-09-22 | Adair | Oklahoma | 40001 | 4690 | 55 |
1740788 | 1740788 | 2021-09-21 | Adair | Oklahoma | 40001 | 4601 | 53 |
1737539 | 1737539 | 2021-09-20 | Adair | Oklahoma | 40001 | 4601 | 53 |
1734289 | 1734289 | 2021-09-19 | Adair | Oklahoma | 40001 | 4601 | 53 |
1731039 | 1731039 | 2021-09-18 | Adair | Oklahoma | 40001 | 4601 | 53 |
1727789 | 1727789 | 2021-09-17 | Adair | Oklahoma | 40001 | 4601 | 53 |
1724540 | 1724540 | 2021-09-16 | Adair | Oklahoma | 40001 | 4601 | 53 |
1721291 | 1721291 | 2021-09-15 | Adair | Oklahoma | 40001 | 4601 | 53 |
1718043 | 1718043 | 2021-09-14 | Adair | Oklahoma | 40001 | 4490 | 53 |
1714795 | 1714795 | 2021-09-13 | Adair | Oklahoma | 40001 | 4490 | 53 |
1711549 | 1711549 | 2021-09-12 | Adair | Oklahoma | 40001 | 4490 | 53 |
1708302 | 1708302 | 2021-09-11 | Adair | Oklahoma | 40001 | 4490 | 53 |
1705055 | 1705055 | 2021-09-10 | Adair | Oklahoma | 40001 | 4490 | 53 |
1701805 | 1701805 | 2021-09-09 | Adair | Oklahoma | 40001 | 4490 | 53 |
1698556 | 1698556 | 2021-09-08 | Adair | Oklahoma | 40001 | 4490 | 53 |
1695308 | 1695308 | 2021-09-07 | Adair | Oklahoma | 40001 | 4310 | 52 |
1692060 | 1692060 | 2021-09-06 | Adair | Oklahoma | 40001 | 4310 | 52 |
1688811 | 1688811 | 2021-09-05 | Adair | Oklahoma | 40001 | 4310 | 52 |
1685561 | 1685561 | 2021-09-04 | Adair | Oklahoma | 40001 | 4310 | 52 |
1682310 | 1682310 | 2021-09-03 | Adair | Oklahoma | 40001 | 4310 | 52 |
1679060 | 1679060 | 2021-09-02 | Adair | Oklahoma | 40001 | 4310 | 52 |
1675812 | 1675812 | 2021-09-01 | Adair | Oklahoma | 40001 | 4310 | 52 |
1672565 | 1672565 | 2021-08-31 | Adair | Oklahoma | 40001 | 4131 | 48 |
1669317 | 1669317 | 2021-08-30 | Adair | Oklahoma | 40001 | 4131 | 48 |
1666070 | 1666070 | 2021-08-29 | Adair | Oklahoma | 40001 | 4131 | 48 |
1662822 | 1662822 | 2021-08-28 | Adair | Oklahoma | 40001 | 4131 | 48 |
1659574 | 1659574 | 2021-08-27 | Adair | Oklahoma | 40001 | 4131 | 48 |
1656325 | 1656325 | 2021-08-26 | Adair | Oklahoma | 40001 | 4131 | 48 |
1653078 | 1653078 | 2021-08-25 | Adair | Oklahoma | 40001 | 4131 | 48 |
1649831 | 1649831 | 2021-08-24 | Adair | Oklahoma | 40001 | 3931 | 47 |
1646582 | 1646582 | 2021-08-23 | Adair | Oklahoma | 40001 | 3931 | 47 |
1643333 | 1643333 | 2021-08-22 | Adair | Oklahoma | 40001 | 3931 | 47 |
1640083 | 1640083 | 2021-08-21 | Adair | Oklahoma | 40001 | 3931 | 47 |
1636833 | 1636833 | 2021-08-20 | Adair | Oklahoma | 40001 | 3931 | 47 |
1633583 | 1633583 | 2021-08-19 | Adair | Oklahoma | 40001 | 3931 | 47 |
1630336 | 1630336 | 2021-08-18 | Adair | Oklahoma | 40001 | 3931 | 47 |
1627089 | 1627089 | 2021-08-17 | Adair | Oklahoma | 40001 | 3776 | 46 |
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);