Difference between revisions of "Patent ID Table"
Jump to navigation
Jump to search
| Line 35: | Line 35: | ||
==Current Problems== | ==Current Problems== | ||
| − | {{#section:Patent_Data_Issues|patentid}} | + | {{#section:Patent_Data_Issues| patentid}} |
Revision as of 10:58, 28 July 2016
Return to USPTOAssigneesData.
Table Purpose
Table Structure
Table "public.patentid"
Column | Type | Modifiers
---------------+------------------------+-----------
reel | integer |
frame | integer |
recdate | date |
patentid | character varying(500) |
country | character varying(500) |
kind | character varying(500) |
filingdate | date |
inventiontitle | character varying(500) |
Example of table entries:
reel | frame | recdate | patentid | country | kind | filingdate | inventiontitle ------+-------+------------+----------+---------+------+------------+---------------------------------------------------------------------------- 14692 | 879 | 2003-11-17 | WO07210 | US | B1 | | 15377 | 840 | 2004-11-18 | US27977 | US | B1 | | 16172 | 708 | 2005-01-24 | US15883 | US | B1 | | 19399 | 976 | 2007-05-25 | TL63716 | US | B1 | | 3996 | 522 | 1982-07-15 | T988010 | US | B1 | 1979-11-06 | PROCESS FOR PREPARING C1-C5 ALKYL 5-(SUBSTITUTED-PHENOXY)-2 -NITROBENZOATE 5270 | 208 | 1990-04-16 | T986005 | US | B1 | 1979-09-04 | PHOTOGRAPHIC FILMS 4669 | 905 | 1986-06-12 | T982002 | US | B1 | | 7322 | 128 | 1995-01-25 | T980003 | US | B1 | 1979-03-06 | POLYOLEFIN COMPOSITIONS CONTAINING CALCIUM CARBONATE 4759 | 429 | 1987-08-11 | T941023 | US | B1 | | 5240 | 440 | 1989-06-26 | T941017 | US | B1 | |
Table Variables
Reel and frame give the location on the microfilm files where the particular transaction is recorded. The reel number and frame number are unique to a transaction between the assignee and assignor.
Current Problems
The patentid table has many entries that do not consist of only integers.
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[A-Z]'; count ------- 775982
SELECT COUNT(*) FROM patentid WHERE patentid ~ '[^A-Z]'; count -------- 27294418
