Baselight
Sign In

Contracts Finder Notices 03–2017

Crown Commercial Service

@ukgov.contracts_finder_notices_03_2017

Loading...
Loading...

About this Dataset

Contracts Finder Notices 03–2017

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

Tables

Contracts Finder OCDS 2017-03-26

@ukgov.contracts_finder_notices_03_2017.contracts_finder_ocds_2017_03_26
  • 136.99 KB
  • 6 rows
  • 148 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_03_26 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" DOUBLE,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_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" DOUBLE,
  "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 2017-03-27

@ukgov.contracts_finder_notices_03_2017.contracts_finder_ocds_2017_03_27
  • 396.84 KB
  • 161 rows
  • 258 columns
Loading... 

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

Contracts Finder OCDS 2017-03-28

@ukgov.contracts_finder_notices_03_2017.contracts_finder_ocds_2017_03_28
  • 1.17 MB
  • 223 rows
  • 1136 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_03_28 (
  "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" VARCHAR,
  "releases_0_tender_items_12_description" VARCHAR,
  "releases_0_tender_items_12_classification_scheme" VARCHAR,
  "releases_0_tender_items_12_classification_id" DOUBLE,
  "releases_0_tender_items_12_classification_description" VARCHAR
);

Contracts Finder OCDS 2017-03-29

@ukgov.contracts_finder_notices_03_2017.contracts_finder_ocds_2017_03_29
  • 480.92 KB
  • 188 rows
  • 358 columns
Loading... 

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

Contracts Finder OCDS 2017-03-30

@ukgov.contracts_finder_notices_03_2017.contracts_finder_ocds_2017_03_30
  • 495.47 KB
  • 153 rows
  • 398 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2017_03_30 (
  "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_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" DOUBLE,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR
);

Contracts Finder OCDS 2017-03-31

@ukgov.contracts_finder_notices_03_2017.contracts_finder_ocds_2017_03_31
  • 951.93 KB
  • 210 rows
  • 826 columns
Loading... 

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

Share link

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