Sunday, April 1, 2012

Legal data: is there life after grant

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.



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

 
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