Difference between revisions of "Assignee Table"
Jump to navigation
Jump to search
(Created page with "Return to USPTOAssigneesData. ==Table Purpose== ==Table Structure== ==Table Variables== ==Current Problems==") |
|||
| Line 4: | Line 4: | ||
==Table Structure== | ==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== | ==Table Variables== | ||
==Current Problems== | ==Current Problems== | ||
Revision as of 10:40, 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
