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 = 4e56778d-75d1-4e86-9ae3-2a26e992ec2a × 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 ▲▼
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5174 observations/events/player/lever 1681858300.0447266 2023-04-18T22:51:40.044727+00:00
{ "data": { "elapsed_milliseconds": 17593, "lever_x": -2180, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 17593,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "19 : 46",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:40.046Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:40.047Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5239 observations/events/player/lever 1681858301.1915004 2023-04-18T22:51:41.191500+00:00
{ "data": { "elapsed_milliseconds": 18740, "lever_x": -2180, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 18740,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 45",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:41.194Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:41.194Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5290 observations/events/player/lever 1681858301.6932893 2023-04-18T22:51:41.693289+00:00
{ "data": { "elapsed_milliseconds": 19242, "lever_x": -2180, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 19242,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 44",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:41.696Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:41.696Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5338 observations/events/player/lever 1681858302.5906467 2023-04-18T22:51:42.590647+00:00
{ "data": { "elapsed_milliseconds": 20139, "lever_x": -2180, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 20139,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 43",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:42.593Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:42.593Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5361 observations/events/player/lever 1681858302.9909055 2023-04-18T22:51:42.990906+00:00
{ "data": { "elapsed_milliseconds": 20540, "lever_x": -2180, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 20540,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "19 : 43",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:42.994Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:42.994Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5500 observations/events/player/lever 1681858305.7912621 2023-04-18T22:51:45.791262+00:00
{ "data": { "elapsed_milliseconds": 23340, "lever_x": -2164, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 23340,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "19 : 40",
    "participant_id": "00136",
    "playername": "Player154",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:45.794Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:45.794Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5526 observations/events/player/lever 1681858306.2910218 2023-04-18T22:51:46.291022+00:00
{ "data": { "elapsed_milliseconds": 23840, "lever_x": -2164, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 23840,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "19 : 40",
    "participant_id": "00136",
    "playername": "Player154",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:46.294Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:46.294Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5543 observations/events/player/lever 1681858306.5413053 2023-04-18T22:51:46.541305+00:00
{ "data": { "elapsed_milliseconds": 24090, "lever_x": -2172, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 24090,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 39",
    "participant_id": "00137",
    "playername": "Player45",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:46.544Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:46.544Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5584 observations/events/player/lever 1681858307.3908365 2023-04-18T22:51:47.390836+00:00
{ "data": { "elapsed_milliseconds": 24940, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 24940,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 39",
    "participant_id": "00136",
    "playername": "Player154",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:47.394Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:47.394Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5651 observations/events/player/lever 1681858308.6907182 2023-04-18T22:51:48.690718+00:00
{ "data": { "elapsed_milliseconds": 26239, "lever_x": -2172, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 26239,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 37",
    "participant_id": "00137",
    "playername": "Player45",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:48.693Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:48.693Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5721 observations/events/player/lever 1681858310.0410297 2023-04-18T22:51:50.041030+00:00
{ "data": { "elapsed_milliseconds": 27590, "lever_x": -2164, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 27590,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 36",
    "participant_id": "00136",
    "playername": "Player154",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:50.044Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:50.044Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 5970 observations/events/player/lever 1681858314.190759 2023-04-18T22:51:54.190759+00:00
{ "data": { "elapsed_milliseconds": 31740, "lever_x": -2180, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 31740,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 32",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:54.194Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:54.194Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 6019 observations/events/player/lever 1681858315.1405914 2023-04-18T22:51:55.140591+00:00
{ "data": { "elapsed_milliseconds": 32690, "lever_x": -2180, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 32690,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 31",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:55.144Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:55.144Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 6046 observations/events/player/lever 1681858315.591986 2023-04-18T22:51:55.591986+00:00
{ "data": { "elapsed_milliseconds": 33141, "lever_x": -2180, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 33141,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "19 : 30",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:55.595Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:55.595Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 6093 observations/events/player/lever 1681858316.494679 2023-04-18T22:51:56.494679+00:00
{ "data": { "elapsed_milliseconds": 34044, "lever_x": -2180, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 34044,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 29",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:56.498Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:56.498Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 6136 observations/events/player/lever 1681858317.2915642 2023-04-18T22:51:57.291564+00:00
{ "data": { "elapsed_milliseconds": 34840, "lever_x": -2180, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 34840,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "19 : 29",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:51:57.294Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:51:57.294Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 7289 observations/events/player/lever 1681858336.8908174 2023-04-18T22:52:16.890817+00:00
{ "data": { "elapsed_milliseconds": 54440, "lever_x": -2180, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 54440,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 9",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:52:16.894Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:52:16.894Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}
4e56778d-75d1-4e86-9ae3-2a26e992ec2a 8482 observations/events/player/lever 1681858357.641226 2023-04-18T22:52:37.641226+00:00
{ "data": { "elapsed_milliseconds": 75190, "lever_x": -2180, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 75190,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 48",
    "participant_id": "00134",
    "playername": "Player250",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-18T22:52:37.644Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "0c9047a3-d143-4bb0-9fef-3aeb6ca528e6",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-18T22:52:37.644Z",
    "trial_id": "4e56778d-75d1-4e86-9ae3-2a26e992ec2a",
    "version": "0.5"
  }
}