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

View and edit SQL

Suggested facets: timestamp_iso8601 (date)

Link group_session frequency station id timestamp_unix timestamp_iso8601 gsr
exp_2023_04_18_14 200 leopard 0 1681855904.4847128 2023-04-18T22:11:44.484713+00:00 66846.4
exp_2023_04_18_14 200 leopard 1 1681855904.489713 2023-04-18T22:11:44.489713+00:00 66844.7
exp_2023_04_18_14 200 leopard 2 1681855904.4947128 2023-04-18T22:11:44.494713+00:00 66843.2
exp_2023_04_18_14 200 leopard 3 1681855904.499713 2023-04-18T22:11:44.499713+00:00 66841.6
exp_2023_04_18_14 200 leopard 4 1681855904.5047128 2023-04-18T22:11:44.504713+00:00 66839.9
exp_2023_04_18_14 200 leopard 5 1681855904.509713 2023-04-18T22:11:44.509713+00:00 66838.3
exp_2023_04_18_14 200 leopard 6 1681855904.5147128 2023-04-18T22:11:44.514713+00:00 66836.7
exp_2023_04_18_14 200 leopard 7 1681855904.519713 2023-04-18T22:11:44.519713+00:00 66835.1
exp_2023_04_18_14 200 leopard 8 1681855904.5247128 2023-04-18T22:11:44.524713+00:00 66833.5
exp_2023_04_18_14 200 leopard 9 1681855904.529713 2023-04-18T22:11:44.529713+00:00 66831.8
exp_2023_04_18_14 200 leopard 10 1681855904.5347128 2023-04-18T22:11:44.534713+00:00 66830.2
exp_2023_04_18_14 200 leopard 11 1681855904.539713 2023-04-18T22:11:44.539713+00:00 66828.6
exp_2023_04_18_14 200 leopard 12 1681855904.5447128 2023-04-18T22:11:44.544713+00:00 66827.0
exp_2023_04_18_14 200 leopard 13 1681855904.549713 2023-04-18T22:11:44.549713+00:00 66825.3
exp_2023_04_18_14 200 leopard 14 1681855904.5547128 2023-04-18T22:11:44.554713+00:00 66823.7
exp_2023_04_18_14 200 leopard 15 1681855904.559713 2023-04-18T22:11:44.559713+00:00 66822.1
exp_2023_04_18_14 200 leopard 16 1681855904.5647128 2023-04-18T22:11:44.564713+00:00 66820.4
exp_2023_04_18_14 200 leopard 17 1681855904.5697129 2023-04-18T22:11:44.569713+00:00 66818.6
exp_2023_04_18_14 200 leopard 18 1681855904.5747128 2023-04-18T22:11:44.574713+00:00 66817.0
exp_2023_04_18_14 200 leopard 19 1681855904.5797129 2023-04-18T22:11:44.579713+00:00 66815.4
exp_2023_04_18_14 200 leopard 20 1681855904.5847127 2023-04-18T22:11:44.584713+00:00 66813.6
exp_2023_04_18_14 200 leopard 21 1681855904.5897129 2023-04-18T22:11:44.589713+00:00 66811.9
exp_2023_04_18_14 200 leopard 22 1681855904.5947127 2023-04-18T22:11:44.594713+00:00 66810.2
exp_2023_04_18_14 200 leopard 23 1681855904.5997128 2023-04-18T22:11:44.599713+00:00 66808.6
exp_2023_04_18_14 200 leopard 24 1681855904.6047127 2023-04-18T22:11:44.604713+00:00 66806.8
exp_2023_04_18_14 200 leopard 25 1681855904.6097128 2023-04-18T22:11:44.609713+00:00 66805.0
exp_2023_04_18_14 200 leopard 26 1681855904.614713 2023-04-18T22:11:44.614713+00:00 66803.3
exp_2023_04_18_14 200 leopard 27 1681855904.6197128 2023-04-18T22:11:44.619713+00:00 66801.6
exp_2023_04_18_14 200 leopard 28 1681855904.624713 2023-04-18T22:11:44.624713+00:00 66799.8
exp_2023_04_18_14 200 leopard 29 1681855904.6297128 2023-04-18T22:11:44.629713+00:00 66798.0
exp_2023_04_18_14 200 leopard 30 1681855904.634713 2023-04-18T22:11:44.634713+00:00 66796.3
exp_2023_04_18_14 200 leopard 31 1681855904.6397128 2023-04-18T22:11:44.639713+00:00 66794.6
exp_2023_04_18_14 200 leopard 32 1681855904.644713 2023-04-18T22:11:44.644713+00:00 66792.8
exp_2023_04_18_14 200 leopard 33 1681855904.6497128 2023-04-18T22:11:44.649713+00:00 66791.0
exp_2023_04_18_14 200 leopard 34 1681855904.654713 2023-04-18T22:11:44.654713+00:00 66789.3
exp_2023_04_18_14 200 leopard 35 1681855904.6597128 2023-04-18T22:11:44.659713+00:00 66787.6
exp_2023_04_18_14 200 leopard 36 1681855904.664713 2023-04-18T22:11:44.664713+00:00 66785.8
exp_2023_04_18_14 200 leopard 37 1681855904.6697128 2023-04-18T22:11:44.669713+00:00 66784.0
exp_2023_04_18_14 200 leopard 38 1681855904.674713 2023-04-18T22:11:44.674713+00:00 66782.4
exp_2023_04_18_14 200 leopard 39 1681855904.6797128 2023-04-18T22:11:44.679713+00:00 66780.7
exp_2023_04_18_14 200 leopard 40 1681855904.684713 2023-04-18T22:11:44.684713+00:00 66778.9
exp_2023_04_18_14 200 leopard 41 1681855904.6897128 2023-04-18T22:11:44.689713+00:00 66777.1
exp_2023_04_18_14 200 leopard 42 1681855904.6947129 2023-04-18T22:11:44.694713+00:00 66775.5
exp_2023_04_18_14 200 leopard 43 1681855904.6997128 2023-04-18T22:11:44.699713+00:00 66773.8
exp_2023_04_18_14 200 leopard 44 1681855904.7047129 2023-04-18T22:11:44.704713+00:00 66772.1
exp_2023_04_18_14 200 leopard 45 1681855904.7097127 2023-04-18T22:11:44.709713+00:00 66770.4
exp_2023_04_18_14 200 leopard 46 1681855904.7147129 2023-04-18T22:11:44.714713+00:00 66768.8
exp_2023_04_18_14 200 leopard 47 1681855904.7197127 2023-04-18T22:11:44.719713+00:00 66767.2
exp_2023_04_18_14 200 leopard 48 1681855904.7247128 2023-04-18T22:11:44.724713+00:00 66765.5
exp_2023_04_18_14 200 leopard 49 1681855904.7297127 2023-04-18T22:11:44.729713+00:00 66763.9
exp_2023_04_18_14 200 leopard 50 1681855904.7347128 2023-04-18T22:11:44.734713+00:00 66762.3
exp_2023_04_18_14 200 leopard 51 1681855904.739713 2023-04-18T22:11:44.739713+00:00 66760.8
exp_2023_04_18_14 200 leopard 52 1681855904.7447128 2023-04-18T22:11:44.744713+00:00 66759.1
exp_2023_04_18_14 200 leopard 53 1681855904.749713 2023-04-18T22:11:44.749713+00:00 66757.5
exp_2023_04_18_14 200 leopard 54 1681855904.7547128 2023-04-18T22:11:44.754713+00:00 66756.0
exp_2023_04_18_14 200 leopard 55 1681855904.759713 2023-04-18T22:11:44.759713+00:00 66754.5
exp_2023_04_18_14 200 leopard 56 1681855904.7647128 2023-04-18T22:11:44.764713+00:00 66753.0
exp_2023_04_18_14 200 leopard 57 1681855904.769713 2023-04-18T22:11:44.769713+00:00 66751.4
exp_2023_04_18_14 200 leopard 58 1681855904.7747128 2023-04-18T22:11:44.774713+00:00 66749.9
exp_2023_04_18_14 200 leopard 59 1681855904.779713 2023-04-18T22:11:44.779713+00:00 66748.5
exp_2023_04_18_14 200 leopard 60 1681855904.7847128 2023-04-18T22:11:44.784713+00:00 66746.9
exp_2023_04_18_14 200 leopard 61 1681855904.789713 2023-04-18T22:11:44.789713+00:00 66745.4
exp_2023_04_18_14 200 leopard 62 1681855904.7947128 2023-04-18T22:11:44.794713+00:00 66743.9
exp_2023_04_18_14 200 leopard 63 1681855904.799713 2023-04-18T22:11:44.799713+00:00 66742.5
exp_2023_04_18_14 200 leopard 64 1681855904.8047128 2023-04-18T22:11:44.804713+00:00 66740.9
exp_2023_04_18_14 200 leopard 65 1681855904.809713 2023-04-18T22:11:44.809713+00:00 66739.4
exp_2023_04_18_14 200 leopard 66 1681855904.8147128 2023-04-18T22:11:44.814713+00:00 66738.0
exp_2023_04_18_14 200 leopard 67 1681855904.8197129 2023-04-18T22:11:44.819713+00:00 66736.5
exp_2023_04_18_14 200 leopard 68 1681855904.8247128 2023-04-18T22:11:44.824713+00:00 66735.0
exp_2023_04_18_14 200 leopard 69 1681855904.8297129 2023-04-18T22:11:44.829713+00:00 66733.4
exp_2023_04_18_14 200 leopard 70 1681855904.8347127 2023-04-18T22:11:44.834713+00:00 66732.0
exp_2023_04_18_14 200 leopard 71 1681855904.8397129 2023-04-18T22:11:44.839713+00:00 66730.5
exp_2023_04_18_14 200 leopard 72 1681855904.8447127 2023-04-18T22:11:44.844713+00:00 66728.9
exp_2023_04_18_14 200 leopard 73 1681855904.8497128 2023-04-18T22:11:44.849713+00:00 66727.4
exp_2023_04_18_14 200 leopard 74 1681855904.8547127 2023-04-18T22:11:44.854713+00:00 66725.9
exp_2023_04_18_14 200 leopard 75 1681855904.8597128 2023-04-18T22:11:44.859713+00:00 66724.4
exp_2023_04_18_14 200 leopard 76 1681855904.864713 2023-04-18T22:11:44.864713+00:00 66722.8
exp_2023_04_18_14 200 leopard 77 1681855904.8697128 2023-04-18T22:11:44.869713+00:00 66721.1
exp_2023_04_18_14 200 leopard 78 1681855904.874713 2023-04-18T22:11:44.874713+00:00 66719.6
exp_2023_04_18_14 200 leopard 79 1681855904.8797128 2023-04-18T22:11:44.879713+00:00 66718.1
exp_2023_04_18_14 200 leopard 80 1681855904.884713 2023-04-18T22:11:44.884713+00:00 66716.4
exp_2023_04_18_14 200 leopard 81 1681855904.8897128 2023-04-18T22:11:44.889713+00:00 66714.8
exp_2023_04_18_14 200 leopard 82 1681855904.894713 2023-04-18T22:11:44.894713+00:00 66713.2
exp_2023_04_18_14 200 leopard 83 1681855904.8997128 2023-04-18T22:11:44.899713+00:00 66711.6
exp_2023_04_18_14 200 leopard 84 1681855904.904713 2023-04-18T22:11:44.904713+00:00 66709.9
exp_2023_04_18_14 200 leopard 85 1681855904.9097128 2023-04-18T22:11:44.909713+00:00 66708.2
exp_2023_04_18_14 200 leopard 86 1681855904.914713 2023-04-18T22:11:44.914713+00:00 66706.6
exp_2023_04_18_14 200 leopard 87 1681855904.9197128 2023-04-18T22:11:44.919713+00:00 66705.0
exp_2023_04_18_14 200 leopard 88 1681855904.924713 2023-04-18T22:11:44.924713+00:00 66703.2
exp_2023_04_18_14 200 leopard 89 1681855904.9297128 2023-04-18T22:11:44.929713+00:00 66701.5
exp_2023_04_18_14 200 leopard 90 1681855904.934713 2023-04-18T22:11:44.934713+00:00 66699.9
exp_2023_04_18_14 200 leopard 91 1681855904.9397128 2023-04-18T22:11:44.939713+00:00 66698.2
exp_2023_04_18_14 200 leopard 92 1681855904.9447129 2023-04-18T22:11:44.944713+00:00 66696.5
exp_2023_04_18_14 200 leopard 93 1681855904.9497128 2023-04-18T22:11:44.949713+00:00 66694.8
exp_2023_04_18_14 200 leopard 94 1681855904.9547129 2023-04-18T22:11:44.954713+00:00 66693.1
exp_2023_04_18_14 200 leopard 95 1681855904.9597127 2023-04-18T22:11:44.959713+00:00 66691.5
exp_2023_04_18_14 200 leopard 96 1681855904.9647129 2023-04-18T22:11:44.964713+00:00 66689.8
exp_2023_04_18_14 200 leopard 97 1681855904.9697127 2023-04-18T22:11:44.969713+00:00 66688.0
exp_2023_04_18_14 200 leopard 98 1681855904.9747128 2023-04-18T22:11:44.974713+00:00 66686.4
exp_2023_04_18_14 200 leopard 99 1681855904.9797127 2023-04-18T22:11:44.979713+00:00 66684.8

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]);