Ted open data

Help

The TED Open Data Service lets you explore the entire collection of public procurement data published by the Publications Office of the EU. You can look up individual notices and inspect their full RDF graph, or write SPARQL queries to extract custom datasets across many notices. Both flows use the same Linked Open Data backend and the same eProcurement Ontology (ePO).

For a broader introduction to TED Open Data, ePO, and SPARQL, visit our documentation website.

Looking up a notice

• Use the Search tab to look up a notice by its publication number (e.g. 00676595-2024).
• Click pick a random notice to explore a recent notice chosen at random.
• Results appear in the Query Results tab as a collapsible tree of RDF triples.
• Use Tree view for a hierarchical, navigable structure.
• Use Turtle view to see the raw RDF serialization.
• Use Backlinks view to see which other resources reference the current one.
• Click the history button in the Search tab to revisit a past search; click Clear history at the bottom of that menu to wipe the list.

Navigating the tree

• Click any type badge to drill into that resource. Badge text reads "Type identifier" (e.g. "Lot LOT-0001", "SettledContract CON-0001") or just "Type" when the resource has no identifier.
• Your path is shown as a breadcrumb at the top of the Query Results tab. Click any step to jump back.
• Each nested card shows a subject (e.g. a Lot, an Organization) with its properties.
• Click the icon in the breadcrumb to return to the notice you started with.

Procedure timeline

When you search a notice, its procedure timeline is shown as a collapsible mini-card above the tree. Every notice within the same procedure is listed with colour-coded cards: green for the original publication, yellow for subsequent amendments (marked with a v2, v3, … badge next to the publication number). Cards are ordered oldest-first; same-day amendments are broken by version. Click any notice in the timeline to navigate to it.

Sharing a notice view

Click the share button next to the notice title to copy a URL that loads the current notice or sub-resource directly. Paste it into an email, a ticket, or another browser tab to share your exploration. Click the download button to export the RDF data as Turtle, RDF/XML, or N-Triples.

Writing SPARQL queries

• Use the Query Library tab to explore suggested SPARQL queries. These will help you get started.
• Use the Query Editor tab to compose your SPARQL query.
• To test your query use the Run Query button.
• SELECT and ASK results are displayed in the Query Results tab as a table.
• CONSTRUCT and DESCRIBE results are displayed in the Query Results tab as an RDF graph (the same tree/turtle/backlinks view used by notice lookup).
• For SELECT queries you can get a URL that runs the query directly by clicking on the Copy URL button.
  You can use this URL to run your query and retrieve live results directly into Excel, Power BI, or any application that can get data from the web.
• To download a copy of the data retrieved by a SELECT query, use the Download button.

Autocomplete in the editor

The query editor provides autocomplete suggestions as you type:

• Type PREFIX to see available namespace prefixes
• Type epo: followed by a class or property name to see ePO ontology suggestions
• Type a after a subject to see available ePO classes
• SPARQL keywords are suggested as you type
• Press Ctrl+Space to manually trigger suggestions at any time

Autocomplete is based on the eProcurement Ontology (ePO) v4.2.0.

Query Library

The Query Library provides example SPARQL queries to help you get started. If you'd like to contribute new queries, improve existing ones, or add comments to make them clearer, see the contributing guide.

Questions & feedback

For questions and feedback, please visit our GitHub Discussions forum.