search

codeforIATI / iati-ideas

💡 Ideas for new codeforIATI projects and blogs
https://ideas.codeforiati.org
0 stars 0 forks source link

[IDEA] Visualise budget data from multiple org files (e.g. budgets for a given recipient country) #12

Open andylolz opened 4 years ago

andylolz commented 4 years ago

Rationale

IATI Decipher is a cool idea, but it:

  1. requires installation of a browser plugin, and
  2. can only visualise data for a single organisation at a time.

It would be useful to be able to visualise data from multiple org files. This would enable us to e.g. produce a graph of annual budgets for Somalia from all donors.

Proposal

This would require a server side component, since all org files need to be parsed and stored in order to present data across donors.

matmaxgeds commented 4 years ago

Keen to help with this - also because I am in the middle of doing this manually (non IATI) for 2019, so could have a second data source to compare with e.g. to work out double counting.

I also think this (starting with org file budgets) would be a great test case for 'IATI on spreadsheets'.

andylolz commented 4 years ago

Great! In fact, @markbrough mentioned:

I wonder if this is something aid on spreadsheets could also do

andylolz commented 4 years ago

Keen to help with this - also because I am in the middle of doing this manually (non IATI) for 2019, so could have a second data source to compare with e.g. to work out double counting.

^^ Re-read this and realised it is super cool as it demonstrates a clear need.

Also, important that you mention double counting as I guess it’s likely to be a big issue here.

matmaxgeds commented 4 years ago

:) I guess one approaches to double counting is to rely on IATI publishers to indicate which org the funds flow too, and if it is too another org who you are also using data from, then discard, we could see how that compares to my comparative numbers. Of course it is easier if you also don't have hard and fast rules on who needs to be attributed as the provider e.g. just focus on totals rather than which org gave X much to Somalia. Known issues after that include missing data e.g. WB Trust Funds not reported, non reporters in general, and funds that leave the donor in one year, but only spent a year or two later (probs minor) etc. But I think worth an initial shot - even if just for a subset of publishers.