How Can I Retrieve Tender Value and Deadline from the TED SPARQL Endpoint? - Stack Overflow

I'm working with the TED (Tenders Electronic Daily) SPARQL endpoint () to extract public procurement tender information. I have the following query based on a keyword. My query successfully returns fields like publication number, legal name, publication date, title, and description.

I have been searching for online resources for SPARQL queries but I am unable to find the fields for tender value or tender deadline data.

PREFIX dc: <.1/>
PREFIX dcterms: </>
PREFIX epo: <;
PREFIX cccev: </>
PREFIX skos: <;
PREFIX xsd: <;

SELECT DISTINCT ?publicationNumber ?legalName ?publicationDate ?title ?description
WHERE {
  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
                    ]
                ]
            ] ;
            epo:refersToProcedure [
                dcterms:title ?title ;
                dcterms:description ?description
            ] .
  }
  ?countryUri skos:prefLabel "Ireland"@en .
  FILTER (
    CONTAINS(LCASE(STR(?title)), "construction") ||
    CONTAINS(LCASE(STR(?description)), "construction")
  )
}
ORDER BY ?publicationDate

Result of SPARQL query.

Is there a source that has all the fields available for TED Tenders?

I'm working with the TED (Tenders Electronic Daily) SPARQL endpoint (https://publications.europa.eu/webapi/rdf/sparql) to extract public procurement tender information. I have the following query based on a keyword. My query successfully returns fields like publication number, legal name, publication date, title, and description.

I have been searching for online resources for SPARQL queries but I am unable to find the fields for tender value or tender deadline data.

PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX dcterms: <http://purl.org/dc/terms/>
PREFIX epo: <http://data.europa.eu/a4g/ontology#>
PREFIX cccev: <http://data.europa.eu/m8g/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT DISTINCT ?publicationNumber ?legalName ?publicationDate ?title ?description
WHERE {
  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
                    ]
                ]
            ] ;
            epo:refersToProcedure [
                dcterms:title ?title ;
                dcterms:description ?description
            ] .
  }
  ?countryUri skos:prefLabel "Ireland"@en .
  FILTER (
    CONTAINS(LCASE(STR(?title)), "construction") ||
    CONTAINS(LCASE(STR(?description)), "construction")
  )
}
ORDER BY ?publicationDate

Result of SPARQL query.

Is there a source that has all the fields available for TED Tenders?

• sparql

Share Improve this question Follow edited Feb 4 at 17:07 Stefan - brox IT-Solutions 2,28566 silver badges1616 bronze badges asked Feb 4 at 15:24 ChristopherChristopher 62733 gold badges99 silver badges2323 bronze badges 2

• the RDF data model and also how to get the data including value and the like is documented here: docs.ted.europa.eu/ODS/latest/samples/query-3.html and also as snippets here: docs.ted.europa.eu/ODS/latest/snippets/index.html – UninformedUser Commented Feb 5 at 8:36
• The situation witn values is a bit complicated. You can get some insights from this query. The query is not optimised and might timeout at the endpoint you use, but it should give you an idea. – Ivo Velitchkov Commented Feb 5 at 15:07

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

This should work for the tender value:

       epo:refersToProcedure 
        [
          epo:hasEstimatedValue  
          [
            epo:hasAmountValue ?estimatedValue ;
            epo:hasCurrency ?currency;
          ];
          a epo:Procedure
        ] ;

If you figured out how to recieve the deadline, let me know it please. I have the same issue.