Assignor Count Table
Revision as of 11:07, 28 July 2016 by MarcelaInteriano (talk | contribs)
Return to USPTOAssigneesData.
Table Purpose
Table Structure
Table "public.assignorcount" Column | Type | Modifiers ------------+---------+----------- reel | integer | frame | integer | recdate | date | patent | integer | numassignor | bigint |
Example of table entries:
reel | frame | recdate | patent | numassignor ------+-------+------------+---------+------------- 4974 | 662 | 1988-10-18 | 9999999 | 2 18015 | 523 | 2006-06-30 | 9933719 | 1 10425 | 882 | 1999-12-06 | 9925487 | 1 11177 | 159 | 2000-09-14 | 9907141 | 2 13036 | 521 | 2002-06-25 | 9903592 | 1 13011 | 193 | 2002-06-19 | 9827659 | 1 13036 | 521 | 2002-06-25 | 9824727 | 1 12653 | 532 | 2002-02-25 | 9808340 | 6 11566 | 681 | 2001-02-13 | 9802673 | 1 22928 | 276 | 2009-07-06 | 9727320 | 1
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 is the date the assignment was recorded. Patent gives the patent number of the patent involved in a specific transaction. Numassignors is the number of assignors involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate.
