ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
155 rows where deaths = 48 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2335707 | 2335707 | 2022-03-23 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2332453 | 2332453 | 2022-03-22 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2329200 | 2329200 | 2022-03-21 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2325948 | 2325948 | 2022-03-20 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2322695 | 2322695 | 2022-03-19 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2319441 | 2319441 | 2022-03-18 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2316187 | 2316187 | 2022-03-17 | Atoka | Oklahoma | 40005 | 3857 | 48 |
2218703 | 2218703 | 2022-02-15 | Texas | Oklahoma | 40139 | 5902 | 48 |
2215452 | 2215452 | 2022-02-14 | Texas | Oklahoma | 40139 | 5902 | 48 |
2212201 | 2212201 | 2022-02-13 | Texas | Oklahoma | 40139 | 5902 | 48 |
2208948 | 2208948 | 2022-02-12 | Texas | Oklahoma | 40139 | 5902 | 48 |
2205695 | 2205695 | 2022-02-11 | Texas | Oklahoma | 40139 | 5902 | 48 |
2202442 | 2202442 | 2022-02-10 | Texas | Oklahoma | 40139 | 5902 | 48 |
2199188 | 2199188 | 2022-02-09 | Texas | Oklahoma | 40139 | 5902 | 48 |
2195902 | 2195902 | 2022-02-08 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2192648 | 2192648 | 2022-02-07 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2189394 | 2189394 | 2022-02-06 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2186141 | 2186141 | 2022-02-05 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2182889 | 2182889 | 2022-02-04 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2179637 | 2179637 | 2022-02-03 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2176386 | 2176386 | 2022-02-02 | Kiowa | Oklahoma | 40075 | 1857 | 48 |
2173132 | 2173132 | 2022-02-01 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2169880 | 2169880 | 2022-01-31 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2166625 | 2166625 | 2022-01-30 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2163370 | 2163370 | 2022-01-29 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2160115 | 2160115 | 2022-01-28 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2156860 | 2156860 | 2022-01-27 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2153607 | 2153607 | 2022-01-26 | Kiowa | Oklahoma | 40075 | 1655 | 48 |
2150355 | 2150355 | 2022-01-25 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2147103 | 2147103 | 2022-01-24 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2143849 | 2143849 | 2022-01-23 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2140594 | 2140594 | 2022-01-22 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2137338 | 2137338 | 2022-01-21 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2134084 | 2134084 | 2022-01-20 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2130832 | 2130832 | 2022-01-19 | Kiowa | Oklahoma | 40075 | 1492 | 48 |
2127572 | 2127572 | 2022-01-18 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2124320 | 2124320 | 2022-01-17 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2121068 | 2121068 | 2022-01-16 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2117816 | 2117816 | 2022-01-15 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2114565 | 2114565 | 2022-01-14 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2111313 | 2111313 | 2022-01-13 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2108061 | 2108061 | 2022-01-12 | Hughes | Oklahoma | 40063 | 1904 | 48 |
2104810 | 2104810 | 2022-01-11 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2101559 | 2101559 | 2022-01-10 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2098308 | 2098308 | 2022-01-09 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2095056 | 2095056 | 2022-01-08 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2091804 | 2091804 | 2022-01-07 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2088552 | 2088552 | 2022-01-06 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2085301 | 2085301 | 2022-01-05 | Hughes | Oklahoma | 40063 | 1860 | 48 |
2082049 | 2082049 | 2022-01-04 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2078797 | 2078797 | 2022-01-03 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2075546 | 2075546 | 2022-01-02 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2072295 | 2072295 | 2022-01-01 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2069044 | 2069044 | 2021-12-31 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2065793 | 2065793 | 2021-12-30 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2062543 | 2062543 | 2021-12-29 | Hughes | Oklahoma | 40063 | 1836 | 48 |
2059293 | 2059293 | 2021-12-28 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2056044 | 2056044 | 2021-12-27 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2052795 | 2052795 | 2021-12-26 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2049545 | 2049545 | 2021-12-25 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2046295 | 2046295 | 2021-12-24 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2043045 | 2043045 | 2021-12-23 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2039796 | 2039796 | 2021-12-22 | Hughes | Oklahoma | 40063 | 1829 | 48 |
2036546 | 2036546 | 2021-12-21 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2033296 | 2033296 | 2021-12-20 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2030046 | 2030046 | 2021-12-19 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2026795 | 2026795 | 2021-12-18 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2023544 | 2023544 | 2021-12-17 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2020293 | 2020293 | 2021-12-16 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2017042 | 2017042 | 2021-12-15 | Hughes | Oklahoma | 40063 | 1815 | 48 |
2013792 | 2013792 | 2021-12-14 | Hughes | Oklahoma | 40063 | 1801 | 48 |
2010541 | 2010541 | 2021-12-13 | Hughes | Oklahoma | 40063 | 1801 | 48 |
2007290 | 2007290 | 2021-12-12 | Hughes | Oklahoma | 40063 | 1801 | 48 |
2004039 | 2004039 | 2021-12-11 | Hughes | Oklahoma | 40063 | 1801 | 48 |
2000788 | 2000788 | 2021-12-10 | Hughes | Oklahoma | 40063 | 1801 | 48 |
1997538 | 1997538 | 2021-12-09 | Hughes | Oklahoma | 40063 | 1801 | 48 |
1994287 | 1994287 | 2021-12-08 | Hughes | Oklahoma | 40063 | 1801 | 48 |
1740837 | 1740837 | 2021-09-21 | Murray | Oklahoma | 40099 | 2427 | 48 |
1737588 | 1737588 | 2021-09-20 | Murray | Oklahoma | 40099 | 2427 | 48 |
1734338 | 1734338 | 2021-09-19 | Murray | Oklahoma | 40099 | 2427 | 48 |
1731088 | 1731088 | 2021-09-18 | Murray | Oklahoma | 40099 | 2427 | 48 |
1727838 | 1727838 | 2021-09-17 | Murray | Oklahoma | 40099 | 2427 | 48 |
1724589 | 1724589 | 2021-09-16 | Murray | Oklahoma | 40099 | 2427 | 48 |
1721340 | 1721340 | 2021-09-15 | Murray | Oklahoma | 40099 | 2427 | 48 |
1672565 | 1672565 | 2021-08-31 | Adair | Oklahoma | 40001 | 4131 | 48 |
1669317 | 1669317 | 2021-08-30 | Adair | Oklahoma | 40001 | 4131 | 48 |
1666070 | 1666070 | 2021-08-29 | Adair | Oklahoma | 40001 | 4131 | 48 |
1662822 | 1662822 | 2021-08-28 | Adair | Oklahoma | 40001 | 4131 | 48 |
1659574 | 1659574 | 2021-08-27 | Adair | Oklahoma | 40001 | 4131 | 48 |
1656325 | 1656325 | 2021-08-26 | Adair | Oklahoma | 40001 | 4131 | 48 |
1653078 | 1653078 | 2021-08-25 | Adair | Oklahoma | 40001 | 4131 | 48 |
1286244 | 1286244 | 2021-05-04 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1282998 | 1282998 | 2021-05-03 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1279751 | 1279751 | 2021-05-02 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1276504 | 1276504 | 2021-05-01 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1273257 | 1273257 | 2021-04-30 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1270010 | 1270010 | 2021-04-29 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1266763 | 1266763 | 2021-04-28 | Pawnee | Oklahoma | 40117 | 1777 | 48 |
1123876 | 1123876 | 2021-03-15 | Ottawa | Oklahoma | 40115 | 3701 | 48 |
1120630 | 1120630 | 2021-03-14 | Ottawa | Oklahoma | 40115 | 3697 | 48 |
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);