Column descriptions

where group_session = "exp_2022_11_04_10"

View and edit SQL

Suggested facets: mission_start_timestamp_iso8601 (date), mission_stop_timestamp_iso8601 (date), trial_start_timestamp_iso8601 (date), trial_stop_timestamp_iso8601 (date)

id ▼ group_session name mission_start_timestamp_unix mission_start_timestamp_iso8601 mission_stop_timestamp_unix mission_stop_timestamp_iso8601 trial_start_timestamp_unix trial_start_timestamp_iso8601 trial_stop_timestamp_unix trial_stop_timestamp_iso8601 final_team_score testbed_version
1230c514-d47d-40a9-b341-ccf462867a94 exp_2022_11_04_10 Saturn_B 1667591009.207 2022-11-04T19:43:29.207Z 1667592033.206 2022-11-04T20:00:33.206Z 1667590911.9388 2022-11-04T19:41:51.9388Z 1667592040.1699 2022-11-04T20:00:40.1699Z 600 5_13_2022_FULL_TRIALS-197-g270a77d4
969bd69e-3a33-4ab7-b676-0b56b9c46ef3 exp_2022_11_04_10 Saturn_A 1667589863.102 2022-11-04T19:24:23.102Z 1667590887.106 2022-11-04T19:41:27.106Z 1667589775.2388 2022-11-04T19:22:55.2388Z 1667590896.3559 2022-11-04T19:41:36.3559Z 530 5_13_2022_FULL_TRIALS-197-g270a77d4
a177df32-40c1-4486-9986-b1c98619cbbf exp_2022_11_04_10 Hands-on Training 1667588513.023 2022-11-04T19:01:53.023Z 1667589717.026 2022-11-04T19:21:57.026Z 1667588381.2427 2022-11-04T18:59:41.2427Z 1667589730.7409 2022-11-04T19:22:10.7409Z 160 5_13_2022_FULL_TRIALS-197-g270a77d4

Advanced export

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

CSV options:

CREATE TABLE "minecraft_mission" (
   [id] TEXT PRIMARY KEY,
   [group_session] TEXT REFERENCES [group_session]([id]),
   [name] TEXT,
   [mission_start_timestamp_unix] TEXT,
   [mission_start_timestamp_iso8601] TEXT,
   [mission_stop_timestamp_unix] TEXT,
   [mission_stop_timestamp_iso8601] TEXT,
   [trial_start_timestamp_unix] TEXT,
   [trial_start_timestamp_iso8601] TEXT,
   [trial_stop_timestamp_unix] TEXT,
   [trial_stop_timestamp_iso8601] TEXT,
   [final_team_score] INTEGER,
   [testbed_version] TEXT
);
CREATE INDEX [idx_minecraft_mission_group_session]
    ON [minecraft_mission] ([group_session]);