ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34 rows where cases = 86 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 |
---|---|---|---|---|---|---|---|
838281 | 838281 | 2020-12-17 | Unknown | Oklahoma | 86 | 0 | |
656509 | 656509 | 2020-10-22 | Beaver | Oklahoma | 40007 | 86 | 1 |
653275 | 653275 | 2020-10-21 | Coal | Oklahoma | 40029 | 86 | 0 |
650080 | 650080 | 2020-10-20 | Roger Mills | Oklahoma | 40129 | 86 | 3 |
578747 | 578747 | 2020-09-28 | Washita | Oklahoma | 40149 | 86 | 0 |
471930 | 471930 | 2020-08-26 | Nowata | Oklahoma | 40105 | 86 | 1 |
468673 | 468673 | 2020-08-25 | Greer | Oklahoma | 40055 | 86 | 8 |
465445 | 465445 | 2020-08-24 | Greer | Oklahoma | 40055 | 86 | 8 |
465467 | 465467 | 2020-08-24 | Murray | Oklahoma | 40099 | 86 | 0 |
462216 | 462216 | 2020-08-23 | Greer | Oklahoma | 40055 | 86 | 8 |
462231 | 462231 | 2020-08-23 | Love | Oklahoma | 40085 | 86 | 0 |
462238 | 462238 | 2020-08-23 | Murray | Oklahoma | 40099 | 86 | 0 |
458988 | 458988 | 2020-08-22 | Greer | Oklahoma | 40055 | 86 | 8 |
423488 | 423488 | 2020-08-11 | Craig | Oklahoma | 40035 | 86 | 1 |
420265 | 420265 | 2020-08-10 | Craig | Oklahoma | 40035 | 86 | 0 |
410625 | 410625 | 2020-08-07 | Latimer | Oklahoma | 40077 | 86 | 1 |
378444 | 378444 | 2020-07-28 | Hughes | Oklahoma | 40063 | 86 | 1 |
359209 | 359209 | 2020-07-22 | Pawnee | Oklahoma | 40117 | 86 | 3 |
352811 | 352811 | 2020-07-20 | Sequoyah | Oklahoma | 40135 | 86 | 3 |
346380 | 346380 | 2020-07-18 | Le Flore | Oklahoma | 40079 | 86 | 1 |
346401 | 346401 | 2020-07-18 | Pittsburg | Oklahoma | 40121 | 86 | 3 |
327222 | 327222 | 2020-07-12 | McIntosh | Oklahoma | 40091 | 86 | 1 |
314482 | 314482 | 2020-07-08 | Garfield | Oklahoma | 40047 | 86 | 2 |
298670 | 298670 | 2020-07-03 | Mayes | Oklahoma | 40097 | 86 | 5 |
286014 | 286014 | 2020-06-29 | Bryan | Oklahoma | 40013 | 86 | 1 |
276603 | 276603 | 2020-06-26 | Kay | Oklahoma | 40071 | 86 | 7 |
156266 | 156266 | 2020-05-18 | McClain | Oklahoma | 40087 | 86 | 2 |
153249 | 153249 | 2020-05-17 | McClain | Oklahoma | 40087 | 86 | 2 |
150238 | 150238 | 2020-05-16 | McClain | Oklahoma | 40087 | 86 | 2 |
147231 | 147231 | 2020-05-15 | McClain | Oklahoma | 40087 | 86 | 2 |
144230 | 144230 | 2020-05-14 | McClain | Oklahoma | 40087 | 86 | 2 |
141235 | 141235 | 2020-05-13 | McClain | Oklahoma | 40087 | 86 | 2 |
83158 | 83158 | 2020-04-23 | Canadian | Oklahoma | 40017 | 86 | 3 |
74798 | 74798 | 2020-04-20 | Delaware | Oklahoma | 40041 | 86 | 5 |
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);