ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where cases = 107 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 |
---|---|---|---|---|---|---|---|
890144 | 890144 | 2021-01-02 | Cimarron | Oklahoma | 40025 | 107 | 1 |
886897 | 886897 | 2021-01-01 | Cimarron | Oklahoma | 40025 | 107 | 1 |
883652 | 883652 | 2020-12-31 | Cimarron | Oklahoma | 40025 | 107 | 1 |
822049 | 822049 | 2020-12-12 | Unknown | Oklahoma | 107 | 0 | |
779818 | 779818 | 2020-11-29 | Harmon | Oklahoma | 40057 | 107 | 0 |
776573 | 776573 | 2020-11-28 | Harmon | Oklahoma | 40057 | 107 | 0 |
731135 | 731135 | 2020-11-14 | Harper | Oklahoma | 40059 | 107 | 2 |
727891 | 727891 | 2020-11-13 | Harper | Oklahoma | 40059 | 107 | 2 |
724682 | 724682 | 2020-11-12 | Roger Mills | Oklahoma | 40129 | 107 | 5 |
721408 | 721408 | 2020-11-11 | Jefferson | Oklahoma | 40067 | 107 | 1 |
585222 | 585222 | 2020-09-30 | Tillman | Oklahoma | 40141 | 107 | 2 |
533377 | 533377 | 2020-09-14 | Murray | Oklahoma | 40099 | 107 | 1 |
530142 | 530142 | 2020-09-13 | Murray | Oklahoma | 40099 | 107 | 1 |
523669 | 523669 | 2020-09-11 | Murray | Oklahoma | 40099 | 107 | 1 |
501015 | 501015 | 2020-09-04 | Johnston | Oklahoma | 40069 | 107 | 2 |
501033 | 501033 | 2020-09-04 | Nowata | Oklahoma | 40105 | 107 | 1 |
494567 | 494567 | 2020-09-02 | Okfuskee | Oklahoma | 40107 | 107 | 3 |
491331 | 491331 | 2020-09-01 | Noble | Oklahoma | 40103 | 107 | 2 |
488089 | 488089 | 2020-08-31 | Love | Oklahoma | 40085 | 107 | 0 |
478347 | 478347 | 2020-08-28 | Atoka | Oklahoma | 40005 | 107 | 1 |
475150 | 475150 | 2020-08-27 | Latimer | Oklahoma | 40077 | 107 | 2 |
471916 | 471916 | 2020-08-26 | Latimer | Oklahoma | 40077 | 107 | 2 |
468684 | 468684 | 2020-08-25 | Latimer | Oklahoma | 40077 | 107 | 2 |
420292 | 420292 | 2020-08-10 | Marshall | Oklahoma | 40095 | 107 | 1 |
417072 | 417072 | 2020-08-09 | Marshall | Oklahoma | 40095 | 107 | 1 |
413851 | 413851 | 2020-08-08 | Marshall | Oklahoma | 40095 | 107 | 1 |
410650 | 410650 | 2020-08-07 | Pushmataha | Oklahoma | 40127 | 107 | 0 |
391313 | 391313 | 2020-08-01 | Hughes | Oklahoma | 40063 | 107 | 1 |
391318 | 391318 | 2020-08-01 | Kingfisher | Oklahoma | 40073 | 107 | 0 |
375254 | 375254 | 2020-07-27 | Pawnee | Oklahoma | 40117 | 107 | 3 |
372042 | 372042 | 2020-07-26 | Pawnee | Oklahoma | 40117 | 107 | 3 |
346360 | 346360 | 2020-07-18 | Custer | Oklahoma | 40039 | 107 | 0 |
260893 | 260893 | 2020-06-21 | Adair | Oklahoma | 40001 | 107 | 4 |
260904 | 260904 | 2020-06-21 | Choctaw | Oklahoma | 40023 | 107 | 1 |
257778 | 257778 | 2020-06-20 | Choctaw | Oklahoma | 40023 | 107 | 1 |
254652 | 254652 | 2020-06-19 | Choctaw | Oklahoma | 40023 | 107 | 1 |
251537 | 251537 | 2020-06-18 | Choctaw | Oklahoma | 40023 | 107 | 1 |
235989 | 235989 | 2020-06-13 | Delaware | Oklahoma | 40041 | 107 | 16 |
232884 | 232884 | 2020-06-12 | Delaware | Oklahoma | 40041 | 107 | 16 |
214302 | 214302 | 2020-06-06 | Grady | Oklahoma | 40051 | 107 | 3 |
211216 | 211216 | 2020-06-05 | Grady | Oklahoma | 40051 | 107 | 3 |
208154 | 208154 | 2020-06-04 | McClain | Oklahoma | 40087 | 107 | 3 |
126246 | 126246 | 2020-05-08 | Canadian | Oklahoma | 40017 | 107 | 3 |
123263 | 123263 | 2020-05-07 | Canadian | Oklahoma | 40017 | 107 | 3 |
97312 | 97312 | 2020-04-28 | Texas | Oklahoma | 40139 | 107 | 1 |
66545 | 66545 | 2020-04-17 | Wagoner | Oklahoma | 40145 | 107 | 7 |
63800 | 63800 | 2020-04-16 | Wagoner | Oklahoma | 40145 | 107 | 7 |
17127 | 17127 | 2020-03-28 | Oklahoma | Oklahoma | 40109 | 107 | 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);