Monday, November 27, 2017

PATSTAT 2017b MySql upload scripts

From link:

https://www.dropbox.com/s/hkkn0xapxfymdl8/patstat2017b.zip?dl=0

it's possible to download my scripts for mysql allowing to upload the majority of tables from ediction 2017b of PATSTAT;

changes from previous ediction:
Table TLS214_NPL_PUBLN
Some attributes are now populated for more NPL types.
Attribute ONLINE_CLASSIFICATION may hold more than one Derwent class.
Attribute ONLINE_AVAILABILITY can now hold up to 500 characters.
Attribute NPL_AUTHOR can now can hold up to 1 000 characters.

Table TLS231_INPADOC_LEGAL_STATUS:
New attribute EVENT_FILING_DATE

Note also The OECD harmonized name (cf. attributes HAN_ID, HAN_NAME, HAN_HARMONIZED) have not been updated since the 2016 Autumn Edition. As a consequence, persons which have been added since then will have default values in these attributes.

No comments:

Post a Comment