KR or WO as countries publication

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

CarlosPB50
Posts: 1
Joined: Tue May 17, 2022 9:31 pm

KR or WO as countries publication

Post by CarlosPB50 » Thu May 19, 2022 2:27 pm

I'm trying to extract the patents that have Artificial intelligence in the title or abs filed in Korea or WO, besides that use distintct, so i dont double the inventions, but i dont know how to include WO and where put distinct. Can you guys help me?

Code: Select all

SELECT * 
  FROM TLS201_APPLN AS APP 
  INNER JOIN TLS202_APPLN_TITLE AS TIT 
  ON (APP.APPLN_ID = TIT.APPLN_ID) 
  INNER JOIN TLS203_APPLN_ABSTR ABS 
  ON (APP.APPLN_ID = ABS.APPLN_ID) 
  WHERE (    TIT.APPLN_TITLE LIKE '%인공 지능%' OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
     AND APP.GRANTED = 'Y' 
	 AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017' 
	 AND APP.APPLN_AUTH = 'KR'


gianluca.tarasconi
Posts: 63
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

Re: KR or WO as countries publication

Post by gianluca.tarasconi » Fri Jun 24, 2022 2:14 pm

Dear Carlos
if you want to select all patents coming via PCT route from any country just add in your selection criteria
APPLN_AUTH = 'WO'

Code: Select all

SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%' 
OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' 
OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' 
OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND ( APP.APPLN_AUTH = 'KR' or APP.APPLN_AUTH = 'WO')
if instead you need the pct applications filed via the Korean patent office, just add RECEIVING_OFFICE = "KR"

Code: Select all

SELECT *
FROM TLS201_APPLN AS APP
INNER JOIN TLS202_APPLN_TITLE AS TIT
ON (APP.APPLN_ID = TIT.APPLN_ID)
INNER JOIN TLS203_APPLN_ABSTR ABS
ON (APP.APPLN_ID = ABS.APPLN_ID)
WHERE ( TIT.APPLN_TITLE LIKE '%인공 지능%' 
OR TIT.APPLN_TITLE LIKE '%Artificial intelligence%' 
OR ABS.APPLN_ABSTRACT LIKE '%인공 지능' 
OR ABS.APPLN_ABSTRACT LIKE '%Artificial intelligence%')
AND APP.GRANTED = 'Y'
AND APP.APPLN_FILING_YEAR BETWEEN '2003' AND '2017'
AND ( APP.APPLN_AUTH = 'KR' or RECEIVING_OFFICE = "KR")


Post Reply