When examining data contained in PRS legal data table (TLS221 described here http://www.epo.org/searching/subscription/raw/product-14-24-1.html) is important to know the period of applications life time cicle in which we are observing the legal events.
For example, if we want to know whether changes of ownership are recorded only before grant or also, at some extend, after grant, should compare PRS gazzette date to date of publication of first granted document (in appendix you can find sql code for doing that).
Results are listed in following table, filtered for events with occurrence > 10.000, EP as application authority and on october 2010 data.
Going back to the question about cahnges of ownerships we see in particular:
SQL code for extracting the data - uncommented -
Select
b.APPLN_AUTH, a.prs_code, Count(a.appln_id) As c
From
patstat.tls221_inpadoc_prs a Inner Join
patstat.tls201_appln b On a.appln_id = b.APPLN_ID
Where
b.APPLN_AUTH = "EP" Group By
b.APPLN_AUTH, a.prs_code;
create table t1
Select b.APPLN_AUTH, c.PUBLN_DATE As gdate, b.APPLN_ID
From
patstat.tls201_appln b Inner Join
patstat.tls211_pat_publn c On b.APPLN_ID = c.APPLN_ID
Where
b.APPLN_AUTH = "EP" And
c.PUBLN_FIRST_GRANT = 1
Group By
b.APPLN_AUTH, c.PUBLN_FIRST_GRANT, c.PUBLN_DATE, b.APPLN_ID;
alter table t1 add index id1(appln_id);
Select a.prs_code, Count(a.prs_event_seq_n) As c
From
t1 t Inner Join
patstat.tls221_inpadoc_prs a On t.APPLN_ID = a.appln_id
Where
a.prs_gazette_date > t.gdate
Group By
a.prs_code, a.prs_gazette_date;
For example, if we want to know whether changes of ownership are recorded only before grant or also, at some extend, after grant, should compare PRS gazzette date to date of publication of first granted document (in appendix you can find sql code for doing that).
Results are listed in following table, filtered for events with occurrence > 10.000, EP as application authority and on october 2010 data.
prs_code
|
tot
|
postgrant
|
% PG
|
121
|
234443
|
0
|
0,00%
|
122
|
51344
|
0
|
0,00%
|
17P
|
2019601
|
27
|
0,00%
|
17Q
|
1397420
|
24
|
0,00%
|
18D
|
461702
|
23
|
0,00%
|
18R
|
54072
|
3
|
0,01%
|
18W
|
126739
|
462
|
0,36%
|
26
|
86541
|
86522
|
99,98%
|
26N
|
898466
|
898443
|
100,00%
|
27A
|
15231
|
15230
|
99,99%
|
27O
|
12173
|
12173
|
100,00%
|
27W
|
17080
|
17080
|
100,00%
|
A4
|
212027
|
3
|
0,00%
|
AC
|
105361
|
1
|
0,00%
|
AK
|
4037202
|
15357
|
0,38%
|
AKX
|
519191
|
2724
|
0,52%
|
AL
|
162387
|
0
|
0,00%
|
AX
|
1163669
|
371
|
0,03%
|
AXX
|
45469
|
975
|
2,14%
|
BE20
|
13122
|
13121
|
99,99%
|
BERE
|
257006
|
256976
|
99,99%
|
DAX
|
279119
|
158
|
0,06%
|
DET
|
14085
|
59
|
0,42%
|
DFPE
|
78954
|
0
|
0,00%
|
DPE1
|
12850
|
0
|
0,00%
|
EAL
|
68064
|
68062
|
100,00%
|
EL
|
12272
|
152
|
1,24%
|
EN
|
89853
|
89804
|
99,95%
|
ENP
|
79451
|
0
|
0,00%
|
EPTA
|
33572
|
33398
|
99,48%
|
ET
|
674270
|
674067
|
99,97%
|
ET3
|
10255
|
10249
|
99,94%
|
EUG
|
188093
|
187615
|
99,75%
|
GBPC
|
483205
|
483160
|
99,99%
|
GBPR
|
11473
|
11464
|
99,92%
|
GBT
|
218467
|
218366
|
99,95%
|
GBV
|
37396
|
37381
|
99,96%
|
ITCL
|
10790
|
8
|
0,07%
|
ITF
|
306954
|
227799
|
74,21%
|
ITPR
|
10854
|
10650
|
98,12%
|
ITTA
|
81250
|
80202
|
98,71%
|
LTIE
|
27039
|
25201
|
93,20%
|
NENP
|
125118
|
0
|
0,00%
|
NLR1
|
56501
|
56498
|
99,99%
|
NLR2
|
20403
|
20402
|
100,00%
|
NLS
|
34363
|
34363
|
100,00%
|
NLT1
|
16383
|
16382
|
99,99%
|
NLT2
|
24394
|
24389
|
99,98%
|
NLV1
|
219721
|
219691
|
99,99%
|
NLV4
|
220591
|
220570
|
99,99%
|
NLV7
|
16305
|
16304
|
99,99%
|
PG25
|
7725957
|
6508218
|
84,24%
|
PGFP
|
5139750
|
5136746
|
99,94%
|
R17D
|
13437
|
21
|
0,16%
|
R26
|
28663
|
28663
|
100,00%
|
RAP1
|
486716
|
45
|
0,01%
|
RAP2
|
58529
|
58518
|
99,98%
|
RAP3
|
28846
|
0
|
0,00%
|
RAX
|
29098
|
227
|
0,78%
|
RBV
|
188216
|
1974
|
1,05%
|
REF
|
1221316
|
987826
|
80,88%
|
REG
|
3835283
|
3229995
|
84,22%
|
RHK1
|
20838
|
1
|
0,00%
|
RIC1
|
548527
|
38
|
0,01%
|
RIN1
|
895614
|
474
|
0,05%
|
RIN2
|
14939
|
14937
|
99,99%
|
RTI1
|
79745
|
5
|
0,01%
|
WWE
|
462081
|
0
|
0,00%
|
WWG
|
80218
|
0
|
0,00%
|
WWP
|
195521
|
0
|
0,00%
|
WWW
|
63321
|
0
|
0,00%
|
XX
|
11526
|
226
|
1,96%
|
Going back to the question about cahnges of ownerships we see in particular:
| 'EP' | RAP1 | 486716 | 45 | 0,01% |
| 'EP' | RAP2 | 58529 | 58518 | 99,98% |
RAP1 transfer of rights of an EP application
RAP2 Transfer of rights of an EP publication
RAP2 Transfer of rights of an EP publication
SQL code for extracting the data - uncommented -
Select
b.APPLN_AUTH, a.prs_code, Count(a.appln_id) As c
From
patstat.tls221_inpadoc_prs a Inner Join
patstat.tls201_appln b On a.appln_id = b.APPLN_ID
Where
b.APPLN_AUTH = "EP" Group By
b.APPLN_AUTH, a.prs_code;
create table t1
Select b.APPLN_AUTH, c.PUBLN_DATE As gdate, b.APPLN_ID
From
patstat.tls201_appln b Inner Join
patstat.tls211_pat_publn c On b.APPLN_ID = c.APPLN_ID
Where
b.APPLN_AUTH = "EP" And
c.PUBLN_FIRST_GRANT = 1
Group By
b.APPLN_AUTH, c.PUBLN_FIRST_GRANT, c.PUBLN_DATE, b.APPLN_ID;
alter table t1 add index id1(appln_id);
Select a.prs_code, Count(a.prs_event_seq_n) As c
From
t1 t Inner Join
patstat.tls221_inpadoc_prs a On t.APPLN_ID = a.appln_id
Where
a.prs_gazette_date > t.gdate
Group By
a.prs_code, a.prs_gazette_date;
No comments:
Post a Comment