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 = b4202882-6710-4776-9054-fe3de1ea3f31 × 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 ▲▼
b4202882-6710-4776-9054-fe3de1ea3f31 5091 observations/events/player/lever 1682635708.7022133 2023-04-27T22:48:28.702213+00:00
{ "data": { "elapsed_milliseconds": 33044, "lever_x": -2180, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 33044,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 30",
    "participant_id": "99999",
    "playername": "Player457",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:28.705Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:28.705Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5207 observations/events/player/lever 1682635710.6973865 2023-04-27T22:48:30.697387+00:00
{ "data": { "elapsed_milliseconds": 35040, "lever_x": -2180, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 35040,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 28",
    "participant_id": "99999",
    "playername": "Player457",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:30.701Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:30.701Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5525 observations/events/player/lever 1682635717.1986241 2023-04-27T22:48:37.198624+00:00
{ "data": { "elapsed_milliseconds": 41541, "lever_x": -2164, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 41541,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "19 : 22",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:37.202Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:37.202Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5578 observations/events/player/lever 1682635718.298451 2023-04-27T22:48:38.298451+00:00
{ "data": { "elapsed_milliseconds": 42641, "lever_x": -2164, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 42641,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 21",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:38.302Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:38.302Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5621 observations/events/player/lever 1682635719.1485906 2023-04-27T22:48:39.148591+00:00
{ "data": { "elapsed_milliseconds": 43491, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 43491,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 20",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:39.152Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:39.152Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5670 observations/events/player/lever 1682635719.748862 2023-04-27T22:48:39.748862+00:00
{ "data": { "elapsed_milliseconds": 44091, "lever_x": -2164, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 44091,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 19",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:39.752Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:39.752Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5866 observations/events/player/lever 1682635723.6974149 2023-04-27T22:48:43.697415+00:00
{ "data": { "elapsed_milliseconds": 48040, "lever_x": -2164, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 48040,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "19 : 15",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:43.701Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:43.701Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 5877 observations/events/player/lever 1682635723.8981118 2023-04-27T22:48:43.898112+00:00
{ "data": { "elapsed_milliseconds": 48240, "lever_x": -2164, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 48240,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "19 : 15",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:48:43.901Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:48:43.901Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 7389 observations/events/player/lever 1682635749.8923967 2023-04-27T22:49:09.892397+00:00
{ "data": { "elapsed_milliseconds": 74191, "lever_x": -2164, "lever_y": 61, "lever_z": 100,… 
{
  "data": {
    "elapsed_milliseconds": 74191,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 100,
    "mission_timer": "18 : 49",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:49:09.852Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:49:09.852Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 7433 observations/events/player/lever 1682635750.5982957 2023-04-27T22:49:10.598296+00:00
{ "data": { "elapsed_milliseconds": 74941, "lever_x": -2164, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 74941,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "18 : 49",
    "participant_id": "00154",
    "playername": "Player510",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:49:10.602Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:49:10.602Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 7605 observations/events/player/lever 1682635753.449897 2023-04-27T22:49:13.449897+00:00
{ "data": { "elapsed_milliseconds": 77792, "lever_x": -2172, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 77792,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "18 : 46",
    "participant_id": "00161",
    "playername": "Player288",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:49:13.453Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:49:13.453Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}
b4202882-6710-4776-9054-fe3de1ea3f31 7977 observations/events/player/lever 1682635759.6480393 2023-04-27T22:49:19.648039+00:00
{ "data": { "elapsed_milliseconds": 83990, "lever_x": -2172, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 83990,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 40",
    "participant_id": "00161",
    "playername": "Player288",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-27T22:49:19.651Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "2033a1a2-f88c-494b-9116-c042944215f2",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-27T22:49:19.651Z",
    "trial_id": "b4202882-6710-4776-9054-fe3de1ea3f31",
    "version": "0.5"
  }
}