ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
90 rows where deaths = 92 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2195897 | 2195897 | 2022-02-08 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2192643 | 2192643 | 2022-02-07 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2189389 | 2189389 | 2022-02-06 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2186136 | 2186136 | 2022-02-05 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2182884 | 2182884 | 2022-02-04 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2179632 | 2179632 | 2022-02-03 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2176381 | 2176381 | 2022-02-02 | Jackson | Oklahoma | 40065 | 6220 | 92 |
2173127 | 2173127 | 2022-02-01 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2169875 | 2169875 | 2022-01-31 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2166620 | 2166620 | 2022-01-30 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2163365 | 2163365 | 2022-01-29 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2160110 | 2160110 | 2022-01-28 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2156855 | 2156855 | 2022-01-27 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2153602 | 2153602 | 2022-01-26 | Jackson | Oklahoma | 40065 | 5727 | 92 |
2013800 | 2013800 | 2021-12-14 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
2010549 | 2010549 | 2021-12-13 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
2007298 | 2007298 | 2021-12-12 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
2004047 | 2004047 | 2021-12-11 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
2000796 | 2000796 | 2021-12-10 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
1997546 | 1997546 | 2021-12-09 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
1994295 | 1994295 | 2021-12-08 | Le Flore | Oklahoma | 40079 | 8570 | 92 |
1991072 | 1991072 | 2021-12-07 | Sequoyah | Oklahoma | 40135 | 6889 | 92 |
1987821 | 1987821 | 2021-12-06 | Sequoyah | Oklahoma | 40135 | 6889 | 92 |
1984571 | 1984571 | 2021-12-05 | Sequoyah | Oklahoma | 40135 | 6889 | 92 |
1981321 | 1981321 | 2021-12-04 | Sequoyah | Oklahoma | 40135 | 6889 | 92 |
1978071 | 1978071 | 2021-12-03 | Sequoyah | Oklahoma | 40135 | 6889 | 92 |
1877298 | 1877298 | 2021-11-02 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1874049 | 1874049 | 2021-11-01 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1870800 | 1870800 | 2021-10-31 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1867551 | 1867551 | 2021-10-30 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1864302 | 1864302 | 2021-10-29 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1861053 | 1861053 | 2021-10-28 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1857804 | 1857804 | 2021-10-27 | McIntosh | Oklahoma | 40091 | 2880 | 92 |
1831807 | 1831807 | 2021-10-19 | McClain | Oklahoma | 40087 | 7325 | 92 |
1831827 | 1831827 | 2021-10-19 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1828558 | 1828558 | 2021-10-18 | McClain | Oklahoma | 40087 | 7325 | 92 |
1828578 | 1828578 | 2021-10-18 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1825309 | 1825309 | 2021-10-17 | McClain | Oklahoma | 40087 | 7325 | 92 |
1825329 | 1825329 | 2021-10-17 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1822060 | 1822060 | 2021-10-16 | McClain | Oklahoma | 40087 | 7325 | 92 |
1822080 | 1822080 | 2021-10-16 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1818811 | 1818811 | 2021-10-15 | McClain | Oklahoma | 40087 | 7325 | 92 |
1818831 | 1818831 | 2021-10-15 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1815562 | 1815562 | 2021-10-14 | McClain | Oklahoma | 40087 | 7325 | 92 |
1815582 | 1815582 | 2021-10-14 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1812314 | 1812314 | 2021-10-13 | McClain | Oklahoma | 40087 | 7325 | 92 |
1812334 | 1812334 | 2021-10-13 | Seminole | Oklahoma | 40133 | 3755 | 92 |
1809043 | 1809043 | 2021-10-12 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1805793 | 1805793 | 2021-10-11 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1802543 | 1802543 | 2021-10-10 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1799294 | 1799294 | 2021-10-09 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1796045 | 1796045 | 2021-10-08 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1792796 | 1792796 | 2021-10-07 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1789547 | 1789547 | 2021-10-06 | Garvin | Oklahoma | 40049 | 4616 | 92 |
1763588 | 1763588 | 2021-09-28 | Payne | Oklahoma | 40119 | 11426 | 92 |
1760339 | 1760339 | 2021-09-27 | Payne | Oklahoma | 40119 | 11426 | 92 |
1757091 | 1757091 | 2021-09-26 | Payne | Oklahoma | 40119 | 11426 | 92 |
1753843 | 1753843 | 2021-09-25 | Payne | Oklahoma | 40119 | 11426 | 92 |
1750595 | 1750595 | 2021-09-24 | Payne | Oklahoma | 40119 | 11426 | 92 |
1747345 | 1747345 | 2021-09-23 | Payne | Oklahoma | 40119 | 11426 | 92 |
1744096 | 1744096 | 2021-09-22 | Payne | Oklahoma | 40119 | 11426 | 92 |
1695363 | 1695363 | 2021-09-07 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1692115 | 1692115 | 2021-09-06 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1688866 | 1688866 | 2021-09-05 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1685616 | 1685616 | 2021-09-04 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1682365 | 1682365 | 2021-09-03 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1679115 | 1679115 | 2021-09-02 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1675867 | 1675867 | 2021-09-01 | Okmulgee | Oklahoma | 40111 | 4968 | 92 |
1672621 | 1672621 | 2021-08-31 | Osage | Oklahoma | 40113 | 5714 | 92 |
1669373 | 1669373 | 2021-08-30 | Osage | Oklahoma | 40113 | 5714 | 92 |
1666126 | 1666126 | 2021-08-29 | Osage | Oklahoma | 40113 | 5714 | 92 |
1662878 | 1662878 | 2021-08-28 | Osage | Oklahoma | 40113 | 5714 | 92 |
1659630 | 1659630 | 2021-08-27 | Osage | Oklahoma | 40113 | 5714 | 92 |
1656381 | 1656381 | 2021-08-26 | Osage | Oklahoma | 40113 | 5714 | 92 |
1653134 | 1653134 | 2021-08-25 | Osage | Oklahoma | 40113 | 5714 | 92 |
1149867 | 1149867 | 2021-03-23 | Washington | Oklahoma | 40147 | 4943 | 92 |
1146620 | 1146620 | 2021-03-22 | Washington | Oklahoma | 40147 | 4943 | 92 |
1143373 | 1143373 | 2021-03-21 | Washington | Oklahoma | 40147 | 4943 | 92 |
1140126 | 1140126 | 2021-03-20 | Washington | Oklahoma | 40147 | 4943 | 92 |
1136880 | 1136880 | 2021-03-19 | Washington | Oklahoma | 40147 | 4943 | 92 |
1133634 | 1133634 | 2021-03-18 | Washington | Oklahoma | 40147 | 4943 | 92 |
1130386 | 1130386 | 2021-03-17 | Washington | Oklahoma | 40147 | 4943 | 92 |
1127139 | 1127139 | 2021-03-16 | Washington | Oklahoma | 40147 | 4943 | 92 |
1068643 | 1068643 | 2021-02-26 | Canadian | Oklahoma | 40017 | 15717 | 92 |
981018 | 981018 | 2021-01-30 | Creek | Oklahoma | 40037 | 5764 | 92 |
977772 | 977772 | 2021-01-29 | Creek | Oklahoma | 40037 | 5705 | 92 |
951859 | 951859 | 2021-01-21 | Rogers | Oklahoma | 40131 | 8403 | 92 |
948564 | 948564 | 2021-01-20 | Comanche | Oklahoma | 40031 | 8907 | 92 |
948614 | 948614 | 2021-01-20 | Rogers | Oklahoma | 40131 | 8346 | 92 |
378467 | 378467 | 2020-07-28 | Oklahoma | Oklahoma | 40109 | 8274 | 92 |
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);