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 = cfa52783-9ddf-4a12-acdc-f911151425d8 × 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 ▲▼
cfa52783-9ddf-4a12-acdc-f911151425d8 3222 observations/events/player/lever 1683139111.2729049 2023-05-03T18:38:31.272905+00:00
{ "data": { "elapsed_milliseconds": 20445, "lever_x": -2164, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 20445,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 43",
    "participant_id": "00160",
    "playername": "Player843",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:31.272Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:31.272Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3258 observations/events/player/lever 1683139111.9687166 2023-05-03T18:38:31.968717+00:00
{ "data": { "elapsed_milliseconds": 21140, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 21140,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 42",
    "participant_id": "00160",
    "playername": "Player843",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:31.968Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:31.968Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3393 observations/events/player/lever 1683139114.421294 2023-05-03T18:38:34.421294+00:00
{ "data": { "elapsed_milliseconds": 23593, "lever_x": -2164, "lever_y": 61, "lever_z": 99, … 
{
  "data": {
    "elapsed_milliseconds": 23593,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 99,
    "mission_timer": "19 : 40",
    "participant_id": "00160",
    "playername": "Player843",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:34.421Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:34.421Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3433 observations/events/player/lever 1683139115.0193827 2023-05-03T18:38:35.019383+00:00
{ "data": { "elapsed_milliseconds": 24191, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 24191,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 39",
    "participant_id": "00160",
    "playername": "Player843",
    "powered": false
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:35.019Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:35.019Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3465 observations/events/player/lever 1683139115.5191054 2023-05-03T18:38:35.519105+00:00
{ "data": { "elapsed_milliseconds": 24691, "lever_x": -2164, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 24691,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 39",
    "participant_id": "00160",
    "playername": "Player843",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:35.519Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:35.519Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3493 observations/events/player/lever 1683139115.9685566 2023-05-03T18:38:35.968557+00:00
{ "data": { "elapsed_milliseconds": 25140, "lever_x": -2164, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 25140,
    "lever_x": -2164,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 38",
    "participant_id": "00160",
    "playername": "Player843",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:35.968Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:35.968Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3711 observations/events/player/lever 1683139119.5687473 2023-05-03T18:38:39.568747+00:00
{ "data": { "elapsed_milliseconds": 28740, "lever_x": -2172, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 28740,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 35",
    "participant_id": "00166",
    "playername": "Player915",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:39.568Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:39.568Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 3906 observations/events/player/lever 1683139122.9193528 2023-05-03T18:38:42.919353+00:00
{ "data": { "elapsed_milliseconds": 32091, "lever_x": -2172, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 32091,
    "lever_x": -2172,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 31",
    "participant_id": "00166",
    "playername": "Player915",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:42.919Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:42.919Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 4693 observations/events/player/lever 1683139137.619514 2023-05-03T18:38:57.619514+00:00
{ "data": { "elapsed_milliseconds": 46791, "lever_x": -2180, "lever_y": 61, "lever_z": 98, … 
{
  "data": {
    "elapsed_milliseconds": 46791,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 98,
    "mission_timer": "19 : 17",
    "participant_id": "99999",
    "playername": "Player436",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:57.619Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:57.619Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}
cfa52783-9ddf-4a12-acdc-f911151425d8 4778 observations/events/player/lever 1683139139.069379 2023-05-03T18:38:59.069379+00:00
{ "data": { "elapsed_milliseconds": 48241, "lever_x": -2180, "lever_y": 61, "lever_z": 97, … 
{
  "data": {
    "elapsed_milliseconds": 48241,
    "lever_x": -2180,
    "lever_y": 61,
    "lever_z": 97,
    "mission_timer": "19 : 15",
    "participant_id": "99999",
    "playername": "Player436",
    "powered": true
  },
  "header": {
    "message_type": "event",
    "timestamp": "2023-05-03T18:38:59.069Z",
    "version": "1.1"
  },
  "msg": {
    "experiment_id": "acc43931-4f24-494f-b570-e3c52d9481b5",
    "source": "simulator",
    "sub_type": "Event:Lever",
    "timestamp": "2023-05-03T18:38:59.069Z",
    "trial_id": "cfa52783-9ddf-4a12-acdc-f911151425d8",
    "version": "0.5"
  }
}