TdlM / taskmaster

Menu
  • Make shortlink

measurements

Table actions
  • Toggle column notes
measurement
A value of "?" indicates that no conclusive measurement was given, with null used to signify a DNF/DQ. Note that times are stored internally as seconds but presented in D:HH:MM:SS format.

16 rows where contestant = 10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
107 Place the exercise balls on the yoga mat 39 Jon Richardson 10
06:37
time ▼ 2
112 Get the potato into the hole 40 Jon Richardson 10
01:09
time ▼ 2
119 Find out about the Swedish person 41 Jon Richardson 10
15:26
time ▼ 2
120 Find out about the Swedish person 41 Jon Richardson 10 5 Fred facts ▲ 17
127 Pack a suitcase 42 Jon Richardson 10
02:04
time ▼ 2
132 Quickly eat an egg 44 Jon Richardson 10
05:12
time ▼ 2
137 Order a pizza without using certain words 47 Jon Richardson 10 2 mistakes ▼ 18
142 Put potatoes in a basket 48 Jon Richardson 10 11 potatoes ▲ 19
147 Impress the Mayor 50 Jon Richardson 10 5 mayor's rating ▲ 20
152 See no potato, hear no potato, speak no potato 53 Jon Richardson 10
04:59
time ▼ 2
157 Throw rabbits into a hat 54 Jon Richardson 10 4 behatted rabbits ▲ 21
162 Conceal a pineapple on your person 57 Jon Richardson 10 20 wrong guesses ▲ 22
165 Set a task / Guess who set the tasks 58 Jon Richardson 10 4 guessed tasks ▲ 23
168 Move items across a stream 62 Jon Richardson 10
03:14
time ▼ 2
173 Build a bridge for the potato 64 Jon Richardson 10 11.4 centimeters ▲ 10
178 Put on gloves, eat a banana, put on a tie, and clap 65 Jon Richardson 10 192 claps ▲ 24

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE measurements (
   id          INTEGER PRIMARY KEY,
   task        INTEGER REFERENCES tasks(id),
   contestant  INTEGER REFERENCES people(id),
   measurement REAL,
   objective   INTEGER REFERENCES objectives(id)
);
Powered by Datasette · Queries took 96.652ms