Contracts Finder Notices 12–2017
Crown Commercial Service
@ukgov.contracts_finder_notices_12_2017
Crown Commercial Service
@ukgov.contracts_finder_notices_12_2017
CREATE TABLE contracts_finder_ocds_2017_12_01 (
"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_2017_12_02 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_contractperiod_startdate" TIMESTAMP,
"releases_0_awards_0_contractperiod_enddate" TIMESTAMP
);
CREATE TABLE contracts_finder_ocds_2017_12_03 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_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
);
CREATE TABLE contracts_finder_ocds_2017_12_04 (
"https_www_contractsfinder_service_gov_uk_published_not_cd89a512" VARCHAR,
"n_2017_12_04t23_39_25z" VARCHAR,
"n_2017_12_12t00_00_00z" VARCHAR,
"bravosolution_uk_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR,
"https_www_contractsfinder_service_gov_uk" VARCHAR,
"n_1_1" VARCHAR,
"https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR,
"https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR,
"https_www_gov_uk_government_publications_open_contracting" VARCHAR,
"ocds_b5fd17_474e70c7_de30_4cf7_add8_89aafae8b925" VARCHAR,
"ocds_b5fd17_474e70c7_de30_4cf7_add8_89aafae8b925_18541_090f97a0" VARCHAR,
"en_gb" VARCHAR,
"n_2017_12_04t23_39_25z_1" TIMESTAMP,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"ocds_b5fd17_474e70c7_de30_4cf7_add8_89aafae8b925_tender_159501" VARCHAR,
"provision_of_logistic_services_for_climate_risk_insura_6eb2ce6b" VARCHAR,
"the_foreign_and_commonwealth_office_the_customer_seeks_7797ab99" VARCHAR,
"n__in_order_to_help_increase_sector_awareness_this_pro_a8dceb9d" VARCHAR,
"unsuccessful" DOUBLE,
"n_1" VARCHAR,
"see_description_of_related_tender" VARCHAR,
"cpv" DOUBLE,
"n_79400000" VARCHAR,
"business_and_management_consultancy_and_related_services" VARCHAR,
"http_cpv_data_ac_uk_code_79400000_html" DOUBLE,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" DOUBLE,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" DOUBLE,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" DOUBLE,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" DOUBLE,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" DOUBLE,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" DOUBLE,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" DOUBLE,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" DOUBLE,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" DOUBLE,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" DOUBLE,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" DOUBLE,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" DOUBLE,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" DOUBLE,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" DOUBLE,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" DOUBLE,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" DOUBLE,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" DOUBLE,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" VARCHAR,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" DOUBLE,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" VARCHAR,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" VARCHAR,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" DOUBLE,
"unnamed_96" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" VARCHAR,
"unnamed_99" VARCHAR
);
CREATE TABLE contracts_finder_ocds_2017_12_05 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" 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_2017_12_06 (
"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_2017_12_07 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);
CREATE TABLE contracts_finder_ocds_2017_12_08 (
"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" VARCHAR,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" VARCHAR,
"releases_0_tender_items_12_classification_description" VARCHAR
);
CREATE TABLE contracts_finder_ocds_2017_12_09 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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_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
);
CREATE TABLE contracts_finder_ocds_2017_12_10 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR,
"releases_0_tender_items_12_classification_uri" VARCHAR,
"releases_0_tender_items_13_id" DOUBLE
);
CREATE TABLE contracts_finder_ocds_2017_12_11 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_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
);
CREATE TABLE contracts_finder_ocds_2017_12_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" 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_2017_12_13 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);
CREATE TABLE contracts_finder_ocds_2017_12_14 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_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_2017_12_15 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);
CREATE TABLE contracts_finder_ocds_2017_12_16 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_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_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
);
CREATE TABLE contracts_finder_ocds_2017_12_17 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_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_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" DOUBLE,
"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
);
CREATE TABLE contracts_finder_ocds_2017_12_18 (
"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_2017_12_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" 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_2017_12_20 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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_2017_12_21 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" 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" 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_2017_12_22 (
"https_www_contractsfinder_service_gov_uk_published_not_a19919f5" VARCHAR,
"n_2017_12_22t13_52_57z" TIMESTAMP,
"n_2018_01_26t00_00_00z" TIMESTAMP,
"due_north_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR,
"https_www_contractsfinder_service_gov_uk" VARCHAR,
"n_1_1" DOUBLE,
"https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR,
"https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR,
"https_www_gov_uk_government_publications_open_contracting" VARCHAR,
"ocds_b5fd17_fac7eb7f_ada2_4e90_a073_06a5a0d0f214" VARCHAR,
"ocds_b5fd17_fac7eb7f_ada2_4e90_a073_06a5a0d0f214_18877_05fbff8d" VARCHAR,
"en_gb" VARCHAR,
"n_2017_12_22t13_52_57z_1" TIMESTAMP,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR,
"unnamed_18" VARCHAR,
"ocds_b5fd17_fac7eb7f_ada2_4e90_a073_06a5a0d0f214_donct_4d8141c0" VARCHAR,
"street_sweeping_gully_waste_disposal_contract" VARCHAR,
"doncaster_metropolitan_borough_council_the_council_inv_6ba00762" VARCHAR,
"n__recycling_or_recovery_and_final_disposal_of_mixed_s_08b7b320" VARCHAR,
"active" BIGINT,
"n_1" VARCHAR,
"see_description_of_related_tender" VARCHAR,
"cpv" BIGINT,
"n_90000000" VARCHAR,
"sewage_refuse_cleaning_and_environmental_services" VARCHAR,
"http_cpv_data_ac_uk_code_90000000_html" DOUBLE,
"unnamed_30" VARCHAR,
"unnamed_31" VARCHAR,
"unnamed_32" DOUBLE,
"unnamed_33" VARCHAR,
"unnamed_34" VARCHAR,
"unnamed_35" DOUBLE,
"unnamed_36" VARCHAR,
"unnamed_37" VARCHAR,
"unnamed_38" DOUBLE,
"unnamed_39" VARCHAR,
"unnamed_40" VARCHAR,
"unnamed_41" DOUBLE,
"unnamed_42" VARCHAR,
"unnamed_43" VARCHAR,
"unnamed_44" DOUBLE,
"unnamed_45" VARCHAR,
"unnamed_46" VARCHAR,
"unnamed_47" DOUBLE,
"unnamed_48" VARCHAR,
"unnamed_49" VARCHAR,
"unnamed_50" DOUBLE,
"unnamed_51" VARCHAR,
"unnamed_52" VARCHAR,
"unnamed_53" DOUBLE,
"unnamed_54" VARCHAR,
"unnamed_55" VARCHAR,
"unnamed_56" DOUBLE,
"unnamed_57" VARCHAR,
"unnamed_58" VARCHAR,
"unnamed_59" DOUBLE,
"unnamed_60" VARCHAR,
"unnamed_61" VARCHAR,
"unnamed_62" DOUBLE,
"unnamed_63" VARCHAR,
"unnamed_64" VARCHAR,
"unnamed_65" DOUBLE,
"unnamed_66" VARCHAR,
"unnamed_67" VARCHAR,
"unnamed_68" DOUBLE,
"unnamed_69" VARCHAR,
"unnamed_70" VARCHAR,
"unnamed_71" DOUBLE,
"unnamed_72" VARCHAR,
"unnamed_73" VARCHAR,
"unnamed_74" DOUBLE,
"unnamed_75" VARCHAR,
"unnamed_76" VARCHAR,
"unnamed_77" DOUBLE,
"unnamed_78" VARCHAR,
"unnamed_79" VARCHAR,
"unnamed_80" DOUBLE,
"unnamed_81" VARCHAR,
"unnamed_82" VARCHAR,
"unnamed_83" DOUBLE,
"unnamed_84" VARCHAR,
"unnamed_85" VARCHAR,
"unnamed_86" DOUBLE,
"unnamed_87" VARCHAR,
"unnamed_88" VARCHAR,
"unnamed_89" DOUBLE,
"unnamed_90" VARCHAR,
"unnamed_91" VARCHAR,
"unnamed_92" DOUBLE,
"unnamed_93" VARCHAR,
"unnamed_94" VARCHAR,
"unnamed_95" DOUBLE,
"unnamed_96" VARCHAR,
"unnamed_97" VARCHAR,
"unnamed_98" DOUBLE,
"unnamed_99" VARCHAR
);
CREATE TABLE contracts_finder_ocds_2017_12_23 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_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_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
);
CREATE TABLE contracts_finder_ocds_2017_12_24 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_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_2017_12_25 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_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,
"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
);
Anyone who has the link will be able to view this.