Hello Eduardo,
the methodology in "An introduction to the Patstat database with example queries - Query8"
is based on calculating the difference between the earliest publication of an application and the earliest publication date of its forward citations.
In the publication we used a sample based on wind energy applications filed in 2005 - reflected by the conditions in Query 1. But you can of course use whatever criteria you want, such as the PSN_ID - to count all the forward citations from applications assigned to a "PATSTAT STANDARDISED NAME"_id.
In order to stay in line with the publication -I used the Wind energy patents- and here is the updated query -according to the publication- which will run on PATSTAT Online.
The "our sample t1"-data is defined by the following sub-query which generates 2191 patent applications in the current PATSTAT2020a release.
Code: Select all
SELECT
DISTINCT table1.appln_id, table1.appln_auth, table1.appln_nr, table1.appln_kind, table1.appln_filing_date
FROM
tls201_appln table1
INNER JOIN
tls209_appln_ipc table2 ON table1.appln_id = table2.appln_id
WHERE
year(table1.appln_filing_date) = 2005
AND (table1.appln_kind = 'A' OR table1.appln_kind = 'W')
AND table2.ipc_class_symbol LIKE 'F03D%'
Integrating the above query into Query 8 would then look like this (PATSTAT Global users would probably create a intermediate table to store the results):
Code: Select all
SELECT
t1.appln_id, COUNT(distinct t3.pat_publn_id) AS cites_3y
FROM
--our_sample t1
--XXXX
(SELECT
DISTINCT table1.appln_id, table1.appln_auth, table1.appln_nr, table1.appln_kind, table1.appln_filing_date
FROM
tls201_appln table1
INNER JOIN
tls209_appln_ipc table2 ON table1.appln_id = table2.appln_id
WHERE
year(table1.appln_filing_date) = 2005
AND (table1.appln_kind = 'A' OR table1.appln_kind = 'W')
AND table2.ipc_class_symbol LIKE 'F03D%') as t1
--XXXX
INNER JOIN
(SELECT
appln_id, MIN(publn_date) AS earliest_date
FROM
tls211_pat_publn
GROUP BY appln_id) t2 ON t1.appln_id = t2.appln_id
INNER JOIN
tls211_pat_publn t2b ON t2b.appln_id = t2.appln_id
INNER JOIN
tls212_citation t3 ON t2b.pat_publn_id = t3.cited_pat_publn_id
INNER JOIN
tls211_pat_publn t4 ON t3.pat_publn_id = t4.pat_publn_id
WHERE
t2b.publn_auth = 'DE'
AND t4.publn_auth = 'EP'
AND YEAR(t2.earliest_date)!= 9999
AND YEAR(t4.publn_date)!= 9999
AND t4.publn_date <= DATEADD( year , 3 ,t2.earliest_date )
GROUP BY t1.appln_id
ORDER BY COUNT(distinct t3.pat_publn_id) DESC, t1.appln_id ASC
The query generates a simple list giving the application ID from the cited application, and the number of forward citations over a time frame of 3 years after the application was published. The query might serve as a "fairly naive" patent value indicator, and researchers and economists will normally look much deeper at the underlying forces and ask questions that serve impact analysis: "who cites who ?" "are patents filed by universities cited more in comparison to patents filed by companies", "can we identify inbound/outbound technology flows by analysing the classification codes assigned to cited and citing applications ?" "can we identify technology flows by looking at the countries of applicants/inventors", "can we identify emerging technologies by unusual cited document combinations" etc... There is plenty of research done in this area. But it is all based on a good and correct understanding of the data in the tables tls212 (tls214, tls215).
Here is a variation that gives the application and publication instead of a number and a count:
Code: Select all
SELECT t1.appln_id,
t1.appln_auth+t1.appln_nr+t1.appln_kind cited, t2.earliest_date
, t4.publn_auth+t4.publn_nr+t4.publn_kind citing,t4.publn_date
FROM
--our_sample t1
--XXXX
(SELECT
DISTINCT table1.appln_id, table1.appln_auth, table1.appln_nr, table1.appln_kind, table1.appln_filing_date
FROM
tls201_appln table1
INNER JOIN
tls209_appln_ipc table2 ON table1.appln_id = table2.appln_id
WHERE
year(table1.appln_filing_date) = 2005
AND (table1.appln_kind = 'A' OR table1.appln_kind = 'W')
AND table2.ipc_class_symbol LIKE 'F03D%') as t1
--XXXX
INNER JOIN
(SELECT
appln_id, MIN(publn_date) AS earliest_date
FROM
tls211_pat_publn
GROUP BY appln_id) t2 ON t1.appln_id = t2.appln_id
INNER JOIN
tls211_pat_publn t2b ON t2b.appln_id = t2.appln_id
INNER JOIN
tls212_citation t3 ON t2b.pat_publn_id = t3.cited_pat_publn_id
INNER JOIN
tls211_pat_publn t4 ON t3.pat_publn_id = t4.pat_publn_id
WHERE
t2b.publn_auth = 'DE'
AND t4.publn_auth = 'EP'
AND YEAR(t2.earliest_date)!= 9999
AND YEAR(t4.publn_date)!= 9999
AND t4.publn_date <= DATEADD( year , 3 ,t2.earliest_date )
order by t1.appln_filing_date, t1.appln_id
;