Deliberation Knowledge Graph

SPARQL Query Interface

Use this interface to query the Deliberation Knowledge Graph using SPARQL. Enter your query in the text area below and click "Execute Query" to see the results.

Executing query...

Query Results

Results will appear here after executing a query.

Example Queries

Click on any of the example queries below to load it into the query editor.

List all deliberation processes

PREFIX del: <https://w3id.org/deliberation/ontology#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?process ?name
WHERE {
  ?process rdf:type del:DeliberationProcess ;
           del:name ?name .
}
LIMIT 10

Find all contributions by a specific participant

PREFIX del: <https://w3id.org/deliberation/ontology#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?contribution ?text
WHERE {
  ?contribution rdf:type del:Contribution ;
               del:text ?text ;
               del:madeBy ?participant .
  ?participant del:name "Iratxe García Pérez" .
}
LIMIT 10

Find all topics discussed in European Parliament debates

PREFIX del: <https://w3id.org/deliberation/ontology#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?topic ?name
WHERE {
  ?process rdf:type del:DeliberationProcess ;
           del:name ?processName ;
           del:hasTopic ?topic .
  ?topic del:name ?name .
  FILTER(CONTAINS(?processName, "European Parliament"))
}
LIMIT 20

List participants and their organizations

PREFIX del: <https://w3id.org/deliberation/ontology#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?participant ?name ?orgName
WHERE {
  ?participant rdf:type del:Participant ;
               del:name ?name ;
               del:isAffiliatedWith ?org .
  ?org del:name ?orgName .
}
LIMIT 20

Find responses to contributions

PREFIX del: <https://w3id.org/deliberation/ontology#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?contribution ?text ?responseTo
WHERE {
  ?contribution rdf:type del:Contribution ;
               del:text ?text ;
               del:responseTo ?responseTo .
}
LIMIT 10

About SPARQL

SPARQL (SPARQL Protocol and RDF Query Language) is a semantic query language for databases, able to retrieve and manipulate data stored in Resource Description Framework (RDF) format. It was made a standard by the W3C in 2008.

Basic SPARQL Query Structure

PREFIX prefix_name: <URI>

SELECT ?variable1 ?variable2 ...
WHERE {
  ?subject predicate ?object .
  ...
}

Common Prefixes for the Deliberation Knowledge Graph

PREFIX del: <https://w3id.org/deliberation/ontology#> - Deliberation Ontology
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> - RDF
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> - RDF Schema
PREFIX foaf: <http://xmlns.com/foaf/0.1/> - Friend of a Friend
PREFIX sioc: <http://rdfs.org/sioc/ns#> - Semantically-Interlinked Online Communities