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 |
---|---|---|---|---|---|---|---|
1094669 | 1094669 | 2021-03-06 | Stephens | Oklahoma | 40137 | 4703 | 68 |
1091423 | 1091423 | 2021-03-05 | Stephens | Oklahoma | 40137 | 4696 | 68 |
1088177 | 1088177 | 2021-03-04 | Stephens | Oklahoma | 40137 | 4690 | 68 |
1084932 | 1084932 | 2021-03-03 | Stephens | Oklahoma | 40137 | 4683 | 68 |
1081686 | 1081686 | 2021-03-02 | Stephens | Oklahoma | 40137 | 4677 | 68 |
1078440 | 1078440 | 2021-03-01 | Stephens | Oklahoma | 40137 | 4677 | 67 |
1075195 | 1075195 | 2021-02-28 | Stephens | Oklahoma | 40137 | 4674 | 67 |
1071949 | 1071949 | 2021-02-27 | Stephens | Oklahoma | 40137 | 4668 | 67 |
1068703 | 1068703 | 2021-02-26 | Stephens | Oklahoma | 40137 | 4661 | 66 |
1065458 | 1065458 | 2021-02-25 | Stephens | Oklahoma | 40137 | 4655 | 66 |
1062214 | 1062214 | 2021-02-24 | Stephens | Oklahoma | 40137 | 4642 | 66 |
1058968 | 1058968 | 2021-02-23 | Stephens | Oklahoma | 40137 | 4641 | 66 |
1055722 | 1055722 | 2021-02-22 | Stephens | Oklahoma | 40137 | 4641 | 65 |
1052476 | 1052476 | 2021-02-21 | Stephens | Oklahoma | 40137 | 4635 | 65 |
1049229 | 1049229 | 2021-02-20 | Stephens | Oklahoma | 40137 | 4615 | 60 |
1045982 | 1045982 | 2021-02-19 | Stephens | Oklahoma | 40137 | 4613 | 60 |
1042737 | 1042737 | 2021-02-18 | Stephens | Oklahoma | 40137 | 4606 | 60 |
1039492 | 1039492 | 2021-02-17 | Stephens | Oklahoma | 40137 | 4604 | 59 |
1036247 | 1036247 | 2021-02-16 | Stephens | Oklahoma | 40137 | 4592 | 58 |
1033002 | 1033002 | 2021-02-15 | Stephens | Oklahoma | 40137 | 4586 | 58 |
1029756 | 1029756 | 2021-02-14 | Stephens | Oklahoma | 40137 | 4581 | 58 |
1026509 | 1026509 | 2021-02-13 | Stephens | Oklahoma | 40137 | 4539 | 58 |
1023264 | 1023264 | 2021-02-12 | Stephens | Oklahoma | 40137 | 4528 | 57 |
1020019 | 1020019 | 2021-02-11 | Stephens | Oklahoma | 40137 | 4523 | 57 |
1016774 | 1016774 | 2021-02-10 | Stephens | Oklahoma | 40137 | 4471 | 56 |
1013529 | 1013529 | 2021-02-09 | Stephens | Oklahoma | 40137 | 4457 | 56 |
1010284 | 1010284 | 2021-02-08 | Stephens | Oklahoma | 40137 | 4454 | 55 |
1007038 | 1007038 | 2021-02-07 | Stephens | Oklahoma | 40137 | 4438 | 55 |
1003792 | 1003792 | 2021-02-06 | Stephens | Oklahoma | 40137 | 4428 | 54 |
1000546 | 1000546 | 2021-02-05 | Stephens | Oklahoma | 40137 | 4410 | 53 |
997300 | 997300 | 2021-02-04 | Stephens | Oklahoma | 40137 | 4387 | 52 |
994054 | 994054 | 2021-02-03 | Stephens | Oklahoma | 40137 | 4341 | 52 |
990808 | 990808 | 2021-02-02 | Stephens | Oklahoma | 40137 | 4303 | 51 |
987562 | 987562 | 2021-02-01 | Stephens | Oklahoma | 40137 | 4295 | 50 |
984315 | 984315 | 2021-01-31 | Stephens | Oklahoma | 40137 | 4288 | 49 |
981068 | 981068 | 2021-01-30 | Stephens | Oklahoma | 40137 | 4266 | 47 |
977822 | 977822 | 2021-01-29 | Stephens | Oklahoma | 40137 | 4234 | 45 |
974577 | 974577 | 2021-01-28 | Stephens | Oklahoma | 40137 | 4185 | 45 |
971332 | 971332 | 2021-01-27 | Stephens | Oklahoma | 40137 | 4150 | 44 |
968087 | 968087 | 2021-01-26 | Stephens | Oklahoma | 40137 | 4116 | 44 |
964843 | 964843 | 2021-01-25 | Stephens | Oklahoma | 40137 | 4106 | 44 |
961598 | 961598 | 2021-01-24 | Stephens | Oklahoma | 40137 | 4104 | 43 |
958353 | 958353 | 2021-01-23 | Stephens | Oklahoma | 40137 | 4059 | 43 |
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 |
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);