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

  1. 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 Open
    • and whose starring has the lowest-to-highest birth date after 1980
  2. 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 Open
    • 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.

  1. Give me all taikonauts.
    give me every astronaut whose nationality is China Open
  2. How many languages are spoken in Colombia? Screencast
    • give me every language spoken in Colombia Open
    • and give me the number of language
  3. Which poet wrote the most books?
    • give me every person
      • whose occupation is Poet Open
      • and that is the author of a book
    • and for each person
      • give me the highest-to-lowest number of book
  4. How many programming languages are there?
    • give me every programming language
    • and give me the number of programming language
  5. Give me all Dutch parties.
    give me every political party whose country is Netherlands Open
  6. When was Carlo Giuliani shot?
    it is true that Death of Carlo Giuliani Open has a date of death
  7. Does the Isar flow into a lake?
    it is true that Isar Open is the inflow of a lake
  8. Which rivers flow into a German lake? Screencast
    give me every river that is the inflow of a lake whose country is Germany Open
  9. How heavy is Jupiter's lightest moon?
    give me everything
    • that is the satellite of Jupiter Open
    • and that has the lowest-to-highest mass
  10. Who is the youngest Darts player?
    give me every darts player that has the highest-to-lowest birth date
  11. Give me all animals that are extinct.
    give me every animal whose conservation status matches EX
  12. How many pages does War and Peace have?
    give me the number of pages of War and Peace Open
  13. Which ingredients do I need for carrot cake?
    give me the ingredient of Carrot cake Open
  14. 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
  15. Who has Tom Cruise been married to?
    give me every person whose spouse is Tom Cruise Open
  16. Who is the tallest player of the Atlanta Falcons?
    it is true that Atlanta Falcons Open is the team of something that has the highest-to-lowest height
  17. What is the bridge with the longest span?
    give me every bridge that has the highest-to-lowest mainspan
  18. give me all films produced by Steven Spielberg with a budget of at least $80 million. Screencast
    give me every film
    • whose director is Steven Spielberg Open
    • and whose budget is higher or equal to 80E6
  19. Is Cola a beverage?
    it is true that Cola Open is a beverage107881800
  20. 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
  21. Where was Bach born?
    give me the birth place of Johann Sebastian Bach Open
  22. Which of Tim Burton's films had the highest budget?
    give me every film
    • whose director is Tim Burton Open
    • and that has the highest-to-lowest budget
  23. Does Abraham Lincoln's death place have a website?
    it is true that Abraham Lincoln Open has a death place whose location has a website
  24. 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
  25. 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 Open
    • and that has the highest-to-lowest ign
  26. give me all actors who were born in Berlin.
    give me every actor whose birth place is Berlin Open
  27. give me all actors who were born in Paris after 1950.
    give me every actor
    • whose birth place is Paris Open
    • and whose birth date is after 1950
  28. What was Brazil's lowest rank in the FIFA World Ranking?
    give me the fifa min of Brazil national football team Open
  29. Give me all Australian metalcore bands.
    give me every band
    • whose genre is Metalcore Open
    • and whose hometown is
      • Australia Open
      • or anything whose country is Australia Open
  30. When is Halloween?
    it is true that Halloween Open has a date
  31. How many inhabitants does the largest city in Canada have?
    it is true that Canada Open has a largest city that has a population total
  32. In which countries can you pay using the West African CFA franc?
    give me every country whose currency is West African CFA franc Open
  33. Give me the capitals of all countries that the Himalayas run through.
    it is true that Himalayas Open has a country that has a capital
  34. Who was the first to climb Mount Everest?
    it is true that Mount Everest Open has a first ascent person
  35. To which artistic movement did the painter of The Three Dancers belong?
    give me the movement of the author of The Three Dancers Open
  36. Which pope succeeded John Paul II?
    give me everything
    • that matches all of john , paul , II
    • and that has a successor
  37. What was the last movie with Alec Guinness?
    give me every film
    • whose starring is Alec Guinness Open
    • and that has the highest-to-lowest release date
  38. How many James Bond movies are there?
    • give me every film whose subject is Category:James Bond films Open
    • and give me the number of film
  39. Which actor played Chewbacca?
    it is true that Chewbacca Open has a portrayer
  40. 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.)
  41. Give me all writers that won the Nobel Prize in literature.
    give me every writer whose award is Nobel Prize in Literature Open
  42. What is the official color of the University of Oxford?
    it is true that University of Oxford Open has an official school colour
  43. Give me all Swedish oceanographers.
    give me every scientist
    • whose field is Oceanography Open
    • and whose nationality is Sweden Open
  44. 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.)
  45. Is James Bond married?
    give me every fictional character
    • that matches all of James, Bond
    • and that has a spouse
  46. Which spaceflights were launched from Baikonur?
    give me everything whose launch site is Baikonur Cosmodrome Open
  47. Give me all actors called Baldwin.
    give me everything
      • that is an actor
      • or whose occupation is Actor Open
    • and whose surname is Baldwin (en)
  48. What does CPU stand for?
    give me everything whose abbreviation is CPU (string)
  49. In which studio did the Beatles record their first album? OUT OF SCOPE
  50. How many gold medals did Michael Phelps win at the 2008 Olympics? OUT OF SCOPE

Example queries about Nobel Prizes

  1. List of Peace Nobel prize laureates, in decreasing year.
    give me every laureate whose nobel prize
    • has as a category Peace Open
    • and has the highest-to-lowest year
  2. 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
  3. 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.

  1. Find rivers taking their source in Russia, and flowing into a lake.
    give me every river
    • whose source is located in Russia Open
    • and that flows into a lake
  2. 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 Open
  3. Give French cities with a population higher than 200,000 located along a river.
    give me every city
    • that is the city of France Open
    • and whose population is higher or equal to 200000
    • and located at a river
  4. Which languages are spoken in Spain? In which proportions?
    give me every spoken language
    • whose country is Spain Open
    • and that has a language
    • and that has the highest-to-lowest percentage
  1. How many countries are there in Europe?
    • give me every country whose continent is Europe Open
    • and give me the number of country
  2. What is the average city population in China? Screencast
    • give me every city
      • that is the city of China Open
      • and that has a population
    • and give me the average population
  1. What is the population of continents, given the population of countries? Screencast
    • give me every country
      • that has a continent
      • and that has a population
    • and for each continent
      • give me the total population
  2. 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
  1. Give me the average population and the average area of countries, for each continent. Screencast
    • 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
  2. 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 Open
      • 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
  1. What is the average area of archipelagos, given that the area is only known for individual islands? Screencast
    • 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
  2. What is the distribution of the number of islands in archipelagos, i.e. the number of archipelagos for each number of islands per archipelago. Screencast
    • 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
  1. 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
  2. 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
  1. Give me countries whose GDP per capita (=total GDP*1e6/population) is above the average. Screencast
    • 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
  2. 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 Open
      • give me the number of river
    • and for the location United States Open
      • give me the number of river
    • and where the 1st number of river > the 2nd number of river
  3. 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
  1. List countries by decreasing population density (=population/area). Screencast
    • give me every country
      • that has a population
      • and that has an area
    • and give me highest-to-lowest the population / the area
  2. Which mountain range has the highest number of volcanos? Screencast
    • 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
  3. 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
  4. 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 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.

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

  1. Give me the list of tracks.
    give me every track
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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