1 row where "created_at" is on date 2021-01-22 and thumbs_value = 0 sorted by rating_type

View and edit SQL

Suggested facets: updated_at (date), event_time (date)

created_at (date)

  • 2021-01-22 · 1
id created_at updated_at deleted_at profile_name title_name rating_type ▼ star_value thumbs_value device_model event_time region_view_date
2 2021-01-22 20:46:21.569481+03:00 2021-01-22 20:46:21.569481+03:00   Seva Miraculous: Tales of Ladybug & Cat Noir thumb 0 0 Apple TV 2019-10-11 20:23:53+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`);