Complexity / 2019 / Article / Tab 2

Research Article

Public Procurement Announcements in Spain: Regulations, Data Analysis, and Award Price Estimator Using Machine Learning

Table 2

Most relevant data fields in the public procurement notices (tenders) used in the dataset

NameDescriptionName column dataset

Tender statusStatus of the tender during the development of the procedure: prior notice, in time, pending adjudication, awarded, resolved or cancelledNot used (similar to Result_code)
Contract file numberUnique identifier for a contract fileNot used
Object of the contractSummary description of the contractNot used (unstructured textual information)
Public procurement agencyPublic procurement agency that made the tender: name, identifier (NIF or DIR3), website, address, postal code, city, country, contact name, telephone, fax, e-mail, etcName_Organisation Postalzone Postalzone_CCAA Postalzone_Province Postalzone_Municipality
Tender priceAmount of bidding budgeted (taxes included)Tender_Price
DurationTime (days) to execute the contractDuration
CPV classificationCPV (common procurement vocabulary) is a European system for classifying the type of work in public contracts defined in the Commission Regulation (EC) No 213/2008: http://data.europa.eu/eli/reg/2008/213/ojCPV
CPV_Aggregated (first 2 digits of the code)
The numerical code consists of 8 digits, subdivided into divisions (first 2 digits of the code), groups (first 3 digits), classes (first 4 digits), and categories (first 5 digits)
Contract typeType of contract defined by legislation (Law 9/2017): works, services, supplies, public works concession, works concession, public services management, services concession, public sector and private sector collaboration, special administrative, private, patrimonial, or othersType_code
Contract subtypeCode to indicate a subtype of contract. If it is a type of service contract: based upon the 2004/18/CE Directive, Annex II. If it is a type of work contract: works contract codes defined by the Spanish DGPESubtype_code
Contract execution placeContract’s execution has a place through the Nomenclature of Statistical Territorial Units (NUTS), created by Eurostat [23]Not used (assumed equal to Postalzone)
Type of procedureProcedure by which the contracts was awarded: open, restricted, negotiated with advertising, negotiated without publicity, competitive dialogue, internal rules, derived from framework agreement, project contest, simplified open, association for innovation, derivative of association for innovation, based on a system dynamic acquisition, bidding with negotiation, or othersProcedure_code
Contracting systemThe contracting system indicates whether it is a contract itself or a framework agreement or dynamic acquisition system
Type of processingType of processing: ordinary, urgent, or emergencyUrgency_code
Award resultType of results: awarded, formalised, desert, resignation, and withdrawalResult_code
Winner identifierIdentifier of the winning bidder (called CIF in Spain) and its province (region)CIF_Winner
Winner_Province
Award priceAmount offered by the winning bidder of the contract (taxes included)Award_Price
DateDate of agreement in the award of the contractDate
Number of received offersNumber of received offers (bidders participating) in each tenderReceived_Offers