ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 116 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
964787 | 964787 | 2021-01-25 | Cimarron | Oklahoma | 40025 | 116 | 1 |
961542 | 961542 | 2021-01-24 | Cimarron | Oklahoma | 40025 | 116 | 1 |
958297 | 958297 | 2021-01-23 | Cimarron | Oklahoma | 40025 | 116 | 1 |
935578 | 935578 | 2021-01-16 | Cimarron | Oklahoma | 40025 | 116 | 1 |
932333 | 932333 | 2021-01-15 | Cimarron | Oklahoma | 40025 | 116 | 1 |
727895 | 727895 | 2020-11-13 | Jefferson | Oklahoma | 40067 | 116 | 1 |
698687 | 698687 | 2020-11-04 | Cotton | Oklahoma | 40033 | 116 | 3 |
604629 | 604629 | 2020-10-06 | Greer | Oklahoma | 40055 | 116 | 8 |
598193 | 598193 | 2020-10-04 | Woods | Oklahoma | 40151 | 116 | 0 |
556038 | 556038 | 2020-09-21 | Murray | Oklahoma | 40099 | 116 | 1 |
520437 | 520437 | 2020-09-10 | Okfuskee | Oklahoma | 40107 | 116 | 3 |
517201 | 517201 | 2020-09-09 | Okfuskee | Oklahoma | 40107 | 116 | 3 |
504249 | 504249 | 2020-09-05 | Johnston | Oklahoma | 40069 | 116 | 2 |
504253 | 504253 | 2020-09-05 | Latimer | Oklahoma | 40077 | 116 | 2 |
442886 | 442886 | 2020-08-17 | Pushmataha | Oklahoma | 40127 | 116 | 0 |
436434 | 436434 | 2020-08-15 | Pushmataha | Oklahoma | 40127 | 116 | 0 |
388123 | 388123 | 2020-07-31 | Pawnee | Oklahoma | 40117 | 116 | 3 |
362418 | 362418 | 2020-07-23 | Pontotoc | Oklahoma | 40123 | 116 | 2 |
248465 | 248465 | 2020-06-17 | Osage | Oklahoma | 40113 | 116 | 8 |
242230 | 242230 | 2020-06-15 | McClain | Oklahoma | 40087 | 116 | 4 |
239121 | 239121 | 2020-06-14 | McClain | Oklahoma | 40087 | 116 | 4 |
235993 | 235993 | 2020-06-13 | Grady | Oklahoma | 40051 | 116 | 3 |
232888 | 232888 | 2020-06-12 | Grady | Oklahoma | 40051 | 116 | 3 |
150204 | 150204 | 2020-05-16 | Canadian | Oklahoma | 40017 | 116 | 3 |
147197 | 147197 | 2020-05-15 | Canadian | Oklahoma | 40017 | 116 | 3 |
144196 | 144196 | 2020-05-14 | Canadian | Oklahoma | 40017 | 116 | 3 |
126252 | 126252 | 2020-05-08 | Comanche | Oklahoma | 40031 | 116 | 2 |
97315 | 97315 | 2020-04-28 | Wagoner | Oklahoma | 40145 | 116 | 14 |
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);