ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40041 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1851278 | 1851278 | 2021-10-25 | Delaware | Oklahoma | 40041 | 7274 | 159 |
1848028 | 1848028 | 2021-10-24 | Delaware | Oklahoma | 40041 | 7274 | 159 |
1844778 | 1844778 | 2021-10-23 | Delaware | Oklahoma | 40041 | 7274 | 159 |
1841528 | 1841528 | 2021-10-22 | Delaware | Oklahoma | 40041 | 7274 | 159 |
1838279 | 1838279 | 2021-10-21 | Delaware | Oklahoma | 40041 | 7274 | 159 |
1835030 | 1835030 | 2021-10-20 | Delaware | Oklahoma | 40041 | 7274 | 159 |
1831781 | 1831781 | 2021-10-19 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1828532 | 1828532 | 2021-10-18 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1825283 | 1825283 | 2021-10-17 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1822034 | 1822034 | 2021-10-16 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1818785 | 1818785 | 2021-10-15 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1815536 | 1815536 | 2021-10-14 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1812288 | 1812288 | 2021-10-13 | Delaware | Oklahoma | 40041 | 7180 | 139 |
1809039 | 1809039 | 2021-10-12 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1805789 | 1805789 | 2021-10-11 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1802539 | 1802539 | 2021-10-10 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1799290 | 1799290 | 2021-10-09 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1796041 | 1796041 | 2021-10-08 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1792792 | 1792792 | 2021-10-07 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1789543 | 1789543 | 2021-10-06 | Delaware | Oklahoma | 40041 | 7107 | 135 |
1786295 | 1786295 | 2021-10-05 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1783046 | 1783046 | 2021-10-04 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1779797 | 1779797 | 2021-10-03 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1776547 | 1776547 | 2021-10-02 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1773297 | 1773297 | 2021-10-01 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1770047 | 1770047 | 2021-09-30 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1766798 | 1766798 | 2021-09-29 | Delaware | Oklahoma | 40041 | 7008 | 126 |
1763549 | 1763549 | 2021-09-28 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1760300 | 1760300 | 2021-09-27 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1757052 | 1757052 | 2021-09-26 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1753804 | 1753804 | 2021-09-25 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1750556 | 1750556 | 2021-09-24 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1747306 | 1747306 | 2021-09-23 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1744057 | 1744057 | 2021-09-22 | Delaware | Oklahoma | 40041 | 6881 | 125 |
1740808 | 1740808 | 2021-09-21 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1737559 | 1737559 | 2021-09-20 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1734309 | 1734309 | 2021-09-19 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1731059 | 1731059 | 2021-09-18 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1727809 | 1727809 | 2021-09-17 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1724560 | 1724560 | 2021-09-16 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1721311 | 1721311 | 2021-09-15 | Delaware | Oklahoma | 40041 | 6729 | 117 |
1718063 | 1718063 | 2021-09-14 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1714815 | 1714815 | 2021-09-13 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1711569 | 1711569 | 2021-09-12 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1708322 | 1708322 | 2021-09-11 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1705075 | 1705075 | 2021-09-10 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1701825 | 1701825 | 2021-09-09 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1698576 | 1698576 | 2021-09-08 | Delaware | Oklahoma | 40041 | 6517 | 114 |
1695328 | 1695328 | 2021-09-07 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1692080 | 1692080 | 2021-09-06 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1688831 | 1688831 | 2021-09-05 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1685581 | 1685581 | 2021-09-04 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1682330 | 1682330 | 2021-09-03 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1679080 | 1679080 | 2021-09-02 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1675832 | 1675832 | 2021-09-01 | Delaware | Oklahoma | 40041 | 6273 | 111 |
1672585 | 1672585 | 2021-08-31 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1669337 | 1669337 | 2021-08-30 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1666090 | 1666090 | 2021-08-29 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1662842 | 1662842 | 2021-08-28 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1659594 | 1659594 | 2021-08-27 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1656345 | 1656345 | 2021-08-26 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1653098 | 1653098 | 2021-08-25 | Delaware | Oklahoma | 40041 | 6083 | 106 |
1649851 | 1649851 | 2021-08-24 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1646602 | 1646602 | 2021-08-23 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1643353 | 1643353 | 2021-08-22 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1640103 | 1640103 | 2021-08-21 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1636853 | 1636853 | 2021-08-20 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1633603 | 1633603 | 2021-08-19 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1630356 | 1630356 | 2021-08-18 | Delaware | Oklahoma | 40041 | 5890 | 103 |
1627109 | 1627109 | 2021-08-17 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1623862 | 1623862 | 2021-08-16 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1620615 | 1620615 | 2021-08-15 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1617367 | 1617367 | 2021-08-14 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1614119 | 1614119 | 2021-08-13 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1610870 | 1610870 | 2021-08-12 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1607622 | 1607622 | 2021-08-11 | Delaware | Oklahoma | 40041 | 5661 | 103 |
1604373 | 1604373 | 2021-08-10 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1601124 | 1601124 | 2021-08-09 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1597876 | 1597876 | 2021-08-08 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1594627 | 1594627 | 2021-08-07 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1591378 | 1591378 | 2021-08-06 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1588129 | 1588129 | 2021-08-05 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1584879 | 1584879 | 2021-08-04 | Delaware | Oklahoma | 40041 | 5406 | 102 |
1581629 | 1581629 | 2021-08-03 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1578380 | 1578380 | 2021-08-02 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1575132 | 1575132 | 2021-08-01 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1571884 | 1571884 | 2021-07-31 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1568636 | 1568636 | 2021-07-30 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1565388 | 1565388 | 2021-07-29 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1562140 | 1562140 | 2021-07-28 | Delaware | Oklahoma | 40041 | 5252 | 100 |
1558892 | 1558892 | 2021-07-27 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1555645 | 1555645 | 2021-07-26 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1552398 | 1552398 | 2021-07-25 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1549151 | 1549151 | 2021-07-24 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1545904 | 1545904 | 2021-07-23 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1542657 | 1542657 | 2021-07-22 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1539409 | 1539409 | 2021-07-21 | Delaware | Oklahoma | 40041 | 5118 | 99 |
1536162 | 1536162 | 2021-07-20 | Delaware | Oklahoma | 40041 | 4974 | 98 |
1532914 | 1532914 | 2021-07-19 | Delaware | Oklahoma | 40041 | 4974 | 98 |
1529667 | 1529667 | 2021-07-18 | Delaware | Oklahoma | 40041 | 4974 | 98 |
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);