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 = 9

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
106 Place the exercise balls on the yoga mat 39 Joe Wilkinson 9
09:01
time ▼ 2
111 Get the potato into the hole 40 Joe Wilkinson 9
14.3
time ▼ 2
117 Find out about the Swedish person 41 Joe Wilkinson 9
16:20
time ▼ 2
118 Find out about the Swedish person 41 Joe Wilkinson 9 0 Fred facts ▲ 17
126 Pack a suitcase 42 Joe Wilkinson 9
DNF / DQ
time ▼ 2
131 Quickly eat an egg 44 Joe Wilkinson 9
10:46
time ▼ 2
136 Order a pizza without using certain words 47 Joe Wilkinson 9 1 mistakes ▼ 18
141 Put potatoes in a basket 48 Joe Wilkinson 9 0 potatoes ▲ 19
146 Impress the Mayor 50 Joe Wilkinson 9 7 mayor's rating ▲ 20
151 See no potato, hear no potato, speak no potato 53 Joe Wilkinson 9
05:49
time ▼ 2
156 Throw rabbits into a hat 54 Joe Wilkinson 9 12 behatted rabbits ▲ 21
161 Conceal a pineapple on your person 57 Joe Wilkinson 9
INCONCLUSIVE
wrong guesses ▲ 22
167 Move items across a stream 62 Joe Wilkinson 9
01:52
time ▼ 2
172 Build a bridge for the potato 64 Joe Wilkinson 9 9 centimeters ▲ 10
177 Put on gloves, eat a banana, put on a tie, and clap 65 Joe Wilkinson 9 234 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 8.662ms