This is a tool for bulk downloading lists of EU Regulations in spreadsheet format.

It searches the EU's CELLAR database of European law via its SPARQL API and processes the results into a useful spreadsheet. (The CELLAR database sits behind the Eur-lex website. )

Technologies:

SPARQL code sample 1: List of subject areas, ordered by number of in-force regulations in each area. 

PREFIX cdm: <http://publications.europa.eu/ontology/cdm#> 
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

select count(distinct(?work)) as ?co ?subject ?label where {

 { ?work cdm:resource_legal_has_type_act_concept_type_act <http://publications.europa.eu/resource/authority/resource-type/REG> }
  UNION
 { ?work rdf:type cdm:regulation }.
 FILTER NOT EXISTS{
  ?work cdm:resource_legal_in-force 'false'^^xsd:boolean
 } 
 ?work cdm:resource_legal_is_about_subject-matter ?subject .
 ?subject <http://www.w3.org/2004/02/skos/core#prefLabel> ?label .
 FILTER ( lang(?label) = "en" ) .
}
ORDER BY desc(?co)

LIMIT 500

SPARQL code sample 2: English language titles 


(snippet)
 ?work rdf:type cdm:regulation .
 ?expression cdm:expression_belongs_to_work ?work .
 ?expression cdm:expression_title ?title .
 ?expression cdm:expression_uses_language <http://publications.europa.eu/resource/authority/language/ENG> .
Valid XHTML 1.0!