PATSTAT and national databases

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Posts: 1
Joined: Tue Nov 10, 2015 5:06 pm

PATSTAT and national databases

Post by hEph0faL0al1cik2weWs » Tue Nov 10, 2015 5:13 pm


I'm working with two different databases. I have a database containing all patents issued by the Italian Patent Office from 1969 to today. I also have the latest version of PATSTAT.
My goal is to create a new database containing all patents developed by Italian inventors, avoiding to double count the patents that are in both the Italian database and PATSTAT.
Do you have suggestions on how to proceed?

Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm

Re: PATSTAT and national databases

Post by nico.rasters » Fri Nov 20, 2015 2:35 pm

Which fields are available in your Italian Patent Office database?
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship

Posts: 62
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy

Re: PATSTAT and national databases

Post by gianluca.tarasconi » Mon Nov 23, 2015 8:50 am

I did a similar exercise

you should work on publication numbers mainly matching them with TLS211, trying different combinations (leading zeroes etc)

good luck!

Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: PATSTAT and national databases

Post by Geert Boedt » Tue Nov 24, 2015 10:15 am

I am also a little bit curious about your Italian data set.
Can you give us some more information on the source, or maybe better, upload a sample data set ?

Many thanks,
PATSTAT User Support
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna

Post Reply