Contracts Finder Notices 08–2017
Crown Commercial Service
@ukgov.contracts_finder_notices_08_2017
Crown Commercial Service
@ukgov.contracts_finder_notices_08_2017
This dataset contains Contracts Finder notices for Aug 2017. The dataset uses the Open Contracting Data Standard (OCDS) flattened CSV format. Each file contains all OCDS releases for a given calendar day
Publisher name: Crown Commercial Service
Last updated: 2022-07-01T04:05:46Z
CREATE TABLE contracts_finder_ocds_2017_08_01 (
"https_www_contractsfinder_service_gov_uk_published_not_f41627db" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/fd0f4e78-fffd-42d2-ab81-900f40240bc4.json,
"n_2017_08_01t15_53_11z" TIMESTAMP -- 2017-08-01T15:53:11Z,
"n_2017_08_25t00_00_00z" TIMESTAMP -- 2017-08-25T00:00:00Z,
"due_north_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" DOUBLE -- 1.1,
"https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR -- Https://raw.githubusercontent.com/open-contracting/ocds Process Title Extension/v1.1/extension.json,
"https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR -- Https://www.nationalarchives.gov.uk/doc/open-government-licence/version/2/,
"https_www_gov_uk_government_publications_open_contracting" VARCHAR -- Https://www.gov.uk/government/publications/open-contracting,
"ocds_b5fd17_6bd3def4_58fa_46aa_8a85_7c4f3e38f35f" VARCHAR,
"ocds_b5fd17_6bd3def4_58fa_46aa_8a85_7c4f3e38f35f_16329_1437f76e" VARCHAR -- Ocds-b5fd17-6bd3def4-58fa-46aa-8a85-7c4f3e38f35f-163294-sthel001-dn289716-23942175,
"en_gb" VARCHAR,
"n_2017_08_01t15_53_11z_1" TIMESTAMP -- 2017-08-01T15:53:11Z.1,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_6bd3def4_58fa_46aa_8a85_7c4f3e38f35f_sthel_e76ffa7c" VARCHAR -- Ocds-b5fd17-6bd3def4-58fa-46aa-8a85-7c4f3e38f35f-sthel001-dn289716-23942175,
"ice_cream_concessions_for_st_helens_parks" VARCHAR -- Ice Cream Concessions For St. Helens Parks,
"st_helens_council_the_council_is_seeking_to_procure_an_1aeedb3a" VARCHAR -- St Helens Council (\the Council\") Is Seeking To Procure An Ice Cream Concession In Ten Differing Sites Across The Borough Of St. Helens. Due To Potential Changing Commercial Activities With The Parks,
"n__the_period_of_contract_for_this_provision_shall_be__4847cea6" VARCHAR -- The Period Of Contract For This Provision Shall Be For 12 Months,
"n__starting_on_the_1st_january_2018_running_until_31st_6a7a3d1c" BIGINT -- Starting On The 1st January 2018 Running Until 31st December 2018. ALL COMMUNICATION HAS TO GO THROUGH THE CHEST Https://www.the-chest.org.uk/",
"unsuccessful" VARCHAR,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" BIGINT -- See Description Of Related Tender.,
"cpv" VARCHAR,
"n_15500000" VARCHAR -- 15500000,
"dairy_products" DOUBLE,
"http_cpv_data_ac_uk_code_15500000_html" VARCHAR -- Http://cpv.data.ac.uk/code-15500000.html,
"n_2" VARCHAR -- 2,
"see_description_of_related_tender_1" DOUBLE -- See Description Of Related Tender..1,
"cpv_1" VARCHAR,
"n_55300000" VARCHAR -- 55300000,
"restaurant_and_food_serving_services" DOUBLE,
"http_cpv_data_ac_uk_code_55300000_html" VARCHAR -- Http://cpv.data.ac.uk/code-55300000.html,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" DOUBLE -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" DOUBLE -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" DOUBLE -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" DOUBLE -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" DOUBLE -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" DOUBLE -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" DOUBLE -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" DOUBLE -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" DOUBLE -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" DOUBLE -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" DOUBLE -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" DOUBLE -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" DOUBLE -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" DOUBLE -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" DOUBLE -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" DOUBLE -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" DOUBLE -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" DOUBLE -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" DOUBLE -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" DOUBLE -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"n_40000" BIGINT -- 40000,
"gbp" VARCHAR,
"n_40000_1" VARCHAR -- 40000.1
);CREATE TABLE contracts_finder_ocds_2017_08_02 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" 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_08_03 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" VARCHAR,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" 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" VARCHAR,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_04 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" 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_08_05 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" BIGINT,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_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_08_06 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_07 (
"https_www_contractsfinder_service_gov_uk_published_not_cfe18cc3" VARCHAR -- Https://www.contractsfinder.service.gov.uk/Published/Notice/releases/e1c25bea-b7b0-460f-84b6-08ddb52d261b.json,
"n_2017_08_07t14_07_44z" TIMESTAMP -- 2017-08-07T14:07:44Z,
"n_2017_09_15t00_00_00z" TIMESTAMP -- 2017-09-15T00:00:00Z,
"in_tend_limited" VARCHAR,
"gb_govuk_crown_comercial_service" VARCHAR,
"unnamed_5" VARCHAR -- Unnamed: 5,
"https_www_contractsfinder_service_gov_uk" VARCHAR -- Https://www.contractsfinder.service.gov.uk,
"n_1_1" DOUBLE -- 1.1,
"https_raw_githubusercontent_com_open_contracting_ocds__48bfa065" VARCHAR -- Https://raw.githubusercontent.com/open-contracting/ocds Process Title Extension/v1.1/extension.json,
"https_www_nationalarchives_gov_uk_doc_open_government__34bf12f5" VARCHAR -- Https://www.nationalarchives.gov.uk/doc/open-government-licence/version/2/,
"https_www_gov_uk_government_publications_open_contracting" VARCHAR -- Https://www.gov.uk/government/publications/open-contracting,
"ocds_b5fd17_e1d4f509_db88_46c1_b931_59d2bdecd0df" VARCHAR,
"ocds_b5fd17_e1d4f509_db88_46c1_b931_59d2bdecd0df_16418_f41210c2" VARCHAR -- Ocds-b5fd17-e1d4f509-db88-46c1-b931-59d2bdecd0df-164181-bhcc---015699,
"en_gb" VARCHAR,
"n_2017_08_07t14_07_44z_1" TIMESTAMP -- 2017-08-07T14:07:44Z.1,
"tenderamendment" VARCHAR,
"tender" VARCHAR,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"ocds_b5fd17_e1d4f509_db88_46c1_b931_59d2bdecd0df_bhcc_015699" VARCHAR -- Ocds-b5fd17-e1d4f509-db88-46c1-b931-59d2bdecd0df-bhcc---015699,
"bhcc_dr_build_a_bike_course" VARCHAR,
"brighton_hove_city_council_would_like_to_invite_organi_b2d48cd5" VARCHAR -- Brighton & Hove City Council Would Like To Invite Organisations To Submit A Bid For The Delivery Of The \Build A Bike\" Course (BaB). The Successful Provider Is To Identify And Work With Individuals To Learn Bicycle Mechanic Skills To Build Their Own Bike,
"n__and_to_cycle_confidently_on_the_road_there_are_two__1981885d" VARCHAR -- And To Cycle Confidently On The Road. There Are Two Elements That Make Up The BaB Course. A) Build A Bike Course; And B) Level 1,
"n__2_and_3_bikeability_cycle_training" BIGINT -- 2 And 3 Bikeability Cycle Training.",
"unsuccessful" VARCHAR,
"n_1" VARCHAR -- 1,
"see_description_of_related_tender" BIGINT -- See Description Of Related Tender.,
"cpv" VARCHAR,
"n_34430000" VARCHAR -- 34430000,
"bicycles" DOUBLE,
"http_cpv_data_ac_uk_code_34430000_html" VARCHAR -- Http://cpv.data.ac.uk/code-34430000.html,
"n_2" VARCHAR -- 2,
"see_description_of_related_tender_1" DOUBLE -- See Description Of Related Tender..1,
"cpv_1" VARCHAR,
"n_34432000" VARCHAR -- 34432000,
"parts_and_accessories_for_bicycles" DOUBLE,
"http_cpv_data_ac_uk_code_34432000_html" VARCHAR -- Http://cpv.data.ac.uk/code-34432000.html,
"n_3" VARCHAR -- 3,
"see_description_of_related_tender_2" DOUBLE -- See Description Of Related Tender..2,
"cpv_2" VARCHAR,
"n_34431000" VARCHAR -- 34431000,
"non_motorised_bicycles" DOUBLE,
"http_cpv_data_ac_uk_code_34431000_html" VARCHAR -- Http://cpv.data.ac.uk/code-34431000.html,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" DOUBLE -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"unnamed_51" VARCHAR -- Unnamed: 51,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"unnamed_94" VARCHAR -- Unnamed: 94,
"unnamed_95" VARCHAR -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"unnamed_97" VARCHAR -- Unnamed: 97,
"unnamed_98" VARCHAR -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);CREATE TABLE contracts_finder_ocds_2017_08_08 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_09 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" VARCHAR,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" VARCHAR,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" VARCHAR,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" VARCHAR,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" VARCHAR,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" VARCHAR,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" VARCHAR,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" 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_08_10 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" 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_08_11 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_12 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" DOUBLE,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_0_sme" VARCHAR,
"releases_0_awards_0_suppliers_0_vco" VARCHAR,
"releases_0_awards_0_suppliers_0_name" VARCHAR,
"releases_0_awards_0_suppliers_0_address_streetaddress" VARCHAR,
"releases_0_awards_0_suppliers_0_address_locality" VARCHAR,
"releases_0_awards_0_suppliers_0_address_region" VARCHAR,
"releases_0_awards_0_suppliers_0_address_postalcode" VARCHAR,
"releases_0_awards_0_suppliers_0_address_countryname" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_name" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_email" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_telephone" VARCHAR,
"releases_0_awards_0_suppliers_0_contactpoint_faxnumber" VARCHAR,
"releases_0_awards_0_suppliers_1_id" DOUBLE,
"releases_0_awards_0_suppliers_1_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_1_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_1_identifier_legalname" VARCHAR,
"releases_0_awards_0_suppliers_1_identifier_uri" VARCHAR,
"releases_0_awards_0_suppliers_1_sme" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_13 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_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_08_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_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_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_08_16 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" 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_08_17 (
"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" VARCHAR,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" DOUBLE,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_tenderperiod_startdate" VARCHAR,
"releases_0_tender_hasenquiries" DOUBLE,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" VARCHAR,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" VARCHAR,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_18 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" VARCHAR,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_19 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" BIGINT,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" BIGINT,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" BIGINT,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" VARCHAR,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" BIGINT,
"releases_0_buyer_address_streetaddress" VARCHAR,
"releases_0_buyer_address_locality" VARCHAR,
"releases_0_buyer_address_region" VARCHAR,
"releases_0_buyer_address_postalcode" VARCHAR,
"releases_0_buyer_address_countryname" VARCHAR,
"releases_0_buyer_contactpoint_name" VARCHAR,
"releases_0_buyer_contactpoint_email" VARCHAR,
"releases_0_buyer_contactpoint_telephone" VARCHAR,
"releases_0_buyer_contactpoint_faxnumber" VARCHAR,
"releases_0_buyer_contactpoint_uri" VARCHAR,
"releases_0_awards_0_id" VARCHAR,
"releases_0_awards_0_title" VARCHAR,
"releases_0_awards_0_description" VARCHAR,
"releases_0_awards_0_status" VARCHAR,
"releases_0_awards_0_date" TIMESTAMP,
"releases_0_awards_0_value_amount" DOUBLE,
"releases_0_awards_0_value_currency" VARCHAR,
"releases_0_awards_0_suppliers_0_id" DOUBLE,
"releases_0_awards_0_suppliers_0_identifier_scheme" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_id" VARCHAR,
"releases_0_awards_0_suppliers_0_identifier_legalname" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_20 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_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_08_21 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" VARCHAR,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" VARCHAR,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" 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" VARCHAR,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_22 (
"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" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" DOUBLE,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" DOUBLE,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" DOUBLE,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_items_10_id" DOUBLE,
"releases_0_tender_items_10_description" VARCHAR,
"releases_0_tender_items_10_classification_scheme" VARCHAR,
"releases_0_tender_items_10_classification_id" DOUBLE,
"releases_0_tender_items_10_classification_description" VARCHAR,
"releases_0_tender_items_10_classification_uri" VARCHAR,
"releases_0_tender_items_11_id" DOUBLE,
"releases_0_tender_items_11_description" VARCHAR,
"releases_0_tender_items_11_classification_scheme" VARCHAR,
"releases_0_tender_items_11_classification_id" DOUBLE,
"releases_0_tender_items_11_classification_description" VARCHAR,
"releases_0_tender_items_11_classification_uri" VARCHAR,
"releases_0_tender_items_12_id" DOUBLE,
"releases_0_tender_items_12_description" VARCHAR,
"releases_0_tender_items_12_classification_scheme" VARCHAR,
"releases_0_tender_items_12_classification_id" DOUBLE,
"releases_0_tender_items_12_classification_description" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_23 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" VARCHAR,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" VARCHAR,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" VARCHAR,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" VARCHAR,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" VARCHAR,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" VARCHAR,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" VARCHAR,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" VARCHAR,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" VARCHAR,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" VARCHAR,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_items_8_id" VARCHAR,
"releases_0_tender_items_8_description" VARCHAR,
"releases_0_tender_items_8_classification_scheme" VARCHAR,
"releases_0_tender_items_8_classification_id" VARCHAR,
"releases_0_tender_items_8_classification_description" VARCHAR,
"releases_0_tender_items_8_classification_uri" VARCHAR,
"releases_0_tender_items_9_id" DOUBLE,
"releases_0_tender_items_9_description" VARCHAR,
"releases_0_tender_items_9_classification_scheme" VARCHAR,
"releases_0_tender_items_9_classification_id" VARCHAR,
"releases_0_tender_items_9_classification_description" VARCHAR,
"releases_0_tender_items_9_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_24 (
"uri" VARCHAR,
"publisheddate" TIMESTAMP,
"deadlinedate" TIMESTAMP,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" VARCHAR,
"publisher_uri" VARCHAR,
"version" DOUBLE,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" BIGINT,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" BIGINT,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" DOUBLE,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" DOUBLE,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" DOUBLE,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_items_7_id" DOUBLE,
"releases_0_tender_items_7_description" VARCHAR,
"releases_0_tender_items_7_classification_scheme" VARCHAR,
"releases_0_tender_items_7_classification_id" DOUBLE,
"releases_0_tender_items_7_classification_description" VARCHAR,
"releases_0_tender_items_7_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" DOUBLE,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" BIGINT,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" VARCHAR,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_enddate" TIMESTAMP,
"releases_0_tender_hasenquiries" VARCHAR,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" DOUBLE,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" TIMESTAMP,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" DOUBLE,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" TIMESTAMP,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" DOUBLE,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" VARCHAR,
"releases_0_buyer_identifier_scheme" VARCHAR
);CREATE TABLE contracts_finder_ocds_2017_08_25 (
"uri" VARCHAR,
"publisheddate" VARCHAR,
"deadlinedate" VARCHAR,
"publisher_name" VARCHAR,
"publisher_scheme" VARCHAR,
"publisher_uid" DOUBLE,
"publisher_uri" VARCHAR,
"version" VARCHAR,
"extensions_0" VARCHAR,
"license" VARCHAR,
"publicationpolicy" VARCHAR,
"releases_0_ocid" VARCHAR,
"releases_0_id" VARCHAR,
"releases_0_language" VARCHAR,
"releases_0_date" TIMESTAMP,
"releases_0_tag_0" VARCHAR,
"releases_0_initiationtype" VARCHAR,
"releases_0_title" VARCHAR,
"releases_0_description" VARCHAR,
"releases_0_tender_id" VARCHAR,
"releases_0_tender_title" VARCHAR,
"releases_0_tender_description" VARCHAR,
"releases_0_tender_status" VARCHAR,
"releases_0_tender_items_0_id" DOUBLE,
"releases_0_tender_items_0_description" VARCHAR,
"releases_0_tender_items_0_classification_scheme" VARCHAR,
"releases_0_tender_items_0_classification_id" DOUBLE,
"releases_0_tender_items_0_classification_description" VARCHAR,
"releases_0_tender_items_0_classification_uri" VARCHAR,
"releases_0_tender_items_1_id" DOUBLE,
"releases_0_tender_items_1_description" VARCHAR,
"releases_0_tender_items_1_classification_scheme" VARCHAR,
"releases_0_tender_items_1_classification_id" DOUBLE,
"releases_0_tender_items_1_classification_description" VARCHAR,
"releases_0_tender_items_1_classification_uri" VARCHAR,
"releases_0_tender_items_2_id" DOUBLE,
"releases_0_tender_items_2_description" VARCHAR,
"releases_0_tender_items_2_classification_scheme" VARCHAR,
"releases_0_tender_items_2_classification_id" DOUBLE,
"releases_0_tender_items_2_classification_description" VARCHAR,
"releases_0_tender_items_2_classification_uri" VARCHAR,
"releases_0_tender_items_3_id" DOUBLE,
"releases_0_tender_items_3_description" VARCHAR,
"releases_0_tender_items_3_classification_scheme" VARCHAR,
"releases_0_tender_items_3_classification_id" DOUBLE,
"releases_0_tender_items_3_classification_description" VARCHAR,
"releases_0_tender_items_3_classification_uri" VARCHAR,
"releases_0_tender_items_4_id" VARCHAR,
"releases_0_tender_items_4_description" VARCHAR,
"releases_0_tender_items_4_classification_scheme" VARCHAR,
"releases_0_tender_items_4_classification_id" DOUBLE,
"releases_0_tender_items_4_classification_description" VARCHAR,
"releases_0_tender_items_4_classification_uri" VARCHAR,
"releases_0_tender_items_5_id" DOUBLE,
"releases_0_tender_items_5_description" VARCHAR,
"releases_0_tender_items_5_classification_scheme" VARCHAR,
"releases_0_tender_items_5_classification_id" VARCHAR,
"releases_0_tender_items_5_classification_description" VARCHAR,
"releases_0_tender_items_5_classification_uri" VARCHAR,
"releases_0_tender_items_6_id" DOUBLE,
"releases_0_tender_items_6_description" VARCHAR,
"releases_0_tender_items_6_classification_scheme" VARCHAR,
"releases_0_tender_items_6_classification_id" VARCHAR,
"releases_0_tender_items_6_classification_description" VARCHAR,
"releases_0_tender_items_6_classification_uri" VARCHAR,
"releases_0_tender_minvalue_amount" VARCHAR,
"releases_0_tender_minvalue_currency" VARCHAR,
"releases_0_tender_value_amount" VARCHAR,
"releases_0_tender_value_currency" VARCHAR,
"releases_0_tender_procurementmethod" DOUBLE,
"releases_0_tender_procurementmethoddetails" VARCHAR,
"releases_0_tender_procurementmethodrationale" VARCHAR,
"releases_0_tender_awardcriteria" VARCHAR,
"releases_0_tender_awardcriteriadetails" VARCHAR,
"releases_0_tender_submissionmethod" VARCHAR,
"releases_0_tender_submissionmethoddetails" VARCHAR,
"releases_0_tender_tenderperiod_startdate" TIMESTAMP,
"releases_0_tender_tenderperiod_enddate" VARCHAR,
"releases_0_tender_hasenquiries" DOUBLE,
"releases_0_tender_eligibilitycriteria" VARCHAR,
"releases_0_tender_milestones_0_id" VARCHAR,
"releases_0_tender_milestones_0_title" VARCHAR,
"releases_0_tender_milestones_0_description" VARCHAR,
"releases_0_tender_milestones_0_duedate" VARCHAR,
"releases_0_tender_milestones_0_status" VARCHAR,
"releases_0_tender_milestones_1_id" VARCHAR,
"releases_0_tender_milestones_1_title" VARCHAR,
"releases_0_tender_milestones_1_description" VARCHAR,
"releases_0_tender_milestones_1_duedate" VARCHAR,
"releases_0_tender_milestones_1_status" VARCHAR,
"releases_0_tender_xclassifications_issuitableforvco" DOUBLE,
"releases_0_tender_xclassifications_issuitableforsme" VARCHAR,
"releases_0_tender_xclassifications_ojeucontracttype" VARCHAR,
"releases_0_tender_supplychain" TIMESTAMP,
"releases_0_buyer_identifier_scheme" VARCHAR,
"releases_0_buyer_identifier_id" VARCHAR,
"releases_0_buyer_identifier_legalname" DOUBLE,
"releases_0_buyer_identifier_uri" VARCHAR,
"releases_0_buyer_name" VARCHAR,
"releases_0_buyer_id" DOUBLE
);Anyone who has the link will be able to view this.