ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 106 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
747357 | 747357 | 2020-11-19 | Ellis | Oklahoma | 40045 | 106 | 0 |
727926 | 727926 | 2020-11-13 | Roger Mills | Oklahoma | 40129 | 106 | 5 |
607920 | 607920 | 2020-10-07 | Washita | Oklahoma | 40149 | 106 | 0 |
604677 | 604677 | 2020-10-06 | Washita | Oklahoma | 40149 | 106 | 0 |
569021 | 569021 | 2020-09-25 | Woods | Oklahoma | 40151 | 106 | 0 |
562490 | 562490 | 2020-09-23 | Greer | Oklahoma | 40055 | 106 | 8 |
546279 | 546279 | 2020-09-18 | Blaine | Oklahoma | 40011 | 106 | 1 |
526905 | 526905 | 2020-09-12 | Murray | Oklahoma | 40099 | 106 | 1 |
501058 | 501058 | 2020-09-04 | Woodward | Oklahoma | 40153 | 106 | 0 |
465435 | 465435 | 2020-08-24 | Craig | Oklahoma | 40035 | 106 | 1 |
462206 | 462206 | 2020-08-23 | Craig | Oklahoma | 40035 | 106 | 1 |
410631 | 410631 | 2020-08-07 | Marshall | Oklahoma | 40095 | 106 | 1 |
381670 | 381670 | 2020-07-29 | Lincoln | Oklahoma | 40081 | 106 | 2 |
362423 | 362423 | 2020-07-23 | Seminole | Oklahoma | 40133 | 106 | 5 |
356008 | 356008 | 2020-07-21 | Pontotoc | Oklahoma | 40123 | 106 | 2 |
340010 | 340010 | 2020-07-16 | Stephens | Oklahoma | 40137 | 106 | 1 |
317656 | 317656 | 2020-07-09 | Garvin | Oklahoma | 40049 | 106 | 2 |
298660 | 298660 | 2020-07-03 | Kay | Oklahoma | 40071 | 106 | 7 |
286057 | 286057 | 2020-06-29 | Muskogee | Oklahoma | 40101 | 106 | 11 |
282912 | 282912 | 2020-06-28 | Muskogee | Oklahoma | 40101 | 106 | 11 |
248422 | 248422 | 2020-06-17 | Choctaw | Oklahoma | 40023 | 106 | 1 |
242204 | 242204 | 2020-06-15 | Creek | Oklahoma | 40037 | 106 | 7 |
239095 | 239095 | 2020-06-14 | Creek | Oklahoma | 40037 | 106 | 7 |
236023 | 236023 | 2020-06-13 | Osage | Oklahoma | 40113 | 106 | 8 |
205073 | 205073 | 2020-06-03 | McClain | Oklahoma | 40087 | 106 | 3 |
201996 | 201996 | 2020-06-02 | McClain | Oklahoma | 40087 | 106 | 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);