Examples of SPARQL queries on data.gov.uk metadata

named-graphs.rq

#List of all the named graphs in the repository. <http://www.data.maudry.com/uk> is the named
#graph where most of the data is stored.

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dgfr: <http://colin.maudry.com/ontologies/dgfr#>
select distinct ?graph where {
  graph ?graph {
  ?s ?p ?o
  }
}

classes.rq

#List of RDF classes and for each, the number of instances

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dgfr: <http://colin.maudry.com/ontologies/dgfr#>
select distinct ?class (count(?thing) as ?numInstances) where {
  graph <http://www.data.maudry.com/uk> {
  ?thing a ?class .
  }
}
group by ?class
order by ?class

top-organizations.rq

#List of the organizations, ordered by number of published datasets.
#It also includes the number of distributions (actual files or resources).
 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dcat: <http://www.w3.org/ns/dcat#>
PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT ?organization (count (distinct ?dataset) as ?numDatasets)
(count (distinct ?distribution) as ?numDistributions)
WHERE {
  graph <http://www.data.maudry.com/uk> {
 ?dataset a dcat:Dataset ;
          dcterms:publisher ?organization ;
      			dcat:distribution ?distribution .  }
} 
group by ?organization
order by desc(?numDatasets)
limit 20