Baselight
Sign In

Contracts Finder Notices 10–2016

Crown Commercial Service

@ukgov.contracts_finder_notices_10_20162_1

Loading...
Loading...

About this Dataset

Contracts Finder Notices 10–2016

This dataset contains Contracts Finder notices for Oct 2016. 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: 2025-05-09T04:05:21Z

Tables

Contracts Finder OCDS 2016-10-01

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_01
  • 129.29 KB
  • 11 rows
  • 125 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" 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_countryname" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" 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_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_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" 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
);

Contracts Finder OCDS 2016-10-02

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_02
  • 154.07 KB
  • 11 rows
  • 158 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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" 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_parties_3_id" VARCHAR,
  "releases_0_parties_3_name" VARCHAR,
  "releases_0_parties_3_identifier_legalname" VARCHAR,
  "releases_0_parties_3_address_streetaddress" VARCHAR,
  "releases_0_parties_3_details_scale" VARCHAR,
  "releases_0_parties_3_details_vcse" VARCHAR,
  "releases_0_parties_3_roles_0" VARCHAR,
  "releases_0_parties_4_id" VARCHAR,
  "releases_0_parties_4_name" VARCHAR,
  "releases_0_parties_4_identifier_legalname" VARCHAR,
  "releases_0_parties_4_address_streetaddress" VARCHAR,
  "releases_0_parties_4_details_scale" VARCHAR
);

Contracts Finder OCDS 2016-10-03

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_03
  • 388.42 KB
  • 101 rows
  • 317 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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
);

Contracts Finder OCDS 2016-10-04

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_04
  • 338.89 KB
  • 130 rows
  • 244 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_04 (
  "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_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_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 2016-10-05

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_05
  • 560.98 KB
  • 118 rows
  • 497 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_05 (
  "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_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_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" 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_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_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_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR
);

Contracts Finder OCDS 2016-10-06

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_06
  • 423.26 KB
  • 122 rows
  • 305 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_06 (
  "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_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_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
);

Contracts Finder OCDS 2016-10-07

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_07
  • 385.16 KB
  • 135 rows
  • 248 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE
);

Contracts Finder OCDS 2016-10-08

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_08
  • 90.35 KB
  • 3 rows
  • 90 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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" VARCHAR,
  "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" BIGINT,
  "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
);

Contracts Finder OCDS 2016-10-09

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_09
  • 106.66 KB
  • 7 rows
  • 105 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" 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_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_1_format" 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_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
);

Contracts Finder OCDS 2016-10-10

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_10
  • 356.72 KB
  • 111 rows
  • 263 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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_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
);

Contracts Finder OCDS 2016-10-11

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_11
  • 302.13 KB
  • 137 rows
  • 186 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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_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_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_communication_futurenoticedate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP
);

Contracts Finder OCDS 2016-10-12

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_12
  • 871.13 KB
  • 137 rows
  • 846 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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" 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_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR
);

Contracts Finder OCDS 2016-10-13

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_13
  • 430.21 KB
  • 122 rows
  • 314 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_13 (
  "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_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_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_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 2016-10-14

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_14
  • 367.15 KB
  • 158 rows
  • 231 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_14 (
  "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_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" 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_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" 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
);

Contracts Finder OCDS 2016-10-15

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_15
  • 112.95 KB
  • 11 rows
  • 101 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_procurementmethod" 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_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_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" DOUBLE,
  "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,
  "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
);

Contracts Finder OCDS 2016-10-16

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_16
  • 184.25 KB
  • 12 rows
  • 183 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" 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_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_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_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
);

Contracts Finder OCDS 2016-10-17

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_17
  • 715.71 KB
  • 133 rows
  • 652 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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
);

Contracts Finder OCDS 2016-10-18

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_18
  • 403.7 KB
  • 116 rows
  • 295 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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
);

Contracts Finder OCDS 2016-10-19

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_19
  • 534.81 KB
  • 139 rows
  • 418 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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" 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 2016-10-20

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_20
  • 531.09 KB
  • 146 rows
  • 397 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_20 (
  "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_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_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_communication_futurenoticedate" 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
);

Contracts Finder OCDS 2016-10-21

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_21
  • 425.69 KB
  • 153 rows
  • 290 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_21 (
  "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_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_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_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
);

Contracts Finder OCDS 2016-10-22

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_22
  • 108.75 KB
  • 11 rows
  • 104 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_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_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_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
);

Contracts Finder OCDS 2016-10-23

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_23
  • 137.75 KB
  • 10 rows
  • 140 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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" 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_parties_3_id" VARCHAR,
  "releases_0_parties_3_name" VARCHAR,
  "releases_0_parties_3_identifier_legalname" VARCHAR,
  "releases_0_parties_3_address_streetaddress" VARCHAR,
  "releases_0_parties_3_details_scale" VARCHAR,
  "releases_0_parties_3_details_vcse" VARCHAR,
  "releases_0_parties_3_roles_0" VARCHAR,
  "releases_0_parties_4_id" VARCHAR,
  "releases_0_parties_4_name" VARCHAR,
  "releases_0_parties_4_identifier_legalname" VARCHAR,
  "releases_0_parties_4_address_streetaddress" VARCHAR,
  "releases_0_parties_4_details_scale" VARCHAR
);

Contracts Finder OCDS 2016-10-24

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_24
  • 560.07 KB
  • 170 rows
  • 444 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_24 (
  "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_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_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_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
);

Contracts Finder OCDS 2016-10-25

@ukgov.contracts_finder_notices_10_20162_1.contracts_finder_ocds_2016_10_25
  • 508.79 KB
  • 156 rows
  • 425 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_10_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_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_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_items_0_id" BIGINT
);

Share link

Anyone who has the link will be able to view this.