Hello Lennart, there is a small typo in your query; CPC codes need to have 8 characters before the / . This means that one has to add "spaces" to make it 8 characters. See query below, I also used the STRING_AGG function and a GROUP BY to reduce the number of rows, and de_duplicate the CPC...

Hello Darwin, For the majority of the DocDB families, the "earliest_appln_id" will refer to one and the same application for all family members. In the complete PATSTAT database (2020a) there are 185.919 out of 76.458.745 (0.2%) DocDB families that have more then 1 "earliest_appln_id&...

Hello Thanos, PATSTAT does not contain information on whether a company is public or private. The PSN_SECTOR allows you the sort already companies from other applicants. You could probably make some kind of analysis on legal entity extensions in the applicant name that indicate whether that company ...

Hello Edwardsj, the answer is straightforward, from 2010 onwards, we do not receive applicant country codes for applications filed in China. There is not much we can do about this, you might simply exclude applications filed in China from your data (at least the utility models), and maybe only take ...

Hello Darwin, there are plenty of scientific and policy publications that touch on the topic of measuring innovation through patent analytics. One of the main sources is the OECD: https://www.oecd.org/site/innovationstrategy/measuringinnovationanewperspective-onlineversion.htm OECD has developed var...

Your query is correct. Here is a small adaptation that will explicitly look for applicants and exclude inventors. SELECT psn_name, person_ctry_code , applt_seq_nr , tls201_appln.* FROM tls201_appln JOIN tls207_pers_appln ON tls207_pers_appln.appln_id = tls201_appln.appln_id JOIN tls206_person ON tls...

Hello , the easiest approach would be to use the NUTS codes available in the tls904_nuts table and linkable to the tls206_person table. The first step is to define "Brussels"; the wider "provincial level" the region or the capital. The query below gives you an overview of all Bel...

The spread of the coronavirus has led to many restrictions and has it made nearly impossible for colleagues and friends to physically meet. Video conferencing, virtual team meetings, home-working and e-conferencing have become the norm and it is hard to believe that it ever will be business as usual...

Hello Darwin, PATSTAT does not have an indicator that can quantify the contribution of an assignee to an invention. As far as I am aware: On applicant/assignee/inventor: the term "assignee" is only used for applications filed at the USPTO. (Is there a legal definition of "primary assi...

Hello Faery, is your network applicant or inventor based (or both) ? Your query looks for Chinese inventors (or inventors/applicants) co-filing with non-Chinese applicants . I assume you want to build some kind of matrix, what is in the columns, rows and the intersections ? You also did not limit yo...