Search found 110 matches

by mkracker
Tue Jan 07, 2014 3:59 pm
Forum: PATSTAT Product Line
Topic: TLS218_DOCDB_FAM
Replies: 5
Views: 2424

Re: TLS218_DOCDB_FAM

PATSTAT does not compute the EPO simple families (table TLS218_DOCDB_FAM) by itself, but simply takes this information from the DOCDB backfile. Although the EPO simple family (also called DOCDB family) is very useful and widely used, the DOCDB manual states: " The business rules governing the family...
by mkracker
Tue Jan 07, 2014 1:18 pm
Forum: PATSTAT Product Line
Topic: Granted?
Replies: 1
Views: 1284

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: 3539

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 applicants...
by mkracker
Wed Dec 18, 2013 5:04 pm
Forum: PATSTAT Product Line
Topic: Why different counts for B82Y subclass
Replies: 4
Views: 1698

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: 2140

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: 1698

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: 1585

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: 1742

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: 1620

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: 2176

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...