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

200 rows where "primaryTitle" is on date -4713-11-30

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

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