Contracts Finder Notices 11–2017
Crown Commercial Service
@ukgov.contracts_finder_notices_11_2017
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 11–2017
This dataset contains Contracts Finder notices for Nov 2017. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2022-07-01T04:05:45Z
Tables
Contracts Finder OCDS 2017-11-01
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_01
- 554.67 kB
- 171 rows
- 436 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_01 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-02
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_02
- 678.26 kB
- 188 rows
- 556 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_02 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"releases_0_tender_hasenquiries" DOUBLE,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" VARCHAR,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" VARCHAR,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR
);Contracts Finder OCDS 2017-11-03
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_03
- 647.58 kB
- 195 rows
- 490 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_03 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" VARCHAR,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-04
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_04
- 102.88 kB
- 3 rows
- 109 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_04 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" BIGINT,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" BIGINT,
"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" 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" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR
);Contracts Finder OCDS 2017-11-05
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_05
- 106.79 kB
- 7 rows
- 103 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR
);Contracts Finder OCDS 2017-11-06
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_06
- 648.06 kB
- 164 rows
- 537 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_06 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-07
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_07
- 388 kB
- 175 rows
- 272 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_07 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" VARCHAR,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" VARCHAR,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_tenderperiod_startdate" VARCHAR,
"releases_0_tender_hasenquiries" DOUBLE,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" VARCHAR,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" VARCHAR,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" VARCHAR,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" VARCHAR,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" TIMESTAMP,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" DOUBLE,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" DOUBLE
);Contracts Finder OCDS 2017-11-08
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_08
- 962.69 kB
- 184 rows
- 821 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_08 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-09
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_09
- 259.58 kB
- 99 rows
- 247 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_09 (
"https_www_contractsfinder_service_gov_uk_published_not_baae68be" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/dcafbf6a-1fd5-4412-bb25-0b487c0fccbe.json,
"n_2017_11_09t14_36_58z" TIMESTAMP -- 2017-11-09T14:36:58Z,
"n_2017_11_13t00_00_00z" TIMESTAMP -- 2017-11-13T00:00:00Z,
"in_tend_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" DOUBLE -- 1.1,
"https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR -- Https://raw.githubusercontent.com/open-contracting/ocds Process Title Extension/v1.1/extension.json,
"https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR -- Https://www.nationalarchives.gov.uk/doc/open-government-licence/version/2/,
"https_www_gov_uk_government_publications_open_contracting" VARCHAR -- Https://www.gov.uk/government/publications/open-contracting,
"ocds_b5fd17_0f7517ae_eb46_40fc_aa38_4cd654581322" VARCHAR,
"ocds_b5fd17_0f7517ae_eb46_40fc_aa38_4cd654581322_18087_03cb453b" VARCHAR -- Ocds-b5fd17-0f7517ae-eb46-40fc-aa38-4cd654581322-180879-scc---017296,
"en_gb" VARCHAR,
"n_2017_11_09t14_36_58z_1" TIMESTAMP -- 2017-11-09T14:36:58Z.1,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_0f7517ae_eb46_40fc_aa38_4cd654581322_scc_017296" VARCHAR -- Ocds-b5fd17-0f7517ae-eb46-40fc-aa38-4cd654581322-scc---017296,
"scc_agc_the_hope_mental_health_project_epsom" VARCHAR -- SCC AGC The Hope (Mental Health) Project, Epsom,
"an_opportunity_has_arisen_for_an_established_mental_he_7a2735f6" VARCHAR -- An Opportunity Has Arisen For An Established Mental Health Provider To Take On Responsibility For Delivering On-site Support To Tenants At The Epsom Hope Project. The Epsom Hope Project Is A Long-standing Project To Meet The Housing And Support Needs Of Individuals With Severe And Enduring Mental Health Problems Through The Provision Of Safe, Independent Homes With Appropriate And Flexible Levels Of Care And Support. The Epsom Hope Project Accommodation, Owned And Managed By Roseberry Housing Association, Consists Of Six Self-contained Flats With Shared Communal Areas, And Is Based In Helm Close, Epsom. Each Tenant (known Henceforth As An \Individual\") Living At The Hope Project Has Their Own Tenancy,
"n__and_support_is_provided_to_meet_their_individual_ne_0c402624" VARCHAR -- And Support Is Provided To Meet Their Individual Needs Through The Delivery Of Personalised Support Plans.",
"unsuccessful" BIGINT,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" BIGINT,
"n_85000000" VARCHAR -- 85000000,
"health_and_social_work_services" VARCHAR,
"http_cpv_data_ac_uk_code_85000000_html" DOUBLE -- Http://cpv.data.ac.uk/code-85000000.html,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" DOUBLE -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" DOUBLE -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" DOUBLE -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" DOUBLE -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" DOUBLE -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" DOUBLE -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" DOUBLE -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" DOUBLE -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" DOUBLE -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" DOUBLE -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" DOUBLE -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" DOUBLE -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" DOUBLE -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" DOUBLE -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" DOUBLE -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" DOUBLE -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" DOUBLE -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" VARCHAR -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"unnamed_97" VARCHAR -- Unnamed: 97,
"unnamed_98" VARCHAR -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);Contracts Finder OCDS 2017-11-10
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_10
- 548.38 kB
- 212 rows
- 392 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR
);Contracts Finder OCDS 2017-11-11
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_11
- 146.73 kB
- 8 rows
- 149 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_11 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR
);Contracts Finder OCDS 2017-11-12
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_12
- 152.68 kB
- 8 rows
- 150 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_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_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 2017-11-13
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_13
- 643.9 kB
- 175 rows
- 527 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_13 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"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" DOUBLE
);Contracts Finder OCDS 2017-11-14
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_14
- 542.08 kB
- 165 rows
- 400 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_14 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-15
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_15
- 273.7 kB
- 130 rows
- 197 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_15 (
"https_www_contractsfinder_service_gov_uk_published_not_c2b1c21c" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/7b8ad25d-c033-4a4d-b5e5-2ee9af482afe.json,
"n_2017_11_15t15_10_40z" TIMESTAMP -- 2017-11-15T15:10:40Z,
"n_2017_08_04t00_00_00z" TIMESTAMP -- 2017-08-04T00:00:00Z,
"due_north_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" DOUBLE -- 1.1,
"https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR -- Https://raw.githubusercontent.com/open-contracting/ocds Process Title Extension/v1.1/extension.json,
"https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR -- Https://www.nationalarchives.gov.uk/doc/open-government-licence/version/2/,
"https_www_gov_uk_government_publications_open_contracting" VARCHAR -- Https://www.gov.uk/government/publications/open-contracting,
"ocds_b5fd17_57a541d4_d74f_4cce_a3f5_c1b9469e43bb" VARCHAR,
"ocds_b5fd17_57a541d4_d74f_4cce_a3f5_c1b9469e43bb_18215_63303a70" VARCHAR -- Ocds-b5fd17-57a541d4-d74f-4cce-a3f5-c1b9469e43bb-182150-northlc001-dn287345-96779943,
"en_gb" VARCHAR,
"n_2017_11_15t15_10_40z_1" TIMESTAMP -- 2017-11-15T15:10:40Z.1,
"awardupdate" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_57a541d4_d74f_4cce_a3f5_c1b9469e43bb_north_6c126c1a" VARCHAR -- Ocds-b5fd17-57a541d4-d74f-4cce-a3f5-c1b9469e43bb-northlc001-dn287345-96779943,
"provision_of_hydraulic_modelling_and_optioneering_serv_d4f5cce5" VARCHAR -- Provision Of Hydraulic Modelling And Optioneering Services - Danvm Drainage Commissioners,
"danvm_drainage_commissioners_are_inviting_tenders_for__e2a2ede0" VARCHAR -- Danvm Drainage Commissioners Are Inviting Tenders For The Provision Of Hydraulic Modelling And Optioneering Services. Danvm Drainage Commissioners (\IDB\") Has Commissioned And Completed A Hydraulic Model Of Its Open Channel And Pumped Drainage Network In Order To Achieve The Following: • Gain A More Comprehensive Understanding Of Fluvial Flood Risk From The IDB Network; • Provide An Evidence Based Decision Making Tool To Be Used To Support Funding Applications For Undertaking Works On The System E.g. Pump Replacement And Ditch Realignment. This Is The First Time An IDB Has Approached Hydraulic Modelling From A Drainage District-wide Perspective To Inform Future Strategy And Provide An Evidenced Based Decision Tool In Relation To Asset Management And Total Catchment Management. The Next Stage In The Development Of The Hydraulic Model And Therefore Evidenced- Based Decision Process Is Further Optioneering With The Base Hydraulic Model,
"n__as_set_out_and_required_by_this_contract_danvm_drai_01754e9d" VARCHAR -- As Set Out And Required By This Contract. Danvm Drainage Commissioners Therefore Wish To Demonstrate The Benefits Of Water Level Management For The Drainage District Through Hydraulic Modelling And Optioneering,
"n__or_testing" BIGINT -- Or Testing,
"n__of_the_base_hydraulic_model_further_information_is__78e8dd4c" VARCHAR -- Of The Base Hydraulic Model. Further Information Is Available In The Specification. Please Note That North Lincolnshire Council Are Acting As Commissioned Procurement Agents Only On This Project. Any Resulting Contract Will Be Between Danvm Drainage Commissioners And The Successful Tenderer. The Deadline For The Submission Of Tender Is 12noon 4 August 2017.",
"complete" VARCHAR,
"n_1" BIGINT -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" VARCHAR,
"n_90700000" DOUBLE -- 90700000,
"environmental_services" VARCHAR,
"http_cpv_data_ac_uk_code_90700000_html" VARCHAR -- Http://cpv.data.ac.uk/code-90700000.html,
"n_2" DOUBLE -- 2,
"see_description_of_related_tender_1" VARCHAR -- See Description Of Related Tender..1,
"cpv_1" VARCHAR,
"n_90713000" DOUBLE -- 90713000,
"environmental_issues_consultancy_services" VARCHAR,
"http_cpv_data_ac_uk_code_90713000_html" VARCHAR -- Http://cpv.data.ac.uk/code-90713000.html,
"unnamed_38" DOUBLE -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" DOUBLE -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" DOUBLE -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" DOUBLE -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" DOUBLE -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" DOUBLE -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" DOUBLE -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" DOUBLE -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" DOUBLE -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" DOUBLE -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" DOUBLE -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" DOUBLE -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" DOUBLE -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" DOUBLE -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" DOUBLE -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" DOUBLE -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" DOUBLE -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" DOUBLE -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" DOUBLE -- Unnamed: 91,
"n_110000" VARCHAR -- 110000,
"gbp" VARCHAR,
"n_130000" VARCHAR -- 130000,
"gbp_1" VARCHAR,
"unnamed_96" VARCHAR -- Unnamed: 96,
"open_procedure" VARCHAR,
"unnamed_98" VARCHAR -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);Contracts Finder OCDS 2017-11-16
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_16
- 764.46 kB
- 215 rows
- 645 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_16 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-17
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_17
- 438.66 kB
- 223 rows
- 256 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR
);Contracts Finder OCDS 2017-11-18
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_18
- 166.25 kB
- 11 rows
- 172 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_18 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR
);Contracts Finder OCDS 2017-11-19
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_19
- 142.13 kB
- 7 rows
- 140 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_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_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" BIGINT,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR
);Contracts Finder OCDS 2017-11-20
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_20
- 424.24 kB
- 203 rows
- 272 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_20 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" DOUBLE,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT
);Contracts Finder OCDS 2017-11-21
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_21
- 361.06 kB
- 208 rows
- 212 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_21 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" 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" VARCHAR,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" VARCHAR,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_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" VARCHAR,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-22
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_22
- 1.17 MB
- 169 rows
- 1,085 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_22 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" VARCHAR,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" VARCHAR,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" VARCHAR,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" VARCHAR,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" VARCHAR,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" VARCHAR,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" VARCHAR,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-23
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_23
- 500.36 kB
- 199 rows
- 344 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_23 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-11-24
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_24
- 355.28 kB
- 188 rows
- 228 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_24 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" VARCHAR,
"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" VARCHAR,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" VARCHAR,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR
);Contracts Finder OCDS 2017-11-25
@ukgov.contracts_finder_notices_11_2017.contracts_finder_ocds_2017_11_25
- 91 kB
- 4 rows
- 96 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_11_25 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" BIGINT,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" DOUBLE,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
"releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);