ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where cases = 252 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 |
---|---|---|---|---|---|---|---|
981028 | 981028 | 2021-01-30 | Harmon | Oklahoma | 40057 | 252 | 1 |
977782 | 977782 | 2021-01-29 | Harmon | Oklahoma | 40057 | 252 | 1 |
974537 | 974537 | 2021-01-28 | Harmon | Oklahoma | 40057 | 252 | 1 |
971292 | 971292 | 2021-01-27 | Harmon | Oklahoma | 40057 | 252 | 1 |
968047 | 968047 | 2021-01-26 | Harmon | Oklahoma | 40057 | 252 | 1 |
964803 | 964803 | 2021-01-25 | Harmon | Oklahoma | 40057 | 252 | 1 |
961558 | 961558 | 2021-01-24 | Harmon | Oklahoma | 40057 | 252 | 1 |
809017 | 809017 | 2020-12-08 | Ellis | Oklahoma | 40045 | 252 | 0 |
805772 | 805772 | 2020-12-07 | Ellis | Oklahoma | 40045 | 252 | 0 |
731181 | 731181 | 2020-11-14 | Washita | Oklahoma | 40149 | 252 | 2 |
650058 | 650058 | 2020-10-20 | Love | Oklahoma | 40085 | 252 | 1 |
646835 | 646835 | 2020-10-19 | Pushmataha | Oklahoma | 40127 | 252 | 4 |
640320 | 640320 | 2020-10-17 | Love | Oklahoma | 40085 | 252 | 1 |
575489 | 575489 | 2020-09-27 | Pawnee | Oklahoma | 40117 | 252 | 3 |
569003 | 569003 | 2020-09-25 | Pawnee | Oklahoma | 40117 | 252 | 3 |
513961 | 513961 | 2020-09-08 | McIntosh | Oklahoma | 40091 | 252 | 4 |
494525 | 494525 | 2020-09-02 | Choctaw | Oklahoma | 40023 | 252 | 2 |
494582 | 494582 | 2020-09-02 | Stephens | Oklahoma | 40137 | 252 | 4 |
488115 | 488115 | 2020-08-31 | Stephens | Oklahoma | 40137 | 252 | 4 |
462213 | 462213 | 2020-08-23 | Garvin | Oklahoma | 40049 | 252 | 4 |
426729 | 426729 | 2020-08-12 | Kay | Oklahoma | 40071 | 252 | 11 |
407427 | 407427 | 2020-08-06 | Pittsburg | Oklahoma | 40121 | 252 | 3 |
391349 | 391349 | 2020-08-01 | Sequoyah | Oklahoma | 40135 | 252 | 4 |
362389 | 362389 | 2020-07-23 | Jackson | Oklahoma | 40065 | 252 | 3 |
355953 | 355953 | 2020-07-21 | Bryan | Oklahoma | 40013 | 252 | 1 |
356003 | 356003 | 2020-07-21 | Osage | Oklahoma | 40113 | 252 | 9 |
117381 | 117381 | 2020-05-05 | Texas | Oklahoma | 40139 | 252 | 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);