Search found 425 matches

by EPO / PATSTAT Support
Tue Aug 22, 2023 3:52 pm
Forum: PATSTAT Product Line
Topic: How to get the annual citation data for docdb families
Replies: 4
Views: 9062

Re: How to get the annual citation data for docdb families

Hello Humpherry, the short answer is: yes, it is wrong (not the SQL syntax as such) but because your query will double count all the family members depending on the number of family members. Have a look at the results from below query, you can see that there are 5 family members, they all have the s...
by EPO / PATSTAT Support
Thu Aug 10, 2023 9:02 am
Forum: PATSTAT Product Line
Topic: Replacement for appln_nr_epodoc
Replies: 2
Views: 3783

Replacement for appln_nr_epodoc

Hello Lionpat, Only using the application number will not work. The answer depends a bit on what you want to do and what you need it for. The appln_nr_epodoc attribute will be part of the data again in the next release. It might however still become obsolete in future releases. The obvious replaceme...
by EPO / PATSTAT Support
Thu Jul 27, 2023 5:14 pm
Forum: PATSTAT Product Line
Topic: Rows to columns: Listing inventors and applicants in the same row
Replies: 1
Views: 3026

Re: Rows to columns: Listing inventors and applicants in the same row

Hello Paulo, I assume you are using PATSTAT Online, which does not allow to make functions, procedures or dynamic SQL. Basically, what you are doing is de-normalising the (relational) data. Have a look at the query below; you can expand it to cover as many applicants or inventors you need (currently...
by EPO / PATSTAT Support
Wed Jun 14, 2023 9:31 am
Forum: PATSTAT Product Line
Topic: Count of European patent applications
Replies: 1
Views: 3346

Re: Count of European patent applications

Hello Alexis, it is in principle impossible to reproduce the filing figures published by the EPO, using PATSTAT. The data is based on applications (including applications that have been withdrawn - witdrawels before publication are NOT in PATSTAT, and nowhere else for that matter, except in EPO stat...
by EPO / PATSTAT Support
Wed Jun 07, 2023 11:42 am
Forum: PATSTAT Product Line
Topic: generate list of EP applications having at least one X-citation
Replies: 1
Views: 1742

Re: generate list of EP applications having at least one X-citation

A bit reworked, have a look and check. The list does not include cited NPL ! select distinct t1.appln_id,t1.appln_auth+t1.appln_nr+t1.appln_kind application, t1.appln_filing_date filing_date, t5.publn_auth+t5.publn_nr+t5.publn_kind citing_publication, t5.publn_date citing_publication_date, t10.publn...
by EPO / PATSTAT Support
Tue Jun 06, 2023 12:26 pm
Forum: PATSTAT Product Line
Topic: application with missing CPC code
Replies: 1
Views: 1259

Re: application with missing CPC code

Hello weiecon, CPC codes are in principle only available for those applications where a CPC code was assigned by any of the participating offices, or where there was a simply patent family member that already has a CPC code. Have a look at this coverage information: https://public.tableau.com/app/pr...
by EPO / PATSTAT Support
Fri Jun 02, 2023 8:55 am
Forum: PATSTAT Product Line
Topic: Understanding results of number of patent applications
Replies: 2
Views: 2530

Re: Understanding results of number of patent applications

Hello khanhhienbi, there is a small error in your query, the last for 3 lines in your SELECT clause have a correct "heading/alias" for the columns (2020,2021,2022), but they all show the values for 2019. So the real values are not shown. Below is a correction. SELECT psn_name, person_ctry_...
by EPO / PATSTAT Support
Thu Jun 01, 2023 11:07 am
Forum: PATSTAT Product Line
Topic: PATSTAT Introduction seminar (beginner, free)
Replies: 0
Views: 1042

PATSTAT Introduction seminar (beginner, free)

This online seminar introduces PATSTAT Online and its beginners' interface, as well as demonstrating more advanced statistical analyses using the structured query language (SQL).The PATSTAT product line provides a unique basis for the advanced statistical analyses of patent data. Join us for this ex...
by EPO / PATSTAT Support
Tue May 30, 2023 11:46 am
Forum: PATSTAT Product Line
Topic: opposition count by ipc 4digit
Replies: 1
Views: 1445

Re: opposition count by ipc 4digit

Hello Elisa, I changed a couple of small things in your query. And I removed (by making SQL lines as comments) a couple of the conditions which are not wrong, but not necessary neither. All information on opposition procedures in PATSTAT Register are linked to granted EP patent applications. So they...
by EPO / PATSTAT Support
Tue May 30, 2023 10:40 am
Forum: PATSTAT Product Line
Topic: ARIPO/African Patents - Designated States?
Replies: 1
Views: 1128

Re: ARIPO/African Patents - Designated States?

Hello Zecon, patents that have been filed ARIPO have the WIPO ST.3 code AP. Using a condition such as appln_auth = 'AP' will retrieve patents filed at ARIPO. There aren't that many, see in espacenet: https://worldwide.espacenet.com/patent/search?q=ap%20%3D%20%22AP%22 EP patents can not designate ARI...