Getting to a list of organisation references for IATI publishers

I guess you’re talking about the secretariat either funding, managing, running or endorsing this somehow. Is that right?

@andylolz yes.

1 Like

Please can we take out of this conversation mention of:

  • references to any organisation in the IATI corpus
  • a list of activity identifiers

This isn’t what is being talk about. One thing at a time, folks!

The remit of the original focus was to get a list of organisation references for IATI publishers. Whilst that sounds straightforward, we realised it isn’t always so. We then found that the data published via the Organisation standard was the optimal source.

I agree. This is why the methodology above took a look at the org data already provided by publishers. Any solution could continue to focus on this data as a source.

The interface to this is very useful. It’s be great to have a similar interface to many other “codes”! However, I think some organisations would also appreciate the data as a list, or in a format that could be imported into their applications. So this application doesn’t fail anything – it’s just a step on from there being a list!!

It’s probably important to consider this isn’t a list in the same way as other lists we use. It’s not a list of countries, that changes via formal announcements, for example.

This list of IATI publisher references that will a) increase regularly / at no set pattern b) be contributed to by each publisher, via their org file (so no central sanction of the list) c) have the possibility of changing, should a publish change their org reference (which is theoretically possibly – a UN agency may decide to add the XM-DAC prefix, for example.)

Therefore, the important step seems to be:

  • agreeing that the route to canonical references for IATI publishers is via the org file
  • inspecting the code we shared, to ensure that provides this
  • running / hosting that code to provide an updated/ongoing version of this list

I’d imagine the service to provide ongoing access the contents of this list would be something consider core to the IATI infrastructure.

I think this can be a community effort, with backing from the Secretariat. We also have an in built metric, in that we can actively track those organisations that do not provide an org file / matching references in their org file. This metric might be something the secretariat could take on.

1 Like

The API is linked in the footer. You can use that to get a snapshot list of IATI org IDs, in CSV, JSON or atom.

I’ll change the footer links to make this more obvious.


Great API! Will this be ‘officially’ maintained?

Hi All

A bit late to this conversation but I just wanted to say that I find @andylolz API super helpful - thanks Andy! I work for a funder and currently in the process of publishing about 200 activities (i.e. grants) - I started looking for organisations’ ids by scrolling up and down the IATI Registry, then discovered this tool (thanks to @stevieflow) and almost halved the time it took me to look up orgs on the Register.

I have also published our org file so the stat is now 407 out of 555 publishers!

Agree this should be maintained centrally as a tool IATI should offer to encourage and support people to publish and agree a list would also be helpful for things like vlookups etc. Tools like this can improve the quality of the data massively!

And I know this is slightly separate to this thread but an activity finder, based on the same concept and maintained centrally, would be amazing - it would be also useful to ensure that aid flows are tracked properly (by enabling publishers to check that they’re using the right activity id)


When using API’s in production applications, its continuity must be guaranteed. @bill_anderson would it therefore be possible to have this API of @andylolz defined as an IATI core service (to be hosted either by the IATI technical team or to be hosted by a third party under the supervision of the IATI technical team)?


The source code is available here:

It’s MIT licensed, so if someone wants to take it, rebrand it, repurpose it… I’m fine with that.

An update on the figures from the original post, two years on.

  • Of 555 IATI publishers, there were 406 IATI organisation files (73% of publishers provide an Org file)

We’re now up to 1,024 IATI publishers. 694 of those have an IATI organisation file. That’s 68% - so the numbers have gone up, but the percentage has slipped a little.

  • Of these 406 publishers, 392 organisation identifiers match the reporting-org/@ref (97%)

Of the 694 publishers with organisation files, 678 of the organisation-identifiers in those org files match the reporting-org/@ref (98%).

  • Of 392 “matching” organisation identifiers, 333 started with a “recognised” prefix (85%)

Of the 678 “matching” organisation identifiers, 637 start with a “recognised” prefix (94%). I guess that means new publishers are choosing (or being given) valid org IDs, and some existing publishers have updated their org IDs to the new system. That’s excellent.

It looks like there are also noteable improvements to the registry metadata. I suspect the @IATI-techteam have pushed to improve this, so that is great. (Recent changes to the registry ensuring the org ID can only be modified on request will certainly also help with this.)

First of all, 100% of organisation identifiers in these 678 org files match the organisation identifiers in the registry metadata. @stevieflow and @bjwebb didn’t include this figure last time so we don’t have it for comparison, but I suspect it wasn’t this high.

958 of the 1,024 org identifiers in the registry metadata match the reporting-org/@ref (94%).

Of these 958 “matching” organisation identifiers, 898 start with a recognised prefix (94%).

Many thanks for this timely update @andylolz

It does represent excellent news in terms of the growth of the number and quality of the organisation references available. Thanks to the @IATI-techteam for pushing this forward for us all.

I’m unsure what the “recent changes to the registry” are, but these also seem welcome. Is there an announcement of these changes anywhere @WendyThomas ?

@andylolz can you confirm that the service you voluntarily host remains up to date / in synch ( I think it’s automagically so)?

From all this, there looks to be four questions to us all to address:

  1. Given that registry itself now contains a high match (94%) of org references to the reporting-org/@ref data , is this to be a preferred methodology?

  2. If so, where does that leave the purpose of the organisation file? Our original point was to highlight that the org file could be the perfect place to maintain a single source of truth in terms of a publisher org reference (and less dependent on the registry itself, which might be a use case for data users who download the whole corpus)

  3. What do we do about the fact that 32% of publishers (330) do not publish an organisation file?

  4. Whilst org references are available in a list on the registry, do we need to ensure services such as @andylolz org id finder are core, central and easily available to all?

1 Like

Sorry, I should have provided a link. I was referring to changes to the registry that prevent publishers from changing their IATI publisher and Org IDs.

Indeed yes. The footer currently says it last updated 9 hours ago.

I’m tempted to change the methodology that org-id-finder uses, to instead use registry metadata. This would make it much simpler. But it would be good to get confirmation that this is now the most reliable source.