ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where cases = 113 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
925843 | 925843 | 2021-01-13 | Cimarron | Oklahoma | 40025 | 113 | 1 |
734416 | 734416 | 2020-11-15 | Roger Mills | Oklahoma | 40129 | 113 | 5 |
614371 | 614371 | 2020-10-09 | Major | Oklahoma | 40093 | 113 | 2 |
601387 | 601387 | 2020-10-05 | Greer | Oklahoma | 40055 | 113 | 8 |
588468 | 588468 | 2020-10-01 | Woods | Oklahoma | 40151 | 113 | 0 |
581988 | 581988 | 2020-09-29 | Woods | Oklahoma | 40151 | 113 | 0 |
578748 | 578748 | 2020-09-28 | Woods | Oklahoma | 40151 | 113 | 0 |
555994 | 555994 | 2020-09-21 | Blaine | Oklahoma | 40011 | 113 | 1 |
549562 | 549562 | 2020-09-19 | Murray | Oklahoma | 40099 | 113 | 1 |
546323 | 546323 | 2020-09-18 | Murray | Oklahoma | 40099 | 113 | 1 |
497798 | 497798 | 2020-09-03 | Noble | Oklahoma | 40103 | 113 | 2 |
491282 | 491282 | 2020-09-01 | Atoka | Oklahoma | 40005 | 113 | 1 |
491318 | 491318 | 2020-09-01 | Latimer | Oklahoma | 40077 | 113 | 2 |
488085 | 488085 | 2020-08-31 | Latimer | Oklahoma | 40077 | 113 | 2 |
475129 | 475129 | 2020-08-27 | Craig | Oklahoma | 40035 | 113 | 1 |
462193 | 462193 | 2020-08-23 | Beckham | Oklahoma | 40009 | 113 | 1 |
400966 | 400966 | 2020-08-04 | Kingfisher | Oklahoma | 40073 | 113 | 0 |
384906 | 384906 | 2020-07-30 | Pawnee | Oklahoma | 40117 | 113 | 3 |
314514 | 314514 | 2020-07-08 | Okmulgee | Oklahoma | 40111 | 113 | 0 |
311322 | 311322 | 2020-07-07 | Kay | Oklahoma | 40071 | 113 | 7 |
298631 | 298631 | 2020-07-03 | Bryan | Oklahoma | 40013 | 113 | 1 |
251588 | 251588 | 2020-06-18 | Rogers | Oklahoma | 40131 | 113 | 5 |
236013 | 236013 | 2020-06-13 | McClain | Oklahoma | 40087 | 113 | 4 |
120292 | 120292 | 2020-05-06 | Comanche | Oklahoma | 40031 | 113 | 2 |
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);