Page 1 of 1

Event_descr missing in 2021 Spring edition

Posted: Thu May 13, 2021 11:44 am
by Eduardo Mercadante
Hello,

I was updating my sample of legal event data (tls231_inpadoc_legal_event) and for some reason the variable event_descr is missing. I have made other queries just to test and none has retrieved this value. If I ask directly for it, the system indicates invalid column name. If I ask for all columns (*), it is missing.

Is this an error or has this variable been dropped from the table? It is very hard to understand the data without it.

Best regards,
Eduardo Mercadante
PhD Candidate at LSE

Re: Event_descr missing in 2021 Spring edition

Posted: Fri May 14, 2021 8:08 am
by EPO / PATSTAT Support
Hello Eduardo,
Indeed, the column is not included in tls231_inpadoc_legal_event in PATSTAT (but that is normal).
You can link to tls803_legal_event_code via a join using the event_auth AND the event_code.
Below is an example on how to do this.

Code: Select all

SELECT top 10 * from tls231_inpadoc_legal_event
join tls803_legal_event_code 
on tls231_inpadoc_legal_event.event_auth = tls803_legal_event_code.event_auth
AND tls231_inpadoc_legal_event.event_code = tls803_legal_event_code.event_code

Re: Event_descr missing in 2021 Spring edition

Posted: Fri May 14, 2021 12:08 pm
by Eduardo Mercadante
Thanks for explaining how to unite these tables. That should solve the issue.

However, is there a reason why this column was removed? I have been extracting legal event data using tls231 for over a year and event_descr was always there. Only with this last edition that it was removed. Are there plans to getting it back in?

Best,
Eduardo Mercadante
PhD Candidate at LSE