Difference between revisions of "Party Count Table"
Jump to navigation
Jump to search
| (2 intermediate revisions by one other user not shown) | |||
| Line 2: | Line 2: | ||
==Table Purpose== | ==Table Purpose== | ||
| − | + | <section begin="partycount" /> | |
| + | The Party Count Table records the number of parties involved in a transaction and specifies the patents involved in the given assignment. The table combines the Assignor and Assignee Count Tables in a more usable format. Additionally, the table illustrates a history of ownership of a patent, which may be considered as an indicator for patent litigation risk in the [[Little Guy Academic Paper]]. | ||
| + | <section end="partycount" /> | ||
==Table Structure== | ==Table Structure== | ||
| − | + | Table "public.partycount" | |
Column | Type | Modifiers | Column | Type | Modifiers | ||
------------+---------+----------- | ------------+---------+----------- | ||
reel | integer | | reel | integer | | ||
frame | integer | | frame | integer | | ||
| + | recdate | date | | ||
patent | integer | | patent | integer | | ||
| − | |||
numassignor | bigint | | numassignor | bigint | | ||
| − | numassignee | bigint | | + | numassignee | bigint | |
Example of table entries: | Example of table entries: | ||
| − | reel | frame | | + | reel | frame | recdate | patent | numassignor | numassignee |
| − | ------+-------+--------- | + | ------+-------+------------+---------+-------------+------------- |
| − | 39094 | 222 | + | 39094 | 222 | 2016-07-07 | 7494254 | 1 | 2 |
| − | 39094 | 578 | + | 39094 | 578 | 2016-07-07 | 8884582 | 1 | 1 |
| − | 39090 | 698 | + | 39090 | 698 | 2016-07-07 | 9350624 | 1 | 1 |
| − | 39094 | 73 | + | 39094 | 73 | 2016-07-07 | 7326866 | 2 | 1 |
| − | 39094 | 423 | + | 39094 | 423 | 2016-07-07 | 8809526 | 1 | 1 |
| − | 39094 | 578 | + | 39094 | 578 | 2016-07-07 | 8795876 | 1 | 1 |
| − | 39090 | 591 | + | 39090 | 591 | 2016-07-07 | 6830898 | 1 | 1 |
| − | 39090 | 591 | + | 39090 | 591 | 2016-07-07 | 7858335 | 1 | 1 |
| − | 39096 | 156 | + | 39096 | 156 | 2016-07-07 | 8406275 | 1 | 1 |
| − | 39094 | 578 | + | 39094 | 578 | 2016-07-07 | 9108497 | 1 | 1 |
==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 by the USPTO. Patent identifies the patent involved in the transaction. Numassignor and numassignee identify how many assignors and assignees were involved in the assignment. The table key is composite consisting of reel, frame, and recdate. | ||
==Current Problems== | ==Current Problems== | ||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Data Tables| ]] | ||
Latest revision as of 16:49, 2 September 2016
Return to USPTOAssigneesData.
Table Purpose
The Party Count Table records the number of parties involved in a transaction and specifies the patents involved in the given assignment. The table combines the Assignor and Assignee Count Tables in a more usable format. Additionally, the table illustrates a history of ownership of a patent, which may be considered as an indicator for patent litigation risk in the Little Guy Academic Paper.
Table Structure
Table "public.partycount" Column | Type | Modifiers ------------+---------+----------- reel | integer | frame | integer | recdate | date | patent | integer | numassignor | bigint | numassignee | bigint |
Example of table entries:
reel | frame | recdate | patent | numassignor | numassignee ------+-------+------------+---------+-------------+------------- 39094 | 222 | 2016-07-07 | 7494254 | 1 | 2 39094 | 578 | 2016-07-07 | 8884582 | 1 | 1 39090 | 698 | 2016-07-07 | 9350624 | 1 | 1 39094 | 73 | 2016-07-07 | 7326866 | 2 | 1 39094 | 423 | 2016-07-07 | 8809526 | 1 | 1 39094 | 578 | 2016-07-07 | 8795876 | 1 | 1 39090 | 591 | 2016-07-07 | 6830898 | 1 | 1 39090 | 591 | 2016-07-07 | 7858335 | 1 | 1 39096 | 156 | 2016-07-07 | 8406275 | 1 | 1 39094 | 578 | 2016-07-07 | 9108497 | 1 | 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 by the USPTO. Patent identifies the patent involved in the transaction. Numassignor and numassignee identify how many assignors and assignees were involved in the assignment. The table key is composite consisting of reel, frame, and recdate.
