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
129 rows where "primaryTitle" is on date -4713-12-03
This data as json, CSV (advanced)
| Link | rowid ▼ | tconst | titleType | primaryTitle | originalTitle | isAdult | startYear | endYear | runtimeMinutes | genres |
|---|---|---|---|---|---|---|---|---|---|---|
| 172119 | 172119 | tt0191312 | videoGame | 9 | 9 | 0 | 1996 | Adventure,Fantasy,Mystery | ||
| 306350 | 306350 | tt0342012 | movie | 9 | 9 | 0 | 2002 | 91 | Crime,Drama,Mystery | |
| 396271 | 396271 | tt0443424 | short | 9 | 9 | 0 | 2005 | 11 | Adventure,Animation,Family | |
| 420154 | 420154 | tt0472033 | movie | 9 | 9 | 0 | 2009 | 79 | Action,Adventure,Animation | |
| 710624 | 710624 | tt0770602 | tvEpisode | 9 | 9 | 0 | 1968 | 28 | Family,Fantasy,Music | |
| 818550 | 818550 | tt0885796 | tvEpisode | 9 | 9 | 0 | 1971 | Comedy,Family | ||
| 960210 | 960210 | tt10062278 | tvEpisode | 9 | 9 | 0 | 2014 | Drama | ||
| 960235 | 960235 | tt10062326 | tvEpisode | 9 | 9 | 0 | 2016 | Drama | ||
| 960248 | 960248 | tt10062352 | tvEpisode | 9 | 9 | 0 | 2008 | Drama | ||
| 960268 | 960268 | tt10062386 | tvEpisode | 9 | 9 | 0 | 2011 | Drama | ||
| 960299 | 960299 | tt10062438 | tvEpisode | 9 | 9 | 0 | 2016 | Drama | ||
| 963898 | 963898 | tt10069052 | tvEpisode | 9 | 9 | 0 | 2006 | Comedy,Talk-Show | ||
| 992846 | 992846 | tt10122662 | tvEpisode | 09 | 09 | 0 | 1992 | Music | ||
| 1020365 | 1020365 | tt10174018 | tvEpisode | 9 | 9 | 0 | 2019 | Game-Show | ||
| 1134586 | 1134586 | tt10384302 | tvEpisode | 9 | 9 | 0 | Reality-TV | |||
| 1181004 | 1181004 | tt10470800 | tvEpisode | 9 | 9 | 0 | 2017 | Comedy | ||
| 1195539 | 1195539 | tt10497612 | tvEpisode | 9 | 9 | 0 | 1996 | Drama | ||
| 1255936 | 1255936 | tt10609448 | tvEpisode | 9 | 9 | 0 | Documentary | |||
| 1356908 | 1356908 | tt10795298 | short | 9 | 9 | 0 | 2015 | 8 | Short,Thriller | |
| 1381777 | 1381777 | tt10840512 | tvEpisode | 9 | 9 | 0 | 2013 | Comedy | ||
| 1423007 | 1423007 | tt10916346 | tvEpisode | 9 | 9 | 0 | 2000 | Comedy | ||
| 1482628 | 1482628 | tt11028210 | short | 8.5 | 8.5 | 0 | Biography,Documentary,Short | |||
| 1547662 | 1547662 | tt11147934 | tvEpisode | 9 | 9 | 0 | 1972 | Animation,Comedy,Family | ||
| 1554880 | 1554880 | tt11161318 | tvEpisode | 9 | 9 | 0 | 2020 | Reality-TV | ||
| 1613305 | 1613305 | tt11274164 | tvEpisode | 9 | 9 | 0 | 2015 | Comedy | ||
| 1693700 | 1693700 | tt11427236 | tvEpisode | 9 | 9 | 0 | 2019 | Talk-Show | ||
| 2053086 | 2053086 | tt12104032 | tvEpisode | 9 | 9 | 0 | 2017 | Crime,Drama,Sci-Fi | ||
| 2276571 | 2276571 | tt12534934 | tvEpisode | 9 | 9 | 0 | Comedy,Drama | |||
| 2346549 | 2346549 | tt12677218 | tvEpisode | 9 | 9 | 0 | 2019 | 14 | Animation,Comedy,Horror | |
| 2385277 | 2385277 | tt12752332 | tvEpisode | 9 | 9 | 0 | 2017 | Comedy | ||
| 2396524 | 2396524 | tt12774378 | tvEpisode | 09 | 09 | 0 | Animation | |||
| 2457353 | 2457353 | tt12893098 | tvEpisode | 9. | 9. | 0 | 2020 | Horror | ||
| 2614153 | 2614153 | tt13186768 | tvEpisode | 9 | 9 | 0 | 1997 | Comedy | ||
| 2624189 | 2624189 | tt13205774 | short | 9 | 9 | 0 | 2020 | Music,Short | ||
| 2649688 | 2649688 | tt13254752 | tvEpisode | 09 | 09 | 0 | 2003 | Game-Show,Reality-TV | ||
| 2801573 | 2801573 | tt13549312 | tvEpisode | 9 | 9 | 0 | 2019 | Romance | ||
| 2928285 | 2928285 | tt13795402 | tvEpisode | 9 | 9 | 0 | 2021 | 18 | Comedy | |
| 3094083 | 3094083 | tt14105866 | tvEpisode | 9 | 9 | 0 | 2020 | Family | ||
| 3175491 | 3175491 | tt14260504 | tvEpisode | 9 | 9 | 0 | 2021 | 29 | Comedy,Drama,Romance | |
| 3199934 | 3199934 | tt1430606 | short | 9 | 9 | 0 | 2009 | 9 | Comedy,Drama,Short | |
| 3369933 | 3369933 | tt14630144 | tvEpisode | 9 | 9 | 0 | 2014 | Biography,Drama,History | ||
| 3540459 | 3540459 | tt14955196 | tvEpisode | 009 | 009 | 0 | 2020 | Adventure,Animation,Drama | ||
| 3619097 | 3619097 | tt15108656 | tvEpisode | 9 | 9 | 0 | 2020 | Drama | ||
| 3621920 | 3621920 | tt15114118 | tvEpisode | 9 | 9 | 0 | 2006 | Drama | ||
| 3802467 | 3802467 | tt15462052 | movie | 9 | 9 | 0 | 2021 | 105 | Drama | |
| 3844727 | 3844727 | tt1554412 | short | 009 | 009 | 0 | 2008 | 23 | Action,Short | |
| 3882519 | 3882519 | tt15612924 | tvEpisode | 09 | 09 | 0 | 2021 | Short | ||
| 3882974 | 3882974 | tt15613900 | tvEpisode | 9 | 9 | 0 | 2021 | |||
| 4173352 | 4173352 | tt16263174 | tvEpisode | 9 | 9 | 0 | 1977 | 25 | Action,Adventure,Animation | |
| 4397109 | 4397109 | tt17040226 | tvEpisode | 09 | 09 | 0 | 2018 | Drama | ||
| 4415525 | 4415525 | tt17080498 | tvEpisode | 9 | 9 | 0 | 2015 | Comedy | ||
| 5028959 | 5028959 | tt20318810 | tvEpisode | 9 | 9 | 0 | 2022 | Family | ||
| 5591509 | 5591509 | tt2263281 | tvEpisode | 9 | 9 | 0 | 2009 | Talk-Show | ||
| 5774599 | 5774599 | tt2368574 | tvEpisode | 9 | 9 | 0 | 24 | Thriller | ||
| 6394627 | 6394627 | tt27675656 | tvEpisode | 009 | 009 | 0 | 2023 | Talk-Show | ||
| 6531338 | 6531338 | tt28141889 | tvEpisode | 9 | 9 | 0 | 2008 | Comedy | ||
| 6645942 | 6645942 | tt28526933 | tvEpisode | 9 | 9 | 0 | Mystery | |||
| 6689325 | 6689325 | tt28672293 | tvEpisode | 8.5 | 8.5 | 0 | 1998 | Game-Show,Music | ||
| 6689326 | 6689326 | tt28672295 | tvEpisode | 8.6 | 8.6 | 0 | 1999 | Game-Show,Music | ||
| 6689328 | 6689328 | tt28672297 | tvEpisode | 8.7 | 8.7 | 0 | 1999 | Game-Show,Music | ||
| 6689330 | 6689330 | tt28672299 | tvEpisode | 8.8 | 8.8 | 0 | 1999 | Game-Show,Music | ||
| 6689332 | 6689332 | tt28672303 | tvEpisode | 8.9 | 8.9 | 0 | 1999 | Game-Show,Music | ||
| 6689334 | 6689334 | tt28672306 | tvEpisode | 9.1 | 9.1 | 0 | 1999 | Game-Show,Music | ||
| 6689335 | 6689335 | tt28672307 | tvEpisode | 9.2 | 9.2 | 0 | 1999 | Game-Show,Music | ||
| 6689336 | 6689336 | tt28672310 | tvEpisode | 9.3 | 9.3 | 0 | 1999 | Game-Show,Music | ||
| 6689337 | 6689337 | tt28672311 | tvEpisode | 9.4 | 9.4 | 0 | 1999 | Game-Show,Music | ||
| 6722991 | 6722991 | tt28789574 | tvEpisode | 9.29 | 9.29 | 0 | Adventure,Drama,News | |||
| 6837476 | 6837476 | tt29368446 | tvEpisode | 9 | 9 | 0 | 2023 | Game-Show | ||
| 7011967 | 7011967 | tt3020402 | tvEpisode | 9 | 9 | 0 | 2009 | Documentary | ||
| 7143369 | 7143369 | tt30796715 | tvEpisode | 9 | 9 | 0 | 2024 | Action,Comedy | ||
| 7146227 | 7146227 | tt30802979 | tvEpisode | 9. | 9. | 0 | 2010 | |||
| 7388076 | 7388076 | tt31961168 | tvEpisode | 9.1 | 9.1 | 0 | 2024 | Reality-TV | ||
| 7399276 | 7399276 | tt31998776 | tvEpisode | 9 | 9 | 0 | 2024 | Documentary | ||
| 7437910 | 7437910 | tt32139071 | tvEpisode | 9 | 9 | 0 | 2022 | 45 | Drama | |
| 7456180 | 7456180 | tt32199062 | tvEpisode | 9 | 9 | 0 | 2024 | Reality-TV | ||
| 7473113 | 7473113 | tt32246798 | tvEpisode | 09 | 09 | 0 | 2024 | Comedy | ||
| 7669771 | 7669771 | tt32869184 | tvEpisode | 9 | 9 | 0 | Drama | |||
| 7694791 | 7694791 | tt32985308 | tvEpisode | 9 | 9 | 0 | 2024 | 45 | Drama | |
| 7700629 | 7700629 | tt33009291 | tvEpisode | 8.5 | 8.5 | 0 | 2019 | Reality-TV | ||
| 7700640 | 7700640 | tt33009334 | tvEpisode | 8.6 | 8.6 | 0 | 2019 | Reality-TV | ||
| 7700839 | 7700839 | tt33013164 | tvEpisode | 8.7 | 8.7 | 0 | 2019 | Reality-TV | ||
| 7700848 | 7700848 | tt33013176 | tvEpisode | 8.8 | 8.8 | 0 | 2019 | Reality-TV | ||
| 7701118 | 7701118 | tt33014311 | tvEpisode | 8.9 | 8.9 | 0 | 2019 | Reality-TV | ||
| 7702606 | 7702606 | tt33017743 | tvEpisode | 9.10 | 9.10 | 0 | 2020 | Reality-TV | ||
| 7702671 | 7702671 | tt33018809 | tvEpisode | 9.11 | 9.11 | 0 | 2020 | Reality-TV | ||
| 7702715 | 7702715 | tt33019505 | tvEpisode | 9.12 | 9.12 | 0 | 2020 | Reality-TV | ||
| 7702723 | 7702723 | tt33019521 | tvEpisode | 9.13 | 9.13 | 0 | 2020 | Reality-TV | ||
| 7777597 | 7777597 | tt33203653 | tvEpisode | 9 | 9 | 0 | 2009 | Reality-TV | ||
| 8013380 | 8013380 | tt3437442 | short | 9 | 9 | 0 | 2014 | 17 | Drama,Short,Thriller | |
| 8256081 | 8256081 | tt35530303 | tvEpisode | 8.5 | 8.5 | 0 | 2024 | Game-Show | ||
| 8256083 | 8256083 | tt35530305 | tvEpisode | 8.6 | 8.6 | 0 | 2024 | Game-Show | ||
| 8256085 | 8256085 | tt35530308 | tvEpisode | 8.7 | 8.7 | 0 | 2024 | Game-Show | ||
| 8256087 | 8256087 | tt35530310 | tvEpisode | 8.8 | 8.8 | 0 | 2024 | Game-Show | ||
| 8256088 | 8256088 | tt35530311 | tvEpisode | 8.9 | 8.9 | 0 | 2024 | Game-Show | ||
| 8332609 | 8332609 | tt35840303 | tvEpisode | 9 | 9 | 0 | 2025 | History,War | ||
| 8379976 | 8379976 | tt36059999 | tvEpisode | 9 | 9 | 0 | 2025 | 30 | Comedy,Drama | |
| 8393974 | 8393974 | tt36122731 | tvEpisode | 9 | 9 | 0 | 2025 | Comedy | ||
| 8473316 | 8473316 | tt36475933 | tvEpisode | 9 | 9 | 0 | 2007 | Reality-TV | ||
| 8494288 | 8494288 | tt36591042 | tvEpisode | 9 | 9 | 0 | 2008 | Reality-TV | ||
| 8494366 | 8494366 | tt36591119 | tvEpisode | 9 | 9 | 0 | 2008 | Documentary |
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]);