Use imdb-loader for loading IMDb datasets to PostgreSQL database.
API is described in the GraphQL schema.
Basically you can search movies by some basic parameters, as well search a movie, a rating, or a person by titleId.
Movie search request
{
movieSearch(genre: "Film-Noir", director: "Billy Wilder", limit: 20, minRating: 7) {
title
year
directors
rating
votes
}
}Response
{
"data": {
"movieSearch": [
{
"title": "Sunset Blvd.",
"year": 1950,
"directors": "Billy Wilder",
"rating": 8.4,
"votes": 214401
},
{
"title": "Double Indemnity",
"year": 1944,
"directors": "Billy Wilder",
"rating": 8.3,
"votes": 152101
},
{
"title": "Ace in the Hole",
"year": 1951,
"directors": "Billy Wilder",
"rating": 8.1,
"votes": 34644
},
{
"title": "The Lost Weekend",
"year": 1945,
"directors": "Billy Wilder",
"rating": 7.9,
"votes": 35886
}
]
}
}Movie by titleId request
{
movie(titleId: 110912) {
titleType
originalTitle
startYear
runtimeMinutes
genres
rating {
numVotes
averageRating
}
}
}Response
{
"data": {
"movie": {
"titleType": "movie",
"originalTitle": "Pulp Fiction",
"startYear": 1994,
"runtimeMinutes": 154,
"genres": "Crime,Drama",
"rating": {
"numVotes": 1946783,
"averageRating": 8.9
}
}
}
}TV Series by titleId
{
tvSeries(titleId: 944947){
data {
primaryTitle
startYear
endYear
genres
rating {
averageRating
numVotes
}
}
totalSeasons
totalEpisodes
totalRuntime
}
}Response
{
"data": {
"tvSeries": {
"data": {
"primaryTitle": "Game of Thrones",
"startYear": 2011,
"endYear": 2019,
"genres": "Action,Adventure,Drama",
"rating": {
"averageRating": 9.2,
"numVotes": 1932926
}
},
"totalSeasons": 8,
"totalEpisodes": 73,
"totalRuntime": 4214
}
}
}Episode by titleId request
{
episode(titleId: 3866850){
parent {
primaryTitle
startYear
endYear
}
season
episode
data {
primaryTitle
directors {
primaryName
birthYear
knownForTitles {
primaryTitle
titleType
startYear
rating {
averageRating
}
}
}
}
}
}Response
{
"data": {
"episode": {
"parent": {
"primaryTitle": "Game of Thrones",
"startYear": 2011,
"endYear": 2019
},
"season": 5,
"episode": 8,
"data": {
"primaryTitle": "Hardhome",
"directors": [
{
"primaryName": "Miguel Sapochnik",
"birthYear": 1974,
"knownForTitles": [
{
"primaryTitle": "A Life Less Ordinary",
"titleType": "movie",
"startYear": 1997,
"rating": {
"averageRating": 6.4
}
},
{
"primaryTitle": "Game of Thrones",
"titleType": "tvSeries",
"startYear": 2011,
"rating": {
"averageRating": 9.2
}
},
{
"primaryTitle": "Repo Men",
"titleType": "movie",
"startYear": 2010,
"rating": {
"averageRating": 6.3
}
},
{
"primaryTitle": "Finch",
"titleType": "movie",
"startYear": 2021,
"rating": {
"averageRating": 6.9
}
}
]
}
]
}
}
}
}