4 rows where "event_time" is on date 2017-04-07 sorted by device_model

View and edit SQL

Suggested facets: updated_at (date)

thumbs_value

  • 2 4

event_time (date)

  • 2017-04-07 · 4

created_at (date)

id created_at updated_at deleted_at profile_name title_name rating_type star_value thumbs_value device_model ▼ event_time region_view_date
5 2021-01-22 20:46:21.569481+03:00 2021-01-22 20:46:21.569481+03:00   Seva Sherlock thumb 0 2 HTML 5 2017-04-07 05:13:11+00:00  
6 2021-01-22 20:46:21.569481+03:00 2021-01-22 20:46:21.569481+03:00   Seva Brooklyn Nine-Nine thumb 0 2 HTML 5 2017-04-07 05:13:08+00:00  
7 2021-01-22 20:46:21.569481+03:00 2021-01-22 20:46:21.569481+03:00   Seva House, M.D. thumb 0 2 HTML 5 2017-04-07 05:13:05+00:00  
8 2021-01-22 20:46:21.569481+03:00 2021-01-22 20:46:21.569481+03:00   Seva House of Cards thumb 0 2 HTML 5 2017-04-07 05:13:03+00:00  

Advanced export

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

CSV options:

CREATE TABLE `netflix_ratings` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`profile_name` text,`title_name` text,`rating_type` text,`star_value` integer,`thumbs_value` integer,`device_model` text,`event_time` datetime,`region_view_date` datetime,PRIMARY KEY (`id`));
CREATE UNIQUE INDEX `netflix_ratings_key` ON `netflix_ratings`(`profile_name`,`title_name`,`event_time`);
CREATE INDEX `idx_netflix_ratings_deleted_at` ON `netflix_ratings`(`deleted_at`);