Difference between revisions of "Assignee Table"
Jump to navigation
Jump to search
| Line 4: | Line 4: | ||
==Table Structure== | ==Table Structure== | ||
| − | + | Table "public.assignee" | |
Column | Type | Modifiers | Column | Type | Modifiers | ||
----------+------------------------+----------- | ----------+------------------------+----------- | ||
| Line 47: | Line 47: | ||
==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 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== | ==Current Problems== | ||
Revision as of 14:17, 27 July 2016
Return to USPTOAssigneesData.
Table Purpose
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.
