3 rows where "time" is on date 2020-10-18 and "updated_at" is on date 2021-01-22 sorted by action descending

View and edit SQL

Suggested facets: displayed_name, action, time (date)

updated_at (date)

  • 2021-01-22 · 3

created_at (date)

id created_at updated_at deleted_at profile_name country_iso_code device is_kids query_typed displayed_name action ▲ section time
3 2021-01-22 20:46:21.571014+03:00 2021-01-22 20:46:21.571014+03:00   Seva RU iPhone 0 epidemic To the Lake view_video_info title_results 2020-10-18 07:04:33+00:00
4 2021-01-22 20:46:21.571014+03:00 2021-01-22 20:46:21.571014+03:00   Seva RU iPhone 0 epidemic Pandemic: How to Prevent an Outbreak view_video_info title_results 2020-10-18 07:00:56+00:00
2 2021-01-22 20:46:21.571014+03:00 2021-01-22 20:46:21.571014+03:00   Seva RU iPhone 0 epidemic To the Lake play video_info 2020-10-18 07:04:35+00:00

Advanced export

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

CSV options:

CREATE TABLE `netflix_search_history` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`profile_name` text,`country_iso_code` text,`device` text,`is_kids` numeric,`query_typed` text,`displayed_name` text,`action` text,`section` text,`time` datetime,PRIMARY KEY (`id`));
CREATE UNIQUE INDEX `netflix_search_history_key` ON `netflix_search_history`(`profile_name`,`device`,`time`);
CREATE INDEX `idx_netflix_search_history_deleted_at` ON `netflix_search_history`(`deleted_at`);