ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 40087 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195304 | 1195304 | 2021-04-06 | McClain | Oklahoma | 40087 | 5153 | 57 |
1192056 | 1192056 | 2021-04-05 | McClain | Oklahoma | 40087 | 5153 | 57 |
1188807 | 1188807 | 2021-04-04 | McClain | Oklahoma | 40087 | 5153 | 57 |
1185560 | 1185560 | 2021-04-03 | McClain | Oklahoma | 40087 | 5153 | 57 |
1182313 | 1182313 | 2021-04-02 | McClain | Oklahoma | 40087 | 5153 | 57 |
1179066 | 1179066 | 2021-04-01 | McClain | Oklahoma | 40087 | 5153 | 57 |
1175819 | 1175819 | 2021-03-31 | McClain | Oklahoma | 40087 | 5153 | 57 |
1172572 | 1172572 | 2021-03-30 | McClain | Oklahoma | 40087 | 5127 | 54 |
1169325 | 1169325 | 2021-03-29 | McClain | Oklahoma | 40087 | 5127 | 54 |
1166077 | 1166077 | 2021-03-28 | McClain | Oklahoma | 40087 | 5127 | 54 |
1162829 | 1162829 | 2021-03-27 | McClain | Oklahoma | 40087 | 5127 | 54 |
1159580 | 1159580 | 2021-03-26 | McClain | Oklahoma | 40087 | 5127 | 54 |
1156333 | 1156333 | 2021-03-25 | McClain | Oklahoma | 40087 | 5127 | 54 |
1153086 | 1153086 | 2021-03-24 | McClain | Oklahoma | 40087 | 5127 | 54 |
1149839 | 1149839 | 2021-03-23 | McClain | Oklahoma | 40087 | 5102 | 54 |
1146592 | 1146592 | 2021-03-22 | McClain | Oklahoma | 40087 | 5102 | 54 |
1143345 | 1143345 | 2021-03-21 | McClain | Oklahoma | 40087 | 5102 | 54 |
1140098 | 1140098 | 2021-03-20 | McClain | Oklahoma | 40087 | 5102 | 54 |
1136852 | 1136852 | 2021-03-19 | McClain | Oklahoma | 40087 | 5102 | 54 |
1133606 | 1133606 | 2021-03-18 | McClain | Oklahoma | 40087 | 5102 | 54 |
1130358 | 1130358 | 2021-03-17 | McClain | Oklahoma | 40087 | 5102 | 54 |
1127111 | 1127111 | 2021-03-16 | McClain | Oklahoma | 40087 | 5102 | 54 |
1123865 | 1123865 | 2021-03-15 | McClain | Oklahoma | 40087 | 5102 | 52 |
1120619 | 1120619 | 2021-03-14 | McClain | Oklahoma | 40087 | 5098 | 52 |
1117372 | 1117372 | 2021-03-13 | McClain | Oklahoma | 40087 | 5092 | 52 |
1114125 | 1114125 | 2021-03-12 | McClain | Oklahoma | 40087 | 5085 | 52 |
1110879 | 1110879 | 2021-03-11 | McClain | Oklahoma | 40087 | 5079 | 52 |
1107633 | 1107633 | 2021-03-10 | McClain | Oklahoma | 40087 | 5073 | 52 |
1104387 | 1104387 | 2021-03-09 | McClain | Oklahoma | 40087 | 5069 | 52 |
1101141 | 1101141 | 2021-03-08 | McClain | Oklahoma | 40087 | 5066 | 50 |
1097895 | 1097895 | 2021-03-07 | McClain | Oklahoma | 40087 | 5064 | 50 |
1094647 | 1094647 | 2021-03-06 | McClain | Oklahoma | 40087 | 5061 | 50 |
1091401 | 1091401 | 2021-03-05 | McClain | Oklahoma | 40087 | 5058 | 50 |
1088155 | 1088155 | 2021-03-04 | McClain | Oklahoma | 40087 | 5051 | 50 |
1084910 | 1084910 | 2021-03-03 | McClain | Oklahoma | 40087 | 5040 | 50 |
1081664 | 1081664 | 2021-03-02 | McClain | Oklahoma | 40087 | 5036 | 49 |
1078418 | 1078418 | 2021-03-01 | McClain | Oklahoma | 40087 | 5039 | 48 |
1075173 | 1075173 | 2021-02-28 | McClain | Oklahoma | 40087 | 5028 | 48 |
1071927 | 1071927 | 2021-02-27 | McClain | Oklahoma | 40087 | 5022 | 46 |
1068681 | 1068681 | 2021-02-26 | McClain | Oklahoma | 40087 | 5015 | 46 |
1065436 | 1065436 | 2021-02-25 | McClain | Oklahoma | 40087 | 5011 | 46 |
1062192 | 1062192 | 2021-02-24 | McClain | Oklahoma | 40087 | 5005 | 46 |
1058946 | 1058946 | 2021-02-23 | McClain | Oklahoma | 40087 | 5001 | 45 |
1055700 | 1055700 | 2021-02-22 | McClain | Oklahoma | 40087 | 4999 | 45 |
1052454 | 1052454 | 2021-02-21 | McClain | Oklahoma | 40087 | 4998 | 45 |
1049207 | 1049207 | 2021-02-20 | McClain | Oklahoma | 40087 | 4979 | 45 |
1045960 | 1045960 | 2021-02-19 | McClain | Oklahoma | 40087 | 4977 | 44 |
1042715 | 1042715 | 2021-02-18 | McClain | Oklahoma | 40087 | 4978 | 44 |
1039470 | 1039470 | 2021-02-17 | McClain | Oklahoma | 40087 | 4975 | 44 |
1036225 | 1036225 | 2021-02-16 | McClain | Oklahoma | 40087 | 4967 | 43 |
1032980 | 1032980 | 2021-02-15 | McClain | Oklahoma | 40087 | 4963 | 43 |
1029734 | 1029734 | 2021-02-14 | McClain | Oklahoma | 40087 | 4955 | 43 |
1026487 | 1026487 | 2021-02-13 | McClain | Oklahoma | 40087 | 4935 | 43 |
1023242 | 1023242 | 2021-02-12 | McClain | Oklahoma | 40087 | 4924 | 43 |
1019997 | 1019997 | 2021-02-11 | McClain | Oklahoma | 40087 | 4916 | 43 |
1016752 | 1016752 | 2021-02-10 | McClain | Oklahoma | 40087 | 4880 | 43 |
1013507 | 1013507 | 2021-02-09 | McClain | Oklahoma | 40087 | 4870 | 43 |
1010262 | 1010262 | 2021-02-08 | McClain | Oklahoma | 40087 | 4854 | 43 |
1007016 | 1007016 | 2021-02-07 | McClain | Oklahoma | 40087 | 4843 | 43 |
1003770 | 1003770 | 2021-02-06 | McClain | Oklahoma | 40087 | 4833 | 43 |
1000524 | 1000524 | 2021-02-05 | McClain | Oklahoma | 40087 | 4794 | 43 |
997278 | 997278 | 2021-02-04 | McClain | Oklahoma | 40087 | 4764 | 42 |
994032 | 994032 | 2021-02-03 | McClain | Oklahoma | 40087 | 4742 | 42 |
990786 | 990786 | 2021-02-02 | McClain | Oklahoma | 40087 | 4728 | 40 |
987540 | 987540 | 2021-02-01 | McClain | Oklahoma | 40087 | 4699 | 40 |
984293 | 984293 | 2021-01-31 | McClain | Oklahoma | 40087 | 4657 | 40 |
981046 | 981046 | 2021-01-30 | McClain | Oklahoma | 40087 | 4631 | 39 |
977800 | 977800 | 2021-01-29 | McClain | Oklahoma | 40087 | 4599 | 38 |
974555 | 974555 | 2021-01-28 | McClain | Oklahoma | 40087 | 4567 | 38 |
971310 | 971310 | 2021-01-27 | McClain | Oklahoma | 40087 | 4541 | 37 |
968065 | 968065 | 2021-01-26 | McClain | Oklahoma | 40087 | 4526 | 37 |
964821 | 964821 | 2021-01-25 | McClain | Oklahoma | 40087 | 4516 | 36 |
961576 | 961576 | 2021-01-24 | McClain | Oklahoma | 40087 | 4497 | 36 |
958331 | 958331 | 2021-01-23 | McClain | Oklahoma | 40087 | 4472 | 36 |
955085 | 955085 | 2021-01-22 | McClain | Oklahoma | 40087 | 4441 | 36 |
951840 | 951840 | 2021-01-21 | McClain | Oklahoma | 40087 | 4398 | 36 |
948595 | 948595 | 2021-01-20 | McClain | Oklahoma | 40087 | 4368 | 33 |
945349 | 945349 | 2021-01-19 | McClain | Oklahoma | 40087 | 4351 | 32 |
942102 | 942102 | 2021-01-18 | McClain | Oklahoma | 40087 | 4317 | 32 |
938857 | 938857 | 2021-01-17 | McClain | Oklahoma | 40087 | 4291 | 32 |
935612 | 935612 | 2021-01-16 | McClain | Oklahoma | 40087 | 4266 | 31 |
932367 | 932367 | 2021-01-15 | McClain | Oklahoma | 40087 | 4228 | 31 |
929122 | 929122 | 2021-01-14 | McClain | Oklahoma | 40087 | 4195 | 31 |
925877 | 925877 | 2021-01-13 | McClain | Oklahoma | 40087 | 4163 | 31 |
922631 | 922631 | 2021-01-12 | McClain | Oklahoma | 40087 | 4127 | 31 |
919386 | 919386 | 2021-01-11 | McClain | Oklahoma | 40087 | 4090 | 30 |
916141 | 916141 | 2021-01-10 | McClain | Oklahoma | 40087 | 4043 | 30 |
912896 | 912896 | 2021-01-09 | McClain | Oklahoma | 40087 | 3971 | 30 |
909651 | 909651 | 2021-01-08 | McClain | Oklahoma | 40087 | 3935 | 30 |
906406 | 906406 | 2021-01-07 | McClain | Oklahoma | 40087 | 3878 | 29 |
903160 | 903160 | 2021-01-06 | McClain | Oklahoma | 40087 | 3830 | 28 |
899915 | 899915 | 2021-01-05 | McClain | Oklahoma | 40087 | 3798 | 28 |
896670 | 896670 | 2021-01-04 | McClain | Oklahoma | 40087 | 3778 | 28 |
893424 | 893424 | 2021-01-03 | McClain | Oklahoma | 40087 | 3749 | 28 |
890178 | 890178 | 2021-01-02 | McClain | Oklahoma | 40087 | 3659 | 28 |
886931 | 886931 | 2021-01-01 | McClain | Oklahoma | 40087 | 3561 | 28 |
883686 | 883686 | 2020-12-31 | McClain | Oklahoma | 40087 | 3561 | 28 |
880441 | 880441 | 2020-12-30 | McClain | Oklahoma | 40087 | 3514 | 27 |
877196 | 877196 | 2020-12-29 | McClain | Oklahoma | 40087 | 3493 | 26 |
873951 | 873951 | 2020-12-28 | McClain | Oklahoma | 40087 | 3464 | 25 |
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);