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-10-03

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ tconst titleType primaryTitle originalTitle isAdult startYear endYear runtimeMinutes genres
8867095 8867095 tt3826660 tvEpisode 1409 1409 0 1975   28 Family,Fantasy,Music
10027354 10027354 tt5040576 tvEpisode 1409 1409 0 2015     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]);