Search found 130 matches
- Thu Jan 08, 2015 5:07 pm
- Forum: PATSTAT Product Line
- Topic: counting documents in CPC groups
- Replies: 4
- Views: 3118
Re: counting documents in CPC groups
Hello Paolo, This query should do the job: select left(tls224_appln_cpc.cpc_class_symbol,11) as CPC, count(distinct(appln_id)) from tls224_appln_cpc where SUBSTRING(left(tls224_appln_cpc.cpc_class_symbol,11),9,3 )='/00' group by left(tls224_appln_cpc.cpc_class_symbol,11) order by left(tls224_appln_c...
- Thu Jan 08, 2015 10:47 am
- Forum: PATSTAT Product Line
- Topic: Backward and forward citations; Problems with syntax
- Replies: 4
- Views: 3734
Re: Backward and forward citations; Problems with syntax
@ curcitiz Additional to the previous replies, I would like to shortly explain how it can be done in PATSTAT on-line. Your question: 1) Publication number 2) Publication date year: patent from 2006 to 2010 included. 3) Name of the applicant (in my case will be the firm (example VESTAS). I know there...
- Thu Dec 04, 2014 6:08 pm
- Forum: PATSTAT Product Line
- Topic: Data retrieval of patent references possible?
- Replies: 3
- Views: 2982
Re: Data retrieval of patent references possible?
ESPACENET allows to download of a list of Cited or Citing document from 1 specific patent. It does not allow you to download the "list" of a "list" of patents belonging to an applicant. So if your list of patents from an applicant only contains a "couple of dozens" of p...
- Tue Nov 11, 2014 3:41 pm
- Forum: PATSTAT Product Line
- Topic: PATSTAT application count sql results
- Replies: 1
- Views: 2053
Re: PATSTAT application count sql results
Hello, your query is a ranking based on the application filing date. Generally spoken, there are 18 months between the date of the patent application and the publication of the application. Add to this 6 months (maximum) between the publication and the PATSTAT production date, and you will have betw...
- Tue Nov 11, 2014 12:59 pm
- Forum: PATSTAT Product Line
- Topic: counting documents in CPC groups
- Replies: 4
- Views: 3118
Re: counting documents in CPC groups
Hello Paolo, if you mean by "main group". being the first 8 digits of the classification code then the following query will give you the result. select left(tls224_appln_cpc.cpc_class_symbol,8) as CPC_main_group, count(distinct(appln_id)) from tls224_appln_cpc group by left(tls224_appln_cp...
- Tue Nov 11, 2014 12:11 pm
- Forum: PATSTAT Product Line
- Topic: Data retrieval of patent references possible?
- Replies: 3
- Views: 2982
Re: Data retrieval of patent references possible?
Hello, If it is effectively only half a dozen of patents, it might be quicker & easier to do it manually via ESPACENET: http://worldwide.espacenet.com ESPACENET allows you to download the cited (and also citing) documents as an excel or CSV file for any specific patent application. If you want t...
- Mon Sep 01, 2014 2:12 pm
- Forum: PATSTAT Product Line
- Topic: Introduction to patent indicators: sample code & test data.
- Replies: 0
- Views: 2472
Introduction to patent indicators: sample code & test data.
Hi everyone, Geert Boedt (EPO), Helene Dernis (OECD) and myself have written a 10-page introduction to the offline Patstat database. The article provides MySQL and SQL codes for several popular queries: - How to identify patent applications by technology field - How to identify PCT patent applicatio...
- Fri May 02, 2014 10:32 pm
- Forum: PATSTAT Product Line
- Topic: What applications are in PATSTAT?
- Replies: 3
- Views: 3290
Re: What applications are in PATSTAT?
The question is not that easy to answer - or just very easy, depending how you look at it. Here are a couple of correct answers: PATSTAT contains ONLY data on applications that have been published (with a small exception of references to cited applications, for which dummy applications and publicati...
- Fri Feb 21, 2014 2:28 pm
- Forum: PATSTAT Product Line
- Topic: Deficiency in IPC table for PATSTAT201310
- Replies: 0
- Views: 1797
Deficiency in IPC table for PATSTAT201310
Dear PATSTAT users, It does not happen often, but we have to notify you about a deficiency in the current PATSTAT version. We have observed that about 4.5 per cent of the applications in the PATSTAT October 2013 release have their IPC codes missing. 99 % of the missing IPC codes belong to Japanese a...
- Wed Jun 15, 2011 4:19 pm
- Forum: PATSTAT Product Line
- Topic: ipc class versions patstat 2009
- Replies: 6
- Views: 6282
Re: ipc class versions patstat 2009
Hello Joe, Unless you take a "distinct" first 4 digits of IPC codes, there will be duplications within a family. In the latest PATSTAT versions we have eliminated duplications within an application (on full IPC symbol). Yes it is possible that applications have different classifications ov...