ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where deaths = 117 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 10
state 1
- Oklahoma · 97 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2218680 | 2218680 | 2022-02-15 | McClain | Oklahoma | 40087 | 11297 | 117 |
2215429 | 2215429 | 2022-02-14 | McClain | Oklahoma | 40087 | 11297 | 117 |
2212178 | 2212178 | 2022-02-13 | McClain | Oklahoma | 40087 | 11297 | 117 |
2208925 | 2208925 | 2022-02-12 | McClain | Oklahoma | 40087 | 11297 | 117 |
2205672 | 2205672 | 2022-02-11 | McClain | Oklahoma | 40087 | 11297 | 117 |
2202419 | 2202419 | 2022-02-10 | McClain | Oklahoma | 40087 | 11297 | 117 |
2199165 | 2199165 | 2022-02-09 | McClain | Oklahoma | 40087 | 11297 | 117 |
2036555 | 2036555 | 2021-12-21 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2033305 | 2033305 | 2021-12-20 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2030055 | 2030055 | 2021-12-19 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2026804 | 2026804 | 2021-12-18 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2023553 | 2023553 | 2021-12-17 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2020302 | 2020302 | 2021-12-16 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2017051 | 2017051 | 2021-12-15 | Lincoln | Oklahoma | 40081 | 5164 | 117 |
2013801 | 2013801 | 2021-12-14 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2010550 | 2010550 | 2021-12-13 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2007299 | 2007299 | 2021-12-12 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2004048 | 2004048 | 2021-12-11 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
2000797 | 2000797 | 2021-12-10 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1997547 | 1997547 | 2021-12-09 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1994296 | 1994296 | 2021-12-08 | Lincoln | Oklahoma | 40081 | 5120 | 117 |
1974813 | 1974813 | 2021-12-02 | Payne | Oklahoma | 40119 | 12300 | 117 |
1971564 | 1971564 | 2021-12-01 | Payne | Oklahoma | 40119 | 12300 | 117 |
1968314 | 1968314 | 2021-11-30 | Payne | Oklahoma | 40119 | 12252 | 117 |
1965063 | 1965063 | 2021-11-29 | Payne | Oklahoma | 40119 | 12252 | 117 |
1961811 | 1961811 | 2021-11-28 | Payne | Oklahoma | 40119 | 12252 | 117 |
1958560 | 1958560 | 2021-11-27 | Payne | Oklahoma | 40119 | 12252 | 117 |
1955309 | 1955309 | 2021-11-26 | Payne | Oklahoma | 40119 | 12252 | 117 |
1952058 | 1952058 | 2021-11-25 | Payne | Oklahoma | 40119 | 12252 | 117 |
1948807 | 1948807 | 2021-11-24 | Payne | Oklahoma | 40119 | 12252 | 117 |
1945556 | 1945556 | 2021-11-23 | Payne | Oklahoma | 40119 | 12201 | 117 |
1942305 | 1942305 | 2021-11-22 | Payne | Oklahoma | 40119 | 12201 | 117 |
1939055 | 1939055 | 2021-11-21 | Payne | Oklahoma | 40119 | 12201 | 117 |
1935805 | 1935805 | 2021-11-20 | Payne | Oklahoma | 40119 | 12201 | 117 |
1932555 | 1932555 | 2021-11-19 | Payne | Oklahoma | 40119 | 12201 | 117 |
1929304 | 1929304 | 2021-11-18 | Payne | Oklahoma | 40119 | 12201 | 117 |
1926054 | 1926054 | 2021-11-17 | Payne | Oklahoma | 40119 | 12201 | 117 |
1922804 | 1922804 | 2021-11-16 | Payne | Oklahoma | 40119 | 12125 | 117 |
1919555 | 1919555 | 2021-11-15 | Payne | Oklahoma | 40119 | 12125 | 117 |
1916305 | 1916305 | 2021-11-14 | Payne | Oklahoma | 40119 | 12125 | 117 |
1913055 | 1913055 | 2021-11-13 | Payne | Oklahoma | 40119 | 12125 | 117 |
1909805 | 1909805 | 2021-11-12 | Payne | Oklahoma | 40119 | 12125 | 117 |
1906556 | 1906556 | 2021-11-11 | Payne | Oklahoma | 40119 | 12125 | 117 |
1903307 | 1903307 | 2021-11-10 | Payne | Oklahoma | 40119 | 12125 | 117 |
1900057 | 1900057 | 2021-11-09 | Payne | Oklahoma | 40119 | 12015 | 117 |
1896807 | 1896807 | 2021-11-08 | Payne | Oklahoma | 40119 | 12015 | 117 |
1893557 | 1893557 | 2021-11-07 | Payne | Oklahoma | 40119 | 12015 | 117 |
1890307 | 1890307 | 2021-11-06 | Payne | Oklahoma | 40119 | 12015 | 117 |
1887057 | 1887057 | 2021-11-05 | Payne | Oklahoma | 40119 | 12015 | 117 |
1883807 | 1883807 | 2021-11-04 | Payne | Oklahoma | 40119 | 12015 | 117 |
1880558 | 1880558 | 2021-11-03 | Payne | Oklahoma | 40119 | 12015 | 117 |
1831817 | 1831817 | 2021-10-19 | Osage | Oklahoma | 40113 | 6765 | 117 |
1828568 | 1828568 | 2021-10-18 | Osage | Oklahoma | 40113 | 6765 | 117 |
1825319 | 1825319 | 2021-10-17 | Osage | Oklahoma | 40113 | 6765 | 117 |
1822070 | 1822070 | 2021-10-16 | Osage | Oklahoma | 40113 | 6765 | 117 |
1818821 | 1818821 | 2021-10-15 | Osage | Oklahoma | 40113 | 6765 | 117 |
1815572 | 1815572 | 2021-10-14 | Osage | Oklahoma | 40113 | 6765 | 117 |
1812324 | 1812324 | 2021-10-13 | Osage | Oklahoma | 40113 | 6765 | 117 |
1786343 | 1786343 | 2021-10-05 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1783094 | 1783094 | 2021-10-04 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1779845 | 1779845 | 2021-10-03 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1776595 | 1776595 | 2021-10-02 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1773345 | 1773345 | 2021-10-01 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1770095 | 1770095 | 2021-09-30 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1766846 | 1766846 | 2021-09-29 | Stephens | Oklahoma | 40137 | 7155 | 117 |
1763597 | 1763597 | 2021-09-28 | Stephens | Oklahoma | 40137 | 6987 | 117 |
1760348 | 1760348 | 2021-09-27 | Stephens | Oklahoma | 40137 | 6987 | 117 |
1757100 | 1757100 | 2021-09-26 | Stephens | Oklahoma | 40137 | 6987 | 117 |
1753852 | 1753852 | 2021-09-25 | Stephens | Oklahoma | 40137 | 6987 | 117 |
1750604 | 1750604 | 2021-09-24 | Stephens | Oklahoma | 40137 | 6987 | 117 |
1747354 | 1747354 | 2021-09-23 | Stephens | Oklahoma | 40137 | 6987 | 117 |
1744105 | 1744105 | 2021-09-22 | Stephens | Oklahoma | 40137 | 6987 | 117 |
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 |
1422597 | 1422597 | 2021-06-15 | Washington | Oklahoma | 40147 | 5250 | 117 |
1419351 | 1419351 | 2021-06-14 | Washington | Oklahoma | 40147 | 5250 | 117 |
1416106 | 1416106 | 2021-06-13 | Washington | Oklahoma | 40147 | 5250 | 117 |
1412860 | 1412860 | 2021-06-12 | Washington | Oklahoma | 40147 | 5250 | 117 |
1409615 | 1409615 | 2021-06-11 | Washington | Oklahoma | 40147 | 5250 | 117 |
1406370 | 1406370 | 2021-06-10 | Washington | Oklahoma | 40147 | 5250 | 117 |
1403124 | 1403124 | 2021-06-09 | Washington | Oklahoma | 40147 | 5250 | 117 |
1101113 | 1101113 | 2021-03-08 | Creek | Oklahoma | 40037 | 6649 | 117 |
1097867 | 1097867 | 2021-03-07 | Creek | Oklahoma | 40037 | 6647 | 117 |
1094619 | 1094619 | 2021-03-06 | Creek | Oklahoma | 40037 | 6641 | 117 |
1091373 | 1091373 | 2021-03-05 | Creek | Oklahoma | 40037 | 6608 | 117 |
1088127 | 1088127 | 2021-03-04 | Creek | Oklahoma | 40037 | 6560 | 117 |
1084882 | 1084882 | 2021-03-03 | Creek | Oklahoma | 40037 | 6549 | 117 |
1081636 | 1081636 | 2021-03-02 | Creek | Oklahoma | 40037 | 6541 | 117 |
1078390 | 1078390 | 2021-03-01 | Creek | Oklahoma | 40037 | 6538 | 117 |
1003739 | 1003739 | 2021-02-06 | Comanche | Oklahoma | 40031 | 10951 | 117 |
744102 | 744102 | 2020-11-18 | Cleveland | Oklahoma | 40027 | 10830 | 117 |
740855 | 740855 | 2020-11-17 | Cleveland | Oklahoma | 40027 | 10709 | 117 |
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);