IDB INTEGRA evidence and calculations for inward FDI extrema (1990-2022).

A) Dashboard/page metadata
1. INTEGRA page path: https://integra.iadb.org/capital-movements/direct-investment-total
2. assets/data/pages.json entry for capital-movements/direct-investment-total:
{
  "id": "cba4b06f-87b9-47a0-b8b9-055a0f7d2b27",
  "slug": "direct-investment-total",
  "title": "menu.capital_movements.direct_investment_total",
  "embedded_info": {
    "report_id": "495a97c8-3b00-4532-84aa-6b6549746863",
    "tables": [
      {
        "page_name": "Country-tabla",
        "section_id": "ReportSection981793aa8e90a603915b",
        "table_id": "0bad25dd159c168ae3de",
        "related_chart": "ReportSection211b3ddf9cbda0607002"
      },
      {
        "page_name": "Region-tabla",
        "section_id": "ReportSection345f7a1691ea7e069c0a",
        "table_id": "cc05b20d102919701947",
        "related_chart": "ReportSection6fa5c29a0d9b0858a43e"
      }
    ],
    "translation_tables": [
      "dim_internationalization",
      "Acuerdos",
      "lang_country",
      "Fuentes",
      "Fuentes_bloques"
    ]
  }
}
3. App JS confirms pages source file:
Init=function(){this.sections$=this.reportService.getPages()},t}(),zt=n("t/Na"),qt=function(){function t(t){this.http=t,this.jsonUrl="./assets/data/pages.json"}return t.prototype.getPages=function(){return this.http.get(this.jsonUrl)},t.ngI

B) Dataset file used (Azure tradedatalake)
Name: datasets/capitalMovement_foreignDirectInvestment.csv
URL: https://saptradedatalake.blob.core.windows.net/tradedatalake-datasets/datasets/capitalMovement_foreignDirectInvestment.csv
Last-Modified: Thu, 16 Oct 2025 16:49:50 GMT
Content-Length: 1570177

C) CSV structure/sample (semicolon delimiter, decimal comma in source)
Header: country_code;country_desciption;year;mode_code;mode_label_eng;direction_code;direction_label_eng;us_dollar_current
First 4 data rows:
"UNS";"No informado";1990;8;"Flow";1;"Inward";8,10
"UNS";"No informado";1990;8;"Flow";2;"Outward";2,40
"UNS";"No informado";1990;9;"Stock";1;"Inward";407,63
"UNS";"No informado";1990;9;"Stock";2;"Outward";20,98

D) Filter applied for requested indicator
Filter conditions: mode_label_eng == 'Flow'; direction_label_eng == 'Inward'; year in [1990, 2022].
Rows after filter: 6363

E) Economic block country composition used for aggregation (ISO-3 country_code values)
CAN: BOL, COL, ECU, PER
CARICOM: ATG, BHS, BRB, BLZ, DMA, GRD, GUY, HTI, JAM, MSR, KNA, LCA, VCT, SUR, TTO
MERCOSUR: ARG, BRA, PRY, URY
NAFTA: CAN, MEX, USA
SICA: BLZ, CRI, SLV, GTM, HND, NIC, PAN, DOM

F) Annual-sum extrema by block (USD million)
Columns: block | max_year | max_raw | max_rounded_1dp_half_up | min_year | min_raw | min_rounded_1dp_half_up
CAN | 2012 | 30289.869999999999 | 30289.9 | 1991 | 705.740000000000 | 705.7
CARICOM | 2008 | 7372.100000000000 | 7372.1 | 1990 | 427.690000000000 | 427.7
MERCOSUR | 2011 | 111470.769999999990 | 111470.8 | 1990 | 2937.400000000000 | 2937.4
NAFTA | 2015 | 547405.989999999991 | 547406.0 | 1992 | 28338.540000000001 | 28338.5
SICA | 2017 | 14885.640000000001 | 14885.6 | 1990 | 419.570000000000 | 419.6