TdlM / taskmaster

Menu
  • Make shortlink

task_winners

11 rows where winner = 50

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
467 Arrange the playdough balls / Do the correct things with the balls 388 Jo Brand 50 ✓
472 Break something and put it back together 393 Jo Brand 50
478 Bring a classic board game to life 397 Jo Brand 50 ✓
484 Lasso Alex 401 Jo Brand 50
485 Make an accurate and inventive egg timer 402 Jo Brand 50
492 Make a body part abnormally long 406 Jo Brand 50
495 Serenade yourself 408 Jo Brand 50
504 Horse or laminator? 414 Jo Brand 50 ✓
505 The best thing from a shed 415 Jo Brand 50
516 Communicate pictures by drawing on your team-mate’s back 424 Jo Brand 50 ✓ ✓
522 Make a cup of tea 427 Jo Brand 50 ✓

Advanced export

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

CSV options:

CREATE TABLE task_winners (
   id     INTEGER PRIMARY KEY,
   task   INTEGER REFERENCES tasks(id),
   winner INTEGER REFERENCES people(id),
   team   INTEGER,
   live   INTEGER
);
Powered by Datasette · Queries took 8.4ms