Baselight
Sign In

Contracts Finder Notices 06–2016

Crown Commercial Service

@ukgov.contracts_finder_notices_06_2016

Loading...
Loading...

About this Dataset

Contracts Finder Notices 06–2016

This dataset contains Contracts Finder notices for Jun 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: 2022-07-01T04:05:46Z

Tables

Contracts Finder OCDS 2016-06-01

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_01
  • 672.71 KB
  • 121 rows
  • 612 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_01 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-02

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_02
  • 324.63 KB
  • 114 rows
  • 251 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_02 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" 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
);

Contracts Finder OCDS 2016-06-03

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_03
  • 835.46 KB
  • 133 rows
  • 768 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_03 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-04

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_04
  • 94.09 KB
  • 8 rows
  • 96 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_04 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" DOUBLE,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" VARCHAR,
  "releases_0_awards_0_suppliers_0_vco" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_region" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);

Contracts Finder OCDS 2016-06-05

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_05
  • 136.91 KB
  • 5 rows
  • 147 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_05 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" VARCHAR,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" VARCHAR,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" VARCHAR,
  "releases_0_awards_0_suppliers_0_vco" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_region" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_suppliers_1_id" DOUBLE,
  "releases_0_awards_0_suppliers_1_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_1_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_1_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_1_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_1_sme" VARCHAR
);

Contracts Finder OCDS 2016-06-06

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_06
  • 458.85 KB
  • 112 rows
  • 388 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_06 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-07

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_07
  • 326.08 KB
  • 136 rows
  • 223 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_07 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-08

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_08
  • 482.25 KB
  • 129 rows
  • 411 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_08 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-09

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_09
  • 337.32 KB
  • 115 rows
  • 243 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_09 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" DOUBLE,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR
);

Contracts Finder OCDS 2016-06-10

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_10
  • 1.32 MB
  • 134 rows
  • 1371 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_10 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-11

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_11
  • 122.23 KB
  • 10 rows
  • 130 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_11 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" BIGINT,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" BIGINT,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" VARCHAR,
  "releases_0_awards_0_suppliers_0_vco" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_region" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_suppliers_1_id" DOUBLE,
  "releases_0_awards_0_suppliers_1_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_1_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_1_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_1_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_1_sme" VARCHAR
);

Contracts Finder OCDS 2016-06-12

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_12
  • 79.76 KB
  • 3 rows
  • 84 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_12 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" DOUBLE,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_buyer_contactpoint_uri" VARCHAR
);

Contracts Finder OCDS 2016-06-13

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_13
  • 480.6 KB
  • 119 rows
  • 402 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_13 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-14

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_14
  • 1.33 MB
  • 152 rows
  • 1386 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_14 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-15

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_15
  • 514.79 KB
  • 118 rows
  • 461 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_15 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-16

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_16
  • 711.19 KB
  • 121 rows
  • 669 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_16 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-17

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_17
  • 289.48 KB
  • 126 rows
  • 199 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_17 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" DOUBLE,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR
);

Contracts Finder OCDS 2016-06-18

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_18
  • 64.29 KB
  • 4 rows
  • 70 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_18 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" BIGINT,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR
);

Contracts Finder OCDS 2016-06-19

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_19
  • 146.34 KB
  • 13 rows
  • 134 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_19 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" DOUBLE,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" DOUBLE,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_buyer_contactpoint_uri" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" DOUBLE,
  "releases_0_awards_0_suppliers_0_vco" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_region" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_suppliers_1_id" DOUBLE,
  "releases_0_awards_0_suppliers_1_identifier_scheme" VARCHAR
);

Contracts Finder OCDS 2016-06-20

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_20
  • 1.32 MB
  • 99 rows
  • 1402 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_20 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-21

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_21
  • 342.49 KB
  • 139 rows
  • 279 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_21 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR,
  "releases_0_tender_items_12_classification_uri" VARCHAR,
  "releases_0_tender_items_13_id" DOUBLE
);

Contracts Finder OCDS 2016-06-22

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_22
  • 341.82 KB
  • 72 rows
  • 297 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_22 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-23

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_23
  • 1.83 MB
  • 128 rows
  • 1918 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_23 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-24

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_24
  • 454.88 KB
  • 118 rows
  • 389 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_24 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_items_10_id" DOUBLE,
  "releases_0_tender_items_10_description" VARCHAR,
  "releases_0_tender_items_10_classification_scheme" VARCHAR,
  "releases_0_tender_items_10_classification_id" DOUBLE,
  "releases_0_tender_items_10_classification_description" VARCHAR,
  "releases_0_tender_items_10_classification_uri" VARCHAR,
  "releases_0_tender_items_11_id" DOUBLE,
  "releases_0_tender_items_11_description" VARCHAR,
  "releases_0_tender_items_11_classification_scheme" VARCHAR,
  "releases_0_tender_items_11_classification_id" DOUBLE,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_items_12_id" DOUBLE,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2016-06-25

@ukgov.contracts_finder_notices_06_2016.contracts_finder_ocds_2016_06_25
  • 86.89 KB
  • 3 rows
  • 96 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2016_06_25 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" 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_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" 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_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" BIGINT,
  "releases_0_tender_xclassifications_issuitableforsme" VARCHAR,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" BIGINT,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" VARCHAR,
  "releases_0_awards_0_suppliers_0_vco" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_region" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);

Share link

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