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 = f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 × 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 ▲▼
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 4478 observations/events/player/lever 1681769319.7296488 2023-04-17T22:08:39.729649+00:00
{ "data": { "elapsed_milliseconds": 29941, "lever_x": -2164, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 29941,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 34",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:08:39.730Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:08:39.730Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 4535 observations/events/player/lever 1681769320.798877 2023-04-17T22:08:40.798877+00:00
{ "data": { "elapsed_milliseconds": 30989, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 30989,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 33",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:08:40.778Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:08:40.778Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 5864 observations/events/player/lever 1681769346.076285 2023-04-17T22:09:06.076285+00:00
{ "data": { "elapsed_milliseconds": 56288, "lever_x": -2164, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 56288,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 7",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:09:06.077Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:09:06.077Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 7120 observations/events/player/lever 1681769370.128815 2023-04-17T22:09:30.128815+00:00
{ "data": { "elapsed_milliseconds": 80338, "lever_x": -2164, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 80338,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 43",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:09:30.127Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:09:30.127Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 7183 observations/events/player/lever 1681769371.1766279 2023-04-17T22:09:31.176628+00:00
{ "data": { "elapsed_milliseconds": 81388, "lever_x": -2164, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 81388,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "18 : 42",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:09:31.177Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:09:31.177Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 7190 observations/events/player/lever 1681769371.2769196 2023-04-17T22:09:31.276920+00:00
{ "data": { "elapsed_milliseconds": 81489, "lever_x": -2172, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 81489,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "18 : 42",
    "participant_id": "00140",
    "playername": "Player525",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:09:31.278Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:09:31.278Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 7203 observations/events/player/lever 1681769371.475812 2023-04-17T22:09:31.475812+00:00
{ "data": { "elapsed_milliseconds": 81688, "lever_x": -2172, "lever_y": 61, "lever_z": 96, … 
{
  "data": {
    "elapsed_milliseconds": 81688,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "18 : 42",
    "participant_id": "00140",
    "playername": "Player525",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:09:31.477Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:09:31.477Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 8654 observations/events/player/lever 1681769398.1769693 2023-04-17T22:09:58.176969+00:00
{ "data": { "elapsed_milliseconds": 108389, "lever_x": -2180, "lever_y": 61, "lever_z": 98,… 
{
  "data": {
    "elapsed_milliseconds": 108389,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "18 : 15",
    "participant_id": "00131",
    "playername": "Player99",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:09:58.178Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:09:58.178Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 8854 observations/events/player/lever 1681769401.7765062 2023-04-17T22:10:01.776506+00:00
{ "data": { "elapsed_milliseconds": 111988, "lever_x": -2164, "lever_y": 61, "lever_z": 99,… 
{
  "data": {
    "elapsed_milliseconds": 111988,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "18 : 12",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:10:01.777Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:10:01.777Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 8942 observations/events/player/lever 1681769403.0763378 2023-04-17T22:10:03.076338+00:00
{ "data": { "elapsed_milliseconds": 113288, "lever_x": -2164, "lever_y": 61, "lever_z": 97,… 
{
  "data": {
    "elapsed_milliseconds": 113288,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 10",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:10:03.077Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:10:03.077Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 9000 observations/events/player/lever 1681769404.1757023 2023-04-17T22:10:04.175702+00:00
{ "data": { "elapsed_milliseconds": 114388, "lever_x": -2180, "lever_y": 61, "lever_z": 97,… 
{
  "data": {
    "elapsed_milliseconds": 114388,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 9",
    "participant_id": "00131",
    "playername": "Player99",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:10:04.177Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:10:04.177Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 9169 observations/events/player/lever 1681769407.47675 2023-04-17T22:10:07.476750+00:00
{ "data": { "elapsed_milliseconds": 117689, "lever_x": -2172, "lever_y": 61, "lever_z": 98,… 
{
  "data": {
    "elapsed_milliseconds": 117689,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "18 : 6",
    "participant_id": "00140",
    "playername": "Player525",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:10:07.478Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:10:07.478Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 9252 observations/events/player/lever 1681769409.0823011 2023-04-17T22:10:09.082301+00:00
{ "data": { "elapsed_milliseconds": 119288, "lever_x": -2172, "lever_y": 61, "lever_z": 97,… 
{
  "data": {
    "elapsed_milliseconds": 119288,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "18 : 4",
    "participant_id": "00140",
    "playername": "Player525",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:10:09.077Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:10:09.077Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}
f4f65fe1-e105-4e67-8682-f9b3dc4eedb1 9291 observations/events/player/lever 1681769409.8266847 2023-04-17T22:10:09.826685+00:00
{ "data": { "elapsed_milliseconds": 120039, "lever_x": -2164, "lever_y": 61, "lever_z": 96,… 
{
  "data": {
    "elapsed_milliseconds": 120039,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 96,
    "mission_timer": "18 : 3",
    "participant_id": "00133",
    "playername": "Player975",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-04-17T22:10:09.828Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "04037bd1-7cd8-4666-98b1-f5cc0e1369c9",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-04-17T22:10:09.828Z",
    "trial_id": "f4f65fe1-e105-4e67-8682-f9b3dc4eedb1",
    "version": "0.5"
  }
}