4 rows where has_watched = 1 sorted by profile_name

View and edit SQL

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

has_watched

id created_at updated_at deleted_at profile_name ▼ title_desc selection_type choice_segment_id has_watched source time
12 2021-01-22 20:46:21.568329+03:00 2021-01-22 20:46:21.568329+03:00   Seva Unbreakable Kimmy Schmidt: Kimmy vs. the Reverend userinput   1 iOS 2020-05-16 15:40:50+00:00
11 2021-01-22 20:46:21.568329+03:00 2021-01-22 20:46:21.568329+03:00   Seva Unbreakable Kimmy Schmidt: Kimmy vs. the Reverend userinput   1 iOS 2020-05-16 15:42:15+00:00
6 2021-01-22 20:46:21.568329+03:00 2021-01-22 20:46:21.568329+03:00   Seva Unbreakable Kimmy Schmidt: Kimmy vs. the Reverend userinput   1 iOS 2020-05-17 02:39:30+00:00
1 2021-01-22 20:46:21.568329+03:00 2021-01-22 20:46:21.568329+03:00   Seva Unbreakable Kimmy Schmidt: Kimmy vs. the Reverend userinput   1 iOS 2020-05-17 03:06:50+00:00

Advanced export

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

CSV options:

CREATE TABLE `netflix_interactive_titles` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`profile_name` text,`title_desc` text,`selection_type` text,`choice_segment_id` text,`has_watched` numeric,`source` text,`time` datetime,PRIMARY KEY (`id`));
CREATE UNIQUE INDEX `netflix_interactive_titles_key` ON `netflix_interactive_titles`(`profile_name`,`time`);
CREATE INDEX `idx_netflix_interactive_titles_deleted_at` ON `netflix_interactive_titles`(`deleted_at`);