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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_17_15 200 leopard 0 1668730508.2189126 2022-11-18T00:15:08.218913+00:00 198485.0
exp_2022_11_17_15 200 leopard 1 1668730508.2239127 2022-11-18T00:15:08.223913+00:00 198514.0
exp_2022_11_17_15 200 leopard 2 1668730508.2289126 2022-11-18T00:15:08.228913+00:00 198543.0
exp_2022_11_17_15 200 leopard 3 1668730508.2339127 2022-11-18T00:15:08.233913+00:00 198572.0
exp_2022_11_17_15 200 leopard 4 1668730508.2389126 2022-11-18T00:15:08.238913+00:00 198601.0
exp_2022_11_17_15 200 leopard 5 1668730508.2439127 2022-11-18T00:15:08.243913+00:00 198630.0
exp_2022_11_17_15 200 leopard 6 1668730508.2489126 2022-11-18T00:15:08.248913+00:00 198658.0
exp_2022_11_17_15 200 leopard 7 1668730508.2539127 2022-11-18T00:15:08.253913+00:00 198686.0
exp_2022_11_17_15 200 leopard 8 1668730508.2589126 2022-11-18T00:15:08.258913+00:00 198714.0
exp_2022_11_17_15 200 leopard 9 1668730508.2639127 2022-11-18T00:15:08.263913+00:00 198742.0
exp_2022_11_17_15 200 leopard 10 1668730508.2689126 2022-11-18T00:15:08.268913+00:00 198769.0
exp_2022_11_17_15 200 leopard 11 1668730508.2739127 2022-11-18T00:15:08.273913+00:00 198797.0
exp_2022_11_17_15 200 leopard 12 1668730508.2789125 2022-11-18T00:15:08.278913+00:00 198824.0
exp_2022_11_17_15 200 leopard 13 1668730508.2839127 2022-11-18T00:15:08.283913+00:00 198851.0
exp_2022_11_17_15 200 leopard 14 1668730508.2889125 2022-11-18T00:15:08.288913+00:00 198877.0
exp_2022_11_17_15 200 leopard 15 1668730508.2939126 2022-11-18T00:15:08.293913+00:00 198904.0
exp_2022_11_17_15 200 leopard 16 1668730508.2989125 2022-11-18T00:15:08.298913+00:00 198931.0
exp_2022_11_17_15 200 leopard 17 1668730508.3039126 2022-11-18T00:15:08.303913+00:00 198957.0
exp_2022_11_17_15 200 leopard 18 1668730508.3089125 2022-11-18T00:15:08.308913+00:00 198983.0
exp_2022_11_17_15 200 leopard 19 1668730508.3139126 2022-11-18T00:15:08.313913+00:00 199009.0
exp_2022_11_17_15 200 leopard 20 1668730508.3189125 2022-11-18T00:15:08.318913+00:00 199034.0
exp_2022_11_17_15 200 leopard 21 1668730508.3239126 2022-11-18T00:15:08.323913+00:00 199060.0
exp_2022_11_17_15 200 leopard 22 1668730508.3289125 2022-11-18T00:15:08.328912+00:00 199085.0
exp_2022_11_17_15 200 leopard 23 1668730508.3339126 2022-11-18T00:15:08.333913+00:00 199111.0
exp_2022_11_17_15 200 leopard 24 1668730508.3389125 2022-11-18T00:15:08.338912+00:00 199136.0
exp_2022_11_17_15 200 leopard 25 1668730508.3439126 2022-11-18T00:15:08.343913+00:00 199161.0
exp_2022_11_17_15 200 leopard 26 1668730508.3489127 2022-11-18T00:15:08.348913+00:00 199185.0
exp_2022_11_17_15 200 leopard 27 1668730508.3539126 2022-11-18T00:15:08.353913+00:00 199210.0
exp_2022_11_17_15 200 leopard 28 1668730508.3589127 2022-11-18T00:15:08.358913+00:00 199234.0
exp_2022_11_17_15 200 leopard 29 1668730508.3639126 2022-11-18T00:15:08.363913+00:00 199259.0
exp_2022_11_17_15 200 leopard 30 1668730508.3689127 2022-11-18T00:15:08.368913+00:00 199283.0
exp_2022_11_17_15 200 leopard 31 1668730508.3739126 2022-11-18T00:15:08.373913+00:00 199307.0
exp_2022_11_17_15 200 leopard 32 1668730508.3789127 2022-11-18T00:15:08.378913+00:00 199331.0
exp_2022_11_17_15 200 leopard 33 1668730508.3839126 2022-11-18T00:15:08.383913+00:00 199354.0
exp_2022_11_17_15 200 leopard 34 1668730508.3889127 2022-11-18T00:15:08.388913+00:00 199378.0
exp_2022_11_17_15 200 leopard 35 1668730508.3939126 2022-11-18T00:15:08.393913+00:00 199401.0
exp_2022_11_17_15 200 leopard 36 1668730508.3989127 2022-11-18T00:15:08.398913+00:00 199424.0
exp_2022_11_17_15 200 leopard 37 1668730508.4039125 2022-11-18T00:15:08.403913+00:00 199447.0
exp_2022_11_17_15 200 leopard 38 1668730508.4089127 2022-11-18T00:15:08.408913+00:00 199470.0
exp_2022_11_17_15 200 leopard 39 1668730508.4139125 2022-11-18T00:15:08.413913+00:00 199493.0
exp_2022_11_17_15 200 leopard 40 1668730508.4189126 2022-11-18T00:15:08.418913+00:00 199516.0
exp_2022_11_17_15 200 leopard 41 1668730508.4239125 2022-11-18T00:15:08.423913+00:00 199538.0
exp_2022_11_17_15 200 leopard 42 1668730508.4289126 2022-11-18T00:15:08.428913+00:00 199561.0
exp_2022_11_17_15 200 leopard 43 1668730508.4339125 2022-11-18T00:15:08.433913+00:00 199583.0
exp_2022_11_17_15 200 leopard 44 1668730508.4389126 2022-11-18T00:15:08.438913+00:00 199605.0
exp_2022_11_17_15 200 leopard 45 1668730508.4439125 2022-11-18T00:15:08.443913+00:00 199627.0
exp_2022_11_17_15 200 leopard 46 1668730508.4489126 2022-11-18T00:15:08.448913+00:00 199649.0
exp_2022_11_17_15 200 leopard 47 1668730508.4539125 2022-11-18T00:15:08.453912+00:00 199670.0
exp_2022_11_17_15 200 leopard 48 1668730508.4589126 2022-11-18T00:15:08.458913+00:00 199692.0
exp_2022_11_17_15 200 leopard 49 1668730508.4639125 2022-11-18T00:15:08.463912+00:00 199713.0
exp_2022_11_17_15 200 leopard 50 1668730508.4689126 2022-11-18T00:15:08.468913+00:00 199735.0
exp_2022_11_17_15 200 leopard 51 1668730508.4739127 2022-11-18T00:15:08.473913+00:00 199756.0
exp_2022_11_17_15 200 leopard 52 1668730508.4789126 2022-11-18T00:15:08.478913+00:00 199777.0
exp_2022_11_17_15 200 leopard 53 1668730508.4839127 2022-11-18T00:15:08.483913+00:00 199797.0
exp_2022_11_17_15 200 leopard 54 1668730508.4889126 2022-11-18T00:15:08.488913+00:00 199818.0
exp_2022_11_17_15 200 leopard 55 1668730508.4939127 2022-11-18T00:15:08.493913+00:00 199839.0
exp_2022_11_17_15 200 leopard 56 1668730508.4989126 2022-11-18T00:15:08.498913+00:00 199859.0
exp_2022_11_17_15 200 leopard 57 1668730508.5039127 2022-11-18T00:15:08.503913+00:00 199879.0
exp_2022_11_17_15 200 leopard 58 1668730508.5089126 2022-11-18T00:15:08.508913+00:00 199899.0
exp_2022_11_17_15 200 leopard 59 1668730508.5139127 2022-11-18T00:15:08.513913+00:00 199919.0
exp_2022_11_17_15 200 leopard 60 1668730508.5189126 2022-11-18T00:15:08.518913+00:00 199939.0
exp_2022_11_17_15 200 leopard 61 1668730508.5239127 2022-11-18T00:15:08.523913+00:00 199959.0
exp_2022_11_17_15 200 leopard 62 1668730508.5289125 2022-11-18T00:15:08.528913+00:00 199978.0
exp_2022_11_17_15 200 leopard 63 1668730508.5339127 2022-11-18T00:15:08.533913+00:00 199998.0
exp_2022_11_17_15 200 leopard 64 1668730508.5389125 2022-11-18T00:15:08.538913+00:00 200017.0
exp_2022_11_17_15 200 leopard 65 1668730508.5439126 2022-11-18T00:15:08.543913+00:00 200036.0
exp_2022_11_17_15 200 leopard 66 1668730508.5489125 2022-11-18T00:15:08.548913+00:00 200055.0
exp_2022_11_17_15 200 leopard 67 1668730508.5539126 2022-11-18T00:15:08.553913+00:00 200074.0
exp_2022_11_17_15 200 leopard 68 1668730508.5589125 2022-11-18T00:15:08.558913+00:00 200092.0
exp_2022_11_17_15 200 leopard 69 1668730508.5639126 2022-11-18T00:15:08.563913+00:00 200111.0
exp_2022_11_17_15 200 leopard 70 1668730508.5689125 2022-11-18T00:15:08.568913+00:00 200129.0
exp_2022_11_17_15 200 leopard 71 1668730508.5739126 2022-11-18T00:15:08.573913+00:00 200147.0
exp_2022_11_17_15 200 leopard 72 1668730508.5789125 2022-11-18T00:15:08.578912+00:00 200165.0
exp_2022_11_17_15 200 leopard 73 1668730508.5839126 2022-11-18T00:15:08.583913+00:00 200183.0
exp_2022_11_17_15 200 leopard 74 1668730508.5889125 2022-11-18T00:15:08.588912+00:00 200201.0
exp_2022_11_17_15 200 leopard 75 1668730508.5939126 2022-11-18T00:15:08.593913+00:00 200219.0
exp_2022_11_17_15 200 leopard 76 1668730508.5989127 2022-11-18T00:15:08.598913+00:00 200236.0
exp_2022_11_17_15 200 leopard 77 1668730508.6039126 2022-11-18T00:15:08.603913+00:00 200253.0
exp_2022_11_17_15 200 leopard 78 1668730508.6089127 2022-11-18T00:15:08.608913+00:00 200271.0
exp_2022_11_17_15 200 leopard 79 1668730508.6139126 2022-11-18T00:15:08.613913+00:00 200288.0
exp_2022_11_17_15 200 leopard 80 1668730508.6189127 2022-11-18T00:15:08.618913+00:00 200305.0
exp_2022_11_17_15 200 leopard 81 1668730508.6239126 2022-11-18T00:15:08.623913+00:00 200322.0
exp_2022_11_17_15 200 leopard 82 1668730508.6289127 2022-11-18T00:15:08.628913+00:00 200338.0
exp_2022_11_17_15 200 leopard 83 1668730508.6339126 2022-11-18T00:15:08.633913+00:00 200355.0
exp_2022_11_17_15 200 leopard 84 1668730508.6389127 2022-11-18T00:15:08.638913+00:00 200372.0
exp_2022_11_17_15 200 leopard 85 1668730508.6439126 2022-11-18T00:15:08.643913+00:00 200388.0
exp_2022_11_17_15 200 leopard 86 1668730508.6489127 2022-11-18T00:15:08.648913+00:00 200404.0
exp_2022_11_17_15 200 leopard 87 1668730508.6539125 2022-11-18T00:15:08.653913+00:00 200421.0
exp_2022_11_17_15 200 leopard 88 1668730508.6589127 2022-11-18T00:15:08.658913+00:00 200437.0
exp_2022_11_17_15 200 leopard 89 1668730508.6639125 2022-11-18T00:15:08.663913+00:00 200453.0
exp_2022_11_17_15 200 leopard 90 1668730508.6689126 2022-11-18T00:15:08.668913+00:00 200469.0
exp_2022_11_17_15 200 leopard 91 1668730508.6739125 2022-11-18T00:15:08.673913+00:00 200485.0
exp_2022_11_17_15 200 leopard 92 1668730508.6789126 2022-11-18T00:15:08.678913+00:00 200501.0
exp_2022_11_17_15 200 leopard 93 1668730508.6839125 2022-11-18T00:15:08.683913+00:00 200517.0
exp_2022_11_17_15 200 leopard 94 1668730508.6889126 2022-11-18T00:15:08.688913+00:00 200533.0
exp_2022_11_17_15 200 leopard 95 1668730508.6939125 2022-11-18T00:15:08.693913+00:00 200549.0
exp_2022_11_17_15 200 leopard 96 1668730508.6989126 2022-11-18T00:15:08.698913+00:00 200564.0
exp_2022_11_17_15 200 leopard 97 1668730508.7039125 2022-11-18T00:15:08.703912+00:00 200580.0
exp_2022_11_17_15 200 leopard 98 1668730508.7089126 2022-11-18T00:15:08.708913+00:00 200596.0
exp_2022_11_17_15 200 leopard 99 1668730508.7139125 2022-11-18T00:15:08.713912+00:00 200612.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]);