KITeS Patstat based reports

I've been vacating this blog for the majority of june because I implemented a set of reports based on Patstat EPO data.

At web address db.kites.unibocconi.it you will be able to find the following reports


Patent count by inventor country / priority year
Patent count by applicant country / priority year
Patent count by inventor region / priority year
Patent count by applicant region / priority year
Patent count by inventor nuts3 / priority year
Patent count by applicant nuts3 / priority year
Patent count by applicant name / priority year
Patent count by main IPC - first 4 digits
Patent count by main IPC class reclassified on OST30
Patent count by applicant, priority year, OST30 IPC reclassification
Patent count by applicant country, county, region, OST30 IPC reclassification, priority year
Citations count by applicant name, priority year
Citations count by applicant country, priority year
Citations count by inventor country, priority year
Copatenting by inventor country, priority year
Copatenting by applicant country, priority year
Applicants by IPC - first 4 digits
Inventors by IPC - first 4 digits

Please remember this is still a beta release; feel free to report me any problem or suggestion...

Eventually you will find some other reports password protected; such reports contain detail data and cannot be distributed since PATSTAT data are property of EPO.

Let's start from...

the end.
Nowadays I work as a database administrator @ KITES (Knowledge, Internationalization and Technology Studies), a dept. caring of economics of innovation in Bocconi University.
One of my main contributes to Kites was creating a database about patents application at EPO and USPTO.
Mainly our db is based on PATSTAT data and developed in mysql. Soon I'm going to post (since it seems EPO do not provide them) some scripts useful for importing patstat in mysql.
Anyway, this blog is going to be a very technical one (so very boring for most of people) aiming first of all to help me to put order in the stuff I deal with. Eventually if some other people could advantage from it, that could be good.