Tenders Electronic Daily (TED) (csv Subset) – Public Procurement Notices by European Commission Directorate-General for Internal Market, Industry, Entrepreneurship and SMEs (DG GROW) | Finance and Economics

About this Dataset

Tenders Electronic Daily (TED) (csv Subset) – Public Procurement Notices

A subset of Tenders Electronic Daily (TED) data covering public procurement for the European Union and beyond from 2006-01-01 to 2023-12-31 in comma separated value (CSV) format. This data includes the most important fields from the contract notice and contract award notice standard forms, such as who bought what from whom, for how much, and which procedure and award criteria were used. Generally, the data consists of tenders above the procurement thresholds. However, publishing below threshold tenders in TED is considered good practice, and thus a non-negligible number of below threshold tenders is present as well. Please see the documentation below for important information on the data and its usage, including a version history of the export. The European Commission is interested in the results of research on public procurement coming from the re-use of this data. Thus, we will be grateful to receive links to any papers, reports, or applications at GROW-G4@ec.europa.eu. TED with broader coverage is also available in XML format at https://data.europa.eu/euodp/en/data/dataset/ted-1. eForms On 14 November 2022, the format of notices published in TED changed: the Publications Office displays both the current standard forms and eForms and makes them available for reuse. If you reuse TED data, your systems must be ready to process both types of notices. To help adapt your systems, you can find resources, models and schemas in the eForms Software Development Kit on GitHub (https://github.com/OP-TED/eForms-SDK/https://github.com/OP-TED/eForms-SDK/). Documentation is available on the Ted Developers Documentation site (https://docs.ted.europa.eu/), including eForms FAQs (https://docs.ted.europa.eu/home/FAQ/eforms.html).
Publisher name: Directorate-General for Internal Market, Industry, Entrepreneurship and SMEs
Publisher URL: https://commission.europa.eu/about/departments-and-executive-agencies/internal-market-industry-entrepreneurship-and-smes
Last updated: 2024-06-11T18:09:26Z

Tables

A) TED V2.2 – Contract Award Notice 2009-2015 (*deprecated Version Of The Data: For Reference Only)

@ecdggrow.ted_csv.a_ted_v2_2_contract_award_notice_2009_2015_deprecated__9c2567b7

59.14 MB
542376 rows
50 columns


CREATE TABLE a_ted_v2_2_contract_award_notice_2009_2015_deprecated__9c2567b7 (
  "id_notice_can" BIGINT,
  "year" BIGINT,
  "id_type" BIGINT,
  "dt_dispatch" VARCHAR,
  "xsd_version" VARCHAR,
  "cancelled" BIGINT,
  "corrections" BIGINT,
  "cae_name" VARCHAR,
  "cae_nationalid" VARCHAR,
  "cae_address" VARCHAR,
  "cae_town" VARCHAR,
  "cae_postal_code" VARCHAR,
  "iso_country_code" VARCHAR,
  "cae_type" VARCHAR,
  "main_activity" VARCHAR,
  "b_on_behalf" VARCHAR,
  "type_of_contract" VARCHAR,
  "tal_location_nuts" VARCHAR,
  "b_fra_agreement" VARCHAR,
  "fra_estimated" VARCHAR,
  "b_dyn_purch_syst" VARCHAR,
  "cpv" BIGINT,
  "additional_cpvs" VARCHAR,
  "b_gpa" VARCHAR,
  "value_euro" DOUBLE,
  "value_euro_fin_1" DOUBLE,
  "value_euro_fin_2" DOUBLE,
  "top_type" VARCHAR,
  "crit_code" VARCHAR,
  "crit_criteria" VARCHAR,
  "crit_weights" VARCHAR,
  "b_electronic_auction" VARCHAR,
  "number_awards" BIGINT,
  "id_award" DOUBLE,
  "contract_number" VARCHAR,
  "lot_number" VARCHAR,
  "title" VARCHAR,
  "win_name" VARCHAR,
  "win_address" VARCHAR,
  "win_town" VARCHAR,
  "win_postal_code" VARCHAR,
  "win_country_code" VARCHAR,
  "number_offers" DOUBLE,
  "number_offers_electr" DOUBLE,
  "award_est_value_euro" DOUBLE,
  "award_value_euro" DOUBLE,
  "award_value_euro_fin_1" DOUBLE,
  "b_subcontracted" VARCHAR,
  "b_eu_funds" VARCHAR,
  "dt_award" VARCHAR
);

E) TED V2.2 – Contract Notices 2009-2015 (*deprecated Version Of The Data: For Reference Only)

@ecdggrow.ted_csv.e_ted_v2_2_contract_notices_2009_2015_deprecated_versi_0546f2fe

17.65 MB
190643 rows
53 columns


CREATE TABLE e_ted_v2_2_contract_notices_2009_2015_deprecated_versi_0546f2fe (
  "id_notice_cn" BIGINT,
  "year" BIGINT,
  "id_type" BIGINT,
  "dt_dispatch" VARCHAR,
  "xsd_version" VARCHAR,
  "cancelled" BIGINT,
  "corrections" BIGINT,
  "future_can_id" DOUBLE,
  "future_can_id_estimated" BIGINT,
  "cae_name" VARCHAR,
  "cae_nationalid" VARCHAR,
  "cae_address" VARCHAR,
  "cae_town" VARCHAR,
  "cae_postal_code" VARCHAR,
  "iso_country_code" VARCHAR,
  "cae_type" VARCHAR,
  "main_activity" VARCHAR,
  "b_on_behalf" VARCHAR,
  "type_of_contract" VARCHAR,
  "tal_location_nuts" VARCHAR,
  "b_fra_agreement" VARCHAR,
  "fra_estimated" VARCHAR,
  "b_fra_single_operator" VARCHAR,
  "fra_number_operators" DOUBLE,
  "fra_number_max_operators" DOUBLE,
  "b_dyn_purch_syst" VARCHAR,
  "cpv" DOUBLE,
  "additional_cpvs" VARCHAR,
  "b_gpa" VARCHAR,
  "lots_number" DOUBLE,
  "lots_submission" VARCHAR,
  "b_variants" VARCHAR,
  "value_euro" DOUBLE,
  "value_euro_fin_1" DOUBLE,
  "b_options" VARCHAR,
  "b_renewals" VARCHAR,
  "duration" DOUBLE,
  "contract_start" VARCHAR,
  "contract_completion" VARCHAR,
  "procedure" VARCHAR,
  "env_operators" DOUBLE,
  "env_min_operators" DOUBLE,
  "env_max_operators" DOUBLE,
  "crit_code" VARCHAR,
  "crit_criteria" VARCHAR,
  "crit_weights" VARCHAR,
  "b_electronic_auction" VARCHAR,
  "dt_applications" VARCHAR,
  "b_language_any_ec" VARCHAR,
  "admin_languages_tender" VARCHAR,
  "admin_other_languages_tender" VARCHAR,
  "b_recurrent_procurement" VARCHAR,
  "b_eu_funds" VARCHAR
);

D) TED V1 - Contract Notices And Contract Award Notices 2009-2015 (*deprecated Version Of The Data: For Reference Only)

@ecdggrow.ted_csv.d_ted_v1_contract_notices_and_contract_award_notices_2_38eb1d51

296 MB
3372973 rows
45 columns


CREATE TABLE d_ted_v1_contract_notices_and_contract_award_notices_2_38eb1d51 (
  "year" BIGINT,
  "id_notice" BIGINT,
  "id_type" BIGINT,
  "cae_name" VARCHAR,
  "cae_nationalid" VARCHAR,
  "cae_address" VARCHAR,
  "cae_town" VARCHAR,
  "cae_postal_code" VARCHAR,
  "iso_country_code" VARCHAR,
  "cae_type" VARCHAR,
  "main_activity" VARCHAR,
  "on_behalf" VARCHAR,
  "type_of_contract" VARCHAR,
  "tal_location_nuts" VARCHAR,
  "fra_agreement" VARCHAR,
  "dyn_purch_syst" VARCHAR,
  "cpv" DOUBLE,
  "additional_cpvs" VARCHAR,
  "gpa" VARCHAR,
  "top_type" VARCHAR,
  "crit_code" VARCHAR,
  "crit_criteria" VARCHAR,
  "crit_weights" VARCHAR,
  "electronic_auction" VARCHAR,
  "vc_value_euros" DOUBLE,
  "number_awards" BIGINT,
  "cancelled" BIGINT,
  "id_award" DOUBLE,
  "lot_number_text" VARCHAR,
  "win_name" VARCHAR,
  "win_address" VARCHAR,
  "win_town" VARCHAR,
  "win_postal_code" VARCHAR,
  "win_country_code" VARCHAR,
  "number_offers" DOUBLE,
  "number_offers_electronic" DOUBLE,
  "estimated_value_euros" DOUBLE,
  "tfv_euros" VARCHAR,
  "value_euros" VARCHAR,
  "subcontracted" VARCHAR,
  "eu_funds" VARCHAR,
  "dt_award" VARCHAR,
  "dt_dispatch" VARCHAR,
  "dt_applications" VARCHAR,
  "lots_number" DOUBLE
);