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

2 rows where "primaryTitle" is on date -4709-11-26

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ tconst titleType primaryTitle originalTitle isAdult startYear endYear runtimeMinutes genres
1845394 1845394 tt11709812 tvEpisode 1463 1463 0 2010   26 Comedy,Drama,Romance
10290916 10290916 tt5758428 tvEpisode 1463 1463 0 2016     Drama

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