Sunday, May 10, 2015

Patstat Count of applications by application authority (on 2014b version)

A quick statistic allowing to understand the coverage of patstat allover the 173 application authorities listed in the DB.
Counts also show the first and last applciation year (some have to be taken with some caveat, FI 1904 for DD that had been created in 1946...)

Counts exclude D1 and D2 application kind and those with applciation year 9999

Country codes have been 'decoded' using both TLS801 and this website for missing codes.

http://www.stevemorse.org/jcal/countries.html



Count
Min_year
Max_year
continent
notes
AE
49
1961
2012
ASIA

AF
1
1976
1976
ASIA

AL
6
1995
2012
EUROPE

AM
208
1993
2013
ASIA

AN
1
1964
1964
NORTH AMERICA

AO
2
2000
2011
AFRICA

AP
7416
1977
2014
AFRICA
ARIPO
AR
132898
1904
2013
SOUTH AMERICA

AT
1157607
1885
2014
EUROPE

AU
1646087
1891
2014
AUSTRALIA

AW
3
2007
2010
NORTH AMERICA

AZ
166
1995
2012
ASIA

BA
409
1986
2013
EUROPE

BB
2
1993
1993
NORTH AMERICA

BD
6
2002
2008
ASIA

BE
376224
1848
2014
EUROPE

BG
54657
1924
2013
EUROPE

BH
2
1999
2009
ASIA

BI
10
2000
2009
AFRICA

BN
4
2012
2012
ASIA

BO
29
1927
2012
SOUTH AMERICA

BR
571760
1900
2014
SOUTH AMERICA

BS
2
1999
2004
NORTH AMERICA

BW
1
1999
1999
AFRICA

BX
120
1947
2013
EUROPE
Benelux TM office
BY
1261
1993
2013
EUROPE

BZ
1
2005
2005
NORTH AMERICA

CA
1639757
1875
2014
NORTH AMERICA

CG
4
1918
1988
AFRICA

CH
1064463
1888
2014
EUROPE

CI
1
1970
1970
AFRICA

CL
5068
1910
2013
SOUTH AMERICA

CM
5
1972
1992
AFRICA

CN
7816964
1944
2014
ASIA

CO
21513
1922
2014
SOUTH AMERICA

CR
6185
1924
2014
NORTH AMERICA

CS
161988
1910
2011
EUROPE
SPLITTED
CU
4512
1907
2013
NORTH AMERICA

CY
3828
1921
2012
ASIA

CZ
78233
1919
2014
EUROPE

DD
176301
1904
1997
EUROPE
chg to DE
DE
6384201
1866
2014
EUROPE

DK
411281
1896
2014
EUROPE

DM
2
2008
2012
NORTH AMERICA

DO
3052
1925
2014
NORTH AMERICA

DZ
1593
1969
2013
AFRICA

EA
34171
1996
2013
AFRICA
Ceuta, Melilla
EC
10129
1926
2012
SOUTH AMERICA

EE
6968
1925
2013
EUROPE

EG
13984
1927
2014
AFRICA

EM
17711
1920
2013
EUROPE
(TM OFFICE)
EP
3223798
1978
2014
EUROPE

ER
5
2000
2007
AFRICA

ES
1075857
1826
2014
EUROPE

FI
240860
1919
2014
EUROPE

FR
3083912
1844
2014
EUROPE

GA
2
1998
2009
AFRICA

GB
3410947
1782
2014
EUROPE

GC
441
1998
2012
ASIA
(GULF COUNCIL)
GE
4975
1987
2013
ASIA

GH
11
1998
2013
AFRICA

GN
5
1996
1998
AFRICA

GR
100120
1920
2014
EUROPE

GT
6279
1926
2013
NORTH AMERICA

GY
1
1937
1937
SOUTH AMERICA

HK
100561
1954
2014
ASIA

HN
973
1979
2014
NORTH AMERICA

HR
16093
1992
2014
EUROPE

HT
7
1976
1985
NORTH AMERICA

HU
139209
1898
2014
EUROPE

IB
109957
1994
2014
WORLD
= WIPO
ID
14850
1913
2013
ASIA

IE
93298
1928
2014
EUROPE

IL
223632
1935
2014
ASIA

IN
80659
1912
2014
ASIA

IQ
17
1966
2012
ASIA

IR
75
1961
2012
ASIA

IS
8110
1924
2014
EUROPE

IT
741127
1886
2014
EUROPE

JM
8
2000
2012
NORTH AMERICA

JO
1825
1968
2012
ASIA

JP
17777076
1906
2014
ASIA

KE
1431
1973
2013
AFRICA

KG
31
1994
2012
ASIA

KP
85
1973
2013
ASIA

KR
2857036
1948
2014
ASIA

KW
2
1984
2011
ASIA

KZ
795
1992
2013
ASIA

LB
118
1930
2011
ASIA

LI
20
1938
2006
EUROPE

LK
178
1907
2012
ASIA

LR
3
1968
1994
AFRICA

LS
3
1994
1996
AFRICA

LT
4233
1930
2014
EUROPE

LU
58776
1918
2014
EUROPE

LV
5746
1926
2014
EUROPE

LY
4
1959
2009
AFRICA

MA
16929
1917
2013
AFRICA

MC
2784
1952
2013
EUROPE

MD
5909
1940
2014
EUROPE

ME
558
1993
2012
EUROPE

MG
3
2003
2010
AFRICA

MK
104
1994
2012
EUROPE

MN
249
1972
2012
ASIA

MO
1
2007
2007
ASIA

MR
1
1988
1988
AFRICA

MT
577
1968
2011
EUROPE

MU
5
1988
2012
AFRICA

MW
739
1968
1993
AFRICA

MX
235504
1904
2014
NORTH AMERICA

MY
44445
1923
2014
ASIA

MZ
1
2012
2012
AFRICA

NA
7
2008
2010
AFRICA

NE
1
1984
1984
AFRICA

NG
20
1978
2013
AFRICA

NI
203
1953
2013
NORTH AMERICA

NL
438623
1862
2014
EUROPE

NO
228502
1893
2014
EUROPE

NP
3
1995
2011
ASIA

NZ
135474
1894
2014
AUSTRALIA

OA
13488
1959
2014
AFRICA
ARIPO
OM
3
1989
2012
ASIA

PA
2401
1927
2011
NORTH AMERICA

PE
15736
1925
2014
SOUTH AMERICA

PH
23405
1951
2014
ASIA

PK
53
1935
2013
ASIA

PL
262697
1919
2014
EUROPE

PT
104910
1902
2014
EUROPE

PY
16
1949
2010
SOUTH AMERICA

RH
42
1926
1985
NORTH AMERICA
(obsolete now HT)
RO
70911
1900
2014
EUROPE

RS
4033
1997
2014
EUROPE

RU
707476
1910
2014
EUROPE

SA
42
1959
2012
ASIA

SB
1
2007
2007
AUSTRALIA

SD
50
1990
2008
AFRICA

SE
406012
1854
2014
EUROPE

SG
80636
1949
2014
ASIA

SH
1
1922
1922
AFRICA

SI
29399
1974
2014
EUROPE

SK
26359
1942
2014
EUROPE

SL
2
1919
2007
AFRICA

SM
1151
1997
2014
EUROPE

SN
1
1978
1978
AFRICA

SR
4
1996
2009
SOUTH AMERICA

SU
1358778
1910
2006

Former USSR
SV
1607
1968
2013
NORTH AMERICA

SY
93
1926
2012
ASIA

TH
640
1968
2013
ASIA

TJ
453
1992
2012
ASIA

TM
2
2002
2005
ASIA

TN
340
1902
2012
AFRICA

TR
67124
1903
2014
EUROPE

TT
46
1926
2013
NORTH AMERICA

TW
858202
1970
2014
ASIA

TZ
3
1961
2009
AFRICA

UA
105551
1932
2013
EUROPE

UG
1
2007
2007
AFRICA

US
13069923
1790
2014
NORTH AMERICA

UY
10567
1923
2014
SOUTH AMERICA

UZ
86
1993
2013
ASIA

VA
6
1938
1971
EUROPE

VE
106
1937
2012
SOUTH AMERICA

VG
1
2000
2000
NORTH AMERICA

VN
329
1954
2013
ASIA

WO
1
1983
1983
WORLD
WIPO
XH
1792
1990
2013


YE
1
1994
1994
ASIA

YU
44261
1921
2008
EUROPE
SPLITTED
ZA
273882
1918
2014
AFRICA

ZM
2740
1966
2012
AFRICA

ZR
1
1991
1991
AFRICA
Formerly Zaire now CD
ZW
2910
1953
2011
AFRICA

6 comments:

Anonymous said...

I want to create my local PATSTAT database with a Microsoft SQL Server. Therefore I want to know if there are existing SQL scripts to create the PATSTAT database scheme and scripts to Import /update the database?

Tank's for your answer.

GL said...

Hi
Patstat documentation CDs contains some scripts for SQLserver 2012... this is the description:

SQLServerScripts

• CreateDatabaseScript: contains 1 script to create the latest PATSTAT database -> "createDatabaseSQLserver.sql".

• CreateIndexScripts: contains a set of scripts to create extra indexes on various PATSTAT tables. allindexes.sql will run all scripts in 1 go. You probably want to create extra indexes depending on the type of queries you do. You should run these scripts AFTER you have loaded the data in the tables.

• CreateTableScripts: contains a set of scripts to create the various tables in PATSTAT after you have created the database with the "CreateDatabaseSQLserver.sql" script.

• "Creating PATSTAT in MS SQL SERVER 2008.doc": Step by step instructions how to create the PATSTAT data base on a working MS SQL SERVER 2008 platform.

hope it helps

Anonymous said...

thnak you very much for your quick answer

Anonymous said...

one more question: What's the best way to import the PATSTAT data (csv file) into the SQL Server database? With BCP I always get Errors. Maybe you have an example for the Import.

Thank's for your help again.

GL said...

sorry, I use MySql so can't be helpful for MS SQL server

Patent search in India said...

We undertake complete prosecution of patent applications in various geographies such as United States, Europe, China, Japan, Australia, Canada, Republic of Korea, Singapore, Brazil, Africa etc. through our associates. Trademark search and registration | Patent search in India

Post a Comment