ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = 40109 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955093 | 955093 | 2021-01-22 | Oklahoma | Oklahoma | 40109 | 71058 | 524 |
951848 | 951848 | 2021-01-21 | Oklahoma | Oklahoma | 40109 | 70543 | 519 |
948603 | 948603 | 2021-01-20 | Oklahoma | Oklahoma | 40109 | 70044 | 512 |
945357 | 945357 | 2021-01-19 | Oklahoma | Oklahoma | 40109 | 69587 | 507 |
942110 | 942110 | 2021-01-18 | Oklahoma | Oklahoma | 40109 | 69329 | 502 |
938865 | 938865 | 2021-01-17 | Oklahoma | Oklahoma | 40109 | 68940 | 500 |
935620 | 935620 | 2021-01-16 | Oklahoma | Oklahoma | 40109 | 68372 | 495 |
932375 | 932375 | 2021-01-15 | Oklahoma | Oklahoma | 40109 | 67719 | 494 |
929130 | 929130 | 2021-01-14 | Oklahoma | Oklahoma | 40109 | 67165 | 485 |
925885 | 925885 | 2021-01-13 | Oklahoma | Oklahoma | 40109 | 66594 | 483 |
922639 | 922639 | 2021-01-12 | Oklahoma | Oklahoma | 40109 | 66096 | 479 |
919394 | 919394 | 2021-01-11 | Oklahoma | Oklahoma | 40109 | 65661 | 473 |
916149 | 916149 | 2021-01-10 | Oklahoma | Oklahoma | 40109 | 64977 | 467 |
912904 | 912904 | 2021-01-09 | Oklahoma | Oklahoma | 40109 | 63766 | 464 |
909659 | 909659 | 2021-01-08 | Oklahoma | Oklahoma | 40109 | 63058 | 457 |
906414 | 906414 | 2021-01-07 | Oklahoma | Oklahoma | 40109 | 61898 | 455 |
903168 | 903168 | 2021-01-06 | Oklahoma | Oklahoma | 40109 | 61336 | 454 |
899923 | 899923 | 2021-01-05 | Oklahoma | Oklahoma | 40109 | 60765 | 452 |
896678 | 896678 | 2021-01-04 | Oklahoma | Oklahoma | 40109 | 60512 | 449 |
893432 | 893432 | 2021-01-03 | Oklahoma | Oklahoma | 40109 | 60103 | 448 |
890186 | 890186 | 2021-01-02 | Oklahoma | Oklahoma | 40109 | 58607 | 444 |
886939 | 886939 | 2021-01-01 | Oklahoma | Oklahoma | 40109 | 57993 | 441 |
883694 | 883694 | 2020-12-31 | Oklahoma | Oklahoma | 40109 | 57993 | 441 |
880449 | 880449 | 2020-12-30 | Oklahoma | Oklahoma | 40109 | 57401 | 435 |
877204 | 877204 | 2020-12-29 | Oklahoma | Oklahoma | 40109 | 56943 | 432 |
873959 | 873959 | 2020-12-28 | Oklahoma | Oklahoma | 40109 | 56748 | 424 |
870714 | 870714 | 2020-12-27 | Oklahoma | Oklahoma | 40109 | 56086 | 423 |
867469 | 867469 | 2020-12-26 | Oklahoma | Oklahoma | 40109 | 55682 | 419 |
864224 | 864224 | 2020-12-25 | Oklahoma | Oklahoma | 40109 | 55011 | 416 |
860979 | 860979 | 2020-12-24 | Oklahoma | Oklahoma | 40109 | 55011 | 416 |
857734 | 857734 | 2020-12-23 | Oklahoma | Oklahoma | 40109 | 54519 | 410 |
854489 | 854489 | 2020-12-22 | Oklahoma | Oklahoma | 40109 | 54067 | 405 |
851244 | 851244 | 2020-12-21 | Oklahoma | Oklahoma | 40109 | 53592 | 398 |
847999 | 847999 | 2020-12-20 | Oklahoma | Oklahoma | 40109 | 53080 | 398 |
844754 | 844754 | 2020-12-19 | Oklahoma | Oklahoma | 40109 | 52415 | 395 |
841508 | 841508 | 2020-12-18 | Oklahoma | Oklahoma | 40109 | 51811 | 393 |
838263 | 838263 | 2020-12-17 | Oklahoma | Oklahoma | 40109 | 51120 | 389 |
835017 | 835017 | 2020-12-16 | Oklahoma | Oklahoma | 40109 | 50569 | 384 |
831771 | 831771 | 2020-12-15 | Oklahoma | Oklahoma | 40109 | 50121 | 375 |
828524 | 828524 | 2020-12-14 | Oklahoma | Oklahoma | 40109 | 49596 | 373 |
825278 | 825278 | 2020-12-13 | Oklahoma | Oklahoma | 40109 | 49009 | 373 |
822031 | 822031 | 2020-12-12 | Oklahoma | Oklahoma | 40109 | 48215 | 367 |
818785 | 818785 | 2020-12-11 | Oklahoma | Oklahoma | 40109 | 47460 | 358 |
815539 | 815539 | 2020-12-10 | Oklahoma | Oklahoma | 40109 | 46425 | 353 |
812293 | 812293 | 2020-12-09 | Oklahoma | Oklahoma | 40109 | 45918 | 342 |
809049 | 809049 | 2020-12-08 | Oklahoma | Oklahoma | 40109 | 45458 | 335 |
805804 | 805804 | 2020-12-07 | Oklahoma | Oklahoma | 40109 | 44851 | 334 |
802559 | 802559 | 2020-12-06 | Oklahoma | Oklahoma | 40109 | 44505 | 331 |
799314 | 799314 | 2020-12-05 | Oklahoma | Oklahoma | 40109 | 43884 | 321 |
796069 | 796069 | 2020-12-04 | Oklahoma | Oklahoma | 40109 | 42872 | 320 |
792824 | 792824 | 2020-12-03 | Oklahoma | Oklahoma | 40109 | 41709 | 315 |
789579 | 789579 | 2020-12-02 | Oklahoma | Oklahoma | 40109 | 41494 | 311 |
786334 | 786334 | 2020-12-01 | Oklahoma | Oklahoma | 40109 | 40803 | 296 |
783090 | 783090 | 2020-11-30 | Oklahoma | Oklahoma | 40109 | 40259 | 292 |
779844 | 779844 | 2020-11-29 | Oklahoma | Oklahoma | 40109 | 39944 | 291 |
776599 | 776599 | 2020-11-28 | Oklahoma | Oklahoma | 40109 | 39512 | 290 |
773354 | 773354 | 2020-11-27 | Oklahoma | Oklahoma | 40109 | 38112 | 290 |
770109 | 770109 | 2020-11-26 | Oklahoma | Oklahoma | 40109 | 37441 | 285 |
766863 | 766863 | 2020-11-25 | Oklahoma | Oklahoma | 40109 | 37441 | 285 |
763618 | 763618 | 2020-11-24 | Oklahoma | Oklahoma | 40109 | 36880 | 282 |
760373 | 760373 | 2020-11-23 | Oklahoma | Oklahoma | 40109 | 36199 | 281 |
757128 | 757128 | 2020-11-22 | Oklahoma | Oklahoma | 40109 | 35499 | 278 |
753881 | 753881 | 2020-11-21 | Oklahoma | Oklahoma | 40109 | 34709 | 275 |
750635 | 750635 | 2020-11-20 | Oklahoma | Oklahoma | 40109 | 33851 | 272 |
747389 | 747389 | 2020-11-19 | Oklahoma | Oklahoma | 40109 | 33309 | 270 |
744143 | 744143 | 2020-11-18 | Oklahoma | Oklahoma | 40109 | 32578 | 266 |
740896 | 740896 | 2020-11-17 | Oklahoma | Oklahoma | 40109 | 31970 | 261 |
737650 | 737650 | 2020-11-16 | Oklahoma | Oklahoma | 40109 | 31753 | 261 |
734406 | 734406 | 2020-11-15 | Oklahoma | Oklahoma | 40109 | 31159 | 260 |
731160 | 731160 | 2020-11-14 | Oklahoma | Oklahoma | 40109 | 30228 | 260 |
727916 | 727916 | 2020-11-13 | Oklahoma | Oklahoma | 40109 | 29737 | 257 |
724672 | 724672 | 2020-11-12 | Oklahoma | Oklahoma | 40109 | 29230 | 254 |
721429 | 721429 | 2020-11-11 | Oklahoma | Oklahoma | 40109 | 28731 | 254 |
718186 | 718186 | 2020-11-10 | Oklahoma | Oklahoma | 40109 | 28213 | 250 |
714943 | 714943 | 2020-11-09 | Oklahoma | Oklahoma | 40109 | 27871 | 250 |
711699 | 711699 | 2020-11-08 | Oklahoma | Oklahoma | 40109 | 27354 | 249 |
708455 | 708455 | 2020-11-07 | Oklahoma | Oklahoma | 40109 | 27354 | 249 |
705212 | 705212 | 2020-11-06 | Oklahoma | Oklahoma | 40109 | 26302 | 248 |
701969 | 701969 | 2020-11-05 | Oklahoma | Oklahoma | 40109 | 25948 | 244 |
698725 | 698725 | 2020-11-04 | Oklahoma | Oklahoma | 40109 | 25473 | 239 |
695482 | 695482 | 2020-11-03 | Oklahoma | Oklahoma | 40109 | 25315 | 235 |
692240 | 692240 | 2020-11-02 | Oklahoma | Oklahoma | 40109 | 25091 | 233 |
688996 | 688996 | 2020-11-01 | Oklahoma | Oklahoma | 40109 | 24869 | 232 |
685751 | 685751 | 2020-10-31 | Oklahoma | Oklahoma | 40109 | 24607 | 231 |
682508 | 682508 | 2020-10-30 | Oklahoma | Oklahoma | 40109 | 24468 | 231 |
679265 | 679265 | 2020-10-29 | Oklahoma | Oklahoma | 40109 | 24250 | 231 |
676022 | 676022 | 2020-10-28 | Oklahoma | Oklahoma | 40109 | 23997 | 231 |
672779 | 672779 | 2020-10-27 | Oklahoma | Oklahoma | 40109 | 23881 | 231 |
669537 | 669537 | 2020-10-26 | Oklahoma | Oklahoma | 40109 | 23726 | 228 |
666293 | 666293 | 2020-10-25 | Oklahoma | Oklahoma | 40109 | 23565 | 227 |
663048 | 663048 | 2020-10-24 | Oklahoma | Oklahoma | 40109 | 23285 | 226 |
659804 | 659804 | 2020-10-23 | Oklahoma | Oklahoma | 40109 | 22816 | 225 |
656560 | 656560 | 2020-10-22 | Oklahoma | Oklahoma | 40109 | 22669 | 222 |
653315 | 653315 | 2020-10-21 | Oklahoma | Oklahoma | 40109 | 22422 | 219 |
650070 | 650070 | 2020-10-20 | Oklahoma | Oklahoma | 40109 | 22213 | 218 |
646826 | 646826 | 2020-10-19 | Oklahoma | Oklahoma | 40109 | 22008 | 216 |
643580 | 643580 | 2020-10-18 | Oklahoma | Oklahoma | 40109 | 21854 | 216 |
640332 | 640332 | 2020-10-17 | Oklahoma | Oklahoma | 40109 | 21701 | 216 |
637086 | 637086 | 2020-10-16 | Oklahoma | Oklahoma | 40109 | 21506 | 216 |
633840 | 633840 | 2020-10-15 | Oklahoma | Oklahoma | 40109 | 21260 | 212 |
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);