Browse

Movies and TV shows with plots, cast and ratings

Public
Explore tables

Movies and TV shows with plots, cast and ratings

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.

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. Use the table for title lookup, catalogue exploration and feature preparation, accounting for missing enrichment and the stated catalogue scope.

Tables

Table healthAs published 4 October 2026moviesTable detailsNamemoviesColumns176
Table overviewPublished rows1,260,645Columns176 rows176 cols
Update detailsStatusAs published 4 October 2026Last published4 Oct 2026

Sources

4 publishers
The Movie Database (TMDB)The Movie Database (TMDB) is a popular, user editable database for movies and TV shows.8 endpoints
About
The Movie Database (TMDB) is a popular, user editable database for movies and TV shows.
Usage rights
Allowed by terms of service.
Requests
10 requests across 8 endpoints
EndpointRequests / coverage
/3/discover/movieTMDB's movie catalogue listed by primary release date, with each movie's overview, genres and audience votes.1 request
/3/movie/%7Bid%7DTMDB's details for each discovered movie, one call per movie with keywords, external ids, videos, watch providers, alternative titles, related movies and logos appended.1 request
/3/movie/%7Bid%7D/creditsTMDB's credits for each discovered movie: the billed cast with characters and the crew with their jobs.2 requests
/3/movie/%7Bid%7D/release_datesTMDB's release dates for each discovered movie, one row per country and release with its age certification, release type and note.1 request
/3/movie/%7Bid%7D/videosTMDB's complete English video list, one row per video with its YouTube key, type and publication time, for movies with at least 20 TMDB votes.1 request
/3/discover/tvTMDB's TV catalogue listed by first air date, with each show's overview, genres and audience votes.1 request
/3/tv/%7Bid%7DTMDB's details for each discovered TV show, one call per show with external ids and content ratings appended: status, type, seasons, episodes, networks, creators, companies, countries and languages.2 requests
/3/tv/%7Bid%7D/aggregate_creditsTMDB's aggregate credits for each discovered TV show across all its seasons: billed cast with their roles and the crew with their jobs.1 request
www.wikidata.orgwww.wikidata.org1 endpoint
Usage rights
Public domain asserted.
Requests
2 requests across 1 endpoint
EndpointRequests / coverage
/w/api.phpWikidata's item for each movie with a TMDB Wikidata id, 25 items per wbgetentities call: English labels, aliases, statements (people, awards, places, box office, external ids) and sitelinks.2 requests
en.wikipedia.orgen.wikipedia.org1 endpoint
Usage rights
Allowed by terms of service.
Requests
2 requests across 1 endpoint
EndpointRequests / coverage
/w/api.phpEnglish Wikipedia's lead section, short description, page image and URL for each movie whose Wikidata item links an English article, 20 titles per query.2 requests
Show 1 more publisher
openrouter-decisionsServed by openrouter.ai2 endpoints
Providers
Usage rights
Allowed by terms of service.
Requests
2 requests across 2 endpoints
EndpointRequests / coverage
jev_movieJEV story-fit scores and the existing browse-tag taxonomy for movie detail metadata; scores are uncalibrated.1 request
jev_tvJEV story-fit scores and the existing browse-tag taxonomy for tv detail metadata; scores are uncalibrated.1 request

Details

Contents
1 table · 1,260,645 rows · 176 columns
Coverage
–
Update cadence
—
Updated
Published
Version
2026-10-04
License
Not stated
Visibility
Public
Publisher
Mostly Right

Access

Read published metadata and available row previews without an account or API key. A free account is required for full table downloads and API queries.

MCP endpoint
https://mostlyright.md/api/mcp · Public discovery and previews; sign in for queries.

Activity

Views962+962 in the last 30 days
Likes0+0 in the last 30 days
Uses473+473 in the last 30 days

Comments

0

No comments yet. Questions about coverage, licensing, or how a column is derived belong here, in the open, beside the data.

Sign in to join the conversation.