ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
771 rows where county = "Grant" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536590 | 536590 | 2020-09-15 | Grant | Oklahoma | 40053 | 33 | 0 |
533354 | 533354 | 2020-09-14 | Grant | Oklahoma | 40053 | 32 | 0 |
530119 | 530119 | 2020-09-13 | Grant | Oklahoma | 40053 | 32 | 0 |
526882 | 526882 | 2020-09-12 | Grant | Oklahoma | 40053 | 31 | 0 |
523646 | 523646 | 2020-09-11 | Grant | Oklahoma | 40053 | 32 | 0 |
520410 | 520410 | 2020-09-10 | Grant | Oklahoma | 40053 | 30 | 0 |
517174 | 517174 | 2020-09-09 | Grant | Oklahoma | 40053 | 30 | 0 |
513939 | 513939 | 2020-09-08 | Grant | Oklahoma | 40053 | 30 | 0 |
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 |
491306 | 491306 | 2020-09-01 | Grant | Oklahoma | 40053 | 25 | 0 |
488073 | 488073 | 2020-08-31 | Grant | Oklahoma | 40053 | 25 | 0 |
484840 | 484840 | 2020-08-30 | Grant | Oklahoma | 40053 | 24 | 0 |
481605 | 481605 | 2020-08-29 | Grant | Oklahoma | 40053 | 24 | 0 |
478371 | 478371 | 2020-08-28 | Grant | Oklahoma | 40053 | 23 | 0 |
475138 | 475138 | 2020-08-27 | Grant | Oklahoma | 40053 | 24 | 0 |
471904 | 471904 | 2020-08-26 | Grant | Oklahoma | 40053 | 23 | 0 |
468672 | 468672 | 2020-08-25 | Grant | Oklahoma | 40053 | 22 | 0 |
465444 | 465444 | 2020-08-24 | Grant | Oklahoma | 40053 | 21 | 0 |
462215 | 462215 | 2020-08-23 | Grant | Oklahoma | 40053 | 21 | 0 |
458987 | 458987 | 2020-08-22 | Grant | Oklahoma | 40053 | 20 | 0 |
455759 | 455759 | 2020-08-21 | Grant | Oklahoma | 40053 | 18 | 0 |
452531 | 452531 | 2020-08-20 | Grant | Oklahoma | 40053 | 18 | 0 |
449303 | 449303 | 2020-08-19 | Grant | Oklahoma | 40053 | 17 | 0 |
446075 | 446075 | 2020-08-18 | Grant | Oklahoma | 40053 | 17 | 0 |
442849 | 442849 | 2020-08-17 | Grant | Oklahoma | 40053 | 17 | 0 |
439622 | 439622 | 2020-08-16 | Grant | Oklahoma | 40053 | 17 | 0 |
436397 | 436397 | 2020-08-15 | Grant | Oklahoma | 40053 | 17 | 0 |
433171 | 433171 | 2020-08-14 | Grant | Oklahoma | 40053 | 17 | 0 |
429945 | 429945 | 2020-08-13 | Grant | Oklahoma | 40053 | 16 | 0 |
426720 | 426720 | 2020-08-12 | Grant | Oklahoma | 40053 | 16 | 0 |
423497 | 423497 | 2020-08-11 | Grant | Oklahoma | 40053 | 16 | 0 |
420274 | 420274 | 2020-08-10 | Grant | Oklahoma | 40053 | 15 | 0 |
417054 | 417054 | 2020-08-09 | Grant | Oklahoma | 40053 | 15 | 0 |
413833 | 413833 | 2020-08-08 | Grant | Oklahoma | 40053 | 15 | 0 |
410613 | 410613 | 2020-08-07 | Grant | Oklahoma | 40053 | 13 | 0 |
407393 | 407393 | 2020-08-06 | Grant | Oklahoma | 40053 | 12 | 0 |
404174 | 404174 | 2020-08-05 | Grant | Oklahoma | 40053 | 12 | 0 |
400956 | 400956 | 2020-08-04 | Grant | Oklahoma | 40053 | 12 | 0 |
397741 | 397741 | 2020-08-03 | Grant | Oklahoma | 40053 | 12 | 0 |
394524 | 394524 | 2020-08-02 | Grant | Oklahoma | 40053 | 11 | 0 |
391308 | 391308 | 2020-08-01 | Grant | Oklahoma | 40053 | 11 | 0 |
388091 | 388091 | 2020-07-31 | Grant | Oklahoma | 40053 | 11 | 0 |
384874 | 384874 | 2020-07-30 | Grant | Oklahoma | 40053 | 9 | 0 |
381656 | 381656 | 2020-07-29 | Grant | Oklahoma | 40053 | 9 | 0 |
378439 | 378439 | 2020-07-28 | Grant | Oklahoma | 40053 | 10 | 0 |
375222 | 375222 | 2020-07-27 | Grant | Oklahoma | 40053 | 7 | 0 |
372010 | 372010 | 2020-07-26 | Grant | Oklahoma | 40053 | 6 | 0 |
368798 | 368798 | 2020-07-25 | Grant | Oklahoma | 40053 | 6 | 0 |
365589 | 365589 | 2020-07-24 | Grant | Oklahoma | 40053 | 6 | 0 |
362383 | 362383 | 2020-07-23 | Grant | Oklahoma | 40053 | 5 | 0 |
359177 | 359177 | 2020-07-22 | Grant | Oklahoma | 40053 | 5 | 0 |
355973 | 355973 | 2020-07-21 | Grant | Oklahoma | 40053 | 5 | 0 |
352770 | 352770 | 2020-07-20 | Grant | Oklahoma | 40053 | 5 | 0 |
349567 | 349567 | 2020-07-19 | Grant | Oklahoma | 40053 | 4 | 0 |
346367 | 346367 | 2020-07-18 | Grant | Oklahoma | 40053 | 4 | 0 |
343167 | 343167 | 2020-07-17 | Grant | Oklahoma | 40053 | 3 | 0 |
339969 | 339969 | 2020-07-16 | Grant | Oklahoma | 40053 | 3 | 0 |
336773 | 336773 | 2020-07-15 | Grant | Oklahoma | 40053 | 3 | 0 |
333579 | 333579 | 2020-07-14 | Grant | Oklahoma | 40053 | 3 | 0 |
330387 | 330387 | 2020-07-13 | Grant | Oklahoma | 40053 | 3 | 0 |
327200 | 327200 | 2020-07-12 | Grant | Oklahoma | 40053 | 2 | 0 |
324015 | 324015 | 2020-07-11 | Grant | Oklahoma | 40053 | 2 | 0 |
320835 | 320835 | 2020-07-10 | Grant | Oklahoma | 40053 | 2 | 0 |
317658 | 317658 | 2020-07-09 | Grant | Oklahoma | 40053 | 2 | 0 |
314485 | 314485 | 2020-07-08 | Grant | Oklahoma | 40053 | 2 | 0 |
311313 | 311313 | 2020-07-07 | Grant | Oklahoma | 40053 | 2 | 0 |
308144 | 308144 | 2020-07-06 | Grant | Oklahoma | 40053 | 2 | 0 |
304977 | 304977 | 2020-07-05 | Grant | Oklahoma | 40053 | 2 | 0 |
301814 | 301814 | 2020-07-04 | Grant | Oklahoma | 40053 | 2 | 0 |
298651 | 298651 | 2020-07-03 | Grant | Oklahoma | 40053 | 2 | 0 |
295492 | 295492 | 2020-07-02 | Grant | Oklahoma | 40053 | 2 | 0 |
292336 | 292336 | 2020-07-01 | Grant | Oklahoma | 40053 | 2 | 0 |
289184 | 289184 | 2020-06-30 | Grant | Oklahoma | 40053 | 2 | 0 |
286034 | 286034 | 2020-06-29 | Grant | Oklahoma | 40053 | 2 | 0 |
282889 | 282889 | 2020-06-28 | Grant | Oklahoma | 40053 | 2 | 0 |
279743 | 279743 | 2020-06-27 | Grant | Oklahoma | 40053 | 2 | 0 |
276595 | 276595 | 2020-06-26 | Grant | Oklahoma | 40053 | 2 | 0 |
273448 | 273448 | 2020-06-25 | Grant | Oklahoma | 40053 | 2 | 0 |
270309 | 270309 | 2020-06-24 | Grant | Oklahoma | 40053 | 2 | 0 |
267175 | 267175 | 2020-06-23 | Grant | Oklahoma | 40053 | 2 | 0 |
264047 | 264047 | 2020-06-22 | Grant | Oklahoma | 40053 | 2 | 0 |
260919 | 260919 | 2020-06-21 | Grant | Oklahoma | 40053 | 2 | 0 |
257792 | 257792 | 2020-06-20 | Grant | Oklahoma | 40053 | 2 | 0 |
254666 | 254666 | 2020-06-19 | Grant | Oklahoma | 40053 | 2 | 0 |
251551 | 251551 | 2020-06-18 | Grant | Oklahoma | 40053 | 2 | 0 |
248436 | 248436 | 2020-06-17 | Grant | Oklahoma | 40053 | 2 | 0 |
245323 | 245323 | 2020-06-16 | Grant | Oklahoma | 40053 | 2 | 0 |
242211 | 242211 | 2020-06-15 | Grant | Oklahoma | 40053 | 2 | 0 |
239102 | 239102 | 2020-06-14 | Grant | Oklahoma | 40053 | 2 | 0 |
235994 | 235994 | 2020-06-13 | Grant | Oklahoma | 40053 | 2 | 0 |
232889 | 232889 | 2020-06-12 | Grant | Oklahoma | 40053 | 2 | 0 |
229784 | 229784 | 2020-06-11 | Grant | Oklahoma | 40053 | 2 | 0 |
226680 | 226680 | 2020-06-10 | Grant | Oklahoma | 40053 | 2 | 0 |
223580 | 223580 | 2020-06-09 | Grant | Oklahoma | 40053 | 2 | 0 |
220485 | 220485 | 2020-06-08 | Grant | Oklahoma | 40053 | 2 | 0 |
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);