I’m trying to find all the actors in the 21million movies dataset that have played themselves in a movie.
I did found one of them by hand and some Google searches: Neil Patrick Harris.
With the query below, I could show that indeed he played himself in a couple of movies.
{
{
nph(func: eq(name@., "Neil Patrick Harris"))
@filter(has(character.portrayed_in_films))
{
name@.
uid
character.portrayed_in_films {
performance.film {
name@.
}
performance.actor @filter(eq(name@., "Neil Patrick Harris")) {
name@.
uid
}
}
}
}
The output is:
{
"extensions": {
"server_latency": {
"parsing_ns": 39684,
"processing_ns": 1812326,
"encoding_ns": 1014961
},
"txn": {
"start_ts": 22790001
}
},
"data": {
"nph": [
{
"name@.": "Neil Patrick Harris",
"uid": "0x72a289",
"character.portrayed_in_films": [
{
"performance.film": [
{
"name@.": "A Very Harold & Kumar 3D Christmas"
}
],
"performance.actor": [
{
"name@.": "Neil Patrick Harris",
"uid": "0x1ae2c"
}
]
},
{
"performance.film": [
{
"name@.": "Harold & Kumar Go to White Castle"
}
],
"performance.actor": [
{
"name@.": "Neil Patrick Harris",
"uid": "0x1ae2c"
}
]
},
{
"performance.film": [
{
"name@.": "Harold & Kumar Escape from Guantanamo Bay"
}
],
"performance.actor": [
{
"name@.": "Neil Patrick Harris",
"uid": "0x1ae2c"
}
]
}
]
}
]
}
}
As you can see, while the name for the actor and the character match, the uid does not. So how could I find in general which actors have played roles in which the character had their own name?
Maybe @MichelDiz knows how to do this already?