Retrieving Contracts for a Specific Date
This query retrieves contracts published on November 4, 2024, filtered and sorted to meet specific criteria.
Output
-
Contract Title: The title of the contract.
-
Conclusion Date: The date when the contract was finalized.
-
Lot Information: The associated lots for each contract.
-
Financial Information: The contract amount and its corresponding currency.
Filters Applied
-
Publication Date: Filters results to contracts published on
2024-11-04. -
Currency: Restricts the results to contracts involving transactions in Euros (EUR).
-
Sorting: Orders the results by contract amount in descending order.
Query
The complete query in SPARQL is as follows:
PREFIX dct: <http://purl.org/dc/terms/> PREFIX dc: <http://purl.org/dc/elements/1.1/> PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX epo: <http://data.europa.eu/a4g/ontology#> PREFIX cccev: <http://data.europa.eu/m8g/> PREFIX dcterms: <http://purl.org/dc/terms/> PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> PREFIX skos: <http://www.w3.org/2004/02/skos/core#> SELECT ?contractTitle ?conclusionDate ?lotUri ?amount ?currency WHERE { FILTER (?publicationDate = "2024-11-04"^^xsd:date) FILTER (?currencyUri = <http://publications.europa.eu/resource/authority/currency/EUR>) ?noticeUri a epo:Notice ; epo:refersToLot ?lotUri ; epo:hasPublicationDate ?publicationDate ; epo:hasNoticePublicationNumber ?publicationNumber . ?contractUri a epo:Contract ; dct:title ?contractTitle ; epo:hasContractConclusionDate ?conclusionDate ; epo:includesTender [ a epo:Tender ; epo:isSubmittedForLot ?lotUri ; epo:hasFinancialOfferValue [ a epo:MonetaryValue ; epo:hasAmountValue ?amount ; epo:hasCurrency ?currencyUri ] ] . ?currencyUri dc:identifier ?currency . } ORDER BY DESC(?amount)sparql
Structures Applied
Notices and Lots
Notices are linked to specific lots using the property epo:refersToLot.
This relationship associates each notice with its corresponding lot(s) as shown below:
?noticeUri epo:refersToLot ?lotUri .sparql
Contracts and Lots
Contracts are tied to lots and include details such as contract title, conclusion date, and financial offer values. The structure is as follows:
?contractUri a epo:Contract ; dct:title ?contractTitle ; epo:hasContractConclusionDate ?conclusionDate ; epo:includesTender [ a epo:Tender ; epo:isSubmittedForLot ?lotUri ; epo:hasFinancialOfferValue [ a epo:MonetaryValue ; epo:hasAmountValue ?amount ; epo:hasCurrency ?currencyUri ] ] .sparql
Award Decision and Outcomes
Notices may also announce award decisions linked to specific lots, as seen in the following structure:
?noticeUri epo:announcesAwardDecision [ a epo:AwardDecision ; epo:comprisesAwardOutcome ?awardOutcome . ]sparql
Award outcomes are linked to lots, as shown below:
?awardOutcome a epo:LotAwardOutcome ; epo:concernsLot ?lotUri ;sparql
Tenderers, Tenders, and Financial Information
Each lot is associated with tenders containing information about the tenderer, their financial offers, and the link to the award decision. The relationship is shown below:
?awardOutcome epo:comprisesTenderAwardOutcome [ a epo:TenderAwardOutcome ; epo:concernsTender ?tenderUri . ] .sparql
Tenderers and financial details are linked through the following structure:
?tenderUri a epo:Tender ; epo:isSubmitedBy [ a epo:Tenderer ; epo:playedBy [ epo:hasLegalName ?legalName ] ] ; epo:hasFinancialOfferValue [ a epo:MonetaryValue ; epo:hasAmountValue ?amount ; epo:hasCurrency ?currencyUri ] .sparql
