ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where fips = 40031 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279708 | 1279708 | 2021-05-02 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1276461 | 1276461 | 2021-05-01 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1273214 | 1273214 | 2021-04-30 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1269967 | 1269967 | 2021-04-29 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1266720 | 1266720 | 2021-04-28 | Comanche | Oklahoma | 40031 | 13703 | 183 |
1263473 | 1263473 | 2021-04-27 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1260226 | 1260226 | 2021-04-26 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1256979 | 1256979 | 2021-04-25 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1253732 | 1253732 | 2021-04-24 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1250485 | 1250485 | 2021-04-23 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1247238 | 1247238 | 2021-04-22 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1243991 | 1243991 | 2021-04-21 | Comanche | Oklahoma | 40031 | 13608 | 182 |
1240744 | 1240744 | 2021-04-20 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1237497 | 1237497 | 2021-04-19 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1234250 | 1234250 | 2021-04-18 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1231002 | 1231002 | 2021-04-17 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1227754 | 1227754 | 2021-04-16 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1224506 | 1224506 | 2021-04-15 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1221259 | 1221259 | 2021-04-14 | Comanche | Oklahoma | 40031 | 13508 | 182 |
1218011 | 1218011 | 2021-04-13 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1214763 | 1214763 | 2021-04-12 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1211516 | 1211516 | 2021-04-11 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1208267 | 1208267 | 2021-04-10 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1205019 | 1205019 | 2021-04-09 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1201771 | 1201771 | 2021-04-08 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1198522 | 1198522 | 2021-04-07 | Comanche | Oklahoma | 40031 | 13257 | 181 |
1195273 | 1195273 | 2021-04-06 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1192025 | 1192025 | 2021-04-05 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1188776 | 1188776 | 2021-04-04 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1185529 | 1185529 | 2021-04-03 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1182282 | 1182282 | 2021-04-02 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1179035 | 1179035 | 2021-04-01 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1175788 | 1175788 | 2021-03-31 | Comanche | Oklahoma | 40031 | 13059 | 148 |
1172541 | 1172541 | 2021-03-30 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1169294 | 1169294 | 2021-03-29 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1166046 | 1166046 | 2021-03-28 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1162798 | 1162798 | 2021-03-27 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1159549 | 1159549 | 2021-03-26 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1156302 | 1156302 | 2021-03-25 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1153055 | 1153055 | 2021-03-24 | Comanche | Oklahoma | 40031 | 12821 | 148 |
1149808 | 1149808 | 2021-03-23 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1146561 | 1146561 | 2021-03-22 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1143314 | 1143314 | 2021-03-21 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1140067 | 1140067 | 2021-03-20 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1136821 | 1136821 | 2021-03-19 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1133575 | 1133575 | 2021-03-18 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1130327 | 1130327 | 2021-03-17 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1127080 | 1127080 | 2021-03-16 | Comanche | Oklahoma | 40031 | 12535 | 146 |
1123834 | 1123834 | 2021-03-15 | Comanche | Oklahoma | 40031 | 12535 | 145 |
1120588 | 1120588 | 2021-03-14 | Comanche | Oklahoma | 40031 | 12503 | 145 |
1117341 | 1117341 | 2021-03-13 | Comanche | Oklahoma | 40031 | 12455 | 145 |
1114094 | 1114094 | 2021-03-12 | Comanche | Oklahoma | 40031 | 12391 | 145 |
1110848 | 1110848 | 2021-03-11 | Comanche | Oklahoma | 40031 | 12355 | 145 |
1107602 | 1107602 | 2021-03-10 | Comanche | Oklahoma | 40031 | 12323 | 145 |
1104356 | 1104356 | 2021-03-09 | Comanche | Oklahoma | 40031 | 12288 | 145 |
1101110 | 1101110 | 2021-03-08 | Comanche | Oklahoma | 40031 | 12271 | 140 |
1097864 | 1097864 | 2021-03-07 | Comanche | Oklahoma | 40031 | 12244 | 140 |
1094616 | 1094616 | 2021-03-06 | Comanche | Oklahoma | 40031 | 12218 | 140 |
1091370 | 1091370 | 2021-03-05 | Comanche | Oklahoma | 40031 | 12179 | 140 |
1088124 | 1088124 | 2021-03-04 | Comanche | Oklahoma | 40031 | 12142 | 140 |
1084879 | 1084879 | 2021-03-03 | Comanche | Oklahoma | 40031 | 12091 | 140 |
1081633 | 1081633 | 2021-03-02 | Comanche | Oklahoma | 40031 | 12072 | 140 |
1078387 | 1078387 | 2021-03-01 | Comanche | Oklahoma | 40031 | 12053 | 135 |
1075142 | 1075142 | 2021-02-28 | Comanche | Oklahoma | 40031 | 11995 | 131 |
1071896 | 1071896 | 2021-02-27 | Comanche | Oklahoma | 40031 | 11986 | 131 |
1068650 | 1068650 | 2021-02-26 | Comanche | Oklahoma | 40031 | 11951 | 131 |
1065405 | 1065405 | 2021-02-25 | Comanche | Oklahoma | 40031 | 11899 | 130 |
1062161 | 1062161 | 2021-02-24 | Comanche | Oklahoma | 40031 | 11854 | 129 |
1058915 | 1058915 | 2021-02-23 | Comanche | Oklahoma | 40031 | 11802 | 128 |
1055669 | 1055669 | 2021-02-22 | Comanche | Oklahoma | 40031 | 11783 | 128 |
1052423 | 1052423 | 2021-02-21 | Comanche | Oklahoma | 40031 | 11769 | 127 |
1049176 | 1049176 | 2021-02-20 | Comanche | Oklahoma | 40031 | 11726 | 127 |
1045929 | 1045929 | 2021-02-19 | Comanche | Oklahoma | 40031 | 11654 | 127 |
1042684 | 1042684 | 2021-02-18 | Comanche | Oklahoma | 40031 | 11599 | 126 |
1039439 | 1039439 | 2021-02-17 | Comanche | Oklahoma | 40031 | 11570 | 125 |
1036194 | 1036194 | 2021-02-16 | Comanche | Oklahoma | 40031 | 11499 | 124 |
1032949 | 1032949 | 2021-02-15 | Comanche | Oklahoma | 40031 | 11479 | 124 |
1029703 | 1029703 | 2021-02-14 | Comanche | Oklahoma | 40031 | 11443 | 124 |
1026456 | 1026456 | 2021-02-13 | Comanche | Oklahoma | 40031 | 11411 | 123 |
1023211 | 1023211 | 2021-02-12 | Comanche | Oklahoma | 40031 | 11366 | 123 |
1019966 | 1019966 | 2021-02-11 | Comanche | Oklahoma | 40031 | 11317 | 123 |
1016721 | 1016721 | 2021-02-10 | Comanche | Oklahoma | 40031 | 11172 | 122 |
1013476 | 1013476 | 2021-02-09 | Comanche | Oklahoma | 40031 | 11105 | 121 |
1010231 | 1010231 | 2021-02-08 | Comanche | Oklahoma | 40031 | 11042 | 120 |
1006985 | 1006985 | 2021-02-07 | Comanche | Oklahoma | 40031 | 11025 | 120 |
1003739 | 1003739 | 2021-02-06 | Comanche | Oklahoma | 40031 | 10951 | 117 |
1000493 | 1000493 | 2021-02-05 | Comanche | Oklahoma | 40031 | 10884 | 115 |
997247 | 997247 | 2021-02-04 | Comanche | Oklahoma | 40031 | 10742 | 115 |
994001 | 994001 | 2021-02-03 | Comanche | Oklahoma | 40031 | 10568 | 111 |
990755 | 990755 | 2021-02-02 | Comanche | Oklahoma | 40031 | 10401 | 109 |
987509 | 987509 | 2021-02-01 | Comanche | Oklahoma | 40031 | 10334 | 106 |
984262 | 984262 | 2021-01-31 | Comanche | Oklahoma | 40031 | 10251 | 106 |
981015 | 981015 | 2021-01-30 | Comanche | Oklahoma | 40031 | 10085 | 105 |
977769 | 977769 | 2021-01-29 | Comanche | Oklahoma | 40031 | 10023 | 104 |
974524 | 974524 | 2021-01-28 | Comanche | Oklahoma | 40031 | 9892 | 104 |
971279 | 971279 | 2021-01-27 | Comanche | Oklahoma | 40031 | 9791 | 104 |
968034 | 968034 | 2021-01-26 | Comanche | Oklahoma | 40031 | 9627 | 100 |
964790 | 964790 | 2021-01-25 | Comanche | Oklahoma | 40031 | 9470 | 100 |
961545 | 961545 | 2021-01-24 | Comanche | Oklahoma | 40031 | 9431 | 99 |
958300 | 958300 | 2021-01-23 | Comanche | Oklahoma | 40031 | 9322 | 96 |
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);