Contracts Finder Notices 01–2018
Crown Commercial Service
@ukgov.contracts_finder_notices_01_20181
Crown Commercial Service
@ukgov.contracts_finder_notices_01_20181
This dataset contains Contracts Finder notices for Jan 2018. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2022-07-01T04:05:41Z
CREATE TABLE contracts_finder_ocds_2018_01_01 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" BIGINT,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" DOUBLE,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_02 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_03 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_04 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" VARCHAR,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" VARCHAR,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" VARCHAR,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_05 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" VARCHAR,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" VARCHAR,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" VARCHAR,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" VARCHAR,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" DOUBLE,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" VARCHAR,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" DOUBLE
);CREATE TABLE contracts_finder_ocds_2018_01_06 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" DOUBLE,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" DOUBLE,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
"releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);CREATE TABLE contracts_finder_ocds_2018_01_07 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_08 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_09 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_10 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" VARCHAR,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" VARCHAR,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"releases_0_tender_hasenquiries" DOUBLE,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_11 (
"https_www_contractsfinder_service_gov_uk_published_not_ec0e5d9f" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/542c491a-a8b1-44f6-a784-f7d5b8183e85.json,
"n_2018_01_11t12_46_05z" VARCHAR -- 2018-01-11T12:46:05Z,
"n_2018_01_26t00_00_00z" VARCHAR -- 2018-01-26T00:00:00Z,
"in_tend_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" 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_2bf2739f_12e8_4f88_a366_d044729c3e41" VARCHAR,
"ocds_b5fd17_2bf2739f_12e8_4f88_a366_d044729c3e41_19097_f28245dd" VARCHAR -- Ocds-b5fd17-2bf2739f-12e8-4f88-a366-d044729c3e41-190976-deaf 1217,
"en_gb" VARCHAR,
"n_2018_01_11t12_46_05z_1" TIMESTAMP -- 2018-01-11T12:46:05Z.1,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_2bf2739f_12e8_4f88_a366_d044729c3e41_deaf_1217" VARCHAR,
"provision_of_outsourced_deaf_support_services" VARCHAR,
"the_college_has_reviewed_its_arrangements_for_deaf_sup_9a7d6ed1" VARCHAR -- The College Has Reviewed Its Arrangements For Deaf Support Services And To Ensure Compliance To EU Procurement Regulations Is Now Re-tendering For An Outsourced Deaf Support Services Comprising Primarily Of Community Support Worker \CSW\" Placement With An Option For British Sign Language \"BSL\" Interpreters,
"n__as_required" VARCHAR -- As Required.",
"active" VARCHAR,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" VARCHAR -- See Description Of Related Tender.,
"cpv" DOUBLE,
"n_79540000" VARCHAR -- 79540000,
"interpretation_services" VARCHAR,
"http_cpv_data_ac_uk_code_79540000_html" DOUBLE -- Http://cpv.data.ac.uk/code-79540000.html,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" DOUBLE -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" DOUBLE -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" DOUBLE -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" DOUBLE -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" DOUBLE -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" DOUBLE -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" DOUBLE -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" DOUBLE -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" DOUBLE -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" DOUBLE -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" DOUBLE -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" DOUBLE -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" DOUBLE -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" DOUBLE -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" DOUBLE -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" DOUBLE -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" DOUBLE -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" DOUBLE -- 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" DOUBLE -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"unnamed_97" VARCHAR -- Unnamed: 97,
"unnamed_98" VARCHAR -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);CREATE TABLE contracts_finder_ocds_2018_01_12 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" VARCHAR,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" VARCHAR,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" VARCHAR,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" VARCHAR,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" TIMESTAMP,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" VARCHAR,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_13 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_14 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_15 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_16 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_17 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_18 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_19 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_20 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" VARCHAR,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" BIGINT,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_suppliers_1_id" DOUBLE,
"releases_0_awards_0_suppliers_1_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_1_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_1_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_1_identifier_uri" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_21 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_22 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_23 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2018_01_24 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" VARCHAR,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" VARCHAR,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" 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
);CREATE TABLE contracts_finder_ocds_2018_01_25 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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
);Anyone who has the link will be able to view this.