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 = 5b076d3b-6d23-46d4-9414-e07fd03e828f × 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 ▲▼
5b076d3b-6d23-46d4-9414-e07fd03e828f 1120 observations/events/player/lever 1667329073.125 2022-11-01T18:57:53.125Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:53.133Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:53.133Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:53.126Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 45",
    "lever_z": 96,
    "elapsed_milliseconds": 18490,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:53.125Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1211 observations/events/player/lever 1667329074.623 2022-11-01T18:57:54.623Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:54.639Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:54.639Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:54.623Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 44",
    "lever_z": 97,
    "elapsed_milliseconds": 19987,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:54.623Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1295 observations/events/player/lever 1667329075.773 2022-11-01T18:57:55.773Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:55.774Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:55.774Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:55.773Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 42",
    "lever_z": 98,
    "elapsed_milliseconds": 21137,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:55.773Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1326 observations/events/player/lever 1667329076.024 2022-11-01T18:57:56.024Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:56.026Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:56.026Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:56.024Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2172,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 42",
    "lever_z": 98,
    "elapsed_milliseconds": 21388,
    "playername": "Player340",
    "participant_id": "99999"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:56.024Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1387 observations/events/player/lever 1667329076.974 2022-11-01T18:57:56.974Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:56.982Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:56.982Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:56.974Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2172,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 41",
    "lever_z": 97,
    "elapsed_milliseconds": 22338,
    "playername": "Player340",
    "participant_id": "99999"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:56.974Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1436 observations/events/player/lever 1667329077.823 2022-11-01T18:57:57.823Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:57.826Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:57.826Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:57.823Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 40",
    "lever_z": 99,
    "elapsed_milliseconds": 23187,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:57.823Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1491 observations/events/player/lever 1667329078.924 2022-11-01T18:57:58.924Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:57:58.926Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:57:58.926Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:57:58.924Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 39",
    "lever_z": 100,
    "elapsed_milliseconds": 24288,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:57:58.924Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 1924 observations/events/player/lever 1667329086.773 2022-11-01T18:58:06.773Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:06.774Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:06.774Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:06.773Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2164,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 31",
    "lever_z": 98,
    "elapsed_milliseconds": 32137,
    "playername": "Player128",
    "participant_id": "00067"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:06.773Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 2056 observations/events/player/lever 1667329089.223 2022-11-01T18:58:09.223Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:09.225Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:09.225Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:09.223Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2164,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "19 : 29",
    "lever_z": 97,
    "elapsed_milliseconds": 34587,
    "playername": "Player128",
    "participant_id": "00067"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:09.223Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 2291 observations/events/player/lever 1667329093.825 2022-11-01T18:58:13.825Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:13.826Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:13.826Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:13.825Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "19 : 24",
    "lever_z": 96,
    "elapsed_milliseconds": 39189,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:13.825Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 2409 observations/events/player/lever 1667329095.922 2022-11-01T18:58:15.922Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:15.923Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:15.923Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:15.922Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "19 : 22",
    "lever_z": 97,
    "elapsed_milliseconds": 41286,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:15.922Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 2521 observations/events/player/lever 1667329097.623 2022-11-01T18:58:17.623Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:17.631Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:17.631Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:17.623Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "19 : 21",
    "lever_z": 98,
    "elapsed_milliseconds": 42987,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:17.623Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 2579 observations/events/player/lever 1667329098.823 2022-11-01T18:58:18.823Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:18.824Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:18.824Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:18.823Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "19 : 19",
    "lever_z": 99,
    "elapsed_milliseconds": 44187,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:18.823Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 2638 observations/events/player/lever 1667329099.773 2022-11-01T18:58:19.773Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:19.774Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:19.774Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:19.773Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "19 : 18",
    "lever_z": 100,
    "elapsed_milliseconds": 45137,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:19.773Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 4311 observations/events/player/lever 1667329129.973 2022-11-01T18:58:49.973Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:49.976Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:49.976Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:49.973Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "18 : 48",
    "lever_z": 98,
    "elapsed_milliseconds": 75337,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:49.973Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 4394 observations/events/player/lever 1667329131.376 2022-11-01T18:58:51.376Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:58:51.397Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:58:51.397Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:58:51.376Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "18 : 47",
    "lever_z": 99,
    "elapsed_milliseconds": 76740,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:58:51.376Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 5185 observations/events/player/lever 1667329145.523 2022-11-01T18:59:05.523Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:59:05.529Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:59:05.529Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:59:05.523Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "18 : 33",
    "lever_z": 99,
    "elapsed_milliseconds": 90887,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:59:05.523Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 5198 observations/events/player/lever 1667329145.724 2022-11-01T18:59:05.724Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:59:05.724Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:59:05.724Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:59:05.724Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "18 : 32",
    "lever_z": 99,
    "elapsed_milliseconds": 91088,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:59:05.724Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 5290 observations/events/player/lever 1667329146.924 2022-11-01T18:59:06.924Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:59:06.925Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:59:06.925Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:59:06.924Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": false,
    "mission_timer": "18 : 31",
    "lever_z": 99,
    "elapsed_milliseconds": 92288,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:59:06.924Z",
    "message_type": "event"
  },
  "@version": "1"
}
5b076d3b-6d23-46d4-9414-e07fd03e828f 5351 observations/events/player/lever 1667329147.774 2022-11-01T18:59:07.774Z
{ "host": "0b90d5241726", "@timestamp": "2022-11-01T18:59:07.777Z", "msg": { "source": "simulator",… 
{
  "host": "0b90d5241726",
  "@timestamp": "2022-11-01T18:59:07.777Z",
  "msg": {
    "source": "simulator",
    "trial_id": "5b076d3b-6d23-46d4-9414-e07fd03e828f",
    "timestamp": "2022-11-01T18:59:07.774Z",
    "experiment_id": "fffba555-32cb-4a20-8c0a-9538bb9d366b",
    "sub_type": "Event:Lever",
    "version": "0.5"
  },
  "data": {
    "lever_x": -2180,
    "lever_y": 61,
    "powered": true,
    "mission_timer": "18 : 30",
    "lever_z": 97,
    "elapsed_milliseconds": 93138,
    "playername": "Player770",
    "participant_id": "00063"
  },
  "header": {
    "version": "1.1",
    "timestamp": "2022-11-01T18:59:07.774Z",
    "message_type": "event"
  },
  "@version": "1"
}