Baselight
Sign In

Contracts Finder Notices 01–2018

Crown Commercial Service

@ukgov.contracts_finder_notices_01_2018

Loading...
Loading...

About this Dataset

Contracts Finder Notices 01–2018

This dataset contains Contracts Finder notices for Jan 2018. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2022-07-01T04:05:45Z

Tables

Contracts Finder OCDS 2018-01-01

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_01
  • 70.66 KB
  • 3 rows
  • 72 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" 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_buyer_contactpoint_uri" VARCHAR
);

Contracts Finder OCDS 2018-01-02

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_02
  • 598.85 KB
  • 168 rows
  • 482 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_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_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" DOUBLE,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR
);

Contracts Finder OCDS 2018-01-03

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_03
  • 344.11 KB
  • 154 rows
  • 222 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_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_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR
);

Contracts Finder OCDS 2018-01-04

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_04
  • 827.99 KB
  • 120 rows
  • 795 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_04 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" DOUBLE,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_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" DOUBLE,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "releases_0_tender_items_11_classification_description" VARCHAR,
  "releases_0_tender_items_11_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" VARCHAR,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" VARCHAR,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR
);

Contracts Finder OCDS 2018-01-05

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_05
  • 531.39 KB
  • 223 rows
  • 380 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_05 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_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" VARCHAR,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" VARCHAR,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" VARCHAR,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" VARCHAR,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" DOUBLE,
  "releases_0_tender_milestones_0_id" VARCHAR,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" VARCHAR,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" DOUBLE,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" DOUBLE
);

Contracts Finder OCDS 2018-01-06

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_06
  • 93.95 KB
  • 9 rows
  • 98 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" DOUBLE,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_buyer_contactpoint_uri" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" DOUBLE,
  "releases_0_awards_0_suppliers_0_vco" VARCHAR,
  "releases_0_awards_0_suppliers_0_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_region" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
  "releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
  "releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
  "releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);

Contracts Finder OCDS 2018-01-07

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_07
  • 158.63 KB
  • 9 rows
  • 172 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_07 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_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_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" VARCHAR,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_buyer_contactpoint_uri" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE,
  "releases_0_awards_0_value_currency" VARCHAR,
  "releases_0_awards_0_suppliers_0_id" DOUBLE,
  "releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
  "releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
  "releases_0_awards_0_suppliers_0_sme" 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
);

Contracts Finder OCDS 2018-01-08

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_08
  • 1.06 MB
  • 346 rows
  • 667 columns
Loading... 

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

Contracts Finder OCDS 2018-01-09

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_09
  • 683.39 KB
  • 229 rows
  • 523 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_09 (
  "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 2018-01-10

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_10
  • 830.33 KB
  • 262 rows
  • 664 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_10 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" DOUBLE,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_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" DOUBLE,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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" VARCHAR,
  "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" VARCHAR,
  "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" VARCHAR,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" VARCHAR,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" VARCHAR,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" VARCHAR,
  "releases_0_tender_hasenquiries" DOUBLE,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" VARCHAR,
  "releases_0_tender_milestones_0_title" VARCHAR
);

Contracts Finder OCDS 2018-01-11

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_11
  • 325.86 KB
  • 135 rows
  • 343 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_11 (
  "https_www_contractsfinder_service_gov_uk_published_not_ec0e5d9f" VARCHAR,
  "n_2018_01_11t12_46_05z" VARCHAR,
  "n_2018_01_26t00_00_00z" VARCHAR,
  "in_tend_limited" VARCHAR,
  "gb_govuk_crown_comercial_service" VARCHAR,
  "unnamed_5" VARCHAR,
  "https_www_contractsfinder_service_gov_uk" VARCHAR,
  "n_1_1" VARCHAR,
  "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_2bf2739f_12e8_4f88_a366_d044729c3e41" VARCHAR,
  "ocds_b5fd17_2bf2739f_12e8_4f88_a366_d044729c3e41_19097_f28245dd" VARCHAR,
  "en_gb" VARCHAR,
  "n_2018_01_11t12_46_05z_1" TIMESTAMP,
  "tenderamendment" VARCHAR,
  "tender" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "ocds_b5fd17_2bf2739f_12e8_4f88_a366_d044729c3e41_deaf_1217" VARCHAR,
  "provision_of_outsourced_deaf_support_services" VARCHAR,
  "the_college_has_reviewed_its_arrangements_for_deaf_sup_9a7d6ed1" VARCHAR,
  "n__as_required" VARCHAR,
  "active" VARCHAR,
  "n_1" VARCHAR,
  "see_description_of_related_tender" VARCHAR,
  "cpv" DOUBLE,
  "n_79540000" VARCHAR,
  "interpretation_services" VARCHAR,
  "http_cpv_data_ac_uk_code_79540000_html" DOUBLE,
  "unnamed_30" VARCHAR,
  "unnamed_31" 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" VARCHAR,
  "unnamed_80" DOUBLE,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" DOUBLE,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "unnamed_94" VARCHAR,
  "unnamed_95" DOUBLE,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

Contracts Finder OCDS 2018-01-12

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_12
  • 474.38 KB
  • 226 rows
  • 307 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_12 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_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" VARCHAR,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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" VARCHAR,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" VARCHAR,
  "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" VARCHAR,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" VARCHAR,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" VARCHAR,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" VARCHAR,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" VARCHAR,
  "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" TIMESTAMP,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" VARCHAR,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" VARCHAR,
  "releases_0_tender_milestones_0_title" VARCHAR
);

Contracts Finder OCDS 2018-01-13

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_13
  • 147.06 KB
  • 16 rows
  • 145 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_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_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" VARCHAR
);

Contracts Finder OCDS 2018-01-14

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_14
  • 133.79 KB
  • 10 rows
  • 134 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_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_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR
);

Contracts Finder OCDS 2018-01-15

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_15
  • 1.15 MB
  • 261 rows
  • 1019 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_15 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" DOUBLE,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "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" DOUBLE,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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 2018-01-16

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_16
  • 560.66 KB
  • 229 rows
  • 373 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_16 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" DOUBLE,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" VARCHAR,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_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" VARCHAR,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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 2018-01-17

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_17
  • 531.94 KB
  • 215 rows
  • 348 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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 2018-01-18

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_18
  • 584.69 KB
  • 234 rows
  • 412 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_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 2018-01-19

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_19
  • 552.61 KB
  • 252 rows
  • 361 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_19 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" DOUBLE,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "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" DOUBLE,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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 2018-01-20

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_20
  • 188.56 KB
  • 4 rows
  • 199 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_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_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" 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_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
);

Contracts Finder OCDS 2018-01-21

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_21
  • 161.46 KB
  • 7 rows
  • 164 columns
Loading... 

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

Contracts Finder OCDS 2018-01-22

@ukgov.contracts_finder_notices_01_2018.contracts_finder_ocds_2018_01_22
  • 550.87 KB
  • 266 rows
  • 342 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2018_01_22 (
  "uri" VARCHAR,
  "publisheddate" VARCHAR,
  "deadlinedate" VARCHAR,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" VARCHAR,
  "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" VARCHAR,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" DOUBLE,
  "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
);

Share link

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