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.

22 rows where contestant = 6

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: task, measurement, objective

id ▲ task contestant measurement objective
4 Eat as much watermelon as possible 2 Romesh Ranganathan 6 301 grams ▲ 1
9 Empty the bathtub 4 Romesh Ranganathan 6
02:50
time ▼ 2
12 Find Alex 6 Romesh Ranganathan 6
02:27
time ▼ 2
16 High-five a 55-year-old 8 Romesh Ranganathan 6
01:00:00
time ▼ 2
21 Identify the contents of the pies 9 Romesh Ranganathan 6 3 pies ▲ 3
26 Throw a teabag into a mug 13 Romesh Ranganathan 6 8.5 meters ▲ 4
31 Get an egg as high as possible 16 Romesh Ranganathan 6 1.11 meters ▲ 4
36 Stand up after 100 seconds 17 Romesh Ranganathan 6 12 difference in seconds ▼ 5
39 Guess Frank’s age in minutes 18 Romesh Ranganathan 6 30355028 difference in minutes ▼ 6
43 Make a block of ice disappear 20 Romesh Ranganathan 6
47:30
time ▼ 2
48 Score 11 points 23 Romesh Ranganathan 6
11:12
time ▼ 2
53 Fill an eggcup with tears 24 Romesh Ranganathan 6 10 tears ▲ 7
58 Memorise an Australian Rules Football team 26 Romesh Ranganathan 6 1 names ▲ 8
63 Move the boulder as far as possible 28 Romesh Ranganathan 6 1.75 miles ▲ 9
68 Grow the longest nail 29 Romesh Ranganathan 6 2.2 centimeters ▲ 10
73 Make a bed while holding hands 30 Romesh Ranganathan 6
16:03
time ▼ 2
78 Make a Swedish person blush 31 Romesh Ranganathan 6 33 blush depth in ticks ▲ 11
92 Play mini golf with eggs 34 Romesh Ranganathan 6 68 shots ▼ 12
93 Play mini golf with eggs 34 Romesh Ranganathan 6 36 eggs ▼ 13
94 Play mini golf with eggs 34 Romesh Ranganathan 6 14.333 minutes ▼ 14
95 Play mini golf with eggs 34 Romesh Ranganathan 6 35088 points ▼ 15
103 Separate the blue sweets 37 Romesh Ranganathan 6 12 blue sweets ▲ 16

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 11.999ms