TdlM / taskmaster

Menu
  • Make shortlink

task_winners

9 rows where winner = 46

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
394 Make a moustache from something unexpected 330 Paul Sinha 46
399 Name a bird, eat a grape, name a contestant 334 Paul Sinha 46 ✓
408 Make the best thing to entertain a toddler 342 Paul Sinha 46
419 Play long-distance catch with a beach ball 349 Paul Sinha 46 ✓
426 Recall the order of the deck of cards 355 Paul Sinha 46
435 The nicest thing to hold 363 Paul Sinha 46
439 Catch the tennis balls 365 Paul Sinha 46 ✓
441 Complete the five-syllable words 367 Paul Sinha 46 ✓
447 Make yourselves look like one person 371 Paul Sinha 46 ✓

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.924ms