1 row where "subscription_closed_time" is on date 2017-05-24 sorted by plan_change_old_category

View and edit SQL

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

subscription_closed_time (date)

  • 2017-05-24 · 1

is_customer_initiated_cancel

  • 0 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
4 2021-01-22 20:46:21.570895+03:00 2021-01-22 20:46:21.570895+03:00   2017-03-24 10:48:42.096+00:00 1 2017-05-24 01:02:04.563+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`);