tls206_ascii

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

patstat2013
Posts: 1
Joined: Wed Nov 13, 2013 2:52 pm

tls206_ascii

Post by patstat2013 » Wed Nov 13, 2013 3:06 pm

Hi,

I have PATSTAT 2013 April version and have a question regarding the variables in the tls206_ascii files as I am not able to find any documentation on the topic. I am trying to retrieve the geospatial distribution of patents across countries and is therefore particularly interested in knowing what the definition of the variable wk_country is. Is there any code book for these files?

Many thanks in advance!

NF


mkracker
Posts: 120
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: tls206_ascii

Post by mkracker » Tue Dec 10, 2013 12:10 pm

The TLS206_ASCII table was never really part of PATSTAT, but for “the programmers only”. It contained a mixture of application data (TLS201_APPLN) and person data (tables TLS206, TLS207, TLS208), and unfortunately never was sufficiently documented.

You asked about the WK_COUNTRY attribute: It is just a copy of the APPLN_AUTH attribute of table TLS201_APPLN.

Because of this weak support of TLS206_ASCII, in the Oct 2013 edition of PATSTAT it has been replaced by the table TLS226_PERSON_ORIG. It now is treated as every other PATSTAT table:
• It can be loaded as every other table
• It is fully documented
• It contains the original name & address data, as taken from DOCDB, EP Register files and USPTO files. The structure of these sources is preserved, no data cleaning is taken place.
• It contains only address/name data, no other bibliographic data about application, publication or the the persons role (applicant and/or inventor)
• It is the bases of the cleaned names / addresses as found in table TLS206_PERSON.

More details can be found in the Data Catalog v5.00.
I highly recommend to stop using TLS206_ASCII of PATSTAT April 2013 and use table TLS226_PERSON_ORIG of the Oct 2013 edition instead.

Martin Kracker
EPO - PATSTAT
-------------------------------------------
Martin Kracker / EPO


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: tls206_ascii

Post by nico.rasters » Tue Dec 10, 2013 6:02 pm

The OECD REGPAT database might also be interesting for you, at least if you want to go beyond the country level.
patent applications to the EPO and PCT filings linked to more than 5 500 regions using the inventors/applicants addresses (covering regions from selected countries outside the OECD area).
http://www.oecd.org/sti/inno/oecdpatentdatabases.htm
http://www.oecd.org/sti/inno/40794372.pdf
________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


Post Reply