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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922657 | 922657 | 2021-01-12 | Unknown | Oklahoma | 99 | 0 | |
919412 | 919412 | 2021-01-11 | Unknown | Oklahoma | 99 | 0 | |
916167 | 916167 | 2021-01-10 | Unknown | Oklahoma | 100 | 0 | |
912922 | 912922 | 2021-01-09 | Unknown | Oklahoma | 101 | 0 | |
909677 | 909677 | 2021-01-08 | Unknown | Oklahoma | 182 | 0 | |
906432 | 906432 | 2021-01-07 | Unknown | Oklahoma | 423 | 0 | |
903186 | 903186 | 2021-01-06 | Unknown | Oklahoma | 461 | 0 | |
899941 | 899941 | 2021-01-05 | Unknown | Oklahoma | 456 | 0 | |
896696 | 896696 | 2021-01-04 | Unknown | Oklahoma | 456 | 0 | |
893450 | 893450 | 2021-01-03 | Unknown | Oklahoma | 460 | 0 | |
890204 | 890204 | 2021-01-02 | Unknown | Oklahoma | 296 | 0 | |
886957 | 886957 | 2021-01-01 | Unknown | Oklahoma | 236 | 0 | |
883712 | 883712 | 2020-12-31 | Unknown | Oklahoma | 236 | 0 | |
880467 | 880467 | 2020-12-30 | Unknown | Oklahoma | 222 | 0 | |
877222 | 877222 | 2020-12-29 | Unknown | Oklahoma | 209 | 0 | |
873977 | 873977 | 2020-12-28 | Unknown | Oklahoma | 184 | 0 | |
870732 | 870732 | 2020-12-27 | Unknown | Oklahoma | 153 | 0 | |
867487 | 867487 | 2020-12-26 | Unknown | Oklahoma | 137 | 0 | |
864242 | 864242 | 2020-12-25 | Unknown | Oklahoma | 124 | 0 | |
860997 | 860997 | 2020-12-24 | Unknown | Oklahoma | 124 | 0 | |
857752 | 857752 | 2020-12-23 | Unknown | Oklahoma | 105 | 0 | |
854507 | 854507 | 2020-12-22 | Unknown | Oklahoma | 97 | 0 | |
851262 | 851262 | 2020-12-21 | Unknown | Oklahoma | 92 | 0 | |
848017 | 848017 | 2020-12-20 | Unknown | Oklahoma | 90 | 0 | |
844772 | 844772 | 2020-12-19 | Unknown | Oklahoma | 67 | 0 | |
841526 | 841526 | 2020-12-18 | Unknown | Oklahoma | 74 | 0 | |
838281 | 838281 | 2020-12-17 | Unknown | Oklahoma | 86 | 0 | |
835035 | 835035 | 2020-12-16 | Unknown | Oklahoma | 70 | 0 | |
831789 | 831789 | 2020-12-15 | Unknown | Oklahoma | 78 | 0 | |
828542 | 828542 | 2020-12-14 | Unknown | Oklahoma | 94 | 0 | |
825296 | 825296 | 2020-12-13 | Unknown | Oklahoma | 114 | 0 | |
822049 | 822049 | 2020-12-12 | Unknown | Oklahoma | 107 | 0 | |
818803 | 818803 | 2020-12-11 | Unknown | Oklahoma | 75 | 0 | |
815557 | 815557 | 2020-12-10 | Unknown | Oklahoma | 60 | 0 | |
812311 | 812311 | 2020-12-09 | Unknown | Oklahoma | 68 | 0 | |
809067 | 809067 | 2020-12-08 | Unknown | Oklahoma | 58 | 0 | |
805822 | 805822 | 2020-12-07 | Unknown | Oklahoma | 58 | 0 | |
802577 | 802577 | 2020-12-06 | Unknown | Oklahoma | 58 | 0 | |
799332 | 799332 | 2020-12-05 | Unknown | Oklahoma | 66 | 0 | |
796087 | 796087 | 2020-12-04 | Unknown | Oklahoma | 71 | 0 | |
792842 | 792842 | 2020-12-03 | Unknown | Oklahoma | 84 | 0 | |
789597 | 789597 | 2020-12-02 | Unknown | Oklahoma | 65 | 0 | |
786352 | 786352 | 2020-12-01 | Unknown | Oklahoma | 55 | 0 | |
783108 | 783108 | 2020-11-30 | Unknown | Oklahoma | 55 | 0 | |
779862 | 779862 | 2020-11-29 | Unknown | Oklahoma | 44 | 0 | |
776617 | 776617 | 2020-11-28 | Unknown | Oklahoma | 72 | 0 | |
773372 | 773372 | 2020-11-27 | Unknown | Oklahoma | 76 | 0 | |
770127 | 770127 | 2020-11-26 | Unknown | Oklahoma | 71 | 0 | |
766881 | 766881 | 2020-11-25 | Unknown | Oklahoma | 71 | 0 | |
763636 | 763636 | 2020-11-24 | Unknown | Oklahoma | 57 | 0 | |
760391 | 760391 | 2020-11-23 | Unknown | Oklahoma | 65 | 0 | |
757146 | 757146 | 2020-11-22 | Unknown | Oklahoma | 62 | 0 | |
753899 | 753899 | 2020-11-21 | Unknown | Oklahoma | 89 | 0 | |
750653 | 750653 | 2020-11-20 | Unknown | Oklahoma | 87 | 0 | |
747407 | 747407 | 2020-11-19 | Unknown | Oklahoma | 127 | 0 | |
744161 | 744161 | 2020-11-18 | Unknown | Oklahoma | 103 | 0 | |
740914 | 740914 | 2020-11-17 | Unknown | Oklahoma | 78 | 0 | |
737668 | 737668 | 2020-11-16 | Unknown | Oklahoma | 75 | 0 | |
734424 | 734424 | 2020-11-15 | Unknown | Oklahoma | 57 | 0 | |
731178 | 731178 | 2020-11-14 | Unknown | Oklahoma | 39 | 0 | |
727934 | 727934 | 2020-11-13 | Unknown | Oklahoma | 32 | 0 | |
724690 | 724690 | 2020-11-12 | Unknown | Oklahoma | 25 | 0 | |
721447 | 721447 | 2020-11-11 | Unknown | Oklahoma | 38 | 0 | |
718204 | 718204 | 2020-11-10 | Unknown | Oklahoma | 62 | 0 | |
714961 | 714961 | 2020-11-09 | Unknown | Oklahoma | 87 | 0 | |
711717 | 711717 | 2020-11-08 | Unknown | Oklahoma | 92 | 0 | |
708473 | 708473 | 2020-11-07 | Unknown | Oklahoma | 92 | 0 | |
705230 | 705230 | 2020-11-06 | Unknown | Oklahoma | 30 | 0 | |
701987 | 701987 | 2020-11-05 | Unknown | Oklahoma | 26 | 0 | |
698743 | 698743 | 2020-11-04 | Unknown | Oklahoma | 19 | 0 | |
695500 | 695500 | 2020-11-03 | Unknown | Oklahoma | 16 | 0 | |
692258 | 692258 | 2020-11-02 | Unknown | Oklahoma | 9 | 0 | |
689014 | 689014 | 2020-11-01 | Unknown | Oklahoma | 3 | 0 | |
685769 | 685769 | 2020-10-31 | Unknown | Oklahoma | 5 | 0 | |
682526 | 682526 | 2020-10-30 | Unknown | Oklahoma | 5 | 0 | |
679283 | 679283 | 2020-10-29 | Unknown | Oklahoma | 3 | 0 | |
676040 | 676040 | 2020-10-28 | Unknown | Oklahoma | 9 | 0 | |
672797 | 672797 | 2020-10-27 | Unknown | Oklahoma | 6 | 0 | |
669555 | 669555 | 2020-10-26 | Unknown | Oklahoma | 6 | 0 | |
666311 | 666311 | 2020-10-25 | Unknown | Oklahoma | 6 | 0 | |
663066 | 663066 | 2020-10-24 | Unknown | Oklahoma | 8 | 0 | |
659822 | 659822 | 2020-10-23 | Unknown | Oklahoma | 12 | 0 | |
656578 | 656578 | 2020-10-22 | Unknown | Oklahoma | 7 | 0 | |
653333 | 653333 | 2020-10-21 | Unknown | Oklahoma | 8 | 0 | |
650088 | 650088 | 2020-10-20 | Unknown | Oklahoma | 15 | 0 | |
646844 | 646844 | 2020-10-19 | Unknown | Oklahoma | 21 | 0 | |
643598 | 643598 | 2020-10-18 | Unknown | Oklahoma | 21 | 0 | |
640350 | 640350 | 2020-10-17 | Unknown | Oklahoma | 21 | 0 | |
637104 | 637104 | 2020-10-16 | Unknown | Oklahoma | 17 | 0 | |
633858 | 633858 | 2020-10-15 | Unknown | Oklahoma | 21 | 0 | |
630613 | 630613 | 2020-10-14 | Unknown | Oklahoma | 26 | 0 | |
627369 | 627369 | 2020-10-13 | Unknown | Oklahoma | 21 | 0 | |
624127 | 624127 | 2020-10-12 | Unknown | Oklahoma | 32 | 0 | |
620884 | 620884 | 2020-10-11 | Unknown | Oklahoma | 23 | 0 | |
617642 | 617642 | 2020-10-10 | Unknown | Oklahoma | 39 | 0 | |
614400 | 614400 | 2020-10-09 | Unknown | Oklahoma | 33 | 0 | |
611159 | 611159 | 2020-10-08 | Unknown | Oklahoma | 25 | 0 | |
607917 | 607917 | 2020-10-07 | Unknown | Oklahoma | 36 | 0 | |
604674 | 604674 | 2020-10-06 | Unknown | Oklahoma | 42 | 0 | |
601432 | 601432 | 2020-10-05 | Unknown | Oklahoma | 39 | 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);