ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
682 rows where fips = 40057 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637060 | 637060 | 2020-10-16 | Harmon | Oklahoma | 40057 | 62 | 0 |
633814 | 633814 | 2020-10-15 | Harmon | Oklahoma | 40057 | 61 | 0 |
630569 | 630569 | 2020-10-14 | Harmon | Oklahoma | 40057 | 61 | 0 |
627325 | 627325 | 2020-10-13 | Harmon | Oklahoma | 40057 | 61 | 0 |
624083 | 624083 | 2020-10-12 | Harmon | Oklahoma | 40057 | 59 | 0 |
620840 | 620840 | 2020-10-11 | Harmon | Oklahoma | 40057 | 59 | 0 |
617598 | 617598 | 2020-10-10 | Harmon | Oklahoma | 40057 | 59 | 0 |
614356 | 614356 | 2020-10-09 | Harmon | Oklahoma | 40057 | 57 | 0 |
611115 | 611115 | 2020-10-08 | Harmon | Oklahoma | 40057 | 54 | 0 |
607873 | 607873 | 2020-10-07 | Harmon | Oklahoma | 40057 | 53 | 0 |
604630 | 604630 | 2020-10-06 | Harmon | Oklahoma | 40057 | 53 | 0 |
601388 | 601388 | 2020-10-05 | Harmon | Oklahoma | 40057 | 52 | 0 |
598145 | 598145 | 2020-10-04 | Harmon | Oklahoma | 40057 | 51 | 0 |
594902 | 594902 | 2020-10-03 | Harmon | Oklahoma | 40057 | 50 | 0 |
591661 | 591661 | 2020-10-02 | Harmon | Oklahoma | 40057 | 50 | 0 |
588420 | 588420 | 2020-10-01 | Harmon | Oklahoma | 40057 | 46 | 0 |
585180 | 585180 | 2020-09-30 | Harmon | Oklahoma | 40057 | 46 | 0 |
581940 | 581940 | 2020-09-29 | Harmon | Oklahoma | 40057 | 44 | 0 |
578700 | 578700 | 2020-09-28 | Harmon | Oklahoma | 40057 | 44 | 0 |
575459 | 575459 | 2020-09-27 | Harmon | Oklahoma | 40057 | 43 | 0 |
572215 | 572215 | 2020-09-26 | Harmon | Oklahoma | 40057 | 43 | 0 |
568973 | 568973 | 2020-09-25 | Harmon | Oklahoma | 40057 | 43 | 0 |
565732 | 565732 | 2020-09-24 | Harmon | Oklahoma | 40057 | 43 | 0 |
562491 | 562491 | 2020-09-23 | Harmon | Oklahoma | 40057 | 43 | 0 |
559254 | 559254 | 2020-09-22 | Harmon | Oklahoma | 40057 | 43 | 0 |
556017 | 556017 | 2020-09-21 | Harmon | Oklahoma | 40057 | 43 | 0 |
552780 | 552780 | 2020-09-20 | Harmon | Oklahoma | 40057 | 43 | 0 |
549541 | 549541 | 2020-09-19 | Harmon | Oklahoma | 40057 | 43 | 0 |
546302 | 546302 | 2020-09-18 | Harmon | Oklahoma | 40057 | 43 | 0 |
543065 | 543065 | 2020-09-17 | Harmon | Oklahoma | 40057 | 43 | 0 |
539829 | 539829 | 2020-09-16 | Harmon | Oklahoma | 40057 | 44 | 0 |
536592 | 536592 | 2020-09-15 | Harmon | Oklahoma | 40057 | 43 | 0 |
533356 | 533356 | 2020-09-14 | Harmon | Oklahoma | 40057 | 43 | 0 |
530121 | 530121 | 2020-09-13 | Harmon | Oklahoma | 40057 | 43 | 0 |
526884 | 526884 | 2020-09-12 | Harmon | Oklahoma | 40057 | 43 | 0 |
523648 | 523648 | 2020-09-11 | Harmon | Oklahoma | 40057 | 43 | 0 |
520412 | 520412 | 2020-09-10 | Harmon | Oklahoma | 40057 | 40 | 0 |
517176 | 517176 | 2020-09-09 | Harmon | Oklahoma | 40057 | 40 | 0 |
513941 | 513941 | 2020-09-08 | Harmon | Oklahoma | 40057 | 40 | 0 |
510708 | 510708 | 2020-09-07 | Harmon | Oklahoma | 40057 | 40 | 0 |
507475 | 507475 | 2020-09-06 | Harmon | Oklahoma | 40057 | 40 | 0 |
504243 | 504243 | 2020-09-05 | Harmon | Oklahoma | 40057 | 40 | 0 |
501009 | 501009 | 2020-09-04 | Harmon | Oklahoma | 40057 | 40 | 0 |
497775 | 497775 | 2020-09-03 | Harmon | Oklahoma | 40057 | 40 | 0 |
494542 | 494542 | 2020-09-02 | Harmon | Oklahoma | 40057 | 40 | 0 |
491308 | 491308 | 2020-09-01 | Harmon | Oklahoma | 40057 | 39 | 0 |
488075 | 488075 | 2020-08-31 | Harmon | Oklahoma | 40057 | 39 | 0 |
484842 | 484842 | 2020-08-30 | Harmon | Oklahoma | 40057 | 39 | 0 |
481607 | 481607 | 2020-08-29 | Harmon | Oklahoma | 40057 | 38 | 0 |
478373 | 478373 | 2020-08-28 | Harmon | Oklahoma | 40057 | 37 | 0 |
475140 | 475140 | 2020-08-27 | Harmon | Oklahoma | 40057 | 37 | 0 |
471906 | 471906 | 2020-08-26 | Harmon | Oklahoma | 40057 | 37 | 0 |
468674 | 468674 | 2020-08-25 | Harmon | Oklahoma | 40057 | 37 | 0 |
465446 | 465446 | 2020-08-24 | Harmon | Oklahoma | 40057 | 37 | 0 |
462217 | 462217 | 2020-08-23 | Harmon | Oklahoma | 40057 | 37 | 0 |
458989 | 458989 | 2020-08-22 | Harmon | Oklahoma | 40057 | 36 | 0 |
455761 | 455761 | 2020-08-21 | Harmon | Oklahoma | 40057 | 36 | 0 |
452533 | 452533 | 2020-08-20 | Harmon | Oklahoma | 40057 | 32 | 0 |
449305 | 449305 | 2020-08-19 | Harmon | Oklahoma | 40057 | 32 | 0 |
446077 | 446077 | 2020-08-18 | Harmon | Oklahoma | 40057 | 32 | 0 |
442851 | 442851 | 2020-08-17 | Harmon | Oklahoma | 40057 | 32 | 0 |
439624 | 439624 | 2020-08-16 | Harmon | Oklahoma | 40057 | 32 | 0 |
436399 | 436399 | 2020-08-15 | Harmon | Oklahoma | 40057 | 32 | 0 |
433173 | 433173 | 2020-08-14 | Harmon | Oklahoma | 40057 | 32 | 0 |
429947 | 429947 | 2020-08-13 | Harmon | Oklahoma | 40057 | 32 | 0 |
426722 | 426722 | 2020-08-12 | Harmon | Oklahoma | 40057 | 32 | 0 |
423499 | 423499 | 2020-08-11 | Harmon | Oklahoma | 40057 | 32 | 0 |
420276 | 420276 | 2020-08-10 | Harmon | Oklahoma | 40057 | 32 | 0 |
417056 | 417056 | 2020-08-09 | Harmon | Oklahoma | 40057 | 32 | 0 |
413835 | 413835 | 2020-08-08 | Harmon | Oklahoma | 40057 | 27 | 0 |
410615 | 410615 | 2020-08-07 | Harmon | Oklahoma | 40057 | 27 | 0 |
407395 | 407395 | 2020-08-06 | Harmon | Oklahoma | 40057 | 27 | 0 |
404176 | 404176 | 2020-08-05 | Harmon | Oklahoma | 40057 | 27 | 0 |
400958 | 400958 | 2020-08-04 | Harmon | Oklahoma | 40057 | 25 | 0 |
397743 | 397743 | 2020-08-03 | Harmon | Oklahoma | 40057 | 25 | 0 |
394526 | 394526 | 2020-08-02 | Harmon | Oklahoma | 40057 | 24 | 0 |
391310 | 391310 | 2020-08-01 | Harmon | Oklahoma | 40057 | 24 | 0 |
388093 | 388093 | 2020-07-31 | Harmon | Oklahoma | 40057 | 22 | 0 |
384876 | 384876 | 2020-07-30 | Harmon | Oklahoma | 40057 | 15 | 0 |
381658 | 381658 | 2020-07-29 | Harmon | Oklahoma | 40057 | 12 | 0 |
378441 | 378441 | 2020-07-28 | Harmon | Oklahoma | 40057 | 9 | 0 |
375224 | 375224 | 2020-07-27 | Harmon | Oklahoma | 40057 | 5 | 0 |
372012 | 372012 | 2020-07-26 | Harmon | Oklahoma | 40057 | 5 | 0 |
368800 | 368800 | 2020-07-25 | Harmon | Oklahoma | 40057 | 5 | 0 |
365591 | 365591 | 2020-07-24 | Harmon | Oklahoma | 40057 | 5 | 0 |
362385 | 362385 | 2020-07-23 | Harmon | Oklahoma | 40057 | 4 | 0 |
359179 | 359179 | 2020-07-22 | Harmon | Oklahoma | 40057 | 4 | 0 |
355975 | 355975 | 2020-07-21 | Harmon | Oklahoma | 40057 | 4 | 0 |
352772 | 352772 | 2020-07-20 | Harmon | Oklahoma | 40057 | 4 | 0 |
349569 | 349569 | 2020-07-19 | Harmon | Oklahoma | 40057 | 4 | 0 |
346369 | 346369 | 2020-07-18 | Harmon | Oklahoma | 40057 | 4 | 0 |
343169 | 343169 | 2020-07-17 | Harmon | Oklahoma | 40057 | 4 | 0 |
339971 | 339971 | 2020-07-16 | Harmon | Oklahoma | 40057 | 4 | 0 |
336775 | 336775 | 2020-07-15 | Harmon | Oklahoma | 40057 | 4 | 0 |
333581 | 333581 | 2020-07-14 | Harmon | Oklahoma | 40057 | 3 | 0 |
330389 | 330389 | 2020-07-13 | Harmon | Oklahoma | 40057 | 3 | 0 |
327202 | 327202 | 2020-07-12 | Harmon | Oklahoma | 40057 | 3 | 0 |
324017 | 324017 | 2020-07-11 | Harmon | Oklahoma | 40057 | 3 | 0 |
320837 | 320837 | 2020-07-10 | Harmon | Oklahoma | 40057 | 3 | 0 |
317660 | 317660 | 2020-07-09 | Harmon | Oklahoma | 40057 | 3 | 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);