Tuesday, November 6, 2012

Patstat oct 2012 ediction mysql scripts

As each november, EPO released new version of PATSTAT
No changes in last 12 mths about data structure so you can download from here

https://dl.dropbox.com/u/3004945/rawpatentdata/PATSTATMYSQL201210.zip


my upload scripts for mysql.

Down here the declared number of records by table



Table name
Number of rows per table
TLS201_APPLN
73.177.050
TLS202_APPLN_TITLE
54.184.267
TLS203_APPLN_ABSTR
31.187.723
TLS204_APPLN_PRIOR
32.125.776
TLS205_TECH_REL
2.131.770
TLS206_PERSON
41.478.412
TLS207_PERS_APPLN
152.682.496
TLS208_DOC_STD_NMS
18.766.111
TLS209_APPLN_IPC
177.915.634
TLS210_APPLN_N_CLS
21.844.519
TLS211_PAT_PUBLN
82.561.787
TLS212_CITATION
125.658.281
TLS214_NPL_PUBLN
19.128.778
TLS215_CITN_CATEG     
20.850.431
TLS216_APPLN_CONTN
2.104.686
TLS217_APPLN_ECLA
126.336.465
TLS218_DOCDB_FAM
64.571.193
TLS219_INPADOC_FAM
73.177.050
TLS221_INPADOC_PRS
111.194.984
TLS222_APPLN_JP_CLASS
285.734.975
TLS223_APPLN_DOCUS
                                     33.590.420





No comments:

Post a Comment