TdlM / taskmaster

Menu
  • Make shortlink

intros

7 rows where person = 39

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲ series clip person task
248 Series 7 7 ▶ Jessica Knappett 39 Paint a blindfolded still life 272
253 Series 7 7 ▶ Jessica Knappett 39 Put the largest numeric value of money in the floating bowl 312
257 Series 7 7 ▶ Jessica Knappett 39 Put on overalls and lie on the ground when the siren sounds 318
262 Series 7 7 ▶ Jessica Knappett 39 Make the best noise 279
267 Series 7 7 ▶ Jessica Knappett 39 Get the ball into the hole by striking it 280
276 Series 7 7 ▶ Jessica Knappett 39 Cheer up the traffic warden 291
281 Series 7 7 ▶ Jessica Knappett 39 Find the satsuma in a sock 314

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 6.82ms