ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
640 rows where county = "Unknown" and state = "Oklahoma" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
25457 | 25457 | 2020-04-01 | Unknown | Oklahoma | 0 | 1 | |
289228 | 289228 | 2020-06-30 | Unknown | Oklahoma | 1 | 0 | |
340014 | 340014 | 2020-07-16 | Unknown | Oklahoma | 2 | 0 | |
375268 | 375268 | 2020-07-27 | Unknown | Oklahoma | 1 | 0 | |
436443 | 436443 | 2020-08-15 | Unknown | Oklahoma | 4 | 0 | |
439668 | 439668 | 2020-08-16 | Unknown | Oklahoma | 7 | 0 | |
442895 | 442895 | 2020-08-17 | Unknown | Oklahoma | 2 | 0 | |
446121 | 446121 | 2020-08-18 | Unknown | Oklahoma | 1 | 0 | |
449349 | 449349 | 2020-08-19 | Unknown | Oklahoma | 7 | 0 | |
452577 | 452577 | 2020-08-20 | Unknown | Oklahoma | 17 | 0 | |
455805 | 455805 | 2020-08-21 | Unknown | Oklahoma | 17 | 0 | |
459033 | 459033 | 2020-08-22 | Unknown | Oklahoma | 11 | 0 | |
462261 | 462261 | 2020-08-23 | Unknown | Oklahoma | 6 | 0 | |
465490 | 465490 | 2020-08-24 | Unknown | Oklahoma | 11 | 0 | |
468718 | 468718 | 2020-08-25 | Unknown | Oklahoma | 7 | 0 | |
471950 | 471950 | 2020-08-26 | Unknown | Oklahoma | 8 | 0 | |
475184 | 475184 | 2020-08-27 | Unknown | Oklahoma | 18 | 0 | |
478417 | 478417 | 2020-08-28 | Unknown | Oklahoma | 21 | 0 | |
481651 | 481651 | 2020-08-29 | Unknown | Oklahoma | 103 | 0 | |
484886 | 484886 | 2020-08-30 | Unknown | Oklahoma | 4 | 0 | |
488119 | 488119 | 2020-08-31 | Unknown | Oklahoma | 82 | 0 | |
491352 | 491352 | 2020-09-01 | Unknown | Oklahoma | 60 | 0 | |
494586 | 494586 | 2020-09-02 | Unknown | Oklahoma | 15 | 0 | |
497819 | 497819 | 2020-09-03 | Unknown | Oklahoma | 40 | 0 | |
501053 | 501053 | 2020-09-04 | Unknown | Oklahoma | 54 | 0 | |
504287 | 504287 | 2020-09-05 | Unknown | Oklahoma | 45 | 0 | |
507519 | 507519 | 2020-09-06 | Unknown | Oklahoma | 41 | 0 | |
510752 | 510752 | 2020-09-07 | Unknown | Oklahoma | 40 | 0 | |
513985 | 513985 | 2020-09-08 | Unknown | Oklahoma | 45 | 0 | |
517220 | 517220 | 2020-09-09 | Unknown | Oklahoma | 55 | 0 | |
520456 | 520456 | 2020-09-10 | Unknown | Oklahoma | 16 | 0 | |
523692 | 523692 | 2020-09-11 | Unknown | Oklahoma | 17 | 0 | |
526928 | 526928 | 2020-09-12 | Unknown | Oklahoma | 45 | 0 | |
530165 | 530165 | 2020-09-13 | Unknown | Oklahoma | 47 | 0 | |
533400 | 533400 | 2020-09-14 | Unknown | Oklahoma | 47 | 0 | |
536636 | 536636 | 2020-09-15 | Unknown | Oklahoma | 56 | 0 | |
539873 | 539873 | 2020-09-16 | Unknown | Oklahoma | 56 | 0 | |
543109 | 543109 | 2020-09-17 | Unknown | Oklahoma | 61 | 0 | |
546346 | 546346 | 2020-09-18 | Unknown | Oklahoma | 51 | 0 | |
549585 | 549585 | 2020-09-19 | Unknown | Oklahoma | 70 | 0 | |
552824 | 552824 | 2020-09-20 | Unknown | Oklahoma | 70 | 0 | |
556061 | 556061 | 2020-09-21 | Unknown | Oklahoma | 75 | 0 | |
559298 | 559298 | 2020-09-22 | Unknown | Oklahoma | 58 | 0 | |
562535 | 562535 | 2020-09-23 | Unknown | Oklahoma | 54 | 0 | |
565776 | 565776 | 2020-09-24 | Unknown | Oklahoma | 51 | 0 | |
569017 | 569017 | 2020-09-25 | Unknown | Oklahoma | 62 | 0 | |
572259 | 572259 | 2020-09-26 | Unknown | Oklahoma | 50 | 0 | |
575503 | 575503 | 2020-09-27 | Unknown | Oklahoma | 51 | 0 | |
578744 | 578744 | 2020-09-28 | Unknown | Oklahoma | 51 | 0 | |
581984 | 581984 | 2020-09-29 | Unknown | Oklahoma | 23 | 0 | |
585224 | 585224 | 2020-09-30 | Unknown | Oklahoma | 29 | 0 | |
588464 | 588464 | 2020-10-01 | Unknown | Oklahoma | 11 | 0 | |
591705 | 591705 | 2020-10-02 | Unknown | Oklahoma | 16 | 0 | |
594946 | 594946 | 2020-10-03 | Unknown | Oklahoma | 30 | 0 | |
598189 | 598189 | 2020-10-04 | Unknown | Oklahoma | 24 | 0 | |
601432 | 601432 | 2020-10-05 | Unknown | Oklahoma | 39 | 0 | |
604674 | 604674 | 2020-10-06 | Unknown | Oklahoma | 42 | 0 | |
607917 | 607917 | 2020-10-07 | Unknown | Oklahoma | 36 | 0 | |
611159 | 611159 | 2020-10-08 | Unknown | Oklahoma | 25 | 0 | |
614400 | 614400 | 2020-10-09 | Unknown | Oklahoma | 33 | 0 | |
617642 | 617642 | 2020-10-10 | Unknown | Oklahoma | 39 | 0 | |
620884 | 620884 | 2020-10-11 | Unknown | Oklahoma | 23 | 0 | |
624127 | 624127 | 2020-10-12 | Unknown | Oklahoma | 32 | 0 | |
627369 | 627369 | 2020-10-13 | Unknown | Oklahoma | 21 | 0 | |
630613 | 630613 | 2020-10-14 | Unknown | Oklahoma | 26 | 0 | |
633858 | 633858 | 2020-10-15 | Unknown | Oklahoma | 21 | 0 | |
637104 | 637104 | 2020-10-16 | Unknown | Oklahoma | 17 | 0 | |
640350 | 640350 | 2020-10-17 | Unknown | Oklahoma | 21 | 0 | |
643598 | 643598 | 2020-10-18 | Unknown | Oklahoma | 21 | 0 | |
646844 | 646844 | 2020-10-19 | Unknown | Oklahoma | 21 | 0 | |
650088 | 650088 | 2020-10-20 | Unknown | Oklahoma | 15 | 0 | |
653333 | 653333 | 2020-10-21 | Unknown | Oklahoma | 8 | 0 | |
656578 | 656578 | 2020-10-22 | Unknown | Oklahoma | 7 | 0 | |
659822 | 659822 | 2020-10-23 | Unknown | Oklahoma | 12 | 0 | |
663066 | 663066 | 2020-10-24 | Unknown | Oklahoma | 8 | 0 | |
666311 | 666311 | 2020-10-25 | Unknown | Oklahoma | 6 | 0 | |
669555 | 669555 | 2020-10-26 | Unknown | Oklahoma | 6 | 0 | |
672797 | 672797 | 2020-10-27 | Unknown | Oklahoma | 6 | 0 | |
676040 | 676040 | 2020-10-28 | Unknown | Oklahoma | 9 | 0 | |
679283 | 679283 | 2020-10-29 | Unknown | Oklahoma | 3 | 0 | |
682526 | 682526 | 2020-10-30 | Unknown | Oklahoma | 5 | 0 | |
685769 | 685769 | 2020-10-31 | Unknown | Oklahoma | 5 | 0 | |
689014 | 689014 | 2020-11-01 | Unknown | Oklahoma | 3 | 0 | |
692258 | 692258 | 2020-11-02 | Unknown | Oklahoma | 9 | 0 | |
695500 | 695500 | 2020-11-03 | Unknown | Oklahoma | 16 | 0 | |
698743 | 698743 | 2020-11-04 | Unknown | Oklahoma | 19 | 0 | |
701987 | 701987 | 2020-11-05 | Unknown | Oklahoma | 26 | 0 | |
705230 | 705230 | 2020-11-06 | Unknown | Oklahoma | 30 | 0 | |
708473 | 708473 | 2020-11-07 | Unknown | Oklahoma | 92 | 0 | |
711717 | 711717 | 2020-11-08 | Unknown | Oklahoma | 92 | 0 | |
714961 | 714961 | 2020-11-09 | Unknown | Oklahoma | 87 | 0 | |
718204 | 718204 | 2020-11-10 | Unknown | Oklahoma | 62 | 0 | |
721447 | 721447 | 2020-11-11 | Unknown | Oklahoma | 38 | 0 | |
724690 | 724690 | 2020-11-12 | Unknown | Oklahoma | 25 | 0 | |
727934 | 727934 | 2020-11-13 | Unknown | Oklahoma | 32 | 0 | |
731178 | 731178 | 2020-11-14 | Unknown | Oklahoma | 39 | 0 | |
734424 | 734424 | 2020-11-15 | Unknown | Oklahoma | 57 | 0 | |
737668 | 737668 | 2020-11-16 | Unknown | Oklahoma | 75 | 0 | |
740914 | 740914 | 2020-11-17 | Unknown | Oklahoma | 78 | 0 | |
744161 | 744161 | 2020-11-18 | Unknown | Oklahoma | 103 | 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);