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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_04_24_13 200 leopard 0 1682370159.3408113 2023-04-24T21:02:39.340811+00:00 384788.0
exp_2023_04_24_13 200 leopard 1 1682370159.3458114 2023-04-24T21:02:39.345811+00:00 384700.0
exp_2023_04_24_13 200 leopard 2 1682370159.3508112 2023-04-24T21:02:39.350811+00:00 384612.0
exp_2023_04_24_13 200 leopard 3 1682370159.3558114 2023-04-24T21:02:39.355811+00:00 384524.0
exp_2023_04_24_13 200 leopard 4 1682370159.3608112 2023-04-24T21:02:39.360811+00:00 384436.0
exp_2023_04_24_13 200 leopard 5 1682370159.3658113 2023-04-24T21:02:39.365811+00:00 384348.0
exp_2023_04_24_13 200 leopard 6 1682370159.3708112 2023-04-24T21:02:39.370811+00:00 384260.0
exp_2023_04_24_13 200 leopard 7 1682370159.3758113 2023-04-24T21:02:39.375811+00:00 384173.0
exp_2023_04_24_13 200 leopard 8 1682370159.3808112 2023-04-24T21:02:39.380811+00:00 384086.0
exp_2023_04_24_13 200 leopard 9 1682370159.3858113 2023-04-24T21:02:39.385811+00:00 383999.0
exp_2023_04_24_13 200 leopard 10 1682370159.3908112 2023-04-24T21:02:39.390811+00:00 383912.0
exp_2023_04_24_13 200 leopard 11 1682370159.3958113 2023-04-24T21:02:39.395811+00:00 383826.0
exp_2023_04_24_13 200 leopard 12 1682370159.4008112 2023-04-24T21:02:39.400811+00:00 383740.0
exp_2023_04_24_13 200 leopard 13 1682370159.4058113 2023-04-24T21:02:39.405811+00:00 383653.0
exp_2023_04_24_13 200 leopard 14 1682370159.4108112 2023-04-24T21:02:39.410811+00:00 383568.0
exp_2023_04_24_13 200 leopard 15 1682370159.4158113 2023-04-24T21:02:39.415811+00:00 383482.0
exp_2023_04_24_13 200 leopard 16 1682370159.4208112 2023-04-24T21:02:39.420811+00:00 383396.0
exp_2023_04_24_13 200 leopard 17 1682370159.4258113 2023-04-24T21:02:39.425811+00:00 383311.0
exp_2023_04_24_13 200 leopard 18 1682370159.4308112 2023-04-24T21:02:39.430811+00:00 383226.0
exp_2023_04_24_13 200 leopard 19 1682370159.4358113 2023-04-24T21:02:39.435811+00:00 383141.0
exp_2023_04_24_13 200 leopard 20 1682370159.4408112 2023-04-24T21:02:39.440811+00:00 383056.0
exp_2023_04_24_13 200 leopard 21 1682370159.4458113 2023-04-24T21:02:39.445811+00:00 382972.0
exp_2023_04_24_13 200 leopard 22 1682370159.4508111 2023-04-24T21:02:39.450811+00:00 382888.0
exp_2023_04_24_13 200 leopard 23 1682370159.4558113 2023-04-24T21:02:39.455811+00:00 382804.0
exp_2023_04_24_13 200 leopard 24 1682370159.4608111 2023-04-24T21:02:39.460811+00:00 382720.0
exp_2023_04_24_13 200 leopard 25 1682370159.4658113 2023-04-24T21:02:39.465811+00:00 382636.0
exp_2023_04_24_13 200 leopard 26 1682370159.4708114 2023-04-24T21:02:39.470811+00:00 382553.0
exp_2023_04_24_13 200 leopard 27 1682370159.4758112 2023-04-24T21:02:39.475811+00:00 382470.0
exp_2023_04_24_13 200 leopard 28 1682370159.4808114 2023-04-24T21:02:39.480811+00:00 382386.0
exp_2023_04_24_13 200 leopard 29 1682370159.4858112 2023-04-24T21:02:39.485811+00:00 382304.0
exp_2023_04_24_13 200 leopard 30 1682370159.4908113 2023-04-24T21:02:39.490811+00:00 382221.0
exp_2023_04_24_13 200 leopard 31 1682370159.4958112 2023-04-24T21:02:39.495811+00:00 382139.0
exp_2023_04_24_13 200 leopard 32 1682370159.5008113 2023-04-24T21:02:39.500811+00:00 382056.0
exp_2023_04_24_13 200 leopard 33 1682370159.5058112 2023-04-24T21:02:39.505811+00:00 381974.0
exp_2023_04_24_13 200 leopard 34 1682370159.5108113 2023-04-24T21:02:39.510811+00:00 381893.0
exp_2023_04_24_13 200 leopard 35 1682370159.5158112 2023-04-24T21:02:39.515811+00:00 381811.0
exp_2023_04_24_13 200 leopard 36 1682370159.5208113 2023-04-24T21:02:39.520811+00:00 381730.0
exp_2023_04_24_13 200 leopard 37 1682370159.5258112 2023-04-24T21:02:39.525811+00:00 381649.0
exp_2023_04_24_13 200 leopard 38 1682370159.5308113 2023-04-24T21:02:39.530811+00:00 381568.0
exp_2023_04_24_13 200 leopard 39 1682370159.5358112 2023-04-24T21:02:39.535811+00:00 381487.0
exp_2023_04_24_13 200 leopard 40 1682370159.5408113 2023-04-24T21:02:39.540811+00:00 381407.0
exp_2023_04_24_13 200 leopard 41 1682370159.5458112 2023-04-24T21:02:39.545811+00:00 381326.0
exp_2023_04_24_13 200 leopard 42 1682370159.5508113 2023-04-24T21:02:39.550811+00:00 381246.0
exp_2023_04_24_13 200 leopard 43 1682370159.5558112 2023-04-24T21:02:39.555811+00:00 381166.0
exp_2023_04_24_13 200 leopard 44 1682370159.5608113 2023-04-24T21:02:39.560811+00:00 381087.0
exp_2023_04_24_13 200 leopard 45 1682370159.5658112 2023-04-24T21:02:39.565811+00:00 381007.0
exp_2023_04_24_13 200 leopard 46 1682370159.5708113 2023-04-24T21:02:39.570811+00:00 380928.0
exp_2023_04_24_13 200 leopard 47 1682370159.5758111 2023-04-24T21:02:39.575811+00:00 380849.0
exp_2023_04_24_13 200 leopard 48 1682370159.5808113 2023-04-24T21:02:39.580811+00:00 380770.0
exp_2023_04_24_13 200 leopard 49 1682370159.5858111 2023-04-24T21:02:39.585811+00:00 380691.0
exp_2023_04_24_13 200 leopard 50 1682370159.5908113 2023-04-24T21:02:39.590811+00:00 380613.0
exp_2023_04_24_13 200 leopard 51 1682370159.5958114 2023-04-24T21:02:39.595811+00:00 380535.0
exp_2023_04_24_13 200 leopard 52 1682370159.6008112 2023-04-24T21:02:39.600811+00:00 380457.0
exp_2023_04_24_13 200 leopard 53 1682370159.6058114 2023-04-24T21:02:39.605811+00:00 380379.0
exp_2023_04_24_13 200 leopard 54 1682370159.6108112 2023-04-24T21:02:39.610811+00:00 380301.0
exp_2023_04_24_13 200 leopard 55 1682370159.6158113 2023-04-24T21:02:39.615811+00:00 380224.0
exp_2023_04_24_13 200 leopard 56 1682370159.6208112 2023-04-24T21:02:39.620811+00:00 380146.0
exp_2023_04_24_13 200 leopard 57 1682370159.6258113 2023-04-24T21:02:39.625811+00:00 380069.0
exp_2023_04_24_13 200 leopard 58 1682370159.6308112 2023-04-24T21:02:39.630811+00:00 379993.0
exp_2023_04_24_13 200 leopard 59 1682370159.6358113 2023-04-24T21:02:39.635811+00:00 379916.0
exp_2023_04_24_13 200 leopard 60 1682370159.6408112 2023-04-24T21:02:39.640811+00:00 379839.0
exp_2023_04_24_13 200 leopard 61 1682370159.6458113 2023-04-24T21:02:39.645811+00:00 379763.0
exp_2023_04_24_13 200 leopard 62 1682370159.6508112 2023-04-24T21:02:39.650811+00:00 379687.0
exp_2023_04_24_13 200 leopard 63 1682370159.6558113 2023-04-24T21:02:39.655811+00:00 379611.0
exp_2023_04_24_13 200 leopard 64 1682370159.6608112 2023-04-24T21:02:39.660811+00:00 379535.0
exp_2023_04_24_13 200 leopard 65 1682370159.6658113 2023-04-24T21:02:39.665811+00:00 379460.0
exp_2023_04_24_13 200 leopard 66 1682370159.6708112 2023-04-24T21:02:39.670811+00:00 379384.0
exp_2023_04_24_13 200 leopard 67 1682370159.6758113 2023-04-24T21:02:39.675811+00:00 379309.0
exp_2023_04_24_13 200 leopard 68 1682370159.6808112 2023-04-24T21:02:39.680811+00:00 379234.0
exp_2023_04_24_13 200 leopard 69 1682370159.6858113 2023-04-24T21:02:39.685811+00:00 379159.0
exp_2023_04_24_13 200 leopard 70 1682370159.6908112 2023-04-24T21:02:39.690811+00:00 379085.0
exp_2023_04_24_13 200 leopard 71 1682370159.6958113 2023-04-24T21:02:39.695811+00:00 379010.0
exp_2023_04_24_13 200 leopard 72 1682370159.7008111 2023-04-24T21:02:39.700811+00:00 378936.0
exp_2023_04_24_13 200 leopard 73 1682370159.7058113 2023-04-24T21:02:39.705811+00:00 378862.0
exp_2023_04_24_13 200 leopard 74 1682370159.7108111 2023-04-24T21:02:39.710811+00:00 378788.0
exp_2023_04_24_13 200 leopard 75 1682370159.7158113 2023-04-24T21:02:39.715811+00:00 378714.0
exp_2023_04_24_13 200 leopard 76 1682370159.7208114 2023-04-24T21:02:39.720811+00:00 378640.0
exp_2023_04_24_13 200 leopard 77 1682370159.7258112 2023-04-24T21:02:39.725811+00:00 378567.0
exp_2023_04_24_13 200 leopard 78 1682370159.7308114 2023-04-24T21:02:39.730811+00:00 378494.0
exp_2023_04_24_13 200 leopard 79 1682370159.7358112 2023-04-24T21:02:39.735811+00:00 378420.0
exp_2023_04_24_13 200 leopard 80 1682370159.7408113 2023-04-24T21:02:39.740811+00:00 378348.0
exp_2023_04_24_13 200 leopard 81 1682370159.7458112 2023-04-24T21:02:39.745811+00:00 378275.0
exp_2023_04_24_13 200 leopard 82 1682370159.7508113 2023-04-24T21:02:39.750811+00:00 378202.0
exp_2023_04_24_13 200 leopard 83 1682370159.7558112 2023-04-24T21:02:39.755811+00:00 378130.0
exp_2023_04_24_13 200 leopard 84 1682370159.7608113 2023-04-24T21:02:39.760811+00:00 378058.0
exp_2023_04_24_13 200 leopard 85 1682370159.7658112 2023-04-24T21:02:39.765811+00:00 377986.0
exp_2023_04_24_13 200 leopard 86 1682370159.7708113 2023-04-24T21:02:39.770811+00:00 377914.0
exp_2023_04_24_13 200 leopard 87 1682370159.7758112 2023-04-24T21:02:39.775811+00:00 377842.0
exp_2023_04_24_13 200 leopard 88 1682370159.7808113 2023-04-24T21:02:39.780811+00:00 377771.0
exp_2023_04_24_13 200 leopard 89 1682370159.7858112 2023-04-24T21:02:39.785811+00:00 377699.0
exp_2023_04_24_13 200 leopard 90 1682370159.7908113 2023-04-24T21:02:39.790811+00:00 377628.0
exp_2023_04_24_13 200 leopard 91 1682370159.7958112 2023-04-24T21:02:39.795811+00:00 377557.0
exp_2023_04_24_13 200 leopard 92 1682370159.8008113 2023-04-24T21:02:39.800811+00:00 377487.0
exp_2023_04_24_13 200 leopard 93 1682370159.8058112 2023-04-24T21:02:39.805811+00:00 377416.0
exp_2023_04_24_13 200 leopard 94 1682370159.8108113 2023-04-24T21:02:39.810811+00:00 377346.0
exp_2023_04_24_13 200 leopard 95 1682370159.8158112 2023-04-24T21:02:39.815811+00:00 377276.0
exp_2023_04_24_13 200 leopard 96 1682370159.8208113 2023-04-24T21:02:39.820811+00:00 377205.0
exp_2023_04_24_13 200 leopard 97 1682370159.8258111 2023-04-24T21:02:39.825811+00:00 377136.0
exp_2023_04_24_13 200 leopard 98 1682370159.8308113 2023-04-24T21:02:39.830811+00:00 377066.0
exp_2023_04_24_13 200 leopard 99 1682370159.8358111 2023-04-24T21:02:39.835811+00:00 376997.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]);