Contracts Finder Notices 10–2017
Crown Commercial Service
@ukgov.contracts_finder_notices_10_2017
Loading...
Loading...
Loading...
Loading...
About this Dataset
Contracts Finder Notices 10–2017
This dataset contains Contracts Finder notices for Oct 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-10-01
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_01
- 115.39 kB
- 12 rows
- 119 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_01 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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" VARCHAR,
"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" VARCHAR,
"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" DOUBLE,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"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" VARCHAR,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" 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,
"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-10-02
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_02
- 1.04 MB
- 200 rows
- 949 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_02 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-10-03
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_03
- 902.84 kB
- 151 rows
- 825 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_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" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-10-04
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_04
- 397.81 kB
- 187 rows
- 262 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_04 (
"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" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" VARCHAR,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" DOUBLE,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR
);Contracts Finder OCDS 2017-10-05
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_05
- 621.78 kB
- 273 rows
- 476 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_05 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" 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-10-06
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_06
- 406.64 kB
- 93 rows
- 546 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_06 (
"https_www_contractsfinder_service_gov_uk_published_not_688f3c94" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/217ecf15-290a-4a6c-8c6e-7603f2698814.json,
"n_2017_10_06t13_08_42z" TIMESTAMP -- 2017-10-06T13:08:42Z,
"n_2017_07_24t00_00_00z" TIMESTAMP -- 2017-07-24T00: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_e7aaced2_6ca8_42ca_8e9c_3b77c9e4ae88" VARCHAR,
"ocds_b5fd17_e7aaced2_6ca8_42ca_8e9c_3b77c9e4ae88_17482_349e8d8c" VARCHAR -- Ocds-b5fd17-e7aaced2-6ca8-42ca-8e9c-3b77c9e4ae88-174828-calder001-dn263547-19298093,
"en_gb" VARCHAR,
"n_2017_10_06t13_08_42z_1" TIMESTAMP -- 2017-10-06T13:08:42Z.1,
"awardupdate" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_e7aaced2_6ca8_42ca_8e9c_3b77c9e4ae88_calde_4a77bbb0" VARCHAR -- Ocds-b5fd17-e7aaced2-6ca8-42ca-8e9c-3b77c9e4ae88-calder001-dn263547-19298093,
"residential_children_looked_after_placements_block_contract" VARCHAR -- Residential Children Looked After Placements (Block Contract),
"all_documentation_is_available_at_www_yortender_co_uk__47f5d0f3" VARCHAR -- All Documentation Is Available At Www.yortender.co.uk. The Borough Council Of Calderdale (\Calderdale Council\") Is To Commission A Service That Delivers Residential Placements For Children Looked After By Calderdale (the \"Service\"). The Service Will Have A Strong Focus On Positive Behaviour Management Support Based On Restorative Intervention,
"n__authoritative_parenting_and_a_strengths_focused_approach" VARCHAR -- Authoritative Parenting And A Strengths-focused Approach.",
"complete" 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,
"n_2" VARCHAR -- 2,
"see_description_of_related_tender_1" VARCHAR -- See Description Of Related Tender..1,
"cpv_1" DOUBLE,
"n_85311300" VARCHAR -- 85311300,
"welfare_services_for_children_and_young_people" VARCHAR,
"http_cpv_data_ac_uk_code_85311300_html" DOUBLE -- Http://cpv.data.ac.uk/code-85311300.html,
"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" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- 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-10-07
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_07
- 228.65 kB
- 6 rows
- 245 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_07 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" 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-10-08
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_08
- 98.23 kB
- 6 rows
- 102 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_08 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" VARCHAR,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" 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-10-09
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_09
- 587.99 kB
- 151 rows
- 712 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_09 (
"https_www_contractsfinder_service_gov_uk_published_not_f009aa1c" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/bd55a542-ae38-419e-89d4-7afba6af2952.json,
"n_2017_10_09t15_02_54z" VARCHAR -- 2017-10-09T15:02:54Z,
"n_2017_08_11t00_00_00z" VARCHAR -- 2017-08-11T00:00:00Z,
"due_north_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" DOUBLE -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" VARCHAR -- 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_a6fa3ee6_f2d4_459d_94be_cd989cd50a26" VARCHAR,
"ocds_b5fd17_a6fa3ee6_f2d4_459d_94be_cd989cd50a26_17521_8da5739e" VARCHAR -- Ocds-b5fd17-a6fa3ee6-f2d4-459d-94be-cd989cd50a26-175217-northlc001-dn289813-15309409,
"en_gb" VARCHAR,
"n_2017_10_09t15_02_54z_1" VARCHAR -- 2017-10-09T15:02:54Z.1,
"awardupdate" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_a6fa3ee6_f2d4_459d_94be_cd989cd50a26_north_5a19293a" VARCHAR -- Ocds-b5fd17-a6fa3ee6-f2d4-459d-94be-cd989cd50a26-northlc001-dn289813-15309409,
"provision_of_a_winter_bureau_and_weather_station_maint_722362eb" VARCHAR -- Provision Of A Winter Bureau And Weather Station Maintenance Service,
"the_humber_group_hull_city_north_east_lincolnshire_and_b76bdfc2" VARCHAR -- The Humber Group (Hull City, North East Lincolnshire And North Lincolnshire Councils) Operate A Road Weather Information System (RWIS), Which Comprises A Network Of Roadside Weather Stations (\Outstations\"),
"n__and_a_centralised_weather_management_service_bureau_7dfbcadf" VARCHAR -- And A Centralised Weather Data Management Service ('Bureau Service'). This Specification Outlines The Requirements For The Provision And Operation Of The Bureau Service,
"n__the_maintenance_of_associated_software" VARCHAR -- The Maintenance Of Associated Software,
"n__and_the_operation_and_maintenance_of_the_network_of_b3ff20c8" VARCHAR -- And The Operation And Maintenance Of The Network Of The Outstations And Non - Invasive Outstations And Ice Warning Signs On The A15 Between The Humber Bridge And M180. The Authorities Rely On Their Weather Station Networks For Their Winter Operations. There Are A Mix Of Technologies On The Network And Require A Contractor Who Has The Proven Technical Capability To Process And Display Data From All Weather Station Types. The Contractor Must Therefore Demonstrate That They Have The Experience And Competence In Collecting And Processing Data From RoSA,
"n__rws200_and_non_invasive" VARCHAR -- RWS200 And Non-invasive,
"n__dst111_dsc111_based_stations_these_are_all_working__81d24102" VARCHAR -- DST111/DSC111 Based Stations. These Are All Working On Specific Message Formats Using A Combination Of Dedicated Internet Communications And Dial-up Processes And This Is To Ensure Reliable And Efficient Data Transfer Of Data/images. Please Note North Lincolnshire Council Is Procuring On Behalf Of The Humber Group Of Authorities (Comprising North Lincolnshire Council,
"n__north_east_lincolnshire_council" VARCHAR -- North East Lincolnshire Council,
"n__hull_city_council_further_information_is_available__25fed364" VARCHAR -- Hull City Council) Further Information Is Available To Download Via Http://www/yortender.co.uk The Deadline For The Submission Of Tenders Is 12noon 11 August 2017",
"complete" VARCHAR,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" VARCHAR,
"n_71350000" VARCHAR -- 71350000,
"engineering_related_scientific_and_technical_services" VARCHAR,
"http_cpv_data_ac_uk_code_71350000_html" DOUBLE -- Http://cpv.data.ac.uk/code-71350000.html,
"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" 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" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" DOUBLE -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" DOUBLE -- 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-10-10
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_10
- 276.96 kB
- 102 rows
- 276 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_10 (
"https_www_contractsfinder_service_gov_uk_published_not_c410188b" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/c5580e65-da5c-408d-9721-e6cf6cf9db7a.json,
"n_2017_10_10t13_28_25z" VARCHAR -- 2017-10-10T13:28:25Z,
"n_2017_02_24t00_00_00z" VARCHAR -- 2017-02-24T00:00:00Z,
"in_tend_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" DOUBLE -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" VARCHAR -- 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_95a45b4d_c88d_439b_8af9_80f935373c7a" VARCHAR,
"ocds_b5fd17_95a45b4d_c88d_439b_8af9_80f935373c7a_17545_3c90a555" VARCHAR -- Ocds-b5fd17-95a45b4d-c88d-439b-8af9-80f935373c7a-175456-wscc---012743---award,
"en_gb" VARCHAR,
"n_2017_10_10t13_28_25z_1" VARCHAR -- 2017-10-10T13:28:25Z.1,
"award" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_95a45b4d_c88d_439b_8af9_80f935373c7a_wscc__6f4e58a6" VARCHAR -- Ocds-b5fd17-95a45b4d-c88d-439b-8af9-80f935373c7a-wscc---012743---award,
"wscc_lc_ncn2_mini_comp_award" VARCHAR -- WSCC - LC - NCN2 Mini Comp - AWARD,
"the_project_to_be_procured_is_the_national_cycle_netwo_e8e8cbf4" VARCHAR -- The Project To Be Procured Is The National Cycle Network (NCN) Route 2 Between Bognor And Littlehampton: \The Development Of A Shared Use Footway/cycleway For Use By Pedestrians And Cyclists Between Bognor Regis And Littlehampton On The Northern Side Of The A259 Carriageway,
"n__approximately_3_metres_width_constructed_within_the_774af738" VARCHAR -- Approximately 3 Metres Width Constructed Within The Existing Road Verge,
"n__with_separation_between_the_footway_cycleway_and_th_d2164268" VARCHAR -- With Separation Between The Footway/cycleway And The Carriageway Covering Approximately 4.4 Kilometres In Total Length. The Proposed Scheme Forms Part Of The NCN Route 2,
"n__which_aims_to_provide_a_continuous_cycle_route_from_93316d42" VARCHAR -- Which Aims To Provide A Continuous Cycle Route From Dover To Penzance.\"",
"complete" VARCHAR,
"n_1" DOUBLE -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" VARCHAR,
"n_45233000" DOUBLE -- 45233000,
"construction_foundation_and_surface_works_for_highways_roads" VARCHAR -- Construction, Foundation And Surface Works For Highways, Roads,
"http_cpv_data_ac_uk_code_45233000_html" VARCHAR -- Http://cpv.data.ac.uk/code-45233000.html,
"n_2" DOUBLE -- 2,
"see_description_of_related_tender_1" VARCHAR -- See Description Of Related Tender..1,
"cpv_1" VARCHAR,
"n_45233130" DOUBLE -- 45233130,
"construction_work_for_highways" VARCHAR,
"http_cpv_data_ac_uk_code_45233130_html" VARCHAR -- Http://cpv.data.ac.uk/code-45233130.html,
"n_3" DOUBLE -- 3,
"see_description_of_related_tender_2" VARCHAR -- See Description Of Related Tender..2,
"cpv_2" VARCHAR,
"n_45233210" DOUBLE -- 45233210,
"surface_work_for_highways" VARCHAR,
"http_cpv_data_ac_uk_code_45233210_html" VARCHAR -- Http://cpv.data.ac.uk/code-45233210.html,
"n_4" DOUBLE -- 4,
"see_description_of_related_tender_3" VARCHAR -- See Description Of Related Tender..3,
"cpv_3" VARCHAR,
"n_45233100" DOUBLE -- 45233100,
"construction_work_for_highways_roads" VARCHAR -- Construction Work For Highways, Roads,
"http_cpv_data_ac_uk_code_45233100_html" VARCHAR -- Http://cpv.data.ac.uk/code-45233100.html,
"n_5" DOUBLE -- 5,
"see_description_of_related_tender_4" VARCHAR -- See Description Of Related Tender..4,
"cpv_4" VARCHAR,
"n_45233310" DOUBLE -- 45233310,
"foundation_work_for_highways" VARCHAR,
"http_cpv_data_ac_uk_code_45233310_html" VARCHAR -- Http://cpv.data.ac.uk/code-45233310.html,
"n_6" DOUBLE -- 6,
"see_description_of_related_tender_5" VARCHAR -- See Description Of Related Tender..5,
"cpv_5" VARCHAR,
"n_45233300" DOUBLE -- 45233300,
"foundation_work_for_highways_roads_streets_and_footpaths" VARCHAR -- Foundation Work For Highways, Roads, Streets And Footpaths,
"http_cpv_data_ac_uk_code_45233300_html" VARCHAR -- Http://cpv.data.ac.uk/code-45233300.html,
"unnamed_62" DOUBLE -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- 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" VARCHAR -- 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" TIMESTAMP -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" DOUBLE -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"n_0" VARCHAR -- 0,
"gbp" VARCHAR,
"n_0_1" VARCHAR -- 0.1,
"gbp_1" VARCHAR,
"unnamed_90" VARCHAR -- Unnamed: 90,
"other" VARCHAR -- Other -,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" TIMESTAMP -- Unnamed: 94,
"unnamed_95" VARCHAR -- Unnamed: 95,
"please_apply_directly_to_the_buyer_using_the_contact_d_1536706a" DOUBLE -- Please Apply Directly To The Buyer Using The Contact Details Provided.,
"unnamed_97" VARCHAR -- Unnamed: 97,
"n_2017_02_24t00_00_00z_1" VARCHAR -- 2017-02-24T00:00:00Z.1,
"unnamed_99" VARCHAR -- Unnamed: 99
);Contracts Finder OCDS 2017-10-11
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_11
- 328.94 kB
- 198 rows
- 188 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_11 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR
);Contracts Finder OCDS 2017-10-12
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_12
- 1.41 MB
- 233 rows
- 1,320 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_12 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" 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" VARCHAR,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" VARCHAR,
"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-10-13
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_13
- 489.86 kB
- 248 rows
- 304 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_13 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);Contracts Finder OCDS 2017-10-14
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_14
- 94.7 kB
- 10 rows
- 96 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_14 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" DOUBLE,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
"releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);Contracts Finder OCDS 2017-10-15
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_15
- 146.26 kB
- 9 rows
- 150 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_15 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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-10-16
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_16
- 583.96 kB
- 159 rows
- 667 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_16 (
"https_www_contractsfinder_service_gov_uk_published_not_8bec6687" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/9487e0ec-bed9-4bc2-bad9-72cc8baa69b8.json,
"n_2017_10_16t16_44_40z" VARCHAR -- 2017-10-16T16:44:40Z,
"n_2017_09_22t00_00_00z" VARCHAR -- 2017-09-22T00: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" VARCHAR -- 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_43bc5abe_85a0_48c2_871b_e3ddf1333a23" VARCHAR,
"ocds_b5fd17_43bc5abe_85a0_48c2_871b_e3ddf1333a23_17667_e48c6950" VARCHAR -- Ocds-b5fd17-43bc5abe-85a0-48c2-871b-e3ddf1333a23-176673-cornwall001-dn262569-19105740,
"en_gb" VARCHAR,
"n_2017_10_16t16_44_40z_1" VARCHAR -- 2017-10-16T16:44:40Z.1,
"awardupdate" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_43bc5abe_85a0_48c2_871b_e3ddf1333a23_cornw_02b5ba9c" VARCHAR -- Ocds-b5fd17-43bc5abe-85a0-48c2-871b-e3ddf1333a23-cornwall001-dn262569-19105740,
"non_hazardous_waste_collection_and_disposal_and_recycl_fb12345d" VARCHAR -- Non-Hazardous Waste Collection And Disposal And Recycling Service For Tamar Bridge And Torpoint Ferry Premises,
"the_overall_service_requirement_is_itt_is_for_the_prov_b28d436a" VARCHAR -- The Overall Service Requirement Is ITT Is For The Provision Of A Non-hazardous \zero To Landfill\" Waste Collection,
"n__disposal_and_recycling_service_for_the_premises_gov_119f0e84" VARCHAR -- Disposal And Recycling Service For The Premises Governed By The Tamar Bridge And Torpoint Ferry Joint Committee (TBTFJC). The Service Is To Be Provided At The Two Main Operating Sites,
"n__split_by_the_river_tamar" VARCHAR -- Split By The River Tamar,
"n__the_tamar_bridge" VARCHAR -- - The Tamar Bridge,
"n__covering_both_plymouth_and_saltash_bridge_operations" VARCHAR -- Covering Both Plymouth And Saltash Bridge Operations,
"n__and_the_torpoint_ferry" DOUBLE -- And The Torpoint Ferry,
"n__covering_devonport_and_torpoint_ferry_operations_ma_2caa03a8" VARCHAR -- Covering Devonport And Torpoint Ferry Operations. Main Service Requirements: 1. General Waste The Service Will Consist Of The Collection,
"n__removal_and_disposal_of_all_non_hazardous_waste_mat_e63c0696" VARCHAR -- Removal And Disposal Of All Non-hazardous Waste Materials As Detailed In The Specification. The Contractor Will Be Responsible For Applying The Waste Hierarchy Once The Waste Has Been Collected,
"n__waste_must_not_go_to_landfill_the_contractor_will_b_8cc3c2a5" DOUBLE -- Waste Must Not Go To Landfill. The Contractor Will Be Required To Collect And Dispose Of All Non-hazardous Waste In An Appropriate,
"n__secure_and_environmentally_preferable_manner_this_i_cff0d041" VARCHAR -- Secure And Environmentally Preferable Manner; This Is To Be Provided Directly By The Contractor Or Through Collections By The Relevant Local Authority Or Other Reputable Organisation That The Supplier May Contract With. In Fulfillment Of Its Statutory Duty Of Care,
"n__tbtfjc_will_require_the_contractor_to_provide_full__3565992b" VARCHAR -- TBTFJC Will Require The Contractor To Provide Full Information On The Methods Of Disposal Of Waste,
"n__showing_clear_evidence_of_using_disposal_methods_wh_769d8107" DOUBLE -- Showing Clear Evidence Of Using Disposal Methods Which Are Environmentally Acceptable. The Contractor Will Be Required To Provide Collection Point Bins,
"n__containers" VARCHAR -- Containers,
"n__skips_etc_that_are_suitably_marked_and_signed_etc_2_5abb686f" VARCHAR -- Skips Etc. That Are Suitably Marked And Signed Etc. 2. Confidential Waste The Contractor Will Be Required To Ensure The Secure Collection,
"n__storage" DOUBLE -- Storage,
"n__removal_and_disposal_of_all_confidential_materials" VARCHAR -- Removal And Disposal Of All Confidential Materials,
"n__so_that_at_no_time_are_these_materials_are_out_of_t_fbadb5e0" VARCHAR -- So That At No Time Are These Materials Are Out Of The Contractors Possession,
"n__or_capable_of_being_deciphered_once_disposed_of_con_0789ecd3" DOUBLE -- Or Capable Of Being Deciphered Once Disposed Of. Confidential Waste Will Need To Be Signed For By The Nominated Contractor's Staff At The Point Of Collection,
"n__and_the_contractor_staff_member_shall_further_indic_3bd73026" VARCHAR -- And The Contractor Staff Member Shall Further Indicate On Each Disposal,
"n__that_it_has_been_adequately_destroyed_all_contracto_84c551b1" VARCHAR -- That It Has Been Adequately Destroyed. All Contractor's Staff Engaged In The Disposal Of Confidential Waste Must Be Security Cleared To An Appropriate Level And The Contractor Shall Be Responsible For Ensuring That Only Those Staff Appropriately Cleared Have Any Access Whatsoever To Confidential Waste And That All Confidential Waste Is Disposed Of In Line With Current Legislation. 3. Recycled Waste The Contractor Will Be Responsible For Recycling,
"n__as_a_minimum" DOUBLE -- As A Minimum,
"n__paper" VARCHAR -- Paper,
"n__cardboard" VARCHAR -- Cardboard,
"n__glass" VARCHAR -- Glass,
"n__plastic_and_cans" VARCHAR -- Plastic And Cans,
"n__although" VARCHAR -- Although,
"n__the_contractor_will_be_required_to_increase_the_per_ede838a9" DOUBLE -- The Contractor Will Be Required To Increase The Percentage And Range Of Goods That Are Recycled With \"energy Recovery\" Being The Last Disposal Option By The Contractor. Landfill Is Not A Disposal Option. The Contractor Will Be Responsible For The Adequate Provision Of Suitable Receptacles For Various Types Of Recyclable Waste,
"n__and_will_provide_any_additional_guidelines_or_strat_f7a2e4a6" VARCHAR -- And Will Provide Any Additional Guidelines Or Strategies For Recycling Material.",
"complete" VARCHAR,
"n_1" DOUBLE -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" VARCHAR,
"n_90500000" DOUBLE -- 90500000,
"refuse_and_waste_related_services" VARCHAR,
"http_cpv_data_ac_uk_code_90500000_html" VARCHAR -- Http://cpv.data.ac.uk/code-90500000.html,
"unnamed_56" VARCHAR -- 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" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" TIMESTAMP -- Unnamed: 70,
"unnamed_71" TIMESTAMP -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" DOUBLE -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- 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,
"n_100000" VARCHAR -- 100000,
"gbp" VARCHAR,
"n_0" VARCHAR -- 0,
"gbp_1" VARCHAR,
"unnamed_90" VARCHAR -- Unnamed: 90,
"open_procedure" VARCHAR,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" DOUBLE -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" VARCHAR -- Unnamed: 95,
"please_apply_directly_to_the_buyer_using_the_contact_d_1536706a" DOUBLE -- Please Apply Directly To The Buyer Using The Contact Details Provided.,
"unnamed_97" VARCHAR -- Unnamed: 97,
"n_2017_09_22t00_00_00z_1" VARCHAR -- 2017-09-22T00:00:00Z.1,
"unnamed_99" VARCHAR -- Unnamed: 99
);Contracts Finder OCDS 2017-10-17
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_17
- 349.43 kB
- 152 rows
- 215 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR
);Contracts Finder OCDS 2017-10-18
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_18
- 325.83 kB
- 181 rows
- 189 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_18 (
"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" 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" VARCHAR,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" VARCHAR,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" VARCHAR,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_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-10-19
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_19
- 682.89 kB
- 217 rows
- 541 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_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_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-10-20
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_20
- 418.16 kB
- 109 rows
- 449 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_20 (
"https_www_contractsfinder_service_gov_uk_published_not_8053301c" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/2328454d-0f14-4c55-bf73-e8d279d31e77.json,
"n_2017_10_20t14_16_57z" TIMESTAMP -- 2017-10-20T14:16:57Z,
"n_2017_11_17t00_00_00z" TIMESTAMP -- 2017-11-17T00: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_f194732a_e606_473d_9be9_32e66e4b0323" VARCHAR,
"ocds_b5fd17_f194732a_e606_473d_9be9_32e66e4b0323_17756_abec87ef" VARCHAR -- Ocds-b5fd17-f194732a-e606-473d-9be9-32e66e4b0323-177562-slake001-dn301550-49622148,
"en_gb" VARCHAR,
"n_2017_10_20t14_16_57z_1" TIMESTAMP -- 2017-10-20T14:16:57Z.1,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_f194732a_e606_473d_9be9_32e66e4b0323_slake_b76c634c" VARCHAR -- Ocds-b5fd17-f194732a-e606-473d-9be9-32e66e4b0323-slake001-dn301550-49622148,
"recycling_bring_sites_services" VARCHAR,
"south_lakeland_district_council_provides_recycling_col_efa7948d" VARCHAR -- South Lakeland District Council Provides Recycling Collection Facilities To Communities Throughout The District By Way Of Kerbside Collections And Recycling Banks (known As \Bring Sites\") There Are 19 Recycling Bring Site Locations At Strategic Sites Throughout The District Which Receive Approximately 2,
"n_500_tonnes_of_recyclables_between_them_each_year_man_afdf470d" VARCHAR -- 500 Tonnes Of Recyclables Between Them Each Year. Many Of The Sites Are On Land Owned And Controlled By Third-parties. The Council Is Inviting Tenders For The Provision Of The Recycling Containers (bring Banks) And Maintaining Them In A Good,
"n__clean_and_safe_condition_at_bring_sites_throughout__f6eb0a79" BIGINT -- Clean And Safe Condition At Bring Sites Throughout The District. The Recycling Bring Sites Services Contract Provides For The Collection Of Paper,
"n__card" VARCHAR -- Card,
"n__glass" VARCHAR -- Glass,
"n__cans_and_plastics_from_the_banks" BIGINT -- Cans And Plastics From The Banks,
"n__which_will_then_be_sold_for_re_processing_the_contr_414e755a" VARCHAR -- Which Will Then Be Sold For Re-processing. The Contractor Shall Retain The Value Of The Materials Collected And Will Be Required To Maximise The Quantity And Value Of Recyclables Arising From The Contract. All Expressions Of Interest,
"n__clarification_questions_and_submission_must_be_made_5664b4ce" VARCHAR -- Clarification Questions And Submission Must Be Made The Chest (www.the-chest.org.uk). Submission Deadline Is 7pm On 20 November 2017.",
"unsuccessful" DOUBLE,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" DOUBLE,
"n_90000000" VARCHAR -- 90000000,
"sewage_refuse_cleaning_and_environmental_services" VARCHAR -- Sewage, Refuse, Cleaning And Environmental Services,
"http_cpv_data_ac_uk_code_90000000_html" DOUBLE -- Http://cpv.data.ac.uk/code-90000000.html,
"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" 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" VARCHAR -- Unnamed: 91,
"unnamed_92" DOUBLE -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" DOUBLE -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"unnamed_97" VARCHAR -- Unnamed: 97,
"unnamed_98" DOUBLE -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);Contracts Finder OCDS 2017-10-21
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_21
- 134.57 kB
- 10 rows
- 136 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_21 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" DOUBLE,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"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-10-22
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_22
- 165.32 kB
- 14 rows
- 155 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_22 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" 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
);Contracts Finder OCDS 2017-10-23
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_23
- 432.96 kB
- 50 rows
- 579 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_23 (
"https_www_contractsfinder_service_gov_uk_published_not_2693f19b" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/8e1d5fea-a9db-434c-a78f-b8332112b969.json,
"n_2017_10_23t12_07_27z" TIMESTAMP -- 2017-10-23T12:07:27Z,
"n_2017_09_22t00_00_00z" TIMESTAMP -- 2017-09-22T00: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_90623b3c_cd73_4e87_b294_d924954e8bee" VARCHAR,
"ocds_b5fd17_90623b3c_cd73_4e87_b294_d924954e8bee_17777_0b7d75c2" VARCHAR -- Ocds-b5fd17-90623b3c-cd73-4e87-b294-d924954e8bee-177774-leicscc001-dn296787-99725668,
"en_gb" VARCHAR,
"n_2017_10_23t12_07_27z_1" TIMESTAMP -- 2017-10-23T12:07:27Z.1,
"awardupdate" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_90623b3c_cd73_4e87_b294_d924954e8bee_leics_6d28d6a7" VARCHAR -- Ocds-b5fd17-90623b3c-cd73-4e87-b294-d924954e8bee-leicscc001-dn296787-99725668,
"the_removal_storage_and_disposal_of_abandoned_vehicles_4ec0321a" VARCHAR -- The Removal, Storage And Disposal Of Abandoned Vehicles (covering The District And Borough Councils Of Charnwood, Harborough, Melton, North West Leicestershire, And Oadby And Wigston),
"leicestershire_county_council_the_council_invited_quot_130224ca" VARCHAR -- Leicestershire County Council (\the Council\") Invited Quotations For The Removal,
"n__storage_and_disposal_of_abandoned_vehicles_the_coun_60531c1b" VARCHAR -- Storage And Disposal Of Abandoned Vehicles. The Council Was Procuring Services For Itself And On Behalf Of The Following District Councils:- Charnwood Borough Council Of Council Offices,
"n__southfield_road" BIGINT -- Southfield Road,
"n__loughborough" VARCHAR -- Loughborough,
"n__le11_2tx_and" VARCHAR -- LE11–2TX; And,
"n__harborough_district_council_of_the_symington_building" BIGINT -- Harborough District Council Of The Symington Building,
"n__adam_and_eve_street" VARCHAR -- Adam And Eve Street,
"n__market_harborough" VARCHAR -- Market Harborough,
"n__leicestershire" DOUBLE -- Leicestershire,
"n__le16_7ag_and" VARCHAR -- LE16–7AG; And,
"n__melton_borough_council_of_parkside" VARCHAR -- Melton Borough Council Of Parkside,
"n__station_approach" DOUBLE -- Station Approach,
"n__burton_street" VARCHAR -- Burton Street,
"n__melton_mowbray" VARCHAR -- Melton Mowbray,
"n__leicestershire_1" DOUBLE -- Leicestershire.1,
"n__le13_1gh_and" VARCHAR -- LE13–1GH; And,
"n__north_west_leicestershire_district_council_of_counc_0c37cbfe" VARCHAR -- North West Leicestershire District Council Of Council Offices,
"n__coalville" DOUBLE -- Coalville,
"n__leicestershire_2" VARCHAR -- Leicestershire.2,
"n__le67_3fj_and" VARCHAR -- LE67–3FJ; And,
"n__oadby_and_wigston_borough_council_of_council_offices" DOUBLE -- Oadby And Wigston Borough Council Of Council Offices,
"n__station_road" VARCHAR -- Station Road,
"n__wigston" VARCHAR -- Wigston,
"n__leicestershire_3" DOUBLE -- Leicestershire.3,
"n__le18_2dr_the_proposed_contract_was_offered_for_a_mi_8f8bdccd" VARCHAR -- LE18–2DR. The Proposed Contract Was Offered For A Minimum Period Of 24 Months With The Possibility To Extend The Contract By Up To A Further Period Or Periods,
"n__totalling_up_to_36_months_the_contract_was_expected_3cd91970" VARCHAR -- Totalling Up To 36 Months. The Contract Was Expected To Be Awarded To A Single Tenderer.",
"complete" DOUBLE,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" DOUBLE,
"n_90000000" VARCHAR -- 90000000,
"sewage_refuse_cleaning_and_environmental_services" VARCHAR -- Sewage, Refuse, Cleaning And Environmental Services,
"http_cpv_data_ac_uk_code_90000000_html" DOUBLE -- Http://cpv.data.ac.uk/code-90000000.html,
"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" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- 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-10-24
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_24
- 676.77 kB
- 191 rows
- 545 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_24 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" VARCHAR,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" VARCHAR,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" DOUBLE,
"releases_0_tender_awardcriteria" DOUBLE,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR
);Contracts Finder OCDS 2017-10-25
@ukgov.contracts_finder_notices_10_2017.contracts_finder_ocds_2017_10_25
- 1.48 MB
- 178 rows
- 1,423 columns
Loading...
Loading...
CREATE TABLE contracts_finder_ocds_2017_10_25 (
"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
);