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 |
---|---|---|---|---|---|---|---|
1279728 | 1279728 | 2021-05-02 | Kay | Oklahoma | 40071 | 5305 | 126 |
1276481 | 1276481 | 2021-05-01 | Kay | Oklahoma | 40071 | 5305 | 126 |
1273234 | 1273234 | 2021-04-30 | Kay | Oklahoma | 40071 | 5305 | 126 |
1269987 | 1269987 | 2021-04-29 | Kay | Oklahoma | 40071 | 5305 | 126 |
1266740 | 1266740 | 2021-04-28 | Kay | Oklahoma | 40071 | 5305 | 126 |
1263493 | 1263493 | 2021-04-27 | Kay | Oklahoma | 40071 | 5290 | 125 |
1260246 | 1260246 | 2021-04-26 | Kay | Oklahoma | 40071 | 5290 | 125 |
1256999 | 1256999 | 2021-04-25 | Kay | Oklahoma | 40071 | 5290 | 125 |
1253752 | 1253752 | 2021-04-24 | Kay | Oklahoma | 40071 | 5290 | 125 |
1250505 | 1250505 | 2021-04-23 | Kay | Oklahoma | 40071 | 5290 | 125 |
1247258 | 1247258 | 2021-04-22 | Kay | Oklahoma | 40071 | 5290 | 125 |
1244011 | 1244011 | 2021-04-21 | Kay | Oklahoma | 40071 | 5290 | 125 |
1240764 | 1240764 | 2021-04-20 | Kay | Oklahoma | 40071 | 5283 | 125 |
1237517 | 1237517 | 2021-04-19 | Kay | Oklahoma | 40071 | 5283 | 125 |
1234270 | 1234270 | 2021-04-18 | Kay | Oklahoma | 40071 | 5283 | 125 |
1231022 | 1231022 | 2021-04-17 | Kay | Oklahoma | 40071 | 5283 | 125 |
1227774 | 1227774 | 2021-04-16 | Kay | Oklahoma | 40071 | 5283 | 125 |
1224526 | 1224526 | 2021-04-15 | Kay | Oklahoma | 40071 | 5283 | 125 |
1221279 | 1221279 | 2021-04-14 | Kay | Oklahoma | 40071 | 5283 | 125 |
1218031 | 1218031 | 2021-04-13 | Kay | Oklahoma | 40071 | 5259 | 125 |
1214783 | 1214783 | 2021-04-12 | Kay | Oklahoma | 40071 | 5259 | 125 |
1211536 | 1211536 | 2021-04-11 | Kay | Oklahoma | 40071 | 5259 | 125 |
1208287 | 1208287 | 2021-04-10 | Kay | Oklahoma | 40071 | 5259 | 125 |
1205039 | 1205039 | 2021-04-09 | Kay | Oklahoma | 40071 | 5259 | 125 |
1201791 | 1201791 | 2021-04-08 | Kay | Oklahoma | 40071 | 5259 | 125 |
1198542 | 1198542 | 2021-04-07 | Kay | Oklahoma | 40071 | 5259 | 125 |
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 |
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);