1 row where "subscription_closed_time" is on date 2017-10-22 sorted by plan_change_date descending

View and edit SQL

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

subscription_closed_time (date)

  • 2017-10-22 · 1
id created_at updated_at deleted_at subscription_opened_time is_free_trial subscription_closed_time is_customer_initiated_cancel plan_change_date ▲ plan_change_old_category plan_change_old_max_concurrent_streams plan_change_old_max_streaming_quality plan_change_new_category plan_change_new_max_concurrent_streams plan_change_new_max_streaming_quality cancellation_reason
3 2021-01-22 20:46:21.570895+03:00 2021-01-22 20:46:21.570895+03:00   2017-05-28 15:37:40.604+00:00 0 2017-10-22 01:14:16.689+00:00 0     0     0   INVOL_UNPAID

Advanced export

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

CSV options:

CREATE TABLE `netflix_subscription_history` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`subscription_opened_time` datetime UNIQUE,`is_free_trial` numeric,`subscription_closed_time` datetime,`is_customer_initiated_cancel` numeric,`signup_plan_category` text,`signup_max_concurrent_streams` integer,`signup_max_streaming_quality` text,`plan_change_date` datetime,`plan_change_old_category` text,`plan_change_old_max_concurrent_streams` integer,`plan_change_old_max_streaming_quality` text,`plan_change_new_category` text,`plan_change_new_max_concurrent_streams` integer,`plan_change_new_max_streaming_quality` text,`cancellation_reason` text,PRIMARY KEY (`id`));
CREATE INDEX `idx_netflix_subscription_history_deleted_at` ON `netflix_subscription_history`(`deleted_at`);