ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 69 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
760331 | 760331 | 2020-11-23 | Cimarron | Oklahoma | 40025 | 69 | 0 |
731128 | 731128 | 2020-11-14 | Ellis | Oklahoma | 40045 | 69 | 0 |
669511 | 669511 | 2020-10-26 | Harmon | Oklahoma | 40057 | 69 | 0 |
591649 | 591649 | 2020-10-02 | Cotton | Oklahoma | 40033 | 69 | 3 |
588408 | 588408 | 2020-10-01 | Cotton | Oklahoma | 40033 | 69 | 3 |
588413 | 588413 | 2020-10-01 | Dewey | Oklahoma | 40043 | 69 | 1 |
585168 | 585168 | 2020-09-30 | Cotton | Oklahoma | 40033 | 69 | 3 |
546317 | 546317 | 2020-09-18 | Major | Oklahoma | 40093 | 69 | 1 |
536607 | 536607 | 2020-09-15 | Major | Oklahoma | 40093 | 69 | 1 |
494584 | 494584 | 2020-09-02 | Tillman | Oklahoma | 40141 | 69 | 1 |
491350 | 491350 | 2020-09-01 | Tillman | Oklahoma | 40141 | 69 | 1 |
465452 | 465452 | 2020-08-24 | Johnston | Oklahoma | 40069 | 69 | 0 |
410636 | 410636 | 2020-08-07 | Murray | Oklahoma | 40099 | 69 | 0 |
407409 | 407409 | 2020-08-06 | Love | Oklahoma | 40085 | 69 | 0 |
407416 | 407416 | 2020-08-06 | Murray | Oklahoma | 40099 | 69 | 0 |
394536 | 394536 | 2020-08-02 | Latimer | Oklahoma | 40077 | 69 | 1 |
388082 | 388082 | 2020-07-31 | Craig | Oklahoma | 40035 | 69 | 0 |
378457 | 378457 | 2020-07-28 | Marshall | Oklahoma | 40095 | 69 | 0 |
365614 | 365614 | 2020-07-24 | Noble | Oklahoma | 40103 | 69 | 2 |
333580 | 333580 | 2020-07-14 | Greer | Oklahoma | 40055 | 69 | 7 |
320870 | 320870 | 2020-07-10 | Pontotoc | Oklahoma | 40123 | 69 | 2 |
317692 | 317692 | 2020-07-09 | Pittsburg | Oklahoma | 40121 | 69 | 3 |
314478 | 314478 | 2020-07-08 | Custer | Oklahoma | 40039 | 69 | 0 |
314519 | 314519 | 2020-07-08 | Pittsburg | Oklahoma | 40121 | 69 | 3 |
311335 | 311335 | 2020-07-07 | McIntosh | Oklahoma | 40091 | 69 | 1 |
286032 | 286032 | 2020-06-29 | Garvin | Oklahoma | 40049 | 69 | 1 |
260902 | 260902 | 2020-06-21 | Carter | Oklahoma | 40019 | 69 | 1 |
260937 | 260937 | 2020-06-21 | Mayes | Oklahoma | 40097 | 69 | 4 |
257773 | 257773 | 2020-06-20 | Bryan | Oklahoma | 40013 | 69 | 1 |
245331 | 245331 | 2020-06-16 | Kay | Oklahoma | 40071 | 69 | 7 |
229807 | 229807 | 2020-06-11 | Muskogee | Oklahoma | 40101 | 69 | 7 |
123255 | 123255 | 2020-05-07 | Adair | Oklahoma | 40001 | 69 | 3 |
123315 | 123315 | 2020-05-07 | Rogers | Oklahoma | 40131 | 69 | 4 |
111561 | 111561 | 2020-05-03 | Caddo | Oklahoma | 40015 | 69 | 8 |
77578 | 77578 | 2020-04-21 | Creek | Oklahoma | 40037 | 69 | 4 |
66489 | 66489 | 2020-04-17 | Canadian | Oklahoma | 40017 | 69 | 3 |
52972 | 52972 | 2020-04-12 | Wagoner | Oklahoma | 40145 | 69 | 4 |
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);