minecraft_testbed_message

Messages sent over the testbed's message bus during missions.

Column descriptions
mission
The ID of the Minecraft mission during which the message was published.
id
Sequential ID of the message within the mission.
topic
The topic the message was published on.
timestamp_unix
The Unix timestamp of the message.
timestamp_iso8601
The timestamp of the message in ISO-8601 format.
message
The contents of the message, stored as JSON; use your database's JSON functions and operators to query into it.

~5,856,114 rows (estimated)

Filters: mission = dc8efe49-dd5b-4070-b822-4e6a641a475c × topic = observations/events/player/lever × clear all

This data as JSON, CSV (capped; for the full dataset, download the database).

mission
topic
mission ▲▼ id ▲▼ topic ▲▼ timestamp_unix ▲▼ timestamp_iso8601 ▲▼ message ▲▼
dc8efe49-dd5b-4070-b822-4e6a641a475c 6085 observations/events/player/lever 1682372358.1779587 2023-04-24T21:39:18.177959+00:00
{ "data": { "elapsed_milliseconds": 31397, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 31397,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 32",
    "participant_id": "00153",
    "playername": "Player20",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:18.179Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:18.180Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 6203 observations/events/player/lever 1682372360.1723154 2023-04-24T21:39:20.172315+00:00
{ "data": { "elapsed_milliseconds": 33391, "lever_x": -2164, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 33391,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 30",
    "participant_id": "00153",
    "playername": "Player20",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:20.175Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:20.175Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 6382 observations/events/player/lever 1682372363.8229604 2023-04-24T21:39:23.822960+00:00
{ "data": { "elapsed_milliseconds": 37042, "lever_x": -2180, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 37042,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "19 : 26",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:23.826Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:23.826Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 6414 observations/events/player/lever 1682372364.4226143 2023-04-24T21:39:24.422614+00:00
{ "data": { "elapsed_milliseconds": 37641, "lever_x": -2180, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 37641,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 26",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:24.425Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:24.425Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 6443 observations/events/player/lever 1682372364.9224641 2023-04-24T21:39:24.922464+00:00
{ "data": { "elapsed_milliseconds": 38141, "lever_x": -2180, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 38141,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 25",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:24.925Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:24.925Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 6481 observations/events/player/lever 1682372365.5223672 2023-04-24T21:39:25.522367+00:00
{ "data": { "elapsed_milliseconds": 38741, "lever_x": -2180, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 38741,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 25",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:25.525Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:25.525Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 6517 observations/events/player/lever 1682372366.1225464 2023-04-24T21:39:26.122546+00:00
{ "data": { "elapsed_milliseconds": 39341, "lever_x": -2180, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 39341,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "19 : 24",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:26.125Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:26.125Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 8114 observations/events/player/lever 1682372396.1231468 2023-04-24T21:39:56.123147+00:00
{ "data": { "elapsed_milliseconds": 69342, "lever_x": -2180, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 69342,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "18 : 54",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:56.126Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:56.126Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 8161 observations/events/player/lever 1682372396.9725885 2023-04-24T21:39:56.972589+00:00
{ "data": { "elapsed_milliseconds": 70191, "lever_x": -2180, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 70191,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "18 : 53",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:56.975Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:56.975Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 8269 observations/events/player/lever 1682372398.7225044 2023-04-24T21:39:58.722504+00:00
{ "data": { "elapsed_milliseconds": 71941, "lever_x": -2180, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 71941,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "18 : 52",
    "participant_id": "00151",
    "playername": "Player198",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:39:58.725Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:39:58.725Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 10262 observations/events/player/lever 1682372435.0751355 2023-04-24T21:40:35.075135+00:00
{ "data": { "elapsed_milliseconds": 108294, "lever_x": -2172, "lever_y": 61, "lever_z": 99,… 
{
  "data": {
    "elapsed_milliseconds": 108294,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "18 : 15",
    "participant_id": "00159",
    "playername": "Player327",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:40:35.078Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:40:35.078Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 10364 observations/events/player/lever 1682372436.9726713 2023-04-24T21:40:36.972671+00:00
{ "data": { "elapsed_milliseconds": 110191, "lever_x": -2172, "lever_y": 61, "lever_z": 98,… 
{
  "data": {
    "elapsed_milliseconds": 110191,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "18 : 13",
    "participant_id": "00159",
    "playername": "Player327",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:40:36.975Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:40:36.975Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 10601 observations/events/player/lever 1682372441.0746412 2023-04-24T21:40:41.074641+00:00
{ "data": { "elapsed_milliseconds": 114293, "lever_x": -2172, "lever_y": 61, "lever_z": 99,… 
{
  "data": {
    "elapsed_milliseconds": 114293,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "18 : 9",
    "participant_id": "00159",
    "playername": "Player327",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:40:41.077Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:40:41.077Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}
dc8efe49-dd5b-4070-b822-4e6a641a475c 10671 observations/events/player/lever 1682372442.3229384 2023-04-24T21:40:42.322938+00:00
{ "data": { "elapsed_milliseconds": 115541, "lever_x": -2172, "lever_y": 61, "lever_z": 97,… 
{
  "data": {
    "elapsed_milliseconds": 115541,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 8",
    "participant_id": "00159",
    "playername": "Player327",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-24T21:40:42.325Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "5f934654-be2d-42ba-9dca-cdaf3a03ad93",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-24T21:40:42.325Z",
    "trial_id": "dc8efe49-dd5b-4070-b822-4e6a641a475c",
    "version": "0.5"
  }
}