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
| Name | Rows | Updated | Get the data |
|---|---|---|---|
Table overviewPublished rows1,260,645Columns176 rows176 cols Update detailsStatusAs published 4 October 2026Last published4 Oct 2026 | Table overviewPublished rows1,260,645Columns176 | 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.
- Website
- api.themoviedb.org ↗
- Usage rights
- Allowed by terms of service.
- Requests
- 10 requests across 8 endpoints
www.wikidata.orgwww.wikidata.org1 endpoint
- Website
- www.wikidata.org ↗
- Usage rights
- Public domain asserted.
- Requests
- 2 requests across 1 endpoint
en.wikipedia.orgen.wikipedia.org1 endpoint
- Website
- en.wikipedia.org ↗
- Usage rights
- Allowed by terms of service.
- Requests
- 2 requests across 1 endpoint
Show 1 more publisherShow fewer publishers
openrouter-decisionsServed by openrouter.ai2 endpoints
- Providers
openrouter.aiopenrouter.ai ↗
- Usage rights
- Allowed by terms of service.
- Requests
- 2 requests across 2 endpoints
Details
- Contents
- 1 table · 1,260,645 rows · 176 columns
- Coverage
- –
- Update cadence
- —
- Category
- Arts, Media & Entertainment
- Updated
- Published
- Version
- 2026-10-04
- License
- Not stated
- Visibility
- Public
- Publisher
- Mostly Right
- Topics
- movies · tv shows · plot summaries +2
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.
- Dataset API
- https://mostlyright.md/api/v2/public/datasets/movies-with-plot-summaries-and-ratings-since-1887
- movies · JSON row preview
- https://mostlyright.md/api/v2/public/tables/f8c2e1a1-809f-4545-89e0-fdf02eed8c9a/preview
- MCP endpoint
- https://mostlyright.md/api/mcp · Public discovery and previews; sign in for queries.


Comments
0No 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.