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
Searching by US patent number
-
- Posts: 176
- Joined: Tue Oct 19, 2004 10:36 am
- Location: Vienna
Re: Searching by US patent number
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
Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna
Re: Searching by US patent number
Just what I needed, thanks!