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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_02_16_14 200 leopard 0 1676585563.5125296 2023-02-16T22:12:43.512530+00:00 169840.0
exp_2023_02_16_14 200 leopard 1 1676585563.5175297 2023-02-16T22:12:43.517530+00:00 169839.0
exp_2023_02_16_14 200 leopard 2 1676585563.5225296 2023-02-16T22:12:43.522530+00:00 169838.0
exp_2023_02_16_14 200 leopard 3 1676585563.5275297 2023-02-16T22:12:43.527530+00:00 169837.0
exp_2023_02_16_14 200 leopard 4 1676585563.5325296 2023-02-16T22:12:43.532530+00:00 169836.0
exp_2023_02_16_14 200 leopard 5 1676585563.5375297 2023-02-16T22:12:43.537530+00:00 169835.0
exp_2023_02_16_14 200 leopard 6 1676585563.5425296 2023-02-16T22:12:43.542530+00:00 169834.0
exp_2023_02_16_14 200 leopard 7 1676585563.5475297 2023-02-16T22:12:43.547530+00:00 169833.0
exp_2023_02_16_14 200 leopard 8 1676585563.5525296 2023-02-16T22:12:43.552530+00:00 169832.0
exp_2023_02_16_14 200 leopard 9 1676585563.5575297 2023-02-16T22:12:43.557530+00:00 169832.0
exp_2023_02_16_14 200 leopard 10 1676585563.5625296 2023-02-16T22:12:43.562530+00:00 169831.0
exp_2023_02_16_14 200 leopard 11 1676585563.5675297 2023-02-16T22:12:43.567530+00:00 169830.0
exp_2023_02_16_14 200 leopard 12 1676585563.5725296 2023-02-16T22:12:43.572530+00:00 169830.0
exp_2023_02_16_14 200 leopard 13 1676585563.5775297 2023-02-16T22:12:43.577530+00:00 169829.0
exp_2023_02_16_14 200 leopard 14 1676585563.5825295 2023-02-16T22:12:43.582530+00:00 169828.0
exp_2023_02_16_14 200 leopard 15 1676585563.5875297 2023-02-16T22:12:43.587530+00:00 169828.0
exp_2023_02_16_14 200 leopard 16 1676585563.5925295 2023-02-16T22:12:43.592530+00:00 169827.0
exp_2023_02_16_14 200 leopard 17 1676585563.5975296 2023-02-16T22:12:43.597530+00:00 169827.0
exp_2023_02_16_14 200 leopard 18 1676585563.6025295 2023-02-16T22:12:43.602530+00:00 169826.0
exp_2023_02_16_14 200 leopard 19 1676585563.6075296 2023-02-16T22:12:43.607530+00:00 169826.0
exp_2023_02_16_14 200 leopard 20 1676585563.6125295 2023-02-16T22:12:43.612530+00:00 169825.0
exp_2023_02_16_14 200 leopard 21 1676585563.6175296 2023-02-16T22:12:43.617530+00:00 169825.0
exp_2023_02_16_14 200 leopard 22 1676585563.6225295 2023-02-16T22:12:43.622530+00:00 169824.0
exp_2023_02_16_14 200 leopard 23 1676585563.6275296 2023-02-16T22:12:43.627530+00:00 169824.0
exp_2023_02_16_14 200 leopard 24 1676585563.6325295 2023-02-16T22:12:43.632529+00:00 169824.0
exp_2023_02_16_14 200 leopard 25 1676585563.6375296 2023-02-16T22:12:43.637530+00:00 169824.0
exp_2023_02_16_14 200 leopard 26 1676585563.6425297 2023-02-16T22:12:43.642530+00:00 169823.0
exp_2023_02_16_14 200 leopard 27 1676585563.6475296 2023-02-16T22:12:43.647530+00:00 169823.0
exp_2023_02_16_14 200 leopard 28 1676585563.6525297 2023-02-16T22:12:43.652530+00:00 169823.0
exp_2023_02_16_14 200 leopard 29 1676585563.6575296 2023-02-16T22:12:43.657530+00:00 169823.0
exp_2023_02_16_14 200 leopard 30 1676585563.6625297 2023-02-16T22:12:43.662530+00:00 169823.0
exp_2023_02_16_14 200 leopard 31 1676585563.6675296 2023-02-16T22:12:43.667530+00:00 169822.0
exp_2023_02_16_14 200 leopard 32 1676585563.6725297 2023-02-16T22:12:43.672530+00:00 169822.0
exp_2023_02_16_14 200 leopard 33 1676585563.6775296 2023-02-16T22:12:43.677530+00:00 169822.0
exp_2023_02_16_14 200 leopard 34 1676585563.6825297 2023-02-16T22:12:43.682530+00:00 169822.0
exp_2023_02_16_14 200 leopard 35 1676585563.6875296 2023-02-16T22:12:43.687530+00:00 169822.0
exp_2023_02_16_14 200 leopard 36 1676585563.6925297 2023-02-16T22:12:43.692530+00:00 169822.0
exp_2023_02_16_14 200 leopard 37 1676585563.6975296 2023-02-16T22:12:43.697530+00:00 169822.0
exp_2023_02_16_14 200 leopard 38 1676585563.7025297 2023-02-16T22:12:43.702530+00:00 169822.0
exp_2023_02_16_14 200 leopard 39 1676585563.7075295 2023-02-16T22:12:43.707530+00:00 169821.0
exp_2023_02_16_14 200 leopard 40 1676585563.7125297 2023-02-16T22:12:43.712530+00:00 169821.0
exp_2023_02_16_14 200 leopard 41 1676585563.7175295 2023-02-16T22:12:43.717530+00:00 169821.0
exp_2023_02_16_14 200 leopard 42 1676585563.7225296 2023-02-16T22:12:43.722530+00:00 169821.0
exp_2023_02_16_14 200 leopard 43 1676585563.7275295 2023-02-16T22:12:43.727530+00:00 169821.0
exp_2023_02_16_14 200 leopard 44 1676585563.7325296 2023-02-16T22:12:43.732530+00:00 169820.0
exp_2023_02_16_14 200 leopard 45 1676585563.7375295 2023-02-16T22:12:43.737530+00:00 169820.0
exp_2023_02_16_14 200 leopard 46 1676585563.7425296 2023-02-16T22:12:43.742530+00:00 169820.0
exp_2023_02_16_14 200 leopard 47 1676585563.7475295 2023-02-16T22:12:43.747530+00:00 169820.0
exp_2023_02_16_14 200 leopard 48 1676585563.7525296 2023-02-16T22:12:43.752530+00:00 169819.0
exp_2023_02_16_14 200 leopard 49 1676585563.7575295 2023-02-16T22:12:43.757529+00:00 169819.0
exp_2023_02_16_14 200 leopard 50 1676585563.7625296 2023-02-16T22:12:43.762530+00:00 169819.0
exp_2023_02_16_14 200 leopard 51 1676585563.7675297 2023-02-16T22:12:43.767530+00:00 169818.0
exp_2023_02_16_14 200 leopard 52 1676585563.7725296 2023-02-16T22:12:43.772530+00:00 169818.0
exp_2023_02_16_14 200 leopard 53 1676585563.7775297 2023-02-16T22:12:43.777530+00:00 169817.0
exp_2023_02_16_14 200 leopard 54 1676585563.7825296 2023-02-16T22:12:43.782530+00:00 169817.0
exp_2023_02_16_14 200 leopard 55 1676585563.7875297 2023-02-16T22:12:43.787530+00:00 169816.0
exp_2023_02_16_14 200 leopard 56 1676585563.7925296 2023-02-16T22:12:43.792530+00:00 169816.0
exp_2023_02_16_14 200 leopard 57 1676585563.7975297 2023-02-16T22:12:43.797530+00:00 169815.0
exp_2023_02_16_14 200 leopard 58 1676585563.8025296 2023-02-16T22:12:43.802530+00:00 169814.0
exp_2023_02_16_14 200 leopard 59 1676585563.8075297 2023-02-16T22:12:43.807530+00:00 169814.0
exp_2023_02_16_14 200 leopard 60 1676585563.8125296 2023-02-16T22:12:43.812530+00:00 169813.0
exp_2023_02_16_14 200 leopard 61 1676585563.8175297 2023-02-16T22:12:43.817530+00:00 169812.0
exp_2023_02_16_14 200 leopard 62 1676585563.8225296 2023-02-16T22:12:43.822530+00:00 169812.0
exp_2023_02_16_14 200 leopard 63 1676585563.8275297 2023-02-16T22:12:43.827530+00:00 169811.0
exp_2023_02_16_14 200 leopard 64 1676585563.8325295 2023-02-16T22:12:43.832530+00:00 169810.0
exp_2023_02_16_14 200 leopard 65 1676585563.8375297 2023-02-16T22:12:43.837530+00:00 169810.0
exp_2023_02_16_14 200 leopard 66 1676585563.8425295 2023-02-16T22:12:43.842530+00:00 169809.0
exp_2023_02_16_14 200 leopard 67 1676585563.8475296 2023-02-16T22:12:43.847530+00:00 169808.0
exp_2023_02_16_14 200 leopard 68 1676585563.8525295 2023-02-16T22:12:43.852530+00:00 169807.0
exp_2023_02_16_14 200 leopard 69 1676585563.8575296 2023-02-16T22:12:43.857530+00:00 169806.0
exp_2023_02_16_14 200 leopard 70 1676585563.8625295 2023-02-16T22:12:43.862530+00:00 169806.0
exp_2023_02_16_14 200 leopard 71 1676585563.8675296 2023-02-16T22:12:43.867530+00:00 169805.0
exp_2023_02_16_14 200 leopard 72 1676585563.8725295 2023-02-16T22:12:43.872530+00:00 169804.0
exp_2023_02_16_14 200 leopard 73 1676585563.8775296 2023-02-16T22:12:43.877530+00:00 169803.0
exp_2023_02_16_14 200 leopard 74 1676585563.8825295 2023-02-16T22:12:43.882529+00:00 169802.0
exp_2023_02_16_14 200 leopard 75 1676585563.8875296 2023-02-16T22:12:43.887530+00:00 169801.0
exp_2023_02_16_14 200 leopard 76 1676585563.8925297 2023-02-16T22:12:43.892530+00:00 169801.0
exp_2023_02_16_14 200 leopard 77 1676585563.8975296 2023-02-16T22:12:43.897530+00:00 169800.0
exp_2023_02_16_14 200 leopard 78 1676585563.9025297 2023-02-16T22:12:43.902530+00:00 169799.0
exp_2023_02_16_14 200 leopard 79 1676585563.9075296 2023-02-16T22:12:43.907530+00:00 169798.0
exp_2023_02_16_14 200 leopard 80 1676585563.9125297 2023-02-16T22:12:43.912530+00:00 169797.0
exp_2023_02_16_14 200 leopard 81 1676585563.9175296 2023-02-16T22:12:43.917530+00:00 169797.0
exp_2023_02_16_14 200 leopard 82 1676585563.9225297 2023-02-16T22:12:43.922530+00:00 169796.0
exp_2023_02_16_14 200 leopard 83 1676585563.9275296 2023-02-16T22:12:43.927530+00:00 169795.0
exp_2023_02_16_14 200 leopard 84 1676585563.9325297 2023-02-16T22:12:43.932530+00:00 169794.0
exp_2023_02_16_14 200 leopard 85 1676585563.9375296 2023-02-16T22:12:43.937530+00:00 169794.0
exp_2023_02_16_14 200 leopard 86 1676585563.9425297 2023-02-16T22:12:43.942530+00:00 169793.0
exp_2023_02_16_14 200 leopard 87 1676585563.9475296 2023-02-16T22:12:43.947530+00:00 169792.0
exp_2023_02_16_14 200 leopard 88 1676585563.9525297 2023-02-16T22:12:43.952530+00:00 169792.0
exp_2023_02_16_14 200 leopard 89 1676585563.9575295 2023-02-16T22:12:43.957530+00:00 169791.0
exp_2023_02_16_14 200 leopard 90 1676585563.9625297 2023-02-16T22:12:43.962530+00:00 169790.0
exp_2023_02_16_14 200 leopard 91 1676585563.9675295 2023-02-16T22:12:43.967530+00:00 169790.0
exp_2023_02_16_14 200 leopard 92 1676585563.9725296 2023-02-16T22:12:43.972530+00:00 169789.0
exp_2023_02_16_14 200 leopard 93 1676585563.9775295 2023-02-16T22:12:43.977530+00:00 169788.0
exp_2023_02_16_14 200 leopard 94 1676585563.9825296 2023-02-16T22:12:43.982530+00:00 169788.0
exp_2023_02_16_14 200 leopard 95 1676585563.9875295 2023-02-16T22:12:43.987530+00:00 169787.0
exp_2023_02_16_14 200 leopard 96 1676585563.9925296 2023-02-16T22:12:43.992530+00:00 169786.0
exp_2023_02_16_14 200 leopard 97 1676585563.9975295 2023-02-16T22:12:43.997530+00:00 169786.0
exp_2023_02_16_14 200 leopard 98 1676585564.0025296 2023-02-16T22:12:44.002530+00:00 169785.0
exp_2023_02_16_14 200 leopard 99 1676585564.0075295 2023-02-16T22:12:44.007529+00:00 169784.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]);