TdlM / taskmaster

Menu
  • Make shortlink

intros

5 rows where person = 23

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ series clip person task
172 Series 5 5 ▶ Aisling Bea 23
UNAIRED
184 Series 5 5 ▶ Aisling Bea 23 Transport a coconut as far as possible 190
194 Series 5 5 ▶ Aisling Bea 23 Create a remarkable water cooler moment 172
197 Series 5 5 ▶ Aisling Bea 23 Travel blindfolded for three minutes and retrace your steps 184
203 Series 5 5 ▶ Aisling Bea 23 Give Alex a special cuddle 147

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE intros (
   id     INTEGER PRIMARY KEY,
   series INTEGER REFERENCES series(id),
   clip   INTEGER,
   person INTEGER REFERENCES people(id),
   task   INTEGER REFERENCES tasks(id)
);
Powered by Datasette · Queries took 4959.171ms