Search found 119 matches
- Tue Jan 07, 2014 1:18 pm
- Forum: PATSTAT Product Line
- Topic: Granted?
- Replies: 2
- Views: 13055
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...
- Wed Dec 18, 2013 5:27 pm
- Forum: PATSTAT Product Line
- Topic: How to count inventors
- Replies: 9
- Views: 5948
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 ...
- Wed Dec 18, 2013 5:04 pm
- Forum: PATSTAT Product Line
- Topic: Why different counts for B82Y subclass
- Replies: 4
- Views: 2810
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...
- Wed Dec 18, 2013 4:36 pm
- Forum: PATSTAT Product Line
- Topic: Mismatch artificial applications due to claimed priorities
- Replies: 4
- Views: 3142
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...
- Tue Dec 10, 2013 1:26 pm
- Forum: PATSTAT Product Line
- Topic: Why different counts for B82Y subclass
- Replies: 4
- Views: 2810
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_...
- Tue Dec 10, 2013 12:10 pm
- Forum: PATSTAT Product Line
- Topic: tls206_ascii
- Replies: 2
- Views: 7732
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...
- Tue Dec 10, 2013 10:04 am
- Forum: PATSTAT Product Line
- Topic: stable person_id vs address replenishments
- Replies: 2
- Views: 2763
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 ...
- Thu Oct 17, 2013 10:16 am
- Forum: PATSTAT Product Line
- Topic: October 2013 edition: Data Catalog available
- Replies: 0
- Views: 2803
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...
- 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: 3484
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...