Search found 119 matches

by mkracker
Tue Jan 07, 2014 1:18 pm
Forum: PATSTAT Product Line
Topic: Granted?
Replies: 2
Views: 9343

Re: Granted?

Dear Nico, You are right: The GRANTED field of table TLS201_APPLN is derived from the PUBLN_FIRST GRANT field of table TLS211_PAT_PUBLN. (cf. Data Catalog v5.00 Oct 2013, p.126) More specifically, it is done this way: update tls201_appln set granted = 1 -- default was 0 where exists (select * from t...
by mkracker
Wed Dec 18, 2013 5:27 pm
Forum: PATSTAT Product Line
Topic: How to count inventors
Replies: 9
Views: 5462

Re: How to count inventors

Have a look at the "SQL Self Study Course", downloadable from the PATSTAT online page on http://www.epo.org/searching/subscription/patstat-online.html . It describes the basics and some advanced features of SQL and contains loads of examples using PATSTAT. Page 78 explains how to retrieve ...
by mkracker
Wed Dec 18, 2013 5:04 pm
Forum: PATSTAT Product Line
Topic: Why different counts for B82Y subclass
Replies: 4
Views: 2781

Re: Why different counts for B82Y subclass

Dear Kirill, your queries are fine. Using the April 2013 PATSTAT edition, I also retrieve only 3 publications. However, if I use the October 2013 edition, I retrieve 180 rows. This is plausible when compared to GPI (Global Patent Index), which returned 179 publication. PATSTAT is based on a snapshot...
by mkracker
Wed Dec 18, 2013 4:36 pm
Forum: PATSTAT Product Line
Topic: Mismatch artificial applications due to claimed priorities
Replies: 4
Views: 3111

Re: Mismatch artificial applications due to claimed prioriti

Hi Tom, By “priority” in PATSTAT we mean not only “Paris Convention priority”, but also other types of priorities which link one application to a, “prior” application. The various types of priorities are stored in separate tables: • TLS201_APPLN An PCT application in its regional/national phase cont...
by mkracker
Tue Dec 10, 2013 1:26 pm
Forum: PATSTAT Product Line
Topic: Why different counts for B82Y subclass
Replies: 4
Views: 2781

Re: Why different counts for B82Y subclass

Dear Kirill, Some helpful hints and comments: I tried your query use patstatapril2013 select count(distinct appln_id) from tls224_appln_cpc where cpc_class_symbol like 'B82Y%' but got more rows: 184.259 – please check Regarding your detailed request: • In line “tls206_person ON tls206_person.person_...
by mkracker
Tue Dec 10, 2013 12:10 pm
Forum: PATSTAT Product Line
Topic: tls206_ascii
Replies: 2
Views: 5017

Re: tls206_ascii

The TLS206_ASCII table was never really part of PATSTAT, but for “the programmers only”. It contained a mixture of application data (TLS201_APPLN) and person data (tables TLS206, TLS207, TLS208), and unfortunately never was sufficiently documented. You asked about the WK_COUNTRY attribute: It is jus...
by mkracker
Tue Dec 10, 2013 10:04 am
Forum: PATSTAT Product Line
Topic: stable person_id vs address replenishments
Replies: 2
Views: 2739

Re: stable person_id vs address replenishments

The rules for de-duplicating records in table TLS206_PERSON have changed in the Oct 2013 edition. The only real data which PATSTAT knows about a person are the attributes PERSON_NAME, PERSON_ADDRESS and PERSON_CTRY_CODE. All other attributes are here for technical reasons (PERSON_ID) or are derived ...
by mkracker
Thu Oct 17, 2013 10:16 am
Forum: PATSTAT Product Line
Topic: October 2013 edition: Data Catalog available
Replies: 0
Views: 2778

October 2013 edition: Data Catalog available

Dear PATSTAT user, The new PATSTAT Oct 2013 edition will be shipped to PATSTAT Raw Data subscribers in the next couple of days. Substantial enhancements have been made since the last edition: * An additional table now links all persons directly to all publication instances * For those who do detaile...
by mkracker
Tue Oct 08, 2013 12:51 pm
Forum: PATSTAT Product Line
Topic: Guide on how to use legal status data TLS221_INPADOC_PRS
Replies: 0
Views: 3451

Guide on how to use legal status data TLS221_INPADOC_PRS

Dear PATSTAT users, Admittedly, legal status information is neither easy to understand nor to apply. The TLS221 table contains almost 4000 different legal event codes (LEC) that tag each procedural step in the life of a patent. The reason why the code count is so high is due to the fact that each co...