ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
715 rows where fips = 40063 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419308 | 1419308 | 2021-06-14 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1416063 | 1416063 | 2021-06-13 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1412817 | 1412817 | 2021-06-12 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1409572 | 1409572 | 2021-06-11 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1406327 | 1406327 | 2021-06-10 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1403081 | 1403081 | 2021-06-09 | Hughes | Oklahoma | 40063 | 1243 | 29 |
1399836 | 1399836 | 2021-06-08 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1396591 | 1396591 | 2021-06-07 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1393344 | 1393344 | 2021-06-06 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1390099 | 1390099 | 2021-06-05 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1386854 | 1386854 | 2021-06-04 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1383609 | 1383609 | 2021-06-03 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1380363 | 1380363 | 2021-06-02 | Hughes | Oklahoma | 40063 | 1242 | 29 |
1377118 | 1377118 | 2021-06-01 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1373872 | 1373872 | 2021-05-31 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1370627 | 1370627 | 2021-05-30 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1367381 | 1367381 | 2021-05-29 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1364135 | 1364135 | 2021-05-28 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1360889 | 1360889 | 2021-05-27 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1357643 | 1357643 | 2021-05-26 | Hughes | Oklahoma | 40063 | 1238 | 29 |
1354397 | 1354397 | 2021-05-25 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1351151 | 1351151 | 2021-05-24 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1347905 | 1347905 | 2021-05-23 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1344657 | 1344657 | 2021-05-22 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1341409 | 1341409 | 2021-05-21 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1338161 | 1338161 | 2021-05-20 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1334914 | 1334914 | 2021-05-19 | Hughes | Oklahoma | 40063 | 1239 | 28 |
1331667 | 1331667 | 2021-05-18 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1328420 | 1328420 | 2021-05-17 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1325174 | 1325174 | 2021-05-16 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1321928 | 1321928 | 2021-05-15 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1318682 | 1318682 | 2021-05-14 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1315434 | 1315434 | 2021-05-13 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1312188 | 1312188 | 2021-05-12 | Hughes | Oklahoma | 40063 | 1237 | 28 |
1308941 | 1308941 | 2021-05-11 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1305695 | 1305695 | 2021-05-10 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1302449 | 1302449 | 2021-05-09 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1299201 | 1299201 | 2021-05-08 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1295955 | 1295955 | 2021-05-07 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1292709 | 1292709 | 2021-05-06 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1289463 | 1289463 | 2021-05-05 | Hughes | Oklahoma | 40063 | 1234 | 28 |
1286217 | 1286217 | 2021-05-04 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1282971 | 1282971 | 2021-05-03 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1279724 | 1279724 | 2021-05-02 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1276477 | 1276477 | 2021-05-01 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1273230 | 1273230 | 2021-04-30 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1269983 | 1269983 | 2021-04-29 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1266736 | 1266736 | 2021-04-28 | Hughes | Oklahoma | 40063 | 1232 | 29 |
1263489 | 1263489 | 2021-04-27 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1260242 | 1260242 | 2021-04-26 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1256995 | 1256995 | 2021-04-25 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1253748 | 1253748 | 2021-04-24 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1250501 | 1250501 | 2021-04-23 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1247254 | 1247254 | 2021-04-22 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1244007 | 1244007 | 2021-04-21 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1240760 | 1240760 | 2021-04-20 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1237513 | 1237513 | 2021-04-19 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1234266 | 1234266 | 2021-04-18 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1231018 | 1231018 | 2021-04-17 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1227770 | 1227770 | 2021-04-16 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1224522 | 1224522 | 2021-04-15 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1221275 | 1221275 | 2021-04-14 | Hughes | Oklahoma | 40063 | 1226 | 29 |
1218027 | 1218027 | 2021-04-13 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1214779 | 1214779 | 2021-04-12 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1211532 | 1211532 | 2021-04-11 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1208283 | 1208283 | 2021-04-10 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1205035 | 1205035 | 2021-04-09 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1201787 | 1201787 | 2021-04-08 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1198538 | 1198538 | 2021-04-07 | Hughes | Oklahoma | 40063 | 1217 | 29 |
1195289 | 1195289 | 2021-04-06 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1192041 | 1192041 | 2021-04-05 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1188792 | 1188792 | 2021-04-04 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1185545 | 1185545 | 2021-04-03 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1182298 | 1182298 | 2021-04-02 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1179051 | 1179051 | 2021-04-01 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1175804 | 1175804 | 2021-03-31 | Hughes | Oklahoma | 40063 | 1207 | 20 |
1172557 | 1172557 | 2021-03-30 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1169310 | 1169310 | 2021-03-29 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1166062 | 1166062 | 2021-03-28 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1162814 | 1162814 | 2021-03-27 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1159565 | 1159565 | 2021-03-26 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1156318 | 1156318 | 2021-03-25 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1153071 | 1153071 | 2021-03-24 | Hughes | Oklahoma | 40063 | 1196 | 19 |
1149824 | 1149824 | 2021-03-23 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1146577 | 1146577 | 2021-03-22 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1143330 | 1143330 | 2021-03-21 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1140083 | 1140083 | 2021-03-20 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1136837 | 1136837 | 2021-03-19 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1133591 | 1133591 | 2021-03-18 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1130343 | 1130343 | 2021-03-17 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1127096 | 1127096 | 2021-03-16 | Hughes | Oklahoma | 40063 | 1183 | 19 |
1123850 | 1123850 | 2021-03-15 | Hughes | Oklahoma | 40063 | 1183 | 18 |
1120604 | 1120604 | 2021-03-14 | Hughes | Oklahoma | 40063 | 1180 | 18 |
1117357 | 1117357 | 2021-03-13 | Hughes | Oklahoma | 40063 | 1178 | 18 |
1114110 | 1114110 | 2021-03-12 | Hughes | Oklahoma | 40063 | 1177 | 18 |
1110864 | 1110864 | 2021-03-11 | Hughes | Oklahoma | 40063 | 1176 | 18 |
1107618 | 1107618 | 2021-03-10 | Hughes | Oklahoma | 40063 | 1176 | 18 |
1104372 | 1104372 | 2021-03-09 | Hughes | Oklahoma | 40063 | 1174 | 18 |
1101126 | 1101126 | 2021-03-08 | Hughes | Oklahoma | 40063 | 1171 | 17 |
1097880 | 1097880 | 2021-03-07 | Hughes | Oklahoma | 40063 | 1171 | 17 |
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);