netflix_playtraces
11 rows where playback_related_event_id = 1 sorted by playback_related_event_id
This data as json, CSV (advanced)
Suggested facets: event_type, 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 |
---|---|---|---|---|---|---|---|
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 | |
3 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 1 1 | playing | 3903 | 2000 | |
4 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 1 1 | playing | 12903 | 11000 | |
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 | |
7 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 1 1 | playing | 36775 | 29000 | |
8 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 1 1 | paused | 203251 | 196000 | |
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 | |
11 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 1 1 | paused | 204116 | 206000 |
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`);