No middle_name in the psc stream API

I compared the psc bulk data (persons-with-significant-control-snapshot-2024-04-25)

{“company_number”:“12578660”,“data”:{“address”:{“country”:“England”,“locality”:“New Milton”,“postal_code”:“BH25 6JX”,“premises”:“36a Station Road”,“region”:“Hampshire”},“country_of_residence”:“England”,“date_of_birth”:{“month”:10,“year”:1984},“etag”:“388c6ca102098145c2a04786967d805f2174ffad”,“kind”:“individual-person-with-significant-control”,“links”:{“self”:"/company/12578660/persons-with-significant-control/individual/OwToTNiG7EBiQ3MDv_y1Gg0s-uc"},“name”:“Mrs Hannah Mary Alice Broadhurst”,“name_elements”:{“forename”:“Hannah”,“middle_name”:“Mary Alice”,“surname”:“Broadhurst”,“title”:“Mrs”},“nationality”:“British”,“natures_of_control”:[“ownership-of-shares-25-to-50-percent”,“voting-rights-25-to-50-percent”],“notified_on”:“2020-04-29”}}
{“company_number”:“15461556”,“data”:{“address”:{“address_line_1”:“Sharvells Road”,“address_line_2”:“Milford On Sea”,“country”:“England”,“locality”:“Lymington”,“postal_code”:“SO41 0PE”,“premises”:“29”},“country_of_residence”:“England”,“date_of_birth”:{“month”:10,“year”:1984},“etag”:“761144cf91c45a2887427bdea1cdd6e8d2650bc9”,“kind”:“individual-person-with-significant-control”,“links”:{“self”:"/company/15461556/persons-with-significant-control/individual/GICdz9lg0HH9Qjggnu8BAjnGuT0"},“name”:“Mrs Hannah Mary Alice Broadhurst”,“name_elements”:{“forename”:“Hannah”,“middle_name”:“Mary Alice”,“surname”:“Broadhurst”,“title”:“Mrs”},“nationality”:“British”,“natures_of_control”:[“ownership-of-shares-75-to-100-percent”,“voting-rights-75-to-100-percent”,“right-to-appoint-and-remove-directors”],“notified_on”:“2024-02-02”}}

with the stream data chunks:

{“resource_kind”:“company-psc-individual”,“resource_uri”:"/company/12578660/persons-with-significant-control/individual/OwToTNiG7EBiQ3MDv_y1Gg0s-uc",“resource_id”:“OwToTNiG7EBiQ3MDv_y1Gg0s-uc”,“data”:{“address”:{“country”:“England”,“locality”:“New Milton”,“postal_code”:“BH25 6JX”,“premises”:“36a Station Road”,“region”:“Hampshire”},“country_of_residence”:“England”,“date_of_birth”:{“month”:10,“year”:1984},“etag”:“388c6ca102098145c2a04786967d805f2174ffad”,“kind”:“individual-person-with-significant-control”,“links”:{“self”:"/company/12578660/persons-with-significant-control/individual/OwToTNiG7EBiQ3MDv_y1Gg0s-uc"},“name”:“Mrs Hannah Mary Alice Broadhurst”,“name_elements”:{“forename”:“Hannah”,“surname”:“Broadhurst”,“title”:“Mrs”},“nationality”:“British”,“natures_of_control”:[“ownership-of-shares-25-to-50-percent”,“voting-rights-25-to-50-percent”],“notified_on”:“2020-04-29”},“event”:{“timepoint”:10176073,“published_at”:“2024-02-02T11:55:19”,“type”:“changed”}}
{“resource_kind”:“company-psc-individual”,“resource_uri”:"/company/15461556/persons-with-significant-control/individual/GICdz9lg0HH9Qjggnu8BAjnGuT0",“resource_id”:“GICdz9lg0HH9Qjggnu8BAjnGuT0”,“data”:{“address”:{“address_line_1”:“Sharvells Road”,“address_line_2”:“Milford On Sea”,“country”:“England”,“locality”:“Lymington”,“postal_code”:“SO41 0PE”,“premises”:“29”},“country_of_residence”:“England”,“date_of_birth”:{“month”:10,“year”:1984},“etag”:“761144cf91c45a2887427bdea1cdd6e8d2650bc9”,“kind”:“individual-person-with-significant-control”,“links”:{“self”:"/company/15461556/persons-with-significant-control/individual/GICdz9lg0HH9Qjggnu8BAjnGuT0"},“name”:“Mrs Hannah Mary Alice Broadhurst”,“name_elements”:{“forename”:“Hannah”,“surname”:“Broadhurst”,“title”:“Mrs”},“nationality”:“British”,“natures_of_control”:[“ownership-of-shares-75-to-100-percent”,“voting-rights-75-to-100-percent”,“right-to-appoint-and-remove-directors”],“notified_on”:“2024-02-02”},“event”:{“timepoint”:10176075,“published_at”:“2024-02-02T11:55:19”,“type”:“changed”}}

And found that the ‘middle_name’ is absent in the streaming chunks

1 Like

@MArkWilliams

The bulk file of psc persons contains:
“name”:“Mrs Hannah Mary Alice Broadhurst”,“name_elements”:{“forename”:“Hannah”,“middle_name”:“Mary Alice”,“surname”:“Broadhurst”,“title”:“Mrs”}

The stream returned:
“name”:“Mrs Hannah Mary Alice Broadhurst”,“name_elements”:{“forename”:“Hannah”,“surname”:“Broadhurst”,“title”:“Mrs”},

No middle name in the stream