appln_filing_date or earlist_appln_date
Posted: Wed May 06, 2020 3:37 pm
Hi
I am trying to measure an applicant's innovative ability by using the number of successful patents in a specific year.
it is 1)based on the family level(DOCDB_family_id)
2) identify the first time an invention is patented and call it the “original patent”.
(WHERE
granted = 1 /* there exists a publication of the grant */
AND publn_first_grant = 1 /* the first publication of grant of a given application */
AND YEAR(publn_date) NE 9999
AND publn_date>=appln_filing_date /*the publication date should later than applicantion filing date*/
GROUP BY docdb_family_id
HAVING publn_date = MIN(publn_date) /* the earliest date of publn_first_grant in each patent)
what i am confuse is how to date the patent
Should I use the appln_filing_date or the earlist_appln_date of the original patent? I think the earlist_appln_date is closer to the actual date of innovation. Could you please give me some suggestion about this?
Thanks in advance.
I am trying to measure an applicant's innovative ability by using the number of successful patents in a specific year.
it is 1)based on the family level(DOCDB_family_id)
2) identify the first time an invention is patented and call it the “original patent”.
(WHERE
granted = 1 /* there exists a publication of the grant */
AND publn_first_grant = 1 /* the first publication of grant of a given application */
AND YEAR(publn_date) NE 9999
AND publn_date>=appln_filing_date /*the publication date should later than applicantion filing date*/
GROUP BY docdb_family_id
HAVING publn_date = MIN(publn_date) /* the earliest date of publn_first_grant in each patent)
what i am confuse is how to date the patent
Should I use the appln_filing_date or the earlist_appln_date of the original patent? I think the earlist_appln_date is closer to the actual date of innovation. Could you please give me some suggestion about this?
Thanks in advance.