The approach to evaluating public policies based on the rational model, with an emphasis on policy performance and results, is widely used in academia and contemporary governments. Below, we present the application of the input-output model, a traditional approach in public policy analysis and business administration, to assess the efficiency of Brazilian spending abroad, creating a quantitative measure for evaluating the country’s diplomatic representations.
The method chosen to assess the performance of Brazilian diplomatic representations is Data Envelopment Analysis (DEA). The method is used to estimate efficiency based on the comparison between similar units (DMUs – Decision Making Units), consuming similar resources (inputs) to produce the same products or results (outputs). In our case, the DMUs are the diplomatic representations of Brazil abroad, structuring the panel data by country and year.
Different types of DEA models have been developed in the literature to address different assumptions, data structures, and research objectives. Since our data structure is panel data, we apply the Dynamic DEA model, which was developed for this type of data structuring. Dynamic DEA allows the evaluation of efficiency in systems where past decisions affect future performance by modeling intertemporal dependencies (e.g., current diplomatic investments impact future bilateral relations).
The fundamental output of the proposed evaluation model is the Foreign Policy Index (FPI), assuming the objective of Brazilian foreign policy to increase or maintain engagement with countries. On the input side, we used expenditures on diplomatic representations, expenditures on diplomatic personnel, and the number of diplomatic staff assigned to the country’s diplomatic representations. The time series covers 2013 to 2022, 110 countries. Below we present the results of the diplomatic efficiency index created by the dynamic DEA analysis, ranging from 0 to 1, where 1 is the highest relative efficiency.
Below we present the dynamic map with the diplomatic efficiency index data for the entire time series. Countries in white on the map do not have data (they generally do not have diplomatic representations or have had relations suspended with Brazil). The more intense the color on the map below, the greater the efficiency of the diplomatic representations in the country.
Next, we make the efficiency index data available in a spreadsheet for download. At the end of this page you will find the disaggregated data for replicating the DEA analysis, with the codes in R and a dynamic bar map to visualize the data according to the available filters.
Dynamic Map of the Diplomatic Efficiency Index
Below we present the table with the diplomatic efficiency index for download and use of the data reported in the dynamic map above.
| wdt_ID | wdt_created_by | wdt_created_at | wdt_last_edited_by | wdt_last_edited_at | country | year | efficiency_index | isoa3 |
|---|---|---|---|---|---|---|---|---|
| 1176 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Angola | 2013 | 0.042 | AGO |
| 1177 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Albania | 2013 | 0.398 | ALB |
| 1178 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | United Arab Emirates | 2013 | 0.062 | ARE |
| 1179 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Argentina | 2013 | 0.951 | ARG |
| 1180 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Armenia | 2013 | 1.000 | ARM |
| 1181 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Australia | 2013 | 0.040 | AUS |
| 1182 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Austria | 2013 | 0.042 | AUT |
| 1183 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Azerbaijan | 2013 | 0.203 | AZE |
| 1184 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Belgium | 2013 | 0.038 | BEL |
| 1185 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Bangladesh | 2013 | 0.150 | BGD |
| 1186 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Bulgaria | 2013 | 0.198 | BGR |
| 1187 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Bahamas | 2013 | 0.310 | BHS |
| 1188 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Bosnia and Herzegovina | 2013 | 0.334 | BIH |
| 1189 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Belarus | 2013 | 0.342 | BLR |
| 1190 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Belize | 2013 | 1.000 | BLZ |
| 1191 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Bolivia | 2013 | 0.354 | BOL |
| 1192 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Barbados | 2013 | 1.000 | BRB |
| 1193 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Botswana | 2013 | 0.570 | BWA |
| 1194 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Canada | 2013 | 0.078 | CAN |
| 1195 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Switzerland | 2013 | 0.099 | CHE |
| 1196 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Chile | 2013 | 0.807 | CHL |
| 1197 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | China | 2013 | 1.000 | CHN |
| 1198 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Cameroon | 2013 | 0.187 | CMR |
| 1199 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Congo | 2013 | 0.271 | COG |
| 1200 | pedrofeliu | 30/06/2025 10:43 | pedrofeliu | 30/06/2025 10:43 | Colombia | 2013 | 0.809 | COL |
| wdt_ID | wdt_created_by | wdt_created_at | wdt_last_edited_by | wdt_last_edited_at | Variable | Description |
|---|---|---|---|---|---|---|
| 1 | pedrofeliu | 10/10/2024 12:00 | pedrofeliu | 30/06/2025 15:55 | country | Name of the country |
| 2 | pedrofeliu | 10/10/2024 12:00 | pedrofeliu | 30/06/2025 15:55 | year | Year |
| 3 | pedrofeliu | 10/10/2024 12:00 | pedrofeliu | 30/06/2025 15:56 | efficiency_index | Diplomatic Efficiency Index estimated with Dynamic DEA |
| 4 | pedrofeliu | 10/10/2024 12:00 | pedrofeliu | 30/06/2025 15:56 | isoa3 | ISO 3 Country Code |
Feliu Ribeiro, P. (2024). POLEN (v1.01) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14015246. Avaiable at: polen.iri.usp.br
Dynamic Bar Chart Diplomatic Efficiency Index
Use the filters below to manipulate the bar chart above, colored by the “efficieny index” variable
Disaggregated data from the Diplomatic Efficiency Index
| country | year | efficiency_index | isoa3 | fpi | funcionarios | embaixada | salario | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| wdt_ID | wdt_created_by | wdt_created_at | wdt_last_edited_by | wdt_last_edited_at | country | year | efficiency_index | isoa3 | fpi | funcionarios | embaixada | salario |
| 1 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Angola | 2013 | 0.042 | AGO | 0.67 | 25 | 8,488,249 | 370,276 |
| 2 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Albania | 2013 | 0.398 | ALB | 0.50 | 13 | 1,825,440 | 162,483 |
| 3 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | United Arab Emirates | 2013 | 0.062 | ARE | 0.61 | 9 | 5,262,340 | 136,021 |
| 4 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Argentina | 2013 | 0.951 | ARG | 0.99 | 101 | 39,594,851 | 1,541,041 |
| 5 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Armenia | 2013 | 1.000 | ARM | 0.24 | 5 | 1,566,443 | 71,210 |
| 6 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Australia | 2013 | 0.040 | AUS | 0.72 | 23 | 12,304,439 | 433,296 |
| 7 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Austria | 2013 | 0.042 | AUT | 0.72 | 17 | 10,684,537 | 348,646 |
| 8 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Azerbaijan | 2013 | 0.203 | AZE | 0.30 | 7 | 2,177,042 | 102,542 |
| 9 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Belgium | 2013 | 0.038 | BEL | 0.78 | 45 | 24,745,206 | 858,459 |
| 10 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Bangladesh | 2013 | 0.150 | BGD | 0.37 | 4 | 2,815,679 | 86,545 |
| 11 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Bulgaria | 2013 | 0.198 | BGR | 0.65 | 6 | 2,365,279 | 77,632 |
| 12 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Bahamas | 2013 | 0.310 | BHS | 0.59 | 4 | 2,593,368 | 57,011 |
| 13 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Bosnia and Herzegovina | 2013 | 0.334 | BIH | 0.14 | 4 | 2,179,743 | 59,357 |
| 14 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Belarus | 2013 | 0.342 | BLR | 0.63 | 3 | 2,274,192 | 59,085 |
| 15 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Belize | 2013 | 1.000 | BLZ | 0.69 | 3 | 2,098,870 | 32,847 |
| 16 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Bolivia | 2013 | 0.354 | BOL | 0.90 | 55 | 22,188,575 | 155,126 |
| 17 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Barbados | 2013 | 1.000 | BRB | 0.70 | 2 | 2,793,569 | 27,425 |
| 18 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Botswana | 2013 | 0.570 | BWA | 0.42 | 6 | 1,760,771 | 73,274 |
| 19 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Canada | 2013 | 0.078 | CAN | 0.82 | 128 | 28,301,663 | 1,630,091 |
| 20 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Switzerland | 2013 | 0.099 | CHE | 0.83 | 63 | 57,927,900 | 1,283,439 |
| 21 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Chile | 2013 | 0.807 | CHL | 0.97 | 16 | 22,364,087 | 332,340 |
| 22 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | China | 2013 | 1.000 | CHN | 1.00 | 58 | 70,307,946 | 1,121,159 |
| 23 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Cameroon | 2013 | 0.187 | CMR | 0.63 | 5 | 2,398,407 | 79,585 |
| 24 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Congo | 2013 | 0.271 | COG | 0.52 | 5 | 2,592,635 | 60,086 |
| 25 | pedrofeliu | 30/06/2025 11:13 | pedrofeliu | 30/06/2025 11:13 | Colombia | 2013 | 0.809 | COL | 0.96 | 33 | 9,772,420 | 579,039 |
| Variable Name | Description | |||||
|---|---|---|---|---|---|---|
| wdt_ID | wdt_created_by | wdt_created_at | wdt_last_edited_by | wdt_last_edited_at | Variable Name | Description |
| 1 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | country | Country name in English |
| 2 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | year | Year |
| 3 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | efficiency_index | Diplomatic Efficiency Index estimated via dynamic DEA |
| 4 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | isoa3 | ISO 3 country code |
| 5 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | fpi | Foreign Policy Index |
| 6 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | employees | Number of diplomatic staff (sum) in the country |
| 7 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | embassy | Expenditure in reais deflated in diplomatic representations by country (sum) |
| 8 | pedrofeliu | 30/06/2025 16:01 | pedrofeliu | 30/06/2025 16:01 | salary | Expenditure in reais deflated of the salaries of diplomatic staff in diplomatic representations by country (sum) |
Feliu Ribeiro, P. (2024). POLEN (v1.01) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.14015246. Avaiable at: polen.iri.usp.br