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

Summary

This query efficiently retrieves contract information for a specific publication date. The results include details such as contract title, conclusion date, financial amounts, and currencies.


Any comments on the documentation?