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
1,605 rows where "primaryTitle" is on date -4713-11-25
This data as json, CSV (advanced)
| Link | rowid ▼ | tconst | titleType | primaryTitle | originalTitle | isAdult | startYear | endYear | runtimeMinutes | genres |
|---|---|---|---|---|---|---|---|---|---|---|
| 357396 | 357396 | tt0397851 | movie | 1 | 1 | 0 | 2004 | 89 | Documentary | |
| 366633 | 366633 | tt0408060 | movie | 1 | 1 | 0 | 2009 | 91 | Sci-Fi,Thriller | |
| 414149 | 414149 | tt0464881 | short | .999 | .999 | 0 | 2000 | 10 | Documentary,Short | |
| 462951 | 462951 | tt0518454 | tvEpisode | 1 | 1 | 0 | 2003 | Comedy | ||
| 513255 | 513255 | tt0569731 | tvEpisode | 1 | 1 | 0 | 1971 | Comedy,Family | ||
| 710698 | 710698 | tt0770591 | tvEpisode | 1 | 1 | 0 | 1968 | 28 | Family,Fantasy,Music | |
| 737188 | 737188 | tt0798401 | tvEpisode | 1. | 1. | 0 | 2004 | Drama,Family | ||
| 949367 | 949367 | tt10042162 | tvEpisode | 01 | 01 | 0 | 2019 | 31 | Comedy,Documentary | |
| 960359 | 960359 | tt10062296 | tvEpisode | 1 | 1 | 0 | 2016 | Drama | ||
| 960393 | 960393 | tt10062364 | tvEpisode | 1 | 1 | 0 | 2011 | Drama | ||
| 960416 | 960416 | tt10062402 | tvEpisode | 1 | 1 | 0 | 2016 | Drama | ||
| 970655 | 970655 | tt10081460 | tvEpisode | 1 | 1 | 0 | 2010 | Thriller | ||
| 1020462 | 1020462 | tt10173926 | tvEpisode | 1 | 1 | 0 | 2019 | Game-Show | ||
| 1061105 | 1061105 | tt10248144 | tvEpisode | 1 | 1 | 0 | 2019 | Crime,Drama,Thriller | ||
| 1086384 | 1086384 | tt10294580 | tvEpisode | 1.1 | 1.1 | 0 | 2018 | Comedy,Sport,Talk-Show | ||
| 1086399 | 1086399 | tt10294610 | tvEpisode | 1.2 | 1.2 | 0 | 2018 | Comedy,Sport,Talk-Show | ||
| 1099243 | 1099243 | tt10318714 | tvEpisode | 1.3 | 1.3 | 0 | 2018 | Comedy,Sport,Talk-Show | ||
| 1099258 | 1099258 | tt10318748 | tvEpisode | 1.4 | 1.4 | 0 | 2018 | Comedy,Sport,Talk-Show | ||
| 1145534 | 1145534 | tt10404436 | tvEpisode | 1.0 | 1.0 | 0 | 2017 | |||
| 1147702 | 1147702 | tt10408416 | short | 1 | 1 | 0 | 2018 | Music,Short | ||
| 1166092 | 1166092 | tt1044252 | tvEpisode | 1.28 | 1.28 | 0 | 2007 | 24 | Animation,Crime,Drama | |
| 1195043 | 1195043 | tt10496456 | tvEpisode | 1.23 | 1.23 | 0 | 1985 | Talk-Show | ||
| 1202635 | 1202635 | tt10510436 | tvEpisode | 1.1 | 1.1 | 0 | 2010 | Game-Show | ||
| 1209493 | 1209493 | tt10523120 | tvEpisode | 1.31 | 1.31 | 0 | 2012 | Drama | ||
| 1225784 | 1225784 | tt10553252 | tvEpisode | 1 | 1 | 0 | 2019 | Talk-Show | ||
| 1256112 | 1256112 | tt10609462 | tvEpisode | 1 | 1 | 0 | Documentary | |||
| 1307297 | 1307297 | tt10703942 | tvEpisode | 1 | 1 | 0 | Comedy | |||
| 1322658 | 1322658 | tt10731370 | tvEpisode | 1 | 1 | 0 | 2018 | Comedy,Drama,Romance | ||
| 1339241 | 1339241 | tt10761572 | tvEpisode | 01 | 01 | 0 | 2017 | 44 | Documentary | |
| 1342695 | 1342695 | tt10768080 | tvEpisode | 1.3 | 1.3 | 0 | 2019 | Comedy | ||
| 1361908 | 1361908 | tt10803986 | tvEpisode | 1 | 1 | 0 | 2016 | Family | ||
| 1381938 | 1381938 | tt10840478 | tvEpisode | 1 | 1 | 0 | 2013 | Comedy | ||
| 1388111 | 1388111 | tt10852024 | tvEpisode | 001 | 001 | 0 | 2019 | Adventure,Animation,Drama | ||
| 1423175 | 1423175 | tt10916320 | tvEpisode | 1 | 1 | 0 | 2000 | Comedy | ||
| 1428828 | 1428828 | tt10927198 | tvEpisode | 1 | 1 | 0 | 2020 | 47 | Crime,Drama,Fantasy | |
| 1453444 | 1453444 | tt10974590 | tvEpisode | 1 | 1 | 0 | 2016 | Crime | ||
| 1453467 | 1453467 | tt10974648 | tvEpisode | 1 | 1 | 0 | 2017 | Crime | ||
| 1470492 | 1470492 | tt11005892 | tvEpisode | 1 | 1 | 0 | Biography | |||
| 1496826 | 1496826 | tt11053316 | tvEpisode | 1 | 1 | 0 | 2020 | Drama | ||
| 1502646 | 1502646 | tt11063828 | tvEpisode | 1 | 1 | 0 | 2019 | Comedy | ||
| 1503530 | 1503530 | tt11065378 | tvEpisode | 1 | 1 | 0 | 2019 | Thriller | ||
| 1521159 | 1521159 | tt11097862 | tvEpisode | 1 | 1 | 0 | 1972 | Animation,Comedy,Family | ||
| 1523030 | 1523030 | tt11101310 | tvEpisode | 1 | 1 | 0 | 2019 | Comedy | ||
| 1523983 | 1523983 | tt11103148 | tvEpisode | 1 | 1 | 0 | 2019 | Comedy,Fantasy | ||
| 1543427 | 1543427 | tt11139678 | tvEpisode | 1 | 1 | 0 | 2019 | Action | ||
| 1555066 | 1555066 | tt11161286 | tvEpisode | 1 | 1 | 0 | 2020 | Reality-TV | ||
| 1556284 | 1556284 | tt11163702 | tvEpisode | 1 | 1 | 0 | 2017 | Reality-TV | ||
| 1605011 | 1605011 | tt11257902 | tvEpisode | 1 | 1 | 0 | 2013 | Comedy,Drama | ||
| 1613499 | 1613499 | tt11274140 | tvEpisode | 1 | 1 | 0 | 2015 | Comedy | ||
| 1691621 | 1691621 | tt11423222 | tvEpisode | 1 | 1 | 0 | 2019 | Drama,Thriller | ||
| 1745472 | 1745472 | tt11524298 | tvEpisode | 1 | 1 | 0 | Documentary | |||
| 1764503 | 1764503 | tt11559614 | tvEpisode | 1 | 1 | 0 | 2008 | Documentary | ||
| 1799056 | 1799056 | tt11623830 | tvEpisode | 1 | 1 | 0 | Drama | |||
| 1804820 | 1804820 | tt11634466 | tvEpisode | 1 | 1 | 0 | Comedy,Sci-Fi | |||
| 1810032 | 1810032 | tt1164416 | tvEpisode | 1 | 1 | 0 | 2005 | Comedy | ||
| 1811619 | 1811619 | tt11647250 | tvEpisode | 1 | 1 | 0 | 2019 | Family | ||
| 1906998 | 1906998 | tt11826282 | tvEpisode | 1 | 1 | 0 | 2015 | Romance | ||
| 1908190 | 1908190 | tt11828694 | short | 01 | 01 | 0 | 2006 | 5 | Short | |
| 1921225 | 1921225 | tt11853476 | tvEpisode | 1 | 1 | 0 | Comedy | |||
| 1955704 | 1955704 | tt11918590 | tvEpisode | 1 | 1 | 0 | 2018 | Crime | ||
| 1964638 | 1964638 | tt11935330 | tvEpisode | 1 | 1 | 0 | 2016 | Drama | ||
| 1970483 | 1970483 | tt11946166 | tvEpisode | 1 | 1 | 0 | 2012 | |||
| 1970489 | 1970489 | tt11946178 | tvEpisode | 1 | 1 | 0 | 2012 | Drama | ||
| 1986122 | 1986122 | tt11975852 | tvEpisode | 1 | 1 | 0 | 2016 | Mystery | ||
| 2052961 | 2052961 | tt12103392 | tvEpisode | 1 | 1 | 0 | 2017 | Crime,Drama,Sci-Fi | ||
| 2083681 | 2083681 | tt12162990 | tvEpisode | 1 | 1 | 0 | 2019 | Comedy | ||
| 2165448 | 2165448 | tt12320742 | short | 1 | 1 | 0 | 2017 | Crime,Short | ||
| 2178193 | 2178193 | tt12344426 | tvEpisode | 1 | 1 | 0 | 2020 | Talk-Show | ||
| 2210074 | 2210074 | tt12404826 | tvEpisode | 1 | 1 | 0 | 2019 | Family,Game-Show | ||
| 2216123 | 2216123 | tt12416666 | tvEpisode | 1. | 1. | 0 | 2020 | Horror | ||
| 2219598 | 2219598 | tt12423348 | tvEpisode | 1 | 1 | 0 | 2020 | Drama | ||
| 2234116 | 2234116 | tt12452464 | tvEpisode | 1 | 1 | 0 | 1990 | Fantasy | ||
| 2251672 | 2251672 | tt12485508 | tvEpisode | 1 | 1 | 0 | 2020 | Comedy | ||
| 2255226 | 2255226 | tt12492214 | tvEpisode | 1 | 1 | 0 | 2019 | |||
| 2276793 | 2276793 | tt12534886 | tvEpisode | 1 | 1 | 0 | 1985 | Comedy,Drama | ||
| 2298752 | 2298752 | tt12580546 | tvEpisode | 1 | 1 | 0 | 2020 | Documentary,Sport | ||
| 2349181 | 2349181 | tt12681732 | tvEpisode | 1 | 1 | 0 | 2020 | Drama | ||
| 2369983 | 2369983 | tt12722392 | tvEpisode | 1 | 1 | 0 | Action,Animation,Comedy | |||
| 2386149 | 2386149 | tt12753718 | tvEpisode | 1 | 1 | 0 | 2016 | Documentary | ||
| 2399768 | 2399768 | tt12780240 | tvEpisode | 1 | 1 | 0 | Action,Adventure,Animation | |||
| 2417425 | 2417425 | tt12816262 | tvEpisode | 1 | 1 | 0 | 2020 | Mystery | ||
| 2448039 | 2448039 | tt12874632 | tvEpisode | 1.1 | 1.1 | 0 | ||||
| 2497512 | 2497512 | tt12968046 | tvEpisode | 1 | 1 | 0 | 2006 | Comedy,Family,Game-Show | ||
| 2539071 | 2539071 | tt13046870 | tvEpisode | 1 | 1 | 0 | 2020 | Drama,Romance | ||
| 2544400 | 2544400 | tt13056420 | short | 1 | 1 | 0 | 2022 | 19 | Drama,Short | |
| 2551544 | 2551544 | tt13069974 | tvEpisode | 1 | 1 | 0 | 2020 | Comedy | ||
| 2610722 | 2610722 | tt13179784 | tvEpisode | 1 | 1 | 0 | 2014 | Biography,Drama,History | ||
| 2610841 | 2610841 | tt13180014 | tvEpisode | 1 | 1 | 0 | 1997 | Comedy | ||
| 2621015 | 2621015 | tt13199330 | short | 1.17 | 1.17 | 0 | 1999 | 16 | Documentary,Short | |
| 2649971 | 2649971 | tt13254730 | tvEpisode | 01 | 01 | 0 | 2003 | Game-Show,Reality-TV | ||
| 2685323 | 2685323 | tt13323718 | tvEpisode | 1 | 1 | 0 | 2019 | Comedy,Drama,Romance | ||
| 2745233 | 2745233 | tt13439330 | tvEpisode | 1 | 1 | 0 | 2020 | Talk-Show | ||
| 2799899 | 2799899 | tt13545628 | tvEpisode | 1 | 1 | 0 | 2019 | Romance | ||
| 2874799 | 2874799 | tt13689588 | tvEpisode | 1 | 1 | 0 | 2018 | Reality-TV | ||
| 2911496 | 2911496 | tt13761244 | tvEpisode | 1 | 1 | 0 | 2019 | Drama | ||
| 2918068 | 2918068 | tt13774202 | tvEpisode | 1 | 1 | 0 | 2014 | Drama | ||
| 2959502 | 2959502 | tt13853540 | tvEpisode | 01 | 01 | 0 | 2021 | Crime,Thriller | ||
| 2993803 | 2993803 | tt13918094 | tvEpisode | 1 | 1 | 0 | 2020 | Thriller | ||
| 3012816 | 3012816 | tt13953404 | tvEpisode | 1 | 1 | 0 | Action,Crime,Drama | |||
| 3013774 | 3013774 | tt13955134 | short | 1 | 1 | 0 | 2001 | 3 | Short |
Advanced export
JSON shape: default, array, newline-delimited
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]);