task_winners

16 rows where winner = 106

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: team, live

id ▲ task winner team live
975 The best sign 772 Sue Perkins 106
978 Make a cheeky picture using nails and wire 774 Sue Perkins 106
981 Recite pi 777 Sue Perkins 106
990 Make a surprisingly pleasant sausage 784 Sue Perkins 106
995 Recreate a well-known piece of art on 100 memo squares 786 Sue Perkins 106
997 Tut the loudest 788 Sue Perkins 106
999 Burst the balloon without looking at it 790 Sue Perkins 106
1007 Recreate the garage scene in the lab 796 Sue Perkins 106 ✓
1012 The thing most guaranteed to make you groan 799 Sue Perkins 106
1018 The best single-word object you own and love that gets the best reaction when introduced following a drum roll 805 Sue Perkins 106
1023 Mime proverbs to your team 809 Sue Perkins 106 ✓ ✓
1025 The bit of old crap that Greg likes the best 810 Sue Perkins 106
1026 Obey all of the traffic signals 811 Sue Perkins 106
1027 Make the best gift for Greg 812 Sue Perkins 106
1029 Pass the parade exam 814 Sue Perkins 106 ✓
1034 Give your guest the best service 818 Sue Perkins 106 ✓

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