ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 40027 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955052 | 955052 | 2021-01-22 | Cleveland | Oklahoma | 40027 | 24467 | 195 |
951807 | 951807 | 2021-01-21 | Cleveland | Oklahoma | 40027 | 24249 | 194 |
948562 | 948562 | 2021-01-20 | Cleveland | Oklahoma | 40027 | 24045 | 193 |
945316 | 945316 | 2021-01-19 | Cleveland | Oklahoma | 40027 | 23922 | 191 |
942069 | 942069 | 2021-01-18 | Cleveland | Oklahoma | 40027 | 23832 | 190 |
938824 | 938824 | 2021-01-17 | Cleveland | Oklahoma | 40027 | 23695 | 190 |
935579 | 935579 | 2021-01-16 | Cleveland | Oklahoma | 40027 | 23475 | 186 |
932334 | 932334 | 2021-01-15 | Cleveland | Oklahoma | 40027 | 23169 | 183 |
929089 | 929089 | 2021-01-14 | Cleveland | Oklahoma | 40027 | 22992 | 179 |
925844 | 925844 | 2021-01-13 | Cleveland | Oklahoma | 40027 | 22709 | 178 |
922598 | 922598 | 2021-01-12 | Cleveland | Oklahoma | 40027 | 22518 | 177 |
919353 | 919353 | 2021-01-11 | Cleveland | Oklahoma | 40027 | 22325 | 173 |
916108 | 916108 | 2021-01-10 | Cleveland | Oklahoma | 40027 | 22062 | 171 |
912863 | 912863 | 2021-01-09 | Cleveland | Oklahoma | 40027 | 21633 | 171 |
909618 | 909618 | 2021-01-08 | Cleveland | Oklahoma | 40027 | 21308 | 170 |
906373 | 906373 | 2021-01-07 | Cleveland | Oklahoma | 40027 | 20953 | 170 |
903127 | 903127 | 2021-01-06 | Cleveland | Oklahoma | 40027 | 20692 | 168 |
899882 | 899882 | 2021-01-05 | Cleveland | Oklahoma | 40027 | 20518 | 168 |
896637 | 896637 | 2021-01-04 | Cleveland | Oklahoma | 40027 | 20392 | 166 |
893391 | 893391 | 2021-01-03 | Cleveland | Oklahoma | 40027 | 20209 | 166 |
890145 | 890145 | 2021-01-02 | Cleveland | Oklahoma | 40027 | 19636 | 164 |
886898 | 886898 | 2021-01-01 | Cleveland | Oklahoma | 40027 | 19231 | 163 |
883653 | 883653 | 2020-12-31 | Cleveland | Oklahoma | 40027 | 19231 | 163 |
880408 | 880408 | 2020-12-30 | Cleveland | Oklahoma | 40027 | 18898 | 163 |
877163 | 877163 | 2020-12-29 | Cleveland | Oklahoma | 40027 | 18704 | 153 |
873918 | 873918 | 2020-12-28 | Cleveland | Oklahoma | 40027 | 18586 | 151 |
870673 | 870673 | 2020-12-27 | Cleveland | Oklahoma | 40027 | 18364 | 150 |
867428 | 867428 | 2020-12-26 | Cleveland | Oklahoma | 40027 | 18177 | 150 |
864183 | 864183 | 2020-12-25 | Cleveland | Oklahoma | 40027 | 17912 | 149 |
860938 | 860938 | 2020-12-24 | Cleveland | Oklahoma | 40027 | 17912 | 149 |
857693 | 857693 | 2020-12-23 | Cleveland | Oklahoma | 40027 | 17604 | 145 |
854448 | 854448 | 2020-12-22 | Cleveland | Oklahoma | 40027 | 17470 | 144 |
851203 | 851203 | 2020-12-21 | Cleveland | Oklahoma | 40027 | 17335 | 144 |
847958 | 847958 | 2020-12-20 | Cleveland | Oklahoma | 40027 | 17096 | 142 |
844713 | 844713 | 2020-12-19 | Cleveland | Oklahoma | 40027 | 16806 | 141 |
841467 | 841467 | 2020-12-18 | Cleveland | Oklahoma | 40027 | 16579 | 141 |
838222 | 838222 | 2020-12-17 | Cleveland | Oklahoma | 40027 | 16260 | 141 |
834976 | 834976 | 2020-12-16 | Cleveland | Oklahoma | 40027 | 15984 | 141 |
831730 | 831730 | 2020-12-15 | Cleveland | Oklahoma | 40027 | 15832 | 138 |
828483 | 828483 | 2020-12-14 | Cleveland | Oklahoma | 40027 | 15743 | 138 |
825237 | 825237 | 2020-12-13 | Cleveland | Oklahoma | 40027 | 15540 | 138 |
821990 | 821990 | 2020-12-12 | Cleveland | Oklahoma | 40027 | 15332 | 137 |
818744 | 818744 | 2020-12-11 | Cleveland | Oklahoma | 40027 | 15112 | 135 |
815498 | 815498 | 2020-12-10 | Cleveland | Oklahoma | 40027 | 14863 | 135 |
812252 | 812252 | 2020-12-09 | Cleveland | Oklahoma | 40027 | 14683 | 134 |
809008 | 809008 | 2020-12-08 | Cleveland | Oklahoma | 40027 | 14559 | 133 |
805763 | 805763 | 2020-12-07 | Cleveland | Oklahoma | 40027 | 14428 | 132 |
802518 | 802518 | 2020-12-06 | Cleveland | Oklahoma | 40027 | 14260 | 131 |
799273 | 799273 | 2020-12-05 | Cleveland | Oklahoma | 40027 | 14095 | 131 |
796028 | 796028 | 2020-12-04 | Cleveland | Oklahoma | 40027 | 13814 | 131 |
792783 | 792783 | 2020-12-03 | Cleveland | Oklahoma | 40027 | 13392 | 131 |
789538 | 789538 | 2020-12-02 | Cleveland | Oklahoma | 40027 | 13287 | 129 |
786293 | 786293 | 2020-12-01 | Cleveland | Oklahoma | 40027 | 13132 | 128 |
783049 | 783049 | 2020-11-30 | Cleveland | Oklahoma | 40027 | 12978 | 128 |
779803 | 779803 | 2020-11-29 | Cleveland | Oklahoma | 40027 | 12889 | 128 |
776558 | 776558 | 2020-11-28 | Cleveland | Oklahoma | 40027 | 12802 | 126 |
773313 | 773313 | 2020-11-27 | Cleveland | Oklahoma | 40027 | 12387 | 125 |
770068 | 770068 | 2020-11-26 | Cleveland | Oklahoma | 40027 | 12180 | 124 |
766822 | 766822 | 2020-11-25 | Cleveland | Oklahoma | 40027 | 12180 | 124 |
763577 | 763577 | 2020-11-24 | Cleveland | Oklahoma | 40027 | 12012 | 124 |
760332 | 760332 | 2020-11-23 | Cleveland | Oklahoma | 40027 | 11843 | 120 |
757087 | 757087 | 2020-11-22 | Cleveland | Oklahoma | 40027 | 11577 | 119 |
753840 | 753840 | 2020-11-21 | Cleveland | Oklahoma | 40027 | 11418 | 119 |
750594 | 750594 | 2020-11-20 | Cleveland | Oklahoma | 40027 | 11158 | 118 |
747348 | 747348 | 2020-11-19 | Cleveland | Oklahoma | 40027 | 10992 | 118 |
744102 | 744102 | 2020-11-18 | Cleveland | Oklahoma | 40027 | 10830 | 117 |
740855 | 740855 | 2020-11-17 | Cleveland | Oklahoma | 40027 | 10709 | 117 |
737609 | 737609 | 2020-11-16 | Cleveland | Oklahoma | 40027 | 10636 | 116 |
734365 | 734365 | 2020-11-15 | Cleveland | Oklahoma | 40027 | 10461 | 116 |
731119 | 731119 | 2020-11-14 | Cleveland | Oklahoma | 40027 | 10291 | 116 |
727875 | 727875 | 2020-11-13 | Cleveland | Oklahoma | 40027 | 10114 | 114 |
724631 | 724631 | 2020-11-12 | Cleveland | Oklahoma | 40027 | 9939 | 114 |
721388 | 721388 | 2020-11-11 | Cleveland | Oklahoma | 40027 | 9806 | 114 |
718145 | 718145 | 2020-11-10 | Cleveland | Oklahoma | 40027 | 9673 | 113 |
714902 | 714902 | 2020-11-09 | Cleveland | Oklahoma | 40027 | 9598 | 112 |
711658 | 711658 | 2020-11-08 | Cleveland | Oklahoma | 40027 | 9384 | 111 |
708414 | 708414 | 2020-11-07 | Cleveland | Oklahoma | 40027 | 9384 | 111 |
705171 | 705171 | 2020-11-06 | Cleveland | Oklahoma | 40027 | 9058 | 110 |
701928 | 701928 | 2020-11-05 | Cleveland | Oklahoma | 40027 | 9021 | 110 |
698684 | 698684 | 2020-11-04 | Cleveland | Oklahoma | 40027 | 8871 | 108 |
695441 | 695441 | 2020-11-03 | Cleveland | Oklahoma | 40027 | 8826 | 106 |
692199 | 692199 | 2020-11-02 | Cleveland | Oklahoma | 40027 | 8778 | 106 |
688955 | 688955 | 2020-11-01 | Cleveland | Oklahoma | 40027 | 8726 | 105 |
685710 | 685710 | 2020-10-31 | Cleveland | Oklahoma | 40027 | 8622 | 105 |
682467 | 682467 | 2020-10-30 | Cleveland | Oklahoma | 40027 | 8568 | 105 |
679224 | 679224 | 2020-10-29 | Cleveland | Oklahoma | 40027 | 8485 | 100 |
675981 | 675981 | 2020-10-28 | Cleveland | Oklahoma | 40027 | 8400 | 99 |
672738 | 672738 | 2020-10-27 | Cleveland | Oklahoma | 40027 | 8369 | 96 |
669496 | 669496 | 2020-10-26 | Cleveland | Oklahoma | 40027 | 8331 | 89 |
666252 | 666252 | 2020-10-25 | Cleveland | Oklahoma | 40027 | 8311 | 89 |
663007 | 663007 | 2020-10-24 | Cleveland | Oklahoma | 40027 | 8218 | 89 |
659763 | 659763 | 2020-10-23 | Cleveland | Oklahoma | 40027 | 8037 | 89 |
656519 | 656519 | 2020-10-22 | Cleveland | Oklahoma | 40027 | 7941 | 87 |
653274 | 653274 | 2020-10-21 | Cleveland | Oklahoma | 40027 | 7843 | 87 |
650029 | 650029 | 2020-10-20 | Cleveland | Oklahoma | 40027 | 7764 | 86 |
646785 | 646785 | 2020-10-19 | Cleveland | Oklahoma | 40027 | 7625 | 85 |
643539 | 643539 | 2020-10-18 | Cleveland | Oklahoma | 40027 | 7575 | 85 |
640291 | 640291 | 2020-10-17 | Cleveland | Oklahoma | 40027 | 7512 | 85 |
637045 | 637045 | 2020-10-16 | Cleveland | Oklahoma | 40027 | 7429 | 85 |
633799 | 633799 | 2020-10-15 | Cleveland | Oklahoma | 40027 | 7337 | 85 |
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);