taskmaster: measurements: 5 rows where task = 196

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.

5 rows where task = 196

descending

id ▲	task	contestant	measurement	objective
494	Throw an exercise ball into a bath or put the coconuts in a trolley 196	Bob Mortimer 28	08:32	time ▼ 2
495	Throw an exercise ball into a bath or put the coconuts in a trolley 196	Josh Widdicombe 29	11:00	time ▼ 2
496	Throw an exercise ball into a bath or put the coconuts in a trolley 196	Katherine Ryan 30	05:34	time ▼ 2
497	Throw an exercise ball into a bath or put the coconuts in a trolley 196	Noel Fielding 31	01:29	time ▼ 2
498	Throw an exercise ball into a bath or put the coconuts in a trolley 196	Rob Beckett 32	01:52	time ▼ 2

Advanced export

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

CREATE TABLE measurements (
   id          INTEGER PRIMARY KEY,
   task        INTEGER REFERENCES tasks(id),
   contestant  INTEGER REFERENCES people(id),
   measurement REAL,
   objective   INTEGER REFERENCES objectives(id)
);