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 |
---|---|---|---|---|---|---|---|
955067 | 955067 | 2021-01-22 | Harmon | Oklahoma | 40057 | 250 | 1 |
951822 | 951822 | 2021-01-21 | Harmon | Oklahoma | 40057 | 249 | 1 |
948577 | 948577 | 2021-01-20 | Harmon | Oklahoma | 40057 | 249 | 1 |
945331 | 945331 | 2021-01-19 | Harmon | Oklahoma | 40057 | 249 | 1 |
942084 | 942084 | 2021-01-18 | Harmon | Oklahoma | 40057 | 247 | 1 |
938839 | 938839 | 2021-01-17 | Harmon | Oklahoma | 40057 | 246 | 1 |
935594 | 935594 | 2021-01-16 | Harmon | Oklahoma | 40057 | 246 | 1 |
932349 | 932349 | 2021-01-15 | Harmon | Oklahoma | 40057 | 246 | 1 |
929104 | 929104 | 2021-01-14 | Harmon | Oklahoma | 40057 | 246 | 0 |
925859 | 925859 | 2021-01-13 | Harmon | Oklahoma | 40057 | 245 | 0 |
922613 | 922613 | 2021-01-12 | Harmon | Oklahoma | 40057 | 245 | 0 |
919368 | 919368 | 2021-01-11 | Harmon | Oklahoma | 40057 | 245 | 0 |
916123 | 916123 | 2021-01-10 | Harmon | Oklahoma | 40057 | 245 | 0 |
912878 | 912878 | 2021-01-09 | Harmon | Oklahoma | 40057 | 244 | 0 |
909633 | 909633 | 2021-01-08 | Harmon | Oklahoma | 40057 | 239 | 0 |
906388 | 906388 | 2021-01-07 | Harmon | Oklahoma | 40057 | 233 | 0 |
903142 | 903142 | 2021-01-06 | Harmon | Oklahoma | 40057 | 219 | 0 |
899897 | 899897 | 2021-01-05 | Harmon | Oklahoma | 40057 | 212 | 0 |
896652 | 896652 | 2021-01-04 | Harmon | Oklahoma | 40057 | 209 | 0 |
893406 | 893406 | 2021-01-03 | Harmon | Oklahoma | 40057 | 201 | 0 |
890160 | 890160 | 2021-01-02 | Harmon | Oklahoma | 40057 | 201 | 0 |
886913 | 886913 | 2021-01-01 | Harmon | Oklahoma | 40057 | 201 | 0 |
883668 | 883668 | 2020-12-31 | Harmon | Oklahoma | 40057 | 201 | 0 |
880423 | 880423 | 2020-12-30 | Harmon | Oklahoma | 40057 | 199 | 0 |
877178 | 877178 | 2020-12-29 | Harmon | Oklahoma | 40057 | 199 | 0 |
873933 | 873933 | 2020-12-28 | Harmon | Oklahoma | 40057 | 199 | 0 |
870688 | 870688 | 2020-12-27 | Harmon | Oklahoma | 40057 | 199 | 0 |
867443 | 867443 | 2020-12-26 | Harmon | Oklahoma | 40057 | 199 | 0 |
864198 | 864198 | 2020-12-25 | Harmon | Oklahoma | 40057 | 199 | 0 |
860953 | 860953 | 2020-12-24 | Harmon | Oklahoma | 40057 | 199 | 0 |
857708 | 857708 | 2020-12-23 | Harmon | Oklahoma | 40057 | 197 | 0 |
854463 | 854463 | 2020-12-22 | Harmon | Oklahoma | 40057 | 196 | 0 |
851218 | 851218 | 2020-12-21 | Harmon | Oklahoma | 40057 | 195 | 0 |
847973 | 847973 | 2020-12-20 | Harmon | Oklahoma | 40057 | 195 | 0 |
844728 | 844728 | 2020-12-19 | Harmon | Oklahoma | 40057 | 193 | 0 |
841482 | 841482 | 2020-12-18 | Harmon | Oklahoma | 40057 | 193 | 0 |
838237 | 838237 | 2020-12-17 | Harmon | Oklahoma | 40057 | 189 | 0 |
834991 | 834991 | 2020-12-16 | Harmon | Oklahoma | 40057 | 187 | 0 |
831745 | 831745 | 2020-12-15 | Harmon | Oklahoma | 40057 | 183 | 0 |
828498 | 828498 | 2020-12-14 | Harmon | Oklahoma | 40057 | 184 | 0 |
825252 | 825252 | 2020-12-13 | Harmon | Oklahoma | 40057 | 185 | 0 |
822005 | 822005 | 2020-12-12 | Harmon | Oklahoma | 40057 | 171 | 0 |
818759 | 818759 | 2020-12-11 | Harmon | Oklahoma | 40057 | 165 | 0 |
815513 | 815513 | 2020-12-10 | Harmon | Oklahoma | 40057 | 163 | 0 |
812267 | 812267 | 2020-12-09 | Harmon | Oklahoma | 40057 | 154 | 0 |
809023 | 809023 | 2020-12-08 | Harmon | Oklahoma | 40057 | 151 | 0 |
805778 | 805778 | 2020-12-07 | Harmon | Oklahoma | 40057 | 151 | 0 |
802533 | 802533 | 2020-12-06 | Harmon | Oklahoma | 40057 | 148 | 0 |
799288 | 799288 | 2020-12-05 | Harmon | Oklahoma | 40057 | 141 | 0 |
796043 | 796043 | 2020-12-04 | Harmon | Oklahoma | 40057 | 132 | 0 |
792798 | 792798 | 2020-12-03 | Harmon | Oklahoma | 40057 | 122 | 0 |
789553 | 789553 | 2020-12-02 | Harmon | Oklahoma | 40057 | 108 | 0 |
786308 | 786308 | 2020-12-01 | Harmon | Oklahoma | 40057 | 108 | 0 |
783064 | 783064 | 2020-11-30 | Harmon | Oklahoma | 40057 | 108 | 0 |
779818 | 779818 | 2020-11-29 | Harmon | Oklahoma | 40057 | 107 | 0 |
776573 | 776573 | 2020-11-28 | Harmon | Oklahoma | 40057 | 107 | 0 |
773328 | 773328 | 2020-11-27 | Harmon | Oklahoma | 40057 | 105 | 0 |
770083 | 770083 | 2020-11-26 | Harmon | Oklahoma | 40057 | 101 | 0 |
766837 | 766837 | 2020-11-25 | Harmon | Oklahoma | 40057 | 101 | 0 |
763592 | 763592 | 2020-11-24 | Harmon | Oklahoma | 40057 | 100 | 0 |
760347 | 760347 | 2020-11-23 | Harmon | Oklahoma | 40057 | 99 | 0 |
757102 | 757102 | 2020-11-22 | Harmon | Oklahoma | 40057 | 99 | 0 |
753855 | 753855 | 2020-11-21 | Harmon | Oklahoma | 40057 | 96 | 0 |
750609 | 750609 | 2020-11-20 | Harmon | Oklahoma | 40057 | 95 | 0 |
747363 | 747363 | 2020-11-19 | Harmon | Oklahoma | 40057 | 94 | 0 |
744117 | 744117 | 2020-11-18 | Harmon | Oklahoma | 40057 | 94 | 0 |
740870 | 740870 | 2020-11-17 | Harmon | Oklahoma | 40057 | 93 | 0 |
737624 | 737624 | 2020-11-16 | Harmon | Oklahoma | 40057 | 93 | 0 |
734380 | 734380 | 2020-11-15 | Harmon | Oklahoma | 40057 | 93 | 0 |
731134 | 731134 | 2020-11-14 | Harmon | Oklahoma | 40057 | 91 | 0 |
727890 | 727890 | 2020-11-13 | Harmon | Oklahoma | 40057 | 91 | 0 |
724646 | 724646 | 2020-11-12 | Harmon | Oklahoma | 40057 | 90 | 0 |
721403 | 721403 | 2020-11-11 | Harmon | Oklahoma | 40057 | 90 | 0 |
718160 | 718160 | 2020-11-10 | Harmon | Oklahoma | 40057 | 90 | 0 |
714917 | 714917 | 2020-11-09 | Harmon | Oklahoma | 40057 | 85 | 0 |
711673 | 711673 | 2020-11-08 | Harmon | Oklahoma | 40057 | 80 | 0 |
708429 | 708429 | 2020-11-07 | Harmon | Oklahoma | 40057 | 80 | 0 |
705186 | 705186 | 2020-11-06 | Harmon | Oklahoma | 40057 | 79 | 0 |
701943 | 701943 | 2020-11-05 | Harmon | Oklahoma | 40057 | 79 | 0 |
698699 | 698699 | 2020-11-04 | Harmon | Oklahoma | 40057 | 79 | 0 |
695456 | 695456 | 2020-11-03 | Harmon | Oklahoma | 40057 | 80 | 0 |
692214 | 692214 | 2020-11-02 | Harmon | Oklahoma | 40057 | 79 | 0 |
688970 | 688970 | 2020-11-01 | Harmon | Oklahoma | 40057 | 78 | 0 |
685725 | 685725 | 2020-10-31 | Harmon | Oklahoma | 40057 | 76 | 0 |
682482 | 682482 | 2020-10-30 | Harmon | Oklahoma | 40057 | 76 | 0 |
679239 | 679239 | 2020-10-29 | Harmon | Oklahoma | 40057 | 75 | 0 |
675996 | 675996 | 2020-10-28 | Harmon | Oklahoma | 40057 | 72 | 0 |
672753 | 672753 | 2020-10-27 | Harmon | Oklahoma | 40057 | 70 | 0 |
669511 | 669511 | 2020-10-26 | Harmon | Oklahoma | 40057 | 69 | 0 |
666267 | 666267 | 2020-10-25 | Harmon | Oklahoma | 40057 | 68 | 0 |
663022 | 663022 | 2020-10-24 | Harmon | Oklahoma | 40057 | 68 | 0 |
659778 | 659778 | 2020-10-23 | Harmon | Oklahoma | 40057 | 64 | 0 |
656534 | 656534 | 2020-10-22 | Harmon | Oklahoma | 40057 | 63 | 0 |
653289 | 653289 | 2020-10-21 | Harmon | Oklahoma | 40057 | 63 | 0 |
650044 | 650044 | 2020-10-20 | Harmon | Oklahoma | 40057 | 63 | 0 |
646800 | 646800 | 2020-10-19 | Harmon | Oklahoma | 40057 | 62 | 0 |
643554 | 643554 | 2020-10-18 | Harmon | Oklahoma | 40057 | 62 | 0 |
640306 | 640306 | 2020-10-17 | Harmon | Oklahoma | 40057 | 62 | 0 |
637060 | 637060 | 2020-10-16 | Harmon | Oklahoma | 40057 | 62 | 0 |
633814 | 633814 | 2020-10-15 | Harmon | Oklahoma | 40057 | 61 | 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);