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 = 8922cf7d-77c8-4e09-be00-71ef4d02f786 × 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 ▲▼
8922cf7d-77c8-4e09-be00-71ef4d02f786 923 observations/events/player/lever 1676929803.653 2023-02-20T21:50:03.653Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:03.653Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:03.653Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player661",
    "mission_timer": "19 : 48",
    "participant_id": "99999",
    "lever_z": 98,
    "lever_y": 61,
    "elapsed_milliseconds": 15341,
    "lever_x": -2164,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:03.653Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:03.663Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 994 observations/events/player/lever 1676929804.851 2023-02-20T21:50:04.851Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:04.851Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:04.851Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player661",
    "mission_timer": "19 : 47",
    "participant_id": "99999",
    "lever_z": 97,
    "lever_y": 61,
    "elapsed_milliseconds": 16538,
    "lever_x": -2164,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:04.851Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:04.853Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 1345 observations/events/player/lever 1676929811.0 2023-02-20T21:50:11Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:11Z", "message_type": "event" … 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:11Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 41",
    "participant_id": "00118",
    "lever_z": 96,
    "lever_y": 61,
    "elapsed_milliseconds": 22687,
    "lever_x": -2172,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:11Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:11.002Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 1372 observations/events/player/lever 1676929811.551 2023-02-20T21:50:11.551Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:11.551Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:11.551Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 40",
    "participant_id": "00118",
    "lever_z": 97,
    "lever_y": 61,
    "elapsed_milliseconds": 23238,
    "lever_x": -2172,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:11.551Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:11.553Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 1402 observations/events/player/lever 1676929812.101 2023-02-20T21:50:12.101Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:12.101Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:12.101Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 40",
    "participant_id": "00118",
    "lever_z": 98,
    "lever_y": 61,
    "elapsed_milliseconds": 23788,
    "lever_x": -2172,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:12.101Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:12.101Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 1464 observations/events/player/lever 1676929813.251 2023-02-20T21:50:13.251Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:13.251Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:13.251Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 39",
    "participant_id": "00118",
    "lever_z": 99,
    "lever_y": 61,
    "elapsed_milliseconds": 24938,
    "lever_x": -2172,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:13.251Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:13.253Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 1517 observations/events/player/lever 1676929814.301 2023-02-20T21:50:14.301Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:14.301Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:14.301Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 38",
    "participant_id": "00118",
    "lever_z": 100,
    "lever_y": 61,
    "elapsed_milliseconds": 25988,
    "lever_x": -2172,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:14.301Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:14.303Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 2538 observations/events/player/lever 1676929832.001 2023-02-20T21:50:32.001Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:32.001Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:32.001Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 20",
    "participant_id": "00118",
    "lever_z": 100,
    "lever_y": 61,
    "elapsed_milliseconds": 43688,
    "lever_x": -2172,
    "powered": false
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:32.001Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:32.002Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 2600 observations/events/player/lever 1676929833.151 2023-02-20T21:50:33.151Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:33.151Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:33.151Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 19",
    "participant_id": "00118",
    "lever_z": 99,
    "lever_y": 61,
    "elapsed_milliseconds": 44838,
    "lever_x": -2172,
    "powered": false
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:33.151Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:33.153Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 2732 observations/events/player/lever 1676929835.7 2023-02-20T21:50:35.700Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:35.700Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:35.700Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player257",
    "mission_timer": "19 : 16",
    "participant_id": "00118",
    "lever_z": 96,
    "lever_y": 61,
    "elapsed_milliseconds": 47387,
    "lever_x": -2172,
    "powered": false
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:35.700Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:35.700Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 3078 observations/events/player/lever 1676929841.801 2023-02-20T21:50:41.801Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:41.801Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:41.801Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player226",
    "mission_timer": "19 : 10",
    "participant_id": "00112",
    "lever_z": 98,
    "lever_y": 61,
    "elapsed_milliseconds": 53488,
    "lever_x": -2180,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:41.801Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:41.802Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 3159 observations/events/player/lever 1676929843.102 2023-02-20T21:50:43.102Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:43.102Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:43.102Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player226",
    "mission_timer": "19 : 9",
    "participant_id": "00112",
    "lever_z": 99,
    "lever_y": 61,
    "elapsed_milliseconds": 54789,
    "lever_x": -2180,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:43.102Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:43.104Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 3218 observations/events/player/lever 1676929844.051 2023-02-20T21:50:44.051Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:44.051Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:44.051Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player226",
    "mission_timer": "19 : 8",
    "participant_id": "00112",
    "lever_z": 100,
    "lever_y": 61,
    "elapsed_milliseconds": 55738,
    "lever_x": -2180,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:44.051Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:44.052Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 3592 observations/events/player/lever 1676929850.5 2023-02-20T21:50:50.500Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:50.500Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:50.500Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player226",
    "mission_timer": "19 : 1",
    "participant_id": "00112",
    "lever_z": 100,
    "lever_y": 61,
    "elapsed_milliseconds": 62187,
    "lever_x": -2180,
    "powered": false
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:50.500Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:50.505Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 3735 observations/events/player/lever 1676929852.551 2023-02-20T21:50:52.551Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:52.551Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:52.551Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player226",
    "mission_timer": "18 : 59",
    "participant_id": "00112",
    "lever_z": 99,
    "lever_y": 61,
    "elapsed_milliseconds": 64238,
    "lever_x": -2180,
    "powered": false
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:52.551Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:52.551Z",
  "@version": "1",
  "host": "952d37679e4c"
}
8922cf7d-77c8-4e09-be00-71ef4d02f786 3825 observations/events/player/lever 1676929853.951 2023-02-20T21:50:53.951Z
{ "header": { "version": "1.1", "timestamp": "2023-02-20T21:50:53.951Z", "message_type": "event… 
{
  "header": {
    "version": "1.1",
    "timestamp": "2023-02-20T21:50:53.951Z",
    "message_type": "event"
  },
  "data": {
    "playername": "Player226",
    "mission_timer": "18 : 58",
    "participant_id": "00112",
    "lever_z": 97,
    "lever_y": 61,
    "elapsed_milliseconds": 65638,
    "lever_x": -2180,
    "powered": true
  },
  "msg": {
    "timestamp": "2023-02-20T21:50:53.951Z",
    "experiment_id": "6518114e-545f-44d4-86e7-f605e34649a5",
    "source": "simulator",
    "version": "0.5",
    "trial_id": "8922cf7d-77c8-4e09-be00-71ef4d02f786",
    "sub_type": "Event:Lever"
  },
  "@timestamp": "2023-02-20T21:50:53.952Z",
  "@version": "1",
  "host": "952d37679e4c"
}