Retrieving Buyers for a Specific Date
This query retrieves buyers of contracts published on November 4, 2024, providing details about the organisations and their countries.
Output
-
Publication Number: The unique identifier for the notice.
-
Legal Name: The name of the buying organisation.
-
Country: The country where the buyer is registered.
Filters Applied
Publication Date: Filters results to contracts published on 2024-11-04. Country language: Retrieves country 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 ?country WHERE { FILTER (?publicationDate = "2024-11-04"^^xsd:date) GRAPH ?g { ?notice a epo:Notice ; epo:hasPublicationDate ?publicationDate ; epo:hasNoticePublicationNumber ?publicationNumber ; epo:announcesRole [ a epo:Buyer ; epo:playedBy [ epo:hasLegalName ?legalName ; cccev:registeredAddress [ epo:hasCountryCode ?countryUri ] ] ] . } ?countryUri a skos:Concept ; skos:prefLabel ?country . FILTER (lang(?country) = "en") }sparql
Structures Applied
Notice and Buyer Relationships
The query identifies organisations specifically playing the role of a buyer in contract notices. This is achieved through the epo:Buyer role, which captures organisations responsible for purchasing goods or services.
epo:announcesRole [ a epo:Buyer ; epo:playedBy [ epo:hasLegalName ?legalName ; cccev:registeredAddress [ epo:hasCountryCode ?countryUri ] ] ]sparql
