As 59 variáveis pela ordem da folha, agrupadas em oito blocos. O número Q é o do questionário no cabeçalho da coluna; o nome curto é o nome de campo legível por máquina. As coberturas e contagens de valores provêm do perfil v4.2 de 4 380 entradas.
Block A — Identification & Actor (Q1–Q4)4 variáveis
Q1region
Coluna de origem: 1.) African Region? · Tipo: Categorical (nominal) · Cobertura: completo
Macro-region of Africa under which the home actor is classified. The file spans five coded regions: the Eastern-Africa module (nineteen states), the fifteen-member ECOWAS belt in full plus Mauritania-less Western Africa (Nigeria, Ghana, Senegal, Côte d'Ivoire, Sierra Leone, Mali, Guinea, Niger, Burkina Faso, Liberia, Togo, Benin, The Gambia, Guinea-Bissau and Cabo Verde) and Sudan (Northern Africa), and South Africa (Southern Africa — the fourth region, opened in v4.0); v4.2 adds ten stub groups created by re-orienting team-coded inbound visits into outbound records of the visiting African state (Egypt, Libya, Tunisia, Morocco, Algeria, Angola, Democratic Republic of the Congo, Equatorial Guinea, Botswana, Namibia — opening Central Africa as the fifth region and extending Northern and Southern Africa); these stub groups are not systematically built.
Eastern Africa2.739Western Africa1.204Northern Africa300Southern Africa132Central Africa5
Q2home_country
Coluna de origem: 2.) Home Country? · Tipo: Categorical (nominal) · Cobertura: completo
Sovereign state (or de facto state) the travelling / engaging leader represents (the sending actor). Forty-six home actors across five regions, thirty-six of them systematically coded; the rest are incidental groups created by re-orienting inbound visits.
Ethiopia480Kenya409Sudan290Nigeria242Zambia176Somalia175Tanzania169Uganda167
Q3actor_title
Coluna de origem: 3.) Title? (King, President, Prime Minister, Foreign Minister, Defense Minister, Finance Minister, etc.) · Tipo: Categorical (nominal) · Cobertura: completo
Official office held by the home actor at the time of the engagement. Free office label drawn from an open list; 27 distinct values clustering on heads of state/government and senior ministers.
President2.826Foreign Minister843Prime Minister440Deputy Prime Minister & Foreign Minister45Defence Minister40Deputy President40Finance Minister35Vice-President25
Nota: Top 14 of 27 distinct office labels shown; the tail comprises single- to triple-count ministerial and military-chief titles (State Minister of Finance, Chief of Defence Staff, Minister of Petroleum/Trade/Mining/Investment, Army/Coast-Guard Commander, Special Envoy, etc.).
Q4leader_name
Coluna de origem: 4.) Leader's Name? · Tipo: Open text · Cobertura: completo
Personal name of the home actor. High-cardinality identifier (579 distinct individuals across the period).
Valores: 579 distinct. Most frequent: Uhuru Kenyatta (170), Yoweri Kaguta Museveni (122), William Ruto (111), Paul Kagame (99), Omar al-Bashir (98), Muhammadu Buhari (95), Meles Zenawi (91), Abiy Ahmed (87), Samia Suluhu Hassan (70), Ismail Omar Guelleh (69), Robert Mugabe (69), Hakainde Hichilema (66).
Block B — Engagement Event (Q5–Q9)5 variáveis
Q5meeting_type
Coluna de origem: 5.) Meeting Type? · Tipo: Categorical (nominal) · Cobertura: completo
Modality of the engagement: an in-person trip, a telephone call, or a video conference.
Visit4.229Video Conference76Phone Call75
Q6country_visited
Coluna de origem: 6.) Country Visited/Called/Conferenced? · Tipo: Categorical (nominal) · Cobertura: completo
Counterpart / host country of the engagement (destination of a visit, or the country of the interlocutor for a call or video conference).
Valores: 130 distinct. Most frequent: United States of America (1,416), China (214), Ethiopia (210), France (127), Kenya (121), Tanzania (113), Egypt (101), South Africa (98), United Kingdom (98), Russian Federation (96), Uganda (89), United Arab Emirates (75).
Nota: Country labels use long-form controlled values (e.g. “Russian Federation”, “Türkiye”, “United Kingdom of Great Britain and Northern Ireland”).
Q7city_visited
Coluna de origem: 7.) City Visited/Called/Conferenced? · Tipo: Categorical (nominal) · Cobertura: 4.357 válidos / 23 em falta
City in which the engagement took place (for calls, typically the interlocutor’s seat).
Valores: 300 distinct. Most frequent: New York (1,214), Addis Ababa (204), Beijing (189), Washington (179), Nairobi (115), Paris (102), London (74), Cairo (73), Kampala (72), Kigali (66), Djibouti City (63), Khartoum (59).
Q8start_date
Coluna de origem: 8.) Trip/Call/Conference Start Date? · Tipo: Date (MM/DD/YYYY) · Cobertura: completo
First day of the engagement. Stored as text in US MM/DD/YYYY order.
Valores: Range 01/01/1990 → 12/30/2025. All 4,380 values parse as valid dates.
Q9end_date
Coluna de origem: 9.) Trip/Call/Conference End Date? · Tipo: Date (MM/DD/YYYY) · Cobertura: completo
Last day of the engagement (equal to the start date for single-day events).
Valores: Range 01/01/1990 → 12/30/2025. All 4,380 values parse as valid dates.
Block C — Delegation & Counterparts (Q10–Q20)11 variáveis
Q10hogs_cotravel
Coluna de origem: 10.) HoG/S Co-Travel? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether another head of government/state from the home country travelled together with the actor (joint travel).
No4.360Yes20
Q11meet_host_hogs
Coluna de origem: 11.) Meet with Host Country HoG/S? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the actor met the host country’s head of government/state.
No3.097Yes1.283
Q12host_hogs_name
Coluna de origem: 12.) If Yes, Name? (Title First Name Last Name) · Tipo: Open text · Cobertura: 1.283 válidos / 3.097 em falta
Name (with title) of the host head of government/state met. Conditional on Q11 = Yes (skip otherwise).
Valores: 314 distinct. Frequent counterparts: President Xi Jinping (71), President Yoweri Kaguta Museveni (46), President Vladimir Putin (38), President Ismail Omar Guelleh (38), President Emmanuel Macron (37), President Abdel Fattah el-Sisi (34), President Isaias Afwerki (34), President Omar al-Bashir (29), President Hu Jintao (29), President Uhuru Kenyatta (28), Prime Minister Abiy Ahmed (28).
Q13meet_host_subhogs
Coluna de origem: 13.) Met With Host-country Sub-HoG/S Equivalent? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the actor met a sub-head-of-government counterpart of the host (e.g. a foreign or other senior minister) rather than the HoG/S.
No4.038Yes342
Q14host_subhogs_name
Coluna de origem: 14.) If Yes, Name? (Title First Name Last Name) · Tipo: Open text · Cobertura: 342 válidos / 4.038 em falta
Name (with title) of the host-country sub-HoG/S counterpart met. Conditional on Q13 = Yes.
Valores: 232 distinct, e.g. Foreign Minister Sergey Lavrov (12), Foreign Minister Wang Yi (10), Prime Minister Narendra Modi (8), Secretary of State Antony Blinken (7), Secretary of State Marco Rubio (5).
Q15summit_attend
Coluna de origem: 15.) Attend a Multilateral Summit or Event? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the engagement included attendance at a multilateral (heads-level) summit or event.
Yes2.648No1.732
Q16summit_name
Coluna de origem: 16.) If Yes, Name of Summit or Event? · Tipo: Open text · Cobertura: 2.648 válidos / 1.732 em falta
Name of the multilateral summit/event attended. Conditional on Q15 = Yes.
Valores: 1,068 distinct, e.g. United Nations Millennium Summit (16), the UN General Assembly General-Debate sessions (up to 13 each), Presidential Inauguration (12), AU Summit (10), FOCAC Beijing Summit 2006 (9).
Q17min_summit_attend
Coluna de origem: 17.) Attend a Multilateral Ministerial Event or Summit? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the engagement included a multilateral event at ministerial (sub-heads) level.
No4.284Yes96
Q18min_summit_name
Coluna de origem: 18.) If Yes, Name of Summit or Event? · Tipo: Open text · Cobertura: 96 válidos / 4.284 em falta
Name of the ministerial multilateral event. Conditional on Q17 = Yes.
Valores: 81 distinct, e.g. the trilateral foreign-ministers’ talks on the Grand Ethiopian Renaissance Dam (Ethiopia–Sudan–Egypt), BRICS Foreign Ministers’ Meeting, IGAD/AU ministerial meetings.
Q19nonhost_hogs_meet
Coluna de origem: 19.) Meet HOG/S from Non-host Country? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the actor met a head of government/state of a third country (not the host), typically on the sidelines of a multilateral event.
No4.175Yes205
Q20nonhost_hogs_names
Coluna de origem: 20.) If Yes, Name(s)? (Title First Name Last Name; List all) · Tipo: Open text · Cobertura: 205 válidos / 4.175 em falta
Name(s) of third-country HoG/S met. Multiple names may be listed in one cell. Conditional on Q19 = Yes.
Valores: 152 distinct strings; several cells list more than one leader (separated by “;”). Frequent: US President Bill Clinton (6), President Xi Jinping (5), Prime Minister Abiy Ahmed (4).
Block D — Activities on the Margins (Q21–Q25)5 variáveis
Q21public_address
Coluna de origem: 21.) Public Address? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the actor delivered a public address / speech during the engagement.
No3.877Yes503
Q22cultural_site_visit
Coluna de origem: 22.) Visit/Address Cultural/Historical/Religious Site or Event? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the engagement included a visit to, or address at, a cultural, historical or religious site or event.
No4.325Yes55
Q23business_leaders_meet
Coluna de origem: 23.) Meet with Business Leaders? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the actor met business / private-sector leaders.
No4.350Yes30
Q24io_leader_meet
Coluna de origem: 24.) Meet with Leader of Int'l Organization? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether the actor met the head of an international organisation.
No4.244Yes136
Q25io_leader_name
Coluna de origem: 25.) If Yes, Name? (Title First Name Last Name) · Tipo: Open text · Cobertura: 136 válidos / 4.244 em falta
Name (with title/organisation) of the international-organisation leader met. Conditional on Q24 = Yes.
Valores: 91 distinct, e.g. UN Secretaries-General Kofi Annan (11) / Ban Ki-moon / António Guterres, IMF & World Bank officials, IGAD Executive Secretary.
Block F — Agreements Signed (Q27–Q43)17 variáveis
Q27agreement_signed
Coluna de origem: 27.) Signed an Agreement? · Tipo: Binary (Yes / No) · Cobertura: completo
Master gate: whether any agreement was signed during the engagement. Opens the four agreement-family blocks (Q28–Q42).
No4.158Yes222
Q28agr_hlp_flag
Coluna de origem: 28.) High-level Politics (treaty-level) Agreement? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether a high-level political (treaty-level) instrument was signed — peace, alliance and boundary treaties, community accession/establishment treaties and founding conventions, and formal diplomatic-relations instruments.
No4.304Yes76
Q29agr_hlp_type
Coluna de origem: 29.) If Yes, What Type of High-level Politics (treaty-level) Agreement? · Tipo: Categorical (nominal) · Cobertura: 76 válidos / 4.304 em falta
Sub-type of the high-level political instrument. Conditional on Q28 = Yes. The type vocabulary is data-derived and richer than the original three treaty types.
Peace Treaty33Establishment Treaty12Alliance Treaty12Joint Communiqué10Accession Treaty4Diplomatic Relations Protocol3Boundary Treaty2
Q30agr_hlp_title
Coluna de origem: 30.) Title of Agreement? · Tipo: Open text · Cobertura: 40 válidos / 4.340 em falta
Official / descriptive title of the high-level political instrument (e.g. “Algiers Agreement (Eritrea–Ethiopia)”, “Pretoria Agreement”, “R-ARCSS”). Conditional on Q28 = Yes.
Q31agr_hlp_notes
Coluna de origem: 31.) Specific Notes? · Tipo: Open text · Cobertura: 47 válidos / 4.333 em falta
Free-text notes on the high-level political instrument (scope, signing context, dates).
Q32agr_econ_flag
Coluna de origem: 32.) Economics-related Agreement? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether an economics-related agreement was signed.
No4.305Yes75
Q33agr_econ_type
Coluna de origem: 33.) If Yes, What Type of Economics-related Agreement? · Tipo: Categorical (nominal) · Cobertura: 75 válidos / 4.305 em falta
Sub-type of the economics agreement. Conditional on Q32 = Yes.
Economic Partnership Agreement26Investment Treaty15Trade Agreement13Development Finance / Loan Agreement8Energy / Economic Cooperation Agreement5Investment Agreement4Trade and Investment Agreement2Tax Treaty2
Q34agr_econ_title
Coluna de origem: 34.) Title of Agreement? · Tipo: Open text · Cobertura: 57 válidos / 4.323 em falta
Title of the economics agreement (e.g. BITs, lines of credit, LAPSSET Corridor agreements, TFTA). Conditional on Q32 = Yes.
Q35agr_econ_notes
Coluna de origem: 35.) Specific Notes? · Tipo: Open text · Cobertura: 58 válidos / 4.322 em falta
Free-text notes on the economics agreement (value, parties, verification source).
Q36agr_func_flag
Coluna de origem: 36.) Functional Cooperation-related Agreement? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether a functional-cooperation agreement was signed.
No4.323Yes57
Q37agr_func_type
Coluna de origem: 37.) If Yes, What Type of Functional-cooperation Agreement? · Tipo: Categorical (nominal) · Cobertura: 57 válidos / 4.323 em falta
Sub-type of the functional-cooperation agreement. Conditional on Q36 = Yes.
Environmental Agreement12Framework/Partnership Agreement11Memorandum of Understanding7Migration Agreement6Consular Agreement5Cooperation Agreement5Defence Cooperation Agreement4Labour Mobility MoU3
Q38agr_func_title
Coluna de origem: 38.) Title of Agreement? · Tipo: Open text · Cobertura: 45 válidos / 4.335 em falta
Title of the functional-cooperation agreement. Conditional on Q36 = Yes.
Q39agr_func_notes
Coluna de origem: 39.) Specific Notes? · Tipo: Open text · Cobertura: 43 válidos / 4.337 em falta
Free-text notes on the functional-cooperation agreement.
Q40agr_tech_flag
Coluna de origem: 40.) Technical or Administrative-related Agreement? · Tipo: Binary (Yes / No) · Cobertura: completo
Whether a technical/administrative agreement was signed.
No4.332Yes48
Q41agr_tech_type
Coluna de origem: 41.) If Yes, What Type of Technical or Administrative-related Agreement? · Tipo: Categorical (nominal) · Cobertura: 48 válidos / 4.332 em falta
Sub-type of the technical/administrative agreement. Conditional on Q40 = Yes.
Memoranda of Understanding30Administrative Agreement12Technical Cooperation Agreement5Memorandum of Understanding1
Nota: “Memoranda of Understanding” (30) and “Memorandum of Understanding” (1) are number variants of the same label.
Q42agr_tech_title
Coluna de origem: 42.) Title of Agreement? · Tipo: Open text · Cobertura: 37 válidos / 4.343 em falta
Title of the technical/administrative agreement. Conditional on Q40 = Yes.
Q43agr_tech_notes
Coluna de origem: 43.) Specific Notes? · Tipo: Open text · Cobertura: 35 válidos / 4.345 em falta
Free-text notes on the technical/administrative agreement.
Block G — Agreement Lifecycle / Status (Q44–Q49)6 variáveis
Q44status_provisional
Coluna de origem: 44.) Still in the Provisional Status? · Tipo: Categorical (nominal) · Cobertura: completo
Whether a signed agreement remains provisional (not yet entered into force). “N/A” marks records with no agreement.
N/A4.270No107Yes3
Q45provisional_sig_date
Coluna de origem: 45.) If Yes, Signature Day? · Tipo: Date (MM/DD/YYYY) · Cobertura: 10 válidos / 4.370 em falta
Signature date of a provisional agreement (MM/DD/YYYY). Sparsely populated.
Q46status_ratified
Coluna de origem: 46.) Ratified? · Tipo: Categorical (nominal) · Cobertura: completo
Whether the agreement has been ratified. “N/A” marks records with no agreement.
N/A4.273No102Yes5
Q47ratification_date
Coluna de origem: 47.) If Yes, Ratification Date? · Tipo: Date (MM/DD/YYYY) · Cobertura: 5 válidos / 4.375 em falta
Ratification date (MM/DD/YYYY). Conditional on Q46 = Yes; sparsely populated.
Q48status_terminated
Coluna de origem: 48.) Terminated? · Tipo: Categorical (nominal) · Cobertura: completo
Whether the agreement has been terminated. “N/A” marks records with no agreement.
N/A4.271No108Yes1
Q49termination_date
Coluna de origem: 49.) If Yes, Termination Date? · Tipo: Date (MM/DD/YYYY) · Cobertura: 1 válidos / 4.379 em falta
Termination date (MM/DD/YYYY). One value present.
Block H — Assessment, Sourcing & Provenance (Q50–Q59)10 variáveis
Q50strategic_importance
Coluna de origem: 50.) Strategic Importance? (High, Medium, Low) · Tipo: Categorical (ordinal) · Cobertura: completo
Coder’s ordinal assessment of the strategic significance of the engagement.
Medium3.129High939Low312
Q51source_link_1
Coluna de origem: 51.) Source Link 1? · Tipo: Open text · Cobertura: completo
Primary source URL documenting the engagement. Always populated.
Valores: 2,790 distinct URLs. Most-cited domains: en.wikipedia.org (760), digitallibrary.un.org (521), u.afp.com (226), gadebate.un.org (225), allafrica.com (193), ask.un.org (183), advance.lexis.com (158), history.state.gov (73), mfaethiopia.blog (73).
Q52source_link_2
Coluna de origem: 52.) Source Link 2? · Tipo: Open text · Cobertura: 1.554 válidos / 2.826 em falta
Second corroborating source URL (optional).
Q53source_link_3
Coluna de origem: 53.) Source Link 3? · Tipo: Open text · Cobertura: 310 válidos / 4.070 em falta
Third corroborating source URL (optional).
Q54source_link_4
Coluna de origem: 54.) Source Link 4? · Tipo: Open text · Cobertura: 96 válidos / 4.284 em falta
Fourth corroborating source URL (optional).
Q55source_link_5
Coluna de origem: 55.) Source Link 5? · Tipo: Open text · Cobertura: 34 válidos / 4.346 em falta
Fifth corroborating source URL (optional).
Q56source_document
Coluna de origem: 56.) Source Document? (pdf, doc, docx, mp3, mp4, jpeg, png, etc.) · Tipo: Open text · Cobertura: 0 válidos / 4.380 em falta
Field reserved for an attached/archived source document (file type).
Nota: Entirely empty in this release (0 / 4,380 populated).
Q57confidence_level
Coluna de origem: 57.) Confidence Level? (Explicit, Implied, Assumed, Guessed, Dubious) · Tipo: Categorical (ordinal) · Cobertura: completo
Coder’s confidence in the record, on a five-level evidential scale (see §6.3). In this release only the two highest levels are used.
Explicit3.361Implied1.019
Nota: The scale defines five levels (Explicit → Dubious); the current release contains only Explicit and Implied — the lower three are defined but unused.
Q58coder_name
Coluna de origem: 58.) Name of Coder? · Tipo: Categorical (nominal) · Cobertura: completo
Name of the coder who entered the record (provenance / inter-coder tracking).
Nota: Coder identities are withheld from the public codebook; the field travels only with the full (gated) dataset.
Q59additional_info
Coluna de origem: 59.) Additional Info? · Tipo: Open text · Cobertura: completo
Free-text narrative summary of the engagement (one paragraph per record). Always populated and near-unique to each record; functions as the human-readable description of the row.
Valores: 4,357 distinct narratives across 4,380 records.