Search found 440 matches
- Tue Nov 02, 2021 3:31 pm
- Forum: Linked open EP data/open EP bulk data
- Topic: Patent Index 2020 - European patent applications - Replication
- Replies: 3
- Views: 38079
Re: Patent Index 2020 - European patent applications - Replication
Dear Fernando, using SQL in PATSTAT Register, there is indeed a risk for double counting when multiple tables are joined in a query. Each joined table might multiplicate the number of rows if no further restrictions are applied in the WHERE clause. Generally spoken on using PATSTAT for "replica...
- Wed Oct 27, 2021 12:59 pm
- Forum: PATSTAT Product Line
- Topic: Running SQL code in online PATSTAT
- Replies: 3
- Views: 2141
Re: Running SQL code in online PATSTAT
I can not guarantee that you will not have to adapt the code to your platform.
The sql code is written for MySQL, so if you have a MySQL data base platform, it might very well run without any further modifications.
The sql code is written for MySQL, so if you have a MySQL data base platform, it might very well run without any further modifications.
- Fri Oct 22, 2021 3:26 pm
- Forum: PATSTAT Product Line
- Topic: Running SQL code in online PATSTAT
- Replies: 3
- Views: 2141
Re: Running SQL code in online PATSTAT
Hello paringyang, It is indeed impossible to run Professor Gaétan's code on PATSTAT Online, also because users can not store their own (user defined) data on the PATSTAT Online platform. My advice: extract the data which you need (maximum 100.000 applications), include the family members in the extr...
- Fri Oct 22, 2021 7:48 am
- Forum: PATSTAT Product Line
- Topic: Missing person information in [dbo].[tls206_person]?
- Replies: 3
- Views: 3714
Re: Missing person information in [dbo].[tls206_person]?
Hello AWFB, you probably just made a mistake in your query. (Maybe the JOINS if you do not find any persons at all) Try the query below and you will find exactly the same as in Espacenet. SELECT a.[appln_id] ,a.[appln_auth] ,a.[appln_nr] ,a.[appln_kind] ,a.[appln_filing_date] ,applt_seq_nr, invt_seq...
- Fri Oct 15, 2021 11:35 am
- Forum: PATSTAT Product Line
- Topic: IPC 'Y' classification
- Replies: 2
- Views: 3657
Re: IPC 'Y' classification
Hello AWFB, your PATSTAT search is searching the CPC classification scheme, not IPC. If you change it to CPC, you will the results. In ESPACENET you will find 4 results which are basically some kind of data errors. We will correct that because the correct result should indeed be zero results, like y...
- Thu Oct 14, 2021 8:49 pm
- Forum: PATSTAT Product Line
- Topic: Top Applicants in certain PSN sectors
- Replies: 1
- Views: 1584
Re: Top Applicants in certain PSN sectors
Hello Diana, 2 observations: a) the AND and OR operators are executed according to standard order of precedence. Meaning: A OR B AND C is executed as (A OR (B AND C )). While what you want is ((A OR B) and C). When you have 1 attribute to be checked against a couple -or many- possible values, you ca...
- Thu Oct 07, 2021 3:35 pm
- Forum: PATSTAT Product Line
- Topic: The patent families concepts.
- Replies: 0
- Views: 1438
The patent families concepts.
(Newbie) PATSTAT users often struggle to understand the concept of patent families. Our colleagues at the patentdata team have produced this very explanatory video on patent families. Both Simple and INPADOC (extended) patent families are pre-created in the PATSTAT data base and are available via th...
- Thu Sep 16, 2021 10:36 am
- Forum: PATSTAT Product Line
- Topic: Call for proposals: EPO Academic Research Programme
- Replies: 0
- Views: 2071
Call for proposals: EPO Academic Research Programme
During the previous editions, many PATSTAT users have benefited from the EPO Academic Research Programme. The new call for proposals is open until 15 October 2021. Proposals for research schemes may be submitted by individual research institutes or by groups of institutes. More information is availa...
- Mon Jul 05, 2021 8:14 am
- Forum: PATSTAT Product Line
- Topic: Data retrieval of the patent references possible ?.
- Replies: 3
- Views: 20666
Re: Data retrieval of the patent references possible ?.
Hello alexsunny, yes, it can be done in PATSTAT, but if you only need to do this for "half a dozen" of patent applications, it might be easier and quicker to do this via ESPACENET and the CCD (Common Citation Document) platform. https://www.fiveipoffices.org/activities/globaldossier/ccd/cc...
- Tue Jun 22, 2021 12:25 pm
- Forum: PATSTAT Product Line
- Topic: DOCDB Family fractional count by country of inventors
- Replies: 5
- Views: 5935
Re: DOCDB Family fractional count by country of inventors
Hello Valentin, it will not be easy; and I would say that this is not possible to do in 1 query- 1 go. You will need to extract the data sets. In the case of patents that have (at least) 1 FR inventor, there are 8582 patent applications. They are grouped in 3359 docdb patent families. So for each on...