search

devinit / data-hub-spotlights

Spotlight on Uganda - http://157.245.39.153/spotlight/spotlight-uganda & Spotlight on Kenya - http://157.245.39.153/spotlight/spotlight-kenya
0 stars 0 forks source link

Data inconsistencies for Financing in Uganda #254

Closed edwinmp closed 4 years ago

edwinmp commented 4 years ago

  1. 2006 data is negative (NB: it was this way even on the old data hub)

  2. Sharp decline from 2015 - 2018 (this is because of disparities between budget type data)

  3. Using projected data for 2018 despite having approved data

Perhaps we should get rid of this whole project, actual, proposed data thing. At the very least, we should provide ONLY one for each year i.e if we have projected and get approved data, we replace the projected with the approved. I remember Moses mentioning something along these lines the last time we discussed this @wakibi

NB: Moses implied that there is 2019 data, but it's not in the DB

k8hughes commented 4 years ago

@wakibi please can you update this issue to say what data you have recieved and if it is in process?

edwinmp commented 4 years ago

Fixed the frontend side of this. The line chart is now stable, with only the value of a specific year changing when the budget type is updated. http://161.35.43.45/spotlight/spotlight-uganda

Also for those with multiple budget types, the order of precedence is as follows: actual > approved > proposed > budget > projected

k8hughes commented 4 years ago

@edwinmp what do we need to do next for this issue?

edwinmp commented 4 years ago

Moses pointed out three issues below ... at the very least, if the data is not accurate, we'll need the accurate data. We'd also decided to only have one budget type per year i.e if we have actual data, we get rid of the projected.

  • 2006 data is negative (NB: it was this way even on the old data hub)
  • Sharp decline from 2015 - 2018 (this is because of disparities between budget type data)
  • Using projected data for 2018 despite having approved data
k8hughes commented 4 years ago

Ok so I think this is the part where we need @wakibi to let us know if he got the data from Moses or not.

wakibi commented 4 years ago

Hi @k8hughes , for the budgets I haven't got new data, but also this is part of what Moses will be verifying so we can remove the obsolete data and remain with only one budget type as @edwinmp noted above. I am already working on a script to remove the obsolete data and will run it once Moses confirms what needs to be removed.

wakibi commented 4 years ago

Everything here has been addressed. Moses is happy. Closing issue.