Anyway difficult to answer as you work with specific user defined tables where only you know the content. But one can easily examine the balance between companies/individuals with the below query. As you can see there are large variations. Typical for the US where the ratio is 50/50 because inventor...

Or have a look at the "Open Patent Services" (OPS) here: https://www.epo.org/en/searching-for-patents/data/web-services/ops OPS-FAQ's : https://www.epo.org/en/service-support/faq/searching-patents/open-patent-services OPS-Forum: https://forums.epo.org/open-patent-services-ops-and-bulk-data...

It seems that a small error has sneaked into the script to create tls201_appln. The re-introduced attribute [appln_nr_epodoc] was ommitted. Below is a correction. USE [patstat2023b] GO /****** Object: Table [dbo].[tls201_appln] Script Date: 08/03/2022 13:30:00 ******/ SET ANSI_NULLS ON GO SET QUOTED...

At the EPO, citations can be added throughout the different (possible) stages of the application, granting, appeal or opposition procedure(s). (See attribute citn_origin in tls212 have an overview, and this document for coverage: REFI Statistics July 2023.pdf for PATSTAT coverage.) Because of the da...

Hello David, for a correct query, kindly see the answer to Sina's post. Or check: https://forums.epo.org/sql-queries-to-create-simple-applicant-year-based-table-10588 PATSTAT does not have a data item that could help users to identify (not) listed companies. The psn_sector attribute in tls206_person...

EPO's patent insight reports focus on future and emerging technologies. They are designed to provide and discover valuable insights into potentially disruptive technologies. The underlying data for these reports is mostly extracted from the PATSTAT data base. Also the methodology is published and yo...

Hello Marec, PATSTAT is a relational database, so it is not so easy to combine data that comes from many tables from the database in 1 "excel like" data sheet. The reason is that many attributes will have multiple occurrences, 1 application can have multiple publications with different dat...

Hello, in principle, WIPO ST3 codes are used for country --> appln_auth, country code in tls206,... (and organisations: EP, WO, etc..) codes. It does happen however that deviations enter the data, for example 'UK' for Great Britain, or 'JA' for Japan, 'PR' for Puerto Rico, etc.. ST3_list.pdf The ST3...

Hello Humphery, there are plenty of posts on the topic of forward citations count. See for example: https://forums.epo.org/count-patent-applications-that-are-granted-and-forward-citation-in-specific-year-for-specific-company-12764#p40953 https://forums.epo.org/count-number-of-patent-applications-and...

Hallo Jens, As far as I am aware, WIPO is indeed using PATSTAT for some of its statistics, but I don't know how they compile their statistics and what method they apply for the data you are comparing with. With other words, in PATSTAT, we can 100% explain an reproduce any data compiled with PATSTAT ...