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
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:
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.
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
thnak you very much for your quick answer
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.
sorry, I use MySql so can't be helpful for MS SQL server
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