Hello,
during my analysis of company data, I realized that some companies in my sample have multiple
PSN_IDs e.g. IBM Deutschland can be associated with PSN_ID: 13138493, 13138495, 13138496 etc.
Is there any specific reason behind this? And is there a solution to identify connected PSN_IDs?
Thanks a lot,
Patrick
Multiple PSN_IDs for the same company?
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Multiple PSN_IDs for the same company?
Hello Patrick,
Your observation is not what I find in PATSTAT.
If you run the code below you will see that 'IBM Deutschland' on has 1 psn_id being 13775141. (in PATSTAT 2022a --> PSN_IDs are NOT fixed across PATSTAT version.
Your observation is not what I find in PATSTAT.
If you run the code below you will see that 'IBM Deutschland' on has 1 psn_id being 13775141. (in PATSTAT 2022a --> PSN_IDs are NOT fixed across PATSTAT version.
Code: Select all
SELECT TOP (1000) person_id
,person_name
,person_name_orig_lg
,person_address
,person_ctry_code
,nuts
,nuts_level
,reg_code
,doc_std_name_id
,doc_std_name
,psn_id
,psn_name
,psn_level
,psn_sector
,han_id
,han_name
,han_harmonized
FROM tls206_person
where psn_name = 'IBM Deutschland'
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org
-
- Posts: 2
- Joined: Wed Sep 28, 2022 11:30 am
Re: Multiple PSN_IDs for the same company?
Hey,
I use a different Patstat-Version so that's why the PSN_IDs are not the same. However, if I check person_id which is a stable identifier across versions and I run the query for a person_id that is connected to one of the PSN_IDs in my sample.
SELECT TOP (1000) person_id
,person_name
,person_name_orig_lg
,person_address
,person_ctry_code
,nuts
,nuts_level
,doc_std_name_id
,doc_std_name
,psn_id
,psn_name
,psn_level
,psn_sector
,han_id
,han_name
,han_harmonized
FROM tls206_person
where person_id = '23724479'
I receive 13558407 as PSN_ID for this company although it is also IBM Deutschland. There is a little difference in the spelling, however, it is still the same company. So the question is still if there is a way to find these connected PSN_IDs?
Thanks a lot,
Patrick
I use a different Patstat-Version so that's why the PSN_IDs are not the same. However, if I check person_id which is a stable identifier across versions and I run the query for a person_id that is connected to one of the PSN_IDs in my sample.
SELECT TOP (1000) person_id
,person_name
,person_name_orig_lg
,person_address
,person_ctry_code
,nuts
,nuts_level
,doc_std_name_id
,doc_std_name
,psn_id
,psn_name
,psn_level
,psn_sector
,han_id
,han_name
,han_harmonized
FROM tls206_person
where person_id = '23724479'
I receive 13558407 as PSN_ID for this company although it is also IBM Deutschland. There is a little difference in the spelling, however, it is still the same company. So the question is still if there is a way to find these connected PSN_IDs?
Thanks a lot,
Patrick