ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12 rows where cases = 316 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
912872 | 912872 | 2021-01-09 | Ellis | Oklahoma | 40045 | 316 | 1 |
893381 | 893381 | 2021-01-03 | Beaver | Oklahoma | 40007 | 316 | 2 |
812255 | 812255 | 2020-12-09 | Cotton | Oklahoma | 40033 | 316 | 4 |
611117 | 611117 | 2020-10-08 | Haskell | Oklahoma | 40061 | 316 | 4 |
594876 | 594876 | 2020-10-03 | Atoka | Oklahoma | 40005 | 316 | 1 |
572198 | 572198 | 2020-09-26 | Choctaw | Oklahoma | 40023 | 316 | 2 |
501022 | 501022 | 2020-09-04 | Logan | Oklahoma | 40083 | 316 | 1 |
417073 | 417073 | 2020-08-09 | Mayes | Oklahoma | 40097 | 316 | 6 |
371990 | 371990 | 2020-07-26 | Bryan | Oklahoma | 40013 | 316 | 1 |
368822 | 368822 | 2020-07-25 | Muskogee | Oklahoma | 40101 | 316 | 16 |
359171 | 359171 | 2020-07-22 | Delaware | Oklahoma | 40041 | 316 | 19 |
192805 | 192805 | 2020-05-30 | Washington | Oklahoma | 40147 | 316 | 35 |
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);