netflix_playtraces

179 rows sorted by media_offset_ms descending

✎ View and edit SQL

This data as json, CSV (advanced)

id created_at updated_at deleted_at playback_related_event_id event_type session_offset_ms media_offset_ms ▲
15 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   2 2 playing 25825 978000
14 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   2 2 playing 16825 969000
159 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 1052592 966000
12 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   2 2 start 0 958000
13 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   2 2 playing 5825 958000
26 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 paused 961560 958000
27 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 stopped 963177 958000
156 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 paused 252010 957000
157 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 1043592 957000
158 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 1043592 957000
155 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 249119 955000
146 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   11 11 playing 25385 816000
145 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   11 11 playing 9385 800000
144 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   11 11 playing 5385 796000
142 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   11 11 start 0 792000
143 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   11 11 playing 1385 792000
154 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 50119 756000
153 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 34119 740000
152 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 5119 711000
149 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 start 0 707000
150 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 1119 707000
151 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   12 12 playing 1119 707000
166 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 paused 216284 707000
167 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 stopped 722467 707000
165 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 playing 36237 527000
164 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 playing 26237 517000
163 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 playing 8237 499000
161 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 start 0 491000
162 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   13 13 playing 237 491000
175 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   14 14 paused 500124 491000
43 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 45920 341000
42 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 30920 326000
41 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 22920 318000
40 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 11920 307000
38 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 9920 305000
39 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 9920 305000
36 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 start 0 302000
37 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   6 6 playing 217 302000
46 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   7 7 start 0 292000
47 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   7 7 playing 304 292000
58 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 paused 281274 292000
59 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 stopped 281788 292000
24 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 paused 238482 248000
25 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 playing 251887 248000
11 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 paused 204116 206000
9 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 repos 203252 205000
10 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 playing 203474 205000
8 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 paused 203251 196000
56 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 repos 136564 147000
57 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 playing 136833 147000
55 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 paused 136563 138000
173 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   14 14 paused 105544 101000
174 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   14 14 playing 109508 101000
23 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 playing 51562 62000
7 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 playing 36775 29000
179 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   15 15 stopped 22606 19000
21 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 repos 3336 14000
22 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 playing 3562 14000
52 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 repos 4507 14000
54 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 playing 13528 14000
53 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 playing 12528 13000
5 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 paused 19325 12000
6 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 playing 19775 12000
4 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 playing 12903 11000
48 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   7 7 stopped 15245 10000
3 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 playing 3903 2000
20 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 paused 3335 2000
51 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 paused 4506 2000
178 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   15 15 playing 4752 2000
1 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 start 0 0
2 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   1 1 playing 1903 0
18 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 start 0 0
19 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   3 3 playing 1236 0
49 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 start 0 0
50 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   8 8 playing 2238 0
171 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   14 14 repos 2658 0
172 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   14 14 playing 4272 0
176 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   15 15 start 0 0
177 2021-01-22 20:46:21.700632+03:00 2021-01-22 20:46:21.700632+03:00   15 15 playing 2752 0

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