List competition notices, buyers and their countries on a chosen date
This query retrieves a list of publications, procedure types for competition notices published on November 4, 2024.
Output
The query produces the following details for each competition notice:
-
Publication Number: The unique identifier for the competition notice.
-
Legal Name: The name of the buying organisation.
-
Procedure Type: The specific type of procurement procedure.
-
Country: The country of the buying organisation.
Filters Applied
The query restricts results to:
-
Publication Date: Filters results to notices published on 2024-11-04.
-
Form Type: Restricts results to competition notices.
-
Procedure Type language: Only retrieves procedure type names in English.
Query
The complete query in SPARQL is as follows:
PREFIX dc: <http://purl.org/dc/elements/1.1/> PREFIX epo: <http://data.europa.eu/a4g/ontology#> PREFIX cccev: <http://data.europa.eu/m8g/> PREFIX org: <http://www.w3.org/ns/org#> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT DISTINCT ?publicationNumber ?legalName ?procedureType ?country WHERE { FILTER (?publicationDate = "2024-11-04"^^xsd:date) FILTER (?formType = <http://publications.europa.eu/resource/authority/form-type/competition>) GRAPH ?g { ?notice epo:hasPublicationDate ?publicationDate ; epo:refersToProcedure [ epo:hasProcedureType ?procedureTypeUri ; a epo:Procedure ] ; epo:hasNoticePublicationNumber ?publicationNumber ; epo:hasFormType ?formType ; epo:announcesRole [ a epo:Buyer ; epo:playedBy [ epo:hasLegalName ?legalName ; cccev:registeredAddress [ epo:hasCountryCode ?countryUri ] ] ] } ?procedureTypeUri a skos:Concept ; skos:prefLabel ?procedureType. FILTER (lang(?procedureType) = "en") ?countryUri dc:identifier ?country. }
sparql
Structures Applied
Competition Notice Identification
The query specifically targets competition notices, which have a specific form type URI.
FILTER (?formType = <http://publications.europa.eu/resource/authority/form-type/competition>) ?notice epo:hasFormType ?formType ;
sparql
Buyer Organisation Details
The query extracts the legal name and country about organisations that play the epo:Buyer role.
?notice epo:announcesRole [ a epo:Buyer ; epo:playedBy [ epo:hasLegalName ?legalName ; cccev:registeredAddress [ epo:hasCountryCode ?countryUri ] ] ] ?countryUri dc:identifier ?country.
sparql