vanishing applications across ediction

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

gianluca.tarasconi
Posts: 63
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

vanishing applications across ediction

Post by gianluca.tarasconi » Fri Jun 08, 2018 11:37 am

Dear all

I ran a comparison across edictions 2018a and 2016b (query attached) and I found a number of applications in the older version cannot be found in the new one

most occurring case, above 1000 app for year are Australian D, but also other offices, for example

'KR' 'A' 2005 1956
'KR' 'A' 2006 2954

in some cases there is a systematic decrease across years as IT

office app kind earl pub date n apps 2018a n apps 2016b
'IT' 'A' 2010 9040 9257 -2%
'IT' 'A' 2011 9411 9681 -3%
'IT' 'A' 2012 8913 9152 -3%
'IT' 'A' 2013 8858 9180 -4%
'IT' 'A' 2014 8234 8494 -3%
'IT' 'A' 2015 3833 3865 -1%

maybe reasons varies across office / app kind, but there is a 'general rule' for these decreases?

thanks
GL



SELECT
a.APPLN_AUTH,
a.APPLN_KIND,
a.EARLIEST_PUBLN_year,
Count(DISTINCT a.APPLN_ID) AS Count_APPLN_ID
FROM
patstat2016b.tls201_appln a
LEFT JOIN patstat.tls201_appln b ON b.APPLN_ID = a.APPLN_ID
WHERE
b.APPLN_ID IS NULL
GROUP BY
a.APPLN_AUTH,
a.APPLN_KIND,
a.EARLIEST_PUBLN_year,
b.APPLN_ID


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: vanishing applications across ediction

Post by EPO / PATSTAT Support » Fri Jun 08, 2018 4:09 pm

Hello Gainluca,
the most "general rule" for these "disappearances" is the cleaning of the database and removal of duplicates, etc...
If you look-up the PUBLICATIONS linked to those "disappeared" applications in the 2018an database, you will see that they are now linked to an application (with the same application filing date) but kind code A and different appln_id.
In principle, I always use kind codes A, W, exceptional U or T.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply