titles

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

54 rows where "primaryTitle" is on date -4712-03-05

✎ View and edit SQL

This data as json, CSV (advanced)

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