ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where cases = 80 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 |
---|---|---|---|---|---|---|---|
1906569 | 1906569 | 2021-11-11 | Unknown | Oklahoma | 80 | 0 | |
1903320 | 1903320 | 2021-11-10 | Unknown | Oklahoma | 80 | 0 | |
786292 | 786292 | 2020-12-01 | Cimarron | Oklahoma | 40025 | 80 | 0 |
783048 | 783048 | 2020-11-30 | Cimarron | Oklahoma | 40025 | 80 | 0 |
711673 | 711673 | 2020-11-08 | Harmon | Oklahoma | 40057 | 80 | 0 |
708429 | 708429 | 2020-11-07 | Harmon | Oklahoma | 40057 | 80 | 0 |
695456 | 695456 | 2020-11-03 | Harmon | Oklahoma | 40057 | 80 | 0 |
688971 | 688971 | 2020-11-01 | Harper | Oklahoma | 40059 | 80 | 2 |
672758 | 672758 | 2020-10-27 | Jefferson | Oklahoma | 40067 | 80 | 0 |
653287 | 653287 | 2020-10-21 | Grant | Oklahoma | 40053 | 80 | 1 |
650019 | 650019 | 2020-10-20 | Beaver | Oklahoma | 40007 | 80 | 0 |
646775 | 646775 | 2020-10-19 | Beaver | Oklahoma | 40007 | 80 | 0 |
559269 | 559269 | 2020-09-22 | Major | Oklahoma | 40093 | 80 | 1 |
429921 | 429921 | 2020-08-13 | Atoka | Oklahoma | 40005 | 80 | 0 |
407405 | 407405 | 2020-08-06 | Latimer | Oklahoma | 40077 | 80 | 1 |
394525 | 394525 | 2020-08-02 | Greer | Oklahoma | 40055 | 80 | 8 |
391309 | 391309 | 2020-08-01 | Greer | Oklahoma | 40055 | 80 | 7 |
388092 | 388092 | 2020-07-31 | Greer | Oklahoma | 40055 | 80 | 7 |
336812 | 336812 | 2020-07-15 | Seminole | Oklahoma | 40133 | 80 | 3 |
301845 | 301845 | 2020-07-04 | Ottawa | Oklahoma | 40115 | 80 | 2 |
273431 | 273431 | 2020-06-25 | Carter | Oklahoma | 40019 | 80 | 1 |
264055 | 264055 | 2020-06-22 | Kay | Oklahoma | 40071 | 80 | 7 |
260927 | 260927 | 2020-06-21 | Kay | Oklahoma | 40071 | 80 | 7 |
254701 | 254701 | 2020-06-19 | Pottawatomie | Oklahoma | 40125 | 80 | 4 |
251574 | 251574 | 2020-06-18 | Muskogee | Oklahoma | 40101 | 80 | 8 |
189732 | 189732 | 2020-05-29 | Rogers | Oklahoma | 40131 | 80 | 5 |
186671 | 186671 | 2020-05-28 | Rogers | Oklahoma | 40131 | 80 | 5 |
180528 | 180528 | 2020-05-26 | Grady | Oklahoma | 40051 | 80 | 3 |
117334 | 117334 | 2020-05-05 | Creek | Oklahoma | 40037 | 80 | 6 |
114453 | 114453 | 2020-05-04 | Creek | Oklahoma | 40037 | 80 | 6 |
111571 | 111571 | 2020-05-03 | Creek | Oklahoma | 40037 | 80 | 6 |
108697 | 108697 | 2020-05-02 | Creek | Oklahoma | 40037 | 80 | 6 |
105830 | 105830 | 2020-05-01 | Creek | Oklahoma | 40037 | 80 | 6 |
102964 | 102964 | 2020-04-30 | Comanche | Oklahoma | 40031 | 80 | 1 |
69256 | 69256 | 2020-04-18 | Delaware | Oklahoma | 40041 | 80 | 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);