date of party change

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

detlef
Posts: 1
Joined: Fri Jan 26, 2018 9:15 am

date of party change

Post by detlef » Fri Jan 26, 2018 9:21 am

does the PATSTAT DB contain dates for ownership change?
In other words, are there dates available for party_new events?
If yes, which attribute contains the information?


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

Re: date of party change

Post by EPO / PATSTAT Support » Mon Jan 29, 2018 5:08 pm

@detlef,
most countries do not have legal requirement to register ownership changes after the patent was/is granted. Whatever information that is available will be in the TLS231_INPADOC_LEGAL_EVENT table. Different countries use different codes, so you will need to look for the relevant event_codes for those patent authorities that are part of your sample.
For EPO applications, basically the same situation: post grant information on changes of ownership or licences is rare -and not sufficient to make meaningful analysis-. Changes of applicant (before grant) occur more often, and are in principle up-to-date. These can be see in the REG107_PARTIES table.
BUT (capital !) some data on address changes have been historically coded as changes of ownership. So there is noise and the best is to use some textual analytics to filter out those cases. (Levenshtein distance,...)
Here is a sample query that illustrates this data: EP codes: reg301_event_data.event_code = '0009199APPR' or reg301_event_data.event_code = '0009012'
The relevant date is the "Change date". (See Register Data Catalog for details)

Code: Select all

 select top 100
		reg101_appln.id
		, reg101_appln.appln_auth 
    	, reg101_appln.appln_nr 
      	, reg101_appln.appln_filing_date 
		, reg107_parties.set_seq_nr 
      	, reg107_parties.is_latest 
      	, reg107_parties.change_date 
      	, reg107_parties.bulletin_year 
      	, reg107_parties.bulletin_nr 
      	, reg107_parties.type 
      	, reg107_parties.seq_nr 
      	, reg107_parties.customer_id 
      	, reg107_parties.name 
      	, reg107_parties.address_1 
      	, reg107_parties.address_2 
      	, reg107_parties.address_3 
      	, reg107_parties.address_4 
      	, reg107_parties.address_5 
      	, reg107_parties.country 
      	, event_date 
      	,reg301_event_data. event_code 
      	, event_text
from reg107_parties join reg101_appln on reg101_appln.id = reg107_parties.id
join  reg301_event_data  
   on reg107_parties.id = reg301_event_data.id 
   and reg107_parties.bulletin_nr = reg301_event_data.bulletin_nr and reg107_parties.bulletin_year = reg301_event_data.bulletin_year
join  reg402_event_text  
   on reg402_event_text.event_code= reg301_event_data.event_code
where (reg301_event_data.event_code = '0009199APPR' or reg301_event_data.event_code = '0009012') and type = 'a'
and reg101_appln.id in (select ID from reg107_parties where country in ('GB','FI','SE') and reg107_parties.type = 'a')
and reg101_appln.id in (select ID from reg301_event_data where reg301_event_data.event_code = '0009199APPR')
and reg101_appln.id in (select ID from reg107_parties where country in ('KY','CY','LU','MC','BB','BS', 'LI', 'MH', 'MO','MT','TC', 'VG','PA') and reg107_parties.type = 'a')
and year(reg101_appln.appln_filing_date) between 2005 and 2015
group by reg101_appln.id
	, reg101_appln.appln_auth 
    , reg101_appln.appln_nr 
    , reg101_appln.appln_filing_date 
	, reg107_parties.set_seq_nr 
    , reg107_parties.is_latest 
    , reg107_parties.change_date 
    , reg107_parties.bulletin_year 
    , reg107_parties.bulletin_nr 
    , reg107_parties.type 
    , reg107_parties.seq_nr 
    , reg107_parties.customer_id 
    , reg107_parties.name 
    , reg107_parties.address_1 
    , reg107_parties.address_2 
    , reg107_parties.address_3 
    , reg107_parties.address_4 
    , reg107_parties.address_5 
    , reg107_parties.country 
    , event_date 
    , reg301_event_data.event_code 
	, reg301_event_data.bulletin_year
	, reg301_event_data.bulletin_nr
    , event_text
order by appln_filing_date desc,reg101_appln.id,change_date, reg107_parties.set_seq_nr asc
Geert BOEDT
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply