netflix_subscription_history
2 rows where plan_change_new_category = "STREAMING ONLY" sorted by plan_change_old_max_concurrent_streams
This data as json, CSV (advanced)
Suggested facets: created_at (date), updated_at (date), subscription_opened_time (date), subscription_closed_time (date)
plan_change_date (date) ✖
- 2019-01-08 1
- 2020-03-11 1
id | created_at | updated_at | deleted_at | subscription_opened_time | is_free_trial | subscription_closed_time | is_customer_initiated_cancel | signup_plan_category | signup_max_concurrent_streams | signup_max_streaming_quality | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2021-01-22 20:46:21.570895+03:00 | 2021-01-22 20:46:21.570895+03:00 | 2020-02-12 07:45:41.952+00:00 | 0 | 0 | STREAMING ONLY | 2 | HD | 2020-03-11 00:00:00+00:00 | STREAMING ONLY | 4 | UHD | STREAMING ONLY | 2 | HD | |||
2 | 2021-01-22 20:46:21.570895+03:00 | 2021-01-22 20:46:21.570895+03:00 | 2018-02-05 20:39:14.171+00:00 | 0 | 2020-02-08 20:53:53.193+00:00 | 1 | STREAMING ONLY | 4 | UHD | 2019-01-08 00:00:00+00:00 | STREAMING ONLY | 4 | UHD | STREAMING ONLY | 2 | HD | CUSTOMER |
Advanced export
JSON shape: default, array, newline-delimited, object
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`);