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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2022_11_10_10 200 leopard 0 1668104414.0689833 2022-11-10T18:20:14.068983+00:00 335844.0
exp_2022_11_10_10 200 leopard 1 1668104414.0739834 2022-11-10T18:20:14.073983+00:00 335840.0
exp_2022_11_10_10 200 leopard 2 1668104414.0789833 2022-11-10T18:20:14.078983+00:00 335837.0
exp_2022_11_10_10 200 leopard 3 1668104414.0839834 2022-11-10T18:20:14.083983+00:00 335833.0
exp_2022_11_10_10 200 leopard 4 1668104414.0889833 2022-11-10T18:20:14.088983+00:00 335830.0
exp_2022_11_10_10 200 leopard 5 1668104414.0939834 2022-11-10T18:20:14.093983+00:00 335827.0
exp_2022_11_10_10 200 leopard 6 1668104414.0989833 2022-11-10T18:20:14.098983+00:00 335823.0
exp_2022_11_10_10 200 leopard 7 1668104414.1039834 2022-11-10T18:20:14.103983+00:00 335820.0
exp_2022_11_10_10 200 leopard 8 1668104414.1089833 2022-11-10T18:20:14.108983+00:00 335817.0
exp_2022_11_10_10 200 leopard 9 1668104414.1139834 2022-11-10T18:20:14.113983+00:00 335813.0
exp_2022_11_10_10 200 leopard 10 1668104414.1189833 2022-11-10T18:20:14.118983+00:00 335809.0
exp_2022_11_10_10 200 leopard 11 1668104414.1239834 2022-11-10T18:20:14.123983+00:00 335806.0
exp_2022_11_10_10 200 leopard 12 1668104414.1289833 2022-11-10T18:20:14.128983+00:00 335803.0
exp_2022_11_10_10 200 leopard 13 1668104414.1339834 2022-11-10T18:20:14.133983+00:00 335799.0
exp_2022_11_10_10 200 leopard 14 1668104414.1389832 2022-11-10T18:20:14.138983+00:00 335795.0
exp_2022_11_10_10 200 leopard 15 1668104414.1439834 2022-11-10T18:20:14.143983+00:00 335792.0
exp_2022_11_10_10 200 leopard 16 1668104414.1489832 2022-11-10T18:20:14.148983+00:00 335789.0
exp_2022_11_10_10 200 leopard 17 1668104414.1539834 2022-11-10T18:20:14.153983+00:00 335785.0
exp_2022_11_10_10 200 leopard 18 1668104414.1589832 2022-11-10T18:20:14.158983+00:00 335781.0
exp_2022_11_10_10 200 leopard 19 1668104414.1639833 2022-11-10T18:20:14.163983+00:00 335778.0
exp_2022_11_10_10 200 leopard 20 1668104414.1689832 2022-11-10T18:20:14.168983+00:00 335774.0
exp_2022_11_10_10 200 leopard 21 1668104414.1739833 2022-11-10T18:20:14.173983+00:00 335770.0
exp_2022_11_10_10 200 leopard 22 1668104414.1789832 2022-11-10T18:20:14.178983+00:00 335767.0
exp_2022_11_10_10 200 leopard 23 1668104414.1839833 2022-11-10T18:20:14.183983+00:00 335763.0
exp_2022_11_10_10 200 leopard 24 1668104414.1889832 2022-11-10T18:20:14.188983+00:00 335760.0
exp_2022_11_10_10 200 leopard 25 1668104414.1939833 2022-11-10T18:20:14.193983+00:00 335756.0
exp_2022_11_10_10 200 leopard 26 1668104414.1989834 2022-11-10T18:20:14.198983+00:00 335752.0
exp_2022_11_10_10 200 leopard 27 1668104414.2039833 2022-11-10T18:20:14.203983+00:00 335749.0
exp_2022_11_10_10 200 leopard 28 1668104414.2089834 2022-11-10T18:20:14.208983+00:00 335745.0
exp_2022_11_10_10 200 leopard 29 1668104414.2139833 2022-11-10T18:20:14.213983+00:00 335741.0
exp_2022_11_10_10 200 leopard 30 1668104414.2189834 2022-11-10T18:20:14.218983+00:00 335737.0
exp_2022_11_10_10 200 leopard 31 1668104414.2239833 2022-11-10T18:20:14.223983+00:00 335734.0
exp_2022_11_10_10 200 leopard 32 1668104414.2289834 2022-11-10T18:20:14.228983+00:00 335730.0
exp_2022_11_10_10 200 leopard 33 1668104414.2339833 2022-11-10T18:20:14.233983+00:00 335726.0
exp_2022_11_10_10 200 leopard 34 1668104414.2389834 2022-11-10T18:20:14.238983+00:00 335722.0
exp_2022_11_10_10 200 leopard 35 1668104414.2439833 2022-11-10T18:20:14.243983+00:00 335719.0
exp_2022_11_10_10 200 leopard 36 1668104414.2489834 2022-11-10T18:20:14.248983+00:00 335715.0
exp_2022_11_10_10 200 leopard 37 1668104414.2539833 2022-11-10T18:20:14.253983+00:00 335711.0
exp_2022_11_10_10 200 leopard 38 1668104414.2589834 2022-11-10T18:20:14.258983+00:00 335707.0
exp_2022_11_10_10 200 leopard 39 1668104414.2639832 2022-11-10T18:20:14.263983+00:00 335704.0
exp_2022_11_10_10 200 leopard 40 1668104414.2689834 2022-11-10T18:20:14.268983+00:00 335700.0
exp_2022_11_10_10 200 leopard 41 1668104414.2739832 2022-11-10T18:20:14.273983+00:00 335696.0
exp_2022_11_10_10 200 leopard 42 1668104414.2789834 2022-11-10T18:20:14.278983+00:00 335692.0
exp_2022_11_10_10 200 leopard 43 1668104414.2839832 2022-11-10T18:20:14.283983+00:00 335689.0
exp_2022_11_10_10 200 leopard 44 1668104414.2889833 2022-11-10T18:20:14.288983+00:00 335685.0
exp_2022_11_10_10 200 leopard 45 1668104414.2939832 2022-11-10T18:20:14.293983+00:00 335682.0
exp_2022_11_10_10 200 leopard 46 1668104414.2989833 2022-11-10T18:20:14.298983+00:00 335678.0
exp_2022_11_10_10 200 leopard 47 1668104414.3039832 2022-11-10T18:20:14.303983+00:00 335674.0
exp_2022_11_10_10 200 leopard 48 1668104414.3089833 2022-11-10T18:20:14.308983+00:00 335671.0
exp_2022_11_10_10 200 leopard 49 1668104414.3139832 2022-11-10T18:20:14.313983+00:00 335667.0
exp_2022_11_10_10 200 leopard 50 1668104414.3189833 2022-11-10T18:20:14.318983+00:00 335664.0
exp_2022_11_10_10 200 leopard 51 1668104414.3239834 2022-11-10T18:20:14.323983+00:00 335660.0
exp_2022_11_10_10 200 leopard 52 1668104414.3289833 2022-11-10T18:20:14.328983+00:00 335657.0
exp_2022_11_10_10 200 leopard 53 1668104414.3339834 2022-11-10T18:20:14.333983+00:00 335654.0
exp_2022_11_10_10 200 leopard 54 1668104414.3389833 2022-11-10T18:20:14.338983+00:00 335650.0
exp_2022_11_10_10 200 leopard 55 1668104414.3439834 2022-11-10T18:20:14.343983+00:00 335647.0
exp_2022_11_10_10 200 leopard 56 1668104414.3489833 2022-11-10T18:20:14.348983+00:00 335644.0
exp_2022_11_10_10 200 leopard 57 1668104414.3539834 2022-11-10T18:20:14.353983+00:00 335640.0
exp_2022_11_10_10 200 leopard 58 1668104414.3589833 2022-11-10T18:20:14.358983+00:00 335637.0
exp_2022_11_10_10 200 leopard 59 1668104414.3639834 2022-11-10T18:20:14.363983+00:00 335634.0
exp_2022_11_10_10 200 leopard 60 1668104414.3689833 2022-11-10T18:20:14.368983+00:00 335631.0
exp_2022_11_10_10 200 leopard 61 1668104414.3739834 2022-11-10T18:20:14.373983+00:00 335628.0
exp_2022_11_10_10 200 leopard 62 1668104414.3789833 2022-11-10T18:20:14.378983+00:00 335625.0
exp_2022_11_10_10 200 leopard 63 1668104414.3839834 2022-11-10T18:20:14.383983+00:00 335622.0
exp_2022_11_10_10 200 leopard 64 1668104414.3889832 2022-11-10T18:20:14.388983+00:00 335619.0
exp_2022_11_10_10 200 leopard 65 1668104414.3939834 2022-11-10T18:20:14.393983+00:00 335616.0
exp_2022_11_10_10 200 leopard 66 1668104414.3989832 2022-11-10T18:20:14.398983+00:00 335613.0
exp_2022_11_10_10 200 leopard 67 1668104414.4039834 2022-11-10T18:20:14.403983+00:00 335610.0
exp_2022_11_10_10 200 leopard 68 1668104414.4089832 2022-11-10T18:20:14.408983+00:00 335607.0
exp_2022_11_10_10 200 leopard 69 1668104414.4139833 2022-11-10T18:20:14.413983+00:00 335604.0
exp_2022_11_10_10 200 leopard 70 1668104414.4189832 2022-11-10T18:20:14.418983+00:00 335601.0
exp_2022_11_10_10 200 leopard 71 1668104414.4239833 2022-11-10T18:20:14.423983+00:00 335598.0
exp_2022_11_10_10 200 leopard 72 1668104414.4289832 2022-11-10T18:20:14.428983+00:00 335595.0
exp_2022_11_10_10 200 leopard 73 1668104414.4339833 2022-11-10T18:20:14.433983+00:00 335592.0
exp_2022_11_10_10 200 leopard 74 1668104414.4389832 2022-11-10T18:20:14.438983+00:00 335589.0
exp_2022_11_10_10 200 leopard 75 1668104414.4439833 2022-11-10T18:20:14.443983+00:00 335586.0
exp_2022_11_10_10 200 leopard 76 1668104414.4489834 2022-11-10T18:20:14.448983+00:00 335583.0
exp_2022_11_10_10 200 leopard 77 1668104414.4539833 2022-11-10T18:20:14.453983+00:00 335580.0
exp_2022_11_10_10 200 leopard 78 1668104414.4589834 2022-11-10T18:20:14.458983+00:00 335576.0
exp_2022_11_10_10 200 leopard 79 1668104414.4639833 2022-11-10T18:20:14.463983+00:00 335573.0
exp_2022_11_10_10 200 leopard 80 1668104414.4689834 2022-11-10T18:20:14.468983+00:00 335570.0
exp_2022_11_10_10 200 leopard 81 1668104414.4739833 2022-11-10T18:20:14.473983+00:00 335566.0
exp_2022_11_10_10 200 leopard 82 1668104414.4789834 2022-11-10T18:20:14.478983+00:00 335563.0
exp_2022_11_10_10 200 leopard 83 1668104414.4839833 2022-11-10T18:20:14.483983+00:00 335559.0
exp_2022_11_10_10 200 leopard 84 1668104414.4889834 2022-11-10T18:20:14.488983+00:00 335556.0
exp_2022_11_10_10 200 leopard 85 1668104414.4939833 2022-11-10T18:20:14.493983+00:00 335552.0
exp_2022_11_10_10 200 leopard 86 1668104414.4989834 2022-11-10T18:20:14.498983+00:00 335548.0
exp_2022_11_10_10 200 leopard 87 1668104414.5039833 2022-11-10T18:20:14.503983+00:00 335544.0
exp_2022_11_10_10 200 leopard 88 1668104414.5089834 2022-11-10T18:20:14.508983+00:00 335540.0
exp_2022_11_10_10 200 leopard 89 1668104414.5139832 2022-11-10T18:20:14.513983+00:00 335536.0
exp_2022_11_10_10 200 leopard 90 1668104414.5189834 2022-11-10T18:20:14.518983+00:00 335532.0
exp_2022_11_10_10 200 leopard 91 1668104414.5239832 2022-11-10T18:20:14.523983+00:00 335528.0
exp_2022_11_10_10 200 leopard 92 1668104414.5289834 2022-11-10T18:20:14.528983+00:00 335523.0
exp_2022_11_10_10 200 leopard 93 1668104414.5339832 2022-11-10T18:20:14.533983+00:00 335519.0
exp_2022_11_10_10 200 leopard 94 1668104414.5389833 2022-11-10T18:20:14.538983+00:00 335514.0
exp_2022_11_10_10 200 leopard 95 1668104414.5439832 2022-11-10T18:20:14.543983+00:00 335510.0
exp_2022_11_10_10 200 leopard 96 1668104414.5489833 2022-11-10T18:20:14.548983+00:00 335505.0
exp_2022_11_10_10 200 leopard 97 1668104414.5539832 2022-11-10T18:20:14.553983+00:00 335500.0
exp_2022_11_10_10 200 leopard 98 1668104414.5589833 2022-11-10T18:20:14.558983+00:00 335495.0
exp_2022_11_10_10 200 leopard 99 1668104414.5639832 2022-11-10T18:20:14.563983+00:00 335491.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]);