Share This
table started by
danm for the Freebase Commons
This type is currently a placeholder. Will be used to store example MQL queries.
Add More Topics
Save this view to a base, or just for yourself.
49 Freebase Query topics matching:
Filter this Collection|
|
|||
|---|---|---|---|
| x name | x image | x Query | x article |
| 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"}]} |
Description could not be displayed
|
|
| 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" } ]} | ||
| x Scientists & Science-Fiction writers | [{ "id":null, "name":null, "type" : "/people/person", "a:profession":[{"name":"Scientist"}], "b:profession":[{"name":"Science-fiction writer"}], "limit":100 }] | ||
