Friday, December 12, 2014

Patstat 2014b mysql upload scripts

 Autumn 2014 patstat ediction (now onward 2014b) has just been released.
 Here you can download the mysql scripts I made for uploading the files from DVDs data.

remember to customize them for your own upload directory / target library
also note I did not upload TLS 203, 222 and 223 but scripts should work fine

Here below a comparison with expected records and october 2013 version
table
date of files
declared
patstat Y-1
imported
delta imp
delta y-1
tls201_appln
2014b
80025895
76594275
80025895
0
4.48%
tls202_appln_title
2014b
60127407
57335762
60127391
16
4.87%
tls203_appln_abstr
2014b
36607548
33870394
36607548
0
8.08%
tls204_appln_prior
2014b
35035840
33615459
35035840
0
4.23%
tls205_tech_rel
2014b
2149383
2138085
2149383
0
0.53%
tls206_person
2014b
47827725
44730405
47827690
35
6.92%
tls207_pers_appln
2014b
176679567
163534542
176679567
0
8.04%
tls208_doc_std_nms
2014b
22127059
19409591
22127059
0
14.00%
tls209_appln_ipc
2014b
195884529
176153334
195884529
0
11.20%
tls210_appln_n_cls
2014b
22016211
21884148
22016211
0
0.60%
tls211_pat_publn
2014b
90478383
85733781
90478383
0
5.53%
tls212_citation
2014b
160518077
142247157
160518077
0
12.84%
tls214_npl_publn
2014b
25448833
22095090
25448826
7
15.18%
tls215_citn_categ
2014b
23690308
22390889
23690308
0
5.80%
tls216_appln_contn
2014b
2459400
2272520
2459400
0
8.22%
tls218_docdb_fam
2014b
71081760
67766434
71081760
0
4.89%
tls219_inpadoc_fam
2014b
78312042
74865923
78312042
0
4.60%
tls221_inpadoc_prs
2014b
157857976
135555494
135555494
0
16.45%
tls222_appln_jp_class
2014b
304165357
294109156
294109156
0
3.42%
tls223_appln_docus
2014b
39008347
36668997
36668997
0
6.38%
tls224_appln_cpc
2014b
149340067
137478291
149340067
0
8.63%
tls226_person_orig
2014b
52524269
47699382
52524269
0
10.12%
tls227_pers_publn
2014b
210802117
193982180
210802117
0
8.67%