Search found 425 matches

by EPO / PATSTAT Support
Thu Apr 06, 2023 3:13 pm
Forum: PATSTAT Product Line
Topic: Number of patents and patents applications per company
Replies: 3
Views: 5649

Re: Number of patents and patents applications per company

Hello Sina, in principle, that is possible, but you will need to develop a model/methodology to define which patents exactly you would consider ESG relevant. I fear that simply taking all patents tagged with cpc_class_symbol = 'Y02' or 'Y04S' will be too broad. You could see your question as a varia...
by EPO / PATSTAT Support
Thu Apr 06, 2023 2:25 pm
Forum: PATSTAT Product Line
Topic: Extracting all swiss priority applications from applicants without duplicates
Replies: 4
Views: 1272

Re: Extracting all swiss priority applications from applicants without duplicates

Have a look at the NUTS codes in tls206_person and table tls904_nuts; it might save you some work.
by EPO / PATSTAT Support
Thu Apr 06, 2023 2:21 pm
Forum: PATSTAT Product Line
Topic: Searching with docdb_family_id
Replies: 1
Views: 686

Re: Searching with docdb_family_id

Hello Lorens, All your observations are due to a small mistake in your query, you should have "FROM tls201_appln JOIN tls225_docdb_fam_cpc ON tls201_appln. docdb_family_id = tls225_docdb_fam_cpc. docdb_family_id ". (I left the mistake in your post to make it clear for others users.) Basica...
by EPO / PATSTAT Support
Thu Mar 30, 2023 4:36 pm
Forum: PATSTAT Product Line
Topic: Primary and Secondary Patents
Replies: 1
Views: 3988

Re: Primary and Secondary Patents

Hello Hien, A second medical use (further medical use according to Article 54(5) EPC) means that the compound was used in the past as a medicament, but for the treatment of a different disease. From classification point of view, there is no possibility to distinguish first or further medical uses , ...
by EPO / PATSTAT Support
Thu Mar 30, 2023 4:09 pm
Forum: PATSTAT Product Line
Topic: Count Patent applications that are granted and forward citation in specific year for specific company
Replies: 3
Views: 1123

Re: Count Patent applications that are granted and forward citation in specific year for specific company

That is a bit tricky because a family can have multiple granted applications filed in different years. But one can take the earliest_filing_year and count the families. The below query will give you the totals based on the earliest application filing year for each patent family member keeping in min...
by EPO / PATSTAT Support
Thu Mar 30, 2023 3:39 pm
Forum: PATSTAT Product Line
Topic: problems with %-operator / retrieve green inventory IPCs
Replies: 7
Views: 4336

Re: problems with %-operator / retrieve green inventory IPCs

On code 1) Using t1.appln_id in (select appln_id from tls209_appln_ipc where ipc_class_symbol in ('F02C 1/05','F02C 1/06' ) ) will retrieve all the data (and all the IPC codes for all the applications) for wich there is an IPC code = F02C 1/05' or 'F02C 1/06'. If you only want those values to be in ...
by EPO / PATSTAT Support
Thu Mar 30, 2023 3:21 pm
Forum: PATSTAT Product Line
Topic: Count number of patent applications and citations per company
Replies: 13
Views: 8757

Re: Count number of patent applications and citations per company

Making a "count" on the attribute nb_citing_docdb_fam is not correct. nb_citing_docdb_fam already gives you the the number of forward citations, so I assume you want to make the sum. You also have to keep in mind that the nb_citing_docdb_fam is a number that is calculated at FAMILY level, ...
by EPO / PATSTAT Support
Thu Mar 30, 2023 1:21 pm
Forum: PATSTAT Product Line
Topic: Searching with low-carbon classification
Replies: 1
Views: 717

Re: Searching with low-carbon classification

There is a typo in your SQL, and you have the appln_title in the SELECT part without having the tls202_appln_title in your joined tables. Also the Y-tags are part of the CPC scheme (table tls225_docdb_fam_cpc), and are not availalble in the IPC table. You have also joined the tls212 table, but you d...
by EPO / PATSTAT Support
Thu Mar 30, 2023 1:00 pm
Forum: PATSTAT Product Line
Topic: Extracting all swiss priority applications from applicants without duplicates
Replies: 4
Views: 1272

Re: Extracting all swiss priority applications from applicants without duplicates

Hello Kevin, Most applications will have more then one CPC classification code; and there is no uniform good way to assign one unique CPC classification symbol to one application (or family). (One could also question whether this is a good thing to do, because all classification codes have their pur...
by EPO / PATSTAT Support
Wed Mar 15, 2023 8:23 am
Forum: PATSTAT Product Line
Topic: Count number of patent applications and citations per company
Replies: 13
Views: 8757

Re: Count number of patent applications and citations per company

Hello Xiaohan, that query creates a too heavy load on the server and it is automatic cancelled because it takes too much resources on the server. (There is a build in limitation to avoid the system working on a query for more then one hour.) I run it on an my local system and it took about 4 hours. ...