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 = 8ee522d9-1c97-4f9a-b1ff-519475ca8874 × 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 ▲▼
8ee522d9-1c97-4f9a-b1ff-519475ca8874 1840 observations/events/player/lever 1666644421.535 2022-10-24T20:47:01.535Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:47:01.536Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:47:01.535Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "19 : 29",
    "lever_x": -2164,
    "elapsed_milliseconds": 34943,
    "participant_id": "00027",
    "lever_z": 98,
    "playername": "Player307",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:47:01.537Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 1867 observations/events/player/lever 1666644422.031 2022-10-24T20:47:02.031Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:47:02.031Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:47:02.031Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "19 : 28",
    "lever_x": -2180,
    "elapsed_milliseconds": 35438,
    "participant_id": "00023",
    "lever_z": 99,
    "playername": "Player268",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:47:02.037Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 1936 observations/events/player/lever 1666644423.229 2022-10-24T20:47:03.229Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:47:03.229Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:47:03.229Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "19 : 27",
    "lever_x": -2164,
    "elapsed_milliseconds": 36636,
    "participant_id": "00027",
    "lever_z": 97,
    "playername": "Player307",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:47:03.244Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 1978 observations/events/player/lever 1666644424.033 2022-10-24T20:47:04.033Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:47:04.033Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:47:04.033Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "19 : 26",
    "lever_x": -2180,
    "elapsed_milliseconds": 37440,
    "participant_id": "00023",
    "lever_z": 97,
    "playername": "Player268",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:47:04.033Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 3970 observations/events/player/lever 1666644462.829 2022-10-24T20:47:42.829Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:47:42.829Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:47:42.829Z"
  },
  "data": {
    "powered": false,
    "mission_timer": "18 : 47",
    "lever_x": -2180,
    "elapsed_milliseconds": 76236,
    "participant_id": "00023",
    "lever_z": 99,
    "playername": "Player268",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:47:42.832Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 4042 observations/events/player/lever 1666644464.179 2022-10-24T20:47:44.179Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:47:44.179Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:47:44.179Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 46",
    "lever_x": -2180,
    "elapsed_milliseconds": 77586,
    "participant_id": "00023",
    "lever_z": 98,
    "playername": "Player268",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:47:44.195Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5373 observations/events/player/lever 1666644488.33 2022-10-24T20:48:08.330Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:08.330Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:08.330Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 22",
    "lever_x": -2172,
    "elapsed_milliseconds": 101737,
    "participant_id": "00051",
    "lever_z": 96,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:08.330Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5395 observations/events/player/lever 1666644488.629 2022-10-24T20:48:08.629Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:08.629Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:08.629Z"
  },
  "data": {
    "powered": false,
    "mission_timer": "18 : 21",
    "lever_x": -2172,
    "elapsed_milliseconds": 102036,
    "participant_id": "00051",
    "lever_z": 96,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:08.630Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5446 observations/events/player/lever 1666644489.43 2022-10-24T20:48:09.430Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:09.430Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:09.430Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 21",
    "lever_x": -2172,
    "elapsed_milliseconds": 102837,
    "participant_id": "00051",
    "lever_z": 96,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:09.432Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5501 observations/events/player/lever 1666644490.329 2022-10-24T20:48:10.329Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:10.329Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:10.329Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 20",
    "lever_x": -2172,
    "elapsed_milliseconds": 103736,
    "participant_id": "00051",
    "lever_z": 97,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:10.336Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5547 observations/events/player/lever 1666644491.081 2022-10-24T20:48:11.081Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:11.081Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:11.081Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 19",
    "lever_x": -2172,
    "elapsed_milliseconds": 104488,
    "participant_id": "00051",
    "lever_z": 98,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:11.098Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5589 observations/events/player/lever 1666644491.829 2022-10-24T20:48:11.829Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:11.829Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:11.829Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 18",
    "lever_x": -2172,
    "elapsed_milliseconds": 105236,
    "participant_id": "00051",
    "lever_z": 99,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:11.831Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 5760 observations/events/player/lever 1666644494.681 2022-10-24T20:48:14.681Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:14.681Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:14.681Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "18 : 15",
    "lever_x": -2172,
    "elapsed_milliseconds": 108088,
    "participant_id": "00051",
    "lever_z": 100,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:14.700Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 7881 observations/events/player/lever 1666644530.58 2022-10-24T20:48:50.580Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:50.580Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:50.580Z"
  },
  "data": {
    "powered": false,
    "mission_timer": "17 : 40",
    "lever_x": -2172,
    "elapsed_milliseconds": 143987,
    "participant_id": "00051",
    "lever_z": 96,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:50.581Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 8021 observations/events/player/lever 1666644533.13 2022-10-24T20:48:53.130Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:53.130Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:53.130Z"
  },
  "data": {
    "powered": true,
    "mission_timer": "17 : 37",
    "lever_x": -2172,
    "elapsed_milliseconds": 146537,
    "participant_id": "00051",
    "lever_z": 96,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:53.153Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 8367 observations/events/player/lever 1666644538.632 2022-10-24T20:48:58.632Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:58.632Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:58.632Z"
  },
  "data": {
    "powered": false,
    "mission_timer": "17 : 31",
    "lever_x": -2172,
    "elapsed_milliseconds": 152039,
    "participant_id": "00051",
    "lever_z": 100,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:58.632Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 8426 observations/events/player/lever 1666644539.679 2022-10-24T20:48:59.679Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:48:59.679Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:48:59.679Z"
  },
  "data": {
    "powered": false,
    "mission_timer": "17 : 30",
    "lever_x": -2172,
    "elapsed_milliseconds": 153086,
    "participant_id": "00051",
    "lever_z": 99,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:48:59.688Z"
}
8ee522d9-1c97-4f9a-b1ff-519475ca8874 8648 observations/events/player/lever 1666644543.28 2022-10-24T20:49:03.280Z
{ "host": "f4f1afe48f49", "msg": { "experiment_id": "14845def-e084-4448-9358-bc0590e832d9", "sub_… 
{
  "host": "f4f1afe48f49",
  "msg": {
    "experiment_id": "14845def-e084-4448-9358-bc0590e832d9",
    "sub_type": "Event:Lever",
    "trial_id": "8ee522d9-1c97-4f9a-b1ff-519475ca8874",
    "source": "simulator",
    "timestamp": "2022-10-24T20:49:03.280Z",
    "version": "0.5"
  },
  "header": {
    "version": "1.1",
    "message_type": "event",
    "timestamp": "2022-10-24T20:49:03.280Z"
  },
  "data": {
    "powered": false,
    "mission_timer": "17 : 27",
    "lever_x": -2172,
    "elapsed_milliseconds": 156687,
    "participant_id": "00051",
    "lever_z": 96,
    "playername": "Player20",
    "lever_y": 61
  },
  "@version": "1",
  "@timestamp": "2022-10-24T20:49:03.282Z"
}