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 |
---|---|---|---|---|---|---|---|
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 |
1623850 | 1623850 | 2021-08-16 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1620603 | 1620603 | 2021-08-15 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1617355 | 1617355 | 2021-08-14 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1614107 | 1614107 | 2021-08-13 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1610858 | 1610858 | 2021-08-12 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1607610 | 1607610 | 2021-08-11 | Canadian | Oklahoma | 40017 | 18582 | 193 |
1604361 | 1604361 | 2021-08-10 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1601112 | 1601112 | 2021-08-09 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1597864 | 1597864 | 2021-08-08 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1594615 | 1594615 | 2021-08-07 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1591366 | 1591366 | 2021-08-06 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1588117 | 1588117 | 2021-08-05 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1584867 | 1584867 | 2021-08-04 | Canadian | Oklahoma | 40017 | 18115 | 193 |
1581617 | 1581617 | 2021-08-03 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1578368 | 1578368 | 2021-08-02 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1575120 | 1575120 | 2021-08-01 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1571872 | 1571872 | 2021-07-31 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1568624 | 1568624 | 2021-07-30 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1565376 | 1565376 | 2021-07-29 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1562128 | 1562128 | 2021-07-28 | Canadian | Oklahoma | 40017 | 17762 | 191 |
1558880 | 1558880 | 2021-07-27 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1555633 | 1555633 | 2021-07-26 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1552386 | 1552386 | 2021-07-25 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1549139 | 1549139 | 2021-07-24 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1545892 | 1545892 | 2021-07-23 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1542645 | 1542645 | 2021-07-22 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1539397 | 1539397 | 2021-07-21 | Canadian | Oklahoma | 40017 | 17627 | 190 |
1536150 | 1536150 | 2021-07-20 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1532902 | 1532902 | 2021-07-19 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1529655 | 1529655 | 2021-07-18 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1526408 | 1526408 | 2021-07-17 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1523161 | 1523161 | 2021-07-16 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1519913 | 1519913 | 2021-07-15 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1516665 | 1516665 | 2021-07-14 | Canadian | Oklahoma | 40017 | 17530 | 190 |
1513418 | 1513418 | 2021-07-13 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1510172 | 1510172 | 2021-07-12 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1506925 | 1506925 | 2021-07-11 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1503679 | 1503679 | 2021-07-10 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1500433 | 1500433 | 2021-07-09 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1497187 | 1497187 | 2021-07-08 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1493940 | 1493940 | 2021-07-07 | Canadian | Oklahoma | 40017 | 17478 | 188 |
1490693 | 1490693 | 2021-07-06 | Canadian | Oklahoma | 40017 | 17461 | 187 |
1487446 | 1487446 | 2021-07-05 | Canadian | Oklahoma | 40017 | 17461 | 187 |
1484199 | 1484199 | 2021-07-04 | Canadian | Oklahoma | 40017 | 17461 | 187 |
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);