netflix_playtraces
10 rows where playback_related_event_id = 6 sorted by media_offset_ms
This data as json, CSV (advanced)
Suggested facets: event_type, media_offset_ms, created_at (date), updated_at (date)
id | created_at | updated_at | deleted_at | playback_related_event_id | event_type | session_offset_ms | media_offset_ms ▼ |
---|---|---|---|---|---|---|---|
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 | |
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 | |
40 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 6 6 | playing | 11920 | 307000 | |
41 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 6 6 | playing | 22920 | 318000 | |
42 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 6 6 | playing | 30920 | 326000 | |
43 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 6 6 | playing | 45920 | 341000 | |
44 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 6 6 | paused | 956284 | 1251000 | |
45 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 6 6 | stopped | 1840457 | 1251000 |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);