ODP USER SURVEYS FORMATTED V2–25072023

CREATE TABLE table_1 (
  "n__0_survey_year" DOUBLE,
  "n__1_what_is_your_main_interest" VARCHAR,
  "n__1_1_to_learn_about_eu_shared" DOUBLE,
  "n__1_2_to_make_comparative" DOUBLE,
  "n__1_3_to_create_your_own" DOUBLE,
  "n__1_4_to_search_for_data" DOUBLE,
  "n__1_5_to_use_the_visualisations" DOUBLE,
  "n__1_6_other" DOUBLE,
  "n__1_7_if_other_please_specify" VARCHAR,
  "n__2_did_you_find_the" VARCHAR,
  "n__3_do_you_have_any_specific" VARCHAR,
  "n__3_1_if_other_please_specify" VARCHAR,
  "n__4_did_you_find_the_website" VARCHAR,
  "n__5_how_could_the_platform" VARCHAR,
  "n__5_1_more_data" DOUBLE,
  "n__5_2_more_user_friendly" DOUBLE,
  "n__5_3_benchmarking_comparing" DOUBLE,
  "n__5_4_more_languages" DOUBLE,
  "n__5_5_linking_to_other" DOUBLE,
  "n__5_6_more_frequent_update" DOUBLE,
  "n__5_7_newsletter" DOUBLE,
  "n__5_8_other" DOUBLE,
  "n__5_9_if_other_please_specify" VARCHAR,
  "n__6_which_fund_s_are_you" VARCHAR,
  "n__6_1_erdf_cohesion_fund" DOUBLE,
  "n__6_2_esf_yei" DOUBLE,
  "n__6_3_emfaf_emff" DOUBLE,
  "n__6_4_amif_bmvi_isf_dg_home" DOUBLE,
  "n__6_5_jtf" DOUBLE,
  "n__6_6_interreg" DOUBLE,
  "n__6_7_eafrd_eagf_dg_agri" DOUBLE,
  "n__7_who_are_you" VARCHAR,
  "n__7_1_if_other_please_specify" VARCHAR,
  "n__8_are_you_working_with_the" VARCHAR,
  "n__8_1_if_other_please_specify" VARCHAR,
  "n__9_country_of_residence" VARCHAR,
  "n__9_1_if_other_please_specify" VARCHAR,
  "n__10_how_did_you_hear_about" VARCHAR,
  "n__10_1_if_other_please_specify" VARCHAR,
  "n__11_how_often_do_you_use" VARCHAR,
  "n__12_do_you_use_functions" VARCHAR,
  "n__12_1_explore_the_data_create" DOUBLE,
  "n__12_2_export_visualisations" DOUBLE,
  "n__12_3_share_to_social_media" DOUBLE,
  "n__12_4_other" DOUBLE,
  "n__12_5_no_but_i_would_like" DOUBLE,
  "no_i_don_t_plan_on_using" DOUBLE,
  "n__12_7_if_other_please_specify" VARCHAR,
  "n__13_how_would_you_rate_the" VARCHAR,
  "n__13_1_comments_you_would" VARCHAR
);