What the database records, how each entry was coded, how confident we are in it, and how the releases have evolved. Variable definitions are given in English, the language of the coding sheet.
Current release
1.6Version
14,848Entries
34Country datasets
34Country profiles
2Regions
22 June 2026First published
CC BY 4.0Licence
10.5281/zenodo.22976211DOI
Release history
Version
Date
Coverage
What changed
1.6
26 September 2026
34 datasets · 14,848 entries · 2 regions
Leader-name standardisation: eight leaders recorded under two spellings are merged to one canonical spelling each (29 cells in the master; e.g. Kumba Yalá → Kumba Iala, Hannah Tetteh → Hanna Tetteh), so the published data now counts 578 distinct leaders. No other values change. Codebook v5.2. The website adds an Insights page, a Releases page and, for registered users, a Leaders section: a profile page for every leader, a leader comparison view and CSV / Excel downloads of each leader's records.
1.5
22 September 2026
34 datasets · 14,848 entries · 2 regions
Reconciliation of the team-coded West Africa cleaned master (413 new records, 588 enrichments and corrections to existing ones) and the West Africa COLT completeness closure. The published site is refocused on the two systematically coded regions — Eastern and Western Africa, 34 states; the master workbook retains the other regions outside the published scope. Codebook v5.1.
1.4
4 September 2026
46 datasets · 19,293 entries · 5 regions
Continental consolidation: the Northern, Southern and Central Africa modules join the file, every state is now systematically coded, and the whole dataset is cross-verified against the COLT corpus. The file grows from 4,382 to 19,293 entries; all 46 states gain a full country profile; codebook v5.0.
1.3
2 September 2026
46 datasets · 4,382 entries · 5 regions
Same rows as 1.2. The machine-readable codebook is republished without coder identities; the website gained the Data & Methods page, the accessibility statement, embeddable cards and charts, and a Zenodo DOI in every citation.
1.2
24 August 2026
46 datasets · 4,382 entries · 5 regions
Dataset-wide normalisation of labels, names and venues; semantic vetting passes closed; ten incidentally coded groups added as map-only datasets.
1.1
17 August 2026
36 datasets · 4,361 entries · 5 regions
Second team-form import: 677 submitted rows, 495 accepted after de-duplication and re-orientation of inbound entries.
1.0
22 June 2026
—
First public release of the database and the interactive map.
What the database records
Each row is one international engagement — an in-person visit, a phone call or a video conference — by a head of state, head of government or foreign minister of an African country, between 1990 and 2025. An engagement is described by 59 variables in eight blocks: identification of the actor, the event itself, delegation and counterparts, activities on the margins, the substance of discussions, agreements signed, the lifecycle of those agreements, and assessment, sourcing and provenance.
Public and gated fields
The interactive map, the country profiles and the downloadable data.json carry every field except four: the coders' free-text notes, the coder's identity, the evidential confidence rating and the source URLs. Those travel with the full dataset, which registered users obtain from the Archive; they are withheld from the public copy to protect coders and to keep source links from being scraped out of context.
Coding conventions
Dates — stored as text in US month-first order, MM/DD/YYYY; every engagement start and end date is well-formed.
Missing values — a blank cell means not applicable or not recorded; in the conditional “If yes…” fields a blank is the expected value when the governing yes/no gate is “No”. The literal text “N/A” marks records with no agreement in the agreement-lifecycle fields.
Gates and skip logic — many fields are yes/no gates that govern dependent fields: when the gate is “Yes” the companion fields are populated; when “No” they are left blank.
Multi-select fields — discussion topics hold one or more categories from a controlled vocabulary, comma-separated in a single cell; split on the comma to tabulate them.
Confidence and provenance — every record carries an evidential confidence rating and at least one source URL (up to five), plus the coder's name and the coding date.
External cross-validation
As the fifth and final stage of the coding workflow, our findings are cross-checked against the independent Country and Organization Leader Travel (COLT) dataset of the Frederick S. Pardee Institute for International Futures (University of Denver): overlapping records are compared trip by trip, every discrepancy is re-examined against the original sources, and confirmed corrections are folded back into the database before release.
Moyer, Jonathan D., Collin J. Meisel, Austin S. Matthews, Whitney Doran, Andrew Scott, Marianne Hughes, Anjali T. Martin, Alexandra Kurkul, and Kylie McKee. 2024. “Country and Organization Leader Travel (COLT) Codebook.” Version 2.6. Frederick S. Pardee Institute for International Futures, Josef Korbel School of International Studies, University of Denver, Denver, CO.
Confidence scale
A five-level ordinal scale grading the evidential basis of a record. The current release uses only the two highest levels — Explicit (10,041 records) and Implied (4,807) in the v5.2 profile; the lower three are defined for completeness and are not used.
Level
Meaning
Explicit
The fact is directly and unambiguously stated in a source.
Implied
Strongly supported by, but not literally stated in, the source(s).
Assumed
Inferred from context / standard practice without direct evidence.
Guessed
Low-evidence best estimate.
Dubious
Recorded but of doubtful reliability; flagged for review.
Discussion-topic vocabulary
The 22 categories observed, with the number of records in which each appears in the v5.2 profile (a record may carry several).
Category
Records
Diplomacy and Foreign Relations
14,274
Regional Organizations and Multilateral Affairs
7,342
Trade and Economic Relations
2,765
Security and Defense
652
Development and Aid
513
International Conflicts and Crises
398
Peace and Security
134
Peace Negotiations and Mediation
129
Symbolic and Ceremonial Issues
122
Environment and Climate Change
115
Financial and Monetary Issues
95
Infrastructure and Connectivity
93
Energy
86
Terrorism and Counterterrorism
59
Human Rights and Governance
56
Education and Culture
55
Health
54
Agriculture and Food Security
43
Maritime and Territorial Issues
30
Domestic Political Matters
20
Migration and Human Mobility
17
Science, Technology and Innovation
15
Agreement families
Signed agreements are classified into four families, each with its own type field. The type vocabularies are data-derived and grow with the file.
High-level politics (treaty-level): Peace, Alliance, Boundary, Establishment and Accession treaties.
Economics: Investment Treaty, Economic Partnership Agreement, Trade Agreement, Tax Treaty, and finance/energy variants such as Development Finance or Loan Agreement.
All 59 variables in worksheet order, grouped in eight blocks. The Q-number is the questionnaire number in the column header; the short name is the machine-readable field name. Coverage and value counts are from the v5.2 profile of 14,848 records.
Block A — Identification & Actor (Q1–Q4)4 variables
Macro-region of Africa under which the home actor is classified. The published database covers the two systematically coded regions: Eastern Africa (nineteen states, Somaliland included) and Western Africa (the full fifteen-member ECOWAS belt) — thirty-four home states in total.
Sovereign state (or de facto state) the travelling / engaging leader represents (the sending actor). Thirty-four home actors across the two regions, all systematically coded.
Official office held by the home actor at the time of the engagement. Free office label drawn from an open list; 31 distinct values clustering on heads of state/government and senior ministers.
President12,907Foreign Minister906Prime Minister742Head of State91Deputy Prime Minister & Foreign Minister45Defence Minister34Finance Minister31Vice-President15
Note: All 31 distinct office labels are listed; the tail comprises single- to triple-count ministerial and military-chief titles.
Q4leader_name
Source column: 4.) Leader's Name? · Type: Open text · Coverage: complete
Personal name of the home actor. High-cardinality identifier (578 distinct individuals across the period).
Counterpart / host country of the engagement (destination of a visit, or the country of the interlocutor for a call or video conference).
Values: 157 distinct. Most frequent: United States of America (1,574), France (740), Nigeria (678), Ethiopia (673), South Africa (497), Tanzania (407), Kenya (394), United Kingdom of Great Britain and Northern Ireland (358), Ghana (352), Côte d'Ivoire (352), Senegal (335), Libya (334).
Note: Country labels use long-form controlled values (e.g. “Russian Federation”, “Türkiye”, “United Kingdom of Great Britain and Northern Ireland”).
City in which the engagement took place (for calls, typically the interlocutor’s seat).
Values: 397 distinct. Most frequent: New York (1,182), Paris (669), Addis Ababa (667), Abuja (647), Nairobi (389), Washington (378), Accra (351), Abidjan (344), Dar es Salaam (340), Dakar (335), London (319), Beijing (304).
Whether another head of government/state from the home country travelled together with the actor (joint travel).
No14,827Yes21
Q11meet_host_hogs
Source column: 11.) Meet with Host Country HoG/S? · Type: Binary (Yes / No) · Coverage: complete
Whether the actor met the host country’s head of government/state.
No9,073Yes5,775
Q12host_hogs_name
Source column: 12.) If Yes, Name? (Title First Name Last Name) · Type: Open text · Coverage: 5,775 valid / 9,073 missing
Name (with title) of the host head of government/state met. Conditional on Q11 = Yes (skip otherwise).
Values: 831 distinct, e.g. Brotherly Leader and Guide of the Revolution Muammar al-Qaddafi (168), President Emmanuel Macron (130), President Yoweri Museveni (107), President Omar al-Bashir (99), President Jacques Chirac (83), President Paul Kagame (83).
Q13meet_host_subhogs
Source column: 13.) Met With Host-country Sub-HoG/S Equivalent? · Type: Binary (Yes / No) · Coverage: complete
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.
No14,498Yes350
Q14host_subhogs_name
Source column: 14.) If Yes, Name? (Title First Name Last Name) · Type: Open text · Coverage: 350 valid / 14,498 missing
Name (with title) of the host-country sub-HoG/S counterpart met. Conditional on Q13 = Yes.
Values: 249 distinct, e.g. Foreign Minister Sergey Lavrov (16), Foreign Minister Wang Yi (13), Premier Li Keqiang (11), Prime Minister Narendra Modi (9), Foreign Minister Hakan Fidan (8).
Q15summit_attend
Source column: 15.) Attend a Multilateral Summit or Event? · Type: Binary (Yes / No) · Coverage: complete
Whether the engagement included attendance at a multilateral (heads-level) summit or event.
No7,437Yes7,411
Q16summit_name
Source column: 16.) If Yes, Name of Summit or Event? · Type: Open text · Coverage: 7,411 valid / 7,437 missing
Name of the multilateral summit/event attended. Conditional on Q15 = Yes.
Values: 2,329 distinct, e.g. African Union (AU) Summit (642), Economic Community of West African States (ECOWAS) Summit (599), Southern African Development Community (SADC) Summit (182), Organization of African Unity (OAU) Summit (122), Common Market for Eastern and Southern Africa (COMESA) Summit (97).
Q17min_summit_attend
Source column: 17.) Attend a Multilateral Ministerial Event or Summit? · Type: Binary (Yes / No) · Coverage: complete
Whether the engagement included a multilateral event at ministerial (sub-heads) level.
No14,732Yes116
Q18min_summit_name
Source column: 18.) If Yes, Name of Summit or Event? · Type: Open text · Coverage: 116 valid / 14,732 missing
Name of the ministerial multilateral event. Conditional on Q17 = Yes.
Values: 102 distinct, e.g. Foreign Minister Wang Yi (6), Trilateral Talks on the Grand Ethiopian Renaissance Dam (GERD) Ethiopia–Sudan–Egypt Foreign Ministers’ Meeting (4), Ethiopia–Egypt–Sudan GERD Negotiations (3), A joint ministerial commission (2).
Whether the actor delivered a public address / speech during the engagement.
No12,659Yes2,189
Q22cultural_site_visit
Source column: 22.) Visit/Address Cultural/Historical/Religious Site or Event? · Type: Binary (Yes / No) · Coverage: complete
Whether the engagement included a visit to, or address at, a cultural, historical or religious site or event.
No12,719Yes2,129
Q23business_leaders_meet
Source column: 23.) Meet with Business Leaders? · Type: Binary (Yes / No) · Coverage: complete
Whether the actor met business / private-sector leaders.
No14,097Yes751
Q24io_leader_meet
Source column: 24.) Meet with Leader of Int'l Organization? · Type: Binary (Yes / No) · Coverage: complete
Whether the actor met the head of an international organisation.
No14,360Yes488
Q25io_leader_name
Source column: 25.) If Yes, Name? (Title First Name Last Name) · Type: Open text · Coverage: 488 valid / 14,360 missing
Name (with title/organisation) of the international-organisation leader met. Conditional on Q24 = Yes.
Values: 184 distinct, e.g. United Nations (UN) Secretary-General Ban Ki-moon (51), United Nations (UN) Secretary-General Kofi Annan (47), European Council President Charles Michel (32), United Nations (UN) Secretary-General Antonio Guterres (29).
Block E — Substance of Discussions (Q26)1 variables
One or more thematic categories describing what was discussed. Stored as a comma-separated list drawn from a controlled vocabulary of 22 categories (full list and frequencies in §6.1).
Values: 539 distinct combinations of the 22 base categories. Most frequent single category: Diplomacy and Foreign Relations (present in 14,274 records).
Block F — Agreements Signed (Q27–Q43)17 variables
Q27agreement_signed
Source column: 27.) Signed an Agreement? · Type: Binary (Yes / No) · Coverage: complete
Master gate: whether any agreement was signed during the engagement. Opens the four agreement-family blocks (Q28–Q42).
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.
No14,557Yes291
Q29agr_hlp_type
Source column: 29.) If Yes, What Type of High-level Politics (treaty-level) Agreement? · Type: Categorical (nominal) · Coverage: 291 valid / 14,557 missing
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.
Source column: 30.) Title of Agreement? · Type: Open text · Coverage: 32 valid / 14,816 missing
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
Source column: 31.) Specific Notes? · Type: Open text · Coverage: 252 valid / 14,596 missing
Free-text notes on the high-level political instrument (scope, signing context, dates).
Whether a technical/administrative agreement was signed.
No14,740Yes108
Q41agr_tech_type
Source column: 41.) If Yes, What Type of Technical or Administrative-related Agreement? · Type: Categorical (nominal) · Coverage: 108 valid / 14,740 missing
Sub-type of the technical/administrative agreement. Conditional on Q40 = Yes.
Memoranda of Understanding84Administrative Agreement19Technical Cooperation Agreement5
Q42agr_tech_title
Source column: 42.) Title of Agreement? · Type: Open text · Coverage: 42 valid / 14,806 missing
Title of the technical/administrative agreement. Conditional on Q40 = Yes.
Q43agr_tech_notes
Source column: 43.) Specific Notes? · Type: Open text · Coverage: 98 valid / 14,750 missing
Free-text notes on the technical/administrative agreement.
Block G — Agreement Lifecycle / Status (Q44–Q49)6 variables
Q44status_provisional
Source column: 44.) Still in the Provisional Status? · Type: Categorical (nominal) · Coverage: complete
Whether a signed agreement remains provisional (not yet entered into force). “N/A” marks records with no agreement.
N/A14,716No129Yes3
Q45provisional_sig_date
Source column: 45.) If Yes, Signature Day? · Type: Date (MM/DD/YYYY) · Coverage: 3 valid / 14,845 missing
Signature date of a provisional agreement (MM/DD/YYYY). Sparsely populated.
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.
Explicit10,041Implied4,807
Note: The scale defines five levels (Explicit → Dubious); the current release contains only Explicit and Implied — the lower three are defined but unused.
Q58coder_name
Source column: 58.) Name of Coder? · Type: Categorical (nominal) · Coverage: complete
Name of the coder who entered the record (provenance / inter-coder tracking).
Note: Coder identities are withheld from the public codebook; the field travels only with the full (gated) dataset.
Q59additional_info
Source column: 59.) Additional Info? · Type: Open text · Coverage: complete
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.
Values: 14,832 distinct narratives across 14,848 records.
Leader names
Each leader carries one canonical spelling. A whole-file review found eight leaders recorded under two spellings (for example Kumba Yalá and Kumba Iala, Hannah and Hanna Tetteh); release 1.6 merges them to the spelling most records already used, unless that spelling was incomplete or wrong. The list of variants is kept with the dataset and applied automatically to every later import, so the duplicates cannot return. Names of counterparts met (free-text fields) are left as recorded.
Leader profiles and biographies
Every leader has a profile page built from the dataset: all recorded engagements, destinations, topics and signed agreements. The short biography and portrait on each profile (and in the Map's biography balloon) are resolved once, when the site is built, from Wikipedia and Wikidata:
An article is accepted only if its opening sentence names the leader, it refers to the leader's country, and Wikidata identifies its subject as a person — articles about offices or events are rejected.
The text is the article in the reader's language (English, French or Portuguese) when one exists; otherwise the English article is shown and the page says so. Text is quoted under Wikipedia's CC BY-SA 4.0 licence with a link to the article.
Portraits come only from Wikimedia Commons, which holds freely licensed files; each is shown with its author and licence. Flags, coats of arms, maps, logos, signatures, and images of places or groups are excluded, as are images Wikipedia uses under “fair use”.
Where no encyclopedia entry exists, the profile describes the official from the LEAD data alone and shows initials instead of a photo. Wrong matches can be corrected by hand in a reviewed corrections list.
The Leaders section — the profiles, the Leaders index, Compare leaders and the leader downloads — is available to registered users who sign in and enter the Leaders access code provided by the Africa Foundation. The Map, the country profiles, Regions and Insights remain open to everyone.
How the Insights are counted
Every figure on the Insights page is computed from the published dataset each time the site is built, including the words describing a trend (rose, fell, stayed close to). The counting unit is one destination of one engagement, as on the Map; partner groups (Africa, Europe, the Gulf states and others) are defined on that page.
Known limitations
The database covers Eastern and Western Africa only: the nineteen-state Eastern-Africa module and the full fifteen-member ECOWAS belt, systematically coded to the same standard.
Only the two highest confidence levels occur; Assumed, Guessed and Dubious are defined but unused.
The agreement-lifecycle dates (signature, ratification, entry into force) are populated only for the few agreements that reached those stages.
Sourcing leans on open web records: Wikipedia trip lists, AFP and UN documents are the most-cited domains; each record nevertheless carries its own source link.
A handful of label variants survive (for example singular and plural forms of “Memorandum of Understanding”); they are normalised release by release.
Download the data
The public dataset is archived on Zenodo: download release 1.6 (data, machine-readable codebook and licence in one bundle), or use the all-versions DOI, which always resolves to the newest release. The full row-level dataset with sources remains available to registered users in the Archive. Registered users can also download every leader's records as CSV or Excel with the same public columns; the Releases page lists every version.
Document control
This page is generated from codebook v5.2, itself produced by automated column-by-column profiling of the published Eastern and Western Africa dataset in the source workbook (SHA-256 c210045d…). The codebook is re-issued whenever the source file changes; the live database currently holds 14,848 entries.
Cite and reuse
The database is licensed CC BY 4.0. Cite it with the reference on the About page; work that uses it is listed under Outputs.