ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Custer" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948767 | 1948767 | 2021-11-24 | Custer | Oklahoma | 40039 | 5284 | 129 |
1945516 | 1945516 | 2021-11-23 | Custer | Oklahoma | 40039 | 5173 | 129 |
1942265 | 1942265 | 2021-11-22 | Custer | Oklahoma | 40039 | 5173 | 129 |
1939015 | 1939015 | 2021-11-21 | Custer | Oklahoma | 40039 | 5173 | 129 |
1935765 | 1935765 | 2021-11-20 | Custer | Oklahoma | 40039 | 5173 | 129 |
1932515 | 1932515 | 2021-11-19 | Custer | Oklahoma | 40039 | 5173 | 129 |
1929264 | 1929264 | 2021-11-18 | Custer | Oklahoma | 40039 | 5173 | 129 |
1926014 | 1926014 | 2021-11-17 | Custer | Oklahoma | 40039 | 5173 | 129 |
1922764 | 1922764 | 2021-11-16 | Custer | Oklahoma | 40039 | 5119 | 129 |
1919515 | 1919515 | 2021-11-15 | Custer | Oklahoma | 40039 | 5119 | 129 |
1916265 | 1916265 | 2021-11-14 | Custer | Oklahoma | 40039 | 5119 | 129 |
1913015 | 1913015 | 2021-11-13 | Custer | Oklahoma | 40039 | 5119 | 129 |
1909765 | 1909765 | 2021-11-12 | Custer | Oklahoma | 40039 | 5119 | 129 |
1906516 | 1906516 | 2021-11-11 | Custer | Oklahoma | 40039 | 5119 | 129 |
1903267 | 1903267 | 2021-11-10 | Custer | Oklahoma | 40039 | 5119 | 129 |
1900017 | 1900017 | 2021-11-09 | Custer | Oklahoma | 40039 | 5075 | 129 |
1896767 | 1896767 | 2021-11-08 | Custer | Oklahoma | 40039 | 5075 | 129 |
1893517 | 1893517 | 2021-11-07 | Custer | Oklahoma | 40039 | 5075 | 129 |
1890267 | 1890267 | 2021-11-06 | Custer | Oklahoma | 40039 | 5075 | 129 |
1887017 | 1887017 | 2021-11-05 | Custer | Oklahoma | 40039 | 5075 | 129 |
1883767 | 1883767 | 2021-11-04 | Custer | Oklahoma | 40039 | 5075 | 129 |
1880518 | 1880518 | 2021-11-03 | Custer | Oklahoma | 40039 | 5075 | 129 |
1877269 | 1877269 | 2021-11-02 | Custer | Oklahoma | 40039 | 5026 | 128 |
1874020 | 1874020 | 2021-11-01 | Custer | Oklahoma | 40039 | 5026 | 128 |
1870771 | 1870771 | 2021-10-31 | Custer | Oklahoma | 40039 | 5026 | 128 |
1867522 | 1867522 | 2021-10-30 | Custer | Oklahoma | 40039 | 5026 | 128 |
1864273 | 1864273 | 2021-10-29 | Custer | Oklahoma | 40039 | 5026 | 128 |
1861024 | 1861024 | 2021-10-28 | Custer | Oklahoma | 40039 | 5026 | 128 |
1857775 | 1857775 | 2021-10-27 | Custer | Oklahoma | 40039 | 5026 | 128 |
1854526 | 1854526 | 2021-10-26 | Custer | Oklahoma | 40039 | 4978 | 128 |
1851277 | 1851277 | 2021-10-25 | Custer | Oklahoma | 40039 | 4978 | 128 |
1848027 | 1848027 | 2021-10-24 | Custer | Oklahoma | 40039 | 4978 | 128 |
1844777 | 1844777 | 2021-10-23 | Custer | Oklahoma | 40039 | 4978 | 128 |
1841527 | 1841527 | 2021-10-22 | Custer | Oklahoma | 40039 | 4978 | 128 |
1838278 | 1838278 | 2021-10-21 | Custer | Oklahoma | 40039 | 4978 | 128 |
1835029 | 1835029 | 2021-10-20 | Custer | Oklahoma | 40039 | 4978 | 128 |
1831780 | 1831780 | 2021-10-19 | Custer | Oklahoma | 40039 | 4902 | 115 |
1828531 | 1828531 | 2021-10-18 | Custer | Oklahoma | 40039 | 4902 | 115 |
1825282 | 1825282 | 2021-10-17 | Custer | Oklahoma | 40039 | 4902 | 115 |
1822033 | 1822033 | 2021-10-16 | Custer | Oklahoma | 40039 | 4902 | 115 |
1818784 | 1818784 | 2021-10-15 | Custer | Oklahoma | 40039 | 4902 | 115 |
1815535 | 1815535 | 2021-10-14 | Custer | Oklahoma | 40039 | 4902 | 115 |
1812287 | 1812287 | 2021-10-13 | Custer | Oklahoma | 40039 | 4902 | 115 |
1809038 | 1809038 | 2021-10-12 | Custer | Oklahoma | 40039 | 4820 | 112 |
1805788 | 1805788 | 2021-10-11 | Custer | Oklahoma | 40039 | 4820 | 112 |
1802538 | 1802538 | 2021-10-10 | Custer | Oklahoma | 40039 | 4820 | 112 |
1799289 | 1799289 | 2021-10-09 | Custer | Oklahoma | 40039 | 4820 | 112 |
1796040 | 1796040 | 2021-10-08 | Custer | Oklahoma | 40039 | 4820 | 112 |
1792791 | 1792791 | 2021-10-07 | Custer | Oklahoma | 40039 | 4820 | 112 |
1789542 | 1789542 | 2021-10-06 | Custer | Oklahoma | 40039 | 4820 | 112 |
1786294 | 1786294 | 2021-10-05 | Custer | Oklahoma | 40039 | 4742 | 111 |
1783045 | 1783045 | 2021-10-04 | Custer | Oklahoma | 40039 | 4742 | 111 |
1779796 | 1779796 | 2021-10-03 | Custer | Oklahoma | 40039 | 4742 | 111 |
1776546 | 1776546 | 2021-10-02 | Custer | Oklahoma | 40039 | 4742 | 111 |
1773296 | 1773296 | 2021-10-01 | Custer | Oklahoma | 40039 | 4742 | 111 |
1770046 | 1770046 | 2021-09-30 | Custer | Oklahoma | 40039 | 4742 | 111 |
1766797 | 1766797 | 2021-09-29 | Custer | Oklahoma | 40039 | 4742 | 111 |
1763548 | 1763548 | 2021-09-28 | Custer | Oklahoma | 40039 | 4696 | 110 |
1760299 | 1760299 | 2021-09-27 | Custer | Oklahoma | 40039 | 4696 | 110 |
1757051 | 1757051 | 2021-09-26 | Custer | Oklahoma | 40039 | 4696 | 110 |
1753803 | 1753803 | 2021-09-25 | Custer | Oklahoma | 40039 | 4696 | 110 |
1750555 | 1750555 | 2021-09-24 | Custer | Oklahoma | 40039 | 4696 | 110 |
1747305 | 1747305 | 2021-09-23 | Custer | Oklahoma | 40039 | 4696 | 110 |
1744056 | 1744056 | 2021-09-22 | Custer | Oklahoma | 40039 | 4696 | 110 |
1740807 | 1740807 | 2021-09-21 | Custer | Oklahoma | 40039 | 4639 | 107 |
1737558 | 1737558 | 2021-09-20 | Custer | Oklahoma | 40039 | 4639 | 107 |
1734308 | 1734308 | 2021-09-19 | Custer | Oklahoma | 40039 | 4639 | 107 |
1731058 | 1731058 | 2021-09-18 | Custer | Oklahoma | 40039 | 4639 | 107 |
1727808 | 1727808 | 2021-09-17 | Custer | Oklahoma | 40039 | 4639 | 107 |
1724559 | 1724559 | 2021-09-16 | Custer | Oklahoma | 40039 | 4639 | 107 |
1721310 | 1721310 | 2021-09-15 | Custer | Oklahoma | 40039 | 4639 | 107 |
1718062 | 1718062 | 2021-09-14 | Custer | Oklahoma | 40039 | 4557 | 106 |
1714814 | 1714814 | 2021-09-13 | Custer | Oklahoma | 40039 | 4557 | 106 |
1711568 | 1711568 | 2021-09-12 | Custer | Oklahoma | 40039 | 4557 | 106 |
1708321 | 1708321 | 2021-09-11 | Custer | Oklahoma | 40039 | 4557 | 106 |
1705074 | 1705074 | 2021-09-10 | Custer | Oklahoma | 40039 | 4557 | 106 |
1701824 | 1701824 | 2021-09-09 | Custer | Oklahoma | 40039 | 4557 | 106 |
1698575 | 1698575 | 2021-09-08 | Custer | Oklahoma | 40039 | 4557 | 106 |
1695327 | 1695327 | 2021-09-07 | Custer | Oklahoma | 40039 | 4471 | 106 |
1692079 | 1692079 | 2021-09-06 | Custer | Oklahoma | 40039 | 4471 | 106 |
1688830 | 1688830 | 2021-09-05 | Custer | Oklahoma | 40039 | 4471 | 106 |
1685580 | 1685580 | 2021-09-04 | Custer | Oklahoma | 40039 | 4471 | 106 |
1682329 | 1682329 | 2021-09-03 | Custer | Oklahoma | 40039 | 4471 | 106 |
1679079 | 1679079 | 2021-09-02 | Custer | Oklahoma | 40039 | 4471 | 106 |
1675831 | 1675831 | 2021-09-01 | Custer | Oklahoma | 40039 | 4471 | 106 |
1672584 | 1672584 | 2021-08-31 | Custer | Oklahoma | 40039 | 4392 | 106 |
1669336 | 1669336 | 2021-08-30 | Custer | Oklahoma | 40039 | 4392 | 106 |
1666089 | 1666089 | 2021-08-29 | Custer | Oklahoma | 40039 | 4392 | 106 |
1662841 | 1662841 | 2021-08-28 | Custer | Oklahoma | 40039 | 4392 | 106 |
1659593 | 1659593 | 2021-08-27 | Custer | Oklahoma | 40039 | 4392 | 106 |
1656344 | 1656344 | 2021-08-26 | Custer | Oklahoma | 40039 | 4392 | 106 |
1653097 | 1653097 | 2021-08-25 | Custer | Oklahoma | 40039 | 4392 | 106 |
1649850 | 1649850 | 2021-08-24 | Custer | Oklahoma | 40039 | 4329 | 106 |
1646601 | 1646601 | 2021-08-23 | Custer | Oklahoma | 40039 | 4329 | 106 |
1643352 | 1643352 | 2021-08-22 | Custer | Oklahoma | 40039 | 4329 | 106 |
1640102 | 1640102 | 2021-08-21 | Custer | Oklahoma | 40039 | 4329 | 106 |
1636852 | 1636852 | 2021-08-20 | Custer | Oklahoma | 40039 | 4329 | 106 |
1633602 | 1633602 | 2021-08-19 | Custer | Oklahoma | 40039 | 4329 | 106 |
1630355 | 1630355 | 2021-08-18 | Custer | Oklahoma | 40039 | 4329 | 106 |
1627108 | 1627108 | 2021-08-17 | Custer | Oklahoma | 40039 | 4257 | 106 |
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);