PSN_Sector quality
Posted: Tue Mar 31, 2020 1:49 pm
Hello!
For a study we are currently doing, we wanted to get an idea of the number of families in the Netherlands that have a 'Private' applicant involved.
We assumed that psn_sector = INDIVIDUAL could be relevant and ran the query below. However, we find interesting results:
1 - The number drops after 2011 for WO and NL applications (relevent to our study).
- For WO: 2010 - 2308, 2011 - 347, NL: 2010 - 388, 2011 - 36
2 - EP applications also show a minimal drop (107 -84 after 2010) but those absolute numbers appear quite low
Something similar happens when the person_ctry_code is set on Germany (DE) or Belgium.
When we look for COMPANY instead of INDIVIDUAL the numbers look solid.
I find this especcialy strange as I assume that many of the WO applicants are also EP applications and thus I would not expect such a difference between the two.
Could you explain what I'm seeing here?
Thanks in Advance!
For a study we are currently doing, we wanted to get an idea of the number of families in the Netherlands that have a 'Private' applicant involved.
We assumed that psn_sector = INDIVIDUAL could be relevant and ran the query below. However, we find interesting results:
1 - The number drops after 2011 for WO and NL applications (relevent to our study).
- For WO: 2010 - 2308, 2011 - 347, NL: 2010 - 388, 2011 - 36
2 - EP applications also show a minimal drop (107 -84 after 2010) but those absolute numbers appear quite low
Something similar happens when the person_ctry_code is set on Germany (DE) or Belgium.
When we look for COMPANY instead of INDIVIDUAL the numbers look solid.
I find this especcialy strange as I assume that many of the WO applicants are also EP applications and thus I would not expect such a difference between the two.
Could you explain what I'm seeing here?
Thanks in Advance!
Code: Select all
SELECT earliest_filing_year, COUNT (DISTINCT docdb_family_id)
FROM tls201_appln
JOIN tls207_pers_appln ON tls201_appln.appln_id = tls207_pers_appln.appln_id
JOIN tls206_person ON tls207_pers_appln.person_id = tls206_person.person_id
WHERE
(tls206_person.person_ctry_code = 'NL' )
AND
(appln_auth = 'WO')
AND
(earliest_filing_year between 2002 and 2019)
AND
applt_seq_nr > 0
AND
psn_sector LIKE 'COMPANY%'
GROUP BY earliest_filing_year
ORDER BY earliest_filing_year ASC