ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 40071 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195293 | 1195293 | 2021-04-06 | Kay | Oklahoma | 40071 | 5244 | 86 |
1192045 | 1192045 | 2021-04-05 | Kay | Oklahoma | 40071 | 5244 | 86 |
1188796 | 1188796 | 2021-04-04 | Kay | Oklahoma | 40071 | 5244 | 86 |
1185549 | 1185549 | 2021-04-03 | Kay | Oklahoma | 40071 | 5244 | 86 |
1182302 | 1182302 | 2021-04-02 | Kay | Oklahoma | 40071 | 5244 | 86 |
1179055 | 1179055 | 2021-04-01 | Kay | Oklahoma | 40071 | 5244 | 86 |
1175808 | 1175808 | 2021-03-31 | Kay | Oklahoma | 40071 | 5244 | 86 |
1172561 | 1172561 | 2021-03-30 | Kay | Oklahoma | 40071 | 5209 | 85 |
1169314 | 1169314 | 2021-03-29 | Kay | Oklahoma | 40071 | 5209 | 85 |
1166066 | 1166066 | 2021-03-28 | Kay | Oklahoma | 40071 | 5209 | 85 |
1162818 | 1162818 | 2021-03-27 | Kay | Oklahoma | 40071 | 5209 | 85 |
1159569 | 1159569 | 2021-03-26 | Kay | Oklahoma | 40071 | 5209 | 85 |
1156322 | 1156322 | 2021-03-25 | Kay | Oklahoma | 40071 | 5209 | 85 |
1153075 | 1153075 | 2021-03-24 | Kay | Oklahoma | 40071 | 5209 | 85 |
1149828 | 1149828 | 2021-03-23 | Kay | Oklahoma | 40071 | 5134 | 84 |
1146581 | 1146581 | 2021-03-22 | Kay | Oklahoma | 40071 | 5134 | 84 |
1143334 | 1143334 | 2021-03-21 | Kay | Oklahoma | 40071 | 5134 | 84 |
1140087 | 1140087 | 2021-03-20 | Kay | Oklahoma | 40071 | 5134 | 84 |
1136841 | 1136841 | 2021-03-19 | Kay | Oklahoma | 40071 | 5134 | 84 |
1133595 | 1133595 | 2021-03-18 | Kay | Oklahoma | 40071 | 5134 | 84 |
1130347 | 1130347 | 2021-03-17 | Kay | Oklahoma | 40071 | 5134 | 84 |
1127100 | 1127100 | 2021-03-16 | Kay | Oklahoma | 40071 | 5134 | 84 |
1123854 | 1123854 | 2021-03-15 | Kay | Oklahoma | 40071 | 5134 | 83 |
1120608 | 1120608 | 2021-03-14 | Kay | Oklahoma | 40071 | 5126 | 83 |
1117361 | 1117361 | 2021-03-13 | Kay | Oklahoma | 40071 | 5126 | 83 |
1114114 | 1114114 | 2021-03-12 | Kay | Oklahoma | 40071 | 5117 | 83 |
1110868 | 1110868 | 2021-03-11 | Kay | Oklahoma | 40071 | 5116 | 83 |
1107622 | 1107622 | 2021-03-10 | Kay | Oklahoma | 40071 | 5107 | 83 |
1104376 | 1104376 | 2021-03-09 | Kay | Oklahoma | 40071 | 5104 | 83 |
1101130 | 1101130 | 2021-03-08 | Kay | Oklahoma | 40071 | 5104 | 81 |
1097884 | 1097884 | 2021-03-07 | Kay | Oklahoma | 40071 | 5102 | 81 |
1094636 | 1094636 | 2021-03-06 | Kay | Oklahoma | 40071 | 5100 | 81 |
1091390 | 1091390 | 2021-03-05 | Kay | Oklahoma | 40071 | 5098 | 81 |
1088144 | 1088144 | 2021-03-04 | Kay | Oklahoma | 40071 | 5089 | 81 |
1084899 | 1084899 | 2021-03-03 | Kay | Oklahoma | 40071 | 5087 | 81 |
1081653 | 1081653 | 2021-03-02 | Kay | Oklahoma | 40071 | 5086 | 81 |
1078407 | 1078407 | 2021-03-01 | Kay | Oklahoma | 40071 | 5084 | 80 |
1075162 | 1075162 | 2021-02-28 | Kay | Oklahoma | 40071 | 5080 | 79 |
1071916 | 1071916 | 2021-02-27 | Kay | Oklahoma | 40071 | 5071 | 77 |
1068670 | 1068670 | 2021-02-26 | Kay | Oklahoma | 40071 | 5066 | 76 |
1065425 | 1065425 | 2021-02-25 | Kay | Oklahoma | 40071 | 5064 | 75 |
1062181 | 1062181 | 2021-02-24 | Kay | Oklahoma | 40071 | 5054 | 75 |
1058935 | 1058935 | 2021-02-23 | Kay | Oklahoma | 40071 | 5052 | 75 |
1055689 | 1055689 | 2021-02-22 | Kay | Oklahoma | 40071 | 5049 | 74 |
1052443 | 1052443 | 2021-02-21 | Kay | Oklahoma | 40071 | 5048 | 73 |
1049196 | 1049196 | 2021-02-20 | Kay | Oklahoma | 40071 | 5040 | 72 |
1045949 | 1045949 | 2021-02-19 | Kay | Oklahoma | 40071 | 5034 | 72 |
1042704 | 1042704 | 2021-02-18 | Kay | Oklahoma | 40071 | 5030 | 72 |
1039459 | 1039459 | 2021-02-17 | Kay | Oklahoma | 40071 | 5026 | 71 |
1036214 | 1036214 | 2021-02-16 | Kay | Oklahoma | 40071 | 5013 | 69 |
1032969 | 1032969 | 2021-02-15 | Kay | Oklahoma | 40071 | 5012 | 69 |
1029723 | 1029723 | 2021-02-14 | Kay | Oklahoma | 40071 | 5007 | 68 |
1026476 | 1026476 | 2021-02-13 | Kay | Oklahoma | 40071 | 5001 | 68 |
1023231 | 1023231 | 2021-02-12 | Kay | Oklahoma | 40071 | 4994 | 68 |
1019986 | 1019986 | 2021-02-11 | Kay | Oklahoma | 40071 | 4984 | 67 |
1016741 | 1016741 | 2021-02-10 | Kay | Oklahoma | 40071 | 4943 | 66 |
1013496 | 1013496 | 2021-02-09 | Kay | Oklahoma | 40071 | 4939 | 66 |
1010251 | 1010251 | 2021-02-08 | Kay | Oklahoma | 40071 | 4935 | 64 |
1007005 | 1007005 | 2021-02-07 | Kay | Oklahoma | 40071 | 4923 | 64 |
1003759 | 1003759 | 2021-02-06 | Kay | Oklahoma | 40071 | 4893 | 62 |
1000513 | 1000513 | 2021-02-05 | Kay | Oklahoma | 40071 | 4847 | 60 |
997267 | 997267 | 2021-02-04 | Kay | Oklahoma | 40071 | 4829 | 60 |
994021 | 994021 | 2021-02-03 | Kay | Oklahoma | 40071 | 4798 | 60 |
990775 | 990775 | 2021-02-02 | Kay | Oklahoma | 40071 | 4790 | 59 |
987529 | 987529 | 2021-02-01 | Kay | Oklahoma | 40071 | 4783 | 58 |
984282 | 984282 | 2021-01-31 | Kay | Oklahoma | 40071 | 4774 | 58 |
981035 | 981035 | 2021-01-30 | Kay | Oklahoma | 40071 | 4758 | 57 |
977789 | 977789 | 2021-01-29 | Kay | Oklahoma | 40071 | 4737 | 57 |
974544 | 974544 | 2021-01-28 | Kay | Oklahoma | 40071 | 4679 | 56 |
971299 | 971299 | 2021-01-27 | Kay | Oklahoma | 40071 | 4641 | 55 |
968054 | 968054 | 2021-01-26 | Kay | Oklahoma | 40071 | 4595 | 55 |
964810 | 964810 | 2021-01-25 | Kay | Oklahoma | 40071 | 4577 | 55 |
961565 | 961565 | 2021-01-24 | Kay | Oklahoma | 40071 | 4559 | 54 |
958320 | 958320 | 2021-01-23 | Kay | Oklahoma | 40071 | 4529 | 54 |
955074 | 955074 | 2021-01-22 | Kay | Oklahoma | 40071 | 4437 | 52 |
951829 | 951829 | 2021-01-21 | Kay | Oklahoma | 40071 | 4363 | 51 |
948584 | 948584 | 2021-01-20 | Kay | Oklahoma | 40071 | 4338 | 51 |
945338 | 945338 | 2021-01-19 | Kay | Oklahoma | 40071 | 4297 | 48 |
942091 | 942091 | 2021-01-18 | Kay | Oklahoma | 40071 | 4260 | 48 |
938846 | 938846 | 2021-01-17 | Kay | Oklahoma | 40071 | 4235 | 48 |
935601 | 935601 | 2021-01-16 | Kay | Oklahoma | 40071 | 4184 | 47 |
932356 | 932356 | 2021-01-15 | Kay | Oklahoma | 40071 | 4137 | 47 |
929111 | 929111 | 2021-01-14 | Kay | Oklahoma | 40071 | 4045 | 45 |
925866 | 925866 | 2021-01-13 | Kay | Oklahoma | 40071 | 3996 | 44 |
922620 | 922620 | 2021-01-12 | Kay | Oklahoma | 40071 | 3937 | 44 |
919375 | 919375 | 2021-01-11 | Kay | Oklahoma | 40071 | 3913 | 44 |
916130 | 916130 | 2021-01-10 | Kay | Oklahoma | 40071 | 3852 | 44 |
912885 | 912885 | 2021-01-09 | Kay | Oklahoma | 40071 | 3745 | 44 |
909640 | 909640 | 2021-01-08 | Kay | Oklahoma | 40071 | 3700 | 44 |
906395 | 906395 | 2021-01-07 | Kay | Oklahoma | 40071 | 3661 | 43 |
903149 | 903149 | 2021-01-06 | Kay | Oklahoma | 40071 | 3619 | 40 |
899904 | 899904 | 2021-01-05 | Kay | Oklahoma | 40071 | 3540 | 34 |
896659 | 896659 | 2021-01-04 | Kay | Oklahoma | 40071 | 3524 | 34 |
893413 | 893413 | 2021-01-03 | Kay | Oklahoma | 40071 | 3509 | 34 |
890167 | 890167 | 2021-01-02 | Kay | Oklahoma | 40071 | 3374 | 33 |
886920 | 886920 | 2021-01-01 | Kay | Oklahoma | 40071 | 3312 | 33 |
883675 | 883675 | 2020-12-31 | Kay | Oklahoma | 40071 | 3312 | 33 |
880430 | 880430 | 2020-12-30 | Kay | Oklahoma | 40071 | 3232 | 31 |
877185 | 877185 | 2020-12-29 | Kay | Oklahoma | 40071 | 3159 | 31 |
873940 | 873940 | 2020-12-28 | Kay | Oklahoma | 40071 | 3154 | 30 |
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);