Column descriptions

group_session
Group session ID
frequency
Frequency of the samples (main clock frequency).
station
The iMac that the participant was stationed at.
timestamp_unix
The Unix timestamp of the event.
timestamp_iso8601
The ISO-8601 timestamp of the event.
aux_gsr
value of the gsr channel.

where group_session = "exp_2023_02_10_10"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_02_10_10 200 leopard 0 1676053234.4926336 2023-02-10T18:20:34.492634+00:00 130302.0
exp_2023_02_10_10 200 leopard 1 1676053234.4976337 2023-02-10T18:20:34.497634+00:00 130308.0
exp_2023_02_10_10 200 leopard 2 1676053234.5026336 2023-02-10T18:20:34.502634+00:00 130313.0
exp_2023_02_10_10 200 leopard 3 1676053234.5076337 2023-02-10T18:20:34.507634+00:00 130319.0
exp_2023_02_10_10 200 leopard 4 1676053234.5126336 2023-02-10T18:20:34.512634+00:00 130324.0
exp_2023_02_10_10 200 leopard 5 1676053234.5176337 2023-02-10T18:20:34.517634+00:00 130329.0
exp_2023_02_10_10 200 leopard 6 1676053234.5226336 2023-02-10T18:20:34.522634+00:00 130333.0
exp_2023_02_10_10 200 leopard 7 1676053234.5276337 2023-02-10T18:20:34.527634+00:00 130338.0
exp_2023_02_10_10 200 leopard 8 1676053234.5326335 2023-02-10T18:20:34.532634+00:00 130342.0
exp_2023_02_10_10 200 leopard 9 1676053234.5376337 2023-02-10T18:20:34.537634+00:00 130347.0
exp_2023_02_10_10 200 leopard 10 1676053234.5426335 2023-02-10T18:20:34.542634+00:00 130351.0
exp_2023_02_10_10 200 leopard 11 1676053234.5476336 2023-02-10T18:20:34.547634+00:00 130355.0
exp_2023_02_10_10 200 leopard 12 1676053234.5526335 2023-02-10T18:20:34.552634+00:00 130359.0
exp_2023_02_10_10 200 leopard 13 1676053234.5576336 2023-02-10T18:20:34.557634+00:00 130362.0
exp_2023_02_10_10 200 leopard 14 1676053234.5626335 2023-02-10T18:20:34.562634+00:00 130366.0
exp_2023_02_10_10 200 leopard 15 1676053234.5676336 2023-02-10T18:20:34.567634+00:00 130369.0
exp_2023_02_10_10 200 leopard 16 1676053234.5726335 2023-02-10T18:20:34.572634+00:00 130373.0
exp_2023_02_10_10 200 leopard 17 1676053234.5776336 2023-02-10T18:20:34.577634+00:00 130376.0
exp_2023_02_10_10 200 leopard 18 1676053234.5826335 2023-02-10T18:20:34.582633+00:00 130379.0
exp_2023_02_10_10 200 leopard 19 1676053234.5876336 2023-02-10T18:20:34.587634+00:00 130382.0
exp_2023_02_10_10 200 leopard 20 1676053234.5926335 2023-02-10T18:20:34.592633+00:00 130385.0
exp_2023_02_10_10 200 leopard 21 1676053234.5976336 2023-02-10T18:20:34.597634+00:00 130388.0
exp_2023_02_10_10 200 leopard 22 1676053234.6026335 2023-02-10T18:20:34.602633+00:00 130391.0
exp_2023_02_10_10 200 leopard 23 1676053234.6076336 2023-02-10T18:20:34.607634+00:00 130393.0
exp_2023_02_10_10 200 leopard 24 1676053234.6126335 2023-02-10T18:20:34.612633+00:00 130396.0
exp_2023_02_10_10 200 leopard 25 1676053234.6176336 2023-02-10T18:20:34.617634+00:00 130398.0
exp_2023_02_10_10 200 leopard 26 1676053234.6226337 2023-02-10T18:20:34.622634+00:00 130401.0
exp_2023_02_10_10 200 leopard 27 1676053234.6276336 2023-02-10T18:20:34.627634+00:00 130404.0
exp_2023_02_10_10 200 leopard 28 1676053234.6326337 2023-02-10T18:20:34.632634+00:00 130406.0
exp_2023_02_10_10 200 leopard 29 1676053234.6376336 2023-02-10T18:20:34.637634+00:00 130409.0
exp_2023_02_10_10 200 leopard 30 1676053234.6426337 2023-02-10T18:20:34.642634+00:00 130412.0
exp_2023_02_10_10 200 leopard 31 1676053234.6476336 2023-02-10T18:20:34.647634+00:00 130414.0
exp_2023_02_10_10 200 leopard 32 1676053234.6526337 2023-02-10T18:20:34.652634+00:00 130417.0
exp_2023_02_10_10 200 leopard 33 1676053234.6576335 2023-02-10T18:20:34.657634+00:00 130420.0
exp_2023_02_10_10 200 leopard 34 1676053234.6626337 2023-02-10T18:20:34.662634+00:00 130423.0
exp_2023_02_10_10 200 leopard 35 1676053234.6676335 2023-02-10T18:20:34.667634+00:00 130427.0
exp_2023_02_10_10 200 leopard 36 1676053234.6726336 2023-02-10T18:20:34.672634+00:00 130430.0
exp_2023_02_10_10 200 leopard 37 1676053234.6776335 2023-02-10T18:20:34.677634+00:00 130434.0
exp_2023_02_10_10 200 leopard 38 1676053234.6826336 2023-02-10T18:20:34.682634+00:00 130438.0
exp_2023_02_10_10 200 leopard 39 1676053234.6876335 2023-02-10T18:20:34.687634+00:00 130442.0
exp_2023_02_10_10 200 leopard 40 1676053234.6926336 2023-02-10T18:20:34.692634+00:00 130446.0
exp_2023_02_10_10 200 leopard 41 1676053234.6976335 2023-02-10T18:20:34.697634+00:00 130451.0
exp_2023_02_10_10 200 leopard 42 1676053234.7026336 2023-02-10T18:20:34.702634+00:00 130456.0
exp_2023_02_10_10 200 leopard 43 1676053234.7076335 2023-02-10T18:20:34.707633+00:00 130461.0
exp_2023_02_10_10 200 leopard 44 1676053234.7126336 2023-02-10T18:20:34.712634+00:00 130467.0
exp_2023_02_10_10 200 leopard 45 1676053234.7176335 2023-02-10T18:20:34.717633+00:00 130473.0
exp_2023_02_10_10 200 leopard 46 1676053234.7226336 2023-02-10T18:20:34.722634+00:00 130480.0
exp_2023_02_10_10 200 leopard 47 1676053234.7276335 2023-02-10T18:20:34.727633+00:00 130487.0
exp_2023_02_10_10 200 leopard 48 1676053234.7326336 2023-02-10T18:20:34.732634+00:00 130495.0
exp_2023_02_10_10 200 leopard 49 1676053234.7376335 2023-02-10T18:20:34.737633+00:00 130503.0
exp_2023_02_10_10 200 leopard 50 1676053234.7426336 2023-02-10T18:20:34.742634+00:00 130511.0
exp_2023_02_10_10 200 leopard 51 1676053234.7476337 2023-02-10T18:20:34.747634+00:00 130521.0
exp_2023_02_10_10 200 leopard 52 1676053234.7526336 2023-02-10T18:20:34.752634+00:00 130530.0
exp_2023_02_10_10 200 leopard 53 1676053234.7576337 2023-02-10T18:20:34.757634+00:00 130541.0
exp_2023_02_10_10 200 leopard 54 1676053234.7626336 2023-02-10T18:20:34.762634+00:00 130552.0
exp_2023_02_10_10 200 leopard 55 1676053234.7676337 2023-02-10T18:20:34.767634+00:00 130563.0
exp_2023_02_10_10 200 leopard 56 1676053234.7726336 2023-02-10T18:20:34.772634+00:00 130575.0
exp_2023_02_10_10 200 leopard 57 1676053234.7776337 2023-02-10T18:20:34.777634+00:00 130588.0
exp_2023_02_10_10 200 leopard 58 1676053234.7826335 2023-02-10T18:20:34.782634+00:00 130602.0
exp_2023_02_10_10 200 leopard 59 1676053234.7876337 2023-02-10T18:20:34.787634+00:00 130616.0
exp_2023_02_10_10 200 leopard 60 1676053234.7926335 2023-02-10T18:20:34.792634+00:00 130631.0
exp_2023_02_10_10 200 leopard 61 1676053234.7976336 2023-02-10T18:20:34.797634+00:00 130646.0
exp_2023_02_10_10 200 leopard 62 1676053234.8026335 2023-02-10T18:20:34.802634+00:00 130662.0
exp_2023_02_10_10 200 leopard 63 1676053234.8076336 2023-02-10T18:20:34.807634+00:00 130679.0
exp_2023_02_10_10 200 leopard 64 1676053234.8126335 2023-02-10T18:20:34.812634+00:00 130696.0
exp_2023_02_10_10 200 leopard 65 1676053234.8176336 2023-02-10T18:20:34.817634+00:00 130714.0
exp_2023_02_10_10 200 leopard 66 1676053234.8226335 2023-02-10T18:20:34.822634+00:00 130733.0
exp_2023_02_10_10 200 leopard 67 1676053234.8276336 2023-02-10T18:20:34.827634+00:00 130752.0
exp_2023_02_10_10 200 leopard 68 1676053234.8326335 2023-02-10T18:20:34.832633+00:00 130771.0
exp_2023_02_10_10 200 leopard 69 1676053234.8376336 2023-02-10T18:20:34.837634+00:00 130791.0
exp_2023_02_10_10 200 leopard 70 1676053234.8426335 2023-02-10T18:20:34.842633+00:00 130812.0
exp_2023_02_10_10 200 leopard 71 1676053234.8476336 2023-02-10T18:20:34.847634+00:00 130832.0
exp_2023_02_10_10 200 leopard 72 1676053234.8526335 2023-02-10T18:20:34.852633+00:00 130854.0
exp_2023_02_10_10 200 leopard 73 1676053234.8576336 2023-02-10T18:20:34.857634+00:00 130875.0
exp_2023_02_10_10 200 leopard 74 1676053234.8626335 2023-02-10T18:20:34.862633+00:00 130897.0
exp_2023_02_10_10 200 leopard 75 1676053234.8676336 2023-02-10T18:20:34.867634+00:00 130919.0
exp_2023_02_10_10 200 leopard 76 1676053234.8726337 2023-02-10T18:20:34.872634+00:00 130941.0
exp_2023_02_10_10 200 leopard 77 1676053234.8776336 2023-02-10T18:20:34.877634+00:00 130963.0
exp_2023_02_10_10 200 leopard 78 1676053234.8826337 2023-02-10T18:20:34.882634+00:00 130985.0
exp_2023_02_10_10 200 leopard 79 1676053234.8876336 2023-02-10T18:20:34.887634+00:00 131008.0
exp_2023_02_10_10 200 leopard 80 1676053234.8926337 2023-02-10T18:20:34.892634+00:00 131030.0
exp_2023_02_10_10 200 leopard 81 1676053234.8976336 2023-02-10T18:20:34.897634+00:00 131052.0
exp_2023_02_10_10 200 leopard 82 1676053234.9026337 2023-02-10T18:20:34.902634+00:00 131074.0
exp_2023_02_10_10 200 leopard 83 1676053234.9076335 2023-02-10T18:20:34.907634+00:00 131095.0
exp_2023_02_10_10 200 leopard 84 1676053234.9126337 2023-02-10T18:20:34.912634+00:00 131116.0
exp_2023_02_10_10 200 leopard 85 1676053234.9176335 2023-02-10T18:20:34.917634+00:00 131137.0
exp_2023_02_10_10 200 leopard 86 1676053234.9226336 2023-02-10T18:20:34.922634+00:00 131158.0
exp_2023_02_10_10 200 leopard 87 1676053234.9276335 2023-02-10T18:20:34.927634+00:00 131178.0
exp_2023_02_10_10 200 leopard 88 1676053234.9326336 2023-02-10T18:20:34.932634+00:00 131197.0
exp_2023_02_10_10 200 leopard 89 1676053234.9376335 2023-02-10T18:20:34.937634+00:00 131216.0
exp_2023_02_10_10 200 leopard 90 1676053234.9426336 2023-02-10T18:20:34.942634+00:00 131234.0
exp_2023_02_10_10 200 leopard 91 1676053234.9476335 2023-02-10T18:20:34.947634+00:00 131252.0
exp_2023_02_10_10 200 leopard 92 1676053234.9526336 2023-02-10T18:20:34.952634+00:00 131269.0
exp_2023_02_10_10 200 leopard 93 1676053234.9576335 2023-02-10T18:20:34.957633+00:00 131285.0
exp_2023_02_10_10 200 leopard 94 1676053234.9626336 2023-02-10T18:20:34.962634+00:00 131301.0
exp_2023_02_10_10 200 leopard 95 1676053234.9676335 2023-02-10T18:20:34.967633+00:00 131316.0
exp_2023_02_10_10 200 leopard 96 1676053234.9726336 2023-02-10T18:20:34.972634+00:00 131330.0
exp_2023_02_10_10 200 leopard 97 1676053234.9776335 2023-02-10T18:20:34.977633+00:00 131343.0
exp_2023_02_10_10 200 leopard 98 1676053234.9826336 2023-02-10T18:20:34.982634+00:00 131355.0
exp_2023_02_10_10 200 leopard 99 1676053234.9876335 2023-02-10T18:20:34.987633+00:00 131367.0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "gsr_sync" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [frequency] INTEGER,
   [station] TEXT REFERENCES [station]([id]),
   [id] INTEGER,
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [gsr] FLOAT,
   PRIMARY KEY ([group_session], [frequency], [station], [id])
);
CREATE INDEX [idx_gsr_sync_station]
    ON [gsr_sync] ([station]);
CREATE INDEX [idx_gsr_sync_group_session]
    ON [gsr_sync] ([group_session]);