data = aq
.from(wb_data)
.select(aq.not("Series Code", "Country Name"))
.fold(aq.not("Country Code", "Series Name"), { as: ["year"] })
.derive({
series: (d) => aq.op.split(d["Series Name"], " ")[0],
year: (d) => +aq.op.split(d.year, " ")[0]
})
.select(aq.not("Series Name"))
.groupby("Country Code", "year")
.pivot("series", "value")
.join_left(aq.from(country_metadata), ["Country Code", "Code"])
.filter((d) => d.Region)