ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 197 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Oklahoma · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2358545 | 2358545 | 2022-03-30 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2355291 | 2355291 | 2022-03-29 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2352038 | 2352038 | 2022-03-28 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2348786 | 2348786 | 2022-03-27 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2345533 | 2345533 | 2022-03-26 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2342280 | 2342280 | 2022-03-25 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2339027 | 2339027 | 2022-03-24 | Stephens | Oklahoma | 40137 | 10937 | 197 |
2036524 | 2036524 | 2021-12-21 | Carter | Oklahoma | 40019 | 9494 | 197 |
2033274 | 2033274 | 2021-12-20 | Carter | Oklahoma | 40019 | 9494 | 197 |
2030024 | 2030024 | 2021-12-19 | Carter | Oklahoma | 40019 | 9494 | 197 |
2026773 | 2026773 | 2021-12-18 | Carter | Oklahoma | 40019 | 9494 | 197 |
2023522 | 2023522 | 2021-12-17 | Carter | Oklahoma | 40019 | 9494 | 197 |
2020271 | 2020271 | 2021-12-16 | Carter | Oklahoma | 40019 | 9494 | 197 |
2017020 | 2017020 | 2021-12-15 | Carter | Oklahoma | 40019 | 9494 | 197 |
1649839 | 1649839 | 2021-08-24 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1646590 | 1646590 | 2021-08-23 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1643341 | 1643341 | 2021-08-22 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1640091 | 1640091 | 2021-08-21 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1636841 | 1636841 | 2021-08-20 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1633591 | 1633591 | 2021-08-19 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1630344 | 1630344 | 2021-08-18 | Canadian | Oklahoma | 40017 | 19148 | 197 |
1581674 | 1581674 | 2021-08-03 | Rogers | Oklahoma | 40131 | 11413 | 197 |
1578425 | 1578425 | 2021-08-02 | Rogers | Oklahoma | 40131 | 11413 | 197 |
1575177 | 1575177 | 2021-08-01 | Rogers | Oklahoma | 40131 | 11413 | 197 |
1571929 | 1571929 | 2021-07-31 | Rogers | Oklahoma | 40131 | 11413 | 197 |
1568681 | 1568681 | 2021-07-30 | Rogers | Oklahoma | 40131 | 11413 | 197 |
1565433 | 1565433 | 2021-07-29 | Rogers | Oklahoma | 40131 | 11413 | 197 |
1562185 | 1562185 | 2021-07-28 | Rogers | Oklahoma | 40131 | 11413 | 197 |
958298 | 958298 | 2021-01-23 | Cleveland | Oklahoma | 40027 | 24919 | 197 |
659821 | 659821 | 2020-10-23 | Tulsa | Oklahoma | 40143 | 21239 | 197 |
604656 | 604656 | 2020-10-06 | Oklahoma | Oklahoma | 40109 | 19307 | 197 |
601414 | 601414 | 2020-10-05 | Oklahoma | Oklahoma | 40109 | 19140 | 197 |
598171 | 598171 | 2020-10-04 | Oklahoma | Oklahoma | 40109 | 19008 | 197 |
594928 | 594928 | 2020-10-03 | Oklahoma | Oklahoma | 40109 | 18870 | 197 |
591687 | 591687 | 2020-10-02 | Oklahoma | Oklahoma | 40109 | 18709 | 197 |
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);