Column descriptions

where group_session = "exp_2022_09_30_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) 1

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
3140d1d9-0962-417e-9044-643d4d675eeb exp_2022_09_30_10 Hands-on Training 1664565264.115 2022-09-30T19:14:24.115Z 1664566468.117 2022-09-30T19:34:28.117Z 1664565139.1154 2022-09-30T19:12:19.1154Z 1664566511.5122 2022-09-30T19:35:11.5122Z   5_13_2022_FULL_TRIALS-189-gc2ccbe24
b2c7a24f-2aff-43a4-99e7-ee0aab174b2b exp_2022_09_30_10 Saturn_A 1664566860.556 2022-09-30T19:41:00.556Z 1664567884.558 2022-09-30T19:58:04.558Z 1664566589.2712 2022-09-30T19:36:29.2712Z 1664567888.9927 2022-09-30T19:58:08.9927Z 60 5_13_2022_FULL_TRIALS-189-gc2ccbe24

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]);