A quick query to understand what application authorities are covered by TLS221 in Patstat:
Epo website says :
The product contains legal status records from over 40 international patent authorities.
The records originate from the patent gazettes or registers of various national patent authorities, including the EPO and WIPO. The EP data is generated both during the EPO patent granting procedure and in the post-grant phase.
to check the coverage
http://www.epo.org/searching/data/data/tables/weekly.html under Contents and coverage of the INPADOC legal status file
if we want to go deeper and see the coverage on all patstat applications we may run this:
Select
t1.APPLN_AUTH,
Count(Distinct t1.APPLN_ID) as app,
Count(Distinct t21.appln_id) app_legal,
Count(Distinct t21.appln_id)/Count(Distinct t1.APPLN_ID) as coverage
From
patstat.tls221_inpadoc_prs t21 Right Join
patstat.tls201_appln t1 On t1.APPLN_ID = t21.appln_id
Group By
t1.APPLN_AUTH
this is the result, removing application authorities where the number of applications is < 10K or the coverage < 10%
APPLN_AUTH
|
app
|
app_legal
|
coverage
|
AR
|
133065
|
49143
|
36,9%
|
AT
|
1163048
|
606840
|
52,2%
|
AU
|
1696435
|
620201
|
36,6%
|
BE
|
650688
|
97244
|
14,9%
|
BR
|
572786
|
355298
|
62,0%
|
CA
|
3211302
|
1059241
|
33,0%
|
CH
|
1068158
|
237457
|
22,2%
|
CN
|
7822408
|
7348427
|
93,9%
|
CO
|
21529
|
9209
|
42,8%
|
CZ
|
78888
|
47768
|
60,6%
|
DD
|
248546
|
98559
|
39,7%
|
DE
|
7220942
|
3107178
|
43,0%
|
DK
|
469471
|
112682
|
24,0%
|
EA
|
34280
|
15409
|
45,0%
|
EP
|
3231522
|
3123783
|
96,7%
|
ES
|
1082075
|
338510
|
31,3%
|
FI
|
285528
|
146684
|
51,4%
|
FR
|
3151796
|
886785
|
28,1%
|
GB
|
3464343
|
1173776
|
33,9%
|
HK
|
100611
|
49436
|
49,1%
|
HU
|
140921
|
72310
|
51,3%
|
IB
|
110041
|
106228
|
96,5%
|
IE
|
93801
|
22792
|
24,3%
|
IL
|
223873
|
83164
|
37,2%
|
IT
|
776176
|
148388
|
19,1%
|
JP
|
18723392
|
5541863
|
29,6%
|
NL
|
621779
|
220155
|
35,4%
|
NO
|
236307
|
65839
|
27,9%
|
NZ
|
136314
|
77687
|
57,0%
|
PE
|
15762
|
13065
|
82,9%
|
PL
|
264364
|
48803
|
18,5%
|
PT
|
104943
|
28712
|
27,4%
|
RU
|
713402
|
345337
|
48,4%
|
SE
|
1102754
|
155545
|
14,1%
|
SI
|
29417
|
6070
|
20,6%
|
SK
|
26396
|
5360
|
20,3%
|
TW
|
887232
|
280871
|
31,7%
|
US
|
14067437
|
6738157
|
47,9%
|
