Dataset: Russian Biggest Government Procurement Contracts

About this Dataset

Russian Biggest Government Procurement Contracts

A simple dataset in Russian of government procurement tenders with the initial price of the tender of more than 500mln RUB (9-13mln USD in 2014, 5-9mln USD in 2022).

Can be used by aspiring analyst, or anyone interested in government procurement.

tender_data.csv
Tender data. Contains information on customer, initial price and accountant information, text description of the tender, data on whether the contract was awarded, in separate cases (not many unfortunately) - the winner company name.

tender_data_description.csv
Description of fields from tender_data.csv.

USD_RUB_exchange_rate.csv
For reference: USD to RUB exchange rate from the Central Bank of Russia for every date from 2014-01-01 to 2023-04-27.

Photo by Karolina Grabowska

Tables

Tender Data

@kaggle.dadalyndell_russian_biggest_government_procurement_contracts.tender_data

899.11 KB
4519 rows
19 columns


CREATE TABLE tender_data (
  "tender_id" BIGINT,
  "tender_name" VARCHAR,
  "start_price" DOUBLE,
  "tender_security" DOUBLE,
  "advance_money" VARCHAR,
  "currency" VARCHAR,
  "publication_date" TIMESTAMP,
  "selection_phase" VARCHAR,
  "legislation" VARCHAR,
  "url" VARCHAR,
  "procedure" VARCHAR,
  "for_small_business" BOOLEAN,
  "customer_region_code" VARCHAR,
  "customer_region" VARCHAR,
  "customer_name" VARCHAR,
  "customer_inn" DOUBLE,
  "winner_name" VARCHAR,
  "winner_inn" DOUBLE,
  "final_price" DOUBLE
);

Tender Data Description

@kaggle.dadalyndell_russian_biggest_government_procurement_contracts.tender_data_description

4.35 KB
19 rows
4 columns


CREATE TABLE tender_data_description (
  "col_name" VARCHAR,
  "ru_definition" VARCHAR,
  "en_definition" VARCHAR,
  "type" VARCHAR
);

Usd Rub Exchange Rate

@kaggle.dadalyndell_russian_biggest_government_procurement_contracts.usd_rub_exchange_rate

39.61 KB
2296 rows
2 columns


CREATE TABLE usd_rub_exchange_rate (
  "date" TIMESTAMP,
  "exchange_rate" DOUBLE
);