Page 1 of 1

Searching by US patent number

Posted: Wed Oct 25, 2017 6:36 am
by Rachie
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

Re: Searching by US patent number

Posted: Wed Oct 25, 2017 8:00 am
by Geert Boedt
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'

Re: Searching by US patent number

Posted: Wed Oct 25, 2017 7:34 pm
by Rachie
Just what I needed, thanks!