ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 383 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2036543 | 2036543 | 2021-12-21 | Harmon | Oklahoma | 40057 | 383 | 9 |
2033293 | 2033293 | 2021-12-20 | Harmon | Oklahoma | 40057 | 383 | 9 |
2030043 | 2030043 | 2021-12-19 | Harmon | Oklahoma | 40057 | 383 | 9 |
2026792 | 2026792 | 2021-12-18 | Harmon | Oklahoma | 40057 | 383 | 9 |
2023541 | 2023541 | 2021-12-17 | Harmon | Oklahoma | 40057 | 383 | 9 |
2020290 | 2020290 | 2021-12-16 | Harmon | Oklahoma | 40057 | 383 | 9 |
2017039 | 2017039 | 2021-12-15 | Harmon | Oklahoma | 40057 | 383 | 9 |
2013789 | 2013789 | 2021-12-14 | Harmon | Oklahoma | 40057 | 383 | 9 |
2010538 | 2010538 | 2021-12-13 | Harmon | Oklahoma | 40057 | 383 | 9 |
2007287 | 2007287 | 2021-12-12 | Harmon | Oklahoma | 40057 | 383 | 9 |
2004036 | 2004036 | 2021-12-11 | Harmon | Oklahoma | 40057 | 383 | 9 |
2000785 | 2000785 | 2021-12-10 | Harmon | Oklahoma | 40057 | 383 | 9 |
1997535 | 1997535 | 2021-12-09 | Harmon | Oklahoma | 40057 | 383 | 9 |
1994284 | 1994284 | 2021-12-08 | Harmon | Oklahoma | 40057 | 383 | 9 |
1094665 | 1094665 | 2021-03-06 | Roger Mills | Oklahoma | 40129 | 383 | 7 |
1091419 | 1091419 | 2021-03-05 | Roger Mills | Oklahoma | 40129 | 383 | 7 |
1088173 | 1088173 | 2021-03-04 | Roger Mills | Oklahoma | 40129 | 383 | 7 |
1084928 | 1084928 | 2021-03-03 | Roger Mills | Oklahoma | 40129 | 383 | 7 |
981003 | 981003 | 2021-01-30 | Beaver | Oklahoma | 40007 | 383 | 4 |
955068 | 955068 | 2021-01-22 | Harper | Oklahoma | 40059 | 383 | 3 |
890159 | 890159 | 2021-01-02 | Greer | Oklahoma | 40055 | 383 | 9 |
854451 | 854451 | 2020-12-22 | Cotton | Oklahoma | 40033 | 383 | 9 |
854456 | 854456 | 2020-12-22 | Dewey | Oklahoma | 40043 | 383 | 3 |
611135 | 611135 | 2020-10-08 | McIntosh | Oklahoma | 40091 | 383 | 8 |
517183 | 517183 | 2020-09-09 | Kay | Oklahoma | 40071 | 383 | 12 |
455778 | 455778 | 2020-08-21 | Mayes | Oklahoma | 40097 | 383 | 8 |
442823 | 442823 | 2020-08-17 | Adair | Oklahoma | 40001 | 383 | 6 |
426754 | 426754 | 2020-08-12 | Pittsburg | Oklahoma | 40121 | 383 | 4 |
400937 | 400937 | 2020-08-04 | Caddo | Oklahoma | 40015 | 383 | 14 |
391344 | 391344 | 2020-08-01 | Pottawatomie | Oklahoma | 40125 | 383 | 7 |
388111 | 388111 | 2020-07-31 | McClain | Oklahoma | 40087 | 383 | 4 |
375228 | 375228 | 2020-07-27 | Jackson | Oklahoma | 40065 | 383 | 3 |
273437 | 273437 | 2020-06-25 | Comanche | Oklahoma | 40031 | 383 | 5 |
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);