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 |
---|---|---|---|---|---|---|---|
1948768 | 1948768 | 2021-11-24 | Delaware | Oklahoma | 40041 | 7601 | 161 |
1945517 | 1945517 | 2021-11-23 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1942266 | 1942266 | 2021-11-22 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1939016 | 1939016 | 2021-11-21 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1935766 | 1935766 | 2021-11-20 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1932516 | 1932516 | 2021-11-19 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1929265 | 1929265 | 2021-11-18 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1926015 | 1926015 | 2021-11-17 | Delaware | Oklahoma | 40041 | 7523 | 161 |
1922765 | 1922765 | 2021-11-16 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1919516 | 1919516 | 2021-11-15 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1916266 | 1916266 | 2021-11-14 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1913016 | 1913016 | 2021-11-13 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1909766 | 1909766 | 2021-11-12 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1906517 | 1906517 | 2021-11-11 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1903268 | 1903268 | 2021-11-10 | Delaware | Oklahoma | 40041 | 7445 | 161 |
1900018 | 1900018 | 2021-11-09 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1896768 | 1896768 | 2021-11-08 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1893518 | 1893518 | 2021-11-07 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1890268 | 1890268 | 2021-11-06 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1887018 | 1887018 | 2021-11-05 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1883768 | 1883768 | 2021-11-04 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1880519 | 1880519 | 2021-11-03 | Delaware | Oklahoma | 40041 | 7368 | 161 |
1877270 | 1877270 | 2021-11-02 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1874021 | 1874021 | 2021-11-01 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1870772 | 1870772 | 2021-10-31 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1867523 | 1867523 | 2021-10-30 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1864274 | 1864274 | 2021-10-29 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1861025 | 1861025 | 2021-10-28 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1857776 | 1857776 | 2021-10-27 | Delaware | Oklahoma | 40041 | 7327 | 160 |
1854527 | 1854527 | 2021-10-26 | Delaware | Oklahoma | 40041 | 7274 | 159 |
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 |
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);