ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
228 rows where deaths = 70 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2472449 | 2472449 | 2022-05-04 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2469193 | 2469193 | 2022-05-03 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2465937 | 2465937 | 2022-05-02 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2462682 | 2462682 | 2022-05-01 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2459426 | 2459426 | 2022-04-30 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2456170 | 2456170 | 2022-04-29 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2452914 | 2452914 | 2022-04-28 | Kingfisher | Oklahoma | 40073 | 4174 | 70 |
2449658 | 2449658 | 2022-04-27 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2446401 | 2446401 | 2022-04-26 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2443146 | 2443146 | 2022-04-25 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2439890 | 2439890 | 2022-04-24 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2436634 | 2436634 | 2022-04-23 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2433378 | 2433378 | 2022-04-22 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2430122 | 2430122 | 2022-04-21 | Kingfisher | Oklahoma | 40073 | 4170 | 70 |
2312932 | 2312932 | 2022-03-16 | Adair | Oklahoma | 40001 | 7830 | 70 |
2309679 | 2309679 | 2022-03-15 | Adair | Oklahoma | 40001 | 7830 | 70 |
2306426 | 2306426 | 2022-03-14 | Adair | Oklahoma | 40001 | 7830 | 70 |
2303175 | 2303175 | 2022-03-13 | Adair | Oklahoma | 40001 | 7830 | 70 |
2299923 | 2299923 | 2022-03-12 | Adair | Oklahoma | 40001 | 7830 | 70 |
2296671 | 2296671 | 2022-03-11 | Adair | Oklahoma | 40001 | 7830 | 70 |
2293419 | 2293419 | 2022-03-10 | Adair | Oklahoma | 40001 | 7830 | 70 |
2173153 | 2173153 | 2022-02-01 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2169901 | 2169901 | 2022-01-31 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2166646 | 2166646 | 2022-01-30 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2163391 | 2163391 | 2022-01-29 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2160136 | 2160136 | 2022-01-28 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2156881 | 2156881 | 2022-01-27 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2153628 | 2153628 | 2022-01-26 | Pawnee | Oklahoma | 40117 | 3656 | 70 |
2150376 | 2150376 | 2022-01-25 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2147124 | 2147124 | 2022-01-24 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2143870 | 2143870 | 2022-01-23 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2140615 | 2140615 | 2022-01-22 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2137359 | 2137359 | 2022-01-21 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2134105 | 2134105 | 2022-01-20 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2130853 | 2130853 | 2022-01-19 | Pawnee | Oklahoma | 40117 | 3393 | 70 |
2127599 | 2127599 | 2022-01-18 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2124347 | 2124347 | 2022-01-17 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2121095 | 2121095 | 2022-01-16 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2117843 | 2117843 | 2022-01-15 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2114592 | 2114592 | 2022-01-14 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2111340 | 2111340 | 2022-01-13 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2108088 | 2108088 | 2022-01-12 | Pawnee | Oklahoma | 40117 | 3133 | 70 |
2104837 | 2104837 | 2022-01-11 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2101586 | 2101586 | 2022-01-10 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2098335 | 2098335 | 2022-01-09 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2095083 | 2095083 | 2022-01-08 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2091831 | 2091831 | 2022-01-07 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2088579 | 2088579 | 2022-01-06 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2085328 | 2085328 | 2022-01-05 | Pawnee | Oklahoma | 40117 | 2983 | 70 |
2059320 | 2059320 | 2021-12-28 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2056071 | 2056071 | 2021-12-27 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2052822 | 2052822 | 2021-12-26 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2049572 | 2049572 | 2021-12-25 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2046322 | 2046322 | 2021-12-24 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2043072 | 2043072 | 2021-12-23 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
2039823 | 2039823 | 2021-12-22 | Pawnee | Oklahoma | 40117 | 2852 | 70 |
1740855 | 1740855 | 2021-09-21 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1737606 | 1737606 | 2021-09-20 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1734356 | 1734356 | 2021-09-19 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1731106 | 1731106 | 2021-09-18 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1727856 | 1727856 | 2021-09-17 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1724607 | 1724607 | 2021-09-16 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1721358 | 1721358 | 2021-09-15 | Sequoyah | Oklahoma | 40135 | 6183 | 70 |
1672606 | 1672606 | 2021-08-31 | Logan | Oklahoma | 40083 | 4904 | 70 |
1669358 | 1669358 | 2021-08-30 | Logan | Oklahoma | 40083 | 4904 | 70 |
1666111 | 1666111 | 2021-08-29 | Logan | Oklahoma | 40083 | 4904 | 70 |
1662863 | 1662863 | 2021-08-28 | Logan | Oklahoma | 40083 | 4904 | 70 |
1659615 | 1659615 | 2021-08-27 | Logan | Oklahoma | 40083 | 4904 | 70 |
1656366 | 1656366 | 2021-08-26 | Logan | Oklahoma | 40083 | 4904 | 70 |
1653119 | 1653119 | 2021-08-25 | Logan | Oklahoma | 40083 | 4904 | 70 |
1604392 | 1604392 | 2021-08-10 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1601143 | 1601143 | 2021-08-09 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1597895 | 1597895 | 2021-08-08 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1594646 | 1594646 | 2021-08-07 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1591397 | 1591397 | 2021-08-06 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1588148 | 1588148 | 2021-08-05 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1584898 | 1584898 | 2021-08-04 | Le Flore | Oklahoma | 40079 | 6075 | 70 |
1490742 | 1490742 | 2021-07-06 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1487495 | 1487495 | 2021-07-05 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1484248 | 1484248 | 2021-07-04 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1481002 | 1481002 | 2021-07-03 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1477755 | 1477755 | 2021-07-02 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1474509 | 1474509 | 2021-07-01 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1471263 | 1471263 | 2021-06-30 | Ottawa | Oklahoma | 40115 | 4231 | 70 |
1468018 | 1468018 | 2021-06-29 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1464773 | 1464773 | 2021-06-28 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1461528 | 1461528 | 2021-06-27 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1458283 | 1458283 | 2021-06-26 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1455038 | 1455038 | 2021-06-25 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1451793 | 1451793 | 2021-06-24 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1448547 | 1448547 | 2021-06-23 | Ottawa | Oklahoma | 40115 | 4102 | 70 |
1445302 | 1445302 | 2021-06-22 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1442057 | 1442057 | 2021-06-21 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1438812 | 1438812 | 2021-06-20 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1435565 | 1435565 | 2021-06-19 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1432318 | 1432318 | 2021-06-18 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1429072 | 1429072 | 2021-06-17 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1425827 | 1425827 | 2021-06-16 | Ottawa | Oklahoma | 40115 | 4022 | 70 |
1422580 | 1422580 | 2021-06-15 | Ottawa | Oklahoma | 40115 | 3972 | 70 |
1419334 | 1419334 | 2021-06-14 | Ottawa | Oklahoma | 40115 | 3972 | 70 |
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);