Freebase Query - Freebase

x Metaweb staff in order of age

{"query":[{"!/type/usergroup/member":[{"name":"Metaweb Staff","type":"/type/usergroup"}],"/freebase/user_profile/person":{"/people/person/date_of_birth":{"value":null}},"name":null,"sort":"-/freebase/user_profile/person./people/person/date_of_birth.value","type":"/type/user"}]}

x 25 Songs with the word 'love' in the title, with release date, album and artist

{ "query":[{ "album":{ "artist":[], "name":null, "release_date":null }, "id":null, "limit":25, "name":null, "name~=":"Love*", "type":"/music/track" }] }

x 35 actors born in the 60's and two of their films

{ "query":[{ "/people/person/date_of_birth":null, "/people/person/date_of_birth<":"1970", "/people/person/date_of_birth>=":"1960", "film":[{ "film":[{ "id":null, "name":null }], "limit":2 }], "id":null, "limit":35, "name":null, "type":"/film/actor" }] }

x Vietnamese restaurants in San Jose, CA

{ "query":[{ "/business/retail_location/address":{ "citytown":"San Jose" }, "cuisine":"Vietnamese", "id":null, "name":null, "type":"/dining/restaurant" }] }

x A sorted list of cloud classifications

{ "query":[{ "clouds":[], "id":null, "name":null, "sort":"name", "type":"/meteorology/cloud_classification" }] }

x 50 People born in San Francisco in the 70's

{ "query":[{ "/people/person/date_of_birth":null, "/people/person/date_of_birth<":"1980", "/people/person/date_of_birth>=":"1970", "/people/person/place_of_birth":"San Francisco", "limit":50, "name":null, "id":null, "type":"/people/person" }] }

x Ivy League Authors

{ "query":[{ "b:type":"/book/author", "education":[{ "institution":[{ "name":null, "id":null, "tags":"Ivy League", "type":"/user/patrick/default_domain/tagged_topic" }] }], "name":null, "id":null, "type":"/people/person" }] }

x Graduates of Stanford born since 1960 who are board members of companies

{ "query":[{"b:type":"/business/board_member","date_of_birth":null, "date_of_birth>=":"1960", "education":[{ "institution":"Stanford University","id":null }], "name":null, "id":null, "type":"/people/person" }] }

x Academy award winning musicals

{ "query":[{ "awards":[{ "award_winner_person":null, "film_award_type":{ "awarding_organization":"Academy of Motion Picture Arts and Sciences", "id":null, "name":null }, "sort":"-year", "year":null }], "genre":{ "id":null, "name":"Musical" }, "id":null, "name":null, "sort":"-awards.year", "type":"/film/film" }] }

x Actors who made movies in the 1970s and 1980s

{"query":[{"a70s:film":[{"film":{"id":null,"initial_release_date":null,"initial_release_date<":"1980","initial_release_date>=":"1970","name":null},"limit":1}],"a80s:film":[{"film":{"id":null,"initial_release_date":null,"initial_release_date<":"1990","initial_release_date>=":"1980","name":null},"limit":1}],"id":null,"name":null,"type":"/film/actor"}]}

x Songs in Video Games

{ "query":[{ "/type/reflect/any_reverse":[{ "id":null, "link":"/user/alecf/default_domain/musical_game/songs", "name":null }], "id":null, "name":null, "type":"/music/song" }] }

x Where are they now? Actors of canceled shows and the shows they're on now

{ "query":[{ "air_date_of_final_episode":{ "limit":1, "value":null }, "id":null, "name":null, "regular_cast":[{ "actor":{ "id":null, "name":null, "starring_roles":[{ "series":{ "air_date_of_final_episode":{ "optional":"forbidden", "value":null }, "id":null, "name":null } }] } }], "sort":"-air_date_of_final_episode.value", "type":"/tv/tv_program" }] }

x Where did they come from? TV Actors on current shows and the shows they came from

{ "query":[{ "air_date_of_final_episode":{ "optional":"forbidden", "value":null }, "id":null, "name":null, "regular_cast":[{ "actor":{ "id":null, "name":null, "starring_roles":{ "limit":1, "series":{ "air_date_of_final_episode":{ "limit":1, "value":null }, "id":null, "name":null, "sort":"-air_date_of_final_episode.value" }, "sort":"-series.air_date_of_final_episode.value" } }, "limit":10, "sort":"-actor.starring_roles.series.air_date_of_final_episode.value" }], "type":"/tv/tv_program" }] }

this is timing out... :(

x What happened to the cast of Who's the Boss?

{ "query":{ "id":null, "name":"Who's the Boss?", "regular_cast":[{ "actor":{ "name":null, "starring_roles":[{ "series":{ "id":null, "name":null } }] } }], "type":"/tv/tv_program" } }

x Films starring Jennifer Connelly with actors who have appeared in Steven Spielberg movies

{ "query" : [ { "b:starring" : [ { "actor" : { "film" : [ { "film" : { "hide:directed_by" : "Steven Spielberg", "name" : null } } ], "name" : null } } ], "hide:starring" : [ { "actor" : "Jennifer Connelly" } ], "id" : null, "initial_release_date" : null, "name" : null, "sort" : "-initial_release_date", "type" : "/film/film" } ] }

x Malls in California with both a Zale's Jewelers and a Victoria's Secret

{ "query" : [ { "/user/jeff/default_domain/addressed_topic/address" : { "citytown" : { "/location/location/containedby" : "California", "name" : null } }, "a:store" : [ { "parent_company" : "Victoria's Secret" } ], "b:store" : [ { "parent_company" : "Zales Jewelers" } ], "id" : null, "name" : null, "type" : "/user/tsegaran/default_domain/shopping_center" } ] }

x CFOs of companies in SF with >$1M in revenue

{ "query" : [ { "employment_history" : [ { "company" : { "headquarters" : [ { "citytown" : "San Francisco" } ], "name" : null, "revenue" : [ { "amount" : null, "amount>" : 1000000 } ], "type" : "/business/company" }, "title" : "Chief Financial Officer" } ], "name" : null, "type" : "/people/person" } ] }

x Directors of $10M+ companies who have starred in movies

{ "query" : [ { "/business/board_member/board_memberships" : [ { "company" : { "market_capitalization" : [ { "amount" : null, "amount>" : 10000000 } ], "name" : null } } ], "/film/actor/film" : [ { "film" : null } ], "a:type" : "/film/actor", "b:type" : "/business/board_member", "id" : null, "name" : null } ] }

x Military people who are now directors of companies (with industries)

{ "query" : [ {"id":null, "/business/board_member/board_memberships" : [ { "company" : [ { "industry" : [], "name" : null } ] } ], "a:type" : "/military/military_person", "b:type" : "/business/board_member", "name" : null } ] }

x Prepackaged software companies that are losing money (with CEOs)

{ "query" : [ { "/business/employer/employees" : [ { "person" : null, "title" : "Chief Executive Officer" } ], "id" : null, "industry" : [ { "name" : "Prepackaged software" } ], "name" : null, "operating_income" : [ { "amount" : null, "amount<" : 0, "valid_date" : null } ], "type" : "/business/company" } ] }

x Female CEOs of public companies in order of Market Cap

{ "query" : [ { "employment_history" : [ { "company" : { "/business/company/market_capitalization" : [ { "amount" : null } ], "/business/company/ticker_symbol" : [ { "ticker_symbol" : null } ], "id" : null, "name" : null }, "title" : "Chief Executive Officer" } ], "hide:gender" : "female", "id" : null, "name" : null, "sort" : "-employment_history.company./business/company/market_capitalization.amount", "type" : "/people/person" } ] }

x French Actresses born before WWII

{"query":[{"type":"/film/actor","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"/people/person/gender":"female","/people/person/date_of_birth":null,"/people/person/date_of_birth<=":"1939","/people/person/nationality":"France","sort":"/people/person/date_of_birth"}]}

x Towns in Tuscany, Italy

{"query":[{"type":"/location/citytown","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":35,"name":null,"id":null,"/location/location/containedby":"Tuscany"}]}

x People born after 1980 who have died

{ "query" : [ { "id":null, "/people/deceased_person/cause_of_death" :[ { "name" : null } ], "/people/deceased_person/date_of_death" : null, "/people/person/date_of_birth" : null, "hide:/people/person/date_of_birth>" : "1980", "name" : null, "hide:type" : "/people/deceased_person" } ]}

x Contributions over $50000 have been made to members of the US congress in the 2008 election cycle by companies headquartered outside of the United States

{ "query" : [ { "/government/politician/election_campaigns" : { "/government/election_campaign/election" : { "/government/election/election_year" : "2008" } }, "/user/robert/us_congress/crp_contribution_recipient/crp_political_contributions_received" : [ { "/user/robert/us_congress/crp_contribution/amount" : null, "/user/robert/us_congress/crp_contribution/amount>" : 50000, "/user/robert/us_congress/crp_contribution/contributor" : { "/business/company/headquarters" : [ { "/location/mailing_address/citytown" : { "/location/location/containedby" : { "limit" : 1, "name" : null, "name!=" : "United States", "type" : "/location/country" }, "name" : null } } ], "name" : null } } ], "hide:/common/topic/image" : [ {} ], "id" : null, "name" : null } ] }

x Foreign donations to 2008 US Political Candidates

{"query": [{"crp_political_contributions_received":[{"amount":null,"amount>":50000,"contributor":{"/business/company/headquarters":[{"citytown":{"/location/location/containedby":{"limit":1,"name":null,"name!=":"United States","type":"/location/country"},"name":null}}],"name":null}}],"hide:/common/topic/image":[{}],"hide:/government/politician/election_campaigns":{"/government/election_campaign/election":{"/government/election/election_year":"2008"}},"id":null,"name":null,"type":"/user/robert/us_congress/crp_contribution_recipient"}]}

What contributions over $50000 have been made to members of the US congress in the 2008 election cycle by companies headquartered outsideof the United States?

x Novels that have won the Hugo, Nebula, and Locus awards combined

{ "query":[ { "/award/award_winning_work/awards_won" : [ { "hide:award" : { "id" : "/en/hugo_award_for_best_novel", "name" : null }, "award":null, "year" : null } ], "b:/award/award_winning_work/awards_won" : [ { "hide:award" : { "id" : "/en/nebula_award_for_best_novel", "name" : null }, "award":null, "year" : null } ], "c:/award/award_winning_work/awards_won" : [ { "hide:award" : { "id" : "/guid/9202a8c04000641f80000000080d4528", "name" : null }, "award":null, "year" : null } ], "name" : null, "id": null, "hide:type" : "/award/award_winning_work", "sort" : "/award/award_winning_work/awards_won.year", "/book/written_work/author": null } ]}

x Australian Aboriginal women ordered by date of birth

{"query": [ { "ethnicity" : "Indigenous Australians", "date_of_birth" : null, "gender" : "female", "id" : null, "name" : null, "sort" : "date_of_birth", "type" : "/people/person" } ]}

x Leading Ladies of Sidney Poitier

{"query":[{"type":"/film/actor","hide:/common/topic/image":[{"id":null,"limit":1}],"name":null,"id":null,"hide:/people/person/gender":"female","film":{"limit":1,"film":{"name":null,"initial_release_date":null,"hide:starring":{"actor":"sidney poitier"}}},"sort":"film.film.initial_release_date"}]}

x Characters created by Stan Lee

{"query":[{"type":"/fictional_universe/fictional_character","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"character_created_by":"stan lee","sort":"name"}]}

x Art of Michelangelo Caravaggio

{"query":[{"type":"/visual_art/artwork","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"artist":"caravaggio","sort":"name"}]}

x Nikon Cameras in order of Resolution

{"query":[{"hide:/common/topic/image":[{"id":null,"limit":1,"optional":true}],"hide:manufacturer":[{"id":"/en/nikon"}],"id":null,"limit":30,"name":null,"sort":"-supported_resolutions.horizontal_resolution.value","supported_resolutions":{"horizontal_resolution":{"limit":1,"value":null},"limit":1},"type":"/digicams/digital_camera"}]}

x Genera of Orchids

{"query":[{"type":"/biology/organism_classification","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"scientific_name":null,"hide:higher_classification":"orchidaceae"}]}

x Russian Cosmonauts

{"query":[{"type":"/spaceflight/astronaut","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"/people/person/nationality":"russia"}]}

x Airplanes manufactured by Boeing

{"query":[{"type":"/aviation/aircraft_model","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"manufacturer":"boeing"}]}

x Oil Companies

{"query":[{"type":"/business/company","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"industry":"Petroleum"}]}

x French Cheese

{"query":[{"type":"/food/cheese","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"country_of_origin":"france"}]}

x Tropical Storms in the 90's

{"query":[{"type":"/meteorology/tropical_cyclone","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"formed":null,"formed>=":"1990","hide:formed":null,"hide:formed<=":"2000"}]}

x Films with Music by John Williams

{"query":[{"type":"/film/film","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"music":"john williams"}]}

x Mountains of the Himalayas

{"query":[{"type":"/geography/mountain","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"mountain_range":"Himalayas"}]}

x Suspension bridges

{"query":[{"type":"/transportation/bridge","hide:/common/topic/image":[{"id":null,"limit":1}],"limit":50,"name":null,"id":null,"bridge_type":"suspension bridge"}]}

x Pop art: works, artists, and dates completed

{"query" : [ { "artist" : [], "date_completed" : { "optional" : true, "value" : null }, "name" : null, "period_or_movement" : "Pop art", "type" : "/visual_art/artwork" } ]}

x African American authors and their books

{"query": [ { "/people/person/ethnicity" : "African American", "name" : null, "id" : null, "type" : "/book/author", "works_written" : [ { "name" : null } ] } ]}

x Who was influenced by Karl Marx?

{ "query" : [ { "id" : null, "influenced_by" : "Karl Marx", "name" : null, "type" : "/influence/influence_node" } ] }

x Heavy Metal bands named after places in Middle Earth

{"query" : [ { "/music/artist/genre~=" : "metal", "/user/skud/names/namesake/named_after" : [ { "/fictional_universe/fictional_setting/contained_by" : "Middle-earth" } ], "id" : null, "name" : null, "type" : "/user/skud/names/namesake" } ]}

x Web browsers that run on Mac OS X

{"query": [ { "/computer/software/compatible_oses" : [ { "/computer/software_compatibility/operating_system" : [ { "id" : "/en/mac_os_x", "name" : null } ] } ], "/computer/software/software_genre" : "Web Browser", "id" : null, "name" : null, "type" : "/computer/software" } ]}

x Web Browsers that run on the Mac

[ { "/computer/software/compatible_oses" : [ { "/computer/software_compatibility/operating_system" : [ { "id" : "/en/mac_os_x", "name" : null } ] } ], "/computer/software/latest_release_date" : null, "/computer/software/software_genre" : "Web Browser", "hide:/common/topic/image" : [ {} ], "id" : null, "name" : null, "sort" : "-/computer/software/latest_release_date", "type" : "/computer/software" } ]

x US cities named Canton

{ "query":[ { "/location/location/containedby" : [ { "name" : null, "type" : "/location/us_state" } ], "name" : "Canton", "id":null, "type" : "/location/citytown" } ]}

Freebase Query table

48 Freebase Query topics

x Add new column Add info Show in info bubble Show in info bubble

Do you know something that's missing from this view? Add it!

Freebase Query table

48 Freebase Query topics

Freebase Query Freebase Commons

x Add new column Add info Show in info bubble Show in info bubble

Do you know something that's missing from this view? Add it!