Baselight
Sign In

Contracts Finder Notices 12–2016

Crown Commercial Service

@ukgov.contracts_finder_notices_12_20162_1

Loading...
Loading...

About this Dataset

Contracts Finder Notices 12–2016

This dataset contains Contracts Finder notices for Dec 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-12-26

@ukgov.contracts_finder_notices_12_20162_1.contracts_finder_ocds_2016_12_26
  • 184.81 KB
  • 4 rows
  • 196 columns
Loading... 

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

Contracts Finder OCDS 2016-12-27

@ukgov.contracts_finder_notices_12_20162_1.contracts_finder_ocds_2016_12_27
  • 144.89 KB
  • 4 rows
  • 147 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_12_27 (
  "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_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_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_2_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_3_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_4_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_5_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_6_countryname" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_contractperiod_startdate" TIMESTAMP,
  "releases_0_tender_contractperiod_enddate" TIMESTAMP,
  "releases_0_tender_suitability_sme" BIGINT,
  "releases_0_tender_suitability_vcse" DOUBLE,
  "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
);

Contracts Finder OCDS 2016-12-28

@ukgov.contracts_finder_notices_12_20162_1.contracts_finder_ocds_2016_12_28
  • 376.1 KB
  • 62 rows
  • 353 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_12_28 (
  "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_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_1_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_postalcode" 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,
  "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,
  "releases_0_tender_documents_0_url" VARCHAR,
  "releases_0_tender_documents_0_datepublished" TIMESTAMP,
  "releases_0_tender_documents_0_format" VARCHAR,
  "releases_0_tender_documents_0_language" VARCHAR
);

Contracts Finder OCDS 2016-12-29

@ukgov.contracts_finder_notices_12_20162_1.contracts_finder_ocds_2016_12_29
  • 260.07 KB
  • 38 rows
  • 229 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_12_29 (
  "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_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_datepublished" TIMESTAMP,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_classification_scheme" VARCHAR,
  "releases_0_tender_classification_id" BIGINT,
  "releases_0_tender_classification_description" VARCHAR,
  "releases_0_tender_additionalclassifications_0_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_0_id" DOUBLE,
  "releases_0_tender_additionalclassifications_0_description" VARCHAR,
  "releases_0_tender_additionalclassifications_1_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_1_id" DOUBLE,
  "releases_0_tender_additionalclassifications_1_description" VARCHAR,
  "releases_0_tender_additionalclassifications_2_scheme" VARCHAR,
  "releases_0_tender_additionalclassifications_2_id" DOUBLE,
  "releases_0_tender_additionalclassifications_2_description" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_deliveryaddresses_0_region" VARCHAR,
  "releases_0_tender_items_0_deliveryaddresses_0_countryname" VARCHAR,
  "releases_0_tender_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_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_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_items_0_deliveryaddresses_6_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_tender_documents_2_id" DOUBLE,
  "releases_0_tender_documents_2_documenttype" VARCHAR,
  "releases_0_tender_documents_2_description" VARCHAR,
  "releases_0_tender_documents_2_url" VARCHAR,
  "releases_0_parties_0_id" VARCHAR
);

Contracts Finder OCDS 2016-12-30

@ukgov.contracts_finder_notices_12_20162_1.contracts_finder_ocds_2016_12_30
  • 178.71 KB
  • 43 rows
  • 154 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_12_30 (
  "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_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_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_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_roles_0" VARCHAR,
  "releases_0_parties_1_id" VARCHAR,
  "releases_0_parties_1_name" VARCHAR,
  "releases_0_parties_1_identifier_legalname" VARCHAR,
  "releases_0_parties_1_address_streetaddress" VARCHAR,
  "releases_0_parties_1_details_scale" VARCHAR,
  "releases_0_parties_1_details_vcse" VARCHAR,
  "releases_0_parties_1_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP,
  "releases_0_awards_0_documents_0_id" DOUBLE,
  "releases_0_awards_0_documents_0_documenttype" VARCHAR,
  "releases_0_awards_0_documents_0_description" VARCHAR,
  "releases_0_awards_0_documents_0_url" VARCHAR,
  "releases_0_awards_0_documents_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_documents_0_format" VARCHAR,
  "releases_0_awards_0_documents_0_language" VARCHAR,
  "releases_0_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
);

Contracts Finder OCDS 2016-12-31

@ukgov.contracts_finder_notices_12_20162_1.contracts_finder_ocds_2016_12_31
  • 111.96 KB
  • 1 row
  • 118 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_12_31 (
  "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_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" BIGINT,
  "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_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_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,
  "releases_0_parties_4_details_vcse" VARCHAR,
  "releases_0_parties_4_roles_0" VARCHAR,
  "releases_0_parties_5_id" VARCHAR,
  "releases_0_parties_5_name" VARCHAR,
  "releases_0_parties_5_identifier_legalname" VARCHAR,
  "releases_0_parties_5_address_streetaddress" VARCHAR,
  "releases_0_parties_5_details_scale" VARCHAR,
  "releases_0_parties_5_details_vcse" VARCHAR,
  "releases_0_parties_5_roles_0" VARCHAR,
  "releases_0_buyer_id" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_datepublished" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_1_id" VARCHAR,
  "releases_0_awards_0_suppliers_1_name" VARCHAR,
  "releases_0_awards_0_suppliers_2_id" VARCHAR
);

Share link

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