Difference between revisions of "Assignee Table"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
Table "public.assignee" | Table "public.assignee" | ||
Column | Type | Modifiers | Column | Type | Modifiers | ||
| − | + | ----------+------------------------+----------- | |
reel | integer | | reel | integer | | ||
frame | integer | | frame | integer | | ||
| Line 21: | Line 21: | ||
reel | frame | recdate | assignee | country | postcode | reel | frame | recdate | assignee | country | postcode | ||
| − | + | ------+-------+------------+-------------------------------------------------------------------------------------------+--------------+---------- | |
15283 | 287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED | INDIA | 110019 | 15283 | 287 | 1970-01-04 | RANBAXY LABORATORIES LIMITED | INDIA | 110019 | ||
5744 | 401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED | ENGLAND | SW1Y | 5744 | 401 | 1975-09-08 | ROLLS-ROYCE (1971) LIMITED | ENGLAND | SW1Y | ||
Revision as of 12:28, 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
