[Developers] Awards Queries

[Jeff Prucher]

Award winnings are stored in the CVT /award/award_honor. This query should
get you all the awards won by films, and who won them. Some film awards
might not have people associated with them, such as "best picture".

{
  "query" : [
    {
      "/award/award_winning_work/awards_won" : [
        {
          "award" : null,
          "award_winner" : [
            {
              "name" : null,
              "type" : "/film/actor"
            }
          ],
          "year" : null
        }
      ],
      "type" : "/film/film"
    }
  ]
}

Finding just awards for actors will be trickier.  That is, finding ALL
awards an actor has won, regardless of whether they're for acting,
directing, television, writing, or architecture, is easy. Finding only film
acting awards won by someone is harder, and requires that you have some
faith in the way awards are named; this query will return all films that
have won awards for categories that include the string "Act" in their names,
including "Actor", "Actress", and "Acting". It won't catch things like Gene
Kelly's honorary Oscar, though.

{
  "query" : [
    {
      "/award/award_winning_work/awards_won" : [
        {
          "award" : [
            {
              "name" : null,
              "name~=" : "Act*"
            }
          ],
          "award_winner" : [],
          "year" : null
        }
      ],
      "type" : "/film/film"
    }
  ]
}

Hope this helps,
Jeff



> -----Original Message-----
> From: developers-bounces at freebase.com 
> [mailto:developers-bounces at freebase.com] On Behalf Of Kendra Kuhl
> Sent: Friday, April 25, 2008 1:28 PM
> To: 'For discussions about MQL,Freebase API and apps built on 
> Freebase'
> Subject: [Developers] Awards Queries
> 
> Everyone,
> 
>  
> 
> I'm attempting to create a query that lists the awards that a 
> movie or an actor has won. I know how to get the awards won 
> properties that points to the movie / actor but then I have 
> to do another query to get the information about each item 
> that comes back. I would like to know if there is a more 
> efficient way of getting the information that I need. Is it 
> possible to get all the data in one query versus one for each 
> award? Is this a Compound Value Type? Any information would help.
> 
>  
> 
> Thanks in advance!
> 
>  
> 
> Kendra
> 
>