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 = 7eb49f42-4b38-45e5-95e3-a5bb4045e326 × 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 ▲▼
7eb49f42-4b38-45e5-95e3-a5bb4045e326 695 observations/events/player/lever 1668732612.557 2022-11-18T00:50:12.557Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:12.557Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:12.557Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:12.558Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 51",
    "lever_x": -2180,
    "lever_z": 98,
    "elapsed_milliseconds": 12095
  },
  "@timestamp": "2022-11-18T00:50:12.559Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 790 observations/events/player/lever 1668732614.154 2022-11-18T00:50:14.154Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:14.154Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:14.154Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:14.154Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 50",
    "lever_x": -2180,
    "lever_z": 99,
    "elapsed_milliseconds": 13691
  },
  "@timestamp": "2022-11-18T00:50:14.155Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 859 observations/events/player/lever 1668732615.154 2022-11-18T00:50:15.154Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:15.154Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:15.154Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:15.154Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 49",
    "lever_x": -2180,
    "lever_z": 100,
    "elapsed_milliseconds": 14691
  },
  "@timestamp": "2022-11-18T00:50:15.155Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 1320 observations/events/player/lever 1668732623.405 2022-11-18T00:50:23.405Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:23.405Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:23.405Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:23.405Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 41",
    "lever_x": -2180,
    "lever_z": 96,
    "elapsed_milliseconds": 22942
  },
  "@timestamp": "2022-11-18T00:50:23.435Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 1410 observations/events/player/lever 1668732625.153 2022-11-18T00:50:25.153Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:25.153Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:25.153Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:25.153Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00076",
    "playername": "Player842",
    "mission_timer": "19 : 39",
    "lever_x": -2164,
    "lever_z": 98,
    "elapsed_milliseconds": 24690
  },
  "@timestamp": "2022-11-18T00:50:25.154Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 1449 observations/events/player/lever 1668732625.954 2022-11-18T00:50:25.954Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:25.954Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:25.954Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:25.954Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00076",
    "playername": "Player842",
    "mission_timer": "19 : 38",
    "lever_x": -2164,
    "lever_z": 97,
    "elapsed_milliseconds": 25491
  },
  "@timestamp": "2022-11-18T00:50:25.955Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 2026 observations/events/player/lever 1668732636.254 2022-11-18T00:50:36.254Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:36.254Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:36.254Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:36.254Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 28",
    "lever_x": -2180,
    "lever_z": 97,
    "elapsed_milliseconds": 35791
  },
  "@timestamp": "2022-11-18T00:50:36.256Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 2038 observations/events/player/lever 1668732636.453 2022-11-18T00:50:36.453Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:36.453Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:36.453Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:36.453Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": false,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 28",
    "lever_x": -2180,
    "lever_z": 97,
    "elapsed_milliseconds": 35990
  },
  "@timestamp": "2022-11-18T00:50:36.454Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 2081 observations/events/player/lever 1668732637.253 2022-11-18T00:50:37.253Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:37.253Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:37.253Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:37.253Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 27",
    "lever_x": -2180,
    "lever_z": 97,
    "elapsed_milliseconds": 36790
  },
  "@timestamp": "2022-11-18T00:50:37.254Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 3166 observations/events/player/lever 1668732658.204 2022-11-18T00:50:58.204Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:50:58.204Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:50:58.204Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:50:58.204Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00079",
    "playername": "Player786",
    "mission_timer": "19 : 6",
    "lever_x": -2172,
    "lever_z": 98,
    "elapsed_milliseconds": 57741
  },
  "@timestamp": "2022-11-18T00:50:58.207Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 3481 observations/events/player/lever 1668732664.154 2022-11-18T00:51:04.154Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:51:04.154Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:51:04.154Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:51:04.154Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": false,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "19 : 0",
    "lever_x": -2180,
    "lever_z": 100,
    "elapsed_milliseconds": 63691
  },
  "@timestamp": "2022-11-18T00:51:04.155Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 3572 observations/events/player/lever 1668732665.754 2022-11-18T00:51:05.754Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:51:05.754Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:51:05.754Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:51:05.754Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": false,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "18 : 58",
    "lever_x": -2180,
    "lever_z": 99,
    "elapsed_milliseconds": 65291
  },
  "@timestamp": "2022-11-18T00:51:05.754Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 3626 observations/events/player/lever 1668732666.354 2022-11-18T00:51:06.354Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:51:06.354Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:51:06.354Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:51:06.354Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": true,
    "lever_y": 61,
    "participant_id": "00079",
    "playername": "Player786",
    "mission_timer": "18 : 58",
    "lever_x": -2172,
    "lever_z": 97,
    "elapsed_milliseconds": 65891
  },
  "@timestamp": "2022-11-18T00:51:06.354Z"
}
7eb49f42-4b38-45e5-95e3-a5bb4045e326 4066 observations/events/player/lever 1668732675.105 2022-11-18T00:51:15.105Z
{ "host": "27d08104a102", "header": { "version": "1.1", "timestamp": "2022-11-18T00:51:15.105Z", … 
{
  "host": "27d08104a102",
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-18T00:51:15.105Z",
    "message_type": "event"
  },
  "msg": {
    "source": "simulator",
    "trial_id": "7eb49f42-4b38-45e5-95e3-a5bb4045e326",
    "timestamp": "2022-11-18T00:51:15.105Z",
    "sub_type": "Event:Lever",
    "version": "0.5",
    "experiment_id": "0dddee93-2ea7-49a8-aa4f-fcfbae1cdb90"
  },
  "@version": "1",
  "data": {
    "powered": false,
    "lever_y": 61,
    "participant_id": "00073",
    "playername": "Player159",
    "mission_timer": "18 : 49",
    "lever_x": -2180,
    "lever_z": 96,
    "elapsed_milliseconds": 74642
  },
  "@timestamp": "2022-11-18T00:51:15.107Z"
}