Paste.InterGen.Online

Untitled

From Anonymous, 9 Hours ago, written in Plain Text, viewed 5 times. This paste will cross the great divide in 3 Weeks.
URL https://paste.intergen.online/view/e3fdc199 Embed
Download Paste or View Raw
  1. IDB INTEGRA evidence and calculations for inward FDI extrema (1990-2022).
  2.  
  3. A) Dashboard/page metadata
  4. 1. INTEGRA page path: https://integra.iadb.org/capital-movements/direct-investment-total
  5. 2. assets/data/pages.json entry for capital-movements/direct-investment-total:
  6. {
  7.   "id": "cba4b06f-87b9-47a0-b8b9-055a0f7d2b27",
  8.   "slug": "direct-investment-total",
  9.   "title": "menu.capital_movements.direct_investment_total",
  10.   "embedded_info": {
  11.     "report_id": "495a97c8-3b00-4532-84aa-6b6549746863",
  12.     "tables": [
  13.       {
  14.         "page_name": "Country-tabla",
  15.         "section_id": "ReportSection981793aa8e90a603915b",
  16.         "table_id": "0bad25dd159c168ae3de",
  17.         "related_chart": "ReportSection211b3ddf9cbda0607002"
  18.       },
  19.       {
  20.         "page_name": "Region-tabla",
  21.         "section_id": "ReportSection345f7a1691ea7e069c0a",
  22.         "table_id": "cc05b20d102919701947",
  23.         "related_chart": "ReportSection6fa5c29a0d9b0858a43e"
  24.       }
  25.     ],
  26.     "translation_tables": [
  27.       "dim_internationalization",
  28.       "Acuerdos",
  29.       "lang_country",
  30.       "Fuentes",
  31.       "Fuentes_bloques"
  32.     ]
  33.   }
  34. }
  35. 3. App JS confirms pages source file:
  36. 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
  37.  
  38. B) Dataset file used (Azure tradedatalake)
  39. Name: datasets/capitalMovement_foreignDirectInvestment.csv
  40. URL: https://saptradedatalake.blob.core.windows.net/tradedatalake-datasets/datasets/capitalMovement_foreignDirectInvestment.csv
  41. Last-Modified: Thu, 16 Oct 2025 16:49:50 GMT
  42. Content-Length: 1570177
  43.  
  44. C) CSV structure/sample (semicolon delimiter, decimal comma in source)
  45. Header: country_code;country_desciption;year;mode_code;mode_label_eng;direction_code;direction_label_eng;us_dollar_current
  46. First 4 data rows:
  47. "UNS";"No informado";1990;8;"Flow";1;"Inward";8,10
  48. "UNS";"No informado";1990;8;"Flow";2;"Outward";2,40
  49. "UNS";"No informado";1990;9;"Stock";1;"Inward";407,63
  50. "UNS";"No informado";1990;9;"Stock";2;"Outward";20,98
  51.  
  52. D) Filter applied for requested indicator
  53. Filter conditions: mode_label_eng == 'Flow'; direction_label_eng == 'Inward'; year in [1990, 2022].
  54. Rows after filter: 6363
  55.  
  56. E) Economic block country composition used for aggregation (ISO-3 country_code values)
  57. CAN: BOL, COL, ECU, PER
  58. CARICOM: ATG, BHS, BRB, BLZ, DMA, GRD, GUY, HTI, JAM, MSR, KNA, LCA, VCT, SUR, TTO
  59. MERCOSUR: ARG, BRA, PRY, URY
  60. NAFTA: CAN, MEX, USA
  61. SICA: BLZ, CRI, SLV, GTM, HND, NIC, PAN, DOM
  62.  
  63. F) Annual-sum extrema by block (USD million)
  64. Columns: block | max_year | max_raw | max_rounded_1dp_half_up | min_year | min_raw | min_rounded_1dp_half_up
  65. CAN | 2012 | 30289.869999999999 | 30289.9 | 1991 | 705.740000000000 | 705.7
  66. CARICOM | 2008 | 7372.100000000000 | 7372.1 | 1990 | 427.690000000000 | 427.7
  67. MERCOSUR | 2011 | 111470.769999999990 | 111470.8 | 1990 | 2937.400000000000 | 2937.4
  68. NAFTA | 2015 | 547405.989999999991 | 547406.0 | 1992 | 28338.540000000001 | 28338.5
  69. SICA | 2017 | 14885.640000000001 | 14885.6 | 1990 | 419.570000000000 | 419.6

Reply to "Untitled"

Here you can reply to the paste above

Powered by Stikked