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
282 rows where "primaryTitle" is on date -4713-11-28
This data as json, CSV (advanced)
| Link | rowid ▼ | tconst | titleType | primaryTitle | originalTitle | isAdult | startYear | endYear | runtimeMinutes | genres |
|---|---|---|---|---|---|---|---|---|---|---|
| 160447 | 160447 | tt0176406 | short | 4 | 4 | 0 | 1998 | 10 | Drama,Short | |
| 300830 | 300830 | tt0335792 | short | 4 | 4 | 0 | 2001 | 14 | Short | |
| 350234 | 350234 | tt0389723 | short | 4 | 4 | 0 | 1995 | 10 | Short | |
| 397643 | 397643 | tt0445161 | movie | 4 | 4 | 0 | 2004 | 126 | Drama,Mystery,Sci-Fi | |
| 426769 | 426769 | tt0479578 | short | 4 | 4 | 0 | 2000 | 14 | Sci-Fi,Short | |
| 436166 | 436166 | tt0489625 | short | 4 | 4 | 0 | 2005 | 5 | Short | |
| 690411 | 690411 | tt0749644 | tvEpisode | 4.0 | 4.0 | 0 | 2005 | 41 | Action,Adventure,Crime | |
| 710683 | 710683 | tt0770598 | tvEpisode | 4 | 4 | 0 | 1968 | 28 | Family,Fantasy,Music | |
| 737168 | 737168 | tt0798404 | tvEpisode | 4. | 4. | 0 | 2004 | Drama,Family | ||
| 818637 | 818637 | tt0885791 | tvEpisode | 4 | 4 | 0 | 1971 | Comedy,Family | ||
| 824627 | 824627 | tt0892034 | short | 4 | 4 | 0 | 2005 | 14 | Sci-Fi,Short | |
| 949350 | 949350 | tt10042176 | tvEpisode | 04 | 04 | 0 | 2019 | 29 | Comedy,Documentary | |
| 960355 | 960355 | tt10062342 | tvEpisode | 4 | 4 | 0 | 2008 | Drama | ||
| 960372 | 960372 | tt10062370 | tvEpisode | 4 | 4 | 0 | 2011 | Drama | ||
| 960402 | 960402 | tt10062420 | tvEpisode | 4 | 4 | 0 | 2016 | Drama | ||
| 963923 | 963923 | tt10068890 | tvEpisode | 4 | 4 | 0 | 2005 | Comedy,Talk-Show | ||
| 970638 | 970638 | tt10081466 | tvEpisode | 4 | 4 | 0 | 2010 | Thriller | ||
| 992957 | 992957 | tt10122644 | tvEpisode | 04 | 04 | 0 | 1992 | Music | ||
| 1020459 | 1020459 | tt10173944 | tvEpisode | 4 | 4 | 0 | 2019 | Game-Show | ||
| 1066160 | 1066160 | tt10257204 | tvEpisode | 4 | 4 | 0 | 2019 | 56 | Crime,Drama,Thriller | |
| 1147785 | 1147785 | tt10408536 | short | 4 | 4 | 0 | 2018 | Music,Short | ||
| 1174394 | 1174394 | tt1045798 | movie | 4 | 4 | 0 | 2007 | 88 | Documentary,Music,Musical | |
| 1181080 | 1181080 | tt10470586 | tvEpisode | 4 | 4 | 0 | 2016 | Comedy | ||
| 1193575 | 1193575 | tt10493658 | tvEpisode | 4 | 4 | 0 | 1996 | Drama | ||
| 1256114 | 1256114 | tt10609396 | tvEpisode | 4 | 4 | 0 | Documentary | |||
| 1263503 | 1263503 | tt10623442 | short | 4.3 | 4.3 | 0 | 2019 | 11 | Short | |
| 1322716 | 1322716 | tt10731390 | tvEpisode | 4 | 4 | 0 | 2018 | Comedy,Drama,Romance | ||
| 1352746 | 1352746 | tt10786750 | tvEpisode | 4 | 4 | 0 | 2015 | Reality-TV,Sci-Fi | ||
| 1382018 | 1382018 | tt10840492 | tvEpisode | 4 | 4 | 0 | 2013 | Comedy | ||
| 1388197 | 1388197 | tt10852046 | tvEpisode | 004 | 004 | 0 | 2019 | Adventure,Animation,Drama | ||
| 1423310 | 1423310 | tt10916330 | tvEpisode | 4 | 4 | 0 | 2000 | Comedy | ||
| 1428962 | 1428962 | tt10927208 | tvEpisode | 4 | 4 | 0 | 2020 | 51 | Crime,Drama,Fantasy | |
| 1496972 | 1496972 | tt11053324 | tvEpisode | 4 | 4 | 0 | 2020 | Drama | ||
| 1548014 | 1548014 | tt11147924 | tvEpisode | 4 | 4 | 0 | 1972 | Animation,Comedy,Family | ||
| 1555229 | 1555229 | tt11161296 | tvEpisode | 4 | 4 | 0 | 2020 | Reality-TV | ||
| 1556442 | 1556442 | tt11163704 | tvEpisode | 4 | 4 | 0 | 2017 | Reality-TV | ||
| 1569593 | 1569593 | tt11188806 | tvEpisode | 4 | 4 | 0 | 2019 | Comedy | ||
| 1613659 | 1613659 | tt11274146 | tvEpisode | 4 | 4 | 0 | 2015 | Comedy | ||
| 1742247 | 1742247 | tt11518022 | tvEpisode | 4 | 4 | 0 | 2017 | Romance | ||
| 1764697 | 1764697 | tt11559622 | tvEpisode | 4 | 4 | 0 | 2008 | Documentary | ||
| 1810248 | 1810248 | tt1164419 | tvEpisode | 4 | 4 | 0 | 2005 | Comedy | ||
| 2053548 | 2053548 | tt12104004 | tvEpisode | 4 | 4 | 0 | 2017 | Crime,Drama,Sci-Fi | ||
| 2258574 | 2258574 | tt12498222 | tvEpisode | 4 | 4 | 0 | 2020 | Comedy | ||
| 2277088 | 2277088 | tt12534906 | tvEpisode | 4 | 4 | 0 | Comedy,Drama | |||
| 2299106 | 2299106 | tt12580648 | tvEpisode | 4 | 4 | 0 | 2020 | Documentary,Sport | ||
| 2336583 | 2336583 | tt12655846 | tvEpisode | 4 | 4 | 0 | 2020 | Talk-Show | ||
| 2363579 | 2363579 | tt12709714 | tvEpisode | 4. | 4. | 0 | 2020 | Horror | ||
| 2386467 | 2386467 | tt12753732 | tvEpisode | 4 | 4 | 0 | 2016 | Documentary | ||
| 2532695 | 2532695 | tt13033530 | tvEpisode | 4 | 4 | 0 | 2020 | Comedy | ||
| 2611202 | 2611202 | tt13180040 | tvEpisode | 4 | 4 | 0 | 1997 | Comedy | ||
| 2650327 | 2650327 | tt13254740 | tvEpisode | 04 | 04 | 0 | 2003 | Game-Show,Reality-TV | ||
| 2672347 | 2672347 | tt13297508 | tvEpisode | 4 | 4 | 0 | Romance | |||
| 2703719 | 2703719 | tt13358570 | movie | 4 | 4 | 0 | 2013 | 120 | Drama | |
| 2800417 | 2800417 | tt13545722 | tvEpisode | 4 | 4 | 0 | 2019 | Romance | ||
| 2959692 | 2959692 | tt13852956 | tvEpisode | 4 | 4 | 0 | Drama | |||
| 2967043 | 2967043 | tt13866568 | tvEpisode | 04 | 04 | 0 | 2021 | Crime,Thriller | ||
| 2995209 | 2995209 | tt13919872 | tvEpisode | 4 | 4 | 0 | 2019 | Drama | ||
| 3094859 | 3094859 | tt14105752 | tvEpisode | 4 | 4 | 0 | 2020 | Family | ||
| 3109299 | 3109299 | tt14133186 | short | 4 | 4 | 0 | 2021 | Music,Short | ||
| 3126207 | 3126207 | tt14164802 | tvEpisode | 4 | 4 | 0 | 2021 | Crime,Drama | ||
| 3176331 | 3176331 | tt14260478 | tvEpisode | 4 | 4 | 0 | 2021 | 28 | Comedy,Drama,Romance | |
| 3370783 | 3370783 | tt14629994 | tvEpisode | 4 | 4 | 0 | 2014 | Biography,Drama,History | ||
| 3414948 | 3414948 | tt14714064 | short | 4 | 4 | 0 | Horror,Short | |||
| 3416226 | 3416226 | tt1471683 | tvEpisode | 4 | 4 | 0 | 1980 | Comedy | ||
| 3544519 | 3544519 | tt14961508 | tvEpisode | 004 | 004 | 0 | 2021 | Talk-Show | ||
| 3585888 | 3585888 | tt15043116 | tvEpisode | 4.4 | 4.4 | 0 | 2022 | 50 | Biography,Drama | |
| 3620074 | 3620074 | tt15108634 | tvEpisode | 4 | 4 | 0 | 2020 | Drama | ||
| 3622902 | 3622902 | tt15114104 | tvEpisode | 4 | 4 | 0 | 2006 | Drama | ||
| 3652199 | 3652199 | tt15170658 | tvEpisode | 4 | 4 | 0 | Drama | |||
| 3730649 | 3730649 | tt1531967 | tvSeries | 4 | 4 | 0 | 2009 | 2010 | Drama | |
| 3883560 | 3883560 | tt15612900 | tvEpisode | 04 | 04 | 0 | 2021 | Short | ||
| 3884021 | 3884021 | tt15613890 | tvEpisode | 4 | 4 | 0 | 2021 | |||
| 3884040 | 3884040 | tt15613932 | tvEpisode | 4 | 4 | 0 | 2021 | |||
| 4019768 | 4019768 | tt15869624 | tvEpisode | 4 | 4 | 0 | 2013 | Reality-TV | ||
| 4155732 | 4155732 | tt16222322 | tvEpisode | 4 | 4 | 0 | 1977 | Action,Adventure,Animation | ||
| 4161951 | 4161951 | tt1623629 | short | 4 | 4 | 0 | 2009 | 17 | Short | |
| 4183370 | 4183370 | tt16281044 | tvEpisode | 4 | 4 | 0 | 1977 | Action,Adventure,Animation | ||
| 4328702 | 4328702 | tt16741126 | tvEpisode | 4 | 4 | 0 | 2021 | Reality-TV | ||
| 4398166 | 4398166 | tt17040100 | tvEpisode | 04 | 04 | 0 | 2018 | Drama | ||
| 4416643 | 4416643 | tt17080478 | tvEpisode | 4 | 4 | 0 | 2013 | Comedy | ||
| 4487826 | 4487826 | tt17508506 | tvEpisode | 4 | 4 | 0 | 2021 | Talk-Show | ||
| 4503894 | 4503894 | tt1756368 | short | 4 | 4 | 0 | 2009 | Drama,Short | ||
| 4529661 | 4529661 | tt17737202 | tvEpisode | 4 | 4 | 0 | Comedy | |||
| 4581273 | 4581273 | tt1813120 | short | 4 | 4 | 0 | 2011 | 7 | Drama,Horror,Short | |
| 4591138 | 4591138 | tt1820625 | video | 4 | 4 | 0 | 2010 | 4 | Animation,Fantasy,Music | |
| 4750981 | 4750981 | tt18932514 | tvEpisode | 4 | 4 | 0 | 2021 | Music,Reality-TV | ||
| 4870072 | 4870072 | tt19515794 | tvEpisode | 4 | 4 | 0 | 2023 | Thriller | ||
| 4915178 | 4915178 | tt1977597 | tvEpisode | 4 | 4 | 0 | 2010 | Drama | ||
| 5030184 | 5030184 | tt20318800 | tvEpisode | 4 | 4 | 0 | 2022 | Family | ||
| 5041499 | 5041499 | tt20413034 | tvEpisode | 4 | 4 | 0 | 2022 | |||
| 5067621 | 5067621 | tt2055570 | short | 4 | 4 | 0 | 2011 | 5 | Short,Thriller | |
| 5081601 | 5081601 | tt2063568 | short | 4 | 4 | 0 | 2011 | 10 | Drama,Short | |
| 5101891 | 5101891 | tt20764838 | tvEpisode | 4 | 4 | 0 | 2005 | Fantasy | ||
| 5260647 | 5260647 | tt21284254 | tvEpisode | 4 | 4 | 0 | 2019 | Drama,Romance | ||
| 5295084 | 5295084 | tt21365766 | short | 4 | 4 | 0 | 1 | Short | ||
| 5350128 | 5350128 | tt21610522 | tvEpisode | 4 | 4 | 0 | 2005 | Drama | ||
| 5751956 | 5751956 | tt2355471 | short | 4.0 | 4.0 | 0 | 2012 | 19 | Comedy,Drama,Short | |
| 5776071 | 5776071 | tt2368558 | tvEpisode | 4 | 4 | 0 | 24 | Thriller | ||
| 5987498 | 5987498 | tt2556840 | movie | 3.50 | 3.50 | 0 | 2013 | 107 | Crime,Drama,Thriller | |
| 6104358 | 6104358 | tt26575791 | movie | 4 | 4 | 0 | Drama |
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]);