Dataset: Public Tenders Romania 2007-2016

About this Dataset

Public Tenders Romania 2007-2016

Context

We present here the public tenders data, covering the years 2007-2016, the first decade after Romania EU accession.

Content

The following columns/attributes are included in the data:

Winner - The company awarded the contract
Winner_VAT - VAT Code of the winning company
Winner_Country - Country of the winning company
Winner_City - City of the winning company
Winner_Address - Address of the winning company
Type - Award type
Contract_Type - Contract type
Procedure_Type - Selection procedure type
Contracting_Authority - Public authority that is contracting the winning company
Contracting_Authority_VAT - VAT Code for the contracting public authority
Contracting_Authority_Type - Contracting public authority type
Contracting_Authority_Activity_Type - Contracting public authority activity type
Award_Anouncement_Number - The official registration number of award announcement
Award_Announcement_Date - The official registration date of award announcement
Contract_Conclusion_Type - Date of signing the contract
Award_Criteria_Type - Criteria for granting the contract
With_Electronic_Auction - Flag for electronic auction for the awarded contract
Offers_Number - Number of offers for the tender
Subcontracted - Flag for subcontracting (the winning company is subcontracting)
Contract_Number - Official registered contract number
Contract_Date - Contract date
Contract_Title - Contract title
Value - Value of contract
Currency - Currency in which this contract is expressed (could be RON - Romanian currency, EUR or USD)
Value_RON - Value of the contract in (equivalent) Romanian currency
Value_EUR - Value of the contract in (equivalent) Romanian currency
CPV_Code_ID - CPV Code ID
CPV_Code - CPV Code
Participation_Announcement_Number - Participation (to the tender) announcement number
Participation_Announcement_Date - Participation (to the tender) announcement date
Participation_Estimated_Value - Participation (to the tender) estimated value
Participation_Estimated_Value_Currency - Participation (to the tender) estimated value currency
EU_Funds - Flag to indicate if the tender is about accessing EU Funds
Financing_Type - Type of financing used for the contract
Legislation_Type_ID - Legislation that applies for the contract
EU_Fund - Specified EU Fund used/accessed for the financing
Periodic_Contract - Flag to indicate if it is a periodic (recurrent) contract
Garantee_Deposits - Guarantee Deposits used
Financing_Method - Financing Method

The original data is in Romanian, including the columns names. We kept the original Romanian text for companies names, as well as for categorical data types categories names.

Tables

Contracts

@kaggle.gpreda_public_tenders_romania_20072016.contracts

133.03 MB
887642 rows
39 columns


CREATE TABLE contracts (
  "winner" VARCHAR,
  "winner_vat" VARCHAR,
  "winner_country" VARCHAR,
  "winner_city" VARCHAR,
  "winner_address" VARCHAR,
  "type" VARCHAR,
  "contract_type" VARCHAR,
  "procedure_type" VARCHAR,
  "contracting_authority" VARCHAR,
  "contracting_authority_vat" VARCHAR,
  "contracting_authority_type" VARCHAR,
  "contracting_authority_activity_type" VARCHAR,
  "award_anouncement_number" DOUBLE,
  "award_announcement_date" VARCHAR,
  "contract_conclusion_type" VARCHAR,
  "award_criteria_type" VARCHAR,
  "with_electronic_auction" VARCHAR,
  "offers_number" DOUBLE,
  "subcontracted" VARCHAR,
  "contract_number" VARCHAR,
  "contract_date" VARCHAR,
  "contract_title" VARCHAR,
  "value" DOUBLE,
  "currency" VARCHAR,
  "value_ron" DOUBLE,
  "value_eur" DOUBLE,
  "cpv_code_id" DOUBLE,
  "cpv_code" VARCHAR,
  "participation_announcement_number" DOUBLE,
  "participation_announcement_date" VARCHAR,
  "participation_estimated_value" DOUBLE,
  "participation_estimated_value_currency" VARCHAR,
  "eu_funds" VARCHAR,
  "financing_type" VARCHAR,
  "legislation_type_id" DOUBLE,
  "eu_fund" VARCHAR,
  "periodic_contract" VARCHAR,
  "garantee_deposits" VARCHAR,
  "financing_method" VARCHAR
);