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 — or as an interactive chart (bar, line, pie, scatter) via the Table / Chart toggle when the results are chartable.
• 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, the Connect your app button gives you the link, and the commands, to run the same query from your own tools.
  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
• Type prefixes to insert all standard PREFIX declarations at once
• Type currency to insert a currency-conversion snippet — an exchange-rate lookup table plus a BIND that converts monetary amounts to EUR
• Press Ctrl+Space to manually trigger suggestions at any time

Autocomplete covers terms from ePO v3 (Standard Forms) and v4 (eForms). Version-specific terms are labelled (v3) or (v4) in the suggestions; terms common to both versions have no label.

The exchange rates in the currency snippet are approximate and provided only to illustrate how conversion can be expressed in SPARQL. They are sourced from the European Commission's monthly InforEuro accounting rates and refreshed periodically. Amounts are converted at the latest available rate — not the rate at the time each notice was published — so do not rely on the result for precise or legally meaningful figures.

Query Library

The Query Library provides example SPARQL queries to help you get started. Pick one and press Run query. Where a query has values you can change — a date, a period, an identifier — you are asked for them first, so you can ask about the day or range you care about without editing any SPARQL. Press Customise instead to open the query in the editor and change it yourself.

If you'd like to contribute new queries, improve existing ones, or add comments to make them clearer, see the contributing guide. It also explains how to let readers change a query's values.

Questions & feedback

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