register icon indicating copy to clipboard operation
register copied to clipboard

birthDate in BODS JSON from UK PSC Register assumes everyone's birthdays are the first of the month

Open StephenAbbott opened this issue 4 years ago • 1 comments

Current mapping from UK PSC Register JSON snapshots to BODS v0.1 maps date_of_birth to birthDate in BODS v0.1.

But this assumes a complete address string. The day of officers' date of birth in UK PSC Register is suppressed so that only the month and year that they were born is provided.

The result in the BODS v0.1 json files for individuals is that all officers from the UK PSC Register seem to be given birth dates on the first of the month which is incorrect. Instead we should map just to YYYY-MM and not YYYY-MM-DD in the birthDate field.

If this change is made, need to consider what impact it will have on existing deduplication/entity matching, for example in the natural persons duplicate merger process.

StephenAbbott avatar Nov 05 '21 10:11 StephenAbbott

See related date field issue https://github.com/openownership/register/issues/10

StephenAbbott avatar Jan 23 '22 12:01 StephenAbbott