Search found 124 matches

by EPO / PATSTAT Support
Tue Oct 30, 2018 11:42 am
Forum: PATSTAT Product Line
Topic: patent citation (backward citation)
Replies: 5
Views: 982

Re: patent citation (backward citation)

Hallo Davor, I kindly refer to the PATSTAT webpage for detailed information. Small data sets (up to 100.000 applications from 1 query) can be downloaded via PATSTAT Online. You can obtain 1 month free access via the online registration form: https://www.epo.org/searching-for-patents/business/patstat...
by EPO / PATSTAT Support
Mon Oct 29, 2018 10:03 am
Forum: PATSTAT Product Line
Topic: Utility Model Priority Application
Replies: 2
Views: 326

Re: Utility Model Priority Application

Hello Lionpat, here is a query that links utility models filed in DE with their US priority filings. To look for DE utility models that served as priority for later US applications, simply switch the joins on the tls204 table. SELECT p.person_name, psn_name,pa.applt_seq_nr ,a.appln_nr_epodoc, a.ipr_...
by EPO / PATSTAT Support
Mon Oct 29, 2018 9:46 am
Forum: PATSTAT Product Line
Topic: Gap betweeen US patent counts & DocDB simple family counts
Replies: 2
Views: 383

Re: Gap betweeen US patent counts & DocDB simple family counts

Hello Thomas, this is due to the endless series of (US) divisional applications originating from 6 "parent" US applications. The process to assign DOCDB_FAMILY_IDs takes into account not only the so called Paris Convention priorities but also the data in TLS2016_APPLN_CONTN and TLS205_TECH_REL. Have...
by EPO / PATSTAT Support
Wed Oct 24, 2018 10:49 pm
Forum: PATSTAT Product Line
Topic: ISA?
Replies: 2
Views: 1767

Re: ISA?

Here is an addition to my previous post in this thread: I forgot to mention that the situation has changed in the newest PATSTAT edition: This 2018 Spring Edition is available as PATSTAT data since early October and will be available soon in PATSTAT Online. In the 2018 Autumn Edition of PATSTAT Glob...
by EPO / PATSTAT Support
Wed Oct 24, 2018 7:12 am
Forum: PATSTAT Product Line
Topic: ISA?
Replies: 2
Views: 1767

Re: ISA?

The procedural step ISAT in the "PATSTAT EP Register" Database does only contain the office of the ISR (Internat. Search Report), not its citations etc. In general, citations cannot be found in the "PATSTAT EP Register" database but only in "PATSTAT Global". Both databases can easily been used toget...
by EPO / PATSTAT Support
Thu Oct 18, 2018 10:48 am
Forum: PATSTAT Product Line
Topic: PATSTAT autumn 2018 MySQL upload scripts
Replies: 1
Views: 388

Re: PATSTAT autumn 2018 MySQL upload scripts

Thank you so much, Gianluca, for supporting the PATSTAT community by providing these MySQL scripts.

Martin, EPO / PATSTAT
by EPO / PATSTAT Support
Tue Oct 16, 2018 1:05 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online: New simple query interface; Changed URL for access
Replies: 0
Views: 452

PATSTAT Online: New simple query interface; Changed URL for access

Dear Users, In addition to the existing "Expert" SQL query interface, a "Beginners" query interface has been added to support users not yet familiar with SQL. It is possible to answer a small set of frequent information needs by filling out a very simple query form, which automatically constructs th...
by EPO / PATSTAT Support
Tue Oct 09, 2018 9:24 am
Forum: PATSTAT Product Line
Topic: patent citation (backward citation)
Replies: 5
Views: 982

Re: patent citation (backward citation)

Hello Devor, your observation is correct, but if you do a family-family analysis, then you have to give your data preparation a serious thought on what attributes you will migrate to family level, and more important how you will do that for attributes that are "application" bound. Very specific: how...
by EPO / PATSTAT Support
Tue Oct 09, 2018 9:08 am
Forum: PATSTAT Product Line
Topic: Count Patent based on Assignee Country
Replies: 1
Views: 393

Re: Count Patent based on Assignee Country

Hello Murry, your query is correct; it illustrates that we have no country information for applicants and inventors on applications filed in Japan. As a comparison, here is an SQL query that gives an easy overview of as well JP as EP applications, counting the number person_id's that have (no) count...
by EPO / PATSTAT Support
Mon Sep 24, 2018 3:52 pm
Forum: PATSTAT Product Line
Topic: Counting international patent applications
Replies: 1
Views: 438

Re: Counting international patent applications

Dear Carmen, as far as I can see, I think you are counting something different then what you want to count. In your query you count the internat_appn_id; that attribute links the PCT application to a later application referring to that PCT. But as you already are looking for PCT applications (receiv...