ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Canadian" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948756 | 1948756 | 2021-11-24 | Canadian | Oklahoma | 40017 | 23915 | 295 |
1945505 | 1945505 | 2021-11-23 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1942254 | 1942254 | 2021-11-22 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1939004 | 1939004 | 2021-11-21 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1935754 | 1935754 | 2021-11-20 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1932504 | 1932504 | 2021-11-19 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1929253 | 1929253 | 2021-11-18 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1926003 | 1926003 | 2021-11-17 | Canadian | Oklahoma | 40017 | 23744 | 295 |
1922753 | 1922753 | 2021-11-16 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1919504 | 1919504 | 2021-11-15 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1916254 | 1916254 | 2021-11-14 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1913004 | 1913004 | 2021-11-13 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1909754 | 1909754 | 2021-11-12 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1906505 | 1906505 | 2021-11-11 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1903256 | 1903256 | 2021-11-10 | Canadian | Oklahoma | 40017 | 23538 | 295 |
1900006 | 1900006 | 2021-11-09 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1896756 | 1896756 | 2021-11-08 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1893506 | 1893506 | 2021-11-07 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1890256 | 1890256 | 2021-11-06 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1887006 | 1887006 | 2021-11-05 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1883756 | 1883756 | 2021-11-04 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1880507 | 1880507 | 2021-11-03 | Canadian | Oklahoma | 40017 | 23345 | 295 |
1877258 | 1877258 | 2021-11-02 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1874009 | 1874009 | 2021-11-01 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1870760 | 1870760 | 2021-10-31 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1867511 | 1867511 | 2021-10-30 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1864262 | 1864262 | 2021-10-29 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1861013 | 1861013 | 2021-10-28 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1857764 | 1857764 | 2021-10-27 | Canadian | Oklahoma | 40017 | 23177 | 288 |
1854515 | 1854515 | 2021-10-26 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1851266 | 1851266 | 2021-10-25 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1848016 | 1848016 | 2021-10-24 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1844766 | 1844766 | 2021-10-23 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1841516 | 1841516 | 2021-10-22 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1838267 | 1838267 | 2021-10-21 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1835018 | 1835018 | 2021-10-20 | Canadian | Oklahoma | 40017 | 22956 | 280 |
1831769 | 1831769 | 2021-10-19 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1828520 | 1828520 | 2021-10-18 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1825271 | 1825271 | 2021-10-17 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1822022 | 1822022 | 2021-10-16 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1818773 | 1818773 | 2021-10-15 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1815524 | 1815524 | 2021-10-14 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1812276 | 1812276 | 2021-10-13 | Canadian | Oklahoma | 40017 | 22572 | 238 |
1809027 | 1809027 | 2021-10-12 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1805777 | 1805777 | 2021-10-11 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1802527 | 1802527 | 2021-10-10 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1799278 | 1799278 | 2021-10-09 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1796029 | 1796029 | 2021-10-08 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1792780 | 1792780 | 2021-10-07 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1789531 | 1789531 | 2021-10-06 | Canadian | Oklahoma | 40017 | 22226 | 231 |
1786283 | 1786283 | 2021-10-05 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1783034 | 1783034 | 2021-10-04 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1779785 | 1779785 | 2021-10-03 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1776535 | 1776535 | 2021-10-02 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1773285 | 1773285 | 2021-10-01 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1770035 | 1770035 | 2021-09-30 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1766786 | 1766786 | 2021-09-29 | Canadian | Oklahoma | 40017 | 21936 | 224 |
1763537 | 1763537 | 2021-09-28 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1760288 | 1760288 | 2021-09-27 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1757040 | 1757040 | 2021-09-26 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1753792 | 1753792 | 2021-09-25 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1750544 | 1750544 | 2021-09-24 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1747294 | 1747294 | 2021-09-23 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1744045 | 1744045 | 2021-09-22 | Canadian | Oklahoma | 40017 | 21595 | 214 |
1740796 | 1740796 | 2021-09-21 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1737547 | 1737547 | 2021-09-20 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1734297 | 1734297 | 2021-09-19 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1731047 | 1731047 | 2021-09-18 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1727797 | 1727797 | 2021-09-17 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1724548 | 1724548 | 2021-09-16 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1721299 | 1721299 | 2021-09-15 | Canadian | Oklahoma | 40017 | 21209 | 208 |
1718051 | 1718051 | 2021-09-14 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1714803 | 1714803 | 2021-09-13 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1711557 | 1711557 | 2021-09-12 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1708310 | 1708310 | 2021-09-11 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1705063 | 1705063 | 2021-09-10 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1701813 | 1701813 | 2021-09-09 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1698564 | 1698564 | 2021-09-08 | Canadian | Oklahoma | 40017 | 20768 | 203 |
1695316 | 1695316 | 2021-09-07 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1692068 | 1692068 | 2021-09-06 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1688819 | 1688819 | 2021-09-05 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1685569 | 1685569 | 2021-09-04 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1682318 | 1682318 | 2021-09-03 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1679068 | 1679068 | 2021-09-02 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1675820 | 1675820 | 2021-09-01 | Canadian | Oklahoma | 40017 | 20204 | 201 |
1672573 | 1672573 | 2021-08-31 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1669325 | 1669325 | 2021-08-30 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1666078 | 1666078 | 2021-08-29 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1662830 | 1662830 | 2021-08-28 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1659582 | 1659582 | 2021-08-27 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1656333 | 1656333 | 2021-08-26 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1653086 | 1653086 | 2021-08-25 | Canadian | Oklahoma | 40017 | 19664 | 198 |
1649839 | 1649839 | 2021-08-24 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1646590 | 1646590 | 2021-08-23 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1643341 | 1643341 | 2021-08-22 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1640091 | 1640091 | 2021-08-21 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1636841 | 1636841 | 2021-08-20 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1633591 | 1633591 | 2021-08-19 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1630344 | 1630344 | 2021-08-18 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1627097 | 1627097 | 2021-08-17 | Canadian | Oklahoma | 40017 | 18582 | 193 |
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);