TdlM / taskmaster

Menu
  • Make shortlink

task_winners

14 rows where winner = 45

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
387 The most powerful smell 323 Lou Sanders 45
391 Collect the most doughnuts in your bucket 327 Lou Sanders 45 ✓
402 Build the best volcano 336 Lou Sanders 45
404 Do the worst thing and make the best apology 338 Lou Sanders 45
412 Throw a frying pan into a hoop 344 Lou Sanders 45 ✓
415 Move the sand from one bucket to another 347 Lou Sanders 45
418 Play long-distance catch with a beach ball 349 Lou Sanders 45 ✓
428 Roll a toilet roll, and retrieve your shoe 357 Lou Sanders 45 ✓
429 The best slippery thing 358 Lou Sanders 45
438 Catch the tennis balls 365 Lou Sanders 45 ✓
442 The best form of protection 368 Lou Sanders 45
443 Get a ball into a bin with the most bounces 369 Lou Sanders 45
446 Make yourselves look like one person 371 Lou Sanders 45 ✓
450 Stack plates and bowls on your head 373 Lou Sanders 45 ✓

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