ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Lincoln" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1490725 | 1490725 | 2021-07-06 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1487478 | 1487478 | 2021-07-05 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1484231 | 1484231 | 2021-07-04 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1480985 | 1480985 | 2021-07-03 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1477738 | 1477738 | 2021-07-02 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1474492 | 1474492 | 2021-07-01 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1471246 | 1471246 | 2021-06-30 | Lincoln | Oklahoma | 40081 | 3281 | 72 |
1468001 | 1468001 | 2021-06-29 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1464756 | 1464756 | 2021-06-28 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1461511 | 1461511 | 2021-06-27 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1458266 | 1458266 | 2021-06-26 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1455021 | 1455021 | 2021-06-25 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1451776 | 1451776 | 2021-06-24 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1448530 | 1448530 | 2021-06-23 | Lincoln | Oklahoma | 40081 | 3266 | 72 |
1445285 | 1445285 | 2021-06-22 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1442040 | 1442040 | 2021-06-21 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1438795 | 1438795 | 2021-06-20 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1435548 | 1435548 | 2021-06-19 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1432301 | 1432301 | 2021-06-18 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1429055 | 1429055 | 2021-06-17 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1425810 | 1425810 | 2021-06-16 | Lincoln | Oklahoma | 40081 | 3263 | 72 |
1422563 | 1422563 | 2021-06-15 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1419317 | 1419317 | 2021-06-14 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1416072 | 1416072 | 2021-06-13 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1412826 | 1412826 | 2021-06-12 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1409581 | 1409581 | 2021-06-11 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1406336 | 1406336 | 2021-06-10 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1403090 | 1403090 | 2021-06-09 | Lincoln | Oklahoma | 40081 | 3258 | 72 |
1399845 | 1399845 | 2021-06-08 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1396600 | 1396600 | 2021-06-07 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1393353 | 1393353 | 2021-06-06 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1390108 | 1390108 | 2021-06-05 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1386863 | 1386863 | 2021-06-04 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1383618 | 1383618 | 2021-06-03 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1380372 | 1380372 | 2021-06-02 | Lincoln | Oklahoma | 40081 | 3252 | 72 |
1377127 | 1377127 | 2021-06-01 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1373881 | 1373881 | 2021-05-31 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1370636 | 1370636 | 2021-05-30 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1367390 | 1367390 | 2021-05-29 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1364144 | 1364144 | 2021-05-28 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1360898 | 1360898 | 2021-05-27 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1357652 | 1357652 | 2021-05-26 | Lincoln | Oklahoma | 40081 | 3249 | 72 |
1354406 | 1354406 | 2021-05-25 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1351160 | 1351160 | 2021-05-24 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1347914 | 1347914 | 2021-05-23 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1344666 | 1344666 | 2021-05-22 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1341418 | 1341418 | 2021-05-21 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1338170 | 1338170 | 2021-05-20 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1334923 | 1334923 | 2021-05-19 | Lincoln | Oklahoma | 40081 | 3248 | 72 |
1331676 | 1331676 | 2021-05-18 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1328429 | 1328429 | 2021-05-17 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1325183 | 1325183 | 2021-05-16 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1321937 | 1321937 | 2021-05-15 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1318691 | 1318691 | 2021-05-14 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1315443 | 1315443 | 2021-05-13 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1312197 | 1312197 | 2021-05-12 | Lincoln | Oklahoma | 40081 | 3245 | 71 |
1308950 | 1308950 | 2021-05-11 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1305704 | 1305704 | 2021-05-10 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1302458 | 1302458 | 2021-05-09 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1299210 | 1299210 | 2021-05-08 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1295964 | 1295964 | 2021-05-07 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1292718 | 1292718 | 2021-05-06 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1289472 | 1289472 | 2021-05-05 | Lincoln | Oklahoma | 40081 | 3239 | 71 |
1286226 | 1286226 | 2021-05-04 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1282980 | 1282980 | 2021-05-03 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1279733 | 1279733 | 2021-05-02 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1276486 | 1276486 | 2021-05-01 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1273239 | 1273239 | 2021-04-30 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1269992 | 1269992 | 2021-04-29 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1266745 | 1266745 | 2021-04-28 | Lincoln | Oklahoma | 40081 | 3230 | 70 |
1263498 | 1263498 | 2021-04-27 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1260251 | 1260251 | 2021-04-26 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1257004 | 1257004 | 2021-04-25 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1253757 | 1253757 | 2021-04-24 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1250510 | 1250510 | 2021-04-23 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1247263 | 1247263 | 2021-04-22 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1244016 | 1244016 | 2021-04-21 | Lincoln | Oklahoma | 40081 | 3213 | 70 |
1240769 | 1240769 | 2021-04-20 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1237522 | 1237522 | 2021-04-19 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1234275 | 1234275 | 2021-04-18 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1231027 | 1231027 | 2021-04-17 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1227779 | 1227779 | 2021-04-16 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1224531 | 1224531 | 2021-04-15 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1221284 | 1221284 | 2021-04-14 | Lincoln | Oklahoma | 40081 | 3198 | 69 |
1218036 | 1218036 | 2021-04-13 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1214788 | 1214788 | 2021-04-12 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1211541 | 1211541 | 2021-04-11 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1208292 | 1208292 | 2021-04-10 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1205044 | 1205044 | 2021-04-09 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1201796 | 1201796 | 2021-04-08 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1198547 | 1198547 | 2021-04-07 | Lincoln | Oklahoma | 40081 | 3176 | 69 |
1195298 | 1195298 | 2021-04-06 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1192050 | 1192050 | 2021-04-05 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1188801 | 1188801 | 2021-04-04 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1185554 | 1185554 | 2021-04-03 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1182307 | 1182307 | 2021-04-02 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1179060 | 1179060 | 2021-04-01 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1175813 | 1175813 | 2021-03-31 | Lincoln | Oklahoma | 40081 | 3161 | 58 |
1172566 | 1172566 | 2021-03-30 | Lincoln | Oklahoma | 40081 | 3138 | 58 |
1169319 | 1169319 | 2021-03-29 | Lincoln | Oklahoma | 40081 | 3138 | 58 |
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);