Thank you so much for the useful information. I'm seeking clarification on the docdb_family_size attribute. Below is the code I'm referencing: SELECT psn_name, appln_auth,person_ctry_code,docdb_family_size, COUNT(distinct(case when t1.appln_filing_year = 2011 then t1.appln_id end)) as '2011', COUNT(...

Dear PATSTAT community, I am currently working with the PATSTAT Autumn 2023 edition. I have a panel dataset of the number of patent applications filed (not granted) by Dutch companies in the pharmaceutical field for the period of 12 years, from 2011 to 2022. I'm wondering whether it's feasible to co...

Thank you very much for your response! All the codes provided work fine! I'm wondering if there is any way to aggregate the number of patent applications filed by a Netherland firm both in domestic and foreign countries? As I can see from the result table after running the second code, one firm can ...

Dear PATSTAT community, I am currently working with the PATSTAT Spring 2023 edition. I would like to get the number of patent applications filed by Netherlands companies in the pharmaceutical field for the period of 12 years, from 2011 to 2022. Here are my codes: SELECT psn_name, person_ctry_code, a...

Dear PATSTAT community, I am currently using PATSTAT Autumn 2022 edition. I am interested in understanding more about primary patents, i.e., patents on active ingredients, and secondary patents, i.e., patents filed on other aspects of active ingredients such as different dosage forms, formulations, ...

Dear PATSTAT community, I would like to count the number of forward citations per year for a set of biotechnology companies. The following queries work fine but would be great to double check with you to see if they're correct: SELECT psn_name, COUNT(distinct(case when appln_filing_year = 2008 then ...

Thank you so much for your help! Could you please correct me if I'm wrong that: the information on events and patent owners is in the PRS database (PATSTAT version: April 2014) which is now included in tables tls231 and tls803? (Please see the journal titled Tracking patent transfers in different Eu...

Dear PATSTAT community, I am working with PATSTAT Online 2022 Spring and am currently interested in exploring information on the transfers of patents, i.e., the name of the buyer and of the seller, the date at which the assignment was recorded at the patent office, etc. for each assignment. I'm wond...

Hi everyone, I am currently working with PATSTAT Autumn 2021 edition. I would like to retrieve a sample of the total number of citations in the UK patent documents for biotechnology firms per year, from 2011 to 2021. This is my code so far. I would like to use COUNT command for nb_citing_docdb_fam t...

Hi everyone,

I am currently working with PATSTAT Autumn 2021 edition. I would like to retrieve a sample of the number of citations in the UK patent documents for biotechnology firms from 2011 to 2021.

I am not sure how to obtain the results.

Any help is much appreciated. Many thanks in advance.