elx_make_query: Create SPARQL queries
In eurlex: Retrieve Data on European Union Law

View source: R/elx_make_query.R

elx_make_query

R Documentation

Create SPARQL queries

Description

Generates pre-defined or manual SPARQL queries to retrieve document ids from Cellar. List of available resource types: http://publications.europa.eu/resource/authority/resource-type . Note that not all resource types are compatible with default parameter values.

Usage

elx_make_query(
  resource_type = c("any", "directive", "regulation", "decision", "recommendation",
    "intagr", "caselaw", "manual", "proposal", "national_impl"),
  manual_type = "",
  directory = NULL,
  sector = NULL,
  include_corrigenda = FALSE,
  include_celex = TRUE,
  include_lbs = FALSE,
  include_date = FALSE,
  date_from = NULL,
  date_to = NULL,
  include_date_force = FALSE,
  include_date_endvalid = FALSE,
  include_date_transpos = FALSE,
  include_date_lodged = FALSE,
  include_force = FALSE,
  include_eurovoc = FALSE,
  include_citations = FALSE,
  include_citations_detailed = FALSE,
  include_author = FALSE,
  include_title = FALSE,
  include_directory = FALSE,
  include_directory_code = FALSE,
  include_sector = FALSE,
  include_ecli = FALSE,
  include_court_procedure = FALSE,
  include_judge_rapporteur = FALSE,
  include_advocate_general = FALSE,
  include_court_formation = FALSE,
  include_court_scholarship = FALSE,
  include_court_origin = FALSE,
  include_original_language = FALSE,
  include_proposal = FALSE,
  order = FALSE,
  limit = NULL
)

Arguments

`resource_type`	Type of resource to be retrieved via SPARQL query
`manual_type`	Define manually the type of resource to be retrieved
`directory`	Restrict the results to a given directory code
`sector`	Restrict the results to a given sector code
`include_corrigenda`	If `TRUE`, results include corrigenda
`include_celex`	If `TRUE`, results include CELEX identifier for each resource URI
`include_lbs`	If `TRUE`, results include legal bases of legislation
`include_date`	If `TRUE`, results include document date
`date_from`	Restrict results to documents dated on or after this date, in `YYYY-MM-DD` format
`date_to`	Restrict results to documents dated on or before this date, in `YYYY-MM-DD` format
`include_date_force`	If `TRUE`, results include date of entry into force
`include_date_endvalid`	If `TRUE`, results include date of end of validity
`include_date_transpos`	If `TRUE`, results include date of transposition deadline for directives
`include_date_lodged`	If `TRUE`, results include date a court case was lodged with the court
`include_force`	If `TRUE`, results include whether legislation is in force
`include_eurovoc`	If `TRUE`, results include EuroVoc descriptors of subject matter
`include_citations`	If `TRUE`, results include citations (CELEX-labelled)
`include_citations_detailed`	If `TRUE`, results include citations (CELEX-labelled) with additional details
`include_author`	If `TRUE`, results include document author(s)
`include_title`	If `TRUE`, results include document title in English
`include_directory`	If `TRUE`, results include the label of the Eur-Lex directory code
`include_directory_code`	If `TRUE`, results include the Eur-Lex directory code
`include_sector`	If `TRUE`, results include the Eur-Lex sector code
`include_ecli`	If `TRUE`, results include the ECLI identifier for court documents
`include_court_procedure`	If `TRUE`, results include type of court procedure and outcome
`include_judge_rapporteur`	If `TRUE`, results include the Judge-Rapporteur
`include_advocate_general`	If `TRUE`, results include the Advocate General
`include_court_formation`	If `TRUE`, results include the court formation
`include_court_scholarship`	If `TRUE`, results include court-curated relevant scholarship
`include_court_origin`	If `TRUE`, results include country of origin of court case
`include_original_language`	If `TRUE`, results include authentic language of document (usually case)
`include_proposal`	If `TRUE`, results include the CELEX of the proposal of the adopted legal act
`order`	Order results by ids
`limit`	Limit the number of results, for testing purposes mainly

Details

When date_from or date_to are specified, the underlying SPARQL query requires ?date to be a well-formed xsd:date. Any document whose date does not resolve to a valid xsd:date would be silently excluded from the filtered results, without a warning or error.

When include_author is TRUE, the query uses GROUP_CONCAT to combine multiple authors for the same document into a single pipe-separated (|) string in the author column, rather than returning one row per author. This avoids duplicate rows for documents with multiple authors, but means the query switches from ⁠SELECT DISTINCT⁠ to ⁠SELECT ... GROUP BY⁠ internally when include_author is used.

Value

A character string containing the SPARQL query

Examples

elx_make_query(resource_type = "directive", include_date = TRUE, include_force = TRUE)
elx_make_query(resource_type = "directive", include_title = TRUE)
elx_make_query(resource_type = "directive", date_from = "2015-01-01", date_to = "2015-12-31")
elx_make_query(resource_type = "regulation", include_corrigenda = TRUE, order = TRUE)
elx_make_query(resource_type = "any", sector = 2)
elx_make_query(resource_type = "manual", manual_type = "SWD")

eurlex documentation built on Oct. 23, 2026, 1:06 a.m.