Search found 256 matches

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: 34

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: 1470

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: 1915

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: 1915

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: 1467

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: 1899

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...
by EPO / PATSTAT Support
Mon Jun 07, 2021 11:15 am
Forum: PATSTAT Product Line
Topic: Collaborative and non-collaborative patents
Replies: 4
Views: 1899

Re: Collaborative and non-collaborative patents

Hello Isabel, here is a simple query that selects all EP patents (labelled "Chemistry") having at least 1 German University as applicant and nothing else. (Some patents have more then 1 German applicant that is labelled as a university: https://worldwide.espacenet.com/patent/search/family/038015913/...
by EPO / PATSTAT Support
Tue Jun 01, 2021 4:22 pm
Forum: PATSTAT Product Line
Topic: University Patents.
Replies: 2
Views: 1588

Re: University Patents.

The reason is because your SQL query is build as such that the condition of "university" and "being German" is split in 2 different branches. So each of the patents will have a university (maybe not German) and a German applicant (maybe a university). It's only a matter of building up the query corr...
by EPO / PATSTAT Support
Tue May 25, 2021 9:58 am
Forum: PATSTAT Product Line
Topic: Help needed Annual patent count of specific firm
Replies: 2
Views: 1417

Re: Help needed Annual patent count of specific firm

You can easily adapt one of the queries in this post to your needs: https://forums.epo.org/sql-queries-to-create-simple-applicant-year-based-table-10588 For example add: and psn_name in ('volkswagen' , 'renault' , 'audi' , 'VOLVO CAR CORPORATION' , 'PEUGEOT CITROEN AUTOMOBILES' , 'DAIMLER') in the W...
by EPO / PATSTAT Support
Fri May 21, 2021 4:09 pm
Forum: PATSTAT Product Line
Topic: Zip Code Column Empty
Replies: 1
Views: 1523

Re: Zip Code Column Empty

Hello Rmudie96, the reason why your query does not return results is the missing spaces in the IPC codes. There should always be 8 characters before the position of the slash (which is position 9) The query below will give you data. However, keep in mind that a) addresses for physical persons have b...