1 row where "event_time" is on date 2019-10-11 sorted by deleted_at

View and edit SQL

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

thumbs_value

  • 0 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`);