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 rowsStatus unavailable
- Table healthStatus unavailablesubtitle_chunksTable overviewPublished rows12,211,160Columns13 rowsStatus unavailable
Sources
storage.googleapis.com24 endpoints
- Website
- storage.googleapis.com ↗
- Usage rights
- Rights not stated.
- Collection
- 24 requests across 24 endpoints
Collected endpoints
Details
- Contents
- 2 tables · 13,471,805 rows · 190 columns
- Coverage
- –
- Category
- Arts, Media & Entertainment
- Updated
- Published
- Version
- 2026-10-27
- License
- Not stated
- Visibility
- Public
- Publisher
- Mostly Right
- Topics
- movies · tv shows · plot summaries +2



