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 -4707-06-18

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ tconst titleType primaryTitle originalTitle isAdult startYear endYear runtimeMinutes genres
2063469 2063469 tt12123354 tvEpisode 2033 2033 0 2012   26 Comedy,Drama,Romance
2148552 2148552 tt1228915 movie 2033 2033 0 2009   100 Adventure,Sci-Fi
2419319 2419319 tt12819720 movie 2033 2033 0       Action

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