Meetings With External Organisations By Ministers In The Foreign And Commonwealth Office

CREATE TABLE fco_ministerial_meetings_with_external_organisation_oc_ec1950aa (
  "tariq_ahmad_2018_11_19_the_rt_rev_d_mouneer_hanna_anis_49c6e5e3" VARCHAR  -- Tariq Ahmad,2018-11-19,"The Rt. Rev. D. Mouneer Hanna Anis, Bishop Of The Episcopal / Anglican Diocese Of Egypt With North Africa And The Horn Of Africa,
  "n__dr_mustafa_el_fiki_president_of_alexandria_library" VARCHAR  -- Dr Mustafa El-Fiki, President Of Alexandria Library,
  "n__ambassador_abdal_rahman_musa_advisor_of_the_grand_imam" VARCHAR  -- Ambassador Abdal Rahman Musa, Advisor Of The Grand Imam,
  "n__dr_ziad_bahaa_el_din_thinker_and_economist_former_d_45c92d66" VARCHAR  -- Dr Ziad Bahaa El-Din, Thinker And Economist, Former Deputy Prime Minister,
  "n__dr_hosam_badrawi_a_professor_of_medicine_at_cairo_u_125f6c76" VARCHAR  -- Dr Hosam Badrawi, A Professor Of Medicine At Cairo University And Former MP And Chairman Of Parliamentary Education Committee,
  "n__dr_osama_el_azhary_advisor_to_the_president" VARCHAR  -- Dr Osama El-Azhary, Advisor To The President,
  "n__sheikh_muhamed_el_amin_secretary_general_of_the_hou_f3c2afe7" VARCHAR  -- Sheikh Muhamed El Amin, Secretary General Of The House Of The Family (Al-Azhar),
  "n__dr_sameh_fawzy_deputy_sg" VARCHAR  -- Dr Sameh Fawzy, Deputy SG,
  "n__dr_samir_marcos_member_of_human_rights_council" VARCHAR  -- Dr Samir Marcos, Member Of Human Rights Council,
  "n__father_rafik_greish_greek_catholic_priest_and_journalist" VARCHAR  -- Father Rafik Greish, Greek Catholic Priest And Journalist,
  "n__chancellor_adly_hussein_former_governor_roundtable__440cfd77" VARCHAR  -- Chancellor Adly Hussein, Former Governor ",Roundtable With Faith And Thought Leaders
);

CREATE TABLE fco_minister_s_meetings_with_external_organisations_ap_319b6816 (
  "tariq_ahmad_15_05_2019_hannah_bond_gender_action_for_p_4469dfe4" VARCHAR  -- Tariq Ahmad ,15/05/2019,"Hannah Bond, Gender Action For Peace And Security,
  "n__chantelle_cummings_conciliation_resources" VARCHAR  -- Chantelle Cummings, Conciliation Resources,
  "n__susana_klien_saferworld" VARCHAR  -- Susana Klien, Saferworld,
  "n__natasha_lewis_care_cooperative_for_assistance_and_r_37b36d3a" VARCHAR  -- Natasha Lewis, CARE [Cooperative For Assistance And Relief Everywhere] International UK,
  "n__sanam_naraghi_anderlini_ican" VARCHAR  -- Sanam Naraghi-Anderlini, ICAN,
  "n__brita_fernandez_schmidt_women_for_women_international" VARCHAR  -- Brita Fernandez Schmidt, Women For Women International,
  "n__zoe_smith_open_doors_uk_women_peace_and_security_st_ffdf272c" VARCHAR  -- Zoe Smith, Open Doors UK","Women, Peace And Security Steering Group - Discussion On Women, Peace And Security Issues"
);

CREATE TABLE fco_minister_s_meetings_with_external_organisations_ja_24c20b91 (
  "minister" VARCHAR,
  "date" TIMESTAMP,
  "name_of_organisation_or_individual" VARCHAR,
  "purpose_of_meeting" VARCHAR
);

CREATE TABLE meetings_with_external_organisations_by_ministers_in_t_7e69d0dd (
  "minister" VARCHAR,
  "date" VARCHAR,
  "name_of_external_organisation" VARCHAR,
  "purpose_of_meeting" VARCHAR,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);