Hey there! No worries at all—starting with DBpedia is such a fun way to dive into structured linked data, and these are perfect first queries to get your feet wet. Let me break down exactly how to pull the data you want using SPARQL.

Extracting Countries, Capitals, and Population Data #

DBpedia uses standardized ontologies to structure Wikipedia data, so we'll leverage properties like dbo:Country (for country entities), dbo:capital (linking to capital cities), and dbo:populationTotal (for population figures).

Here's a SPARQL query that pulls this data, filtering out entries where population might be missing:

SELECT ?countryName ?capitalName ?population
WHERE {
  ?country a dbo:Country ;
           rdfs:label ?countryName ;
           dbo:capital ?capital ;
           dbo:populationTotal ?population .
  ?capital rdfs:label ?capitalName .
  FILTER(LANG(?countryName) = "en" && LANG(?capitalName) = "en")
  FILTER(?population > 0) # Exclude entries with no valid population data
}
ORDER BY ?countryName

Quick breakdown: #

• ?country a dbo:Country: We're targeting all entities classified as countries
• rdfs:label ?countryName: Grabs the English name of each country (and capital, for ?capitalName)
• dbo:capital ?capital: Links each country to its capital entity
• dbo:populationTotal ?population: Pulls the total population value
• The filters ensure we only get English labels and valid, positive population numbers

Getting 100 Random Famous People with Birth Details & Descriptions #

For this, we'll target dbo:Person entities, pull their birth date, birth place, and English description. To get random entries, we'll use ORDER BY RAND() and LIMIT 100.

Here's the query:

SELECT ?personName ?birthDate ?birthPlace ?description
WHERE {
  ?person a dbo:Person ;
          rdfs:label ?personName ;
          dbo:birthDate ?birthDate ;
          dbo:birthPlace ?birthPlace ;
          rdfs:comment ?description .
  FILTER(LANG(?personName) = "en" && LANG(?description) = "en")
  FILTER(LANG(?birthPlace) = "en") # Ensure birth place name is in English
}
ORDER BY RAND()
LIMIT 100

Quick breakdown: #

• ?person a dbo:Person: Targets all person entities in DBpedia
• dbo:birthDate/dbo:birthPlace: Pulls the required birth details
• rdfs:comment ?description: Grabs the short English description from Wikipedia
• ORDER BY RAND() shuffles the results randomly, and LIMIT 100 gives us exactly 100 entries

Pro Tips: #

• You can run these queries directly in the DBpedia SPARQL endpoint (no setup needed!)
• If you want to narrow down people to a specific domain (e.g., actors, scientists), add an extra triple like ?person dbo:occupation dbo:Actor to the WHERE clause
• For countries, you could add a filter to focus on a region (e.g., ?country dbo:region dbr:Europe) if you don't want the entire global list

内容的提问来源于stack exchange，提问作者Ubercoder