task_winners

8 rows where winner = 99

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
901 Compose and perform a musical solo 722 Ivo Graham 99
905 Build a bridge over the red green for this potato 723 Ivo Graham 99 ✓
909 Exit the caravan after exactly 20 minutes 727 Ivo Graham 99
912 Perform a slow-motion fight scene 729 Ivo Graham 99 ✓
913 Know the most facts about sausages 730 Ivo Graham 99 ✓
934 Rotate the pulper wheel without pulping the egg 747 Ivo Graham 99
951 Make these things the same colour 757 Ivo Graham 99 ✓
955 Deliver a one-minute history lecture 758 Ivo Graham 99

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
);