619
edits
Changes
Jump to navigation
Jump to search
no edit summary
==Table Purpose==
<section begin="assignee2" />
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.
<section end="assignee2" />
==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==
[[Category: Internal]]
[[Internal Classification: Legacy| ]]
