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

3 rows where "primaryTitle" is on date -4708-08-05

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ tconst titleType primaryTitle originalTitle isAdult startYear endYear runtimeMinutes genres
1437435 1437435 tt10943664 tvEpisode 1716 1716 0 2019     Drama
4821651 4821651 tt1932198 tvEpisode 1716 1716 0 2011   26 Comedy,Drama,Romance
10432855 10432855 tt6084726 tvEpisode 1716 1716 0 2016     Action,Adventure,News

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]);