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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, objective

id ▲ task contestant measurement objective
105 Place the exercise balls on the yoga mat 39 Doc Brown 8
12:25
time ▼ 2
110 Get the potato into the hole 40 Doc Brown 8
06:59
time ▼ 2
115 Find out about the Swedish person 41 Doc Brown 8
10:00
time ▼ 2
116 Find out about the Swedish person 41 Doc Brown 8 3 Fred facts ▲ 17
125 Pack a suitcase 42 Doc Brown 8
DNF / DQ
time ▼ 2
130 Quickly eat an egg 44 Doc Brown 8
03:35
time ▼ 2
135 Order a pizza without using certain words 47 Doc Brown 8 4 mistakes ▼ 18
140 Put potatoes in a basket 48 Doc Brown 8 0 potatoes ▲ 19
145 Impress the Mayor 50 Doc Brown 8 7 mayor's rating ▲ 20
150 See no potato, hear no potato, speak no potato 53 Doc Brown 8
05:49
time ▼ 2
155 Throw rabbits into a hat 54 Doc Brown 8 12 behatted rabbits ▲ 21
160 Conceal a pineapple on your person 57 Doc Brown 8 5 wrong guesses ▲ 22
166 Move items across a stream 62 Doc Brown 8
04:24
time ▼ 2
171 Build a bridge for the potato 64 Doc Brown 8 10 centimeters ▲ 10
176 Put on gloves, eat a banana, put on a tie, and clap 65 Doc Brown 8 237 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 9.201ms