Loading dataset

Description

Explore movies and TV shows with titles, release dates, cast, crew, plots and ratings. This table joins TMDB catalogue records with Wikidata, Wikipedia and Jev enrichment.

This live dataset updates weekly. The current verified version contains 1,260,645 rows and 176 columns. Each row is a movie or TV record at its release date, keyed by media_type, release_date and TMDB id. That key passed the whole-table uniqueness check.

What is included

English and original titles, original language, plot summary, genres, popularity and user ratings; poster and backdrop links; cast, directors, writers and other crew; runtime, budget, revenue and production information; age ratings, videos, watch providers and external identifiers; TV seasons and episode metadata; Wikidata descriptions and relationships, Wikipedia extracts, and Jev tags where available. Enrichment is joined to the catalogue rather than added as separate movie or TV rows.

Coverage and limitations

All 16 declared sources were included in the build. No row or byte ceiling truncated a source. The TMDB Discover scope excludes adult and video-only catalogue entries and requires a release date. Records span historical releases through the build date; this is the declared catalogue scope, not every record TMDB holds.

Coverage of optional enrichment is incomplete. The receipt reports 217,847 failed Wikidata movie requests and 28,700 failed Wikidata TV requests; missing matches or unavailable fields remain null. Successful execution and the uniqueness check do not establish completeness of every enrichment field.

The status counter of 8,082,786 rows sums the 16 input sources, including one-to-many credits and release ratings. It is not the final table size. The sealed table manifest records 1,260,645 rows.

Updates and search

Automatic updates are enabled every 7 days, using Studio's bounded incremental refresh. The table is live and refresh-ready. Enabling the schedule does not establish that the first scheduled refresh has already completed.

Title search covers all 1,260,645 rows in the current sealed version. It matches literal title substrings without case sensitivity and returns the original title, release date, media type and TMDB identifier. Full coverage, pagination and Unicode title queries have been verified end to end.

Subtitles table

The subtitle_chunks table holds English dialogue for 126,173 films in 12,211,160 chunks of about 30 to 60 seconds each, with start and end times. Each film uses one subtitle file. Join it to the movies table on imdb_id, or on id (the TMDB id), which is filled for 119,453 films found in the movies table. Subtitle text comes from OpenSubtitles.org via OPUS OpenSubtitles v2024.

Sources and use

TMDB supplies catalogue, detail, credit, rating and media data; Wikidata, Wikipedia and Jev supply optional enrichment. Original providers retain their respective rights and terms; this description does not grant a new licence. Subtitle text in the subtitle_chunks table is credited to OpenSubtitles.org via OPUS OpenSubtitles v2024. Use the table for title lookup, catalogue exploration and feature preparation, accounting for missing enrichment and the stated catalogue scope.

Tables2

  • Table healthStatus unavailablemoviesTable overviewPublished rows1,260,645Columns177 rows
    Status unavailable
  • Table healthStatus unavailablesubtitle_chunksTable overviewPublished rows12,211,160Columns13 rows
    Status unavailable

Sources

storage.googleapis.com24 endpoints
Usage rights
Rights not stated.
Collection
24 requests across 24 endpoints

Collected endpoints

Part 1 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_000.parquet1 request
Part 2 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_001.parquet1 request
Part 3 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_002.parquet1 request
Part 4 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_003.parquet1 request
Part 5 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_004.parquet1 request
Part 6 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_005.parquet1 request
Part 7 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_006.parquet1 request
Part 8 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_007.parquet1 request
Part 9 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_008.parquet1 request
Part 10 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_009.parquet1 request
Part 11 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_010.parquet1 request
Part 12 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_011.parquet1 request
Part 13 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_012.parquet1 request
Part 14 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_013.parquet1 request
Part 15 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_014.parquet1 request
Part 16 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_015.parquet1 request
Part 17 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_016.parquet1 request
Part 18 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_017.parquet1 request
Part 19 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_018.parquet1 request
Part 20 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_019.parquet1 request
Part 21 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_020.parquet1 request
Part 22 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_021.parquet1 request
Part 23 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_022.parquet1 request
Part 24 of 24 of processed Parquet of OPUS OpenSubtitles v2024 English film subtitle chunks./mostlyright-public-hosted-sources/opensubtitles-en-full/v2/part_023.parquet1 request

Details

Contents
2 tables · 13,471,805 rows · 190 columns
Coverage
–
Updated
Published
Version
2026-10-27
License
Not stated
Visibility
Public
Publisher
Mostly Right

Activity

Views2,299+1,326 in the last 30 days
Likes0+0 in the last 30 days
Uses693+198 in the last 30 days

Support

Talk to Mostly Right

Loading chat…