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_2022_10_31_10"

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_10_31_10 200 leopard 0 1667240568.5271714 2022-10-31T18:22:48.527171+00:00 131652.0
exp_2022_10_31_10 200 leopard 1 1667240568.5321715 2022-10-31T18:22:48.532171+00:00 131649.0
exp_2022_10_31_10 200 leopard 2 1667240568.5371714 2022-10-31T18:22:48.537171+00:00 131646.0
exp_2022_10_31_10 200 leopard 3 1667240568.5421715 2022-10-31T18:22:48.542171+00:00 131643.0
exp_2022_10_31_10 200 leopard 4 1667240568.5471714 2022-10-31T18:22:48.547171+00:00 131640.0
exp_2022_10_31_10 200 leopard 5 1667240568.5521715 2022-10-31T18:22:48.552171+00:00 131638.0
exp_2022_10_31_10 200 leopard 6 1667240568.5571713 2022-10-31T18:22:48.557171+00:00 131635.0
exp_2022_10_31_10 200 leopard 7 1667240568.5621715 2022-10-31T18:22:48.562171+00:00 131632.0
exp_2022_10_31_10 200 leopard 8 1667240568.5671713 2022-10-31T18:22:48.567171+00:00 131629.0
exp_2022_10_31_10 200 leopard 9 1667240568.5721714 2022-10-31T18:22:48.572171+00:00 131626.0
exp_2022_10_31_10 200 leopard 10 1667240568.5771713 2022-10-31T18:22:48.577171+00:00 131623.0
exp_2022_10_31_10 200 leopard 11 1667240568.5821714 2022-10-31T18:22:48.582171+00:00 131620.0
exp_2022_10_31_10 200 leopard 12 1667240568.5871713 2022-10-31T18:22:48.587171+00:00 131618.0
exp_2022_10_31_10 200 leopard 13 1667240568.5921714 2022-10-31T18:22:48.592171+00:00 131615.0
exp_2022_10_31_10 200 leopard 14 1667240568.5971713 2022-10-31T18:22:48.597171+00:00 131612.0
exp_2022_10_31_10 200 leopard 15 1667240568.6021714 2022-10-31T18:22:48.602171+00:00 131609.0
exp_2022_10_31_10 200 leopard 16 1667240568.6071713 2022-10-31T18:22:48.607171+00:00 131606.0
exp_2022_10_31_10 200 leopard 17 1667240568.6121714 2022-10-31T18:22:48.612171+00:00 131604.0
exp_2022_10_31_10 200 leopard 18 1667240568.6171713 2022-10-31T18:22:48.617171+00:00 131601.0
exp_2022_10_31_10 200 leopard 19 1667240568.6221714 2022-10-31T18:22:48.622171+00:00 131598.0
exp_2022_10_31_10 200 leopard 20 1667240568.6271713 2022-10-31T18:22:48.627171+00:00 131595.0
exp_2022_10_31_10 200 leopard 21 1667240568.6321714 2022-10-31T18:22:48.632171+00:00 131592.0
exp_2022_10_31_10 200 leopard 22 1667240568.6371713 2022-10-31T18:22:48.637171+00:00 131590.0
exp_2022_10_31_10 200 leopard 23 1667240568.6421714 2022-10-31T18:22:48.642171+00:00 131587.0
exp_2022_10_31_10 200 leopard 24 1667240568.6471713 2022-10-31T18:22:48.647171+00:00 131584.0
exp_2022_10_31_10 200 leopard 25 1667240568.6521714 2022-10-31T18:22:48.652171+00:00 131581.0
exp_2022_10_31_10 200 leopard 26 1667240568.6571715 2022-10-31T18:22:48.657171+00:00 131578.0
exp_2022_10_31_10 200 leopard 27 1667240568.6621714 2022-10-31T18:22:48.662171+00:00 131576.0
exp_2022_10_31_10 200 leopard 28 1667240568.6671715 2022-10-31T18:22:48.667171+00:00 131573.0
exp_2022_10_31_10 200 leopard 29 1667240568.6721714 2022-10-31T18:22:48.672171+00:00 131570.0
exp_2022_10_31_10 200 leopard 30 1667240568.6771715 2022-10-31T18:22:48.677171+00:00 131568.0
exp_2022_10_31_10 200 leopard 31 1667240568.6821713 2022-10-31T18:22:48.682171+00:00 131565.0
exp_2022_10_31_10 200 leopard 32 1667240568.6871715 2022-10-31T18:22:48.687171+00:00 131562.0
exp_2022_10_31_10 200 leopard 33 1667240568.6921713 2022-10-31T18:22:48.692171+00:00 131560.0
exp_2022_10_31_10 200 leopard 34 1667240568.6971714 2022-10-31T18:22:48.697171+00:00 131557.0
exp_2022_10_31_10 200 leopard 35 1667240568.7021713 2022-10-31T18:22:48.702171+00:00 131554.0
exp_2022_10_31_10 200 leopard 36 1667240568.7071714 2022-10-31T18:22:48.707171+00:00 131552.0
exp_2022_10_31_10 200 leopard 37 1667240568.7121713 2022-10-31T18:22:48.712171+00:00 131549.0
exp_2022_10_31_10 200 leopard 38 1667240568.7171714 2022-10-31T18:22:48.717171+00:00 131546.0
exp_2022_10_31_10 200 leopard 39 1667240568.7221713 2022-10-31T18:22:48.722171+00:00 131544.0
exp_2022_10_31_10 200 leopard 40 1667240568.7271714 2022-10-31T18:22:48.727171+00:00 131541.0
exp_2022_10_31_10 200 leopard 41 1667240568.7321713 2022-10-31T18:22:48.732171+00:00 131539.0
exp_2022_10_31_10 200 leopard 42 1667240568.7371714 2022-10-31T18:22:48.737171+00:00 131536.0
exp_2022_10_31_10 200 leopard 43 1667240568.7421713 2022-10-31T18:22:48.742171+00:00 131533.0
exp_2022_10_31_10 200 leopard 44 1667240568.7471714 2022-10-31T18:22:48.747171+00:00 131531.0
exp_2022_10_31_10 200 leopard 45 1667240568.7521713 2022-10-31T18:22:48.752171+00:00 131528.0
exp_2022_10_31_10 200 leopard 46 1667240568.7571714 2022-10-31T18:22:48.757171+00:00 131526.0
exp_2022_10_31_10 200 leopard 47 1667240568.7621713 2022-10-31T18:22:48.762171+00:00 131523.0
exp_2022_10_31_10 200 leopard 48 1667240568.7671714 2022-10-31T18:22:48.767171+00:00 131521.0
exp_2022_10_31_10 200 leopard 49 1667240568.7721713 2022-10-31T18:22:48.772171+00:00 131518.0
exp_2022_10_31_10 200 leopard 50 1667240568.7771714 2022-10-31T18:22:48.777171+00:00 131516.0
exp_2022_10_31_10 200 leopard 51 1667240568.7821715 2022-10-31T18:22:48.782171+00:00 131513.0
exp_2022_10_31_10 200 leopard 52 1667240568.7871714 2022-10-31T18:22:48.787171+00:00 131511.0
exp_2022_10_31_10 200 leopard 53 1667240568.7921715 2022-10-31T18:22:48.792171+00:00 131509.0
exp_2022_10_31_10 200 leopard 54 1667240568.7971714 2022-10-31T18:22:48.797171+00:00 131506.0
exp_2022_10_31_10 200 leopard 55 1667240568.8021715 2022-10-31T18:22:48.802171+00:00 131504.0
exp_2022_10_31_10 200 leopard 56 1667240568.8071713 2022-10-31T18:22:48.807171+00:00 131501.0
exp_2022_10_31_10 200 leopard 57 1667240568.8121715 2022-10-31T18:22:48.812171+00:00 131499.0
exp_2022_10_31_10 200 leopard 58 1667240568.8171713 2022-10-31T18:22:48.817171+00:00 131496.0
exp_2022_10_31_10 200 leopard 59 1667240568.8221714 2022-10-31T18:22:48.822171+00:00 131494.0
exp_2022_10_31_10 200 leopard 60 1667240568.8271713 2022-10-31T18:22:48.827171+00:00 131492.0
exp_2022_10_31_10 200 leopard 61 1667240568.8321714 2022-10-31T18:22:48.832171+00:00 131489.0
exp_2022_10_31_10 200 leopard 62 1667240568.8371713 2022-10-31T18:22:48.837171+00:00 131487.0
exp_2022_10_31_10 200 leopard 63 1667240568.8421714 2022-10-31T18:22:48.842171+00:00 131484.0
exp_2022_10_31_10 200 leopard 64 1667240568.8471713 2022-10-31T18:22:48.847171+00:00 131482.0
exp_2022_10_31_10 200 leopard 65 1667240568.8521714 2022-10-31T18:22:48.852171+00:00 131480.0
exp_2022_10_31_10 200 leopard 66 1667240568.8571713 2022-10-31T18:22:48.857171+00:00 131477.0
exp_2022_10_31_10 200 leopard 67 1667240568.8621714 2022-10-31T18:22:48.862171+00:00 131475.0
exp_2022_10_31_10 200 leopard 68 1667240568.8671713 2022-10-31T18:22:48.867171+00:00 131473.0
exp_2022_10_31_10 200 leopard 69 1667240568.8721714 2022-10-31T18:22:48.872171+00:00 131470.0
exp_2022_10_31_10 200 leopard 70 1667240568.8771713 2022-10-31T18:22:48.877171+00:00 131468.0
exp_2022_10_31_10 200 leopard 71 1667240568.8821714 2022-10-31T18:22:48.882171+00:00 131465.0
exp_2022_10_31_10 200 leopard 72 1667240568.8871713 2022-10-31T18:22:48.887171+00:00 131463.0
exp_2022_10_31_10 200 leopard 73 1667240568.8921714 2022-10-31T18:22:48.892171+00:00 131461.0
exp_2022_10_31_10 200 leopard 74 1667240568.8971713 2022-10-31T18:22:48.897171+00:00 131458.0
exp_2022_10_31_10 200 leopard 75 1667240568.9021714 2022-10-31T18:22:48.902171+00:00 131456.0
exp_2022_10_31_10 200 leopard 76 1667240568.9071715 2022-10-31T18:22:48.907171+00:00 131454.0
exp_2022_10_31_10 200 leopard 77 1667240568.9121714 2022-10-31T18:22:48.912171+00:00 131451.0
exp_2022_10_31_10 200 leopard 78 1667240568.9171715 2022-10-31T18:22:48.917171+00:00 131449.0
exp_2022_10_31_10 200 leopard 79 1667240568.9221714 2022-10-31T18:22:48.922171+00:00 131446.0
exp_2022_10_31_10 200 leopard 80 1667240568.9271715 2022-10-31T18:22:48.927171+00:00 131444.0
exp_2022_10_31_10 200 leopard 81 1667240568.9321713 2022-10-31T18:22:48.932171+00:00 131441.0
exp_2022_10_31_10 200 leopard 82 1667240568.9371715 2022-10-31T18:22:48.937171+00:00 131439.0
exp_2022_10_31_10 200 leopard 83 1667240568.9421713 2022-10-31T18:22:48.942171+00:00 131436.0
exp_2022_10_31_10 200 leopard 84 1667240568.9471714 2022-10-31T18:22:48.947171+00:00 131434.0
exp_2022_10_31_10 200 leopard 85 1667240568.9521713 2022-10-31T18:22:48.952171+00:00 131432.0
exp_2022_10_31_10 200 leopard 86 1667240568.9571714 2022-10-31T18:22:48.957171+00:00 131429.0
exp_2022_10_31_10 200 leopard 87 1667240568.9621713 2022-10-31T18:22:48.962171+00:00 131427.0
exp_2022_10_31_10 200 leopard 88 1667240568.9671714 2022-10-31T18:22:48.967171+00:00 131424.0
exp_2022_10_31_10 200 leopard 89 1667240568.9721713 2022-10-31T18:22:48.972171+00:00 131422.0
exp_2022_10_31_10 200 leopard 90 1667240568.9771714 2022-10-31T18:22:48.977171+00:00 131419.0
exp_2022_10_31_10 200 leopard 91 1667240568.9821713 2022-10-31T18:22:48.982171+00:00 131416.0
exp_2022_10_31_10 200 leopard 92 1667240568.9871714 2022-10-31T18:22:48.987171+00:00 131414.0
exp_2022_10_31_10 200 leopard 93 1667240568.9921713 2022-10-31T18:22:48.992171+00:00 131411.0
exp_2022_10_31_10 200 leopard 94 1667240568.9971714 2022-10-31T18:22:48.997171+00:00 131409.0
exp_2022_10_31_10 200 leopard 95 1667240569.0021713 2022-10-31T18:22:49.002171+00:00 131406.0
exp_2022_10_31_10 200 leopard 96 1667240569.0071714 2022-10-31T18:22:49.007171+00:00 131404.0
exp_2022_10_31_10 200 leopard 97 1667240569.0121713 2022-10-31T18:22:49.012171+00:00 131401.0
exp_2022_10_31_10 200 leopard 98 1667240569.0171714 2022-10-31T18:22:49.017171+00:00 131399.0
exp_2022_10_31_10 200 leopard 99 1667240569.0221713 2022-10-31T18:22:49.022171+00:00 131396.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]);