Search found 228 matches

by EPO / PATSTAT Support
Wed Dec 02, 2020 8:46 am
Forum: PATSTAT Product Line
Topic: PATSTAT: Aren't all application in tls201 included in tls209?
Replies: 1
Views: 15

Re: PATSTAT: Aren't all application in tls201 included in tls209?

Hello, your queries are correct. I assume that the reason for missing IPC codes is that those patents simply have not been classified, so nothing wrong with the data as such. The WIPO guide gives some information on the IPC history and when it entered into force. wipo_guide_ipc_2020.pdf I don't know...
by EPO / PATSTAT Support
Tue Nov 10, 2020 9:52 am
Forum: PATSTAT Product Line
Topic: Help with SQL query - How to count the number of patent applications of a specific company
Replies: 1
Views: 108

Re: Help with SQL query - How to count the number of patent applications of a specific company

Hello khanhhienbi, first a couple of observations: Patents that have been filed between '2016-01-01' and '2020-01-01' will mostly not be granted yet. It easily takes 3 to 4 years for a patent to become granted. So I have widened the scope, but you can easily adapt it to your needs. If you want to "c...
by EPO / PATSTAT Support
Fri Nov 06, 2020 2:06 pm
Forum: PATSTAT Product Line
Topic: PATSTAT release Autumn 2020 is available for download
Replies: 0
Views: 142

PATSTAT release Autumn 2020 is available for download

PATSTAT 2020 Autumn edition Dear PATSTAT subscriber, The 2020 Autumn edition has been tested, found sound, and is now ready for download https://publication.epo.org/raw-data/authentication?action=2 . Do not hesitate to contact us in case you encounter any problems when uploading the new data files....
by EPO / PATSTAT Support
Wed Oct 28, 2020 11:41 am
Forum: PATSTAT Product Line
Topic: X-categorized citations
Replies: 2
Views: 179

Re: X-categorized citations

Hello Val, there is a small logical mistake in your query. The tls215_citn_categ should be joined via 2 attributes in order to link the correct citation category to the citations: t6.pat_publn_id = t12.pat_publn_id and t6.citn_id = t12.citn_id So observe that the join is NOT via t6.cited_pat_publn_i...
by EPO / PATSTAT Support
Tue Sep 29, 2020 4:58 pm
Forum: PATSTAT Product Line
Topic: IPC classification
Replies: 2
Views: 449

Re: IPC classification, F and L, Schmoch technology scheme

Dear Eduardo, That is a whole lot of questions in one go, so let me tackle them one by one. On question 1) In PATSTAT, we have pre-calculated the weighted technology shares for the each application based on the classification picture of each individual patent. Not on the position. This allows for mo...
by EPO / PATSTAT Support
Fri Sep 25, 2020 10:13 am
Forum: PATSTAT Product Line
Topic: PSN_ID changed?
Replies: 3
Views: 952

Filing date on divisional applications & new person_id's

Hello Tim, I would say that your question touches on 2 different but related issues. a) how is it possible that patent applications having a filing year < 2010 were not in PATSTAT2015 b) and the person_id's from those applications do not appear neither in the PATSTAT2015-but suddenly appear in a lat...
by EPO / PATSTAT Support
Tue Sep 22, 2020 2:03 pm
Forum: PATSTAT Product Line
Topic: ERROR 1014
Replies: 3
Views: 409

Re: ERROR 1014

Hello Al, That query should (and does) run without error message and gives you a list of 1.590 million rows. I assume it must have been a temporary hick-up - if this gave an error-. But this query creates for sure too much records to download in a result list or to extract in a separate database. Th...
by EPO / PATSTAT Support
Tue Sep 22, 2020 8:07 am
Forum: PATSTAT Product Line
Topic: ERROR 1014
Replies: 3
Views: 409

Re: ERROR 1014

Dear Al, PATSTAT Online has indeed a cut-off when the computational cost of a query becomes too high. Although the platform is MS SQL based, some functions or features might not work 100% because the parser pre-treats it before sending it to the server. Can you post the query so we can have a look a...
by EPO / PATSTAT Support
Mon Sep 14, 2020 10:49 am
Forum: PATSTAT Product Line
Topic: differentiate between assignee and inventor
Replies: 1
Views: 409

Re: differentiate between assignee and inventor

Hello, the short answer is YES; by setting correct applt_seq_nr and invt_seq_nr conditions. The term "assignee" is mainly used when talking about patent applications filed at the US patent office. At the EPO we rather use "applicant" in conjunction with patent application and "patent owner" or "prop...
by EPO / PATSTAT Support
Thu Sep 10, 2020 2:34 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online download and extraction limitations.
Replies: 0
Views: 376

PATSTAT Online download and extraction limitations.

Many users ask us about the "limitations" in PATSTAT Online. Although documented in the user manual , here is an overview: PatstatOnline_UserManual_v2.20.pdf The maximum length of an SQL query is 10 000 characters. PATSTAT subset download: Your result set must not contain more than 100 000 applicati...