Example queries for Sparklis

This page lists a number of queries over different endpoints (mostly DBpedia) that can be built in Sparklis.

For each example query, a link enables to directly jump to it in Sparklis, and to navigate further.

Example queries demonstrated in the YouTube demo

List of films directed by Tim Burton and starring somebody born after 1980, ordered by increasing birth date.
give me
every film
whose director is Tim Burton
and whose starring has the lowest-to-highest birth date after 1980
List of film writers born in France with their English name, an optional depiction, their number of films as a writer (in decreasing order), and the list of their known birth dates.
- give me every writer
  that is the writer of a film
  and whose label has a language matching en
  and that optionally has a depiction
  and that has a birth date
  and that has any birth place whose country is France
- and
  for each result
  give me the highest-to-lowest number of film
- and
  for each result
  give me the list of birth date

Example queries from the QALD-4 challenge

Test questions from Task 1 on DBpedia.

Give me all taikonauts.
give me every astronaut whose nationality is China
How many languages are spoken in Colombia?
- give me every language spoken in Colombia
- and give me the number of language
Which poet wrote the most books?
- give me every person
  whose occupation is Poet
  and that is the author of a book
- and
  for each person
  give me the highest-to-lowest number of book
How many programming languages are there?
- give me every programming language
- and give me the number of programming language
Give me all Dutch parties.
give me every political party whose country is Netherlands
When was Carlo Giuliani shot?
it is true that Death of Carlo Giuliani has a date of death
Does the Isar flow into a lake?
it is true that Isar is the inflow of a lake
Which rivers flow into a German lake?
give me every river that is the inflow of a lake whose country is Germany
How heavy is Jupiter's lightest moon?
give me
everything
that is the satellite of Jupiter
and that has the lowest-to-highest mass
Who is the youngest Darts player?
give me every darts player that has the highest-to-lowest birth date
Give me all animals that are extinct.
give me every animal whose conservation status matches EX
How many pages does War and Peace have?
give me the number of pages of War and Peace
Which ingredients do I need for carrot cake?
give me the ingredient of Carrot cake
What is the most frequent death cause?
- give me the death cause of a person
- and
  for each death cause
  give me the highest-to-lowest number of person
Who has Tom Cruise been married to?
give me every person whose spouse is Tom Cruise
Who is the tallest player of the Atlanta Falcons?
it is true that Atlanta Falcons is the team of something that has the highest-to-lowest height
What is the bridge with the longest span?
give me every bridge that has the highest-to-lowest mainspan
give me all films produced by Steven Spielberg with a budget of at least $80 million.
give me
every film
whose director is Steven Spielberg
and whose budget is higher or equal to 80E6
Is Cola a beverage?
it is true that Cola is a beverage107881800
Which actor was casted in the most movies?
- give me every actor that is the starring of a film
- and
  for each actor
  give me the highest-to-lowest number of film
Where was Bach born?
give me the birth place of Johann Sebastian Bach
Which of Tim Burton's films had the highest budget?
give me
every film
whose director is Tim Burton
and that has the highest-to-lowest budget
Does Abraham Lincoln's death place have a website?
it is true that Abraham Lincoln has a death place whose location has a website
Who are the four youngest MVP basketball players?
give me
every basketball player
that is the mvp of something
and that has the highest-to-lowest birth date
What are the top-10 action role-playing video games according to IGN?
give me
every video game
whose subject is Category:Action role-playing video games
and that has the highest-to-lowest ign
give me all actors who were born in Berlin.
give me every actor whose birth place is Berlin
give me all actors who were born in Paris after 1950.
give me
every actor
whose birth place is Paris
and whose birth date is after 1950
What was Brazil's lowest rank in the FIFA World Ranking?
give me the fifa min of Brazil national football team
Give me all Australian metalcore bands.
give me
every band
whose genre is Metalcore
and whose hometown is
Australia
or anything whose country is Australia
When is Halloween?
it is true that Halloween has a date
How many inhabitants does the largest city in Canada have?
it is true that Canada has a largest city that has a population total
In which countries can you pay using the West African CFA franc?
give me every country whose currency is West African CFA franc
Give me the capitals of all countries that the Himalayas run through.
it is true that Himalayas has a country that has a capital
Who was the first to climb Mount Everest?
it is true that Mount Everest has a first ascent person
To which artistic movement did the painter of The Three Dancers belong?
give me the movement of the author of The Three Dancers
Which pope succeeded John Paul II?
give me
everything
that matches all of john , paul , II
and that has a successor
What was the last movie with Alec Guinness?
give me
every film
whose starring is Alec Guinness
and that has the highest-to-lowest release date
How many James Bond movies are there?
- give me every film whose subject is Category:James Bond films
- and give me the number of film
Which actor played Chewbacca?
it is true that Chewbacca has a portrayer
Give me the grandchildren of Bruce Lee.
give me
every person
that matches all of bruce, lee
and whose child has a children
(Only the number of child's children is known, not their identity.)
Give me all writers that won the Nobel Prize in literature.
give me every writer whose award is Nobel Prize in Literature
What is the official color of the University of Oxford?
it is true that University of Oxford has an official school colour
Give me all Swedish oceanographers.
give me
every scientist
whose field is Oceanography
and whose nationality is Sweden
How deep is Lake Placid?
give me every lake that matches all of placid
(Nothing related to depth about any of the two existing Lake Placid.)
Is James Bond married?
give me
every fictional character
that matches all of James, Bond
and that has a spouse
Which spaceflights were launched from Baikonur?
give me everything whose launch site is Baikonur Cosmodrome
Give me all actors called Baldwin.
give me
everything
that is an actor
or whose occupation is Actor

and whose surname is Baldwin (en)
What does CPU stand for?
give me everything whose abbreviation is CPU (string)
In which studio did the Beatles record their first album? OUT OF SCOPE
How many gold medals did Michael Phelps win at the 2008 Olympics? OUT OF SCOPE

Example queries about Wikidata

Selection of queries from the Wikidata page about example queries for the Wikidata query service.

Slideshow of individual cats
give me every house cat that has an image
Map of French hospitals
give me
every hospital
that has as a country France
and that has a geolocation
Number of humans in Wikidata
- give me every human
- and give me the number of human
Popular given names among the French people
- give me every human
  that has a given name
  and that has as a country of citizenship France
- and
  for each given name
  give me the highest-to-lowest number of human
Humans whose gender we know we don't know
- give me every human that has a sex or gender
- and where the sex or gender is a blank node
Whose birthday is today?
- give me every human that has a date of birth
- and where the month of the date of birth = the month of now and the day of the date of birth = the day of now
List of countries ordered by the number of their cities with female mayor
- give me every city
  that has a country
  and not with an end time
  and that has a head of government that has as a sex or gender female
  and not with an end time
- and
  for each country
  give me the highest-to-lowest number of city
Timeline of space probes
- give me every space probe
  that has the lowest-to-highest time of spacecraft launch
  and that optionally has an operator
  and that optionally has an image
- and
  for each result
  give me a sample of image
Population of countries sharing a border with France, per year since 2015
- give me every country
  that is shares border with France
  and that has a population with a point in time
- and give me year = the year of the point in time
- and
  for
  the lowest-to-highest country
  and the highest-to-lowest year higher or equal to 2015
  
  give me the average population
French prime ministers by total length of service
- give me every human
  that has as a position held Prime Minister of France with a start time after 1815 with an end time
  and that optionally has an image
- and give me length of service (days) = highest-to-lowest the end time - the start time
- and
  for each human
  give me
  the highest-to-lowest total length of service (days)
  and a sample of image

Example queries about Nobel Prizes

List of Peace Nobel prize laureates, in decreasing year.
give me
every laureate
whose nobel prize
has as a category Peace
and has the highest-to-lowest year
List of Nobel prize laureates, by decreasing number of Nobel prizes.
- give me every laureate that has a nobel prize
- and
  for each laureate
  give me the highest-to-lowest number of nobel prize
Number of Nobel prize laureates by gender.
- give me every laureate that has a gender
- and
  for each gender
  give me the number of laureate

Example queries about geographical facts in the Mondial database

The links below include parameters to use English labels for classes and properties, and to use a Mondial-specific labelling property for entities.

You may have to click the button after following the links to see the proper labels because they are retrieved asynchronously.

Selections

Find rivers taking their source in Russia, and flowing into a lake.
give me
every river
whose source is located in Russia
and that flows into a lake
Which capitals of which countries are on the border to the Atlantic Ocean?
give me
every city
that is the capital of a country
and located at Atlantic Ocean
Give French cities with a population higher than 200,000 located along a river.
give me
every city
that is the city of France
and whose population is higher or equal to 200000
and located at a river
Which languages are spoken in Spain? In which proportions?
give me
every spoken language
whose country is Spain
and that has a language
and that has the highest-to-lowest percentage

Basic aggregations

How many countries are there in Europe?
- give me every country whose continent is Europe
- and give me the number of country
What is the average city population in China?
- give me every city
  that is the city of China
  and that has a population
- and give me the average population

Simple aggregations (or cubes)

What is the population of continents, given the population of countries?
- give me every country
  that has a continent
  and that has a population
- and
  for each continent
  give me the total population
How many countries are there for each continent, and for each language spoken by at least 10% of the people?
- give me every country
  that has a continent
  and that is the country of a spoken language
  that has a language
  and whose percentage is higher or equal to 10
- and
  for
  each continent
  and each language
  
  give me the number of country

Multiple aggregations

Give me the average population and the average area of countries, for each continent.
- give me every country
  that has a continent
  and that has a population
  and that has an area
- and
  for each continent
  give me the average population
- and
  for each continent
  give me the average area
Give me the number of European seaside city, and their average population, for each country, and for each sea.
- give me every city
  that is the city of a country whose continent is Europe
  and whose location near the body of water is a sea
  and that has a population
- and
  for
  each country
  and each location near the body of water
  
  give me the number of city
- and
  for
  each country
  and each location near the body of water
  
  give me the average population

Nested aggregations

What is the average area of archipelagos, given that the area is only known for individual islands?
- give me every archipelago that is the archipelago of an island that has an area
- and
  for each archipelago
  give me the total area
- and give me the average total area
What is the distribution of the number of islands in archipelagos, i.e. the number of archipelagos for each number of islands per archipelago.
- give me every archipelago that is the archipelago of an island
- and
  for each archipelago
  give me the number of island
- and
  for the lowest-to-highest number of island
  give me the number of archipelago

Expressions in bindings and filters

Give me the population density for each country, from population and area.
- give me every country
  that has a population
  and that has an area
- and give me the population / the area
Which countries have a service GDP less than the agricultural and industrial GDP combined, and have an agricultural GDP higher than the industrial GDP?
- give me every country
  that has an agricultural GDP
  and that has a gdp ind
  and that has a service GDP
- and where the service GDP < the agricultural GDP + the gdp ind and the agricultural GDP > the gdp ind

Complex combinations

Give me countries whose GDP per capita (=total GDP*1e6/population) is above the average.
- give me every country
  that has a total GDP
  and that has a population
- and give me GDP per capita = the total GDP * 1e6 / the population
- and give me the average GDP per capita
- and where the GDP per capita > the average GDP per capita
Has Russia more rivers longer than 1000km than USA?
- give me every river
  whose length is higher or equal to 1000
  and whose location is a country
- and
  for the location Russia
  give me the number of river
- and
  for the location United States
  give me the number of river
- and where the 1st number of river > the 2nd number of river
Which proportion of cities are near a body of water, for each country?
- give me every city
  that is the city of a country
  and that optionally has a location near the body of water
- and give me near water ? = 1 or 0 whether the location near the body of water is bound
- and
  for
  each country
  and the near water ? 1
  
  give me the number of city
- and
  for each country
  give me the number of city
- and give me the 1st number of city / the 2nd number of city

Ranking and top-K questions

List countries by decreasing population density (=population/area).
- give me every country
  that has a population
  and that has an area
- and give me highest-to-lowest the population / the area
Which mountain range has the highest number of volcanos?
- give me every mountain range that is the mountain range of a volcano
- and
  for each mountain range
  give me the highest-to-lowest number of volcano
Which are the 3 most common numbers of islands in archipelagos?
- give me every archipelago that is the archipelago of an island
- and
  for each archipelago
  give me the number of island
- and
  for each number of island
  give me the highest-to-lowest number of archipelago
Which religions are present in which countries at more than 5 percent? How many such countries are there for each religion, in decreasing order?
- give me every belief
  that has a religion
  and that has a country
  and whose percentage is higher or equal to 5
- and
  for each religion
  give me the highest-to-lowest number of country

Example queries with nested results about Wikidata

Selection of queries from the Wikidata page about example queries for the Wikidata query service.

Academy awards
give me every human that award received with a for work that optionally has ⚬ a director ⚬ ⚬ an Academy Awards with a statement is subject of that optionally has ⚬ a point in time ⚬ ⚬
Ranking of film directors
- give me every human
  that has as an occupation ⚬ film director ⚬
  and that is the director of something ⚬
  and that is the cast member of something ⚬
- and
  for each human
  give me
  the number of 1st thing
  and the number of 2nd thing
- and give me total = highest-to-lowest the number of 1st thing + the number of 2nd thing
The Simpsons episodes
The Simpsons has as a part with the lowest-to-highest series ordinal ⚬ a television series season that has as a part with the lowest-to-highest series ordinal ⚬ a television series episode ⚬ ⚬
Law &ersand; Order episodes
Law & Order has as a part with the lowest-to-highest series ordinal ⚬ a television series season that has as a part with the lowest-to-highest series ordinal ⚬ a television series episode that has ⚬ a publication date ⚬ ⚬ ⚬
Dr Who performers
- give me every regeneration of The Doctor
  that optionally has ⚬ a series ordinal ⚬
  and that optionally has ⚬ a performer ⚬
- and give me lowest-to-highest the series ordinal as integer
Movies about World War II
give me
every film
that has ⚬ a narrative location that has a geolocation ⚬
and that has ⚬ a country of origin ⚬
and that has as a main subject ⚬ World War II ⚬
Longest rivers
give me
every river
that has ⚬ the highest-to-lowest length ⚬
and that has ⚬ an image ⚬
Stations of Paris line 1
give me
every metro station
that has as a connecting line ⚬ Paris Métro Line 1 ⚬
and that has a geolocation
and that optionally has ⚬ a connecting line that is not Paris Métro Line 1 ⚬
and that optionally has ⚬ an adjacent station with a connecting line with a towards ⚬
Governments of countries
give me
every country
that has ⚬ a basic form of government
⚬
and optionally with a start time ⚬
and not with an end time ⚬
and that has ⚬ a head of government that has ⚬ a sex or gender ⚬ with a start time after 2000 ⚬

Example queries from the QALD-6 challenge

Test questions from Task 3 on datacubes.

You may have to click the button after following the links to see the proper labels because they are retrieved asynchronously.

How much was spent on public safety by the Town of Cary in 2010?
How many programs were done under the class of General Government in the expenditure of the Town of Cary?
How much did the Town of Cary earn in 2010?
Which class achieved the highest revenue for the Town of Cary?
For which account type of whiteacre was spent the most?
How much interest did the debt service of the city of Whiteacre spend?
Which expenses had the highest total amount of proposed expenditures for the Maldives?
What was the highest single expenditure amount proposed by the Maldives Broadcasting Corporation?
Which Ugandan output had the highest budget in 2014?
What was the average Uganda health budget amount in Namutumba District?
How many suppliers did the Newcastle city council use for education?
How many directorates does the Newcastle city council have?
Which suppliers did the Waltham Forest Council utilize for recycling?
On the Waltham Forest Council, how much money was given to the Forest Recycling Project?
How many narratives are there for Cheshire West and Chester council spending in the category of Marketing?
What are the top 3 expenditure categories in Cheshire West and Chester council spending?
Which priorities does the insurance fund have for the City of Redacre?
How many divisions have safety priority in the City of Redacre spending?
What was the total Wandsworth spending in 2013 from the housing department?
How much money does Wandsworth spendt on general internal repairs?
Top 3 IW Council Spending service areas?
Under which directorate does the IW Council service area have the highest revenue?
Which departments of the city of Springfield had a higher budget in 2004 then in 2005?
What is the highest single budget amount in the city of Springfield for public safety?
Which of the Californian cities received the highest amount of money?
Under which caption did Livermore receive the highest amount of money in 2011?
What is the average Washington DC teacher salary?
Which position has the highest average salary in Washington DC?
How many big lottery found grants were given in the South West in 2012?
Has there been a big lottery fund grant to Stanbury Court Social Club?
On which expenses in Gloucestershire was spent more than 10,000,000 pound in total?
How much money did Cheltenham Borough Homes receive?
How much did the department for work and pensions pay for Research into Infrastructure?
What are the geographic regions in the UK Country Regional Analysis from the scottish executive and its departments for forests?
How much cost the implementation of Midwifery Education in Nangarhar?
How much was spent on food security by Cordaid in Afghanistan?
What was the total expenditure on Materials and Supplies of the City of Toronto in 2010?
How much did Ireland charities pay in total governance costs?
What was the frontex staff budget in 2005?
What was the smallest amount for industrial and commercial facilities in the Dublin City Council Expenditure Budget of 2013?
Which country received the highest financial crisis aid?
How much was charity spending was expended for charitable activities in Haiti?
What is the amount given by the Metropolitan Police Department to Cybernational?
What was the highest amount under the sub-account for layout and construction of buildingsin Cameroon in 2009?
When did Canada get Nominet Trust funding for the last time?
Which admin was reponsible for the most total running expenses in Armenia in 2009?
How much is the total amount of statuatory transfers in Nigerias proposed budget of 2013?
How much did the New York City Council Members give in 2015 for the Manhattan youth?
What was the amount of the smallest community grant in the Fingal County Council expenditure budget?
When was the upgrade of the Parks-Baba Park paid?

Example queries on ISWC 2017 metadata

You may have to click the button after following the links to see the proper labels because they are retrieved asynchronously.

Give me the list of tracks.
give me every track
Give me papers on 'question answering', and their first author.
give me
every article in proceedings
that matches all of question, answering
and whose author list has a first item that has a content
Give me the distribution of people by affiliation.
- give me every person whose affiliation has a with organisation
- and
  for each with organisation
  give me the highest-to-lowest number of person
Give me the distribution of people by affiliation and role.
- give me every person
  whose affiliation has an organisation
  and
  whose hold role has a role
  or that is the creator of an article in proceedings
- and give me role = the role if the role is bound else author
- and
  for
  each organisation
  and each role
  
  give me the highest-to-lowest number of person
Give me people with the most papers.
- give me every person that is the creator of an article in proceedings
- and
  for each person
  give me the highest-to-lowest number of article in proceedings
Give me organizations with the most papers.
- give me every organisation that is the organisation of the affiliation of the creator of an article in proceedings
- and
  for each organisation
  give me the highest-to-lowest number of article in proceedings
Give me the distribution of papers by number of authors.
- give me every article in proceedings that has a creator
- and
  for each article in proceedings
  give me the number of creator
- and
  for the lowest-to-highest number of creator
  give me the number of article in proceedings
List the papers with authors from Bonn.
- give me every article in proceedings whose creator
  has an affiliation whose with organisation matches all of Bonn
  and has a label
- and
  for each article in proceedings
  give me
  the list of label
  and a sample of with organisation
What is the number of papers whose title matches various keywords?
- give me every article in proceedings that has a label
- and give me regexp = a lowest-to-highest choice between SPARQL, [Qq]uestion, [Qq]uer(y|ies), [Ss]earch, [Aa]nswering
- and where the label matches as regexp the regexp
- and
  for each regexp
  give me the highest-to-lowest number of article in proceedings