ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where cases = 27 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
607857 | 607857 | 2020-10-07 | Cimarron | Oklahoma | 40025 | 27 | 0 |
601372 | 601372 | 2020-10-05 | Cimarron | Oklahoma | 40025 | 27 | 0 |
598129 | 598129 | 2020-10-04 | Cimarron | Oklahoma | 40025 | 27 | 0 |
594886 | 594886 | 2020-10-03 | Cimarron | Oklahoma | 40025 | 27 | 0 |
591645 | 591645 | 2020-10-02 | Cimarron | Oklahoma | 40025 | 27 | 0 |
588404 | 588404 | 2020-10-01 | Cimarron | Oklahoma | 40025 | 27 | 0 |
562492 | 562492 | 2020-09-23 | Harper | Oklahoma | 40059 | 27 | 1 |
520405 | 520405 | 2020-09-10 | Dewey | Oklahoma | 40043 | 27 | 1 |
510706 | 510706 | 2020-09-07 | Grant | Oklahoma | 40053 | 27 | 0 |
507473 | 507473 | 2020-09-06 | Grant | Oklahoma | 40053 | 27 | 0 |
504241 | 504241 | 2020-09-05 | Grant | Oklahoma | 40053 | 27 | 0 |
501007 | 501007 | 2020-09-04 | Grant | Oklahoma | 40053 | 27 | 0 |
497773 | 497773 | 2020-09-03 | Grant | Oklahoma | 40053 | 27 | 0 |
494540 | 494540 | 2020-09-02 | Grant | Oklahoma | 40053 | 27 | 0 |
417102 | 417102 | 2020-08-09 | Washita | Oklahoma | 40149 | 27 | 0 |
413835 | 413835 | 2020-08-08 | Harmon | Oklahoma | 40057 | 27 | 0 |
413844 | 413844 | 2020-08-08 | Kiowa | Oklahoma | 40075 | 27 | 1 |
413881 | 413881 | 2020-08-08 | Washita | Oklahoma | 40149 | 27 | 0 |
410615 | 410615 | 2020-08-07 | Harmon | Oklahoma | 40057 | 27 | 0 |
410624 | 410624 | 2020-08-07 | Kiowa | Oklahoma | 40075 | 27 | 1 |
410661 | 410661 | 2020-08-07 | Washita | Oklahoma | 40149 | 27 | 0 |
407395 | 407395 | 2020-08-06 | Harmon | Oklahoma | 40057 | 27 | 0 |
407404 | 407404 | 2020-08-06 | Kiowa | Oklahoma | 40075 | 27 | 1 |
407410 | 407410 | 2020-08-06 | Major | Oklahoma | 40093 | 27 | 1 |
404176 | 404176 | 2020-08-05 | Harmon | Oklahoma | 40057 | 27 | 0 |
404185 | 404185 | 2020-08-05 | Kiowa | Oklahoma | 40075 | 27 | 1 |
400967 | 400967 | 2020-08-04 | Kiowa | Oklahoma | 40075 | 27 | 1 |
397729 | 397729 | 2020-08-03 | Coal | Oklahoma | 40029 | 27 | 0 |
397752 | 397752 | 2020-08-03 | Kiowa | Oklahoma | 40075 | 27 | 1 |
394512 | 394512 | 2020-08-02 | Coal | Oklahoma | 40029 | 27 | 0 |
394535 | 394535 | 2020-08-02 | Kiowa | Oklahoma | 40075 | 27 | 1 |
391319 | 391319 | 2020-08-01 | Kiowa | Oklahoma | 40075 | 27 | 1 |
384862 | 384862 | 2020-07-30 | Coal | Oklahoma | 40029 | 27 | 0 |
384881 | 384881 | 2020-07-30 | Jefferson | Oklahoma | 40067 | 27 | 0 |
381644 | 381644 | 2020-07-29 | Coal | Oklahoma | 40029 | 27 | 0 |
378427 | 378427 | 2020-07-28 | Coal | Oklahoma | 40029 | 27 | 0 |
378446 | 378446 | 2020-07-28 | Jefferson | Oklahoma | 40067 | 27 | 0 |
375229 | 375229 | 2020-07-27 | Jefferson | Oklahoma | 40067 | 27 | 0 |
372014 | 372014 | 2020-07-26 | Haskell | Oklahoma | 40061 | 27 | 0 |
372017 | 372017 | 2020-07-26 | Jefferson | Oklahoma | 40067 | 27 | 0 |
368777 | 368777 | 2020-07-25 | Blaine | Oklahoma | 40011 | 27 | 0 |
368848 | 368848 | 2020-07-25 | Woodward | Oklahoma | 40153 | 27 | 0 |
365567 | 365567 | 2020-07-24 | Beckham | Oklahoma | 40009 | 27 | 0 |
365597 | 365597 | 2020-07-24 | Johnston | Oklahoma | 40069 | 27 | 0 |
365639 | 365639 | 2020-07-24 | Woodward | Oklahoma | 40153 | 27 | 0 |
362361 | 362361 | 2020-07-23 | Beckham | Oklahoma | 40009 | 27 | 0 |
359155 | 359155 | 2020-07-22 | Beckham | Oklahoma | 40009 | 27 | 0 |
355951 | 355951 | 2020-07-21 | Beckham | Oklahoma | 40009 | 27 | 0 |
355985 | 355985 | 2020-07-21 | Latimer | Oklahoma | 40077 | 27 | 1 |
352748 | 352748 | 2020-07-20 | Beckham | Oklahoma | 40009 | 27 | 0 |
349545 | 349545 | 2020-07-19 | Beckham | Oklahoma | 40009 | 27 | 0 |
346345 | 346345 | 2020-07-18 | Beckham | Oklahoma | 40009 | 27 | 0 |
336816 | 336816 | 2020-07-15 | Tillman | Oklahoma | 40141 | 27 | 1 |
333570 | 333570 | 2020-07-14 | Craig | Oklahoma | 40035 | 27 | 0 |
330378 | 330378 | 2020-07-13 | Craig | Oklahoma | 40035 | 27 | 0 |
327191 | 327191 | 2020-07-12 | Craig | Oklahoma | 40035 | 27 | 0 |
324006 | 324006 | 2020-07-11 | Craig | Oklahoma | 40035 | 27 | 0 |
320826 | 320826 | 2020-07-10 | Craig | Oklahoma | 40035 | 27 | 0 |
308120 | 308120 | 2020-07-06 | Atoka | Oklahoma | 40005 | 27 | 0 |
295502 | 295502 | 2020-07-02 | Kingfisher | Oklahoma | 40073 | 27 | 0 |
286043 | 286043 | 2020-06-29 | Kingfisher | Oklahoma | 40073 | 27 | 0 |
282898 | 282898 | 2020-06-28 | Kingfisher | Oklahoma | 40073 | 27 | 0 |
273463 | 273463 | 2020-06-25 | Love | Oklahoma | 40085 | 27 | 0 |
270324 | 270324 | 2020-06-24 | Love | Oklahoma | 40085 | 27 | 0 |
267214 | 267214 | 2020-06-23 | Sequoyah | Oklahoma | 40135 | 27 | 3 |
264059 | 264059 | 2020-06-22 | Le Flore | Oklahoma | 40079 | 27 | 1 |
264060 | 264060 | 2020-06-22 | Lincoln | Oklahoma | 40081 | 27 | 2 |
264081 | 264081 | 2020-06-22 | Pontotoc | Oklahoma | 40123 | 27 | 2 |
260931 | 260931 | 2020-06-21 | Le Flore | Oklahoma | 40079 | 27 | 1 |
260953 | 260953 | 2020-06-21 | Pontotoc | Oklahoma | 40123 | 27 | 2 |
257817 | 257817 | 2020-06-20 | Nowata | Oklahoma | 40105 | 27 | 1 |
254687 | 254687 | 2020-06-19 | McIntosh | Oklahoma | 40091 | 27 | 1 |
254691 | 254691 | 2020-06-19 | Nowata | Oklahoma | 40105 | 27 | 1 |
251576 | 251576 | 2020-06-18 | Nowata | Oklahoma | 40105 | 27 | 1 |
245336 | 245336 | 2020-06-16 | Lincoln | Oklahoma | 40081 | 27 | 2 |
226658 | 226658 | 2020-06-10 | Beaver | Oklahoma | 40007 | 27 | 0 |
223558 | 223558 | 2020-06-09 | Beaver | Oklahoma | 40007 | 27 | 0 |
220463 | 220463 | 2020-06-08 | Beaver | Oklahoma | 40007 | 27 | 0 |
220513 | 220513 | 2020-06-08 | Okmulgee | Oklahoma | 40111 | 27 | 0 |
217371 | 217371 | 2020-06-07 | Beaver | Oklahoma | 40007 | 27 | 0 |
214308 | 214308 | 2020-06-06 | Jackson | Oklahoma | 40065 | 27 | 3 |
211222 | 211222 | 2020-06-05 | Jackson | Oklahoma | 40065 | 27 | 3 |
208140 | 208140 | 2020-06-04 | Jackson | Oklahoma | 40065 | 27 | 3 |
205051 | 205051 | 2020-06-03 | Garfield | Oklahoma | 40047 | 27 | 1 |
205059 | 205059 | 2020-06-03 | Jackson | Oklahoma | 40065 | 27 | 3 |
201974 | 201974 | 2020-06-02 | Garfield | Oklahoma | 40047 | 27 | 1 |
201982 | 201982 | 2020-06-02 | Jackson | Oklahoma | 40065 | 27 | 3 |
198907 | 198907 | 2020-06-01 | Jackson | Oklahoma | 40065 | 27 | 3 |
195834 | 195834 | 2020-05-31 | Jackson | Oklahoma | 40065 | 27 | 3 |
192757 | 192757 | 2020-05-30 | Garfield | Oklahoma | 40047 | 27 | 1 |
192765 | 192765 | 2020-05-30 | Jackson | Oklahoma | 40065 | 27 | 3 |
183564 | 183564 | 2020-05-27 | Choctaw | Oklahoma | 40023 | 27 | 0 |
147230 | 147230 | 2020-05-15 | Mayes | Oklahoma | 40097 | 27 | 4 |
120324 | 120324 | 2020-05-06 | Muskogee | Oklahoma | 40101 | 27 | 6 |
117363 | 117363 | 2020-05-05 | Muskogee | Oklahoma | 40101 | 27 | 6 |
114446 | 114446 | 2020-05-04 | Cherokee | Oklahoma | 40021 | 27 | 1 |
114482 | 114482 | 2020-05-04 | Muskogee | Oklahoma | 40101 | 27 | 6 |
111564 | 111564 | 2020-05-03 | Cherokee | Oklahoma | 40021 | 27 | 1 |
111600 | 111600 | 2020-05-03 | Muskogee | Oklahoma | 40101 | 27 | 6 |
108690 | 108690 | 2020-05-02 | Cherokee | Oklahoma | 40021 | 27 | 1 |
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);