Search found 260 matches

by EPO / PATSTAT Support
Fri Oct 22, 2021 7:48 am
Forum: PATSTAT Product Line
Topic: Missing person information in [dbo].[tls206_person]?
Replies: 1
Views: 20

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...
by EPO / PATSTAT Support
Fri Oct 15, 2021 11:35 am
Forum: PATSTAT Product Line
Topic: IPC 'Y' classification
Replies: 2
Views: 59

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...
by EPO / PATSTAT Support
Thu Oct 14, 2021 8:49 pm
Forum: PATSTAT Product Line
Topic: Top Applicants in certain PSN sectors
Replies: 1
Views: 61

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...
by EPO / PATSTAT Support
Thu Oct 07, 2021 3:35 pm
Forum: PATSTAT Product Line
Topic: The patent families concepts.
Replies: 0
Views: 106

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...
by EPO / PATSTAT Support
Thu Sep 16, 2021 10:36 am
Forum: PATSTAT Product Line
Topic: Call for proposals: EPO Academic Research Programme
Replies: 0
Views: 148

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...
by EPO / PATSTAT Support
Mon Jul 05, 2021 8:14 am
Forum: PATSTAT Product Line
Topic: Data retrieval of the patent references possible ?.
Replies: 1
Views: 2414

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/ccd_index . ...
by EPO / PATSTAT Support
Tue Jun 22, 2021 12:25 pm
Forum: PATSTAT Product Line
Topic: DOCDB Family fractional count by country of inventors
Replies: 4
Views: 2981

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...
by EPO / PATSTAT Support
Mon Jun 21, 2021 1:03 pm
Forum: PATSTAT Product Line
Topic: DOCDB Family fractional count by country of inventors
Replies: 4
Views: 2981

Re: DOCDB Family fractional count by country of inventors

Hello Valentin, looking at your query; it is a bit difficult to understand exactly what you would like to do with regards to the fractional counting. Can you explain in a couple of sentences, what you would like to do and how you expect the results to look like ? If your methodology is to be used on...
by EPO / PATSTAT Support
Thu Jun 17, 2021 7:14 pm
Forum: PATSTAT Product Line
Topic: different number country-specific applications
Replies: 2
Views: 2340

Re: different number country-specific applications

Hello Polina, your analysis - reason 1 is correct. In PATSTAT we have aggregated applicant and inventor names at application level via the tls207 table. This means that (generally spoken) we take the names from the latest publication instance from that application. So when a change of ownership happ...
by EPO / PATSTAT Support
Mon Jun 07, 2021 12:25 pm
Forum: PATSTAT Product Line
Topic: Collaborative and non-collaborative patents
Replies: 4
Views: 3009

Re: Collaborative and non-collaborative patents

The queries are all variations on the same theme; in the WHERE part of the SQL query, you specify what "group" of patents the final result list should look like. The "AND tls201_appln.appln_id in (select.....)" defines intersections of samples of patents. So here is a query that selects all the pate...