Survey Data: Mapping Of Transnational Collaborative Partnerships

CREATE TABLE mapping_of_transnational_collaborative_partnerships (
  "n_1_1_what_is_the_name_of_your_collaborative_partnership" VARCHAR,
  "n_1_2_in_which_year_was_the_collaborative_partnership__e47d21a9" BIGINT,
  "if_the_collaborative_partnership_has_ended_please_specify_when" VARCHAR,
  "n_1_3_how_many_institutions_are_involved_in_your_colla_d1b6334b" BIGINT,
  "n_1_4_please_indicate_where_the_members_of_your_collab_63ef13d3" VARCHAR,
  "n_1_5_what_types_of_organisations_institutions_constit_021942a8" VARCHAR,
  "please_specify" VARCHAR,
  "n_1_6_what_are_the_main_sources_of_funding_for_your_co_29e9cf2e" VARCHAR,
  "please_elaborate_if_needed_in_case_of_a_combination_of_6fd79c6a" VARCHAR,
  "n_1_7_what_proportion_of_the_following_groups_benefit__f4ba4b52" VARCHAR,
  "n_1_7_what_proportion_of_the_following_groups_benefit__3b68d64e" VARCHAR,
  "n_1_7_what_proportion_of_the_following_groups_benefit__4c45cef6" VARCHAR,
  "n_1_7_what_proportion_of_the_following_groups_benefit__0d8ea9ad" VARCHAR,
  "n_1_7_what_proportion_of_the_following_groups_benefit__7d56b56f" VARCHAR,
  "n_1_8_what_mobility_schemes_are_currently_established__b6b275d3" VARCHAR,
  "n_1_8_what_mobility_schemes_are_currently_established__8a8eef6c" VARCHAR,
  "n_1_8_what_mobility_schemes_are_currently_established__1578d497" VARCHAR,
  "n_1_8_what_mobility_schemes_are_currently_established__69e26209" VARCHAR,
  "n_1_8_what_mobility_schemes_are_currently_established__05931ca0" VARCHAR,
  "in_case_you_selected_the_option_other_please_indicate__9c6aa8c8" VARCHAR,
  "n_1_9_is_your_collaboration_based_on_multiple_options__2aff2d97" VARCHAR,
  "please_specify_broad_field_using_the_iscedf13_definiti_a20c345f" VARCHAR,
  "please_specify_8d2c17" VARCHAR,
  "n_1_10_does_your_collaboration_involve" VARCHAR,
  "please_specify_1" VARCHAR,
  "n_1_11_what_are_the_formal_criteria_for_membership_in__d9c50864" VARCHAR,
  "n_1_12_does_the_collaborative_partnership_have_a_legal_a2d92801" VARCHAR,
  "please_specify_1_756c8a" VARCHAR,
  "n_1_13_please_indicate_what_governance_model_best_desc_378f79a9" VARCHAR,
  "please_specify_2" VARCHAR,
  "n_1_14_which_common_administrative_structures_does_you_29a8878a" VARCHAR,
  "please_specify_2_29bffb" VARCHAR,
  "n_1_15_within_the_context_of_your_transnational_collab_8b2c88d1" VARCHAR,
  "n_1_16_for_each_mission_please_indicate_what_is_the_ma_ce025070" VARCHAR,
  "n_1_16_for_each_mission_please_indicate_what_is_the_ma_80c0640f" VARCHAR,
  "n_1_16_for_each_mission_please_indicate_what_is_the_ma_bccdb79e" VARCHAR,
  "n_2_1_what_kind_of_educational_collaboration_do_the_pa_99de2530" VARCHAR,
  "n_2_1_what_kind_of_educational_collaboration_do_the_pa_35aefd23" VARCHAR,
  "n_2_1_what_kind_of_educational_collaboration_do_the_pa_8227b0ff" VARCHAR,
  "in_case_you_indicated_other_forms_please_describe_name_f31a59e9" VARCHAR,
  "n_2_2_what_proportion_of_students_staff_benefit_from_e_f22d5804" VARCHAR,
  "n_2_2_what_proportion_of_students_staff_benefit_from_e_7072e313" VARCHAR,
  "n_2_2_what_proportion_of_students_staff_benefit_from_e_35c1b6a8" VARCHAR,
  "n_2_3_how_would_you_rate_the_intensity_of_collaboratio_7ff2fb75" VARCHAR,
  "n_2_3_how_would_you_rate_the_intensity_of_collaboratio_b2dc806a" VARCHAR,
  "n_2_3_how_would_you_rate_the_intensity_of_collaboratio_698484d7" VARCHAR,
  "n_2_4_does_your_collaborative_partnership_support_stud_c00ae16b" VARCHAR,
  "n_2_5_if_your_collaborative_partnership_supports_other_138059ce" VARCHAR,
  "n_3_1_when_collaborating_in_research_do_partners_engag_6cf20d15" VARCHAR,
  "in_case_you_have_selected_other_please_elaborate" VARCHAR,
  "n_3_2_what_proportion_of_researchers_staff_benefit_fro_d45a6ecf" VARCHAR,
  "n_3_2_what_proportion_of_researchers_staff_benefit_fro_1c01c693" VARCHAR,
  "n_3_2_what_proportion_of_researchers_staff_benefit_fro_5727bb70" VARCHAR,
  "n_4_1_when_collaborating_in_third_mission_innovation_a_a7d1d225" VARCHAR,
  "other_please_describe" VARCHAR,
  "n_4_2_what_proportion_of_students_staff_researchers_be_beb7ed5d" VARCHAR,
  "n_4_2_what_proportion_of_students_staff_researchers_be_92f7375c" VARCHAR,
  "n_4_2_what_proportion_of_students_staff_researchers_be_24144d18" VARCHAR,
  "n_4_2_what_proportion_of_students_staff_researchers_be_8b9d2558" VARCHAR,
  "n_5_1_1_general_drivers_geographical_proximity" VARCHAR,
  "n_5_1_1_general_drivers_strong_leadership_with_common_vision" VARCHAR,
  "n_5_1_1_general_drivers_bottom_up_approach" VARCHAR,
  "n_5_1_1_general_drivers_good_balance_between_top_down__80943515" VARCHAR,
  "n_5_1_1_general_drivers_common_similar_topics_and_interests" VARCHAR,
  "n_5_1_1_general_drivers_existing_contacts_between_staff_members" VARCHAR,
  "n_5_1_1_general_drivers_previously_established_collabo_f8c756c3" VARCHAR,
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_19a46ca9" VARCHAR,
  "n_5_1_2_mobility_mobility_of_students" VARCHAR,
  "n_5_1_2_mobility_mobility_of_researchers" VARCHAR,
  "n_5_1_2_mobility_mobility_of_teaching_staff" VARCHAR,
  "n_5_1_2_mobility_mobility_of_administrative_and_other__99fe36d2" VARCHAR,
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_37848689" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_devel_d9003d02" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_enhan_188f4754" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_nurtu_2613a634" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_incre_e27b038c" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_devel_851da79a" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_incre_07a7cccc" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_promo_64978ae7" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_promo_bc3a1a0a" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_devel_c01bbc6d" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_enhan_d53878ea" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_promo_19f8c46b" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_incre_ec69f56a" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_incre_f2941d99" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_incre_a0a69b27" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_achie_677b19da" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_promo_92cf208e" VARCHAR,
  "n_5_1_3_education_teaching_and_capacity_building_promo_85ae4957" VARCHAR,
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_5cb23825" VARCHAR,
  "n_5_1_4_research_and_capacity_building_developing_comm_f0da760d" VARCHAR,
  "n_5_1_4_research_and_capacity_building_developing_rese_4e87c7bd" VARCHAR,
  "n_5_1_4_research_and_capacity_building_enhancing_resea_1bb189bc" VARCHAR,
  "n_5_1_4_research_and_capacity_building_promoting_scien_af14d96f" VARCHAR,
  "n_5_1_4_research_and_capacity_building_strengthening_c_fffeafee" VARCHAR,
  "n_5_1_4_research_and_capacity_building_achieving_criti_205cafa2" VARCHAR,
  "n_5_1_4_research_and_capacity_building_promoting_attra_adc479a7" VARCHAR,
  "n_5_1_4_research_and_capacity_building_accessing_forei_f134bd0d" VARCHAR,
  "n_5_1_4_research_and_capacity_building_promoting_colla_d283e847" VARCHAR,
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_4538e819" VARCHAR
);