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.

15 rows where contestant = 11

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, objective

id ▲ task contestant measurement objective
108 Place the exercise balls on the yoga mat 39 Katherine Ryan 11
07:36
time ▼ 2
113 Get the potato into the hole 40 Katherine Ryan 11
06:28
time ▼ 2
121 Find out about the Swedish person 41 Katherine Ryan 11
15:41
time ▼ 2
122 Find out about the Swedish person 41 Katherine Ryan 11 6 Fred facts ▲ 17
128 Pack a suitcase 42 Katherine Ryan 11
02:34
time ▼ 2
133 Quickly eat an egg 44 Katherine Ryan 11
DNF / DQ
time ▼ 2
138 Order a pizza without using certain words 47 Katherine Ryan 11 1 mistakes ▼ 18
143 Put potatoes in a basket 48 Katherine Ryan 11 5 potatoes ▲ 19
148 Impress the Mayor 50 Katherine Ryan 11 8 mayor's rating ▲ 20
153 See no potato, hear no potato, speak no potato 53 Katherine Ryan 11
05:49
time ▼ 2
158 Throw rabbits into a hat 54 Katherine Ryan 11 15 behatted rabbits ▲ 21
163 Conceal a pineapple on your person 57 Katherine Ryan 11 14 wrong guesses ▲ 22
169 Move items across a stream 62 Katherine Ryan 11
02:44
time ▼ 2
174 Build a bridge for the potato 64 Katherine Ryan 11 0.1 centimeters ▲ 10
179 Put on gloves, eat a banana, put on a tie, and clap 65 Katherine Ryan 11 221 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 16.977ms