Assignor Count Table

From edegan.com
Jump to navigation Jump to search

Return to USPTOAssigneesData.

Table Purpose

Since multiple assignees and assignors may be involved in a patent transaction, the Assignor Count Table keeps track of the number of assignors involved in a given assignment. The table was made using the Assignor Table and counting the number of rows per each distinct group of reel number, frame number, and recdate. The table was used to create the Party Count Table.

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.

Current Problems