ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 85 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
714917 | 714917 | 2020-11-09 | Harmon | Oklahoma | 40057 | 85 | 0 |
646836 | 646836 | 2020-10-19 | Roger Mills | Oklahoma | 40129 | 85 | 2 |
643590 | 643590 | 2020-10-18 | Roger Mills | Oklahoma | 40129 | 85 | 2 |
594911 | 594911 | 2020-10-03 | Kiowa | Oklahoma | 40075 | 85 | 2 |
591670 | 591670 | 2020-10-02 | Kiowa | Oklahoma | 40075 | 85 | 2 |
565747 | 565747 | 2020-09-24 | Major | Oklahoma | 40093 | 85 | 1 |
500986 | 500986 | 2020-09-04 | Blaine | Oklahoma | 40011 | 85 | 1 |
481613 | 481613 | 2020-08-29 | Johnston | Oklahoma | 40069 | 85 | 1 |
459010 | 459010 | 2020-08-22 | Murray | Oklahoma | 40099 | 85 | 0 |
446102 | 446102 | 2020-08-18 | Okfuskee | Oklahoma | 40107 | 85 | 3 |
442850 | 442850 | 2020-08-17 | Greer | Oklahoma | 40055 | 85 | 8 |
439623 | 439623 | 2020-08-16 | Greer | Oklahoma | 40055 | 85 | 8 |
352802 | 352802 | 2020-07-20 | Pawnee | Oklahoma | 40117 | 85 | 3 |
343201 | 343201 | 2020-07-17 | Pittsburg | Oklahoma | 40121 | 85 | 3 |
333572 | 333572 | 2020-07-14 | Custer | Oklahoma | 40039 | 85 | 0 |
324037 | 324037 | 2020-07-11 | McIntosh | Oklahoma | 40091 | 85 | 1 |
320850 | 320850 | 2020-07-10 | Logan | Oklahoma | 40083 | 85 | 1 |
308175 | 308175 | 2020-07-06 | Ottawa | Oklahoma | 40115 | 85 | 2 |
282869 | 282869 | 2020-06-28 | Bryan | Oklahoma | 40013 | 85 | 1 |
279723 | 279723 | 2020-06-27 | Bryan | Oklahoma | 40013 | 85 | 1 |
260954 | 260954 | 2020-06-21 | Pottawatomie | Oklahoma | 40125 | 85 | 4 |
217430 | 217430 | 2020-06-07 | Rogers | Oklahoma | 40131 | 85 | 5 |
214340 | 214340 | 2020-06-06 | Rogers | Oklahoma | 40131 | 85 | 5 |
189670 | 189670 | 2020-05-29 | Adair | Oklahoma | 40001 | 85 | 3 |
189694 | 189694 | 2020-05-29 | Grady | Oklahoma | 40051 | 85 | 3 |
162289 | 162289 | 2020-05-20 | Creek | Oklahoma | 40037 | 85 | 7 |
159262 | 159262 | 2020-05-19 | Creek | Oklahoma | 40037 | 85 | 7 |
156241 | 156241 | 2020-05-18 | Creek | Oklahoma | 40037 | 85 | 7 |
138239 | 138239 | 2020-05-12 | McClain | Oklahoma | 40087 | 85 | 2 |
135249 | 135249 | 2020-05-11 | McClain | Oklahoma | 40087 | 85 | 2 |
132258 | 132258 | 2020-05-10 | McClain | Oklahoma | 40087 | 85 | 2 |
129269 | 129269 | 2020-05-09 | McClain | Oklahoma | 40087 | 85 | 2 |
126280 | 126280 | 2020-05-08 | McClain | Oklahoma | 40087 | 85 | 2 |
126290 | 126290 | 2020-05-08 | Osage | Oklahoma | 40113 | 85 | 8 |
94474 | 94474 | 2020-04-27 | Texas | Oklahoma | 40139 | 85 | 1 |
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);