Null nationalities in UK transformer

[miranda-ae]

Summary: Got about 1m persons with null nationalities from the UK register but when you check the raw data they should have nationalities. Likely something wrong with how we are coding these?

Full writeup:

Do we know if there is anything wrong with the nationality mapping for the UK PSC data to BODS? I know we’ve got known issues with Denmark but when I was in with the Norwegian journalists we were looking at Norwegians as BOs in the register and there are a few in SK data , some in DK (tho suspect that might be wrong) but absolutely none from the UK which seems… weird.

E.g. see famous Norwegian Erling Haaland’s record:
https://register.openownership.org/entities/18313221187575966477

You can see in the raw CH data that he is Norwegian but the nationality is null in the local DB I’ve got running. Seems to be true for a few other examples I’ve checked.

In total we’ve got over 1m UK PSC person’s with Null nationality - cursory check of the raw data for a few of those shows that there are nationalities in there? So assume its something to do with our mapping.