Ministers' Meetings With External Organisations Individuals From January 2020 To September 2023

CREATE TABLE ministers_meetings_with_external_organisations_and_ind_50e09650 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

CREATE TABLE ministers_meetings_with_external_organisations_and_ind_d5947c73 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_15cc86df (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_4412605e (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_504b2084 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_5fd87662 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_947b5f11 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_b585ed83 (
  "mark_beattie_daera_spad" VARCHAR  -- Mark Beattie, DAERA SpAd,
  "n__richard_bullick_fm_spad" VARCHAR  -- Richard Bullick, FM SpAd,
  "n__jonathan_mcferran_daera" VARCHAR  -- Jonathan McFerran, DAERA,
  "n__paul_mclaughlin_qc" VARCHAR  -- Paul McLaughlin QC,
  "n__kevin_brown_dso" VARCHAR  -- Kevin Brown, DSO,
  "n__mike_brennan_dfe" VARCHAR  -- Mike Brennan, DfE,
  "n__graham_miller_dfe" VARCHAR  -- Graham Miller, DfE,
  "n__jonathan_ashe_dfe" VARCHAR  -- Jonathan Ashe, DfE
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_b80ebce9 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_b822a0a1 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_bd275efb (
  "minister_edwin_poots_mla_daera_21_06_2021_ministers_an_53164f69" VARCHAR  -- Minister Edwin Poots MLA,DAERA,21/06/2021,"Ministers And Departmental Officials,
  "n__minister_conor_murphy_mla_daera" VARCHAR  -- Minister Conor Murphy MLA, DAERA,
  "n__jonathan_mcferran_daera" VARCHAR  -- Jonathan McFerran, DAERA,
  "n__john_joe_o_boyle_assistant_secretary_forest_service" VARCHAR  -- John Joe O’Boyle, Assistant Secretary Forest Service,
  "n__dr_hammond_head_of_natural_environment_operations_niea" VARCHAR  -- Dr Hammond, Head Of Natural Environment Operations NIEA,
  "n__minister_nichola_mallon_mla_dfi" VARCHAR  -- Minister Nichola Mallon MLA, DFI,
  "n__tanya_mccamphill_dfi_special_advisor" VARCHAR  -- Tanya McCamphill, DFI Special Advisor,
  "n__paul_harper_director_of_asset_recovery_ni_water" VARCHAR  -- Paul Harper, Director Of Asset Recovery NI Water,
  "n__dymphna_gallagher_head_of_drinking_water_regulation_ni_water" VARCHAR  -- Dymphna Gallagher, Head Of Drinking Water Regulation, NI Water,
  "n__chris_hazzard_mp_south_down" VARCHAR  -- Chris Hazzard, MP South Down,
  "n__rebecca_webb_accompanied_chris_hazzard_mp" VARCHAR  -- Rebecca Webb, Accompanied Chris Hazzard MP,
  "n__ian_mccurley_woodland_trust" VARCHAR  -- Ian McCurley, Woodland Trust,
  "n__martin_carey_director_mourne_heritage_trust" VARCHAR  -- Martin Carey, Director, Mourne Heritage Trust,
  "n__david_mcginn_chair_mourne_heritage_trust" VARCHAR  -- David McGinn, Chair, Mourne Heritage Trust,
  "n__conor_mallon_director_of_enterprise_regeneration_an_376995ac" VARCHAR  -- Conor Mallon, Director Of Enterprise, Regeneration And Tourism, Newry, Mourne And Down District Council (NMDDC),
  "n__andrew_patterson_asst_director_tourism_culture_and__46831fdb" VARCHAR  -- Andrew Patterson, Asst. Director Tourism, Culture And Events, NMDDC,
  "n__heather_mclachlan_national_trust" VARCHAR  -- Heather McLachlan, National Trust,
  "n__diane_ruddock_external_affairs_manager_national_trust" VARCHAR  -- Diane Ruddock, External Affairs Manager, National Trust,
  "n__marie_ward_ceo_nmddc" VARCHAR  -- Marie Ward, CEO, NMDDC,
  "n__councillor_cathy_mason_chairperson_nmddc_to_take_fo_bb2f21fd" VARCHAR  -- Councillor Cathy Mason, Chairperson, NMDDC. ",To Take Forward The Mournes Recovery Plan,
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_d6c739ca (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9,
  "unnamed_10" VARCHAR  -- Unnamed: 10,
  "unnamed_11" VARCHAR  -- Unnamed: 11,
  "unnamed_12" VARCHAR  -- Unnamed: 12,
  "unnamed_13" VARCHAR  -- Unnamed: 13,
  "unnamed_14" VARCHAR  -- Unnamed: 14,
  "unnamed_15" VARCHAR  -- Unnamed: 15,
  "unnamed_16" VARCHAR  -- Unnamed: 16,
  "unnamed_17" VARCHAR  -- Unnamed: 17,
  "unnamed_18" VARCHAR  -- Unnamed: 18,
  "unnamed_19" VARCHAR  -- Unnamed: 19,
  "unnamed_20" VARCHAR  -- Unnamed: 20,
  "unnamed_21" VARCHAR  -- Unnamed: 21,
  "unnamed_22" VARCHAR  -- Unnamed: 22,
  "unnamed_23" VARCHAR  -- Unnamed: 23,
  "unnamed_24" VARCHAR  -- Unnamed: 24,
  "unnamed_25" VARCHAR  -- Unnamed: 25,
  "unnamed_26" VARCHAR  -- Unnamed: 26,
  "unnamed_27" VARCHAR  -- Unnamed: 27,
  "unnamed_28" VARCHAR  -- Unnamed: 28,
  "unnamed_29" VARCHAR  -- Unnamed: 29,
  "unnamed_30" VARCHAR  -- Unnamed: 30,
  "unnamed_31" VARCHAR  -- Unnamed: 31,
  "unnamed_32" VARCHAR  -- Unnamed: 32,
  "unnamed_33" VARCHAR  -- Unnamed: 33,
  "unnamed_34" VARCHAR  -- Unnamed: 34,
  "unnamed_35" VARCHAR  -- Unnamed: 35,
  "unnamed_36" VARCHAR  -- Unnamed: 36,
  "unnamed_37" VARCHAR  -- Unnamed: 37,
  "unnamed_38" VARCHAR  -- Unnamed: 38,
  "unnamed_39" VARCHAR  -- Unnamed: 39,
  "unnamed_40" VARCHAR  -- Unnamed: 40,
  "unnamed_41" VARCHAR  -- Unnamed: 41,
  "unnamed_42" VARCHAR  -- Unnamed: 42,
  "unnamed_43" VARCHAR  -- Unnamed: 43,
  "unnamed_44" VARCHAR  -- Unnamed: 44,
  "unnamed_45" VARCHAR  -- Unnamed: 45,
  "unnamed_46" VARCHAR  -- Unnamed: 46,
  "unnamed_47" VARCHAR  -- Unnamed: 47,
  "unnamed_48" VARCHAR  -- Unnamed: 48,
  "unnamed_49" VARCHAR  -- Unnamed: 49,
  "unnamed_50" VARCHAR  -- Unnamed: 50,
  "unnamed_51" VARCHAR  -- Unnamed: 51,
  "unnamed_52" VARCHAR  -- Unnamed: 52,
  "unnamed_53" VARCHAR  -- Unnamed: 53,
  "unnamed_54" VARCHAR  -- Unnamed: 54,
  "unnamed_55" VARCHAR  -- Unnamed: 55,
  "unnamed_56" VARCHAR  -- Unnamed: 56,
  "unnamed_57" VARCHAR  -- Unnamed: 57,
  "unnamed_58" VARCHAR  -- Unnamed: 58,
  "unnamed_59" VARCHAR  -- Unnamed: 59,
  "unnamed_60" VARCHAR  -- Unnamed: 60,
  "unnamed_61" VARCHAR  -- Unnamed: 61,
  "unnamed_62" VARCHAR  -- Unnamed: 62,
  "unnamed_63" VARCHAR  -- Unnamed: 63,
  "unnamed_64" VARCHAR  -- Unnamed: 64,
  "unnamed_65" VARCHAR  -- Unnamed: 65,
  "unnamed_66" VARCHAR  -- Unnamed: 66,
  "unnamed_67" VARCHAR  -- Unnamed: 67,
  "unnamed_68" VARCHAR  -- Unnamed: 68,
  "unnamed_69" VARCHAR  -- Unnamed: 69,
  "unnamed_70" VARCHAR  -- Unnamed: 70,
  "unnamed_71" VARCHAR  -- Unnamed: 71,
  "unnamed_72" VARCHAR  -- Unnamed: 72,
  "unnamed_73" VARCHAR  -- Unnamed: 73,
  "unnamed_74" VARCHAR  -- Unnamed: 74,
  "unnamed_75" VARCHAR  -- Unnamed: 75,
  "unnamed_76" VARCHAR  -- Unnamed: 76,
  "unnamed_77" VARCHAR  -- Unnamed: 77,
  "unnamed_78" VARCHAR  -- Unnamed: 78,
  "unnamed_79" VARCHAR  -- Unnamed: 79,
  "unnamed_80" VARCHAR  -- Unnamed: 80,
  "unnamed_81" VARCHAR  -- Unnamed: 81,
  "unnamed_82" VARCHAR  -- Unnamed: 82,
  "unnamed_83" VARCHAR  -- Unnamed: 83,
  "unnamed_84" VARCHAR  -- Unnamed: 84,
  "unnamed_85" VARCHAR  -- Unnamed: 85,
  "unnamed_86" VARCHAR  -- Unnamed: 86,
  "unnamed_87" VARCHAR  -- Unnamed: 87,
  "unnamed_88" VARCHAR  -- Unnamed: 88,
  "unnamed_89" VARCHAR  -- Unnamed: 89,
  "unnamed_90" VARCHAR  -- Unnamed: 90,
  "unnamed_91" VARCHAR  -- Unnamed: 91,
  "unnamed_92" VARCHAR  -- Unnamed: 92,
  "unnamed_93" VARCHAR  -- Unnamed: 93,
  "unnamed_94" VARCHAR  -- Unnamed: 94,
  "unnamed_95" VARCHAR  -- Unnamed: 95,
  "unnamed_96" VARCHAR  -- Unnamed: 96,
  "unnamed_97" VARCHAR  -- Unnamed: 97,
  "unnamed_98" VARCHAR  -- Unnamed: 98,
  "unnamed_99" VARCHAR  -- Unnamed: 99
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_e6227971 (
  "n__to_discuss_developing_agri_links_minister_edwin_poo_b40d7b23" VARCHAR  -- ,To Discuss Developing Agri Links, Minister Edwin Poots MLA,DAERA,15/12/2021,Global Britain (Operations) - Lord Frost,Global Britain (Operations) Meeting With Political Representatives, Minister Edwin Poots MLA,DAERA,20/12/2021,Ursula Lavery Moy Park,
  "n__alan_huston_moy_park" VARCHAR  -- Alan Huston Moy Park,
  "n__keiron_forbes_core_group" VARCHAR  -- Keiron Forbes Core Group,
  "n__charles_crawford_ready_eggs" VARCHAR  -- Charles Crawford Ready Eggs,
  "n__richard_cummings_ready_eggs" VARCHAR  -- Richard Cummings Ready Eggs,
  "n__harold_richmond_skea_eggs" VARCHAR  -- Harold Richmond Skea Eggs,
  "n__jonathan_thompson_farmlay" VARCHAR  -- Jonathan Thompson Farmlay,
  "n__mark_davison_ballygarvey" VARCHAR  -- Mark Davison Ballygarvey,
  "n__brian_clarke_clarkes_eggs" VARCHAR  -- Brian Clarke Clarkes Eggs,
  "n__brian_edgar_edgar_transport" VARCHAR  -- Brian Edgar Edgar Transport,
  "n__eileen_hall_cavanagh_eggs" VARCHAR  -- Eileen Hall Cavanagh Eggs,
  "n__david_fenton_fenton_eggs" VARCHAR  -- David Fenton Fenton Eggs,
  "n__emma_carter_bowler_eggs" VARCHAR  -- Emma Carter Bowler Eggs,
  "n__eric_thompson_rockvale_poultry" VARCHAR  -- Eric Thompson Rockvale Poultry,
  "n__gavin_rotherham_noble_foods" VARCHAR  -- Gavin Rotherham Noble Foods,
  "n__gill_gallagher_ni_grain_trade_association" VARCHAR  -- Gill Gallagher NI Grain Trade Association,
  "n__declan_billington_thompsons_feeds_ltd" VARCHAR  -- Declan Billington Thompsons Feeds Ltd,
  "n__gerry_smyth_smyth_transport" VARCHAR  -- Gerry Smyth Smyth Transport,
  "n__edward_kearns_kearns_poultry" VARCHAR  -- Edward Kearns Kearns Poultry,
  "n__trevor_lockhart_fane_valley_feeds" VARCHAR  -- Trevor Lockhart Fane Valley Feeds,
  "n__maire_burnett_bpc" VARCHAR  -- Maire Burnett BPC,
  "n__mark_williams_beic" VARCHAR  -- Mark Williams BEIC,
  "n__michael_bryson_genshane_eggs" VARCHAR  -- Michael Bryson Genshane Eggs,
  "n__niall_delarghy_ballyeamon_eggs" VARCHAR  -- Niall Delarghy Ballyeamon Eggs,
  "n__phillip_clements_clements_eggs" VARCHAR  -- Phillip Clements Clements Eggs,
  "n__peter_mcconnell_silverhill_ducks" VARCHAR  -- Peter McConnell Silverhill Ducks,
  "n__richard_nesbitt_corby_rock_feed" VARCHAR  -- Richard Nesbitt Corby Rock Feed,
  "n__sean_mcshane_linergy" VARCHAR  -- Sean McShane Linergy,
  "n__tom_willings_stonegate_eggs" VARCHAR  -- Tom Willings Stonegate Eggs
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_e6bf6d0b (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6
);

CREATE TABLE ministers_meetings_with_external_organisations_individ_f9795f71 (
  "register_of_ministers_meetings_with_external_organisat_c0a1e7b0" VARCHAR  -- REGISTER OF MINISTERS' MEETINGS WITH EXTERNAL ORGANISATIONS / INDIVIDUALS,
  "unnamed_1" VARCHAR  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5,
  "unnamed_6" VARCHAR  -- Unnamed: 6,
  "unnamed_7" VARCHAR  -- Unnamed: 7,
  "unnamed_8" VARCHAR  -- Unnamed: 8,
  "unnamed_9" VARCHAR  -- Unnamed: 9
);