ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Stephens" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195326 | 1195326 | 2021-04-06 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1192078 | 1192078 | 2021-04-05 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1188829 | 1188829 | 2021-04-04 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1185582 | 1185582 | 2021-04-03 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1182335 | 1182335 | 2021-04-02 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1179088 | 1179088 | 2021-04-01 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1175841 | 1175841 | 2021-03-31 | Stephens | Oklahoma | 40137 | 4768 | 73 |
1172594 | 1172594 | 2021-03-30 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1169347 | 1169347 | 2021-03-29 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1166099 | 1166099 | 2021-03-28 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1162851 | 1162851 | 2021-03-27 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1159602 | 1159602 | 2021-03-26 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1156355 | 1156355 | 2021-03-25 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1153108 | 1153108 | 2021-03-24 | Stephens | Oklahoma | 40137 | 4747 | 72 |
1149861 | 1149861 | 2021-03-23 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1146614 | 1146614 | 2021-03-22 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1143367 | 1143367 | 2021-03-21 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1140120 | 1140120 | 2021-03-20 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1136874 | 1136874 | 2021-03-19 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1133628 | 1133628 | 2021-03-18 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1130380 | 1130380 | 2021-03-17 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1127133 | 1127133 | 2021-03-16 | Stephens | Oklahoma | 40137 | 4728 | 72 |
1123887 | 1123887 | 2021-03-15 | Stephens | Oklahoma | 40137 | 4728 | 71 |
1120641 | 1120641 | 2021-03-14 | Stephens | Oklahoma | 40137 | 4727 | 71 |
1117394 | 1117394 | 2021-03-13 | Stephens | Oklahoma | 40137 | 4722 | 71 |
1114147 | 1114147 | 2021-03-12 | Stephens | Oklahoma | 40137 | 4718 | 71 |
1110901 | 1110901 | 2021-03-11 | Stephens | Oklahoma | 40137 | 4718 | 71 |
1107655 | 1107655 | 2021-03-10 | Stephens | Oklahoma | 40137 | 4713 | 71 |
1104409 | 1104409 | 2021-03-09 | Stephens | Oklahoma | 40137 | 4707 | 71 |
1101163 | 1101163 | 2021-03-08 | Stephens | Oklahoma | 40137 | 4704 | 68 |
1097917 | 1097917 | 2021-03-07 | Stephens | Oklahoma | 40137 | 4704 | 68 |
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 |
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);