netflix_playtraces
179 rows where "created_at" is on date 2021-01-22
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 |
---|---|---|---|---|---|---|---|
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 | |
104 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 142792 | 1191000 | |
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 | |
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 | |
112 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | repos | 143158 | 1211000 | |
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 | |
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 | |
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 | |
138 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 9 9 | stopped | 177401 | 1311000 | |
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 | |
141 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 10 10 | stopped | 10359 | 1163000 | |
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 | |
144 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 11 11 | playing | 5385 | 796000 | |
145 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 11 11 | playing | 9385 | 800000 | |
146 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 11 11 | playing | 25385 | 816000 | |
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 | |
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 | |
152 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 12 12 | playing | 5119 | 711000 | |
153 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 12 12 | playing | 34119 | 740000 | |
154 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 12 12 | playing | 50119 | 756000 | |
155 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 12 12 | playing | 249119 | 955000 | |
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 | |
159 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 12 12 | playing | 1052592 | 966000 | |
160 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 12 12 | stopped | 1079167 | 993000 | |
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 | |
163 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 13 13 | playing | 8237 | 499000 | |
164 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 13 13 | playing | 26237 | 517000 | |
165 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 13 13 | playing | 36237 | 527000 | |
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 | |
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 | |
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 | |
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 | |
175 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 14 14 | paused | 500124 | 491000 | |
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 | |
178 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 15 15 | playing | 4752 | 2000 | |
179 | 2021-01-22 20:46:21.700632+03:00 | 2021-01-22 20:46:21.700632+03:00 | 15 15 | stopped | 22606 | 19000 |
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`);