netflix_playtraces
11 rows where "created_at" is on date 2021-01-22 and playback_related_event_id = 8
This data as json, CSV (advanced)
Suggested facets: event_type, media_offset_ms, updated_at (date)
id ▼ | created_at | updated_at | deleted_at | playback_related_event_id | event_type | session_offset_ms | media_offset_ms |
---|---|---|---|---|---|---|---|
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 | |
51 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 8 8 | paused | 4506 | 2000 | |
52 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 8 8 | repos | 4507 | 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 | |
54 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 8 8 | playing | 13528 | 14000 | |
55 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 8 8 | paused | 136563 | 138000 | |
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 | |
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 |
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`);