TdlM / taskmaster

Menu
  • Make shortlink

task_winners

15 rows where winner = 37

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team

id ▲ task winner team live
235 The best liquid 206 Tim Vine 37
241 The best non-living hairy thing 212 Tim Vine 37
247 The most magnificent day trip 218 Tim Vine 37
256 Have the most fun in 3 minutes 225 Tim Vine 37 ✓
261 Exactly recreate your 3 minutes of fun 226 Tim Vine 37 ✓
266 Work out the length of a piece of string 231 Tim Vine 37
271 Remove the tablecloth from underneath the eggs 232 Tim Vine 37
274 Identify the link and do it 100 times 233 Tim Vine 37 ✓
275 Pull off an elaborate snooker trick shot 234 Tim Vine 37
277 The best invention 236 Tim Vine 37
281 Knock over the ducks without leaving the carpet 238 Tim Vine 37 ✓
292 Make and eat a pancake with objects tucked into your sweatband 246 Tim Vine 37
297 Make a join-the-dots image using stiletto heels 251 Tim Vine 37
300 The most pleasing cat-sized thing 254 Tim Vine 37
304 Make an outfit with stationery / Guess what pun Tim will make 257 Tim Vine 37

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