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 = 0438231f-afe3-4390-aba5-9482fb268da7 × 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 ▲▼
0438231f-afe3-4390-aba5-9482fb268da7 1432 observations/events/player/lever 1669143905.658 2022-11-22T19:05:05.658Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:05.658Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:05.658Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 97,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 25892,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "19 : 38"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:05.658Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:05.659Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 1502 observations/events/player/lever 1669143906.809 2022-11-22T19:05:06.809Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:06.809Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:06.809Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 96,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 27042,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "19 : 36"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:06.809Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:06.810Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 1566 observations/events/player/lever 1669143907.806 2022-11-22T19:05:07.806Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:07.806Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:07.806Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 98,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 28039,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "19 : 35"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:07.806Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:07.811Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 1627 observations/events/player/lever 1669143908.705 2022-11-22T19:05:08.705Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:08.705Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:08.705Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 99,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 28938,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "19 : 35"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:08.705Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:08.727Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 1676 observations/events/player/lever 1669143909.705 2022-11-22T19:05:09.705Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:09.705Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:09.705Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 100,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 29938,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "19 : 34"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:09.705Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:09.708Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 2243 observations/events/player/lever 1669143920.556 2022-11-22T19:05:20.556Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:20.556Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:20.556Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 100,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 40789,
    "participant_id": "00088",
    "powered": false,
    "mission_timer": "19 : 23"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:20.556Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:20.556Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 2332 observations/events/player/lever 1669143922.255 2022-11-22T19:05:22.255Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:22.255Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:22.255Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 99,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 42488,
    "participant_id": "00088",
    "powered": false,
    "mission_timer": "19 : 21"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:22.255Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:22.268Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 2606 observations/events/player/lever 1669143927.205 2022-11-22T19:05:27.205Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:27.205Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:27.205Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 98,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 47438,
    "participant_id": "00088",
    "powered": false,
    "mission_timer": "19 : 16"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:27.205Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:27.207Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 2663 observations/events/player/lever 1669143928.306 2022-11-22T19:05:28.306Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:28.306Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:28.306Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 98,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 48539,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "19 : 15"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:28.306Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:28.307Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 2800 observations/events/player/lever 1669143930.857 2022-11-22T19:05:30.857Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:30.857Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:30.857Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 97,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 51090,
    "participant_id": "00088",
    "powered": false,
    "mission_timer": "19 : 12"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:30.857Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:30.860Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 2856 observations/events/player/lever 1669143931.905 2022-11-22T19:05:31.905Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:31.905Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:31.905Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 96,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 52138,
    "participant_id": "00088",
    "powered": false,
    "mission_timer": "19 : 11"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:31.905Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:31.908Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 3796 observations/events/player/lever 1669143950.306 2022-11-22T19:05:50.306Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:50.306Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:50.306Z"
  },
  "data": {
    "lever_x": -2164,
    "lever_z": 98,
    "lever_y": 61,
    "playername": "Player937",
    "elapsed_milliseconds": 70539,
    "participant_id": "00081",
    "powered": true,
    "mission_timer": "18 : 53"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:50.306Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:50.307Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 3896 observations/events/player/lever 1669143951.905 2022-11-22T19:05:51.905Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:05:51.905Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:05:51.905Z"
  },
  "data": {
    "lever_x": -2164,
    "lever_z": 99,
    "lever_y": 61,
    "playername": "Player937",
    "elapsed_milliseconds": 72138,
    "participant_id": "00081",
    "powered": true,
    "mission_timer": "18 : 51"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:05:51.905Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:05:51.906Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 5016 observations/events/player/lever 1669143973.055 2022-11-22T19:06:13.055Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:06:13.055Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:06:13.055Z"
  },
  "data": {
    "lever_x": -2172,
    "lever_z": 97,
    "lever_y": 61,
    "playername": "Player337",
    "elapsed_milliseconds": 93288,
    "participant_id": "00088",
    "powered": true,
    "mission_timer": "18 : 30"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:06:13.055Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:06:13.055Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 6159 observations/events/player/lever 1669143995.255 2022-11-22T19:06:35.255Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:06:35.255Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:06:35.255Z"
  },
  "data": {
    "lever_x": -2164,
    "lever_z": 99,
    "lever_y": 61,
    "playername": "Player937",
    "elapsed_milliseconds": 115488,
    "participant_id": "00081",
    "powered": false,
    "mission_timer": "18 : 8"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:06:35.255Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:06:35.256Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 6248 observations/events/player/lever 1669143996.857 2022-11-22T19:06:36.857Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:06:36.857Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:06:36.857Z"
  },
  "data": {
    "lever_x": -2164,
    "lever_z": 97,
    "lever_y": 61,
    "playername": "Player937",
    "elapsed_milliseconds": 117090,
    "participant_id": "00081",
    "powered": true,
    "mission_timer": "18 : 6"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:06:36.857Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:06:36.859Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 12210 observations/events/player/lever 1669144103.505 2022-11-22T19:08:23.505Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:08:23.505Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:08:23.505Z"
  },
  "data": {
    "lever_x": -2180,
    "lever_z": 98,
    "lever_y": 61,
    "playername": "Player347",
    "elapsed_milliseconds": 223738,
    "participant_id": "00055",
    "powered": true,
    "mission_timer": "16 : 20"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:08:23.505Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:08:23.506Z"
}
0438231f-afe3-4390-aba5-9482fb268da7 12518 observations/events/player/lever 1669144108.858 2022-11-22T19:08:28.858Z
{ "header": { "message_type": "event", "version": "1.1", "timestamp": "2022-11-22T19:08:28.858Z… 
{
  "header": {
    "message_type": "event",
    "version": "1.1",
    "timestamp": "2022-11-22T19:08:28.858Z"
  },
  "data": {
    "lever_x": -2180,
    "lever_z": 97,
    "lever_y": 61,
    "playername": "Player347",
    "elapsed_milliseconds": 229091,
    "participant_id": "00055",
    "powered": true,
    "mission_timer": "16 : 14"
  },
  "msg": {
    "experiment_id": "656709bb-f448-4ab1-89e4-3a1f9ad77b93",
    "source": "simulator",
    "trial_id": "0438231f-afe3-4390-aba5-9482fb268da7",
    "version": "0.5",
    "sub_type": "Event:Lever",
    "timestamp": "2022-11-22T19:08:28.858Z"
  },
  "@version": "1",
  "host": "4901f40f0a58",
  "@timestamp": "2022-11-22T19:08:28.860Z"
}