ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
268 rows where deaths = 78 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 |
---|---|---|---|---|---|---|---|
1991009 | 1991009 | 2021-12-07 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1987758 | 1987758 | 2021-12-06 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1984508 | 1984508 | 2021-12-05 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1981258 | 1981258 | 2021-12-04 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1978008 | 1978008 | 2021-12-03 | Beckham | Oklahoma | 40009 | 3828 | 78 |
1627146 | 1627146 | 2021-08-17 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1627155 | 1627155 | 2021-08-17 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1623899 | 1623899 | 2021-08-16 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1623908 | 1623908 | 2021-08-16 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1620652 | 1620652 | 2021-08-15 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1620661 | 1620661 | 2021-08-15 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1617404 | 1617404 | 2021-08-14 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1617413 | 1617413 | 2021-08-14 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1614156 | 1614156 | 2021-08-13 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1614165 | 1614165 | 2021-08-13 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1610907 | 1610907 | 2021-08-12 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1610916 | 1610916 | 2021-08-12 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1607659 | 1607659 | 2021-08-11 | Ottawa | Oklahoma | 40115 | 5061 | 78 |
1607668 | 1607668 | 2021-08-11 | Seminole | Oklahoma | 40133 | 3064 | 78 |
1604419 | 1604419 | 2021-08-10 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1601170 | 1601170 | 2021-08-09 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1597922 | 1597922 | 2021-08-08 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1594673 | 1594673 | 2021-08-07 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1591424 | 1591424 | 2021-08-06 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1588175 | 1588175 | 2021-08-05 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1584925 | 1584925 | 2021-08-04 | Seminole | Oklahoma | 40133 | 2968 | 78 |
1581675 | 1581675 | 2021-08-03 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1578426 | 1578426 | 2021-08-02 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1575178 | 1575178 | 2021-08-01 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1571930 | 1571930 | 2021-07-31 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1568682 | 1568682 | 2021-07-30 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1565434 | 1565434 | 2021-07-29 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1562186 | 1562186 | 2021-07-28 | Seminole | Oklahoma | 40133 | 2927 | 78 |
1558932 | 1558932 | 2021-07-27 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1558938 | 1558938 | 2021-07-27 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1555685 | 1555685 | 2021-07-26 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1555691 | 1555691 | 2021-07-26 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1552438 | 1552438 | 2021-07-25 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1552444 | 1552444 | 2021-07-25 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1549191 | 1549191 | 2021-07-24 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1549197 | 1549197 | 2021-07-24 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1545944 | 1545944 | 2021-07-23 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1545950 | 1545950 | 2021-07-23 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1542697 | 1542697 | 2021-07-22 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1542703 | 1542703 | 2021-07-22 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1539449 | 1539449 | 2021-07-21 | Pittsburg | Oklahoma | 40121 | 4739 | 78 |
1539455 | 1539455 | 2021-07-21 | Seminole | Oklahoma | 40133 | 2905 | 78 |
1536202 | 1536202 | 2021-07-20 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1536208 | 1536208 | 2021-07-20 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1532954 | 1532954 | 2021-07-19 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1532960 | 1532960 | 2021-07-19 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1529707 | 1529707 | 2021-07-18 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1529713 | 1529713 | 2021-07-18 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1526460 | 1526460 | 2021-07-17 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1526466 | 1526466 | 2021-07-17 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1523213 | 1523213 | 2021-07-16 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1523219 | 1523219 | 2021-07-16 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1519965 | 1519965 | 2021-07-15 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1519971 | 1519971 | 2021-07-15 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1516717 | 1516717 | 2021-07-14 | Pittsburg | Oklahoma | 40121 | 4709 | 78 |
1516723 | 1516723 | 2021-07-14 | Seminole | Oklahoma | 40133 | 2895 | 78 |
1513470 | 1513470 | 2021-07-13 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1513476 | 1513476 | 2021-07-13 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1510224 | 1510224 | 2021-07-12 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1510230 | 1510230 | 2021-07-12 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1506977 | 1506977 | 2021-07-11 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1506983 | 1506983 | 2021-07-11 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1503731 | 1503731 | 2021-07-10 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1503737 | 1503737 | 2021-07-10 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1500485 | 1500485 | 2021-07-09 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1500491 | 1500491 | 2021-07-09 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1497239 | 1497239 | 2021-07-08 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1497245 | 1497245 | 2021-07-08 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1493992 | 1493992 | 2021-07-07 | Pittsburg | Oklahoma | 40121 | 4703 | 78 |
1493998 | 1493998 | 2021-07-07 | Seminole | Oklahoma | 40133 | 2892 | 78 |
1490745 | 1490745 | 2021-07-06 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1490751 | 1490751 | 2021-07-06 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1487498 | 1487498 | 2021-07-05 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1487504 | 1487504 | 2021-07-05 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1484251 | 1484251 | 2021-07-04 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1484257 | 1484257 | 2021-07-04 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1481005 | 1481005 | 2021-07-03 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1481011 | 1481011 | 2021-07-03 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1477758 | 1477758 | 2021-07-02 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1477764 | 1477764 | 2021-07-02 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1474512 | 1474512 | 2021-07-01 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1474518 | 1474518 | 2021-07-01 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1471266 | 1471266 | 2021-06-30 | Pittsburg | Oklahoma | 40121 | 4684 | 78 |
1471272 | 1471272 | 2021-06-30 | Seminole | Oklahoma | 40133 | 2889 | 78 |
1468021 | 1468021 | 2021-06-29 | Pittsburg | Oklahoma | 40121 | 4671 | 78 |
1468027 | 1468027 | 2021-06-29 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1464776 | 1464776 | 2021-06-28 | Pittsburg | Oklahoma | 40121 | 4671 | 78 |
1464782 | 1464782 | 2021-06-28 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1461531 | 1461531 | 2021-06-27 | Pittsburg | Oklahoma | 40121 | 4671 | 78 |
1461537 | 1461537 | 2021-06-27 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1458286 | 1458286 | 2021-06-26 | Pittsburg | Oklahoma | 40121 | 4671 | 78 |
1458292 | 1458292 | 2021-06-26 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1455041 | 1455041 | 2021-06-25 | Pittsburg | Oklahoma | 40121 | 4671 | 78 |
1455047 | 1455047 | 2021-06-25 | Seminole | Oklahoma | 40133 | 2885 | 78 |
1451796 | 1451796 | 2021-06-24 | Pittsburg | Oklahoma | 40121 | 4671 | 78 |
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);