ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40137 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955107 | 955107 | 2021-01-22 | Stephens | Oklahoma | 40137 | 4008 | 42 |
951862 | 951862 | 2021-01-21 | Stephens | Oklahoma | 40137 | 3924 | 38 |
948617 | 948617 | 2021-01-20 | Stephens | Oklahoma | 40137 | 3895 | 37 |
945371 | 945371 | 2021-01-19 | Stephens | Oklahoma | 40137 | 3863 | 35 |
942124 | 942124 | 2021-01-18 | Stephens | Oklahoma | 40137 | 3861 | 34 |
938879 | 938879 | 2021-01-17 | Stephens | Oklahoma | 40137 | 3849 | 34 |
935634 | 935634 | 2021-01-16 | Stephens | Oklahoma | 40137 | 3779 | 34 |
932389 | 932389 | 2021-01-15 | Stephens | Oklahoma | 40137 | 3747 | 32 |
929144 | 929144 | 2021-01-14 | Stephens | Oklahoma | 40137 | 3712 | 31 |
925899 | 925899 | 2021-01-13 | Stephens | Oklahoma | 40137 | 3676 | 30 |
922653 | 922653 | 2021-01-12 | Stephens | Oklahoma | 40137 | 3636 | 30 |
919408 | 919408 | 2021-01-11 | Stephens | Oklahoma | 40137 | 3616 | 29 |
916163 | 916163 | 2021-01-10 | Stephens | Oklahoma | 40137 | 3550 | 27 |
912918 | 912918 | 2021-01-09 | Stephens | Oklahoma | 40137 | 3446 | 26 |
909673 | 909673 | 2021-01-08 | Stephens | Oklahoma | 40137 | 3419 | 26 |
906428 | 906428 | 2021-01-07 | Stephens | Oklahoma | 40137 | 3362 | 25 |
903182 | 903182 | 2021-01-06 | Stephens | Oklahoma | 40137 | 3297 | 25 |
899937 | 899937 | 2021-01-05 | Stephens | Oklahoma | 40137 | 3239 | 24 |
896692 | 896692 | 2021-01-04 | Stephens | Oklahoma | 40137 | 3224 | 23 |
893446 | 893446 | 2021-01-03 | Stephens | Oklahoma | 40137 | 3201 | 23 |
890200 | 890200 | 2021-01-02 | Stephens | Oklahoma | 40137 | 3086 | 23 |
886953 | 886953 | 2021-01-01 | Stephens | Oklahoma | 40137 | 3029 | 23 |
883708 | 883708 | 2020-12-31 | Stephens | Oklahoma | 40137 | 3029 | 23 |
880463 | 880463 | 2020-12-30 | Stephens | Oklahoma | 40137 | 2980 | 23 |
877218 | 877218 | 2020-12-29 | Stephens | Oklahoma | 40137 | 2888 | 23 |
873973 | 873973 | 2020-12-28 | Stephens | Oklahoma | 40137 | 2860 | 23 |
870728 | 870728 | 2020-12-27 | Stephens | Oklahoma | 40137 | 2833 | 23 |
867483 | 867483 | 2020-12-26 | Stephens | Oklahoma | 40137 | 2779 | 23 |
864238 | 864238 | 2020-12-25 | Stephens | Oklahoma | 40137 | 2693 | 23 |
860993 | 860993 | 2020-12-24 | Stephens | Oklahoma | 40137 | 2693 | 23 |
857748 | 857748 | 2020-12-23 | Stephens | Oklahoma | 40137 | 2650 | 22 |
854503 | 854503 | 2020-12-22 | Stephens | Oklahoma | 40137 | 2556 | 20 |
851258 | 851258 | 2020-12-21 | Stephens | Oklahoma | 40137 | 2535 | 20 |
848013 | 848013 | 2020-12-20 | Stephens | Oklahoma | 40137 | 2525 | 20 |
844768 | 844768 | 2020-12-19 | Stephens | Oklahoma | 40137 | 2453 | 20 |
841522 | 841522 | 2020-12-18 | Stephens | Oklahoma | 40137 | 2391 | 20 |
838277 | 838277 | 2020-12-17 | Stephens | Oklahoma | 40137 | 2350 | 20 |
835031 | 835031 | 2020-12-16 | Stephens | Oklahoma | 40137 | 2318 | 20 |
831785 | 831785 | 2020-12-15 | Stephens | Oklahoma | 40137 | 2260 | 20 |
828538 | 828538 | 2020-12-14 | Stephens | Oklahoma | 40137 | 2243 | 20 |
825292 | 825292 | 2020-12-13 | Stephens | Oklahoma | 40137 | 2227 | 20 |
822045 | 822045 | 2020-12-12 | Stephens | Oklahoma | 40137 | 2173 | 20 |
818799 | 818799 | 2020-12-11 | Stephens | Oklahoma | 40137 | 2126 | 19 |
815553 | 815553 | 2020-12-10 | Stephens | Oklahoma | 40137 | 2061 | 19 |
812307 | 812307 | 2020-12-09 | Stephens | Oklahoma | 40137 | 1994 | 19 |
809063 | 809063 | 2020-12-08 | Stephens | Oklahoma | 40137 | 1972 | 19 |
805818 | 805818 | 2020-12-07 | Stephens | Oklahoma | 40137 | 1946 | 19 |
802573 | 802573 | 2020-12-06 | Stephens | Oklahoma | 40137 | 1934 | 19 |
799328 | 799328 | 2020-12-05 | Stephens | Oklahoma | 40137 | 1893 | 19 |
796083 | 796083 | 2020-12-04 | Stephens | Oklahoma | 40137 | 1868 | 19 |
792838 | 792838 | 2020-12-03 | Stephens | Oklahoma | 40137 | 1834 | 19 |
789593 | 789593 | 2020-12-02 | Stephens | Oklahoma | 40137 | 1795 | 19 |
786348 | 786348 | 2020-12-01 | Stephens | Oklahoma | 40137 | 1706 | 18 |
783104 | 783104 | 2020-11-30 | Stephens | Oklahoma | 40137 | 1706 | 17 |
779858 | 779858 | 2020-11-29 | Stephens | Oklahoma | 40137 | 1683 | 16 |
776613 | 776613 | 2020-11-28 | Stephens | Oklahoma | 40137 | 1647 | 16 |
773368 | 773368 | 2020-11-27 | Stephens | Oklahoma | 40137 | 1591 | 16 |
770123 | 770123 | 2020-11-26 | Stephens | Oklahoma | 40137 | 1549 | 16 |
766877 | 766877 | 2020-11-25 | Stephens | Oklahoma | 40137 | 1549 | 16 |
763632 | 763632 | 2020-11-24 | Stephens | Oklahoma | 40137 | 1490 | 15 |
760387 | 760387 | 2020-11-23 | Stephens | Oklahoma | 40137 | 1466 | 15 |
757142 | 757142 | 2020-11-22 | Stephens | Oklahoma | 40137 | 1415 | 14 |
753895 | 753895 | 2020-11-21 | Stephens | Oklahoma | 40137 | 1369 | 13 |
750649 | 750649 | 2020-11-20 | Stephens | Oklahoma | 40137 | 1312 | 13 |
747403 | 747403 | 2020-11-19 | Stephens | Oklahoma | 40137 | 1277 | 12 |
744157 | 744157 | 2020-11-18 | Stephens | Oklahoma | 40137 | 1218 | 12 |
740910 | 740910 | 2020-11-17 | Stephens | Oklahoma | 40137 | 1178 | 12 |
737664 | 737664 | 2020-11-16 | Stephens | Oklahoma | 40137 | 1174 | 12 |
734420 | 734420 | 2020-11-15 | Stephens | Oklahoma | 40137 | 1149 | 12 |
731174 | 731174 | 2020-11-14 | Stephens | Oklahoma | 40137 | 1116 | 11 |
727930 | 727930 | 2020-11-13 | Stephens | Oklahoma | 40137 | 1091 | 10 |
724686 | 724686 | 2020-11-12 | Stephens | Oklahoma | 40137 | 1065 | 10 |
721443 | 721443 | 2020-11-11 | Stephens | Oklahoma | 40137 | 1014 | 10 |
718200 | 718200 | 2020-11-10 | Stephens | Oklahoma | 40137 | 989 | 9 |
714957 | 714957 | 2020-11-09 | Stephens | Oklahoma | 40137 | 976 | 9 |
711713 | 711713 | 2020-11-08 | Stephens | Oklahoma | 40137 | 963 | 9 |
708469 | 708469 | 2020-11-07 | Stephens | Oklahoma | 40137 | 963 | 9 |
705226 | 705226 | 2020-11-06 | Stephens | Oklahoma | 40137 | 910 | 9 |
701983 | 701983 | 2020-11-05 | Stephens | Oklahoma | 40137 | 893 | 9 |
698739 | 698739 | 2020-11-04 | Stephens | Oklahoma | 40137 | 864 | 9 |
695496 | 695496 | 2020-11-03 | Stephens | Oklahoma | 40137 | 834 | 9 |
692254 | 692254 | 2020-11-02 | Stephens | Oklahoma | 40137 | 816 | 8 |
689010 | 689010 | 2020-11-01 | Stephens | Oklahoma | 40137 | 813 | 8 |
685765 | 685765 | 2020-10-31 | Stephens | Oklahoma | 40137 | 805 | 8 |
682522 | 682522 | 2020-10-30 | Stephens | Oklahoma | 40137 | 772 | 8 |
679279 | 679279 | 2020-10-29 | Stephens | Oklahoma | 40137 | 765 | 8 |
676036 | 676036 | 2020-10-28 | Stephens | Oklahoma | 40137 | 756 | 8 |
672793 | 672793 | 2020-10-27 | Stephens | Oklahoma | 40137 | 741 | 8 |
669551 | 669551 | 2020-10-26 | Stephens | Oklahoma | 40137 | 711 | 8 |
666307 | 666307 | 2020-10-25 | Stephens | Oklahoma | 40137 | 703 | 8 |
663062 | 663062 | 2020-10-24 | Stephens | Oklahoma | 40137 | 696 | 8 |
659818 | 659818 | 2020-10-23 | Stephens | Oklahoma | 40137 | 675 | 8 |
656574 | 656574 | 2020-10-22 | Stephens | Oklahoma | 40137 | 662 | 8 |
653329 | 653329 | 2020-10-21 | Stephens | Oklahoma | 40137 | 640 | 8 |
650084 | 650084 | 2020-10-20 | Stephens | Oklahoma | 40137 | 636 | 8 |
646840 | 646840 | 2020-10-19 | Stephens | Oklahoma | 40137 | 604 | 8 |
643594 | 643594 | 2020-10-18 | Stephens | Oklahoma | 40137 | 600 | 8 |
640346 | 640346 | 2020-10-17 | Stephens | Oklahoma | 40137 | 592 | 8 |
637100 | 637100 | 2020-10-16 | Stephens | Oklahoma | 40137 | 574 | 8 |
633854 | 633854 | 2020-10-15 | Stephens | Oklahoma | 40137 | 562 | 8 |
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);