# 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 pas…

Movies and TV shows with plots, cast and ratings is an open, machine-readable dataset published on Mostly Right as immutable Parquet versions, with a documented column schema, a JSON query API and a direct download. Its first rows are free to read and it is open to AI agents.

## Facts

- Slug: `movies-with-plot-summaries-and-ratings-since-1887`
- Canonical page: https://mostlyright.md/datasets/movies-with-plot-summaries-and-ratings-since-1887
- Publisher: mostlyrightmd (https://mostlyright.md/publishers/mostlyrightmd)
- Published: 2026-09-24T09:19:02.864Z
- Tables: 1
- Formats: Apache Parquet (download), JSON (query and sample)
- Cost: the first 500 rows of each table are free to everyone; querying and downloading need a free account and count against a monthly free allowance unless the workspace is subscribed
- Metadata API: `GET https://mostlyright.md/api/v2/public/datasets/movies-with-plot-summaries-and-ratings-since-1887`
- Topics: movies, tv shows, plot summaries, cast, ratings

## How to use it

1. Read a table's schema — no account needed.
2. Fetch its published sample rows — no account needed.
   The first 500 rows of every table, in stored order, are free to everyone, with or without an account. Without an account you get that sample and nothing else: no filter, sort, search, download or page past row 500.
3. Sign in at https://mostlyright.md/login, connect this dataset to a workspace on its page, and create an `mr_use_` key.
4. Query bounded JSON, or download the complete Parquet snapshot and read it locally.
   A free workspace may read 100,000 rows and run 1,000 queries a UTC month past the sample. The allowance is shared by everyone in the workspace, and a free workspace may have any number of members. Reads count against the workspace whose data or key they use. A subscribed workspace is never counted, for anyone working in it.

Agents can do all of this over MCP at `https://mostlyright.md/api/mcp` — searching, reading schemas and sampling rows work with no credential at all.

## Table: movies

- Table id: `f8c2e1a1-809f-4545-89e0-fdf02eed8c9a`
- Slug: `movies`
- Immutable version: `0ba66f99-0320-5779-bd5f-a85442068e30`
- Schema: `GET https://mostlyright.md/api/v2/public/tables/f8c2e1a1-809f-4545-89e0-fdf02eed8c9a/schema`
- Sample rows, no key: `GET https://mostlyright.md/api/v2/public/tables/f8c2e1a1-809f-4545-89e0-fdf02eed8c9a/preview`
- Bounded JSON query: `POST https://mostlyright.md/api/v2/public/tables/f8c2e1a1-809f-4545-89e0-fdf02eed8c9a/query` with `x-api-key: mr_use_…`
- Full Parquet snapshot: `GET https://mostlyright.md/api/v2/public/tables/f8c2e1a1-809f-4545-89e0-fdf02eed8c9a/current` with `x-api-key: mr_use_…` (application/vnd.apache.parquet)

### Columns (176)

| Column | Type | Description |
| --- | --- | --- |
| `media_type` | string | Whether the title is a movie or a TV show: 'movie' or 'tv'. Part of the grain, because TMDB movie and TV ids overlap. |
| `release_date` | date | For a movie, its primary release date; for a TV show, its first air date; as TMDB records it. |
| `id` | integer | TMDB's numeric identifier for the movie or TV show; unique only together with media_type. |
| `title` | string | The movie's or show's title in English where TMDB has one. |
| `original_title` | string | The movie's or show's title in its original language. |
| `original_language` | string | The ISO 639-1 code of the movie's original language. |
| `overview` | string | TMDB's short English plot summary of the movie. |
| `genres` | string | Up to five TMDB genres, comma-separated, in TMDB's order. |
| `popularity` | number | TMDB's popularity score at the time the movie's month was last fetched. |
| `vote_average` | number | The average TMDB user rating, from 0 to 10. |
| `vote_count` | integer | How many TMDB users rated the movie. |
| `poster_url` | string | A link to the movie's poster image on TMDB's image server. |
| `adult` | boolean | Whether TMDB marks the title as adult. |
| `backdrop_url` | string | A link to the movie's backdrop image on TMDB's image server. |
| `video` | boolean | Whether TMDB marks this Discover row as a video title. |
| `emoji_1` | string | JEV story-fit emoji label ranked 1 among valid model scores at least 0.5; null when no qualifying score or no answer exists. Scores are uncalibrated. |
| `p_1` | number | Uncalibrated JEV score for emoji_1; retained only in [0.5,1]. This is not an empirical event probability. |
| `emoji_2` | string | JEV story-fit emoji label ranked 2 among valid model scores at least 0.5; null when no qualifying score or no answer exists. Scores are uncalibrated. |
| `p_2` | number | Uncalibrated JEV score for emoji_2; retained only in [0.5,1]. This is not an empirical event probability. |
| `emoji_3` | string | JEV story-fit emoji label ranked 3 among valid model scores at least 0.5; null when no qualifying score or no answer exists. Scores are uncalibrated. |
| `p_3` | number | Uncalibrated JEV score for emoji_3; retained only in [0.5,1]. This is not an empirical event probability. |
| `emoji_model` | string | Served JEV model identifier for the answer inferred from available title, overview, tagline, genre and keyword metadata; null when no answer exists. |
| `mood_1` | string | JEV inferred mood 1 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `mood_2` | string | JEV inferred mood 2 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `tone` | string | JEV inferred tone browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `setting_1` | string | JEV inferred setting 1 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `setting_2` | string | JEV inferred setting 2 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `era_feel` | string | JEV inferred era feel browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `audience` | string | JEV inferred audience browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `narrative` | string | JEV inferred narrative browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `trope_1` | string | JEV inferred trope 1 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `trope_2` | string | JEV inferred trope 2 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null. |
| `tag_model` | string | Served JEV model identifier for the answer inferred from available title, overview, tagline, genre and keyword metadata; null when no answer exists. |
| `tags_text` | string | Stable joined tag string for embedding ingest (axis:value pairs). |
| `director` | string | Directors, comma-separated in billing order; for TV, every director TMDB credits across the show's episodes. |
| `writers` | string | The movie's writers from TMDB credits (screenplay, story, novel and other writing jobs), comma-separated in credit order. Read from the first 100 crew credits,… |
| `composer` | string | The movie's composer from TMDB credits (original music, music), comma-separated in credit order. Read from the first 100 crew credits, or the complete crew for… |
| `cast_top10` | string | The first ten billed cast members as a JSON array of objects with name and character, in TMDB billing order. |
| `cast_full` | string | The billed cast as a JSON array of objects with name and character, in TMDB billing order, cut at the first 20. |
| `crew_key` | string | Key crew as a JSON array of objects with job and name, covering director, writing jobs, composer, producer, director of photography and editor. Read from the f… |
| `budget` | integer | Movie production budget in US dollars as TMDB records it; always NULL for TV. |
| `revenue` | integer | Movie worldwide box office revenue in US dollars as TMDB records it; always NULL for TV. |
| `runtime` | integer | Movie running time in minutes; for TV, the first typical episode run time in minutes. |
| `tagline` | string | The movie's English tagline on TMDB. |
| `keywords` | string | Up to the first 30 TMDB keywords as a JSON array of strings, in TMDB's order. |
| `production_companies` | string | Up to five production company names as a JSON array of strings, in TMDB's order. |
| `production_countries` | string | Up to five production countries as a JSON array of ISO 3166-1 alpha-2 codes. |
| `spoken_languages` | string | Up to five spoken languages as a JSON array of ISO 639-1 codes. |
| `age_rating_us` | string | The US age certification, such as PG-13 or R, preferring the theatrical release. Null where TMDB records none. |
| `age_ratings` | string | The age certification in each country as a JSON object keyed by ISO 3166-1 code, preferring each country's theatrical release. |
| `premium_formats` | string | Movies only: JSON list of premium formats (IMAX, Dolby Cinema, 4DX, ScreenX, 3D) the release was shown in; NULL for TV. |
| `trailer_youtube` | string | A YouTube link to the movie's English trailer on TMDB, preferring the earliest official trailer, then any trailer, then a teaser. Movies with fewer than 20 TMD… |
| `watch_providers` | string | Where to stream (up to four), rent (up to two) and buy (up to two) the movie in the US, GB, DE, FR, CZ and JP, as a JSON array of objects with country, flatrat… |
| `alternative_titles` | string | Up to ten alternative titles as a JSON array of objects with country and title. |
| `recommended_ids` | string | TMDB ids of the first 15 movies TMDB recommends alongside this one, as a JSON array of integers. |
| `similar_ids` | string | TMDB ids of the first 15 movies TMDB lists as similar, as a JSON array of integers. |
| `imdb_id` | string | The movie's IMDb identifier, such as tt0137523. |
| `wikidata_id` | string | The movie's Wikidata item identifier, such as Q190050. |
| `homepage` | string | The movie's official website as TMDB records it. |
| `logo_url` | string | A link to the movie's first English title logo on TMDB's image server. |
| `status` | string | TMDB's production status: for movies e.g. Released or Post Production, for TV e.g. Returning Series, Ended or Canceled. |
| `origin_country` | string | JSON list of ISO 3166-1 country codes TMDB gives as the title's country of origin. |
| `first_air_date` | date | TV only: the date the show's first episode aired, as TMDB records it (equal to release_date for TV rows). |
| `last_air_date` | date | TV only: the air date of the most recent episode TMDB lists for the show. |
| `in_production` | boolean | TV only: whether TMDB marks the show as still in production. |
| `tv_type` | string | TV only: TMDB's show type, e.g. Scripted, Reality, Documentary, Miniseries, Talk Show or News. |
| `number_of_episodes` | integer | TV only: the total number of episodes TMDB counts for the show. |
| `number_of_seasons` | integer | TV only: the number of seasons TMDB counts for the show (specials excluded). |
| `episode_run_time` | string | TV only: JSON list of typical episode run times in minutes, as TMDB states them. |
| `languages` | string | TV only: JSON list of ISO 639-1 language codes the show is produced in. |
| `networks` | string | TV only: JSON list of the networks that aired the show, each with its name and country. |
| `created_by` | string | TV only: JSON list of the show's creators' names. |
| `seasons` | string | TV only: JSON list with one summary per season (season number, name, first air date, episode count); season 0 holds specials. |
| `translation_languages` | string | TV only: JSON list of the ISO 639-1 languages TMDB holds a translation of the show's text in. |
| `tvdb_id` | string | TV only: the show's TheTVDB series id, from TMDB's external ids. |
| `freebase_mid` | string | TV only: the show's Freebase machine id (/m/...), from TMDB's external ids. |
| `freebase_id` | string | TV only: the show's Freebase topic id, from TMDB's external ids. |
| `tvrage_id` | string | TV only: the show's retired TVRage id, from TMDB's external ids. |
| `facebook_id` | string | The title's Facebook page handle, from TMDB's external ids. |
| `instagram_id` | string | The title's Instagram handle, from TMDB's external ids. |
| `twitter_id` | string | The title's X (Twitter) handle, from TMDB's external ids. |
| `wd_id` | string | The Wikidata item id (Q-number) this row's Wikidata columns were read from. |
| `wd_label` | string | The English label of the title's Wikidata item. |
| `wd_description` | string | The English short description of the title's Wikidata item. |
| `wd_aliases` | string | JSON list of up to five English aliases of the title's Wikidata item. |
| `wd_instance_of` | string | JSON list of Wikidata Q-ids of the title's what kind of work the item is (P31), e.g. film or television series. |
| `wd_genres` | string | JSON list of Wikidata Q-ids of the title's genres (P136). |
| `wd_countries_of_origin` | string | JSON list of Wikidata Q-ids of the title's countries of origin (P495). |
| `wd_original_languages` | string | JSON list of Wikidata Q-ids of the title's original languages (P364). |
| `wd_directors` | string | JSON list of Wikidata Q-ids of the title's directors (P57). |
| `wd_screenwriters` | string | JSON list of Wikidata Q-ids of the title's screenwriters (P58). |
| `wd_cast` | string | JSON list of Wikidata Q-ids of the title's cast members (P161). |
| `wd_composers` | string | JSON list of Wikidata Q-ids of the title's composers (P86). |
| `wd_cinematographers` | string | JSON list of Wikidata Q-ids of the title's directors of photography (P344). |
| `wd_editors` | string | JSON list of Wikidata Q-ids of the title's film editors (P1040). |
| `wd_producers` | string | JSON list of Wikidata Q-ids of the title's producers (P162). |
| `wd_executive_producers` | string | JSON list of Wikidata Q-ids of the title's executive producers (P1431). |
| `wd_production_companies` | string | JSON list of Wikidata Q-ids of the title's production companies (P272). |
| `wd_distributors` | string | JSON list of Wikidata Q-ids of the title's distributors (P750). |
| `wd_awards` | string | JSON list of Wikidata Q-ids of the title's awards received (P166). |
| `wd_nominations` | string | JSON list of Wikidata Q-ids of the title's award nominations (P1411). |
| `wd_narrative_locations` | string | JSON list of Wikidata Q-ids of the title's narrative locations (P840). |
| `wd_filming_locations` | string | JSON list of Wikidata Q-ids of the title's filming locations (P915). |
| `wd_main_subjects` | string | JSON list of Wikidata Q-ids of the title's main subjects (P921). |
| `wd_based_on` | string | JSON list of Wikidata Q-ids of the title's works it is based on (P144). |
| `wd_series` | string | JSON list of Wikidata Q-ids of the title's series it belongs to (P179). |
| `wd_part_of` | string | JSON list of Wikidata Q-ids of the title's larger works it is part of (P361). |
| `wd_media_franchises` | string | JSON list of Wikidata Q-ids of the title's media franchises (P8345). |
| `wd_original_broadcasters` | string | JSON list of Wikidata Q-ids of the title's original broadcasters (P449). |
| `wd_creators` | string | JSON list of Wikidata Q-ids of the title's creators (P170). |
| `wd_distribution_formats` | string | JSON list of Wikidata Q-ids of the title's distribution formats (P437). |
| `wd_characters` | string | JSON list of Wikidata Q-ids of the title's characters (P674). |
| `wd_costume_designers` | string | JSON list of Wikidata Q-ids of the title's costume designers (P2515). |
| `wd_production_designers` | string | JSON list of Wikidata Q-ids of the title's production designers (P2554). |
| `wd_follows` | string | Wikidata Q-id of the title this one follows in its series (P155). |
| `wd_followed_by` | string | Wikidata Q-id of the title that follows this one in its series (P156). |
| `wd_mpaa_rating` | string | Wikidata Q-id of the title's MPA film rating (P1657). |
| `wd_fsk_rating` | string | Wikidata Q-id of the title's German FSK rating (P1981). |
| `wd_color` | string | Wikidata Q-id of the title's colour process, e.g. colour or black-and-white (P462). |
| `wd_box_office` | number | Box office gross from Wikidata's first stated value (P2142), in the currency named by wd_box_office_currency. |
| `wd_box_office_currency` | string | Wikidata Q-id of the currency of wd_box_office, e.g. Q4917 for US dollars. |
| `wd_cost` | number | Production cost from Wikidata's first stated value (P2130), in the currency named by wd_cost_currency. |
| `wd_cost_currency` | string | Wikidata Q-id of the currency of wd_cost, e.g. Q4917 for US dollars. |
| `wd_duration_min` | number | Running time in minutes from Wikidata's first stated duration (P2047), converted from hours where needed. |
| `wd_number_of_episodes` | integer | Number of episodes Wikidata states for the title (P1113). |
| `wd_number_of_seasons` | integer | Number of seasons Wikidata states for the title (P2437). |
| `wd_publication_dates` | string | JSON list of up to three publication or release dates Wikidata states (P577), as YYYY-MM-DD with 00 for unknown month or day. |
| `wd_start_time` | string | The title's start date on Wikidata (P580), typically a show's first broadcast, as YYYY-MM-DD. |
| `wd_end_time` | string | The title's end date on Wikidata (P582), typically a show's last broadcast, as YYYY-MM-DD. |
| `wd_title` | string | The title in its original language as Wikidata records it (P1476). |
| `wd_imdb_id` | string | The title's IMDb identifier as Wikidata records it. |
| `wd_tmdb_movie_id` | string | The title's TMDB movie identifier as Wikidata records it. |
| `wd_tmdb_tv_id` | string | The title's TMDB TV identifier as Wikidata records it. |
| `wd_tvdb_id` | string | The title's TheTVDB identifier as Wikidata records it. |
| `wd_rotten_tomatoes_id` | string | The title's Rotten Tomatoes identifier as Wikidata records it. |
| `wd_metacritic_id` | string | The title's Metacritic identifier as Wikidata records it. |
| `wd_letterboxd_id` | string | The title's Letterboxd identifier as Wikidata records it. |
| `wd_box_office_mojo_id` | string | The title's Box Office Mojo identifier as Wikidata records it. |
| `wd_allocine_id` | string | The title's AlloCiné identifier as Wikidata records it. |
| `wd_netflix_id` | string | The title's Netflix identifier as Wikidata records it. |
| `wd_kinopoisk_id` | string | The title's Kinopoisk identifier as Wikidata records it. |
| `wd_filmaffinity_id` | string | The title's FilmAffinity identifier as Wikidata records it. |
| `wd_filmweb_id` | string | The title's Filmweb identifier as Wikidata records it. |
| `wd_csfd_id` | string | The title's ČSFD identifier as Wikidata records it. |
| `wd_allmovie_id` | string | The title's AllMovie identifier as Wikidata records it. |
| `wd_freebase_id` | string | The title's Freebase identifier as Wikidata records it. |
| `wd_x_username` | string | The title's X (Twitter) username identifier as Wikidata records it. |
| `wd_instagram_username` | string | The title's Instagram username identifier as Wikidata records it. |
| `wd_facebook_id` | string | The title's Facebook identifier as Wikidata records it. |
| `wd_apple_tv_movie_id` | string | The title's Apple TV movie identifier as Wikidata records it. |
| `wd_apple_tv_show_id` | string | The title's Apple TV show identifier as Wikidata records it. |
| `wd_isan` | string | The title's ISAN identifier as Wikidata records it. |
| `wd_sitelinks` | string | JSON object of the title's Wikipedia article titles by wiki (enwiki, dewiki, frwiki, eswiki, itwiki, jawiki, ruwiki, zhwiki, cswiki, ptwiki, plwiki, kowiki). |
| `wd_enwiki_url` | string | URL of the title's English Wikipedia article, from its Wikidata sitelink. |
| `wp_page_id` | integer | English Wikipedia page id of the title's article. |
| `wp_title` | string | English Wikipedia article title, after following redirects. |
| `wp_url` | string | URL of the English Wikipedia article; its text is CC BY-SA 4.0, attribute it here. |
| `wp_description` | string | English Wikipedia's short description of the article. |
| `wp_extract` | string | Plain-text lead section of the English Wikipedia article. |
| `wp_length` | integer | Length of the English Wikipedia article in bytes of wikitext. |
| `wp_last_edited` | string | When the English Wikipedia article was last touched, as an ISO timestamp. |
| `wp_image_url` | string | URL of the article's lead image in its original size, from Wikimedia Commons. |
| `wp_wikidata_id` | string | The Wikidata item the English Wikipedia article is linked to. |
| `wp_is_disambiguation` | boolean | Whether the English Wikipedia page is a disambiguation page rather than an article about the title. |
| `franchise_id` | integer | TMDB movie collection identifier; null for TV or missing collection metadata. |
| `franchise` | string | TMDB movie collection name; null for TV or missing collection metadata. |
| `last_episode_id` | integer | TMDB last episode id for TV; null for movies or absent episode metadata. |
| `last_episode_name` | string | TMDB last episode name for TV; null for movies or absent episode metadata. |
| `last_episode_air_date` | date | TMDB last episode air date for TV; null for movies or absent episode metadata. |
| `last_episode_episode_number` | integer | TMDB last episode episode number for TV; null for movies or absent episode metadata. |
| `last_episode_season_number` | integer | TMDB last episode season number for TV; null for movies or absent episode metadata. |
| `next_episode_id` | integer | TMDB next episode id for TV; null for movies or absent episode metadata. |
| `next_episode_name` | string | TMDB next episode name for TV; null for movies or absent episode metadata. |
| `next_episode_air_date` | date | TMDB next episode air date for TV; null for movies or absent episode metadata. |
| `next_episode_episode_number` | integer | TMDB next episode episode number for TV; null for movies or absent episode metadata. |
| `next_episode_season_number` | integer | TMDB next episode season number for TV; null for movies or absent episode metadata. |

## Citing this dataset

Cite the dataset by name and canonical URL (https://mostlyright.md/datasets/movies-with-plot-summaries-and-ratings-since-1887), the table, and the immutable `version_id` the rows came from. A query response carries `table.version_id` and `table.content_digest`; a download carries a strong ETag and a `Content-Digest` header.