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  -- 1.1. What Is The Name Of Your Collaborative Partnership?,
  "n_1_2_in_which_year_was_the_collaborative_partnership__e47d21a9" BIGINT  -- 1.2. In Which Year Was The Collaborative Partnership Established?,
  "if_the_collaborative_partnership_has_ended_please_specify_when" VARCHAR  -- If The Collaborative Partnership Has Ended, Please Specify When,
  "n_1_3_how_many_institutions_are_involved_in_your_colla_d1b6334b" BIGINT  -- 1.3. How Many Institutions Are Involved In Your Collaborative Partnership?,
  "n_1_4_please_indicate_where_the_members_of_your_collab_63ef13d3" VARCHAR  -- 1.4. Please, Indicate Where The Members Of Your Collaborative Partnership Are Based Or Located. (multiple Options Are Possible),
  "n_1_5_what_types_of_organisations_institutions_constit_021942a8" VARCHAR  -- 1.5. What Types Of Organisations/institutions Constitute Your Collaborative Partnership? (multiple Options Are Possible),
  "please_specify" VARCHAR  -- Please, Specify,
  "n_1_6_what_are_the_main_sources_of_funding_for_your_co_29e9cf2e" VARCHAR  -- 1.6. What Are The Main Sources Of Funding For Your Collaborative Partnership? (multiple Options Are Possible),
  "please_elaborate_if_needed_in_case_of_a_combination_of_6fd79c6a" VARCHAR  -- Please, Elaborate If Needed. In Case Of A Combination Of Funding Could You Please Describe How These Sources Of Funding Interact. Please Specify Whether These Multiple Sources Of Funds Occurred At The Same Time Or At Different Stages In The Lifetime Of The Collaborative Partnership,
  "n_1_7_what_proportion_of_the_following_groups_benefit__f4ba4b52" VARCHAR  -- 1.7. What Proportion Of The Following Groups Benefit From Direct Participation In Educational, Research Or Innovation Activities Of The Partnership?: Students,
  "n_1_7_what_proportion_of_the_following_groups_benefit__3b68d64e" VARCHAR  -- 1.7. What Proportion Of The Following Groups Benefit From Direct Participation In Educational, Research Or Innovation Activities Of The Partnership?: Researchers,
  "n_1_7_what_proportion_of_the_following_groups_benefit__4c45cef6" VARCHAR  -- 1.7. What Proportion Of The Following Groups Benefit From Direct Participation In Educational, Research Or Innovation Activities Of The Partnership?: Teaching Staff,
  "n_1_7_what_proportion_of_the_following_groups_benefit__0d8ea9ad" VARCHAR  -- 1.7. What Proportion Of The Following Groups Benefit From Direct Participation In Educational, Research Or Innovation Activities Of The Partnership?: Administrative And Support Staff,
  "n_1_7_what_proportion_of_the_following_groups_benefit__7d56b56f" VARCHAR  -- 1.7. What Proportion Of The Following Groups Benefit From Direct Participation In Educational, Research Or Innovation Activities Of The Partnership?: University Leadership,
  "n_1_8_what_mobility_schemes_are_currently_established__b6b275d3" VARCHAR  -- 1.8. What Mobility Schemes Are Currently Established Within The Framework Of The Collaborative Partnership? (multiple Options Are Possible): Bachelor Students (including Short-cycle Students),
  "n_1_8_what_mobility_schemes_are_currently_established__8a8eef6c" VARCHAR  -- 1.8. What Mobility Schemes Are Currently Established Within The Framework Of The Collaborative Partnership? (multiple Options Are Possible): Master Students,
  "n_1_8_what_mobility_schemes_are_currently_established__1578d497" VARCHAR  -- 1.8. What Mobility Schemes Are Currently Established Within The Framework Of The Collaborative Partnership? (multiple Options Are Possible): Doctoral Candidates,
  "n_1_8_what_mobility_schemes_are_currently_established__69e26209" VARCHAR  -- 1.8. What Mobility Schemes Are Currently Established Within The Framework Of The Collaborative Partnership? (multiple Options Are Possible): Teaching Staff,
  "n_1_8_what_mobility_schemes_are_currently_established__05931ca0" VARCHAR  -- 1.8. What Mobility Schemes Are Currently Established Within The Framework Of The Collaborative Partnership? (multiple Options Are Possible): Researchers,
  "in_case_you_selected_the_option_other_please_indicate__9c6aa8c8" VARCHAR  -- In Case You Selected The Option "other" Please Indicate The Types Of Mobility Schemes That Have Been Established.,
  "n_1_9_is_your_collaboration_based_on_multiple_options__2aff2d97" VARCHAR  -- 1.9. Is Your Collaboration Based On (multiple Options Are Possible),
  "please_specify_broad_field_using_the_iscedf13_definiti_a20c345f" VARCHAR  -- Please, Specify Broad Field Using The ISCEDF13 Definition. (multiple Choices Are Possible),
  "please_specify_8d2c17" VARCHAR  -- Please Specify,
  "n_1_10_does_your_collaboration_involve" VARCHAR  -- 1.10. Does Your Collaboration Involve,
  "please_specify_1" VARCHAR,
  "n_1_11_what_are_the_formal_criteria_for_membership_in__d9c50864" VARCHAR  -- 1.11. What Are The Formal Criteria For Membership In Your Collaborative Partnership (e.g. Co-funding, Joint Activities, Etc.)?,
  "n_1_12_does_the_collaborative_partnership_have_a_legal_a2d92801" VARCHAR  -- 1.12. Does The Collaborative Partnership Have A Legal Base (partnership/consortium Agreement, Memorandum Of Understanding Or Other Forms Of Arrangement, Regulating The Responsibilities, Obligations And Rights Of The Partners Between Them And/or With Regard To Third Parties)?,
  "please_specify_1_756c8a" VARCHAR  -- Please, Specify.1,
  "n_1_13_please_indicate_what_governance_model_best_desc_378f79a9" VARCHAR  -- 1.13. Please Indicate What Governance Model Best Describes Your Collaborative Partnership.,
  "please_specify_2" VARCHAR,
  "n_1_14_which_common_administrative_structures_does_you_29a8878a" VARCHAR  -- 1.14. Which Common Administrative Structures Does Your Collaborative Partnership Maintain? (multiple Options Are Possible),
  "please_specify_2_29bffb" VARCHAR  -- Please, Specify.2,
  "n_1_15_within_the_context_of_your_transnational_collab_8b2c88d1" VARCHAR  -- 1.15. Within The Context Of Your Transnational Collaboration, In Which Of The Following Missions Does Cooperation Occur? (multiple Options Are Possible),
  "n_1_16_for_each_mission_please_indicate_what_is_the_ma_ce025070" VARCHAR  -- 1.16. For Each Mission, Please Indicate What Is The Main Level Of Cooperation In Your Collaborative Partnership. (multiple Options Are Possible): Education,
  "n_1_16_for_each_mission_please_indicate_what_is_the_ma_80c0640f" VARCHAR  -- 1.16. For Each Mission, Please Indicate What Is The Main Level Of Cooperation In Your Collaborative Partnership. (multiple Options Are Possible): Research,
  "n_1_16_for_each_mission_please_indicate_what_is_the_ma_bccdb79e" VARCHAR  -- 1.16. For Each Mission, Please Indicate What Is The Main Level Of Cooperation In Your Collaborative Partnership. (multiple Options Are Possible): Third Mission / Innovation,
  "n_2_1_what_kind_of_educational_collaboration_do_the_pa_99de2530" VARCHAR  -- 2.1 What Kind Of Educational Collaboration Do The Partners Engage In: (multiple Options Are Possible): Bachelor (including Short-cycle Studies),
  "n_2_1_what_kind_of_educational_collaboration_do_the_pa_35aefd23" VARCHAR  -- 2.1 What Kind Of Educational Collaboration Do The Partners Engage In: (multiple Options Are Possible): Master,
  "n_2_1_what_kind_of_educational_collaboration_do_the_pa_8227b0ff" VARCHAR  -- 2.1 What Kind Of Educational Collaboration Do The Partners Engage In: (multiple Options Are Possible): Doctoral,
  "in_case_you_indicated_other_forms_please_describe_name_f31a59e9" VARCHAR  -- In Case You Indicated "other Forms", Please Describe/name Them Here,
  "n_2_2_what_proportion_of_students_staff_benefit_from_e_f22d5804" VARCHAR  -- 2.2. What Proportion Of Students / Staff Benefit From Educational Collaboration Within The Partnership?: Students,
  "n_2_2_what_proportion_of_students_staff_benefit_from_e_7072e313" VARCHAR  -- 2.2. What Proportion Of Students / Staff Benefit From Educational Collaboration Within The Partnership?: Teaching Staff,
  "n_2_2_what_proportion_of_students_staff_benefit_from_e_35c1b6a8" VARCHAR  -- 2.2. What Proportion Of Students / Staff Benefit From Educational Collaboration Within The Partnership?: Administrative And Support Staff,
  "n_2_3_how_would_you_rate_the_intensity_of_collaboratio_7ff2fb75" VARCHAR  -- 2.3 How Would You Rate The Intensity Of Collaboration According To The Scale Below?: Bachelor (including Short-cycle Studies),
  "n_2_3_how_would_you_rate_the_intensity_of_collaboratio_b2dc806a" VARCHAR  -- 2.3 How Would You Rate The Intensity Of Collaboration According To The Scale Below?: Master,
  "n_2_3_how_would_you_rate_the_intensity_of_collaboratio_698484d7" VARCHAR  -- 2.3 How Would You Rate The Intensity Of Collaboration According To The Scale Below?: Doctoral,
  "n_2_4_does_your_collaborative_partnership_support_stud_c00ae16b" VARCHAR  -- 2.4 Does Your Collaborative Partnership Support Student And Staff Mobility Schemes Funded Through Erasmus+?,
  "n_2_5_if_your_collaborative_partnership_supports_other_138059ce" VARCHAR  -- 2.5 If Your Collaborative Partnership Supports Other Mobility Schemes, Please Specify,
  "n_3_1_when_collaborating_in_research_do_partners_engag_6cf20d15" VARCHAR  -- 3.1 When Collaborating In Research, Do Partners Engage In (multiple Options Are Possible),
  "in_case_you_have_selected_other_please_elaborate" VARCHAR  -- In Case You Have Selected "other", Please Elaborate,
  "n_3_2_what_proportion_of_researchers_staff_benefit_fro_d45a6ecf" VARCHAR  -- 3.2. What Proportion Of Researchers / Staff Benefit From Research Collaboration Within The Partnership?: Researchers,
  "n_3_2_what_proportion_of_researchers_staff_benefit_fro_1c01c693" VARCHAR  -- 3.2. What Proportion Of Researchers / Staff Benefit From Research Collaboration Within The Partnership?: Teaching Staff,
  "n_3_2_what_proportion_of_researchers_staff_benefit_fro_5727bb70" VARCHAR  -- 3.2. What Proportion Of Researchers / Staff Benefit From Research Collaboration Within The Partnership?: Administrative And Support Staff,
  "n_4_1_when_collaborating_in_third_mission_innovation_a_a7d1d225" VARCHAR  -- 4.1 When Collaborating In Third Mission / Innovation Activities, Do Partners Engage In (multiple Options Are Possible),
  "other_please_describe" VARCHAR  -- Other, Please Describe,
  "n_4_2_what_proportion_of_students_staff_researchers_be_beb7ed5d" VARCHAR  -- 4.2. What Proportion Of Students / Staff / Researchers Benefit From Innovation Collaboration Within The Partnership?: Students,
  "n_4_2_what_proportion_of_students_staff_researchers_be_92f7375c" VARCHAR  -- 4.2. What Proportion Of Students / Staff / Researchers Benefit From Innovation Collaboration Within The Partnership?: Researchers,
  "n_4_2_what_proportion_of_students_staff_researchers_be_24144d18" VARCHAR  -- 4.2. What Proportion Of Students / Staff / Researchers Benefit From Innovation Collaboration Within The Partnership?: Teaching Staff,
  "n_4_2_what_proportion_of_students_staff_researchers_be_8b9d2558" VARCHAR  -- 4.2. What Proportion Of Students / Staff / Researchers Benefit From Innovation Collaboration Within The Partnership?: Administrative And Support Staff,
  "n_5_1_1_general_drivers_geographical_proximity" VARCHAR  -- 5.1.1 General Drivers: Geographical Proximity,
  "n_5_1_1_general_drivers_strong_leadership_with_common_vision" VARCHAR  -- 5.1.1 General Drivers: Strong Leadership With Common Vision,
  "n_5_1_1_general_drivers_bottom_up_approach" VARCHAR  -- 5.1.1 General Drivers: Bottom-up Approach,
  "n_5_1_1_general_drivers_good_balance_between_top_down__80943515" VARCHAR  -- 5.1.1 General Drivers: Good Balance Between Top-down And Bottom-up Approach,
  "n_5_1_1_general_drivers_common_similar_topics_and_interests" VARCHAR  -- 5.1.1 General Drivers: Common / Similar Topics And Interests,
  "n_5_1_1_general_drivers_existing_contacts_between_staff_members" VARCHAR  -- 5.1.1 General Drivers: Existing Contacts Between Staff Members,
  "n_5_1_1_general_drivers_previously_established_collabo_f8c756c3" VARCHAR  -- 5.1.1 General Drivers: Previously Established Collaboration For Participation In International Programmes / FP Projects,
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_19a46ca9" VARCHAR  -- If You Agree Or Totally Agree With Any Of The Above, Please Elaborate On Your Choice,
  "n_5_1_2_mobility_mobility_of_students" VARCHAR  -- 5.1.2 Mobility: Mobility Of Students,
  "n_5_1_2_mobility_mobility_of_researchers" VARCHAR  -- 5.1.2 Mobility: Mobility Of Researchers,
  "n_5_1_2_mobility_mobility_of_teaching_staff" VARCHAR  -- 5.1.2 Mobility: Mobility Of Teaching Staff,
  "n_5_1_2_mobility_mobility_of_administrative_and_other__99fe36d2" VARCHAR  -- 5.1.2 Mobility: Mobility Of Administrative And Other Non-teaching Staff,
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_37848689" VARCHAR  -- If You Agree Or Totally Agree With Any Of The Above, Please Elaborate On Your Choice.1,
  "n_5_1_3_education_teaching_and_capacity_building_devel_d9003d02" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Developing Students' New Skills (e.g. Multilingualism, Multidisciplinarity),
  "n_5_1_3_education_teaching_and_capacity_building_enhan_188f4754" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Enhancing Students' Employability,
  "n_5_1_3_education_teaching_and_capacity_building_nurtu_2613a634" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Nurturing Active Citizenship / Civic Engagement,
  "n_5_1_3_education_teaching_and_capacity_building_incre_e27b038c" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Increasing The Ability To Attract The Best Students,
  "n_5_1_3_education_teaching_and_capacity_building_devel_851da79a" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Developing Common / Similar Higher Education Disciplines, Topics And Interests,
  "n_5_1_3_education_teaching_and_capacity_building_incre_07a7cccc" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Increasing The Quality And Relevance Of The Educational Offer (study Programmes),
  "n_5_1_3_education_teaching_and_capacity_building_promo_64978ae7" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Promoting Synergies In Education Among Partners,
  "n_5_1_3_education_teaching_and_capacity_building_promo_bc3a1a0a" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Promoting Links Between Higher Education And Research,
  "n_5_1_3_education_teaching_and_capacity_building_devel_c01bbc6d" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Developing Teaching And Non-teaching Staff's New Skills,
  "n_5_1_3_education_teaching_and_capacity_building_enhan_d53878ea" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Enhancing Staff's Employability,
  "n_5_1_3_education_teaching_and_capacity_building_promo_19f8c46b" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Promoting Excellence In Teaching And Learning (learning Environment / Learning Conditions),
  "n_5_1_3_education_teaching_and_capacity_building_incre_ec69f56a" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Increasing The Organisation(s)' Capacity To Design And Deliver Higher Education,
  "n_5_1_3_education_teaching_and_capacity_building_incre_f2941d99" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Increasing The Organisation(s)' Capacity To Assess And Certify Higher Education,
  "n_5_1_3_education_teaching_and_capacity_building_incre_a0a69b27" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Increasing The Organisation(s)' Capacity To Provide Services To Students And Staff,
  "n_5_1_3_education_teaching_and_capacity_building_achie_677b19da" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Achieving Critical Mass To Attract Funding Or (foreign) Students,
  "n_5_1_3_education_teaching_and_capacity_building_promo_92cf208e" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Promoting Attractiveness Of Institutions To Non-EU Higher Education Partners,
  "n_5_1_3_education_teaching_and_capacity_building_promo_85ae4957" VARCHAR  -- 5.1.3 Education, Teaching And Capacity Building: Promoting Collaboration Between Universities With Different Levels Of Higher Education Capability (widening / Capacity Building),
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_5cb23825" VARCHAR  -- If You Agree Or Totally Agree With Any Of The Above, Please Elaborate On Your Choice.2,
  "n_5_1_4_research_and_capacity_building_developing_comm_f0da760d" VARCHAR  -- 5.1.4 Research And Capacity Building: Developing Common / Similar Research Topics And Interests,
  "n_5_1_4_research_and_capacity_building_developing_rese_4e87c7bd" VARCHAR  -- 5.1.4 Research And Capacity Building: Developing Researchers' New Skills,
  "n_5_1_4_research_and_capacity_building_enhancing_resea_1bb189bc" VARCHAR  -- 5.1.4 Research And Capacity Building: Enhancing Researchers' Employability,
  "n_5_1_4_research_and_capacity_building_promoting_scien_af14d96f" VARCHAR  -- 5.1.4 Research And Capacity Building: Promoting Scientific Excellence,
  "n_5_1_4_research_and_capacity_building_strengthening_c_fffeafee" VARCHAR  -- 5.1.4 Research And Capacity Building: Strengthening Capacity Building,
  "n_5_1_4_research_and_capacity_building_achieving_criti_205cafa2" VARCHAR  -- 5.1.4 Research And Capacity Building: Achieving Critical Mass To Attract Funding Or (foreign) Staff,
  "n_5_1_4_research_and_capacity_building_promoting_attra_adc479a7" VARCHAR  -- 5.1.4 Research And Capacity Building: Promoting Attractiveness To Non-EU R&D Partners,
  "n_5_1_4_research_and_capacity_building_accessing_forei_f134bd0d" VARCHAR  -- 5.1.4 Research And Capacity Building: Accessing Foreign Knowledge Base / Collaborative Partners,
  "n_5_1_4_research_and_capacity_building_promoting_colla_d283e847" VARCHAR  -- 5.1.4 Research And Capacity Building: Promoting Collaboration Between Universities With Different Levels Of Research Capability (widening / Capacity Building),
  "if_you_agree_or_totally_agree_with_any_of_the_above_pl_4538e819" VARCHAR  -- If You Agree Or Totally Agree With Any Of The Above, Please Elaborate On Your Choice.3
);