titles

Basic information about all titles (movies, TV shows, etc.)
tconst
Unique identifier
titleType
Type (movie, tvSeries, short, etc.)
primaryTitle
Main title
originalTitle
Original language title
startYear
Release year
endYear
End year (for TV series)
runtimeMinutes
Runtime in minutes
genres
Comma-separated genres

5 rows where "primaryTitle" is on date -4712-06-08

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ tconst titleType primaryTitle originalTitle isAdult startYear endYear runtimeMinutes genres
786891 786891 tt0851672 tvEpisode 197 197 0 1973     Comedy,Family
1524711 1524711 tt11104158 tvEpisode 197 197 0 2018     Comedy,News,Talk-Show
3701718 3701718 tt15264666 tvEpisode 197 197 0 1999     Drama
7637767 7637767 tt32758675 tvEpisode 197 197 0 2023      
8721036 8721036 tt37597762 tvEpisode 197 197 0 2025     Crime

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [titles] (
   [tconst] TEXT,
   [titleType] TEXT,
   [primaryTitle] TEXT,
   [originalTitle] TEXT,
   [isAdult] TEXT,
   [startYear] TEXT,
   [endYear] TEXT,
   [runtimeMinutes] TEXT,
   [genres] TEXT
);
CREATE UNIQUE INDEX [idx_titles_tconst]
    ON [titles] ([tconst]);
CREATE INDEX [idx_titles_primaryTitle]
    ON [titles] ([primaryTitle]);
CREATE INDEX [idx_titles_titleType]
    ON [titles] ([titleType]);
CREATE INDEX [idx_titles_startYear]
    ON [titles] ([startYear]);
CREATE INDEX [idx_titles_genres]
    ON [titles] ([genres]);