Search found 113 matches

by mkracker
Wed Dec 10, 2014 2:25 pm
Forum: PATSTAT Product Line
Topic: 2014 Autumn Edition is shipped
Replies: 0
Views: 996

2014 Autumn Edition is shipped

I am glad to report that the PATSTAT Raw Data DVDs "2014 Autumn Edition" is currently shipped. You should receive the DVDs by Dec 15th at the latest. The production of this edition took longer than usual. The reason was that we changed the processing platform and significantly streamlined the produc...
by mkracker
Wed Jan 08, 2014 11:42 am
Forum: PATSTAT Product Line
Topic: PUBLN_FIRST_GRANT?
Replies: 1
Views: 1467

Re: PUBLN_FIRST_GRANT?

Hi Nico, Roughly spoken, most offices publish their patents first as applications and later, if the applications are granted, as granted patents . I repeat your points and add my responses: ● Not all publications are grants (but all grants are publications). Correct - see above. ● Therefore, not all...
by mkracker
Wed Jan 08, 2014 11:08 am
Forum: PATSTAT Product Line
Topic: TLS218_DOCDB_FAM
Replies: 5
Views: 2523

Re: TLS218_DOCDB_FAM

The PATSTAT Data Catalog describes table TLS218_DOCDB_FAM quite correctly: " Generally speaking, if two applications claim exactly the same prior applications as priorities (.....), then they are defined by the EPO as belonging to the same DOCDB simple family. The EPO reserves the right to classify ...
by mkracker
Tue Jan 07, 2014 3:59 pm
Forum: PATSTAT Product Line
Topic: TLS218_DOCDB_FAM
Replies: 5
Views: 2523

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

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

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

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

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

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

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