netflix_playtraces
179 rows sorted by media_offset_ms
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 ▼ |
|---|---|---|---|---|---|---|---|
| 79 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 114553 | 1086000 | |
| 80 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 114782 | 1086000 | |
| 81 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 115114 | 1086332 | |
| 82 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 115115 | 1094000 | |
| 83 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 115337 | 1094000 | |
| 84 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 115547 | 1094210 | |
| 85 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 115548 | 1105000 | |
| 86 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 115785 | 1105000 | |
| 87 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 141336 | 1130000 | |
| 88 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 141337 | 1139000 | |
| 89 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 141577 | 1139000 | |
| 90 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 141803 | 1140000 | |
| 91 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 141804 | 1149000 | |
| 92 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 142044 | 1149000 | |
| 93 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142149 | 1149105 | |
| 94 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142150 | 1159000 | |
| 95 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142332 | 1159000 | |
| 97 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 142333 | 1159000 | |
| 98 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142333 | 1159000 | |
| 139 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 10 10 | start | 0 | 1162000 | |
| 140 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 10 10 | playing | 8582 | 1162000 | |
| 147 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 11 11 | paused | 371577 | 1162000 | |
| 148 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 11 11 | stopped | 372124 | 1162000 | |
| 141 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 10 10 | stopped | 10359 | 1163000 | |
| 96 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142333 | 1170000 | |
| 99 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142333 | 1170000 | |
| 100 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 142556 | 1170000 | |
| 101 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142599 | 1170043 | |
| 102 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142600 | 1180000 | |
| 103 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142791 | 1180000 | |
| 105 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 142792 | 1180000 | |
| 106 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142792 | 1180000 | |
| 104 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142792 | 1191000 | |
| 107 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142792 | 1191000 | |
| 108 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 142893 | 1191000 | |
| 109 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 142974 | 1191081 | |
| 110 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142975 | 1202000 | |
| 111 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 143157 | 1202000 | |
| 113 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 143158 | 1202000 | |
| 114 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 143158 | 1202000 | |
| 112 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 143158 | 1211000 | |
| 115 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 143158 | 1211000 | |
| 116 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 143359 | 1211000 | |
| 117 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 143359 | 1211000 | |
| 118 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 143359 | 1220000 | |
| 119 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 143558 | 1220000 | |
| 120 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 143558 | 1220000 | |
| 121 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 143558 | 1228000 | |
| 122 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 143772 | 1228000 | |
| 123 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 143791 | 1228019 | |
| 124 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 143792 | 1239000 | |
| 125 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 144029 | 1239000 | |
| 126 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 144151 | 1239122 | |
| 127 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 144152 | 1250000 | |
| 128 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 144392 | 1250000 | |
| 129 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 144728 | 1250336 | |
| 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 | |
| 130 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 144729 | 1259000 | |
| 131 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 144967 | 1259000 | |
| 132 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 145533 | 1260000 | |
| 133 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 145534 | 1269000 | |
| 134 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 145756 | 1269000 | |
| 135 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | paused | 145936 | 1269180 | |
| 136 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 145937 | 1280000 | |
| 137 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | playing | 146184 | 1280000 | |
| 32 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 5 5 | start | 0 | 1300000 | |
| 33 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 5 5 | playing | 211 | 1300000 | |
| 34 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 5 5 | playing | 211 | 1300000 | |
| 17 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 2 2 | stopped | 350006 | 1302000 | |
| 35 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 5 5 | stopped | 3336 | 1303000 | |
| 28 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 4 4 | start | 0 | 1304000 | |
| 29 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 4 4 | playing | 2512 | 1304000 | |
| 30 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 4 4 | playing | 2512 | 1304000 | |
| 31 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 4 4 | stopped | 11731 | 1308000 | |
| 168 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 14 14 | start | 0 | 1310000 | |
| 169 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 14 14 | playing | 1731 | 1310000 | |
| 170 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 14 14 | paused | 2133 | 1310402 | |
| 138 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | stopped | 177401 | 1311000 |
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`);