3 rows where navigation_level = "postPlay" sorted by profile_name

View and edit SQL

Suggested facets: created_at (date), updated_at (date), click_time (date)

navigation_level

  • postPlay · 3
id created_at updated_at deleted_at profile_name ▼ source navigation_level referrer_url webpage_url click_time
11 2021-01-22 20:46:21.580303+03:00 2021-01-22 20:46:21.580303+03:00   Seva iOS postPlay     2020-12-30 18:32:56+00:00
4 2021-01-22 20:46:21.580303+03:00 2021-01-22 20:46:21.580303+03:00   Seva iOS postPlay     2020-12-30 20:14:14+00:00
2 2021-01-22 20:46:21.580303+03:00 2021-01-22 20:46:21.580303+03:00   Seva iOS postPlay     2020-12-30 20:14:16+00:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE `netflix_clickstream` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`profile_name` text,`source` text,`navigation_level` text,`referrer_url` text,`webpage_url` text,`click_time` datetime,PRIMARY KEY (`id`));
CREATE UNIQUE INDEX `netflix_clickstream_key` ON `netflix_clickstream`(`profile_name`,`source`,`navigation_level`,`click_time`);
CREATE INDEX `idx_netflix_clickstream_deleted_at` ON `netflix_clickstream`(`deleted_at`);