Difference between revisions of "Assignee Table"
| (4 intermediate revisions by one other user not shown) | |||
| Line 2: | Line 2: | ||
==Table Purpose== | ==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 Structure== | ||
| Line 51: | Line 54: | ||
==Current Problems== | ==Current Problems== | ||
| + | |||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Legacy| ]] | ||
Latest revision as of 16:15, 2 September 2016
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.
