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?