Searching by US patent number

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

Rachie
Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

Searching by US patent number

Post by Rachie » Wed Oct 25, 2017 6:36 am

I'm trying to figure out how to determine a docdb_family_id for patents, given a US patent ID or application ID. What fields correlate to patent IDs or application IDs? I can't quite figure it out from the documentation.

As an example, how would I locate this patent in the database?
https://patents.google.com/patent/US3229886A


Geert Boedt
Posts: 178
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: Searching by US patent number

Post by Geert Boedt » Wed Oct 25, 2017 8:00 am

Something like this:

Code: Select all

SELECT tls201_appln.appln_auth, tls201_appln.appln_nr,tls201_appln.appln_kind,tls201_appln.appln_filing_date, tls201_appln.docdb_family_id, tls211_pat_publn.*
FROM tls211_pat_publn 
JOIN tls201_appln ON tls211_pat_publn.appln_id = tls201_appln.appln_id
WHERE publn_auth = 'US' AND publn_nr = '3229886'
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


Rachie
Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

Re: Searching by US patent number

Post by Rachie » Wed Oct 25, 2017 7:34 pm

Just what I needed, thanks!


Post Reply