Notice des variables sur la commande publique européenne

Les données

  • Télécharger les données dans le répertoire d’archive à l’adresse suivante : Téléchargement

Notice des variables

Variables Notes
Notice metadata  
ID_NOTICE_CAN Unique identifier of the contract award notice
YEAR Year of publication of the notice
ID_TYPE standard form number
DT_DISPATCH The date when the buyer dispatched (sent) the notice for publication to TED.
XSD_VERSION Version of the XML schema definition used by the Publications Office of the EU to publish the data. Higher versions mean better average quality of data. The lowest version is “2.0.5”, the highest “2.0.8”; notices before 2006 are of the lowest quality and do not have version information. [ADDED]
CANCELLED 1 = this notice was later cancelled  [ADDED]
CORRECTIONS Number of later notices which corrected or added information to this notice (see standard form 14). [ADDED]
Contracting authority or entity identification  
CAE_NAME “Official name”
CAE_NATIONALID “National ID” e.g. VAT number for utilities
CAE_ADDRESS “Postal address”
CAE_POSTAL_CODE “Postal code”
Various CAN level variables  
CAE_TYPE[1] Type of contracting authority. The values are the following:

  • 1 “Central government”
  • 2 “Armed forces”
  • 3 “Local authorities”
  • 4 “Water, energy, transport and telecommunications sectors”
  • 5 “European Union institution/agency”
  • 5A “other international organisation”
  • 6 “Body governed by public law”
  • 8 “Other”
  • 9 “Not applicable”
  • N “National or federal Agency / Office”
  • R “Regional or local Agency / Office”
  • Z “Not specified”

The distinction between 5 and 5A has been [ADDED] on the basis of data not included in the standard forms.

Please note that procurement by “European Union institution/agency” will generally not be covered by public procurement legislation, but by the Financial Regulation of the EU. Thus, it may be appropriate to exclude them from analyses dealing with the procurement directives. Similarly, it might be appropriate to exclude these observations for analyses of national level procurement, since the responsibility for this procurement lies at the EU level.

MAIN_ACTIVITY[2] (The classification corresponds to COFOG divisions.)
B_ON_BEHALF This indicates either a central purchasing body or several buyers buying together (i.e. occasional joint procurement).
TYPE_OF_CONTRACT Type of contract. The values are the following:

  • W “Works”
  • U “Supplies”
  • S “Services”
TAL_LOCATION_NUTS The Nomenclature of Territorial Units for Statistics (NUTS) code placement of the “Main site or location of work, place of delivery or of performance”
B_FRA_AGREEMENT “The notice involves the establishment of a framework agreement”
FRA_ESTIMATED Whether there are indications that this notice is actually about a framework agreement, even though it has not been marked as such by the buyer (i.e. the buyer possibly forgot to mark the field). Indications are the following:

K “The keyword `framework’, in the appropriate language, was found in the title or description of the notice.”

A “Multiple awards were given per one lot, which is legally admissible only in case of framework agreements and dynamic purchasing systems.”

C “Consistency across notices: the contract notice which preceded this notice was marked as a framework agreement.”

The use of these indications depends on how important it is to not misclassify frameworks in your analysis. One possible approach is to assume that the notice has been misclassified as a framework when at least two of the indications above are present. [ADDED]

B_DYN_PURCH_SYST “The notice involves contract(s) based on a dynamic purchasing system”
CPV The main Common Procurement Vocabulary code of the main object of the contract
ADDITIONAL_CPV1-4 The main Common Procurement Vocabulary of the additional object(s) of the contract. The first four listed in the notice.
B_GPA “The contract is covered by the Government Procurement Agreement”
LOTS_NUMBER The number of lots for a given CAN. This value is based on the number of unique “Lot No” values included in the heading of section V of the CAN. This information is available only since 2009. [ADDED]
VALUE_EURO CAN value, in EUR, without VAT. If the value was not present, the lowest bid is included.
VALUE_EURO_FIN_1 CAN value, in EUR, without VAT. If a value field is missing, this columns looks for it in all other fields from which it could be taken (see detailed explanation in Annex I). [ADDED]
VALUE_EURO_FIN_2 Generally the same value as VALUE_EURO_FIN_1, but – if available – overwritten by human-made estimates of values for large value contracts which seemed to be incorrect.[3] These estimates are indicative and the Commission holds no responsibility for their correctness or usage. [ADDED]
TOP_TYPE Type of procedure. The values are the following:

  • ACN “accelerated negotiated “
  • ACR “accelerated restricted”
  • AWP “award without prior publication of a contract notice”
  • COD “competitive dialogue”
  • NOC/NOP “negotiated without a call for competition”
  • NIC/NIP “negotiated with a call for competition”
  • OPE “open”
  • RES “restricted”
CRIT_CODE Award criteria. The values are the following:

  • L “Lowest price”
  • M “Most economically advantageous tender”
CRIT_CRITERIA Information on award criteria. The field is an unstructured text field.
CRIT_WEIGHTS Information on award criteria weighing. The field is unstructured text.
B_ELECTRONIC_AUCTION “An electronic auction has been used”
NUMBER_AWARDS The number of CAs for a given CAN. [ADDED]
Award metadata  
ID_AWARD unique contract award identifier
Winning bidder identification  
WIN_NAME “Official name”
WIN_ADDRESS “Postal address”
WIN_POSTAL_CODE “Postal code”
Various CA level variables  
LOT_NUMBER “Lot No”, an identifier of a lot.
TITLE “Title”
NUMBER_OFFERS “Number of offers received”
NUMBER_OFFERS_ELECTR “Number of offers received by electronic means”
AWARD_EST_VALUE_EURO Estimated CA value, in EUR, without VAT.
AWARD_VALUE_EURO Total final CA value, in EUR, without VAT. If the value was not present, the lowest bid is included.
AWARD_VALUE_EURO_FIN_1 CA value, in EUR, without VAT. If a value field is missing, this columns looks for it in all other fields from which it could be taken (see detailed explanation in Annex I). [ADDED]
B_SUBCONTRACTED “The contract is likely to be subcontracted.”
B_EU_FUNDS “The contract is related to a project and / or programme financed by European Union funds”

[1]  Please note that the values for this variable are more diverse than those in the current standard forms, as they were used also for coding values from their older versions (i.e. “armed forces” was used in standard forms up to 2003).

[2] For standard forms related to the 2004 procurement directives this field was regrettably multiple choice which makes analysis difficult. For the 2014 procurement directives only one option is possible.

[3]  As explained in the presentations in the beginning of this document, typos in large value contracts can severely bias aggregate statistics even at national level. For this reason, the value of some large value contracts has been manually corrected throughout the years, e.g. on the basis on the information available in the notice description, contacting the buyer, or searching online resources.

1 Trackback / Pingback

  1. Challenge #1 : Prévoir l’attribution d’un marché public en fonction de la réputation de l’entreprise – Management & Data Science

Laisser un commentaire

Ce site utilise Akismet pour réduire les indésirables. En savoir plus sur comment les données de vos commentaires sont utilisées.