6 rows where "time" is on date 2020-05-16 sorted by profile_name

View and edit SQL

Suggested facets: has_watched, source, created_at (date)

updated_at (date)

time (date)

  • 2020-05-16 · 6
id created_at updated_at deleted_at profile_name ▼ title_desc selection_type choice_segment_id has_watched source time
14 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   0 www 2020-05-16 01:37:51+00:00
13 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   0 www 2020-05-16 01:42:10+00:00
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
10 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   0 iOS 2020-05-16 15:44:03+00:00
9 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   0 iOS 2020-05-16 15:46:08+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`);