data = aq
.from(gbd)
.join(aq.from(wbi), "Code")
.join(aq.from(wbc), "Code")
.derive(
{
Name: aq.escape((d) => codeToName[d["Code"]]),
Code: (d) => d["Code"],
"Income Group": (d) => d["Income group"],
"Depressed Adults": (d) => d["Population"],
"Internet Usage Proportion": (d) => d["Proportion"]
},
{ drop: true }
)
.derive({
"Depressed Adult Internet Users": (d) =>
d["Internet Usage Proportion"] &&
d["Depressed Adults"] * d["Internet Usage Proportion"]
})
.filter((d) => !!d["Depressed Adult Internet Users"])
.filter(
(d) =>
d["Income Group"] === "Low income" ||
d["Income Group"] === "Lower middle income"
)
.objects()