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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_04_28_10 200 leopard 0 1682705527.5424032 2023-04-28T18:12:07.542403+00:00 432424.0
exp_2023_04_28_10 200 leopard 1 1682705527.5474033 2023-04-28T18:12:07.547403+00:00 432413.0
exp_2023_04_28_10 200 leopard 2 1682705527.5524032 2023-04-28T18:12:07.552403+00:00 432403.0
exp_2023_04_28_10 200 leopard 3 1682705527.5574033 2023-04-28T18:12:07.557403+00:00 432393.0
exp_2023_04_28_10 200 leopard 4 1682705527.5624032 2023-04-28T18:12:07.562403+00:00 432382.0
exp_2023_04_28_10 200 leopard 5 1682705527.5674033 2023-04-28T18:12:07.567403+00:00 432372.0
exp_2023_04_28_10 200 leopard 6 1682705527.5724032 2023-04-28T18:12:07.572403+00:00 432361.0
exp_2023_04_28_10 200 leopard 7 1682705527.5774033 2023-04-28T18:12:07.577403+00:00 432351.0
exp_2023_04_28_10 200 leopard 8 1682705527.5824032 2023-04-28T18:12:07.582403+00:00 432340.0
exp_2023_04_28_10 200 leopard 9 1682705527.5874033 2023-04-28T18:12:07.587403+00:00 432330.0
exp_2023_04_28_10 200 leopard 10 1682705527.5924032 2023-04-28T18:12:07.592403+00:00 432319.0
exp_2023_04_28_10 200 leopard 11 1682705527.5974033 2023-04-28T18:12:07.597403+00:00 432309.0
exp_2023_04_28_10 200 leopard 12 1682705527.6024032 2023-04-28T18:12:07.602403+00:00 432298.0
exp_2023_04_28_10 200 leopard 13 1682705527.6074033 2023-04-28T18:12:07.607403+00:00 432287.0
exp_2023_04_28_10 200 leopard 14 1682705527.6124032 2023-04-28T18:12:07.612403+00:00 432277.0
exp_2023_04_28_10 200 leopard 15 1682705527.6174033 2023-04-28T18:12:07.617403+00:00 432267.0
exp_2023_04_28_10 200 leopard 16 1682705527.6224031 2023-04-28T18:12:07.622403+00:00 432256.0
exp_2023_04_28_10 200 leopard 17 1682705527.6274033 2023-04-28T18:12:07.627403+00:00 432246.0
exp_2023_04_28_10 200 leopard 18 1682705527.6324031 2023-04-28T18:12:07.632403+00:00 432236.0
exp_2023_04_28_10 200 leopard 19 1682705527.6374032 2023-04-28T18:12:07.637403+00:00 432226.0
exp_2023_04_28_10 200 leopard 20 1682705527.6424031 2023-04-28T18:12:07.642403+00:00 432215.0
exp_2023_04_28_10 200 leopard 21 1682705527.6474032 2023-04-28T18:12:07.647403+00:00 432205.0
exp_2023_04_28_10 200 leopard 22 1682705527.652403 2023-04-28T18:12:07.652403+00:00 432196.0
exp_2023_04_28_10 200 leopard 23 1682705527.6574032 2023-04-28T18:12:07.657403+00:00 432186.0
exp_2023_04_28_10 200 leopard 24 1682705527.662403 2023-04-28T18:12:07.662403+00:00 432176.0
exp_2023_04_28_10 200 leopard 25 1682705527.6674032 2023-04-28T18:12:07.667403+00:00 432166.0
exp_2023_04_28_10 200 leopard 26 1682705527.6724033 2023-04-28T18:12:07.672403+00:00 432157.0
exp_2023_04_28_10 200 leopard 27 1682705527.6774032 2023-04-28T18:12:07.677403+00:00 432148.0
exp_2023_04_28_10 200 leopard 28 1682705527.6824033 2023-04-28T18:12:07.682403+00:00 432139.0
exp_2023_04_28_10 200 leopard 29 1682705527.6874032 2023-04-28T18:12:07.687403+00:00 432130.0
exp_2023_04_28_10 200 leopard 30 1682705527.6924033 2023-04-28T18:12:07.692403+00:00 432121.0
exp_2023_04_28_10 200 leopard 31 1682705527.6974032 2023-04-28T18:12:07.697403+00:00 432112.0
exp_2023_04_28_10 200 leopard 32 1682705527.7024033 2023-04-28T18:12:07.702403+00:00 432103.0
exp_2023_04_28_10 200 leopard 33 1682705527.7074032 2023-04-28T18:12:07.707403+00:00 432095.0
exp_2023_04_28_10 200 leopard 34 1682705527.7124033 2023-04-28T18:12:07.712403+00:00 432087.0
exp_2023_04_28_10 200 leopard 35 1682705527.7174032 2023-04-28T18:12:07.717403+00:00 432079.0
exp_2023_04_28_10 200 leopard 36 1682705527.7224033 2023-04-28T18:12:07.722403+00:00 432071.0
exp_2023_04_28_10 200 leopard 37 1682705527.7274032 2023-04-28T18:12:07.727403+00:00 432063.0
exp_2023_04_28_10 200 leopard 38 1682705527.7324033 2023-04-28T18:12:07.732403+00:00 432056.0
exp_2023_04_28_10 200 leopard 39 1682705527.7374032 2023-04-28T18:12:07.737403+00:00 432048.0
exp_2023_04_28_10 200 leopard 40 1682705527.7424033 2023-04-28T18:12:07.742403+00:00 432041.0
exp_2023_04_28_10 200 leopard 41 1682705527.7474031 2023-04-28T18:12:07.747403+00:00 432034.0
exp_2023_04_28_10 200 leopard 42 1682705527.7524033 2023-04-28T18:12:07.752403+00:00 432027.0
exp_2023_04_28_10 200 leopard 43 1682705527.7574031 2023-04-28T18:12:07.757403+00:00 432020.0
exp_2023_04_28_10 200 leopard 44 1682705527.7624032 2023-04-28T18:12:07.762403+00:00 432014.0
exp_2023_04_28_10 200 leopard 45 1682705527.7674031 2023-04-28T18:12:07.767403+00:00 432007.0
exp_2023_04_28_10 200 leopard 46 1682705527.7724032 2023-04-28T18:12:07.772403+00:00 432001.0
exp_2023_04_28_10 200 leopard 47 1682705527.777403 2023-04-28T18:12:07.777403+00:00 431995.0
exp_2023_04_28_10 200 leopard 48 1682705527.7824032 2023-04-28T18:12:07.782403+00:00 431989.0
exp_2023_04_28_10 200 leopard 49 1682705527.787403 2023-04-28T18:12:07.787403+00:00 431983.0
exp_2023_04_28_10 200 leopard 50 1682705527.7924032 2023-04-28T18:12:07.792403+00:00 431977.0
exp_2023_04_28_10 200 leopard 51 1682705527.7974033 2023-04-28T18:12:07.797403+00:00 431971.0
exp_2023_04_28_10 200 leopard 52 1682705527.8024032 2023-04-28T18:12:07.802403+00:00 431965.0
exp_2023_04_28_10 200 leopard 53 1682705527.8074033 2023-04-28T18:12:07.807403+00:00 431959.0
exp_2023_04_28_10 200 leopard 54 1682705527.8124032 2023-04-28T18:12:07.812403+00:00 431954.0
exp_2023_04_28_10 200 leopard 55 1682705527.8174033 2023-04-28T18:12:07.817403+00:00 431948.0
exp_2023_04_28_10 200 leopard 56 1682705527.8224032 2023-04-28T18:12:07.822403+00:00 431943.0
exp_2023_04_28_10 200 leopard 57 1682705527.8274033 2023-04-28T18:12:07.827403+00:00 431937.0
exp_2023_04_28_10 200 leopard 58 1682705527.8324032 2023-04-28T18:12:07.832403+00:00 431932.0
exp_2023_04_28_10 200 leopard 59 1682705527.8374033 2023-04-28T18:12:07.837403+00:00 431927.0
exp_2023_04_28_10 200 leopard 60 1682705527.8424032 2023-04-28T18:12:07.842403+00:00 431921.0
exp_2023_04_28_10 200 leopard 61 1682705527.8474033 2023-04-28T18:12:07.847403+00:00 431916.0
exp_2023_04_28_10 200 leopard 62 1682705527.8524032 2023-04-28T18:12:07.852403+00:00 431911.0
exp_2023_04_28_10 200 leopard 63 1682705527.8574033 2023-04-28T18:12:07.857403+00:00 431905.0
exp_2023_04_28_10 200 leopard 64 1682705527.8624032 2023-04-28T18:12:07.862403+00:00 431900.0
exp_2023_04_28_10 200 leopard 65 1682705527.8674033 2023-04-28T18:12:07.867403+00:00 431894.0
exp_2023_04_28_10 200 leopard 66 1682705527.8724031 2023-04-28T18:12:07.872403+00:00 431889.0
exp_2023_04_28_10 200 leopard 67 1682705527.8774033 2023-04-28T18:12:07.877403+00:00 431883.0
exp_2023_04_28_10 200 leopard 68 1682705527.8824031 2023-04-28T18:12:07.882403+00:00 431878.0
exp_2023_04_28_10 200 leopard 69 1682705527.8874032 2023-04-28T18:12:07.887403+00:00 431872.0
exp_2023_04_28_10 200 leopard 70 1682705527.8924031 2023-04-28T18:12:07.892403+00:00 431867.0
exp_2023_04_28_10 200 leopard 71 1682705527.8974032 2023-04-28T18:12:07.897403+00:00 431861.0
exp_2023_04_28_10 200 leopard 72 1682705527.902403 2023-04-28T18:12:07.902403+00:00 431856.0
exp_2023_04_28_10 200 leopard 73 1682705527.9074032 2023-04-28T18:12:07.907403+00:00 431850.0
exp_2023_04_28_10 200 leopard 74 1682705527.912403 2023-04-28T18:12:07.912403+00:00 431844.0
exp_2023_04_28_10 200 leopard 75 1682705527.9174032 2023-04-28T18:12:07.917403+00:00 431839.0
exp_2023_04_28_10 200 leopard 76 1682705527.9224033 2023-04-28T18:12:07.922403+00:00 431833.0
exp_2023_04_28_10 200 leopard 77 1682705527.9274032 2023-04-28T18:12:07.927403+00:00 431827.0
exp_2023_04_28_10 200 leopard 78 1682705527.9324033 2023-04-28T18:12:07.932403+00:00 431821.0
exp_2023_04_28_10 200 leopard 79 1682705527.9374032 2023-04-28T18:12:07.937403+00:00 431816.0
exp_2023_04_28_10 200 leopard 80 1682705527.9424033 2023-04-28T18:12:07.942403+00:00 431810.0
exp_2023_04_28_10 200 leopard 81 1682705527.9474032 2023-04-28T18:12:07.947403+00:00 431804.0
exp_2023_04_28_10 200 leopard 82 1682705527.9524033 2023-04-28T18:12:07.952403+00:00 431798.0
exp_2023_04_28_10 200 leopard 83 1682705527.9574032 2023-04-28T18:12:07.957403+00:00 431793.0
exp_2023_04_28_10 200 leopard 84 1682705527.9624033 2023-04-28T18:12:07.962403+00:00 431787.0
exp_2023_04_28_10 200 leopard 85 1682705527.9674032 2023-04-28T18:12:07.967403+00:00 431781.0
exp_2023_04_28_10 200 leopard 86 1682705527.9724033 2023-04-28T18:12:07.972403+00:00 431776.0
exp_2023_04_28_10 200 leopard 87 1682705527.9774032 2023-04-28T18:12:07.977403+00:00 431770.0
exp_2023_04_28_10 200 leopard 88 1682705527.9824033 2023-04-28T18:12:07.982403+00:00 431765.0
exp_2023_04_28_10 200 leopard 89 1682705527.9874032 2023-04-28T18:12:07.987403+00:00 431759.0
exp_2023_04_28_10 200 leopard 90 1682705527.9924033 2023-04-28T18:12:07.992403+00:00 431754.0
exp_2023_04_28_10 200 leopard 91 1682705527.9974031 2023-04-28T18:12:07.997403+00:00 431749.0
exp_2023_04_28_10 200 leopard 92 1682705528.0024033 2023-04-28T18:12:08.002403+00:00 431743.0
exp_2023_04_28_10 200 leopard 93 1682705528.0074031 2023-04-28T18:12:08.007403+00:00 431738.0
exp_2023_04_28_10 200 leopard 94 1682705528.0124032 2023-04-28T18:12:08.012403+00:00 431733.0
exp_2023_04_28_10 200 leopard 95 1682705528.0174031 2023-04-28T18:12:08.017403+00:00 431728.0
exp_2023_04_28_10 200 leopard 96 1682705528.0224032 2023-04-28T18:12:08.022403+00:00 431723.0
exp_2023_04_28_10 200 leopard 97 1682705528.027403 2023-04-28T18:12:08.027403+00:00 431718.0
exp_2023_04_28_10 200 leopard 98 1682705528.0324032 2023-04-28T18:12:08.032403+00:00 431714.0
exp_2023_04_28_10 200 leopard 99 1682705528.037403 2023-04-28T18:12:08.037403+00:00 431709.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]);