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
vanishing applications across ediction
-
- Posts: 63
- Joined: Mon Nov 09, 2009 8:48 pm
- Location: Italy
- Contact:
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: vanishing applications across ediction
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.
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
EPO - Vienna
patstat @ epo.org