About this Dataset

Contracts Finder Notices 09–2018

This dataset contains Contracts Finder notices for Sep 2018. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2023-03-02T06:05:24Z

Tables

Contracts Finder OCDS 2018-09-01

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_01

98.63 KB
5 rows
99 columns


CREATE TABLE contracts_finder_ocds_2018_09_01 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" BIGINT,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" DOUBLE,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
  "releases_0_awards_0_documents_0_id" DOUBLE,
  "releases_0_awards_0_documents_0_documenttype" VARCHAR,
  "releases_0_awards_0_documents_0_description" VARCHAR,
  "releases_0_awards_0_documents_0_url" VARCHAR,
  "releases_0_awards_0_documents_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_documents_0_format" VARCHAR,
  "releases_0_awards_0_documents_0_language" VARCHAR,
  "releases_0_awards_0_documents_1_id" DOUBLE,
  "releases_0_awards_0_documents_1_documenttype" VARCHAR,
  "releases_0_awards_0_documents_1_description" VARCHAR,
  "releases_0_awards_0_documents_1_url" VARCHAR
);

Contracts Finder OCDS 2018-09-02

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_02

148.88 KB
3 rows
146 columns


CREATE TABLE contracts_finder_ocds_2018_09_02 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" DOUBLE,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_15_id" DOUBLE,
  "releases_0_tender_additionalclassifications_15_description" VARCHAR,
  "releases_0_tender_additionalclassifications_16_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_16_id" DOUBLE,
  "releases_0_tender_additionalclassifications_16_description" VARCHAR,
  "releases_0_tender_additionalclassifications_17_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_17_id" DOUBLE,
  "releases_0_tender_additionalclassifications_17_description" VARCHAR,
  "releases_0_tender_additionalclassifications_18_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_18_id" DOUBLE,
  "releases_0_tender_additionalclassifications_18_description" VARCHAR,
  "releases_0_tender_additionalclassifications_19_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_19_id" DOUBLE,
  "releases_0_tender_additionalclassifications_19_description" VARCHAR,
  "releases_0_tender_additionalclassifications_20_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_20_id" DOUBLE,
  "releases_0_tender_additionalclassifications_20_description" VARCHAR,
  "releases_0_tender_additionalclassifications_21_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_21_id" DOUBLE,
  "releases_0_tender_additionalclassifications_21_description" VARCHAR,
  "releases_0_tender_additionalclassifications_22_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_22_id" DOUBLE,
  "releases_0_tender_additionalclassifications_22_description" VARCHAR,
  "releases_0_tender_additionalclassifications_23_scheme" VARCHAR
);

Contracts Finder OCDS 2018-09-03

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_03

1.04 MB
162 rows
957 columns


CREATE TABLE contracts_finder_ocds_2018_09_03 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_id" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_period_startdate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_datemodified" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" VARCHAR,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_planning_documents_3_id" DOUBLE,
  "releases_0_planning_documents_3_documenttype" VARCHAR,
  "releases_0_planning_documents_3_url" VARCHAR,
  "releases_0_planning_documents_3_format" VARCHAR,
  "releases_0_planning_documents_4_id" DOUBLE,
  "releases_0_planning_documents_4_documenttype" VARCHAR,
  "releases_0_planning_documents_4_url" VARCHAR,
  "releases_0_planning_documents_4_format" VARCHAR,
  "releases_0_planning_documents_5_id" DOUBLE,
  "releases_0_planning_documents_5_documenttype" VARCHAR,
  "releases_0_planning_documents_5_url" VARCHAR,
  "releases_0_planning_documents_5_format" VARCHAR,
  "releases_0_planning_documents_6_id" DOUBLE,
  "releases_0_planning_documents_6_documenttype" VARCHAR,
  "releases_0_planning_documents_6_url" VARCHAR,
  "releases_0_planning_documents_6_format" VARCHAR,
  "releases_0_planning_documents_7_id" DOUBLE,
  "releases_0_planning_documents_7_documenttype" VARCHAR,
  "releases_0_planning_documents_7_url" VARCHAR,
  "releases_0_planning_documents_7_format" VARCHAR,
  "releases_0_planning_documents_8_id" DOUBLE,
  "releases_0_planning_documents_8_documenttype" VARCHAR,
  "releases_0_planning_documents_8_url" VARCHAR,
  "releases_0_planning_documents_8_format" VARCHAR,
  "releases_0_planning_documents_9_id" DOUBLE,
  "releases_0_planning_documents_9_documenttype" VARCHAR,
  "releases_0_planning_documents_9_url" VARCHAR,
  "releases_0_planning_documents_9_format" VARCHAR,
  "releases_0_planning_documents_10_id" DOUBLE,
  "releases_0_planning_documents_10_documenttype" VARCHAR,
  "releases_0_planning_documents_10_url" VARCHAR,
  "releases_0_planning_documents_10_format" VARCHAR,
  "releases_0_planning_documents_11_id" VARCHAR,
  "releases_0_planning_documents_11_documenttype" VARCHAR,
  "releases_0_planning_documents_11_url" VARCHAR,
  "releases_0_planning_documents_11_format" VARCHAR,
  "releases_0_planning_documents_12_id" VARCHAR
);

Contracts Finder OCDS 2018-09-04

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_04

538.49 KB
160 rows
414 columns


CREATE TABLE contracts_finder_ocds_2018_09_04 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" VARCHAR,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" VARCHAR,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" VARCHAR,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_items_0_id" DOUBLE,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR
);

Contracts Finder OCDS 2018-09-05

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_05

475.55 KB
276 rows
310 columns


CREATE TABLE contracts_finder_ocds_2018_09_05 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" VARCHAR,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_datemodified" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" VARCHAR,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" VARCHAR,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" VARCHAR,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" VARCHAR,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" VARCHAR,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" VARCHAR,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" VARCHAR,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_additionalclassifications_15_scheme" VARCHAR
);

Contracts Finder OCDS 2018-09-06

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_06

378.4 KB
94 rows
430 columns


CREATE TABLE contracts_finder_ocds_2018_09_06 (
  "https_www_contractsfinder_service_gov_uk_published_not_f64cfba7" VARCHAR,
  "n_2018_09_06t14_21_43_01_00" VARCHAR,
  "cabinet_office" VARCHAR,
  "gb_gor" VARCHAR,
  "d2" VARCHAR,
  "https_www_gov_uk_government_organisations_cabinet_office" VARCHAR,
  "n_1_1" VARCHAR,
  "https_standard_open_contracting_org_profiles_eu_master_9a25c439" VARCHAR,
  "https_raw_githubusercontent_com_portaledcahn_ocds_tend_899e42ae" VARCHAR,
  "https_raw_githubusercontent_com_open_contracting_exten_283fb799" VARCHAR,
  "https_raw_githubusercontent_com_crown_commercial_servi_751afc7f" VARCHAR,
  "https_raw_githubusercontent_com_crown_commercial_servi_e4036c70" VARCHAR,
  "https_raw_githubusercontent_com_crown_commercial_servi_a93234bd" VARCHAR,
  "https_raw_githubusercontent_com_open_contracting_exten_ff7b0709" VARCHAR,
  "http_www_nationalarchives_gov_uk_doc_open_government_l_ed0688a9" VARCHAR,
  "https_www_gov_uk_government_publications_open_contracting" VARCHAR,
  "ocds_b5fd17_19022903_37dc_44c1_9bc8_a14852f8271b" VARCHAR,
  "n_96293ada_1d7f_4e5a_b31a_e1d16139a277_239313" VARCHAR,
  "en" VARCHAR,
  "n_2018_09_06t14_21_43_01_00_1" TIMESTAMP,
  "awardupdate" VARCHAR,
  "tender" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" DOUBLE,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" TIMESTAMP,
  "unnamed_27" DOUBLE,
  "unnamed_28" VARCHAR,
  "unnamed_29" TIMESTAMP,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" DOUBLE,
  "unnamed_34" TIMESTAMP,
  "unnamed_35" TIMESTAMP,
  "unnamed_36" VARCHAR,
  "unnamed_37" DOUBLE,
  "unnamed_38" VARCHAR,
  "unnamed_39" DOUBLE,
  "unnamed_40" TIMESTAMP,
  "unnamed_41" TIMESTAMP,
  "unnamed_42" VARCHAR,
  "unnamed_43" DOUBLE,
  "unnamed_44" VARCHAR,
  "unnamed_45" DOUBLE,
  "unnamed_46" TIMESTAMP,
  "unnamed_47" TIMESTAMP,
  "unnamed_48" VARCHAR,
  "unnamed_49" DOUBLE,
  "unnamed_50" VARCHAR,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" TIMESTAMP,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "bolt001_dn348375_01912084" VARCHAR,
  "q051_rivington_and_blackrod_high_school_asd_unit" VARCHAR,
  "the_borough_council_of_bolton_the_authority_is_prepare_0361de14" VARCHAR,
  "n__specification_and_tender_package_enclosed_please_no_942ea1ed" TIMESTAMP,
  "n_2018_06_18t16_10_30_01_00" VARCHAR,
  "complete" VARCHAR,
  "cpv" DOUBLE,
  "n_45000000" VARCHAR,
  "construction_work" VARCHAR,
  "unnamed_67" DOUBLE,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" DOUBLE,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" DOUBLE,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" DOUBLE,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "n_1" VARCHAR,
  "bl1_1ru" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "british_oversea_territories" VARCHAR,
  "unnamed_94" VARCHAR,
  "channel_islands" VARCHAR,
  "unnamed_96" VARCHAR,
  "europe" VARCHAR,
  "unnamed_98" VARCHAR,
  "isle_of_man" VARCHAR
);

Contracts Finder OCDS 2018-09-07

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_07

487.62 KB
200 rows
320 columns


CREATE TABLE contracts_finder_ocds_2018_09_07 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR
);

Contracts Finder OCDS 2018-09-08

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_08

134.46 KB
14 rows
128 columns


CREATE TABLE contracts_finder_ocds_2018_09_08 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_tender_documents_2_id" DOUBLE,
  "releases_0_tender_documents_2_documenttype" VARCHAR,
  "releases_0_tender_documents_2_description" VARCHAR,
  "releases_0_tender_documents_2_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_identifier_scheme" VARCHAR,
  "releases_0_parties_0_identifier_id" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" VARCHAR,
  "releases_0_parties_0_details_url" VARCHAR,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_parties_2_id" VARCHAR,
  "releases_0_parties_2_name" VARCHAR,
  "releases_0_parties_2_identifier_legalname" VARCHAR,
  "releases_0_parties_2_address_streetaddress" VARCHAR,
  "releases_0_parties_2_details_scale" VARCHAR
);

Contracts Finder OCDS 2018-09-09

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_09

118.14 KB
5 rows
117 columns


CREATE TABLE contracts_finder_ocds_2018_09_09 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_tender_documents_2_id" DOUBLE,
  "releases_0_tender_documents_2_documenttype" VARCHAR,
  "releases_0_tender_documents_2_description" VARCHAR,
  "releases_0_tender_documents_2_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" VARCHAR,
  "releases_0_parties_0_details_url" VARCHAR,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR
);

Contracts Finder OCDS 2018-09-10

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_10

913.78 KB
152 rows
834 columns


CREATE TABLE contracts_finder_ocds_2018_09_10 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_3_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_3_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_3_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_4_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_4_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_4_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_4_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_planning_documents_3_id" DOUBLE,
  "releases_0_planning_documents_3_documenttype" VARCHAR,
  "releases_0_planning_documents_3_url" VARCHAR,
  "releases_0_planning_documents_3_format" VARCHAR,
  "releases_0_planning_documents_4_id" DOUBLE,
  "releases_0_planning_documents_4_documenttype" VARCHAR,
  "releases_0_planning_documents_4_url" VARCHAR,
  "releases_0_planning_documents_4_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE
);

Contracts Finder OCDS 2018-09-11

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_11

765.69 KB
162 rows
666 columns


CREATE TABLE contracts_finder_ocds_2018_09_11 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" DOUBLE,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_15_id" DOUBLE
);

Contracts Finder OCDS 2018-09-12

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_12

531.15 KB
173 rows
386 columns


CREATE TABLE contracts_finder_ocds_2018_09_12 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" DOUBLE,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_15_id" DOUBLE
);

Contracts Finder OCDS 2018-09-13

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_13

695.46 KB
179 rows
552 columns


CREATE TABLE contracts_finder_ocds_2018_09_13 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_datemodified" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_planning_documents_3_id" DOUBLE,
  "releases_0_planning_documents_3_documenttype" VARCHAR,
  "releases_0_planning_documents_3_description" VARCHAR,
  "releases_0_planning_documents_3_url" VARCHAR,
  "releases_0_planning_documents_3_format" VARCHAR,
  "releases_0_planning_documents_4_id" DOUBLE,
  "releases_0_planning_documents_4_documenttype" VARCHAR,
  "releases_0_planning_documents_4_description" VARCHAR,
  "releases_0_planning_documents_4_url" VARCHAR,
  "releases_0_planning_documents_4_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR
);

Contracts Finder OCDS 2018-09-14

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_14

560.67 KB
189 rows
392 columns


CREATE TABLE contracts_finder_ocds_2018_09_14 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_additionalclassifications_13_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_13_id" DOUBLE,
  "releases_0_tender_additionalclassifications_13_description" VARCHAR,
  "releases_0_tender_additionalclassifications_14_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_14_id" DOUBLE,
  "releases_0_tender_additionalclassifications_14_description" VARCHAR,
  "releases_0_tender_additionalclassifications_15_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_15_id" DOUBLE
);

Contracts Finder OCDS 2018-09-15

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_15

117.33 KB
8 rows
112 columns


CREATE TABLE contracts_finder_ocds_2018_09_15 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_tender_documents_2_id" DOUBLE,
  "releases_0_tender_documents_2_documenttype" VARCHAR,
  "releases_0_tender_documents_2_description" VARCHAR,
  "releases_0_tender_documents_2_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" VARCHAR,
  "releases_0_parties_0_details_url" VARCHAR,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP
);

Contracts Finder OCDS 2018-09-16

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_16

214.37 KB
10 rows
212 columns


CREATE TABLE contracts_finder_ocds_2018_09_16 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE
);

Contracts Finder OCDS 2018-09-17

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_17

391.55 KB
163 rows
242 columns


CREATE TABLE contracts_finder_ocds_2018_09_17 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_10_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_10_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR
);

Contracts Finder OCDS 2018-09-18

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_18

1.06 MB
131 rows
1098 columns


CREATE TABLE contracts_finder_ocds_2018_09_18 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR
);

Contracts Finder OCDS 2018-09-19

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_19

794.15 KB
132 rows
710 columns


CREATE TABLE contracts_finder_ocds_2018_09_19 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_id" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_id" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_period_enddate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_amount" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" VARCHAR,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" VARCHAR,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" VARCHAR,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" VARCHAR,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" VARCHAR,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" VARCHAR,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_items_0_id" DOUBLE,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" VARCHAR,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR
);

Contracts Finder OCDS 2018-09-20

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_20

485.94 KB
133 rows
402 columns


CREATE TABLE contracts_finder_ocds_2018_09_20 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" VARCHAR,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" VARCHAR,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" VARCHAR,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" VARCHAR,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" VARCHAR,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" VARCHAR,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_items_0_id" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" VARCHAR,
  "releases_0_tender_contractperiod_startdate" VARCHAR,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR
);

Contracts Finder OCDS 2018-09-21

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_21

632.98 KB
164 rows
526 columns


CREATE TABLE contracts_finder_ocds_2018_09_21 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" VARCHAR,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" DOUBLE,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_planning_documents_2_format" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" DOUBLE,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" VARCHAR,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" VARCHAR,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" VARCHAR,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" VARCHAR,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_items_0_id" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_7_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_8_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_9_countryname" VARCHAR
);

Contracts Finder OCDS 2018-09-22

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_22

114.26 KB
9 rows
109 columns


CREATE TABLE contracts_finder_ocds_2018_09_22 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" DOUBLE,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_parties_2_id" VARCHAR,
  "releases_0_parties_2_name" VARCHAR,
  "releases_0_parties_2_identifier_legalname" VARCHAR,
  "releases_0_parties_2_address_streetaddress" VARCHAR,
  "releases_0_parties_2_details_scale" VARCHAR,
  "releases_0_parties_2_details_vcse" VARCHAR,
  "releases_0_parties_2_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_1_id" VARCHAR,
  "releases_0_awards_0_suppliers_1_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
  "releases_0_awards_0_documents_0_id" DOUBLE,
  "releases_0_awards_0_documents_0_documenttype" VARCHAR
);

Contracts Finder OCDS 2018-09-23

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_23

164.7 KB
11 rows
166 columns


CREATE TABLE contracts_finder_ocds_2018_09_23 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" DOUBLE,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "releases_0_tender_mainprocurementcategory" VARCHAR,
  "releases_0_tender_documents_0_id" DOUBLE,
  "releases_0_tender_documents_0_documenttype" VARCHAR,
  "releases_0_tender_documents_0_description" VARCHAR,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR,
  "releases_0_tender_documents_1_id" DOUBLE,
  "releases_0_tender_documents_1_documenttype" VARCHAR,
  "releases_0_tender_documents_1_description" VARCHAR,
  "releases_0_tender_documents_1_url" VARCHAR,
  "releases_0_tender_documents_2_id" DOUBLE,
  "releases_0_tender_documents_2_documenttype" VARCHAR,
  "releases_0_tender_documents_2_description" VARCHAR,
  "releases_0_tender_documents_2_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR,
  "releases_0_parties_0_name" VARCHAR,
  "releases_0_parties_0_identifier_legalname" VARCHAR,
  "releases_0_parties_0_identifier_scheme" VARCHAR,
  "releases_0_parties_0_identifier_id" VARCHAR,
  "releases_0_parties_0_address_streetaddress" VARCHAR,
  "releases_0_parties_0_address_locality" VARCHAR,
  "releases_0_parties_0_address_postalcode" VARCHAR,
  "releases_0_parties_0_address_countryname" VARCHAR,
  "releases_0_parties_0_contactpoint_name" VARCHAR,
  "releases_0_parties_0_contactpoint_email" VARCHAR,
  "releases_0_parties_0_contactpoint_telephone" VARCHAR,
  "releases_0_parties_0_details_url" VARCHAR,
  "releases_0_parties_0_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR
);

Contracts Finder OCDS 2018-09-24

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_24

607.41 KB
183 rows
455 columns


CREATE TABLE contracts_finder_ocds_2018_09_24 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" VARCHAR,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_id" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_period_startdate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_period_enddate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_0_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_0_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_1_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_1_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_1_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_id" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_period_enddate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_2_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_2_amount_amount" DOUBLE,
  "releases_0_planning_budget_budgetbreakdown_2_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_id" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_period_startdate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_period_enddate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_amount_amount" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_3_amount_currency" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_id" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_period_startdate" TIMESTAMP,
  "releases_0_planning_budget_budgetbreakdown_4_period_enddate" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_description" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_amount_amount" VARCHAR,
  "releases_0_planning_budget_budgetbreakdown_4_amount_currency" VARCHAR,
  "releases_0_planning_documents_0_id" VARCHAR,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_planning_documents_1_format" VARCHAR,
  "releases_0_planning_documents_2_id" VARCHAR,
  "releases_0_planning_documents_2_documenttype" VARCHAR,
  "releases_0_planning_documents_2_description" VARCHAR,
  "releases_0_planning_documents_2_url" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" VARCHAR,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" VARCHAR,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" VARCHAR,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" VARCHAR,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR
);

Contracts Finder OCDS 2018-09-25

@ukgov.contracts_finder_notices_09_20182_1.contracts_finder_ocds_2018_09_25

564.12 KB
147 rows
432 columns


CREATE TABLE contracts_finder_ocds_2018_09_25 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "extensions_1" VARCHAR,
  "extensions_2" VARCHAR,
  "extensions_3" VARCHAR,
  "extensions_4" VARCHAR,
  "extensions_5" VARCHAR,
  "extensions_6" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_planning_milestones_0_id" DOUBLE,
  "releases_0_planning_milestones_0_title" VARCHAR,
  "releases_0_planning_milestones_0_type" VARCHAR,
  "releases_0_planning_milestones_0_duedate" TIMESTAMP,
  "releases_0_planning_documents_0_id" DOUBLE,
  "releases_0_planning_documents_0_documenttype" VARCHAR,
  "releases_0_planning_documents_0_description" VARCHAR,
  "releases_0_planning_documents_0_url" VARCHAR,
  "releases_0_planning_documents_0_datepublished" TIMESTAMP,
  "releases_0_planning_documents_0_format" VARCHAR,
  "releases_0_planning_documents_0_language" VARCHAR,
  "releases_0_planning_documents_1_id" DOUBLE,
  "releases_0_planning_documents_1_documenttype" VARCHAR,
  "releases_0_planning_documents_1_description" VARCHAR,
  "releases_0_planning_documents_1_url" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_additionalclassifications_3_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_3_id" DOUBLE,
  "releases_0_tender_additionalclassifications_3_description" VARCHAR,
  "releases_0_tender_additionalclassifications_4_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_4_id" DOUBLE,
  "releases_0_tender_additionalclassifications_4_description" VARCHAR,
  "releases_0_tender_additionalclassifications_5_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_5_id" DOUBLE,
  "releases_0_tender_additionalclassifications_5_description" VARCHAR,
  "releases_0_tender_additionalclassifications_6_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_6_id" DOUBLE,
  "releases_0_tender_additionalclassifications_6_description" VARCHAR,
  "releases_0_tender_additionalclassifications_7_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_7_id" DOUBLE,
  "releases_0_tender_additionalclassifications_7_description" VARCHAR,
  "releases_0_tender_additionalclassifications_8_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_8_id" DOUBLE,
  "releases_0_tender_additionalclassifications_8_description" VARCHAR,
  "releases_0_tender_additionalclassifications_9_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_9_id" DOUBLE,
  "releases_0_tender_additionalclassifications_9_description" VARCHAR,
  "releases_0_tender_additionalclassifications_10_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_10_id" DOUBLE,
  "releases_0_tender_additionalclassifications_10_description" VARCHAR,
  "releases_0_tender_additionalclassifications_11_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_11_id" DOUBLE,
  "releases_0_tender_additionalclassifications_11_description" VARCHAR,
  "releases_0_tender_additionalclassifications_12_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_12_id" DOUBLE,
  "releases_0_tender_additionalclassifications_12_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_region" VARCHAR
);