A look at Coops UK Cooperative Economy Open Dataset 2015

Asking “How can we easily match organisations ?”

During the P6Data hack day, I got to talking with Michelle and Paul from Coops UK, the UK co-operative network. They’ve released a UK Cooperative economy dataset, which is an excellent start to their open data publication journey.

[Also see A distributed approach to co-operative data by my Open Data Services colleague, Tim Davies]

After a critical look at the dataset and guide (guys! they have documentation!), alongside the use cases that came out of P6 Data: “How the heck do we share data more smoothly?”, we came to some conclusions:

  1. We really need a data exchange standard that’s lightweight and we don’t want to reinvent the wheel (we’ll come to that later).
  2. We really need to know: Who’s the registrar and what’s the organisation type? This will help match organisations from one list to organisations from another.

How? Read on.

So Coops UK provide the registrar’s number for most of their members (except schools and a few other edge cases like unincorporated organisations, more on that later too). On the downside, it’s a single column all smooshed up together. On the upside, a simple (!) set of rules means we can work back and find out the organisation type *and* the registrar. Happy days! [See table below]

So what does this do for us? Ultimately, by knowing the registrar, we can:

Exchange information with other organisations: we can all match on something better than name.

For example, instead of trying to match Littleton and Badsey Growers Ltd and Littleton and Badsey Growers Limited or even Littleton & Badsey Growers, you can match Companies House’s Company Number 04518100. Much simpler

Check the registered number is right: At least with modern regulators like Companies House who provide a unique location (URI) for every company, here’s Littleton & Badsey Growers.

We can do that right in Excel, Open Refine or your preferred spreadsheet/wrangling programme. We can ask our friendly developers to add this feature to customer relationship management systems like SalesForce or plan.io. This means one less task when your organisation tries to reconcile a list from another organisation.

Here’s an example in Open Refine where I’ve worked out the registrar, the organisation type and the link to that organisation at the FCA’s mutual registry (the FCA URI).

open refine reconciliation
Open Refine reconciliation to FCA mutuals register

 Get even more relevant information: Given more time, we could pull out particular things we’re interested in, for example, what’s their current  status as a mutual or is a company incorporated and since when?

FCA Mutuals Register.png
The FCA Mutuals Public Register showing status
Companies House Incorporation.png
Companies House URI – a page for every registered company – showing summary company information

All this from a small extension to the existing dataset, which you can find here: Co-Operative Economy Extended Dataset derived from Coops UK Co-Operative Economy Open Data, released under the Open Data Commons Attribution License (ODC-by v1.0).

Corrections, updates and stories about what you’ve done with this dataset are welcome.

Working out the registrar – a simple guide (based on best guess)

Rule Location Org Type Registrar / Regulator
Starts with “LP” England & Wales Limited Partnership Companies House
Starts with “FC” Overseas Company Companies House
Starts with “OC” England & Wales Limited Liability Partnership Companies House
Starts with “SO” Scotland Limited Liability Partnership Companies House
Starts with “NP” Northern Ireland Industrial/Provident Company or Credit Union Companies House
Starts with “NI” Northern Ireland Limited Company Companies House
Start with “SC” + numbers Scotland Limited Company Companies House
All numbers England & Wales Limited Company Companies House
Ends with “RS” Scotland Co-operative and Community Benefit Society FCA
Ends with “C” Credit Union FCA
Ends with “CBS” Scotland Community Benefit Societies FCA
Ends with “CS” Industrial and Provident Society FCA
Ends with “CUS” Scotland Credit Union FCA
Ends with “R” Co-operative and Community Benefit Society FCA
Starts with “CU” Northern Ireland Credit Union FCA
Starts with “IP” Northern Ireland Industrial & Provident Society FCA

A huge thank you to our collaborators and hosts:

logo.png

Co-operatives UK

Institute for Solidarity Economics.png

https://i0.wp.com/www.imity.io/images/transformap.jpg

Published by

ekoner

Consultant: Data Science & Data Analysis || Data confusion → Organisation insight || I make the complex, simple

3 thoughts on “A look at Coops UK Cooperative Economy Open Dataset 2015”

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s