ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 91 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 |
---|---|---|---|---|---|---|---|
1926067 | 1926067 | 2021-11-17 | Unknown | Oklahoma | 91 | 0 | |
825236 | 825236 | 2020-12-13 | Cimarron | Oklahoma | 40025 | 91 | 0 |
731134 | 731134 | 2020-11-14 | Harmon | Oklahoma | 40057 | 91 | 0 |
727890 | 727890 | 2020-11-13 | Harmon | Oklahoma | 40057 | 91 | 0 |
685761 | 685761 | 2020-10-31 | Roger Mills | Oklahoma | 40129 | 91 | 4 |
682518 | 682518 | 2020-10-30 | Roger Mills | Oklahoma | 40129 | 91 | 4 |
659764 | 659764 | 2020-10-23 | Coal | Oklahoma | 40029 | 91 | 0 |
598154 | 598154 | 2020-10-04 | Kiowa | Oklahoma | 40075 | 91 | 2 |
578715 | 578715 | 2020-09-28 | Major | Oklahoma | 40093 | 91 | 1 |
517153 | 517153 | 2020-09-09 | Blaine | Oklahoma | 40011 | 91 | 1 |
513940 | 513940 | 2020-09-08 | Greer | Oklahoma | 40055 | 91 | 8 |
510707 | 510707 | 2020-09-07 | Greer | Oklahoma | 40055 | 91 | 8 |
507474 | 507474 | 2020-09-06 | Greer | Oklahoma | 40055 | 91 | 8 |
504242 | 504242 | 2020-09-05 | Greer | Oklahoma | 40055 | 91 | 8 |
501008 | 501008 | 2020-09-04 | Greer | Oklahoma | 40055 | 91 | 8 |
501030 | 501030 | 2020-09-04 | Murray | Oklahoma | 40099 | 91 | 1 |
468699 | 468699 | 2020-08-25 | Okfuskee | Oklahoma | 40107 | 91 | 3 |
465471 | 465471 | 2020-08-24 | Okfuskee | Oklahoma | 40107 | 91 | 3 |
462242 | 462242 | 2020-08-23 | Okfuskee | Oklahoma | 40107 | 91 | 3 |
459014 | 459014 | 2020-08-22 | Okfuskee | Oklahoma | 40107 | 91 | 3 |
455735 | 455735 | 2020-08-21 | Atoka | Oklahoma | 40005 | 91 | 1 |
439647 | 439647 | 2020-08-16 | Noble | Oklahoma | 40103 | 91 | 2 |
436422 | 436422 | 2020-08-15 | Noble | Oklahoma | 40103 | 91 | 2 |
308142 | 308142 | 2020-07-06 | Garvin | Oklahoma | 40049 | 91 | 1 |
304975 | 304975 | 2020-07-05 | Garvin | Oklahoma | 40049 | 91 | 1 |
282897 | 282897 | 2020-06-28 | Kay | Oklahoma | 40071 | 91 | 7 |
279751 | 279751 | 2020-06-27 | Kay | Oklahoma | 40071 | 91 | 7 |
273483 | 273483 | 2020-06-25 | Pottawatomie | Oklahoma | 40125 | 91 | 4 |
205029 | 205029 | 2020-06-03 | Adair | Oklahoma | 40001 | 91 | 4 |
201952 | 201952 | 2020-06-02 | Adair | Oklahoma | 40001 | 91 | 3 |
177479 | 177479 | 2020-05-25 | Creek | Oklahoma | 40037 | 91 | 7 |
156276 | 156276 | 2020-05-18 | Osage | Oklahoma | 40113 | 91 | 8 |
153259 | 153259 | 2020-05-17 | Osage | Oklahoma | 40113 | 91 | 8 |
150248 | 150248 | 2020-05-16 | Osage | Oklahoma | 40113 | 91 | 8 |
147241 | 147241 | 2020-05-15 | Osage | Oklahoma | 40113 | 91 | 8 |
114455 | 114455 | 2020-05-04 | Delaware | Oklahoma | 40041 | 91 | 13 |
111573 | 111573 | 2020-05-03 | Delaware | Oklahoma | 40041 | 91 | 13 |
108699 | 108699 | 2020-05-02 | Delaware | Oklahoma | 40041 | 91 | 13 |
105832 | 105832 | 2020-05-01 | Delaware | Oklahoma | 40041 | 91 | 13 |
94418 | 94418 | 2020-04-27 | Canadian | Oklahoma | 40017 | 91 | 3 |
91592 | 91592 | 2020-04-26 | Canadian | Oklahoma | 40017 | 91 | 3 |
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);