ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 121 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
993998 | 993998 | 2021-02-03 | Cimarron | Oklahoma | 40025 | 121 | 1 |
990752 | 990752 | 2021-02-02 | Cimarron | Oklahoma | 40025 | 121 | 1 |
987506 | 987506 | 2021-02-01 | Cimarron | Oklahoma | 40025 | 121 | 1 |
984259 | 984259 | 2021-01-31 | Cimarron | Oklahoma | 40025 | 121 | 1 |
740871 | 740871 | 2020-11-17 | Harper | Oklahoma | 40059 | 121 | 2 |
737625 | 737625 | 2020-11-16 | Harper | Oklahoma | 40059 | 121 | 2 |
711648 | 711648 | 2020-11-08 | Beaver | Oklahoma | 40007 | 121 | 1 |
708404 | 708404 | 2020-11-07 | Beaver | Oklahoma | 40007 | 121 | 1 |
698697 | 698697 | 2020-11-04 | Grant | Oklahoma | 40053 | 121 | 2 |
617645 | 617645 | 2020-10-10 | Washita | Oklahoma | 40149 | 121 | 0 |
614355 | 614355 | 2020-10-09 | Greer | Oklahoma | 40055 | 121 | 8 |
530145 | 530145 | 2020-09-13 | Nowata | Oklahoma | 40105 | 121 | 2 |
523654 | 523654 | 2020-09-11 | Johnston | Oklahoma | 40069 | 121 | 3 |
520418 | 520418 | 2020-09-10 | Johnston | Oklahoma | 40069 | 121 | 3 |
520435 | 520435 | 2020-09-10 | Noble | Oklahoma | 40103 | 121 | 2 |
471941 | 471941 | 2020-08-26 | Pushmataha | Oklahoma | 40127 | 121 | 1 |
468709 | 468709 | 2020-08-25 | Pushmataha | Oklahoma | 40127 | 121 | 1 |
465481 | 465481 | 2020-08-24 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
462252 | 462252 | 2020-08-23 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
459024 | 459024 | 2020-08-22 | Pushmataha | Oklahoma | 40127 | 121 | 0 |
442867 | 442867 | 2020-08-17 | Marshall | Oklahoma | 40095 | 121 | 1 |
439640 | 439640 | 2020-08-16 | Marshall | Oklahoma | 40095 | 121 | 1 |
436415 | 436415 | 2020-08-15 | Marshall | Oklahoma | 40095 | 121 | 1 |
355966 | 355966 | 2020-07-21 | Custer | Oklahoma | 40039 | 121 | 0 |
330371 | 330371 | 2020-07-13 | Cherokee | Oklahoma | 40021 | 121 | 1 |
314470 | 314470 | 2020-07-08 | Choctaw | Oklahoma | 40023 | 121 | 1 |
314516 | 314516 | 2020-07-08 | Ottawa | Oklahoma | 40115 | 121 | 2 |
311349 | 311349 | 2020-07-07 | Pottawatomie | Oklahoma | 40125 | 121 | 4 |
304951 | 304951 | 2020-07-05 | Adair | Oklahoma | 40001 | 121 | 4 |
273442 | 273442 | 2020-06-25 | Delaware | Oklahoma | 40041 | 121 | 16 |
254659 | 254659 | 2020-06-19 | Creek | Oklahoma | 40037 | 121 | 7 |
254685 | 254685 | 2020-06-19 | McClain | Oklahoma | 40087 | 121 | 4 |
27689 | 27689 | 2020-04-02 | Cleveland | Oklahoma | 40027 | 121 | 6 |
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);