List the awarded tender amounts

This query retrieves information about awarded tenders from procurement notices published on a specific date. It focuses on extracting metadata such as the publication number, associated lots, tenderer details, and financial information.

Output

The query extracts the following details:

  • Publication Number: A unique identifier for the notice.

  • Lot URI: Identifies the lot associated with the award outcome.

  • Legal Name: The name of the tenderer who was awarded the lot.

  • Amount: The financial value of the awarded tender.

Filters Applied

  • Publication Date: Limits results to notices published on 2024-11-04.

  • Currency: Restricts results to tenders with a specific currency (not defined in this example query).

Query

The complete SPARQL query is as follows:

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 ?publicationNumber ?lotUri ?legalName ?amount
WHERE {
  FILTER (?publicationDate = "2024-11-04"^^xsd:date)
  FILTER (?currencyUri = <http://publications.europa.eu/resource/authority/currency/EUR>)
  ?noticeUri a epo:Notice ;
             epo:hasPublicationDate ?publicationDate ;
             epo:hasNoticePublicationNumber ?publicationNumber ;
             epo:announcesAwardDecision [
       a epo:AwardDecision ;
       epo:comprisesAwardOutcome [
         a epo:LotAwardOutcome ;
         epo:hasAwardStatus <http://publications.europa.eu/resource/authority/winner-selection-status/selec-w> ;
         epo:concernsLot ?lotUri ;
         epo:comprisesTenderAwardOutcome [
           a epo:TenderAwardOutcome ;
           epo:concernsTender [
             a epo:Tender ;
             epo:isSubmitedBy [
               a epo:Tenderer ;
               epo:playedBy [
                 epo:hasLegalName ?legalName
               ]
             ] ;
             epo:hasFinancialOfferValue [
               a epo:MonetaryValue ;
               epo:hasAmountValue ?amount ;
               epo:hasCurrency ?currencyUri
             ]
           ]
         ]
       ]
     ] .
}
ORDER BY DESC(?amount)
sparql

Structures applied

Notice and Award Metadata Extraction

The query identifies notices and their corresponding award decisions and outcomes.

Notices and Awards

Notices are connected to award decisions through the following structure:

?noticeUri epo:announcesAwardDecision [
         a epo:AwardDecision ;
         epo:comprisesAwardOutcome ?awardOutcome .
    ]
sparql

Awards and Lots

Each award decision includes outcomes related to specific lots, structured as follows:

?awardOutcome a epo:LotAwardOutcome ;
              epo:concernsLot ?lotUri ;
sparql

Tenderers, Tenders, and Financial Details

Awarded lots are associated with tenders, which provide detailed information about the tenderer and their financial offer.

Connecting Tenders to Awards

The connection between tenderUri and the award decision is established as follows:

?awardOutcome epo:comprisesTenderAwardOutcome [
  a epo:TenderAwardOutcome ;
  epo:concernsTender ?tenderUri .
] .
sparql

Tenderer and Financial Offer Details

For each tender, the query retrieves information about the submitting tenderer and the financial offer:

?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 highlights the relationships between procurement notices, awarded tenders, and financial details. By navigating through the structure of award decisions and outcomes, the query links notices to the awarded tenders and provides a comprehensive view of tenderer details and awarded amounts.


Any comments on the documentation?