Baselight
Sign In

Contracts Finder Notices 02–2017

Crown Commercial Service

@ukgov.contracts_finder_notices_02_2017

Loading...
Loading...

About this Dataset

Contracts Finder Notices 02–2017

This dataset contains Contracts Finder notices for Feb 2017. 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:45Z

Tables

Contracts Finder OCDS 2017-02-01

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_01
  • 607.24 KB
  • 168 rows
  • 520 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-02

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_02
  • 907.11 KB
  • 151 rows
  • 842 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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_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 2017-02-03

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_03
  • 405.75 KB
  • 151 rows
  • 282 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-04

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_04
  • 97.92 KB
  • 24 rows
  • 96 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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" 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_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" 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 2017-02-05

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_05
  • 107.99 KB
  • 8 rows
  • 115 columns
Loading... 

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

Contracts Finder OCDS 2017-02-06

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_06
  • 495.29 KB
  • 158 rows
  • 370 columns
Loading... 

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

Contracts Finder OCDS 2017-02-07

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_07
  • 484.22 KB
  • 37 rows
  • 760 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_07 (
  "https_www_contractsfinder_service_gov_uk_published_not_437e43a4" VARCHAR,
  "n_2017_02_07t11_28_36z" TIMESTAMP,
  "n_2017_02_24t00_00_00z" TIMESTAMP,
  "in_tend_limited" VARCHAR,
  "gb_govuk_crown_comercial_service" VARCHAR,
  "unnamed_5" VARCHAR,
  "https_www_contractsfinder_service_gov_uk" VARCHAR,
  "n_1_1" DOUBLE,
  "https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR,
  "https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR,
  "https_www_gov_uk_government_publications_open_contracting" VARCHAR,
  "ocds_b5fd17_d136ef4b_dc59_4085_9b61_30bcaffedd7e" VARCHAR,
  "ocds_b5fd17_d136ef4b_dc59_4085_9b61_30bcaffedd7e_129029_qu054" VARCHAR,
  "en_gb" VARCHAR,
  "n_2017_02_07t11_28_36z_1" TIMESTAMP,
  "tender" VARCHAR,
  "tender_1" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "ocds_b5fd17_d136ef4b_dc59_4085_9b61_30bcaffedd7e_qu054" VARCHAR,
  "qu054_provision_for_an_assessment_and_proposition_for__c4aac751" VARCHAR,
  "birmingham_has_transformed_itself_into_a_truly_interna_16aed25d" VARCHAR,
  "n__birmingham_will_be_renowned_as_an_enterprising" VARCHAR,
  "n__innovative_and_green_city_that_has_undergone_transf_d3904009" BIGINT,
  "n__growing_its_economy_and_strengthening_its_position__915641e2" VARCHAR,
  "n__set_out_in_the_birmingham_development_plan_and_echo_c68e75fe" VARCHAR,
  "n__firmly_articulates_the_forward_thinking_strategy_th_76babcd5" BIGINT,
  "n__to_make_sure_that_birmingham_remains_the_west_midla_6ecdbcfd" VARCHAR,
  "n__the_uk_s_second_city_and_a_major_player_internation_e191b813" VARCHAR,
  "n__centred_within_edgbaston_selly_oak" DOUBLE,
  "n__and_primarily_focussed_on_the_queen_elizabeth_ii_ho_31f8bdd3" VARCHAR,
  "n__on_24th_february_2017" VARCHAR,
  "unsuccessful" DOUBLE,
  "n_1" VARCHAR,
  "see_description_of_related_tender" VARCHAR,
  "cpv" DOUBLE,
  "n_70000000" VARCHAR,
  "real_estate_services" VARCHAR,
  "http_cpv_data_ac_uk_code_70000000_html" DOUBLE,
  "n_2" VARCHAR,
  "see_description_of_related_tender_1" VARCHAR,
  "cpv_1" DOUBLE,
  "n_70112000" VARCHAR,
  "development_of_non_residential_real_estate" VARCHAR,
  "http_cpv_data_ac_uk_code_70112000_html" DOUBLE,
  "n_3" VARCHAR,
  "see_description_of_related_tender_2" VARCHAR,
  "cpv_2" DOUBLE,
  "n_70332100" VARCHAR,
  "land_management_services" VARCHAR,
  "http_cpv_data_ac_uk_code_70332100_html" DOUBLE,
  "n_4" VARCHAR,
  "see_description_of_related_tender_3" VARCHAR,
  "cpv_3" DOUBLE,
  "n_70111000" VARCHAR,
  "development_of_residential_real_estate" VARCHAR,
  "http_cpv_data_ac_uk_code_70111000_html" DOUBLE,
  "n_5" VARCHAR,
  "see_description_of_related_tender_4" VARCHAR,
  "cpv_4" DOUBLE,
  "n_70110000" VARCHAR,
  "development_services_of_real_estate" VARCHAR,
  "http_cpv_data_ac_uk_code_70110000_html" DOUBLE,
  "n_6" VARCHAR,
  "see_description_of_related_tender_5" VARCHAR,
  "cpv_5" DOUBLE,
  "n_45111291" VARCHAR,
  "site_development_work" VARCHAR,
  "http_cpv_data_ac_uk_code_45111291_html" DOUBLE,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" DOUBLE,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" DOUBLE,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" DOUBLE,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" DOUBLE,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" DOUBLE,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" DOUBLE,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" DOUBLE,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" DOUBLE,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" DOUBLE,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" DOUBLE,
  "unnamed_99" VARCHAR
);

Contracts Finder OCDS 2017-02-08

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_08
  • 243.25 KB
  • 35 rows
  • 321 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_08 (
  "https_www_contractsfinder_service_gov_uk_published_not_94214296" VARCHAR,
  "n_2017_02_08t11_07_53z" TIMESTAMP,
  "n_2016_08_08t00_00_00z" TIMESTAMP,
  "bravosolution_uk_limited" VARCHAR,
  "gb_govuk_crown_comercial_service" VARCHAR,
  "unnamed_5" VARCHAR,
  "https_www_contractsfinder_service_gov_uk" VARCHAR,
  "n_1_1" DOUBLE,
  "https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR,
  "https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR,
  "https_www_gov_uk_government_publications_open_contracting" VARCHAR,
  "ocds_b5fd17_9721a034_432a_4a11_ba3e_7d04be6c1697" VARCHAR,
  "ocds_b5fd17_9721a034_432a_4a11_ba3e_7d04be6c1697_12931_089e4522" VARCHAR,
  "en_gb" VARCHAR,
  "n_2017_02_08t11_07_53z_1" TIMESTAMP,
  "awardupdate" VARCHAR,
  "tender" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "ocds_b5fd17_9721a034_432a_4a11_ba3e_7d04be6c1697_tender_125522" VARCHAR,
  "programme_delivery_partner_support_for_the_reform_prog_0e42ae59" VARCHAR,
  "programme_delivery_partner_support_for_the_reform_prog_b0fcdbf2" VARCHAR,
  "n__through_activities_n_n3_account_management_requirem_1bc87b9b" VARCHAR,
  "n__in_so_far_as_the_supplier_can_reasonably_manage" BIGINT,
  "n__for_the_duration_of_the_contract_term" VARCHAR,
  "complete" VARCHAR,
  "n_1" BIGINT,
  "see_description_of_related_tender" VARCHAR,
  "cpv" VARCHAR,
  "n_72221000" DOUBLE,
  "business_analysis_consultancy_services" VARCHAR,
  "http_cpv_data_ac_uk_code_72221000_html" VARCHAR,
  "unnamed_32" DOUBLE,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" DOUBLE,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" DOUBLE,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" DOUBLE,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" DOUBLE,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" DOUBLE,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" DOUBLE,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" DOUBLE,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" DOUBLE,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" DOUBLE,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" DOUBLE,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" DOUBLE,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" DOUBLE,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" DOUBLE,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" DOUBLE,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" DOUBLE,
  "unnamed_78" VARCHAR,
  "unnamed_79" BIGINT,
  "n_2000000" VARCHAR,
  "gbp" VARCHAR,
  "n_0" VARCHAR,
  "gbp_1" VARCHAR,
  "unnamed_84" VARCHAR,
  "other" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" TIMESTAMP,
  "unnamed_89" TIMESTAMP,
  "please_apply_directly_to_the_buyer_using_the_contact_d_1536706a" VARCHAR,
  "n_2016_08_08t00_00_00z_1" VARCHAR,
  "unnamed_92" BIGINT,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "n_1_2" TIMESTAMP,
  "contract_start" VARCHAR,
  "anticipated_contract_start_date" BIGINT,
  "n_2016_09_19t00_00_00z" VARCHAR,
  "unnamed_99" VARCHAR
);

Contracts Finder OCDS 2017-02-09

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_09
  • 406.32 KB
  • 138 rows
  • 284 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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_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 2017-02-10

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_10
  • 357.04 KB
  • 143 rows
  • 251 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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_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 2017-02-11

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_11
  • 90.17 KB
  • 5 rows
  • 96 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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" 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" 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
);

Contracts Finder OCDS 2017-02-12

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_12
  • 108.22 KB
  • 6 rows
  • 113 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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_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" 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_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 2017-02-13

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_13
  • 497.11 KB
  • 169 rows
  • 393 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-14

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_14
  • 599.61 KB
  • 134 rows
  • 511 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-15

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_15
  • 852.54 KB
  • 133 rows
  • 806 columns
Loading... 

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

Contracts Finder OCDS 2017-02-16

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_16
  • 470.38 KB
  • 137 rows
  • 378 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-17

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_17
  • 904.37 KB
  • 134 rows
  • 832 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_17 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" VARCHAR,
  "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 2017-02-18

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_18
  • 281.74 KB
  • 10 rows
  • 295 columns
Loading... 

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

Contracts Finder OCDS 2017-02-19

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_19
  • 103.57 KB
  • 7 rows
  • 108 columns
Loading... 

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

Contracts Finder OCDS 2017-02-20

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_20
  • 760.41 KB
  • 155 rows
  • 672 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-22

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_22
  • 364.34 KB
  • 85 rows
  • 422 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_22 (
  "https_www_contractsfinder_service_gov_uk_published_not_10a69585" VARCHAR,
  "n_2017_02_22t15_35_27z" TIMESTAMP,
  "n_2017_03_20t00_00_00z" TIMESTAMP,
  "in_tend_limited" VARCHAR,
  "gb_govuk_crown_comercial_service" VARCHAR,
  "unnamed_5" VARCHAR,
  "https_www_contractsfinder_service_gov_uk" VARCHAR,
  "n_1_1" DOUBLE,
  "https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR,
  "https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR,
  "https_www_gov_uk_government_publications_open_contracting" VARCHAR,
  "ocds_b5fd17_5112cee9_fca7_44a7_ac69_8ed0ef9d40fc" VARCHAR,
  "ocds_b5fd17_5112cee9_fca7_44a7_ac69_8ed0ef9d40fc_131790_n6" VARCHAR,
  "en_gb" VARCHAR,
  "n_2017_02_22t15_35_27z_1" TIMESTAMP,
  "tender" VARCHAR,
  "tender_1" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "ocds_b5fd17_5112cee9_fca7_44a7_ac69_8ed0ef9d40fc_n6" VARCHAR,
  "tender_for_lightwoods_nursery" VARCHAR,
  "tender_for_lightwoods_nursery_n_n_sandwell_metropolita_2ed7dab0" VARCHAR,
  "n__please_visit_https_in_tendhost_co_uk_sandwellmbc_to_f6ae9d19" VARCHAR,
  "n__express_an_interest_in_the_opportunity" BIGINT,
  "n__and_gain_immediate_access_to_the_itt_and_other_rela_e5544c3b" VARCHAR,
  "n__you_will_be_required_to_opt_in_n_n_please_be_mindfu_f074d223" VARCHAR,
  "n__this_is_due_to_the_fact_that_some_special_character_6977bcd8" BIGINT,
  "unsuccessful" VARCHAR,
  "n_1" VARCHAR,
  "see_description_of_related_tender" DOUBLE,
  "cpv" VARCHAR,
  "n_85312100" VARCHAR,
  "daycare_services" DOUBLE,
  "http_cpv_data_ac_uk_code_85312100_html" VARCHAR,
  "n_2" VARCHAR,
  "see_description_of_related_tender_1" DOUBLE,
  "cpv_1" VARCHAR,
  "n_80110000" VARCHAR,
  "pre_school_education_services" DOUBLE,
  "http_cpv_data_ac_uk_code_80110000_html" VARCHAR,
  "n_3" VARCHAR,
  "see_description_of_related_tender_2" DOUBLE,
  "cpv_2" VARCHAR,
  "n_85312110" VARCHAR,
  "child_daycare_services" DOUBLE,
  "http_cpv_data_ac_uk_code_85312110_html" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" DOUBLE,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" DOUBLE,
  "unnamed_51" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" DOUBLE,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" DOUBLE,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" DOUBLE,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" DOUBLE,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" DOUBLE,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" DOUBLE,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" DOUBLE,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" DOUBLE,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" DOUBLE,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" DOUBLE,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" DOUBLE,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" DOUBLE,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" DOUBLE,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" DOUBLE,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" DOUBLE,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" DOUBLE,
  "unnamed_99" VARCHAR
);

Contracts Finder OCDS 2017-02-23

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_23
  • 465.46 KB
  • 131 rows
  • 366 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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 2017-02-24

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_24
  • 440.78 KB
  • 103 rows
  • 545 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_24 (
  "https_www_contractsfinder_service_gov_uk_published_not_572b0da7" VARCHAR,
  "n_2017_02_24t14_36_18z" TIMESTAMP,
  "n_2017_03_17t00_00_00z" TIMESTAMP,
  "in_tend_limited" VARCHAR,
  "gb_govuk_crown_comercial_service" VARCHAR,
  "unnamed_5" VARCHAR,
  "https_www_contractsfinder_service_gov_uk" VARCHAR,
  "n_1_1" DOUBLE,
  "https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR,
  "https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR,
  "https_www_gov_uk_government_publications_open_contracting" VARCHAR,
  "ocds_b5fd17_e6805c92_e4f3_43fe_a65a_3d01bd60ca00" VARCHAR,
  "ocds_b5fd17_e6805c92_e4f3_43fe_a65a_3d01bd60ca00_13221_63218c53" VARCHAR,
  "en_gb" VARCHAR,
  "n_2017_02_24t14_36_18z_1" TIMESTAMP,
  "tendercancellation" VARCHAR,
  "tender" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "ocds_b5fd17_e6805c92_e4f3_43fe_a65a_3d01bd60ca00_cbc_0681_t_ts" VARCHAR,
  "cbc_0681_t_ts_biggleswade_travellers_site_new_development" VARCHAR,
  "biggleswade_traveller_site_new_development_on_vacant_l_1898926b" VARCHAR,
  "n__you_will_be_required_to_opt_in_n_n_opt_in_this_will_f65e7bf0" VARCHAR,
  "n__will_be_made_available_to_all_suppliers_tendering" BIGINT,
  "n__to_ensure_a_fair_and_consistent_approach_to_all_if__8d9c6e32" VARCHAR,
  "n__then_please_contact_us_using_the_correspondence_fac_59e0b71b" VARCHAR,
  "cancelled" BIGINT,
  "n_1" VARCHAR,
  "see_description_of_related_tender" VARCHAR,
  "cpv" DOUBLE,
  "n_45111291" VARCHAR,
  "site_development_work" VARCHAR,
  "http_cpv_data_ac_uk_code_45111291_html" DOUBLE,
  "n_2" VARCHAR,
  "see_description_of_related_tender_1" VARCHAR,
  "cpv_1" DOUBLE,
  "n_45233100" VARCHAR,
  "construction_work_for_highways_roads" VARCHAR,
  "http_cpv_data_ac_uk_code_45233100_html" DOUBLE,
  "n_3" VARCHAR,
  "see_description_of_related_tender_2" VARCHAR,
  "cpv_2" DOUBLE,
  "n_45112710" VARCHAR,
  "landscaping_work_for_green_areas" VARCHAR,
  "http_cpv_data_ac_uk_code_45112710_html" DOUBLE,
  "n_4" VARCHAR,
  "see_description_of_related_tender_3" VARCHAR,
  "cpv_3" DOUBLE,
  "n_70111000" VARCHAR,
  "development_of_residential_real_estate" VARCHAR,
  "http_cpv_data_ac_uk_code_70111000_html" DOUBLE,
  "n_5" VARCHAR,
  "see_description_of_related_tender_4" VARCHAR,
  "cpv_4" VARCHAR,
  "n_44231000" VARCHAR,
  "made_up_fencing_panels" VARCHAR,
  "http_cpv_data_ac_uk_code_44231000_html" VARCHAR,
  "n_6" VARCHAR,
  "see_description_of_related_tender_5" VARCHAR,
  "cpv_5" VARCHAR,
  "n_45232450" VARCHAR,
  "drainage_construction_works" VARCHAR,
  "http_cpv_data_ac_uk_code_45232450_html" VARCHAR,
  "n_7" VARCHAR,
  "see_description_of_related_tender_6" VARCHAR,
  "cpv_6" VARCHAR,
  "n_45233320" VARCHAR,
  "foundation_work_for_roads" VARCHAR,
  "http_cpv_data_ac_uk_code_45233320_html" VARCHAR,
  "n_8" VARCHAR,
  "see_description_of_related_tender_7" VARCHAR,
  "cpv_7" VARCHAR,
  "n_44163110" VARCHAR,
  "drainage_pipes" VARCHAR,
  "http_cpv_data_ac_uk_code_44163110_html" VARCHAR,
  "n_9" VARCHAR,
  "see_description_of_related_tender_8" VARCHAR,
  "cpv_8" VARCHAR,
  "n_31682000" VARCHAR,
  "electricity_supplies" VARCHAR,
  "http_cpv_data_ac_uk_code_31682000_html" VARCHAR,
  "n_10" VARCHAR,
  "see_description_of_related_tender_9" VARCHAR,
  "cpv_9" VARCHAR,
  "n_45111213" VARCHAR,
  "site_clearance_work" VARCHAR,
  "http_cpv_data_ac_uk_code_45111213_html" VARCHAR,
  "n_11" VARCHAR,
  "see_description_of_related_tender_10" VARCHAR,
  "cpv_10" VARCHAR,
  "n_45233220" VARCHAR,
  "surface_work_for_roads" VARCHAR,
  "http_cpv_data_ac_uk_code_45233220_html" VARCHAR,
  "n_12" VARCHAR,
  "see_description_of_related_tender_11" VARCHAR,
  "cpv_11" VARCHAR,
  "n_45111000" VARCHAR,
  "demolition_site_preparation_and_clearance_work" VARCHAR,
  "http_cpv_data_ac_uk_code_45111000_html" VARCHAR,
  "n_13" VARCHAR
);

Contracts Finder OCDS 2017-02-25

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_25
  • 110.81 KB
  • 8 rows
  • 114 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_02_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" 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" 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 2017-02-26

@ukgov.contracts_finder_notices_02_2017.contracts_finder_ocds_2017_02_26
  • 89.84 KB
  • 9 rows
  • 96 columns
Loading... 

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

Share link

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