Search found 425 matches
- 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...
- 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.
- 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...
- 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 , ...
- 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...
- 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 ...
- 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, ...
- 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...
- 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...
- 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. ...