ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
553 rows where deaths = 22 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Greer 119
- Pushmataha 70
- Love 49
- Nowata 35
- Choctaw 21
- Marshall 21
- Ottawa 18
- Washita 14
- Woods 14
- Murray 13
- Texas 13
- Beckham 11
- Lincoln 11
- Delaware 10
- Garfield 10
- Mayes 9
- Le Flore 8
- Wagoner 8
- Blaine 7
- Cotton 7
- Creek 7
- Dewey 7
- Jefferson 7
- Noble 7
- Comanche 6
- Kay 4
- McIntosh 4
- Pittsburg 4
- Seminole 4
- Tulsa 4
- …
state 1
- Oklahoma · 553 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2241424 | 2241424 | 2022-02-22 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2238173 | 2238173 | 2022-02-21 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2234922 | 2234922 | 2022-02-20 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2231671 | 2231671 | 2022-02-19 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2228420 | 2228420 | 2022-02-18 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2225169 | 2225169 | 2022-02-17 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2221918 | 2221918 | 2022-02-16 | Jefferson | Oklahoma | 40067 | 1270 | 22 |
2013782 | 2013782 | 2021-12-14 | Dewey | Oklahoma | 40043 | 747 | 22 |
2010531 | 2010531 | 2021-12-13 | Dewey | Oklahoma | 40043 | 747 | 22 |
2007280 | 2007280 | 2021-12-12 | Dewey | Oklahoma | 40043 | 747 | 22 |
2004029 | 2004029 | 2021-12-11 | Dewey | Oklahoma | 40043 | 747 | 22 |
2000778 | 2000778 | 2021-12-10 | Dewey | Oklahoma | 40043 | 747 | 22 |
1997528 | 1997528 | 2021-12-09 | Dewey | Oklahoma | 40043 | 747 | 22 |
1994277 | 1994277 | 2021-12-08 | Dewey | Oklahoma | 40043 | 747 | 22 |
1854523 | 1854523 | 2021-10-26 | Cotton | Oklahoma | 40033 | 981 | 22 |
1851274 | 1851274 | 2021-10-25 | Cotton | Oklahoma | 40033 | 981 | 22 |
1848024 | 1848024 | 2021-10-24 | Cotton | Oklahoma | 40033 | 981 | 22 |
1844774 | 1844774 | 2021-10-23 | Cotton | Oklahoma | 40033 | 981 | 22 |
1841524 | 1841524 | 2021-10-22 | Cotton | Oklahoma | 40033 | 981 | 22 |
1838275 | 1838275 | 2021-10-21 | Cotton | Oklahoma | 40033 | 981 | 22 |
1835026 | 1835026 | 2021-10-20 | Cotton | Oklahoma | 40033 | 981 | 22 |
1831837 | 1831837 | 2021-10-19 | Woods | Oklahoma | 40151 | 1599 | 22 |
1828588 | 1828588 | 2021-10-18 | Woods | Oklahoma | 40151 | 1599 | 22 |
1825339 | 1825339 | 2021-10-17 | Woods | Oklahoma | 40151 | 1599 | 22 |
1822090 | 1822090 | 2021-10-16 | Woods | Oklahoma | 40151 | 1599 | 22 |
1818841 | 1818841 | 2021-10-15 | Woods | Oklahoma | 40151 | 1599 | 22 |
1815592 | 1815592 | 2021-10-14 | Woods | Oklahoma | 40151 | 1599 | 22 |
1812344 | 1812344 | 2021-10-13 | Woods | Oklahoma | 40151 | 1599 | 22 |
1809095 | 1809095 | 2021-10-12 | Woods | Oklahoma | 40151 | 1577 | 22 |
1805845 | 1805845 | 2021-10-11 | Woods | Oklahoma | 40151 | 1577 | 22 |
1802595 | 1802595 | 2021-10-10 | Woods | Oklahoma | 40151 | 1577 | 22 |
1799346 | 1799346 | 2021-10-09 | Woods | Oklahoma | 40151 | 1577 | 22 |
1796097 | 1796097 | 2021-10-08 | Woods | Oklahoma | 40151 | 1577 | 22 |
1792848 | 1792848 | 2021-10-07 | Woods | Oklahoma | 40151 | 1577 | 22 |
1789599 | 1789599 | 2021-10-06 | Woods | Oklahoma | 40151 | 1577 | 22 |
1763581 | 1763581 | 2021-09-28 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1760332 | 1760332 | 2021-09-27 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1757084 | 1757084 | 2021-09-26 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1753836 | 1753836 | 2021-09-25 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1750588 | 1750588 | 2021-09-24 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1747338 | 1747338 | 2021-09-23 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1744089 | 1744089 | 2021-09-22 | Nowata | Oklahoma | 40105 | 1686 | 22 |
1740815 | 1740815 | 2021-09-21 | Greer | Oklahoma | 40055 | 669 | 22 |
1740840 | 1740840 | 2021-09-21 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1737566 | 1737566 | 2021-09-20 | Greer | Oklahoma | 40055 | 669 | 22 |
1737591 | 1737591 | 2021-09-20 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1734316 | 1734316 | 2021-09-19 | Greer | Oklahoma | 40055 | 669 | 22 |
1734341 | 1734341 | 2021-09-19 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1731066 | 1731066 | 2021-09-18 | Greer | Oklahoma | 40055 | 669 | 22 |
1731091 | 1731091 | 2021-09-18 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1727816 | 1727816 | 2021-09-17 | Greer | Oklahoma | 40055 | 669 | 22 |
1727841 | 1727841 | 2021-09-17 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1724567 | 1724567 | 2021-09-16 | Greer | Oklahoma | 40055 | 669 | 22 |
1724592 | 1724592 | 2021-09-16 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1721318 | 1721318 | 2021-09-15 | Greer | Oklahoma | 40055 | 669 | 22 |
1721343 | 1721343 | 2021-09-15 | Nowata | Oklahoma | 40105 | 1649 | 22 |
1718070 | 1718070 | 2021-09-14 | Greer | Oklahoma | 40055 | 648 | 22 |
1718095 | 1718095 | 2021-09-14 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1714822 | 1714822 | 2021-09-13 | Greer | Oklahoma | 40055 | 648 | 22 |
1714847 | 1714847 | 2021-09-13 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1711576 | 1711576 | 2021-09-12 | Greer | Oklahoma | 40055 | 648 | 22 |
1711601 | 1711601 | 2021-09-12 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1708329 | 1708329 | 2021-09-11 | Greer | Oklahoma | 40055 | 648 | 22 |
1708354 | 1708354 | 2021-09-11 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1705082 | 1705082 | 2021-09-10 | Greer | Oklahoma | 40055 | 648 | 22 |
1705107 | 1705107 | 2021-09-10 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1701832 | 1701832 | 2021-09-09 | Greer | Oklahoma | 40055 | 648 | 22 |
1701857 | 1701857 | 2021-09-09 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1698583 | 1698583 | 2021-09-08 | Greer | Oklahoma | 40055 | 648 | 22 |
1698608 | 1698608 | 2021-09-08 | Nowata | Oklahoma | 40105 | 1576 | 22 |
1695313 | 1695313 | 2021-09-07 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1695335 | 1695335 | 2021-09-07 | Greer | Oklahoma | 40055 | 632 | 22 |
1695360 | 1695360 | 2021-09-07 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1692065 | 1692065 | 2021-09-06 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1692087 | 1692087 | 2021-09-06 | Greer | Oklahoma | 40055 | 632 | 22 |
1692112 | 1692112 | 2021-09-06 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1688816 | 1688816 | 2021-09-05 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1688838 | 1688838 | 2021-09-05 | Greer | Oklahoma | 40055 | 632 | 22 |
1688863 | 1688863 | 2021-09-05 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1685566 | 1685566 | 2021-09-04 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1685588 | 1685588 | 2021-09-04 | Greer | Oklahoma | 40055 | 632 | 22 |
1685613 | 1685613 | 2021-09-04 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1682315 | 1682315 | 2021-09-03 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1682337 | 1682337 | 2021-09-03 | Greer | Oklahoma | 40055 | 632 | 22 |
1682362 | 1682362 | 2021-09-03 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1679065 | 1679065 | 2021-09-02 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1679087 | 1679087 | 2021-09-02 | Greer | Oklahoma | 40055 | 632 | 22 |
1679112 | 1679112 | 2021-09-02 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1675817 | 1675817 | 2021-09-01 | Blaine | Oklahoma | 40011 | 1233 | 22 |
1675839 | 1675839 | 2021-09-01 | Greer | Oklahoma | 40055 | 632 | 22 |
1675864 | 1675864 | 2021-09-01 | Nowata | Oklahoma | 40105 | 1495 | 22 |
1672592 | 1672592 | 2021-08-31 | Greer | Oklahoma | 40055 | 617 | 22 |
1672617 | 1672617 | 2021-08-31 | Nowata | Oklahoma | 40105 | 1439 | 22 |
1669344 | 1669344 | 2021-08-30 | Greer | Oklahoma | 40055 | 617 | 22 |
1669369 | 1669369 | 2021-08-30 | Nowata | Oklahoma | 40105 | 1439 | 22 |
1666097 | 1666097 | 2021-08-29 | Greer | Oklahoma | 40055 | 617 | 22 |
1666122 | 1666122 | 2021-08-29 | Nowata | Oklahoma | 40105 | 1439 | 22 |
1662849 | 1662849 | 2021-08-28 | Greer | Oklahoma | 40055 | 617 | 22 |
1662874 | 1662874 | 2021-08-28 | Nowata | Oklahoma | 40105 | 1439 | 22 |
1659601 | 1659601 | 2021-08-27 | Greer | Oklahoma | 40055 | 617 | 22 |
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);