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)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19d3c2d4-403a-42df-a44e-2a4295d71e68 | exp_2023_05_02_14 | Hands-on Training | 1683068331.223626 | 2023-05-02T22:58:51.223626+00:00 | 1683069535.2234726 | 2023-05-02T23:18:55.223473+00:00 | 1683068206.5947983 | 2023-05-02T22:56:46.594798+00:00 | 1683069546.9873867 | 2023-05-02T23:19:06.987387+00:00 | 230 | 5_13_2022_FULL_TRIALS-197-g270a77d4 |
| 91870f05-d116-4247-8ea6-cbf24e3f175a | exp_2023_05_02_14 | Saturn_A | 1683069638.9014394 | 2023-05-02T23:20:38.901439+00:00 | 1683070662.9006445 | 2023-05-02T23:37:42.900645+00:00 | 1683069572.557897 | 2023-05-02T23:19:32.557897+00:00 | 1683070664.9278917 | 2023-05-02T23:37:44.927892+00:00 | 640 | 5_13_2022_FULL_TRIALS-197-g270a77d4 |
| dd04b37b-a151-4b2d-a1fc-b31a1984760d | exp_2023_05_02_14 | Saturn_B | 1683070751.9623492 | 2023-05-02T23:39:11.962349+00:00 | 1683071775.960164 | 2023-05-02T23:56:15.960164+00:00 | 1683070680.1545477 | 2023-05-02T23:38:00.154548+00:00 | 1683071778.0373292 | 2023-05-02T23:56:18.037329+00:00 | 660 | 5_13_2022_FULL_TRIALS-197-g270a77d4 |
JSON shape: default, array, newline-delimited, object
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 );