Column descriptions

where group_session = "exp_2022_09_30_10" and "mission_stop_timestamp_iso8601" is on date 2022-09-30

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- remove filter - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

- column - 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

= != contains ends with starts with > ≥ < ≤ like not like glob in not in array contains array does not contain date is null is not null is blank is not blank

Sort... Sort by id Sort by group_session Sort by name Sort by mission_start_timestamp_unix Sort by mission_start_timestamp_iso8601 Sort by mission_stop_timestamp_unix Sort by mission_stop_timestamp_iso8601 Sort by trial_start_timestamp_unix Sort by trial_start_timestamp_iso8601 Sort by trial_stop_timestamp_unix Sort by trial_stop_timestamp_iso8601 Sort by final_team_score Sort by testbed_version

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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