German inventors citing U.S. patents

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

Posts: 1
Joined: Tue Aug 27, 2019 10:26 am

German inventors citing U.S. patents

Post by TheNew » Tue Aug 27, 2019 10:33 am


thank you for this forum, and the possibily to get help.
using the patstat 2018b version, I want to find out about certain inventors from Germany who cite U.S. patents.
Is it sufficient to join the data using the tls211_pat_publn.pat_publn_id ?
My join would be:

Code: Select all

INNER JOIN patstat2018b.dbo.tls212_citation ON PatAppl_GermanInventors.publn_id = tls212_citation.cited_pat_publn_id
	INNER JOIN patstat2018b.dbo.tls211_pat_publn ON tls212_citation.pat_publn_id = tls211_pat_publn.pat_publn_id
So linking my German Inventors (GermanInventors) using the publn_id with cited_pat_publn_id and then using tls212_citation.pat_publn_id = tls211_pat_publn.pat_publn_id.
Or am I missing something?

Thank you very much.

Post Reply