TV Shows & Streaming Database — Deep Research Brief, Part 05: "Where to Watch" Availability, Pricing, and Catalog Change Tracking
111 preserved extracts. Research planning document; requested work is not evidence that the work was completed.
- NOTE 3818
TV Shows & Streaming Database — Deep Research Brief, Part 05: "Where to Watch" Availability, Pricing, and Catalog Change Tracking
Research window: January 1, 2019 – September 15, 2026 (with emphasis on the last 24 months). Research date: state the exact date research was performed (brief drafted September 17, 2026).
- NOTE 3819
TV Shows & Streaming Database — Deep Research Brief, Part 05: "Where to Watch" Availability, Pricing, and Catalog Change Tracking
Conduct exhaustive research on how TV series availability works and changes across streaming, broadcast-streaming, FAST, and rent/buy storefronts in multiple countries, and on how existing aggregators collect, display, and get availability wrong. The goal is to give the website a defensible availability record model, a measured understanding of catalog churn, a documented case list of removed and split-rights titles, a tested deep-link library, an accuracy benchmark against the leading aggregators, and the math behind "which services do I need," subscription rotation, and price-history features.
- NOTE 3820
1. How to research this part
Treat every named title, platform, price, date, and removal in this brief as a lead to verify, not a fact. Items marked (verify) are especially likely to be stale.
- NOTE 3821
1. How to research this part
Minimum counts: at least 60 platform-plan records per country for the 5 audit countries; at least 75 removal/write-off/rights-dispute cases (2022–2026); at least 40 split-rights examples; at least 25 TVOD price observations per storefront; deep-link patterns for at least 30 platforms across web, iOS, Android, and one TV OS.
- NOTE 3822
1. How to research this part
Prefer primary sources: platform help centers and pricing pages, press sites, company earnings calls and 10-K/annual reports, official "new this month" posts, storefront listings observed directly, and API documentation. Use trade press (Deadline, Variety, THR, The Wrap, Cord Cutters News, What's on Netflix) for context and dates, not as the sole source for availability.
- NOTE 3823
1. How to research this part
Record every availability and price observation with country, plan, observation date (UTC), observation method (manual in-app, official web page, API response), and observer.
- NOTE 3824
1. How to research this part
Log "as of" dates on catalog-size and churn figures; catalog numbers change weekly.
- NOTE 3825
1. How to research this part
Do not scrape platforms or aggregators in violation of their terms, use VPNs or geo-block evasion to observe other countries, or link to unauthorized sources. Use local testers, official country pages, licensed APIs, or contracted panels.
- NOTE 3826
1. How to research this part
Separate announced dates ("leaving March 31") from observed removals (title actually gone on April 1 in that country).
- NOTE 3827
2.1 Core record (platform × country × plan × date)
Design and justify a schema. Research how JustWatch, Reelgood, Watchmode, Streaming Availability API (Movie of the Night), and TMDB watch providers structure their equivalents (verify current field sets from public documentation).
- NOTE 3828
2.1 Core record (platform × country × plan × date)
availabilityid, titleid (canonical), scope (series / season / episode), seasonnumber, episoderange
- NOTE 3829
2.1 Core record (platform × country × plan × date)
platformid, channeloraddonid (e.g., a Prime Video Channel vs. Prime Video itself), country (ISO 3166-1), region where relevant (e.g., Canadian provinces for French-language rights)
- NOTE 3830
2.1 Core record (platform × country × plan × date)
offertype: subscription, free-with-ads, free, rent, buy, add-on, live/linear, next-day, FAST channel
- NOTE 3831
2.1 Core record (platform × country × plan × date)
planidsincluded (e.g., Netflix Standard with ads vs. Standard vs. Premium; Peacock Premium vs. Premium Plus; Disney+ Basic vs. Premium)
- NOTE 3832
2.1 Core record (platform × country × plan × date)
planrestrictions (title excluded from ad tier for licensing reasons—verify known Netflix and Disney+ ad-tier exclusions)
- NOTE 3833
2.1 Core record (platform × country × plan × date)
quality (SD/HD/4K/HDR/Dolby Vision), audiolanguages, subtitlelanguages, audiodescription flag
- NOTE 3834
2.1 Core record (platform × country × plan × date)
price, currency, pricetype (per episode / per season / season pass), taxinclusive flag
- NOTE 3835
2.1 Core record (platform × country × plan × date)
availablefrom, availableuntil (announced), observedfirstat, observedlastat
- NOTE 3836
2.1 Core record (platform × country × plan × date)
deeplinks {web, ios, android, tvos, androidtv, roku, firetv, tizen, webos}
- NOTE 3837
2.1 Core record (platform × country × plan × date)
source (list), sourcerecordid, confidencescore, lastverifiedat, verificationmethod
- NOTE 3838
2.1 Core record (platform × country × plan × date)
status: active, leavingsoon, expired, removedunexpectedly, disputed, unconfirmed
- NOTE 3839
2.2 Questions to answer
Should season-level and episode-level records be stored separately, or episode ranges collapsed? Show a worked example where Season 1–3 are on one service and Season 4 on another.
- NOTE 3840
2.2 Questions to answer
How should "partial seasons" be handled (e.g., a network streamer carrying only the last 5 episodes of a current season)? Research next-day windows on Hulu, Peacock, Paramount+, and network apps (verify current policies post-2025 Hulu integration into Disney+).
- NOTE 3841
2.2 Questions to answer
How do add-on channels map (Prime Video Channels, Apple TV Channels, Roku Premium Subscriptions, YouTube Primetime Channels)? A title on "HBO Max via Prime Video Channels" (verify whether still offered) is a different offer from HBO Max direct.
- NOTE 3842
2.2 Questions to answer
How to represent bundles (Disney+/Hulu/HBO Max bundle, Xfinity StreamSaver, carrier bundles) without duplicating availability.
- NOTE 3843
2.2 Questions to answer
How to model dubbed/subbed differences (e.g., anime simulcast subbed vs. dub weeks later on Crunchyroll; verify).
- NOTE 3844
2.3 Worked example to produce
Take one long-running series with known split rights (candidate leads: Grey's Anatomy, The Office (U.S.), Seinfeld, Star Trek: Discovery, Doctor Who) and build its full availability table for US, UK, CA, AU, DE on a single date, with every season, plan, and storefront. Show the JSON and a rendered "Where to watch" module mock.
- NOTE 3845
3. Catalog churn: adds, removals, and cadence
Measure monthly adds and removals by platform and country. Sources: official "new on" posts, What's on Netflix removal lists, JustWatch/Reelgood "new" and "leaving" feeds (as licensed), and your own longitudinal snapshots.
- NOTE 3846
3. Catalog churn: adds, removals, and cadence
Questions: What share of removals happen on the 1st and last day of the month? What share are pre-announced, and how far ahead (Netflix "last day to watch" labels typically ~30 days (verify))? How often do announced removals get extended or reversed?
- NOTE 3847
3. Catalog churn: adds, removals, and cadence
Research catalog-size estimates and their sources (e.g., Netflix U.S. TV series count over time; verify figures from What's on Netflix, JustWatch, Ampere Analysis). Record source and date for every number.
- NOTE 3848
3. Catalog churn: adds, removals, and cadence
Study licensed-vs-original catalog shifts: licensing back to rivals (e.g., WBD and Paramount titles licensed to Netflix 2023–2025 (verify); Suits on Netflix 2023 as a demand case (verify)).
- NOTE 3849
3. Catalog churn: adds, removals, and cadence
Study library moves tied to corporate events: Paramount Skydance–WBD acquisition plan to combine HBO Max and Paramount+ (announced; closing not expected before 2027, verify); Hulu integration into Disney+; Freevee shutdown 2025 and where Freevee originals went (verify); Crunchyroll ending free ad-supported tier Dec 31, 2025 (verify).
- NOTE 3850
3. Catalog churn: adds, removals, and cadence
Produce: a churn table (platform, country, month, adds, removals, announced %, reversals) for at least 12 months across 10 platforms, clearly marked as estimated where based on third-party data.
- NOTE 3851
3.1 Leaving-soon data reliability
Compare "leaving soon" labels in apps vs. aggregator feeds vs. actual removal dates for a sample of at least 100 titles.
- NOTE 3852
3.1 Leaving-soon data reliability
Record: announced date, actual removal date, country, whether extension occurred, lag before aggregator updated.
- NOTE 3853
3.1 Leaving-soon data reliability
Case leads: Netflix "Last day to watch" badges; Hulu "Expiring" collection; Max/HBO Max "Last Chance" rows; Prime Video "Leaving soon" (verify which still exist).
- NOTE 3854
4. Removed titles, write-offs, and rights disputes (2022–2026)
Build a case database. Every entry below is a lead requiring verification of dates, scope, and whether the title later returned elsewhere.
- NOTE 3855
4.1 Write-offs and content purges (verify all)
Warner Bros. Discovery removals from HBO Max 2022–2023: Westworld, The Nevers, Minx (later picked up by Starz), Raised by Wolves, Love Life, Gordita Chronicles, Infinity Train, Summer Camp Island, OK K.O.!, various Cartoon Network titles; many later went to FAST services (Tubi, The Roku Channel) (verify).
- NOTE 3856
4.1 Write-offs and content purges (verify all)
Disney+/Hulu removals May–June 2023: Willow, Y: The Last Man, Big Shot, The Mysterious Benedict Society, Dollface, Pistol, The Premise (verify); Willow later to TVOD/other (verify).
- NOTE 3857
4.1 Write-offs and content purges (verify all)
Paramount+ removals 2023 after Showtime integration: Star Trek: Prodigy (moved to Netflix, verify), Queen of the Universe, Grease: Rise of the Pink Ladies, The Game revival (verify).
- NOTE 3858
4.1 Write-offs and content purges (verify all)
Starz, AMC+, and MGM+ removals (research whether documented).
- NOTE 3859
4.1 Write-offs and content purges (verify all)
Post-2025 consolidation removals: research titles removed during Hulu-into-Disney+ migration, Freevee sunset, Versant spin-off (Comcast cable networks, Jan 2026, verify) and any Paramount+/Showtime catalog trimming.
- NOTE 3860
4.2 Licensing expirations and disputes (verify all)
Carriage or licensing disputes that pulled TV content: YouTube TV vs. Disney channels (Nov 2025 blackout, verify); YouTube TV vs. Paramount/NBCU/Fox negotiations 2025 (verify outcomes); DirecTV vs. Disney (2024, verify).
- NOTE 3861
4.2 Licensing expirations and disputes (verify all)
Music-rights edits and removals (e.g., Scrubs, Dawson's Creek, Daria music replacements on streaming) as availability-quality issues, not removals.
- NOTE 3862
4.2 Licensing expirations and disputes (verify all)
Episodes pulled for content reasons: 30 Rock, Scrubs, Community, It's Always Sunny in Philadelphia episodes removed 2020 for blackface (verify); Golden Girls episode (verify). These create episode-level gaps that must be recorded.
- NOTE 3863
4.2 Licensing expirations and disputes (verify all)
Titles unavailable on any streaming service in the U.S. for extended periods (lead list to verify: Moonlighting (returned via Hulu 2020, verify), The Wonder Years original, WKRP in Cincinnati, Ally McBeal).
- NOTE 3864
4.3 Produce
Case table: title, platform, countries affected, removal date, stated reason (write-off / expiry / dispute / content / unknown), official statement link, later home (platform, date), episode-level impact, source quality rating.
- NOTE 3865
4.3 Produce
A "lost TV" indicator policy: when to label a title "not currently streaming anywhere in [country]" and how to verify a true absence (checking all storefronts, FAST services, network apps).
- NOTE 3866
5. Split rights
Seasons split across services: e.g., The Walking Dead seasons (Netflix vs. AMC+ in U.S. at various times, verify); Gossip Girl original; Gilmore Girls (Netflix vs. others internationally); Doctor Who (BBC iPlayer + Disney+ outside UK/Ireland 2023–2025, verify current).
- NOTE 3867
5. Split rights
Territory splits: Netflix-branded originals licensed from other studios (Star Trek: Discovery was Netflix outside U.S. until Paramount+ took it back ~2021, verify); The Office U.S. on Peacock in U.S. but other services internationally; Apple/Prime co-productions.
- NOTE 3868
5. Split rights
Language/region splits: French-language rights in Canada (Crave vs. Club illico, verify); Latin America vs. Brazil; DACH vs. rest of EU.
- NOTE 3869
5. Split rights
Windowing splits: broadcast next-day on Hulu (ABC, FX) or Peacock (NBC) vs. full back catalog elsewhere; Paramount+ live CBS feed vs. on-demand.
- NOTE 3870
5. Split rights
Produce: at least 40 split-rights examples with a diagram-ready table (title → seasons → country → platform → dates).
- NOTE 3871
6. Network next-day streaming and live windows
Document for each major U.S. broadcaster: next-day on which service and plan (ABC/Hulu or Disney+, NBC/Peacock, CBS/Paramount+, Fox/Hulu or Fox One or Tubi, The CW/CW app) (verify all post-2025).
- NOTE 3872
6. Network next-day streaming and live windows
Document live access: Paramount+ with Showtime/Premium live CBS; Peacock Premium Plus live NBC affiliate; Fox One (launched Aug 2025, verify); vMVPDs.
- NOTE 3873
6. Network next-day streaming and live windows
UK/AU/CA equivalents: BBC iPlayer box-set policy, ITVX, Channel 4 streaming-first, 7plus/9Now/10 catch-up windows, CBC Gem, Crave next-day HBO (verify).
- NOTE 3874
6. Network next-day streaming and live windows
Questions: How long do "current season" episodes stay (rolling 5, full season, until next season)? How to show a rolling window in the UI?
- NOTE 3875
7. TVOD per-episode and season pricing
Storefronts: Apple TV app/iTunes, Amazon Prime Video store, Google TV / YouTube Movies & TV (verify Google Play Movies migration status), Fandango at Home (formerly Vudu, rebranded 2024, verify), Microsoft Store (verify whether still selling TV), Sky Store, Rakuten TV, Chili (verify status).
- NOTE 3876
7. TVOD per-episode and season pricing
Observe per-episode HD/SD pricing (historically $1.99–$3.99 U.S., verify), season prices, season passes, "complete series" bundles, pre-order season pass behavior, and whether 4K costs more.
- NOTE 3877
7. TVOD per-episode and season pricing
Research regional differences (UK £, EUR, CAD, AUD) and tax-inclusive display.
- NOTE 3878
7. TVOD per-episode and season pricing
Questions: How often do season prices change? How common are sales? Do storefront prices differ by device? Are some episodes unavailable individually?
- NOTE 3879
7. TVOD per-episode and season pricing
Produce: a price sheet of 25+ titles × 4 storefronts × 3 countries with observation dates, plus a price-change log over at least 8 weeks.
- NOTE 3880
8. Deep links: formats and testing
Catalog link patterns for each platform (web URL, universal links on iOS, Android App Links/intents, tvOS, Android TV, Roku ECP deep-link parameters, Fire TV, Samsung Tizen, LG webOS). Research official partner docs: Apple TV app integration (Video Partner Program, verify), Google TV/Android "Watch Actions" (verify), Roku deep linking spec, Amazon catalog integration.
- NOTE 3881
8. Deep links: formats and testing
Record whether links target series, season, or episode, and whether IDs are stable (Netflix title IDs, Prime Video ASINs/GTIs, Disney+ entity IDs, HBO Max URNs—verify formats).
- NOTE 3882
8. Deep links: formats and testing
Design a test protocol: for each platform × device × country, test 50 links; record outcome (opens correct episode, opens show page, opens home, error, prompts install, wrong region). Retest monthly.
- NOTE 3883
8. Deep links: formats and testing
Produce: deep-link failure-rate table and a link-rot monitoring plan (HTTP checks for web, periodic device checks for apps).
- NOTE 3884
8. Deep links: formats and testing
Note affiliate-link wrapping impacts (Amazon, Apple Services Performance Partners) and disclosure needs; note where a lawyer should review affiliate terms.
- NOTE 3885
9.1 Design
Countries: US, UK, Canada, Australia, Germany (or India/Brazil as alternates; justify).
- NOTE 3886
9.1 Design
Sample: 500 series stratified by type (100 current-season broadcast/cable, 100 streaming originals, 100 licensed library, 75 anime, 50 K-drama/Asian, 50 reality/unscripted, 25 kids). Include 50 titles with known recent changes.
- NOTE 3887
9.1 Design
Sources compared: JustWatch, Reelgood (US and limited countries, verify), TMDB watch providers (JustWatch-powered; note attribution), Watchmode, Streaming Availability API, Google search/knowledge panel "Watch" options, official platform apps/websites as ground truth.
- NOTE 3888
9.1 Design
Ground truth: local testers with real subscriptions checking official apps within a 48-hour window; record screenshots and timestamps.
- NOTE 3889
9.2 Metrics
Precision (listed offers that truly exist), recall (true offers listed), plan accuracy, season-scope accuracy, price accuracy, deep-link success, and staleness (days behind reality).
- NOTE 3890
9.2 Metrics
Error taxonomy: wrong platform, missing platform, wrong country, wrong plan/ad tier, wrong season scope, stale removal, phantom leaving-soon, wrong price, broken deep link, add-on confused with base service.
- NOTE 3891
9.2 Metrics
Produce: per-source scorecard by country and title type, with confidence intervals and a list of the 50 worst errors.
- NOTE 3892
10. Confidence score and last-verified design
Propose a 0–100 score combining: number of agreeing independent sources, source reliability weights (from the audit), age since last verification, platform volatility (churn rate), proximity to announced expiry or month boundary, and user-reported problems.
- NOTE 3893
10. Confidence score and last-verified design
Worked example: offer confirmed by official app 2 days ago (+), agreed by 2 feeds (+), month-end in 1 day (−), 1 user report "not available" (−) → score and displayed label ("Verified Sep 15", "Likely", "Unconfirmed").
- NOTE 3894
10. Confidence score and last-verified design
Define refresh cadence tiers (daily for top 5,000 titles and leaving-soon items; weekly mid-tail; monthly long tail).
- NOTE 3895
10. Confidence score and last-verified design
Research UX: how to display "last verified" without eroding trust; how users report errors; correction SLAs.
- NOTE 3896
11. "Which services do I need" optimizer
Formalize as weighted set cover: minimize total monthly cost subject to covering watchlist titles (or maximize weighted coverage under a budget). Include ad-tier vs. ad-free choices, bundles, add-ons, free services, and TVOD fallback costs.
- NOTE 3897
11. "Which services do I need" optimizer
Worked example: a 20-show watchlist in the U.S., prices on a given date (verify), showing optimal sets at $10, $20, $30 budgets, and the cost of buying the uncovered shows outright.
- NOTE 3898
11. "Which services do I need" optimizer
Questions: greedy vs. integer programming performance at 200 services; handling annual-plan discounts; multi-country households; user-owned services as sunk cost.
- NOTE 3899
11. "Which services do I need" optimizer
Research existing tools (JustWatch "my services" filters, Reelgood, Streaming Availability-based apps) and their limits.
- NOTE 3900
12. Subscription rotation planner
Model a 12-month calendar: which service to hold each month to watch watchlist items as they release (weekly schedules mean finales determine subscription timing).
- NOTE 3901
12. Subscription rotation planner
Inputs: release calendars, episode counts, user pace (episodes/week), cancellation rules (billing-period end access), price changes, promo offers.
- NOTE 3902
12. Subscription rotation planner
Research churn-and-return data (Antenna subscriber analyses, verify; serial churner statistics) and platform countermeasures (annual plans, bundles, ad tier pricing).
- NOTE 3903
12. Subscription rotation planner
Worked example: two prestige weekly shows on different services premiering three months apart; show savings vs. holding both all year.
- NOTE 3904
13. Price history tracking
Build a price-history table: platform, country, plan, price, currency, effective date, announcement date, grandfathering rules, source link.
- NOTE 3905
13. Price history tracking
Seed with known 2023–2026 changes (verify each): Netflix price rises (Jan 2025 U.S., verify), Disney+/Hulu Oct 2025 (verify), Peacock July 2025 (verify), HBO Max Oct 2025 (verify), Crunchyroll Feb 2026 (verify), Prime Video Ultra ad-free add-on ($4.99/mo with 4K moved into it, 2026, verify), Apple TV price increase Aug 2025 (verify).
- NOTE 3906
13. Price history tracking
Questions: how to track promo vs. list prices; how to present regional price parity; how to alert users before increases take effect.
- NOTE 3907
14. Timeline 2019 – 2026
Log dated events relevant to availability: launches (Disney+, Apple TV+ 2019; HBO Max, Peacock 2020; Paramount+ 2021), renames (Max 2023, HBO Max return July 2025, Apple TV rename Oct 2025; Vudu → Fandango at Home 2024), shutdowns (Freevee 2025; CNN+ 2022), major write-off waves (2022–2023), licensing-back deals, carriage disputes, ad-tier launches (Netflix Nov 2022, Disney+ Dec 2022, Prime Video default ads Jan 2024), password-sharing crackdowns, price changes, merger closings (Skydance–Paramount Aug 2025; Disney–Fubo Oct 2025; WBD acquisition pending) — all (verify).
- NOTE 3908
15. Deliverables for Part 05
Availability schema (JSON Schema + ER diagram) with worked multi-season, multi-country example.
- NOTE 3909
15. Deliverables for Part 05
Platform-plan directory for 5 audit countries (at least 300 plan records) with prices and as-of dates.
- NOTE 3910
15. Deliverables for Part 05
Catalog churn dataset (10 platforms × 12 months) with methodology notes.
- NOTE 3911
15. Deliverables for Part 05
Removals/write-offs/disputes case database (75+ cases).
- NOTE 3912
15. Deliverables for Part 05
Split-rights database (40+ examples).
- NOTE 3913
15. Deliverables for Part 05
Next-day/live window matrix for U.S., UK, CA, AU broadcasters.
- NOTE 3914
15. Deliverables for Part 05
TVOD price sheet and 8-week price-change log.
- NOTE 3915
15. Deliverables for Part 05
Deep-link pattern library (30+ platforms) and failure-rate test results.
- NOTE 3916
15. Deliverables for Part 05
500-title × 5-country accuracy audit report and per-source scorecards.
- NOTE 3917
15. Deliverables for Part 05
Confidence score specification with test cases.
- NOTE 3918
15. Deliverables for Part 05
Optimizer and rotation planner specifications with worked examples.
- NOTE 3919
15. Deliverables for Part 05
Price-history table (2019–2026) with sources.
- NOTE 3920
15. Deliverables for Part 05
Glossary of at least 60 availability terms (window, holdback, co-exclusive, season pass, next-day, FAST, add-on, etc.).
- NOTE 3921
15. Deliverables for Part 05
Annotated source list (at least 80 sources) with access dates.
- NOTE 3922
Research standards
State the research date and record access dates for every observation; availability is only true "as of" a moment in a specific country.
- NOTE 3923
Research standards
Treat official apps and platform pages observed in-country as ground truth; label aggregator data as secondary.
- NOTE 3924
Research standards
Never observe foreign catalogs via VPN or geo-evasion; use in-country testers or licensed data.
- NOTE 3925
Research standards
Label each removal reason as officially stated, reported by trade press, or inferred.
- NOTE 3926
Research standards
Report accuracy metrics with sample sizes and confidence intervals; do not generalize beyond the sample.
- NOTE 3927
Research standards
Keep price data with currency, tax treatment, and promo vs. list status.
- NOTE 3928
Research standards
Respect data-provider terms on caching, attribution, and display; note where a lawyer should review license terms or affiliate agreements.