Difference between revisions of "Patent ID Table"
| Line 2: | Line 2: | ||
==Table Purpose== | ==Table Purpose== | ||
| − | + | Allows us to find th epatents of interest for us (utility). | |
==Table Structure== | ==Table Structure== | ||
Table "public.patentid" | Table "public.patentid" | ||
| Line 32: | Line 32: | ||
==Table Variables== | ==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. | + | 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. The recdate gives the date the assignment was recorded by the USPTO. Patentid is the patent number, either foreign or American, or the application number of the patent involved in the transaction. The country is the country of the original inventor or patent applicant. Kind identifies the type of patent, when it was granted, and whether the patentid corresponds to a patent or a patent application. The filing date is the date the patent application was filed. Inventiontitle is the title of the patent. |
==Current Problems== | ==Current Problems== | ||
{{#section:Patent_Data_Issues|patentid}} | {{#section:Patent_Data_Issues|patentid}} | ||
Revision as of 16:18, 28 July 2016
Return to USPTOAssigneesData.
Table Purpose
Allows us to find th epatents of interest for us (utility).
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. The recdate gives the date the assignment was recorded by the USPTO. Patentid is the patent number, either foreign or American, or the application number of the patent involved in the transaction. The country is the country of the original inventor or patent applicant. Kind identifies the type of patent, when it was granted, and whether the patentid corresponds to a patent or a patent application. The filing date is the date the patent application was filed. Inventiontitle is the title of the patent.
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
