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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_10_18_10 200 leopard 0 1666117910.5168164 2022-10-18T18:31:50.516816+00:00 583316.0
exp_2022_10_18_10 200 leopard 1 1666117910.5218165 2022-10-18T18:31:50.521816+00:00 583547.0
exp_2022_10_18_10 200 leopard 2 1666117910.5268164 2022-10-18T18:31:50.526816+00:00 583772.0
exp_2022_10_18_10 200 leopard 3 1666117910.5318165 2022-10-18T18:31:50.531816+00:00 583990.0
exp_2022_10_18_10 200 leopard 4 1666117910.5368164 2022-10-18T18:31:50.536816+00:00 584198.0
exp_2022_10_18_10 200 leopard 5 1666117910.5418165 2022-10-18T18:31:50.541816+00:00 584397.0
exp_2022_10_18_10 200 leopard 6 1666117910.5468163 2022-10-18T18:31:50.546816+00:00 584584.0
exp_2022_10_18_10 200 leopard 7 1666117910.5518165 2022-10-18T18:31:50.551816+00:00 584757.0
exp_2022_10_18_10 200 leopard 8 1666117910.5568163 2022-10-18T18:31:50.556816+00:00 584916.0
exp_2022_10_18_10 200 leopard 9 1666117910.5618165 2022-10-18T18:31:50.561816+00:00 585061.0
exp_2022_10_18_10 200 leopard 10 1666117910.5668163 2022-10-18T18:31:50.566816+00:00 585190.0
exp_2022_10_18_10 200 leopard 11 1666117910.5718164 2022-10-18T18:31:50.571816+00:00 585302.0
exp_2022_10_18_10 200 leopard 12 1666117910.5768163 2022-10-18T18:31:50.576816+00:00 585397.0
exp_2022_10_18_10 200 leopard 13 1666117910.5818164 2022-10-18T18:31:50.581816+00:00 585475.0
exp_2022_10_18_10 200 leopard 14 1666117910.5868163 2022-10-18T18:31:50.586816+00:00 585536.0
exp_2022_10_18_10 200 leopard 15 1666117910.5918164 2022-10-18T18:31:50.591816+00:00 585579.0
exp_2022_10_18_10 200 leopard 16 1666117910.5968163 2022-10-18T18:31:50.596816+00:00 585605.0
exp_2022_10_18_10 200 leopard 17 1666117910.6018164 2022-10-18T18:31:50.601816+00:00 585614.0
exp_2022_10_18_10 200 leopard 18 1666117910.6068163 2022-10-18T18:31:50.606816+00:00 585607.0
exp_2022_10_18_10 200 leopard 19 1666117910.6118164 2022-10-18T18:31:50.611816+00:00 585582.0
exp_2022_10_18_10 200 leopard 20 1666117910.6168163 2022-10-18T18:31:50.616816+00:00 585542.0
exp_2022_10_18_10 200 leopard 21 1666117910.6218164 2022-10-18T18:31:50.621816+00:00 585488.0
exp_2022_10_18_10 200 leopard 22 1666117910.6268163 2022-10-18T18:31:50.626816+00:00 585420.0
exp_2022_10_18_10 200 leopard 23 1666117910.6318164 2022-10-18T18:31:50.631816+00:00 585339.0
exp_2022_10_18_10 200 leopard 24 1666117910.6368163 2022-10-18T18:31:50.636816+00:00 585246.0
exp_2022_10_18_10 200 leopard 25 1666117910.6418164 2022-10-18T18:31:50.641816+00:00 585143.0
exp_2022_10_18_10 200 leopard 26 1666117910.6468165 2022-10-18T18:31:50.646816+00:00 585032.0
exp_2022_10_18_10 200 leopard 27 1666117910.6518164 2022-10-18T18:31:50.651816+00:00 584912.0
exp_2022_10_18_10 200 leopard 28 1666117910.6568165 2022-10-18T18:31:50.656816+00:00 584787.0
exp_2022_10_18_10 200 leopard 29 1666117910.6618164 2022-10-18T18:31:50.661816+00:00 584658.0
exp_2022_10_18_10 200 leopard 30 1666117910.6668165 2022-10-18T18:31:50.666816+00:00 584526.0
exp_2022_10_18_10 200 leopard 31 1666117910.6718163 2022-10-18T18:31:50.671816+00:00 584394.0
exp_2022_10_18_10 200 leopard 32 1666117910.6768165 2022-10-18T18:31:50.676816+00:00 584263.0
exp_2022_10_18_10 200 leopard 33 1666117910.6818163 2022-10-18T18:31:50.681816+00:00 584136.0
exp_2022_10_18_10 200 leopard 34 1666117910.6868165 2022-10-18T18:31:50.686816+00:00 584014.0
exp_2022_10_18_10 200 leopard 35 1666117910.6918163 2022-10-18T18:31:50.691816+00:00 583899.0
exp_2022_10_18_10 200 leopard 36 1666117910.6968164 2022-10-18T18:31:50.696816+00:00 583794.0
exp_2022_10_18_10 200 leopard 37 1666117910.7018163 2022-10-18T18:31:50.701816+00:00 583700.0
exp_2022_10_18_10 200 leopard 38 1666117910.7068164 2022-10-18T18:31:50.706816+00:00 583619.0
exp_2022_10_18_10 200 leopard 39 1666117910.7118163 2022-10-18T18:31:50.711816+00:00 583554.0
exp_2022_10_18_10 200 leopard 40 1666117910.7168164 2022-10-18T18:31:50.716816+00:00 583506.0
exp_2022_10_18_10 200 leopard 41 1666117910.7218163 2022-10-18T18:31:50.721816+00:00 583479.0
exp_2022_10_18_10 200 leopard 42 1666117910.7268164 2022-10-18T18:31:50.726816+00:00 583472.0
exp_2022_10_18_10 200 leopard 43 1666117910.7318163 2022-10-18T18:31:50.731816+00:00 583489.0
exp_2022_10_18_10 200 leopard 44 1666117910.7368164 2022-10-18T18:31:50.736816+00:00 583531.0
exp_2022_10_18_10 200 leopard 45 1666117910.7418163 2022-10-18T18:31:50.741816+00:00 583600.0
exp_2022_10_18_10 200 leopard 46 1666117910.7468164 2022-10-18T18:31:50.746816+00:00 583697.0
exp_2022_10_18_10 200 leopard 47 1666117910.7518163 2022-10-18T18:31:50.751816+00:00 583824.0
exp_2022_10_18_10 200 leopard 48 1666117910.7568164 2022-10-18T18:31:50.756816+00:00 583983.0
exp_2022_10_18_10 200 leopard 49 1666117910.7618163 2022-10-18T18:31:50.761816+00:00 584174.0
exp_2022_10_18_10 200 leopard 50 1666117910.7668164 2022-10-18T18:31:50.766816+00:00 584400.0
exp_2022_10_18_10 200 leopard 51 1666117910.7718165 2022-10-18T18:31:50.771816+00:00 584659.0
exp_2022_10_18_10 200 leopard 52 1666117910.7768164 2022-10-18T18:31:50.776816+00:00 584955.0
exp_2022_10_18_10 200 leopard 53 1666117910.7818165 2022-10-18T18:31:50.781816+00:00 585288.0
exp_2022_10_18_10 200 leopard 54 1666117910.7868164 2022-10-18T18:31:50.786816+00:00 585657.0
exp_2022_10_18_10 200 leopard 55 1666117910.7918165 2022-10-18T18:31:50.791816+00:00 586062.0
exp_2022_10_18_10 200 leopard 56 1666117910.7968163 2022-10-18T18:31:50.796816+00:00 586506.0
exp_2022_10_18_10 200 leopard 57 1666117910.8018165 2022-10-18T18:31:50.801816+00:00 586987.0
exp_2022_10_18_10 200 leopard 58 1666117910.8068163 2022-10-18T18:31:50.806816+00:00 587505.0
exp_2022_10_18_10 200 leopard 59 1666117910.8118165 2022-10-18T18:31:50.811816+00:00 588059.0
exp_2022_10_18_10 200 leopard 60 1666117910.8168163 2022-10-18T18:31:50.816816+00:00 588649.0
exp_2022_10_18_10 200 leopard 61 1666117910.8218164 2022-10-18T18:31:50.821816+00:00 589274.0
exp_2022_10_18_10 200 leopard 62 1666117910.8268163 2022-10-18T18:31:50.826816+00:00 589933.0
exp_2022_10_18_10 200 leopard 63 1666117910.8318164 2022-10-18T18:31:50.831816+00:00 590625.0
exp_2022_10_18_10 200 leopard 64 1666117910.8368163 2022-10-18T18:31:50.836816+00:00 591349.0
exp_2022_10_18_10 200 leopard 65 1666117910.8418164 2022-10-18T18:31:50.841816+00:00 592102.0
exp_2022_10_18_10 200 leopard 66 1666117910.8468163 2022-10-18T18:31:50.846816+00:00 592884.0
exp_2022_10_18_10 200 leopard 67 1666117910.8518164 2022-10-18T18:31:50.851816+00:00 593691.0
exp_2022_10_18_10 200 leopard 68 1666117910.8568163 2022-10-18T18:31:50.856816+00:00 594522.0
exp_2022_10_18_10 200 leopard 69 1666117910.8618164 2022-10-18T18:31:50.861816+00:00 595375.0
exp_2022_10_18_10 200 leopard 70 1666117910.8668163 2022-10-18T18:31:50.866816+00:00 596248.0
exp_2022_10_18_10 200 leopard 71 1666117910.8718164 2022-10-18T18:31:50.871816+00:00 597137.0
exp_2022_10_18_10 200 leopard 72 1666117910.8768163 2022-10-18T18:31:50.876816+00:00 598041.0
exp_2022_10_18_10 200 leopard 73 1666117910.8818164 2022-10-18T18:31:50.881816+00:00 598956.0
exp_2022_10_18_10 200 leopard 74 1666117910.8868163 2022-10-18T18:31:50.886816+00:00 599881.0
exp_2022_10_18_10 200 leopard 75 1666117910.8918164 2022-10-18T18:31:50.891816+00:00 600811.0
exp_2022_10_18_10 200 leopard 76 1666117910.8968165 2022-10-18T18:31:50.896816+00:00 601745.0
exp_2022_10_18_10 200 leopard 77 1666117910.9018164 2022-10-18T18:31:50.901816+00:00 602679.0
exp_2022_10_18_10 200 leopard 78 1666117910.9068165 2022-10-18T18:31:50.906816+00:00 603611.0
exp_2022_10_18_10 200 leopard 79 1666117910.9118164 2022-10-18T18:31:50.911816+00:00 604538.0
exp_2022_10_18_10 200 leopard 80 1666117910.9168165 2022-10-18T18:31:50.916816+00:00 605457.0
exp_2022_10_18_10 200 leopard 81 1666117910.9218163 2022-10-18T18:31:50.921816+00:00 606365.0
exp_2022_10_18_10 200 leopard 82 1666117910.9268165 2022-10-18T18:31:50.926816+00:00 607260.0
exp_2022_10_18_10 200 leopard 83 1666117910.9318163 2022-10-18T18:31:50.931816+00:00 608139.0
exp_2022_10_18_10 200 leopard 84 1666117910.9368165 2022-10-18T18:31:50.936816+00:00 609000.0
exp_2022_10_18_10 200 leopard 85 1666117910.9418163 2022-10-18T18:31:50.941816+00:00 609840.0
exp_2022_10_18_10 200 leopard 86 1666117910.9468164 2022-10-18T18:31:50.946816+00:00 610657.0
exp_2022_10_18_10 200 leopard 87 1666117910.9518163 2022-10-18T18:31:50.951816+00:00 611449.0
exp_2022_10_18_10 200 leopard 88 1666117910.9568164 2022-10-18T18:31:50.956816+00:00 612214.0
exp_2022_10_18_10 200 leopard 89 1666117910.9618163 2022-10-18T18:31:50.961816+00:00 612951.0
exp_2022_10_18_10 200 leopard 90 1666117910.9668164 2022-10-18T18:31:50.966816+00:00 613657.0
exp_2022_10_18_10 200 leopard 91 1666117910.9718163 2022-10-18T18:31:50.971816+00:00 614332.0
exp_2022_10_18_10 200 leopard 92 1666117910.9768164 2022-10-18T18:31:50.976816+00:00 614973.0
exp_2022_10_18_10 200 leopard 93 1666117910.9818163 2022-10-18T18:31:50.981816+00:00 615581.0
exp_2022_10_18_10 200 leopard 94 1666117910.9868164 2022-10-18T18:31:50.986816+00:00 616154.0
exp_2022_10_18_10 200 leopard 95 1666117910.9918163 2022-10-18T18:31:50.991816+00:00 616691.0
exp_2022_10_18_10 200 leopard 96 1666117910.9968164 2022-10-18T18:31:50.996816+00:00 617191.0
exp_2022_10_18_10 200 leopard 97 1666117911.0018163 2022-10-18T18:31:51.001816+00:00 617656.0
exp_2022_10_18_10 200 leopard 98 1666117911.0068164 2022-10-18T18:31:51.006816+00:00 618084.0
exp_2022_10_18_10 200 leopard 99 1666117911.0118163 2022-10-18T18:31:51.011816+00:00 618474.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]);