ODP USER SURVEYS FORMATTED V2–25072023

CREATE TABLE table_1 (
  "n__0_survey_year" DOUBLE  -- 0 Survey Year,
  "n__1_what_is_your_main_interest" VARCHAR  -- 1 What Is Your Main Interest,
  "n__1_1_to_learn_about_eu_shared" DOUBLE  -- 1–1 To Learn About Eu Shared,
  "n__1_2_to_make_comparative" DOUBLE  -- 1–2 To Make Comparative,
  "n__1_3_to_create_your_own" DOUBLE  -- 1–3 To Create Your Own,
  "n__1_4_to_search_for_data" DOUBLE  -- 1–4 To Search For Data,
  "n__1_5_to_use_the_visualisations" DOUBLE  -- 1–5 To Use The Visualisations,
  "n__1_6_other" DOUBLE  -- 1–6 Other,
  "n__1_7_if_other_please_specify" VARCHAR  -- 1–7 If Other Please Specify,
  "n__2_did_you_find_the" VARCHAR  -- 2 Did You Find The,
  "n__3_do_you_have_any_specific" VARCHAR  -- 3 Do You Have Any Specific,
  "n__3_1_if_other_please_specify" VARCHAR  -- 3–1 If Other Please Specify,
  "n__4_did_you_find_the_website" VARCHAR  -- 4 Did You Find The Website,
  "n__5_how_could_the_platform" VARCHAR  -- 5 How Could The Platform,
  "n__5_1_more_data" DOUBLE  -- 5–1 More Data,
  "n__5_2_more_user_friendly" DOUBLE  -- 5–2 More User Friendly,
  "n__5_3_benchmarking_comparing" DOUBLE  -- 5–3 Benchmarking Comparing,
  "n__5_4_more_languages" DOUBLE  -- 5–4 More Languages,
  "n__5_5_linking_to_other" DOUBLE  -- 5–5 Linking To Other,
  "n__5_6_more_frequent_update" DOUBLE  -- 5–6 More Frequent Update,
  "n__5_7_newsletter" DOUBLE  -- 5–7 Newsletter,
  "n__5_8_other" DOUBLE  -- 5–8 Other,
  "n__5_9_if_other_please_specify" VARCHAR  -- 5–9 If Other Please Specify,
  "n__6_which_fund_s_are_you" VARCHAR  -- 6 Which Fund S Are You,
  "n__6_1_erdf_cohesion_fund" DOUBLE  -- 6–1 Erdf Cohesion Fund,
  "n__6_2_esf_yei" DOUBLE  -- 6–2 Esf Yei,
  "n__6_3_emfaf_emff" DOUBLE  -- 6–3 Emfaf Emff,
  "n__6_4_amif_bmvi_isf_dg_home" DOUBLE  -- 6–4 Amif Bmvi Isf Dg Home,
  "n__6_5_jtf" DOUBLE  -- 6–5 Jtf,
  "n__6_6_interreg" DOUBLE  -- 6–6 Interreg,
  "n__6_7_eafrd_eagf_dg_agri" DOUBLE  -- 6–7 Eafrd Eagf Dg Agri,
  "n__7_who_are_you" VARCHAR  -- 7 Who Are You,
  "n__7_1_if_other_please_specify" VARCHAR  -- 7–1 If Other Please Specify,
  "n__8_are_you_working_with_the" VARCHAR  -- 8 Are You Working With The,
  "n__8_1_if_other_please_specify" VARCHAR  -- 8–1 If Other Please Specify,
  "n__9_country_of_residence" VARCHAR  -- 9 Country Of Residence,
  "n__9_1_if_other_please_specify" VARCHAR  -- 9–1 If Other Please Specify,
  "n__10_how_did_you_hear_about" VARCHAR  -- 10 How Did You Hear About,
  "n__10_1_if_other_please_specify" VARCHAR  -- 10–1 If Other Please Specify,
  "n__11_how_often_do_you_use" VARCHAR  -- 11 How Often Do You Use,
  "n__12_do_you_use_functions" VARCHAR  -- 12 Do You Use Functions,
  "n__12_1_explore_the_data_create" DOUBLE  -- 12–1 Explore The Data Create,
  "n__12_2_export_visualisations" DOUBLE  -- 12–2 Export Visualisations,
  "n__12_3_share_to_social_media" DOUBLE  -- 12–3 Share To Social Media,
  "n__12_4_other" DOUBLE  -- 12–4 Other,
  "n__12_5_no_but_i_would_like" DOUBLE  -- 12–5 No But I Would Like,
  "no_i_don_t_plan_on_using" DOUBLE,
  "n__12_7_if_other_please_specify" VARCHAR  -- 12–7 If Other Please Specify,
  "n__13_how_would_you_rate_the" VARCHAR  -- 13 How Would You Rate The,
  "n__13_1_comments_you_would" VARCHAR  -- 13–1 Comments You Would
);