Loading PATSTAT in a MS SQL server is dependant on your MS SQL server edition and your server settings. At the EPO we use MS SQL Enterprise edition 2017. This means we can use the Bulk data tools to import the data. The scripts might not work on earlier versions of MS SQL server. So, this is what wo...

Hello Asraf, The scripts provided in the documentation for creating the data base and the tables are only provided as an example on how it can be done. CREATE DATABASE [patstat2019b] ON PRIMARY ( NAME = N'patstat2019b_dat', FILENAME = N'D:\mssql_dbs\patstat2019b\patstat2019bdat.mdf' , SIZE = 200000M...

Hello Ucindami, indeed, replenishment via the priority filings or the family members is the best approach to add the missing country codes. The EPO will make available any country information it receives from the respective national patent offices. And we will not replenish any person country data o...

Hello Patty,
the easiest check is to do a record count on all of the tables.
In the attached file you will find the SQL query and the results is should show for PATSTAT Autumn 2019 - with the understanding that you loaded all tables and files.

Hello Richard, table TLS214_NPL_PUBLN can be linked to TLS212_CITATION via the attribute NPL_PUBLN_ID. Here is a query that extract all citation information (exept the citation categories) from a single patent applications. SELECT citing.appln_id, citing.publn_auth, citing.publn_nr, citing.publn_kin...

Hello Richard, "Connecting" or "linking" tables in PATSTAT is done via the different kinds of SQL "JOIN" s. A JOIN clause is used to combine rows from two or more tables, based on (a) related column(s) between them. This "related column" is very often the primary key or a combination of "foreign key...

1980 was the first year EP patents were granted. select year(publn_date) grant_date , count(appln_id) #_applications from tls211_pat_publn where publn_kind = 'B1' and publn_auth = 'EP' group by year(publn_date) order by year(publn_date) So it makes sense that no renewal fees records are available fr...

Hello Ucindami, your questions are rather related to the patent application & granting procedure. A good introduction to the general rules for EP and PCT (international) applications are the "Guide for applicants", which you can find at this link: http://documents.epo.org/projects/babylon/eponet.nsf...

Hello Thomas, the concept of OECD triadic families is not based on EPO (DocDB % INPADOC) patent families. For more information on the OECD approach, kindly have a look at the attached documents: OECD Triadic patent families methodology.pdf OECD Triadic Patent Families - Sept 2017.pdf Replicating the...

"My intention is to capture the level of innovation at the country level." Many researchers are using the first priority filing to measure innovative capacity. But it does not work for EP and WO applications (or other regional offices) where no priority was filed. ... In which case they mostly use t...