Column descriptions

where group_session = "exp_2022_11_15_13"

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
17692491-32bd-4099-931a-83439c834b87 exp_2022_11_15_13 Saturn_B 1668551446.887 2022-11-15T22:30:46.887Z 1668552470.887 2022-11-15T22:47:50.887Z 1668551341.7804 2022-11-15T22:29:01.7804Z 1668552485.0067 2022-11-15T22:48:05.0067Z 730 5_13_2022_FULL_TRIALS-197-g270a77d4
38075ea6-1243-4c7d-8ef4-92b8cdc28fdb exp_2022_11_15_13 Saturn_A 1668550246.246 2022-11-15T22:10:46.246Z 1668551270.245 2022-11-15T22:27:50.245Z 1668550117.5605 2022-11-15T22:08:37.5605Z 1668551323.7712 2022-11-15T22:28:43.7712Z 670 5_13_2022_FULL_TRIALS-197-g270a77d4
869dc779-bf86-4d39-917b-b80469e8eb9b exp_2022_11_15_13 Hands-on Training 1668548867.879 2022-11-15T21:47:47.879Z 1668550071.881 2022-11-15T22:07:51.881Z 1668548674.2872 2022-11-15T21:44:34.2872Z 1668550093.5314 2022-11-15T22:08:13.5314Z 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]);