Data

Spine of all third sector organisations

The initial data product of this project is a spine of all UK third sector organisations, their names, addresses and dates of registration (and dissolution where relevant). Additionally, where organisations are found in more than one register, we provide a file listing these linkages. Data relating to alternative names and addresses is also collated for completeness.

The organisational spine consists of three csv files:

  • public_spine.spine.csv contains a row for each organisation considered to make up the UK’s thrid sector, with name, address and date details.
  • public_spine.supplementary.csv contains any name, address and date information associated with an organsiation which is additional to what is in the spine, such as ‘Also Known As’ names, previous addresses.
  • public_spine.matches.csv lists the organisations which are linked or matched according to our searches, along with the type of match.

Download spine files

These three files can be downloaded using these links:

Data dictionaries

Main organisational spine

The file containing the list of unique organisations comprising the third sector, public_spine.spine.csv, contains the following fields:

FieldnameNotes
uidUID created for each source, e.g. GB-CHC-1234
organisationnameName as primary in source
normalisednameName normalised to capitalise, remove extra spaces and punctuation - to aid matching
fulladdressFull address as found in source with highest precendence across any matched organisations
cityCity matching full address as defined above
postcodePostcode matching full address as defined above
registerdateEarliest registration date found in records for this organisation across all sources
removeddateLatest dissolution date found in records for this organisation across all sources

Supplementary information

File of supplementary data for organisations, public_spine.supplementary.csv, contains the following fields:

FieldnameNotes
uidUID created for each source using source and id from original source
organisationnameAlternative name
normalisedname(Alt name normalised)
fulladdressAlternative address
cityAlternative address
postcodeAlternative address
registerdateAlternative registration date
removeddateAlternative removed / dissolved date

Matches

Matches between organisations are listed in file public_spine.matches.csv, using the following fields:

FieldnameNotes
uidUID created for each source, matches table - if match is unambiguous; blank otherwise
orgA_id_in_sourceID in original source, for matched organisation A
orgA_sourceOriginal source of organisation A
orgA_uidUID created for organisation A
orgB_id_in_sourceID in original source, for matched organisation B
orgB_sourceOriginal source of organisation B
orgB_uidUID created for organisation B
match_typeType of match (e.g. by name, by companyid)