Difference between revisions of "Assignee Count Table"
Jump to navigation
Jump to search
| Line 30: | Line 30: | ||
==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. The recdate is the date the assignment was recorded. Patent gives the patent number of the patent involved in a specific transation. Numassignees is the number of assignees involved in the transaction. | + | 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 transation. Numassignees is the number of assignees involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate. |
| + | |||
==Current Problems== | ==Current Problems== | ||
Revision as of 13:26, 27 July 2016
Return to USPTOAssigneesData.
Table Purpose
In a transaction, multiple assignees and assignors may be involved.
Table Structure
Table "public.assigneecount" Column | Type | Modifiers ------------+---------+----------- reel | integer | frame | integer | recdate | date | patent | integer | numassignee | bigint |
Example of table entries:
reel | frame | recdate | patent | numassignee ------+-------+------------+---------+------------- 4974 | 662 | 1988-10-18 | 9999999 | 1 4974 | 662 | 1988-10-18 | 9999999 | 1 18015 | 523 | 2006-06-30 | 9933719 | 1 10425 | 882 | 1999-12-06 | 9925487 | 1 11177 | 159 | 2000-09-14 | 9907141 | 1 11177 | 159 | 2000-09-14 | 9907141 | 1 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 | 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 transation. Numassignees is the number of assignees involved in the transaction. The table has a composite key consisting of reel number, frame number, and recdate.
