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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_01_30_13 200 leopard 0 1675113644.1347373 2023-01-30T21:20:44.134737+00:00 340325.0
exp_2023_01_30_13 200 leopard 1 1675113644.1397374 2023-01-30T21:20:44.139737+00:00 340316.0
exp_2023_01_30_13 200 leopard 2 1675113644.1447372 2023-01-30T21:20:44.144737+00:00 340306.0
exp_2023_01_30_13 200 leopard 3 1675113644.1497374 2023-01-30T21:20:44.149737+00:00 340297.0
exp_2023_01_30_13 200 leopard 4 1675113644.1547372 2023-01-30T21:20:44.154737+00:00 340288.0
exp_2023_01_30_13 200 leopard 5 1675113644.1597373 2023-01-30T21:20:44.159737+00:00 340279.0
exp_2023_01_30_13 200 leopard 6 1675113644.1647372 2023-01-30T21:20:44.164737+00:00 340270.0
exp_2023_01_30_13 200 leopard 7 1675113644.1697373 2023-01-30T21:20:44.169737+00:00 340261.0
exp_2023_01_30_13 200 leopard 8 1675113644.1747372 2023-01-30T21:20:44.174737+00:00 340252.0
exp_2023_01_30_13 200 leopard 9 1675113644.1797373 2023-01-30T21:20:44.179737+00:00 340244.0
exp_2023_01_30_13 200 leopard 10 1675113644.1847372 2023-01-30T21:20:44.184737+00:00 340235.0
exp_2023_01_30_13 200 leopard 11 1675113644.1897373 2023-01-30T21:20:44.189737+00:00 340227.0
exp_2023_01_30_13 200 leopard 12 1675113644.1947372 2023-01-30T21:20:44.194737+00:00 340219.0
exp_2023_01_30_13 200 leopard 13 1675113644.1997373 2023-01-30T21:20:44.199737+00:00 340211.0
exp_2023_01_30_13 200 leopard 14 1675113644.2047372 2023-01-30T21:20:44.204737+00:00 340204.0
exp_2023_01_30_13 200 leopard 15 1675113644.2097373 2023-01-30T21:20:44.209737+00:00 340196.0
exp_2023_01_30_13 200 leopard 16 1675113644.2147372 2023-01-30T21:20:44.214737+00:00 340189.0
exp_2023_01_30_13 200 leopard 17 1675113644.2197373 2023-01-30T21:20:44.219737+00:00 340182.0
exp_2023_01_30_13 200 leopard 18 1675113644.2247372 2023-01-30T21:20:44.224737+00:00 340175.0
exp_2023_01_30_13 200 leopard 19 1675113644.2297373 2023-01-30T21:20:44.229737+00:00 340169.0
exp_2023_01_30_13 200 leopard 20 1675113644.2347372 2023-01-30T21:20:44.234737+00:00 340163.0
exp_2023_01_30_13 200 leopard 21 1675113644.2397373 2023-01-30T21:20:44.239737+00:00 340157.0
exp_2023_01_30_13 200 leopard 22 1675113644.2447371 2023-01-30T21:20:44.244737+00:00 340151.0
exp_2023_01_30_13 200 leopard 23 1675113644.2497373 2023-01-30T21:20:44.249737+00:00 340145.0
exp_2023_01_30_13 200 leopard 24 1675113644.2547371 2023-01-30T21:20:44.254737+00:00 340140.0
exp_2023_01_30_13 200 leopard 25 1675113644.2597373 2023-01-30T21:20:44.259737+00:00 340136.0
exp_2023_01_30_13 200 leopard 26 1675113644.2647374 2023-01-30T21:20:44.264737+00:00 340131.0
exp_2023_01_30_13 200 leopard 27 1675113644.2697372 2023-01-30T21:20:44.269737+00:00 340126.0
exp_2023_01_30_13 200 leopard 28 1675113644.2747374 2023-01-30T21:20:44.274737+00:00 340122.0
exp_2023_01_30_13 200 leopard 29 1675113644.2797372 2023-01-30T21:20:44.279737+00:00 340119.0
exp_2023_01_30_13 200 leopard 30 1675113644.2847373 2023-01-30T21:20:44.284737+00:00 340115.0
exp_2023_01_30_13 200 leopard 31 1675113644.2897372 2023-01-30T21:20:44.289737+00:00 340112.0
exp_2023_01_30_13 200 leopard 32 1675113644.2947373 2023-01-30T21:20:44.294737+00:00 340108.0
exp_2023_01_30_13 200 leopard 33 1675113644.2997372 2023-01-30T21:20:44.299737+00:00 340106.0
exp_2023_01_30_13 200 leopard 34 1675113644.3047373 2023-01-30T21:20:44.304737+00:00 340103.0
exp_2023_01_30_13 200 leopard 35 1675113644.3097372 2023-01-30T21:20:44.309737+00:00 340100.0
exp_2023_01_30_13 200 leopard 36 1675113644.3147373 2023-01-30T21:20:44.314737+00:00 340098.0
exp_2023_01_30_13 200 leopard 37 1675113644.3197372 2023-01-30T21:20:44.319737+00:00 340096.0
exp_2023_01_30_13 200 leopard 38 1675113644.3247373 2023-01-30T21:20:44.324737+00:00 340093.0
exp_2023_01_30_13 200 leopard 39 1675113644.3297372 2023-01-30T21:20:44.329737+00:00 340091.0
exp_2023_01_30_13 200 leopard 40 1675113644.3347373 2023-01-30T21:20:44.334737+00:00 340089.0
exp_2023_01_30_13 200 leopard 41 1675113644.3397372 2023-01-30T21:20:44.339737+00:00 340087.0
exp_2023_01_30_13 200 leopard 42 1675113644.3447373 2023-01-30T21:20:44.344737+00:00 340085.0
exp_2023_01_30_13 200 leopard 43 1675113644.3497372 2023-01-30T21:20:44.349737+00:00 340083.0
exp_2023_01_30_13 200 leopard 44 1675113644.3547373 2023-01-30T21:20:44.354737+00:00 340081.0
exp_2023_01_30_13 200 leopard 45 1675113644.3597372 2023-01-30T21:20:44.359737+00:00 340080.0
exp_2023_01_30_13 200 leopard 46 1675113644.3647373 2023-01-30T21:20:44.364737+00:00 340078.0
exp_2023_01_30_13 200 leopard 47 1675113644.3697371 2023-01-30T21:20:44.369737+00:00 340076.0
exp_2023_01_30_13 200 leopard 48 1675113644.3747373 2023-01-30T21:20:44.374737+00:00 340074.0
exp_2023_01_30_13 200 leopard 49 1675113644.3797371 2023-01-30T21:20:44.379737+00:00 340072.0
exp_2023_01_30_13 200 leopard 50 1675113644.3847373 2023-01-30T21:20:44.384737+00:00 340069.0
exp_2023_01_30_13 200 leopard 51 1675113644.3897374 2023-01-30T21:20:44.389737+00:00 340067.0
exp_2023_01_30_13 200 leopard 52 1675113644.3947372 2023-01-30T21:20:44.394737+00:00 340065.0
exp_2023_01_30_13 200 leopard 53 1675113644.3997374 2023-01-30T21:20:44.399737+00:00 340062.0
exp_2023_01_30_13 200 leopard 54 1675113644.4047372 2023-01-30T21:20:44.404737+00:00 340060.0
exp_2023_01_30_13 200 leopard 55 1675113644.4097373 2023-01-30T21:20:44.409737+00:00 340057.0
exp_2023_01_30_13 200 leopard 56 1675113644.4147372 2023-01-30T21:20:44.414737+00:00 340054.0
exp_2023_01_30_13 200 leopard 57 1675113644.4197373 2023-01-30T21:20:44.419737+00:00 340052.0
exp_2023_01_30_13 200 leopard 58 1675113644.4247372 2023-01-30T21:20:44.424737+00:00 340049.0
exp_2023_01_30_13 200 leopard 59 1675113644.4297373 2023-01-30T21:20:44.429737+00:00 340046.0
exp_2023_01_30_13 200 leopard 60 1675113644.4347372 2023-01-30T21:20:44.434737+00:00 340044.0
exp_2023_01_30_13 200 leopard 61 1675113644.4397373 2023-01-30T21:20:44.439737+00:00 340041.0
exp_2023_01_30_13 200 leopard 62 1675113644.4447372 2023-01-30T21:20:44.444737+00:00 340039.0
exp_2023_01_30_13 200 leopard 63 1675113644.4497373 2023-01-30T21:20:44.449737+00:00 340036.0
exp_2023_01_30_13 200 leopard 64 1675113644.4547372 2023-01-30T21:20:44.454737+00:00 340035.0
exp_2023_01_30_13 200 leopard 65 1675113644.4597373 2023-01-30T21:20:44.459737+00:00 340033.0
exp_2023_01_30_13 200 leopard 66 1675113644.4647372 2023-01-30T21:20:44.464737+00:00 340032.0
exp_2023_01_30_13 200 leopard 67 1675113644.4697373 2023-01-30T21:20:44.469737+00:00 340031.0
exp_2023_01_30_13 200 leopard 68 1675113644.4747372 2023-01-30T21:20:44.474737+00:00 340031.0
exp_2023_01_30_13 200 leopard 69 1675113644.4797373 2023-01-30T21:20:44.479737+00:00 340032.0
exp_2023_01_30_13 200 leopard 70 1675113644.4847372 2023-01-30T21:20:44.484737+00:00 340033.0
exp_2023_01_30_13 200 leopard 71 1675113644.4897373 2023-01-30T21:20:44.489737+00:00 340034.0
exp_2023_01_30_13 200 leopard 72 1675113644.4947371 2023-01-30T21:20:44.494737+00:00 340037.0
exp_2023_01_30_13 200 leopard 73 1675113644.4997373 2023-01-30T21:20:44.499737+00:00 340041.0
exp_2023_01_30_13 200 leopard 74 1675113644.5047371 2023-01-30T21:20:44.504737+00:00 340046.0
exp_2023_01_30_13 200 leopard 75 1675113644.5097373 2023-01-30T21:20:44.509737+00:00 340052.0
exp_2023_01_30_13 200 leopard 76 1675113644.5147374 2023-01-30T21:20:44.514737+00:00 340059.0
exp_2023_01_30_13 200 leopard 77 1675113644.5197372 2023-01-30T21:20:44.519737+00:00 340068.0
exp_2023_01_30_13 200 leopard 78 1675113644.5247374 2023-01-30T21:20:44.524737+00:00 340078.0
exp_2023_01_30_13 200 leopard 79 1675113644.5297372 2023-01-30T21:20:44.529737+00:00 340090.0
exp_2023_01_30_13 200 leopard 80 1675113644.5347373 2023-01-30T21:20:44.534737+00:00 340104.0
exp_2023_01_30_13 200 leopard 81 1675113644.5397372 2023-01-30T21:20:44.539737+00:00 340119.0
exp_2023_01_30_13 200 leopard 82 1675113644.5447373 2023-01-30T21:20:44.544737+00:00 340136.0
exp_2023_01_30_13 200 leopard 83 1675113644.5497372 2023-01-30T21:20:44.549737+00:00 340155.0
exp_2023_01_30_13 200 leopard 84 1675113644.5547373 2023-01-30T21:20:44.554737+00:00 340176.0
exp_2023_01_30_13 200 leopard 85 1675113644.5597372 2023-01-30T21:20:44.559737+00:00 340200.0
exp_2023_01_30_13 200 leopard 86 1675113644.5647373 2023-01-30T21:20:44.564737+00:00 340225.0
exp_2023_01_30_13 200 leopard 87 1675113644.5697372 2023-01-30T21:20:44.569737+00:00 340253.0
exp_2023_01_30_13 200 leopard 88 1675113644.5747373 2023-01-30T21:20:44.574737+00:00 340283.0
exp_2023_01_30_13 200 leopard 89 1675113644.5797372 2023-01-30T21:20:44.579737+00:00 340316.0
exp_2023_01_30_13 200 leopard 90 1675113644.5847373 2023-01-30T21:20:44.584737+00:00 340350.0
exp_2023_01_30_13 200 leopard 91 1675113644.5897372 2023-01-30T21:20:44.589737+00:00 340387.0
exp_2023_01_30_13 200 leopard 92 1675113644.5947373 2023-01-30T21:20:44.594737+00:00 340427.0
exp_2023_01_30_13 200 leopard 93 1675113644.5997372 2023-01-30T21:20:44.599737+00:00 340470.0
exp_2023_01_30_13 200 leopard 94 1675113644.6047373 2023-01-30T21:20:44.604737+00:00 340514.0
exp_2023_01_30_13 200 leopard 95 1675113644.6097372 2023-01-30T21:20:44.609737+00:00 340561.0
exp_2023_01_30_13 200 leopard 96 1675113644.6147373 2023-01-30T21:20:44.614737+00:00 340611.0
exp_2023_01_30_13 200 leopard 97 1675113644.6197371 2023-01-30T21:20:44.619737+00:00 340664.0
exp_2023_01_30_13 200 leopard 98 1675113644.6247373 2023-01-30T21:20:44.624737+00:00 340718.0
exp_2023_01_30_13 200 leopard 99 1675113644.6297371 2023-01-30T21:20:44.629737+00:00 340775.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]);