Baselight
Sign In

Contracts Finder Notices 12–2015

Crown Commercial Service

@ukgov.contracts_finder_notices_12_2015

Loading...
Loading...

About this Dataset

Contracts Finder Notices 12–2015

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

Tables

Contracts Finder OCDS 2015-12-01

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_01
  • 281.75 KB
  • 113 rows
  • 222 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_01 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_items_9_id" DOUBLE,
  "releases_0_tender_items_9_description" VARCHAR,
  "releases_0_tender_items_9_classification_scheme" VARCHAR,
  "releases_0_tender_items_9_classification_id" DOUBLE,
  "releases_0_tender_items_9_classification_description" VARCHAR,
  "releases_0_tender_items_9_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" DOUBLE,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_tenderperiod_startdate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR
);

Contracts Finder OCDS 2015-12-02

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_02
  • 508.15 KB
  • 153 rows
  • 423 columns
Loading... 

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

Contracts Finder OCDS 2015-12-03

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_03
  • 408.62 KB
  • 98 rows
  • 333 columns
Loading... 

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

Contracts Finder OCDS 2015-12-04

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_04
  • 565.33 KB
  • 100 rows
  • 495 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_04 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_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 2015-12-05

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_05
  • 162.83 KB
  • 4 rows
  • 168 columns
Loading... 

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

Contracts Finder OCDS 2015-12-06

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_06
  • 106.89 KB
  • 6 rows
  • 107 columns
Loading... 

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

Contracts Finder OCDS 2015-12-07

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_07
  • 564.65 KB
  • 129 rows
  • 496 columns
Loading... 

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

Contracts Finder OCDS 2015-12-08

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_08
  • 349.36 KB
  • 129 rows
  • 261 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_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 2015-12-09

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_09
  • 377.71 KB
  • 108 rows
  • 313 columns
Loading... 

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

Contracts Finder OCDS 2015-12-10

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_10
  • 308.72 KB
  • 116 rows
  • 217 columns
Loading... 

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

Contracts Finder OCDS 2015-12-11

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_11
  • 479.93 KB
  • 136 rows
  • 402 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_11 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_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 2015-12-12

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_12
  • 114.29 KB
  • 5 rows
  • 120 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_12 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_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_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" BIGINT,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" DOUBLE,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR,
  "releases_0_awards_0_id" VARCHAR,
  "releases_0_awards_0_title" VARCHAR,
  "releases_0_awards_0_description" VARCHAR,
  "releases_0_awards_0_status" VARCHAR,
  "releases_0_awards_0_date" TIMESTAMP,
  "releases_0_awards_0_value_amount" DOUBLE
);

Contracts Finder OCDS 2015-12-13

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_13
  • 115.83 KB
  • 5 rows
  • 112 columns
Loading... 

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

Contracts Finder OCDS 2015-12-14

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_14
  • 355.08 KB
  • 64 rows
  • 310 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_14 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_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" DOUBLE,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" DOUBLE,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" 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
);

Contracts Finder OCDS 2015-12-15

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_15
  • 1.02 MB
  • 116 rows
  • 1049 columns
Loading... 

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

Contracts Finder OCDS 2015-12-16

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_16
  • 500.34 KB
  • 183 rows
  • 388 columns
Loading... 

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

Contracts Finder OCDS 2015-12-17

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_17
  • 638.95 KB
  • 142 rows
  • 554 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_17 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_title" VARCHAR,
  "releases_0_description" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_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 2015-12-18

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_18
  • 493.76 KB
  • 155 rows
  • 389 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_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 2015-12-19

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_19
  • 171.71 KB
  • 6 rows
  • 180 columns
Loading... 

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

Contracts Finder OCDS 2015-12-20

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_20
  • 287.27 KB
  • 9 rows
  • 314 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_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_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_items_3_id" DOUBLE,
  "releases_0_tender_items_3_description" VARCHAR,
  "releases_0_tender_items_3_classification_scheme" VARCHAR,
  "releases_0_tender_items_3_classification_id" DOUBLE,
  "releases_0_tender_items_3_classification_description" VARCHAR,
  "releases_0_tender_items_3_classification_uri" VARCHAR,
  "releases_0_tender_items_4_id" DOUBLE,
  "releases_0_tender_items_4_description" VARCHAR,
  "releases_0_tender_items_4_classification_scheme" VARCHAR,
  "releases_0_tender_items_4_classification_id" DOUBLE,
  "releases_0_tender_items_4_classification_description" VARCHAR,
  "releases_0_tender_items_4_classification_uri" VARCHAR,
  "releases_0_tender_items_5_id" DOUBLE,
  "releases_0_tender_items_5_description" VARCHAR,
  "releases_0_tender_items_5_classification_scheme" VARCHAR,
  "releases_0_tender_items_5_classification_id" DOUBLE,
  "releases_0_tender_items_5_classification_description" VARCHAR,
  "releases_0_tender_items_5_classification_uri" VARCHAR,
  "releases_0_tender_items_6_id" DOUBLE,
  "releases_0_tender_items_6_description" VARCHAR,
  "releases_0_tender_items_6_classification_scheme" VARCHAR,
  "releases_0_tender_items_6_classification_id" DOUBLE,
  "releases_0_tender_items_6_classification_description" VARCHAR,
  "releases_0_tender_items_6_classification_uri" VARCHAR,
  "releases_0_tender_items_7_id" DOUBLE,
  "releases_0_tender_items_7_description" VARCHAR,
  "releases_0_tender_items_7_classification_scheme" VARCHAR,
  "releases_0_tender_items_7_classification_id" DOUBLE,
  "releases_0_tender_items_7_classification_description" VARCHAR,
  "releases_0_tender_items_7_classification_uri" VARCHAR,
  "releases_0_tender_items_8_id" DOUBLE,
  "releases_0_tender_items_8_description" VARCHAR,
  "releases_0_tender_items_8_classification_scheme" VARCHAR,
  "releases_0_tender_items_8_classification_id" DOUBLE,
  "releases_0_tender_items_8_classification_description" VARCHAR,
  "releases_0_tender_items_8_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE
);

Contracts Finder OCDS 2015-12-21

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_21
  • 1.09 MB
  • 117 rows
  • 1106 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_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_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 2015-12-22

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_22
  • 753.32 KB
  • 144 rows
  • 682 columns
Loading... 

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

Contracts Finder OCDS 2015-12-23

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_23
  • 1.88 MB
  • 152 rows
  • 1976 columns
Loading... 

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

Contracts Finder OCDS 2015-12-24

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_24
  • 683.72 KB
  • 43 rows
  • 694 columns
Loading... 

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

Contracts Finder OCDS 2015-12-25

@ukgov.contracts_finder_notices_12_2015.contracts_finder_ocds_2015_12_25
  • 79.25 KB
  • 4 rows
  • 82 columns
Loading... 

CREATE TABLE contracts_finder_ocds_2015_12_25 (
  "uri" VARCHAR,
  "publisheddate" TIMESTAMP,
  "deadlinedate" TIMESTAMP,
  "publisher_name" VARCHAR,
  "publisher_scheme" VARCHAR,
  "publisher_uid" VARCHAR,
  "publisher_uri" VARCHAR,
  "version" DOUBLE,
  "extensions_0" VARCHAR,
  "license" VARCHAR,
  "publicationpolicy" VARCHAR,
  "releases_0_ocid" VARCHAR,
  "releases_0_id" VARCHAR,
  "releases_0_language" VARCHAR,
  "releases_0_date" TIMESTAMP,
  "releases_0_tag_0" VARCHAR,
  "releases_0_initiationtype" VARCHAR,
  "releases_0_tender_id" VARCHAR,
  "releases_0_tender_title" VARCHAR,
  "releases_0_tender_description" VARCHAR,
  "releases_0_tender_status" VARCHAR,
  "releases_0_tender_items_0_id" BIGINT,
  "releases_0_tender_items_0_description" VARCHAR,
  "releases_0_tender_items_0_classification_scheme" VARCHAR,
  "releases_0_tender_items_0_classification_id" BIGINT,
  "releases_0_tender_items_0_classification_description" VARCHAR,
  "releases_0_tender_items_0_classification_uri" VARCHAR,
  "releases_0_tender_items_1_id" DOUBLE,
  "releases_0_tender_items_1_description" VARCHAR,
  "releases_0_tender_items_1_classification_scheme" VARCHAR,
  "releases_0_tender_items_1_classification_id" DOUBLE,
  "releases_0_tender_items_1_classification_description" VARCHAR,
  "releases_0_tender_items_1_classification_uri" VARCHAR,
  "releases_0_tender_items_2_id" DOUBLE,
  "releases_0_tender_items_2_description" VARCHAR,
  "releases_0_tender_items_2_classification_scheme" VARCHAR,
  "releases_0_tender_items_2_classification_id" DOUBLE,
  "releases_0_tender_items_2_classification_description" VARCHAR,
  "releases_0_tender_items_2_classification_uri" VARCHAR,
  "releases_0_tender_minvalue_amount" BIGINT,
  "releases_0_tender_minvalue_currency" VARCHAR,
  "releases_0_tender_value_amount" BIGINT,
  "releases_0_tender_value_currency" VARCHAR,
  "releases_0_tender_procurementmethod" VARCHAR,
  "releases_0_tender_procurementmethoddetails" VARCHAR,
  "releases_0_tender_procurementmethodrationale" VARCHAR,
  "releases_0_tender_awardcriteria" VARCHAR,
  "releases_0_tender_awardcriteriadetails" VARCHAR,
  "releases_0_tender_submissionmethod" VARCHAR,
  "releases_0_tender_submissionmethoddetails" VARCHAR,
  "releases_0_tender_tenderperiod_enddate" TIMESTAMP,
  "releases_0_tender_hasenquiries" VARCHAR,
  "releases_0_tender_eligibilitycriteria" VARCHAR,
  "releases_0_tender_milestones_0_id" BIGINT,
  "releases_0_tender_milestones_0_title" VARCHAR,
  "releases_0_tender_milestones_0_description" VARCHAR,
  "releases_0_tender_milestones_0_duedate" TIMESTAMP,
  "releases_0_tender_milestones_0_status" VARCHAR,
  "releases_0_tender_milestones_1_id" BIGINT,
  "releases_0_tender_milestones_1_title" VARCHAR,
  "releases_0_tender_milestones_1_description" VARCHAR,
  "releases_0_tender_milestones_1_duedate" TIMESTAMP,
  "releases_0_tender_milestones_1_status" VARCHAR,
  "releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
  "releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
  "releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
  "releases_0_tender_supplychain" VARCHAR,
  "releases_0_buyer_identifier_scheme" VARCHAR,
  "releases_0_buyer_identifier_id" VARCHAR,
  "releases_0_buyer_identifier_legalname" VARCHAR,
  "releases_0_buyer_identifier_uri" VARCHAR,
  "releases_0_buyer_name" VARCHAR,
  "releases_0_buyer_id" BIGINT,
  "releases_0_buyer_address_streetaddress" VARCHAR,
  "releases_0_buyer_address_locality" VARCHAR,
  "releases_0_buyer_address_region" VARCHAR,
  "releases_0_buyer_address_postalcode" VARCHAR,
  "releases_0_buyer_address_countryname" VARCHAR,
  "releases_0_buyer_contactpoint_name" VARCHAR,
  "releases_0_buyer_contactpoint_email" VARCHAR,
  "releases_0_buyer_contactpoint_telephone" BIGINT,
  "releases_0_buyer_contactpoint_faxnumber" VARCHAR
);

Share link

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