Help request - FTS vs .......for humanitarian data


(Matt Geddes) #1

Hi,

In Somalia we are making IATI data available within the government AIMS for data entry users to import projects published via IATI, rather than re-typing out all of the data.

When we scoped the project back in 2015, OCHA was publishing FTS data to IATI e.g. see here but this seems to have stopped in 2015?

Does anyone know what we are missing? Has it restarted somewhere else? OCHA in Mogadishu are suggesting using OPS data but as far as we know that is just excel sheets and not published to IATI…help!

Of course we can also get humanitarian data from all the individual organisations, but FTS is (was) great because it used the locally recognised project names, sorted out the duplication etc

Thanks a lot,

Matt


(Matt Geddes) #2

Tumbleweed…can anyone recommend any contacts? We are talking to the OCHA country office, but it would be good to know who at HQ is switched on with regard to IATI so we can connect them? Does the secretariat have a go-to person?

I also now see that that OCHA publishes under five different entities:
XM-IATI-OCHASDC
XM-OCHA-CERF
XM-OCHA-CBPF
XM-OCHA-FTS
XM-DAC-41127

Of which some are primary publishers and some secondary, they are based in different countries…it would be great to talk to someone about how these different publishing entities relate to each-other, and to humanitarian support (in Somalia) in general.

tagging @elbayar @ximboden as they both represented OCHA on these forums in the past.


(Mark Brough) #3

Also tagging @david_megginson in case he can help flag this query to the right person!


(David Megginson) #4

The UN Secretariat does not have a single IATI go-to person right now, but we’re talking about that inside OCHA. You might as well reach out to me, and I can try to answer any questions or direct them to the right person.

Yes, FTS stopped republishing IATI data in 2015, I think, because of concerns about duplicate reporting (some of the orgs they were republishing were also publishing directly). The financial data is still available via FTS’s API, and you can find a lot of individual project information there (much more than used to be in OPS): https://api.hpc.tools/docs/v1/

CERF and CBPF are pooled funds that OCHA manages on behalf of the humanitarian community. They exist because during a humanitarian emergency, there needs to be money available right away, without waiting for fundraising and earmarked donor grants.

CERF (Central Emergency Response Fund) is an unearmarked fund that many donors contribute to, and it’s used to help with underfunded emergencies in any country where there’s a need. Donors pay in without knowing where or how the money will be spent.

CBPF (Country-Based Pooled Funds) are a collection of lightly-earmarked funds that donors contribute to, and they’re used to help fund activities/projects in specific countries as the need arises. Donors pay in knowing where the money will be spent, but not how it will be spent.

While OCHA reports on these funds, neither of them is actually OCHA’s money, per se. The funds are intermediaries between the donors and the implementing orgs or agencies, and they can make IATI traceability very challenging (it’s like trying to the trace the origin of a cup of water you pull out of the ocean).


(David Megginson) #5

Following up on the API, here are all the humanitarian response plans (formerly, “appeals”) for Somalia:

https://api.hpc.tools/v1/public/plan/country/som

The code for the Somalia 2019 HRP is “HSOM19”. Knowing that, we can get a list of projects:

https://api.hpc.tools/v1/public/project/plancode/HSOM19

Checking right now, there are 561 Somalia 2019 projects listed in the JSON, with funding info (some additional projects are redacted for privacy/security concerns, and don’t appear in the public listing).

I hope this is helpful. I’d love to see those projects available as IATI some day.


(Matt Geddes) #6

thanks @David_Megginson for setting this all out.

So we know what we are now missing out on, do you know if there a way to identify what projects in FTS are not also reported under CERF or CBPFs? As if that was significant, then we would have to think again about supporting the FTS API.

We would also be very keen to support efforts to restart the FTS publishing data to IATI - let us know if there is any way we can help? We are already telling the country office staff who are therefore now responsible for doing manual entry (without IATI) that they need to make themselves heard.

FTS was always listed as a secondary publisher so I don’t understand how the double reporting can be an issue - especially given the scale of it elsewhere in IATI - plus it also applies to CERF/CBPFs as donors report their core contributions.

RE redacted projects - is there a way to get at them that redacts the names/locations, but would allow us to know that there is an activity at least? Or who should we ask for an estimate of their number/volume?

Thanks a mil - and happy to skype if easier (‘matmaxgeds’).

Matt


(David Megginson) #7

Any project not funded by CBPF or CERF would not appear in their IATI reports, but would appear in the FTS API. Note that those projects are a much-more granular level than most donors report—they’re usually a specific thing that an org is doing in a specific place, while donors’ IATI reports are often more about programming (e.g. $1M for women’s health education in Ghana), which doesn’t actually tell you much about what’s happening where.

There has been some investigation into getting the HPC project identifiers into CERF’s and CBPF’s IATI. I’m not sure about the status of that.


(Matt Geddes) #8

Thanks David, sorry, this is turning into an FTS API info request.

Is there a way to distinguish between the CERF/CBPF vs other projects in the FTS data? We are trying to work out what we are missing out on by only importing IATI data. For example, some projects have their code as HSOM - whereas others start with XNP (but also appear to have a HSOM code) - do you know who we could check this with?

Can you also recommend someone to ask about the redacted projects?

I guess this must be the largest amount of data that was formerly available in IATI but no longer.


(David Megginson) #9

You can look up organisation ids here, and then filter on import (unfortunately, you can’t filter via the public API itself, as far as I know):

https://api.hpc.tools/v1/public/organization

CERF is straight-forward, because it’s a single org in the system:

{
  "id": 4762,
  "abbreviation": "CERF",
  "name": "Central Emergency Response Fund",
  "categories": [
    {
      "id": 121,
      "name": "Pooled fund",
      "group": "organizationType"
    }
  ]
}

CBPF is more complicated, because each country fund is listed as a separate org. You could try filtering on the “Pooled fund” category (as shown in the example above), but I’m not sure if there are other pooled funds in the system that you might miss. Here is the record for the DRC pooled fund, as an example (at least, I think it’s the CBPF fund—you see, even I’m not sure):

{
  "id": 7654,
  "abbreviation": "Democratic Republic of the Congo Humanitarian Fund",
  "name": "Democratic Republic of the Congo Humanitarian Fund",
  "categories": [
    {
      "id": 121,
      "name": "Pooled fund",
      "group": "organizationType"
    }
  ]
}

Cheers, David


(Matt Geddes) #10

Thanks @David_Megginson - that is very helpful.

We also heard today that the FTS hope to restart IATI publishing in 2019, fingers crossed - will share more here when we get it.


(David Megginson) #11

HI, @matmaxgeds - the FTS tech team got in touch and let me know that there’s a new v2 of the API that they recommend using. Here’s an example:

https://api.hpc.tools/v2/public/project/search?planCodes=HSOM19&excludeFields=locations

It looks like both the API structure and returned data structures have changed considerably.

For anyone not comfortable with JSON, I’ve made a simplified tabular view here (leaving out some hierarchical data structures):

https://proxy.hxlstandard.org/data/93fb54

D