Household Expenditure Currency

[rbroth]

We have a column for household expenditure, but in what currency is it? All local currencies? Converted to US Dollars? Is this even in scope for the project? (@bgsandan and Louise to answer that one)

[bgsandan]

In scope possibly, in terms of currency I will leave that question to the data experts

[kmtang]

These will all be collected in local currencies. I specifically do not need to use this data for my models but it would be good to check with Louise or an economist on the team (Sherwin?) to see whether this household demand data will be needed for their work.

If we plan on using this data, I don't think converting to a standard currency (e.g. USD) would be necessary since costing/cost-effectiveness analyses would be specific to each individual country and presented in that country's local currency (again I could be wrong so probably best to check with Sherwin to see if he needs this). But we will have to adjust for inflation since the data will be coming from surveys taken from different years.

[rbroth]

Looks like I'll need to add a column for "currency used by household", unless we're ok with just doing some spatial joins? I assume that all of the households will always use the currency of the country indicated by their lat-lon coordinates?

I don't think Sherwin has a Github account, can someone walk him through it?

[bgsandan]

I would go with storing the expenditure data (in general storing as much of the original source data is my view - enables more visualisations / filtering in the future - this is a platform with the intention to evolve over time!).

Adding a column for local currency though seems a sensible addition to give context when amalgamating multiple surveys into a single table

[rbroth]

Cool, action on me to:

• [ ] add column "local_currency" to "household" table. Comment: "Holds the currency used by that household to buy goods and services"