media_type
stringWhether the title is a movie or a TV show: 'movie' or 'tv'. Part of the grain, because TMDB movie and TV ids overlap.
No distribution published
- Valid
- —
- Missing
- —
- Distinct
- —
773 MB across 1,609 parts, newest sealed 4 October 2026 at 21:43 UTC.
The first build wrote 1,609 parts and 1.3M rows.
GRAIN_UNIQUE passed.
Whether the title is a movie or a TV show: 'movie' or 'tv'. Part of the grain, because TMDB movie and TV ids overlap.
No distribution published
For a movie, its primary release date; for a TV show, its first air date; as TMDB records it.
No distribution published
TMDB's numeric identifier for the movie or TV show; unique only together with media_type.
No distribution published
The movie's or show's title in English where TMDB has one.
No distribution published
The movie's or show's title in its original language.
No distribution published
The ISO 639-1 code of the movie's original language.
No distribution published
TMDB's short English plot summary of the movie.
No distribution published
Up to five TMDB genres, comma-separated, in TMDB's order.
No distribution published
TMDB's popularity score at the time the movie's month was last fetched.
No distribution published
The average TMDB user rating, from 0 to 10.
No distribution published
How many TMDB users rated the movie.
No distribution published
A link to the movie's poster image on TMDB's image server.
No distribution published
Whether TMDB marks the title as adult.
No distribution published
A link to the movie's backdrop image on TMDB's image server.
No distribution published
Whether TMDB marks this Discover row as a video title.
No distribution published
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.
No distribution published
Uncalibrated JEV score for emoji_1; retained only in [0.5,1]. This is not an empirical event probability.
No distribution published
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.
No distribution published
Uncalibrated JEV score for emoji_2; retained only in [0.5,1]. This is not an empirical event probability.
No distribution published
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.
No distribution published
Uncalibrated JEV score for emoji_3; retained only in [0.5,1]. This is not an empirical event probability.
No distribution published
Served JEV model identifier for the answer inferred from available title, overview, tagline, genre and keyword metadata; null when no answer exists.
No distribution published
JEV inferred mood 1 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred mood 2 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred tone browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred setting 1 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred setting 2 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred era feel browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred audience browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred narrative browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred trope 1 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
JEV inferred trope 2 browse tag from the supplied title description and explicit metadata; unknown or out-of-taxonomy answers remain null.
No distribution published
Served JEV model identifier for the answer inferred from available title, overview, tagline, genre and keyword metadata; null when no answer exists.
No distribution published
Stable joined tag string for embedding ingest (axis:value pairs).
No distribution published
Directors, comma-separated in billing order; for TV, every director TMDB credits across the show's episodes.
No distribution published
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, or the complete crew for movies with at least 20 TMDB votes.
No distribution published
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 movies with at least 20 TMDB votes.
No distribution published
The first ten billed cast members as a JSON array of objects with name and character, in TMDB billing order.
No distribution published
The billed cast as a JSON array of objects with name and character, in TMDB billing order, cut at the first 20.
No distribution published
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 first 100 crew credits, or the complete crew for movies with at least 20 TMDB votes.
No distribution published
Movie production budget in US dollars as TMDB records it; always NULL for TV.
No distribution published
Movie worldwide box office revenue in US dollars as TMDB records it; always NULL for TV.
No distribution published
Movie running time in minutes; for TV, the first typical episode run time in minutes.
No distribution published
The movie's English tagline on TMDB.
No distribution published
Up to the first 30 TMDB keywords as a JSON array of strings, in TMDB's order.
No distribution published
Up to five production company names as a JSON array of strings, in TMDB's order.
No distribution published
Up to five production countries as a JSON array of ISO 3166-1 alpha-2 codes.
No distribution published
Up to five spoken languages as a JSON array of ISO 639-1 codes.
No distribution published
The US age certification, such as PG-13 or R, preferring the theatrical release. Null where TMDB records none.
No distribution published
The age certification in each country as a JSON object keyed by ISO 3166-1 code, preferring each country's theatrical release.
No distribution published
Movies only: JSON list of premium formats (IMAX, Dolby Cinema, 4DX, ScreenX, 3D) the release was shown in; NULL for TV.
No distribution published
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 TMDB votes are read from their first 14 videos.
No distribution published
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, flatrate, rent and buy. Data from JustWatch via TMDB.
No distribution published
Up to ten alternative titles as a JSON array of objects with country and title.
No distribution published
TMDB ids of the first 15 movies TMDB recommends alongside this one, as a JSON array of integers.
No distribution published
TMDB ids of the first 15 movies TMDB lists as similar, as a JSON array of integers.
No distribution published
The movie's IMDb identifier, such as tt0137523.
No distribution published
The movie's Wikidata item identifier, such as Q190050.
No distribution published
The movie's official website as TMDB records it.
No distribution published
A link to the movie's first English title logo on TMDB's image server.
No distribution published
TMDB's production status: for movies e.g. Released or Post Production, for TV e.g. Returning Series, Ended or Canceled.
No distribution published
JSON list of ISO 3166-1 country codes TMDB gives as the title's country of origin.
No distribution published
TV only: the date the show's first episode aired, as TMDB records it (equal to release_date for TV rows).
No distribution published
TV only: the air date of the most recent episode TMDB lists for the show.
No distribution published
TV only: whether TMDB marks the show as still in production.
No distribution published
TV only: TMDB's show type, e.g. Scripted, Reality, Documentary, Miniseries, Talk Show or News.
No distribution published
TV only: the total number of episodes TMDB counts for the show.
No distribution published
TV only: the number of seasons TMDB counts for the show (specials excluded).
No distribution published
TV only: JSON list of typical episode run times in minutes, as TMDB states them.
No distribution published
TV only: JSON list of ISO 639-1 language codes the show is produced in.
No distribution published
TV only: JSON list of the networks that aired the show, each with its name and country.
No distribution published
TV only: JSON list of the show's creators' names.
No distribution published
TV only: JSON list with one summary per season (season number, name, first air date, episode count); season 0 holds specials.
No distribution published
TV only: JSON list of the ISO 639-1 languages TMDB holds a translation of the show's text in.
No distribution published
TV only: the show's TheTVDB series id, from TMDB's external ids.
No distribution published
TV only: the show's Freebase machine id (/m/...), from TMDB's external ids.
No distribution published
TV only: the show's Freebase topic id, from TMDB's external ids.
No distribution published
TV only: the show's retired TVRage id, from TMDB's external ids.
No distribution published
The title's Facebook page handle, from TMDB's external ids.
No distribution published
The title's Instagram handle, from TMDB's external ids.
No distribution published
The title's X (Twitter) handle, from TMDB's external ids.
No distribution published
The Wikidata item id (Q-number) this row's Wikidata columns were read from.
No distribution published
The English label of the title's Wikidata item.
No distribution published
The English short description of the title's Wikidata item.
No distribution published
JSON list of up to five English aliases of the title's Wikidata item.
No distribution published
JSON list of Wikidata Q-ids of the title's what kind of work the item is (P31), e.g. film or television series.
No distribution published
JSON list of Wikidata Q-ids of the title's genres (P136).
No distribution published
JSON list of Wikidata Q-ids of the title's countries of origin (P495).
No distribution published
JSON list of Wikidata Q-ids of the title's original languages (P364).
No distribution published
JSON list of Wikidata Q-ids of the title's directors (P57).
No distribution published
JSON list of Wikidata Q-ids of the title's screenwriters (P58).
No distribution published
JSON list of Wikidata Q-ids of the title's cast members (P161).
No distribution published
JSON list of Wikidata Q-ids of the title's composers (P86).
No distribution published
JSON list of Wikidata Q-ids of the title's directors of photography (P344).
No distribution published
JSON list of Wikidata Q-ids of the title's film editors (P1040).
No distribution published
JSON list of Wikidata Q-ids of the title's producers (P162).
No distribution published
JSON list of Wikidata Q-ids of the title's executive producers (P1431).
No distribution published
JSON list of Wikidata Q-ids of the title's production companies (P272).
No distribution published
JSON list of Wikidata Q-ids of the title's distributors (P750).
No distribution published
JSON list of Wikidata Q-ids of the title's awards received (P166).
No distribution published
JSON list of Wikidata Q-ids of the title's award nominations (P1411).
No distribution published
JSON list of Wikidata Q-ids of the title's narrative locations (P840).
No distribution published
JSON list of Wikidata Q-ids of the title's filming locations (P915).
No distribution published
JSON list of Wikidata Q-ids of the title's main subjects (P921).
No distribution published
JSON list of Wikidata Q-ids of the title's works it is based on (P144).
No distribution published
JSON list of Wikidata Q-ids of the title's series it belongs to (P179).
No distribution published
JSON list of Wikidata Q-ids of the title's larger works it is part of (P361).
No distribution published
JSON list of Wikidata Q-ids of the title's media franchises (P8345).
No distribution published
JSON list of Wikidata Q-ids of the title's original broadcasters (P449).
No distribution published
JSON list of Wikidata Q-ids of the title's creators (P170).
No distribution published
JSON list of Wikidata Q-ids of the title's distribution formats (P437).
No distribution published
JSON list of Wikidata Q-ids of the title's characters (P674).
No distribution published
JSON list of Wikidata Q-ids of the title's costume designers (P2515).
No distribution published
JSON list of Wikidata Q-ids of the title's production designers (P2554).
No distribution published
Wikidata Q-id of the title this one follows in its series (P155).
No distribution published
Wikidata Q-id of the title that follows this one in its series (P156).
No distribution published
Wikidata Q-id of the title's MPA film rating (P1657).
No distribution published
Wikidata Q-id of the title's German FSK rating (P1981).
No distribution published
Wikidata Q-id of the title's colour process, e.g. colour or black-and-white (P462).
No distribution published
Box office gross from Wikidata's first stated value (P2142), in the currency named by wd_box_office_currency.
No distribution published
Wikidata Q-id of the currency of wd_box_office, e.g. Q4917 for US dollars.
No distribution published
Production cost from Wikidata's first stated value (P2130), in the currency named by wd_cost_currency.
No distribution published
Wikidata Q-id of the currency of wd_cost, e.g. Q4917 for US dollars.
No distribution published
Running time in minutes from Wikidata's first stated duration (P2047), converted from hours where needed.
No distribution published
Number of episodes Wikidata states for the title (P1113).
No distribution published
Number of seasons Wikidata states for the title (P2437).
No distribution published
JSON list of up to three publication or release dates Wikidata states (P577), as YYYY-MM-DD with 00 for unknown month or day.
No distribution published
The title's start date on Wikidata (P580), typically a show's first broadcast, as YYYY-MM-DD.
No distribution published
The title's end date on Wikidata (P582), typically a show's last broadcast, as YYYY-MM-DD.
No distribution published
The title in its original language as Wikidata records it (P1476).
No distribution published
The title's IMDb identifier as Wikidata records it.
No distribution published
The title's TMDB movie identifier as Wikidata records it.
No distribution published
The title's TMDB TV identifier as Wikidata records it.
No distribution published
The title's TheTVDB identifier as Wikidata records it.
No distribution published
The title's Rotten Tomatoes identifier as Wikidata records it.
No distribution published
The title's Metacritic identifier as Wikidata records it.
No distribution published
The title's Letterboxd identifier as Wikidata records it.
No distribution published
The title's Box Office Mojo identifier as Wikidata records it.
No distribution published
The title's AlloCiné identifier as Wikidata records it.
No distribution published
The title's Netflix identifier as Wikidata records it.
No distribution published
The title's Kinopoisk identifier as Wikidata records it.
No distribution published
The title's FilmAffinity identifier as Wikidata records it.
No distribution published
The title's Filmweb identifier as Wikidata records it.
No distribution published
The title's ČSFD identifier as Wikidata records it.
No distribution published
The title's AllMovie identifier as Wikidata records it.
No distribution published
The title's Freebase identifier as Wikidata records it.
No distribution published
The title's X (Twitter) username identifier as Wikidata records it.
No distribution published
The title's Instagram username identifier as Wikidata records it.
No distribution published
The title's Facebook identifier as Wikidata records it.
No distribution published
The title's Apple TV movie identifier as Wikidata records it.
No distribution published
The title's Apple TV show identifier as Wikidata records it.
No distribution published
The title's ISAN identifier as Wikidata records it.
No distribution published
JSON object of the title's Wikipedia article titles by wiki (enwiki, dewiki, frwiki, eswiki, itwiki, jawiki, ruwiki, zhwiki, cswiki, ptwiki, plwiki, kowiki).
No distribution published
URL of the title's English Wikipedia article, from its Wikidata sitelink.
No distribution published
English Wikipedia page id of the title's article.
No distribution published
English Wikipedia article title, after following redirects.
No distribution published
URL of the English Wikipedia article; its text is CC BY-SA 4.0, attribute it here.
No distribution published
English Wikipedia's short description of the article.
No distribution published
Plain-text lead section of the English Wikipedia article.
No distribution published
Length of the English Wikipedia article in bytes of wikitext.
No distribution published
When the English Wikipedia article was last touched, as an ISO timestamp.
No distribution published
URL of the article's lead image in its original size, from Wikimedia Commons.
No distribution published
The Wikidata item the English Wikipedia article is linked to.
No distribution published
Whether the English Wikipedia page is a disambiguation page rather than an article about the title.
No distribution published
TMDB movie collection identifier; null for TV or missing collection metadata.
No distribution published
TMDB movie collection name; null for TV or missing collection metadata.
No distribution published
TMDB last episode id for TV; null for movies or absent episode metadata.
No distribution published
TMDB last episode name for TV; null for movies or absent episode metadata.
No distribution published
TMDB last episode air date for TV; null for movies or absent episode metadata.
No distribution published
TMDB last episode episode number for TV; null for movies or absent episode metadata.
No distribution published
TMDB last episode season number for TV; null for movies or absent episode metadata.
No distribution published
TMDB next episode id for TV; null for movies or absent episode metadata.
No distribution published
TMDB next episode name for TV; null for movies or absent episode metadata.
No distribution published
TMDB next episode air date for TV; null for movies or absent episode metadata.
No distribution published
TMDB next episode episode number for TV; null for movies or absent episode metadata.
No distribution published
TMDB next episode season number for TV; null for movies or absent episode metadata.
No distribution published