ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 173 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 |
---|---|---|---|---|---|---|---|
711672 | 711672 | 2020-11-08 | Greer | Oklahoma | 40055 | 173 | 8 |
708428 | 708428 | 2020-11-07 | Greer | Oklahoma | 40055 | 173 | 8 |
659801 | 659801 | 2020-10-23 | Noble | Oklahoma | 40103 | 173 | 3 |
614380 | 614380 | 2020-10-09 | Nowata | Oklahoma | 40105 | 173 | 4 |
578706 | 578706 | 2020-09-28 | Johnston | Oklahoma | 40069 | 173 | 4 |
559270 | 559270 | 2020-09-22 | Marshall | Oklahoma | 40095 | 173 | 1 |
407378 | 407378 | 2020-08-06 | Choctaw | Oklahoma | 40023 | 173 | 1 |
384867 | 384867 | 2020-07-30 | Custer | Oklahoma | 40039 | 173 | 0 |
372008 | 372008 | 2020-07-26 | Garvin | Oklahoma | 40049 | 173 | 4 |
349564 | 349564 | 2020-07-19 | Garfield | Oklahoma | 40047 | 173 | 2 |
320815 | 320815 | 2020-07-10 | Bryan | Oklahoma | 40013 | 173 | 1 |
304976 | 304976 | 2020-07-05 | Grady | Oklahoma | 40051 | 173 | 5 |
245367 | 245367 | 2020-06-16 | Wagoner | Oklahoma | 40145 | 173 | 17 |
232871 | 232871 | 2020-06-12 | Caddo | Oklahoma | 40015 | 173 | 10 |
229766 | 229766 | 2020-06-11 | Caddo | Oklahoma | 40015 | 173 | 10 |
226662 | 226662 | 2020-06-10 | Caddo | Oklahoma | 40015 | 173 | 10 |
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);