Assignee Table

From edegan.com
Revision as of 17:15, 2 September 2016 by Carlin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Return to USPTOAssigneesData.

Table Purpose

The Assignee Table gives the assignee and location of each assignee involved in an assignment. The table gives a non-standardized inventory of companies involved in assignments as well as an indication of a company's patent portfolio over time. Additionally, the Assignee Table was used to create the Assignment and Assignee Count Tables.

Table Structure

            Table "public.assignee"
 Column   |          Type          | Modifiers 
----------+------------------------+-----------
reel      | integer                | 
frame     | integer                | 
recdate   | date                   | 
assignee  | character varying(500) | 
addrline1 | character varying(500) | 
addrline2 | character varying(500) | 
city      | character varying(500) | 
state     | character varying(500) | 
country   | character varying(500) | 
postcode  | character varying(500) | 

Example of table entries:

reel  | frame |  recdate   |                                         assignee                                          |   country    | postcode 
------+-------+------------+-------------------------------------------------------------------------------------------+--------------+----------
15283 |   287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED                                                              | INDIA        | 110019
 5744 |   401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED                                                                | ENGLAND      | SW1Y
 3634 |   874 | 1979-03-02 | PARADYNE CORPORATION                                                                      |              | 33540
 3634 |   875 | 1979-03-02 | PARADYNE CORPORATION                                                                      |              | 33540
 3625 |   888 | 1979-03-05 | NORTHERN TELECOM LIMITED                                                                  | NOT PROVIDED | 
 8613 |   265 | 1979-05-27 | STAHL INTERNATIONAL B.V.                                                                  | NETHERLANDS  | 
 3835 |   710 | 1979-09-07 | KIORITZ CORPORATION, 5-1, SHIMORENJAKU-7-CHOME, MITAKA-SHI, TOKYO, JAPAN A CORP. OF JAPAN |              | 
 3692 |   537 | 1979-09-26 | EHD, INC.                                                                                 |              | 38501
 3696 |   452 | 1979-10-11 | HOWMEDICA, INC.                                                                           | NOT PROVIDED | 
 3818 |   140 | 1980-01-02 | E. EDELMANN & CO.                                                                         |              | 60076
reel  | frame |  recdate   |                                         assignee                                          |        addrline1        |            addrline2            |       city       |   state   
------+-------+------------+-------------------------------------------------------------------------------------------+-------------------------+---------------------------------+------------------+-----------
15283 |   287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED                                                              | 19, NEHRU PLACE         |                                 | NEW DELHI        | 
 5744 |   401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED                                                                |                         | NORFOLK HOUSE, ST. JAMES SQUARE | LONDON           | 
 3634 |   874 | 1979-03-02 | PARADYNE CORPORATION                                                                      |                         | 8550 ULMERTON ROAD              | LARGO            | FLORIDA
 3634 |   875 | 1979-03-02 | PARADYNE CORPORATION                                                                      |                         | 8550 ULMERTON ROAD              | LARGO            | FLORIDA
 3625 |   888 | 1979-03-05 | NORTHERN TELECOM LIMITED                                                                  |                         |                                 |                  | 
 8613 |   265 | 1979-05-27 | STAHL INTERNATIONAL B.V.                                                                  |                         | POSTBUS 110, SLUISWEG 10        | 5140 AC WAALWIJK | 
 3835 |   710 | 1979-09-07 | KIORITZ CORPORATION, 5-1, SHIMORENJAKU-7-CHOME, MITAKA-SHI, TOKYO, JAPAN A CORP. OF JAPAN |                         |                                 |                  | 
 3692 |   537 | 1979-09-26 | EHD, INC.                                                                                 | A TENNESSEE CORPORATION | 500 GOULD DRIVE                 | COOKEVILLE       | TENNESSEE
 3696 |   452 | 1979-10-11 | HOWMEDICA, INC.                                                                           |                         |                                 |                  | 
 3818 |   140 | 1980-01-02 | E. EDELMANN & CO.                                                                         | 4711 GOLF RD.           |                                 | SKOKIE           | ILLINOIS

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 assignee receives ownership or interest in the patents involved in the transaction from the assignor. The recdate is the date the transaction was recorded. The rest of the entries in the table give the location of the assignee. The key for the table is composite and consists of a unique combination of reel number, frame number, and recdate.

Current Problems