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 = ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c × 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 ▲▼
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1075 observations/events/player/lever 1668106793.654 2022-11-10T18:59:53.654Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T18:59:53.655Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 45",
    "lever_x": -2164,
    "participant_id": "00075",
    "powered": true,
    "lever_y": 61,
    "lever_z": 100,
    "elapsed_milliseconds": 18595,
    "playername": "Player216"
  },
  "@timestamp": "2022-11-10T18:59:53.658Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T18:59:53.654Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1295 observations/events/player/lever 1668106797.8 2022-11-10T18:59:57.800Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T18:59:57.800Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 41",
    "lever_x": -2164,
    "participant_id": "00075",
    "powered": false,
    "lever_y": 61,
    "lever_z": 100,
    "elapsed_milliseconds": 22740,
    "playername": "Player216"
  },
  "@timestamp": "2022-11-10T18:59:57.801Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T18:59:57.800Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1354 observations/events/player/lever 1668106798.85 2022-11-10T18:59:58.850Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T18:59:58.850Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 40",
    "lever_x": -2180,
    "participant_id": "00074",
    "powered": true,
    "lever_y": 61,
    "lever_z": 99,
    "elapsed_milliseconds": 23790,
    "playername": "Player499"
  },
  "@timestamp": "2022-11-10T18:59:58.852Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T18:59:58.850Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1384 observations/events/player/lever 1668106799.349 2022-11-10T18:59:59.349Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T18:59:59.349Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 39",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": true,
    "lever_y": 61,
    "lever_z": 96,
    "elapsed_milliseconds": 24289,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T18:59:59.350Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T18:59:59.349Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1439 observations/events/player/lever 1668106800.299 2022-11-10T19:00:00.299Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:00.299Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 38",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": true,
    "lever_y": 61,
    "lever_z": 97,
    "elapsed_milliseconds": 25239,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:00.325Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:00.299Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1506 observations/events/player/lever 1668106801.349 2022-11-10T19:00:01.349Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:01.349Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 37",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": true,
    "lever_y": 61,
    "lever_z": 99,
    "elapsed_milliseconds": 26289,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:01.353Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:01.349Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1542 observations/events/player/lever 1668106801.95 2022-11-10T19:00:01.950Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:01.950Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 37",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": true,
    "lever_y": 61,
    "lever_z": 100,
    "elapsed_milliseconds": 26890,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:01.953Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:01.950Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1600 observations/events/player/lever 1668106802.9 2022-11-10T19:00:02.900Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:02.900Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 36",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": true,
    "lever_y": 61,
    "lever_z": 98,
    "elapsed_milliseconds": 27840,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:02.900Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:02.900Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 1980 observations/events/player/lever 1668106809.749 2022-11-10T19:00:09.749Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:09.749Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 29",
    "lever_x": -2164,
    "participant_id": "00075",
    "powered": true,
    "lever_y": 61,
    "lever_z": 98,
    "elapsed_milliseconds": 34689,
    "playername": "Player216"
  },
  "@timestamp": "2022-11-10T19:00:09.752Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:09.749Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 2030 observations/events/player/lever 1668106810.649 2022-11-10T19:00:10.649Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:10.649Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 28",
    "lever_x": -2164,
    "participant_id": "00075",
    "powered": true,
    "lever_y": 61,
    "lever_z": 97,
    "elapsed_milliseconds": 35589,
    "playername": "Player216"
  },
  "@timestamp": "2022-11-10T19:00:10.651Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:10.649Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 2104 observations/events/player/lever 1668106811.949 2022-11-10T19:00:11.949Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:11.949Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 27",
    "lever_x": -2180,
    "participant_id": "00074",
    "powered": false,
    "lever_y": 61,
    "lever_z": 99,
    "elapsed_milliseconds": 36889,
    "playername": "Player499"
  },
  "@timestamp": "2022-11-10T19:00:11.952Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:11.949Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 2208 observations/events/player/lever 1668106813.649 2022-11-10T19:00:13.649Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:13.649Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 25",
    "lever_x": -2180,
    "participant_id": "00074",
    "powered": true,
    "lever_y": 61,
    "lever_z": 98,
    "elapsed_milliseconds": 38589,
    "playername": "Player499"
  },
  "@timestamp": "2022-11-10T19:00:13.653Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:13.649Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 2249 observations/events/player/lever 1668106814.251 2022-11-10T19:00:14.251Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:14.251Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "19 : 24",
    "lever_x": -2180,
    "participant_id": "00074",
    "powered": true,
    "lever_y": 61,
    "lever_z": 97,
    "elapsed_milliseconds": 39191,
    "playername": "Player499"
  },
  "@timestamp": "2022-11-10T19:00:14.252Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:14.251Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 4331 observations/events/player/lever 1668106853.049 2022-11-10T19:00:53.049Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:53.049Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "18 : 46",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": false,
    "lever_y": 61,
    "lever_z": 100,
    "elapsed_milliseconds": 77989,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:53.064Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:53.049Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 4389 observations/events/player/lever 1668106853.7 2022-11-10T19:00:53.700Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:53.700Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "18 : 45",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": false,
    "lever_y": 61,
    "lever_z": 99,
    "elapsed_milliseconds": 78640,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:53.701Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:53.700Z"
  },
  "@version": "1"
}
ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c 4479 observations/events/player/lever 1668106855.3 2022-11-10T19:00:55.300Z
{ "host": "b8b97114e35a", "msg": { "sub_type": "Event:Lever", "source": "simulator", "timesta… 
{
  "host": "b8b97114e35a",
  "msg": {
    "sub_type": "Event:Lever",
    "source": "simulator",
    "timestamp": "2022-11-10T19:00:55.300Z",
    "version": "0.5",
    "experiment_id": "d34f3604-e0d0-4e93-bac7-0e401e189a14",
    "trial_id": "ebc6d8fd-6b89-4ea5-8029-04fe3ed4159c"
  },
  "data": {
    "mission_timer": "18 : 43",
    "lever_x": -2172,
    "participant_id": "00082",
    "powered": false,
    "lever_y": 61,
    "lever_z": 96,
    "elapsed_milliseconds": 80240,
    "playername": "Player505"
  },
  "@timestamp": "2022-11-10T19:00:55.303Z",
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-11-10T19:00:55.300Z"
  },
  "@version": "1"
}