179 rows

View and edit SQL

updated_at (date)

id ▼ created_at updated_at deleted_at playback_related_event_id event_type session_offset_ms media_offset_ms
101 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 142599 1170043
102 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 142600 1180000
103 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 142791 1180000
104 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 142792 1191000
105 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 142792 1180000
106 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 142792 1180000
107 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 142792 1191000
108 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 142893 1191000
109 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 142974 1191081
110 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 142975 1202000
111 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 143157 1202000
112 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 143158 1211000
113 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 143158 1202000
114 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 143158 1202000
115 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 143158 1211000
116 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 143359 1211000
117 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 143359 1211000
118 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 143359 1220000
119 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 143558 1220000
120 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 143558 1220000
121 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 143558 1228000
122 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 143772 1228000
123 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 143791 1228019
124 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 143792 1239000
125 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 144029 1239000
126 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 144151 1239122
127 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 144152 1250000
128 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 144392 1250000
129 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 144728 1250336
130 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 144729 1259000
131 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 144967 1259000
132 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 145533 1260000
133 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 145534 1269000
134 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 145756 1269000
135 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 145936 1269180
136 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 145937 1280000
137 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 146184 1280000
138 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   stopped 177401 1311000
139 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   start 0 1162000
140 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 8582 1162000
141 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   stopped 10359 1163000
142 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   start 0 792000
143 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1385 792000
144 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 5385 796000
145 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 9385 800000
146 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 25385 816000
147 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 371577 1162000
148 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   stopped 372124 1162000
149 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   start 0 707000
150 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1119 707000
151 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1119 707000
152 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 5119 711000
153 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 34119 740000
154 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 50119 756000
155 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 249119 955000
156 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 252010 957000
157 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1043592 957000
158 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1043592 957000
159 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1052592 966000
160 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   stopped 1079167 993000
161 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   start 0 491000
162 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 237 491000
163 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 8237 499000
164 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 26237 517000
165 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 36237 527000
166 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 216284 707000
167 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   stopped 722467 707000
168 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   start 0 1310000
169 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 1731 1310000
170 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 2133 1310402
171 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   repos 2658 0
172 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 4272 0
173 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 105544 101000
174 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 109508 101000
175 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   paused 500124 491000
176 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   start 0 0
177 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 2752 0
178 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   playing 4752 2000
179 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   stopped 22606 19000

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `netflix_playtraces` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`playback_related_event_id` integer,`event_type` text,`session_offset_ms` integer,`media_offset_ms` integer,PRIMARY KEY (`id`),CONSTRAINT `fk_netflix_playtraces_playback_related_event` FOREIGN KEY (`playback_related_event_id`) REFERENCES `netflix_playback_related_events`(`id`),CONSTRAINT `fk_netflix_playback_related_events_playtraces` FOREIGN KEY (`playback_related_event_id`) REFERENCES `netflix_playback_related_events`(`id`));
CREATE INDEX `idx_netflix_playtraces_deleted_at` ON `netflix_playtraces`(`deleted_at`);