Back to [[Patent Data Specifications]].
==Table Structure==
Table "public.ptoassignee"
Column | Type | Modifiers
postcode | character varying(80) |
Example of table entries: reel_no reelno | frame_no frameno | name | addrline1 | addrline2 | city | state | country | postcode --------+----------+-------------------------------+--------------------------------------+--------------------------------------------------------+--------------------+------------+-------------+---------- 11446 | 662 | HEWLETT-PACKARD COMPANY | INTELLECTUAL PROPERTY ADMINISTRATION | P.O. BOX 272400 | FORT COLLINS | COLORADO | | 80527 11446 | 665 | HEWLETT-PACKARD COMPANY | P.O. BOX 272400 | INTELLECTUAL PROPERTY ADMINISTRATION | FORT COLLINS | COLORADO | | 80527 11446 | 667 | HEWLETT-PACKARD COMPANY | INTELLECTUAL PROPERTY ADMINISTRATION | P.O. BOX 272400 | FORT COLLINS | COLORADO | | 80527 11446 | 672 | AGFA-GEVAERT, N.V. | | SEPTESTRAAT 27 | MORTSEL | | BELGIUM | B-264 11446 | 674 | EASTMAN KODAK COMPANY | | | ROCHESTER | NEW YORK | | 14650 11446 | 677 | HEWLETT-PACKARD COMPANY | | P.O. BOX 272400, INTELLECTUAL PROPERTY ADMINISTRATION | FORT COLLINS | COLORADO | | 80527 11446 | 681 | PROCTER & GAMBLE COMPANY, THE | CHIEF PATENT COUNSEL | 6090 CENTER HILL ROAD | CINCINNATI | OHIO | | 45224 11446 | 688 | HOFFMANN-LA ROCHE INC. | | 340 KINGSLAND STREET | NUTLEY | NEW JERSEY | | 07110 11446 | 691 | PROCTER & GAMBLE COMPANY, THE | ATTN: GENERAL COUNSEL | WINTON HILL TECHNICAL CENTER - 6090 CENTER HILL AVENUE | CINCINNATI | OHIO | | 45224 11446 | 695 | BP CHEMICALS LIMITED | | BRITANNIC HOUSE, 1 FINSBURY CIRCUS | LONDON | | ENGLAND | EC4M 11446 | 697 | DURECT CORPORATION | | 10240 BUBB ROAD | CUPERTINO | CALIFORNIA | | 95014 11446 | 700 | KAROLINSKA INNOVATIONS AB | | | S-171 77 STOCKHOLM | | SWEDEN | ==Table Variables== The reelno and frameno correspond to the location of an assignment on microfilm kept by the USPTO. Name is the firm or individual that receives the patents in the assignment transaction. The other columns give the location of the entity. 11446 | 703 | AUTOLIV DEVELOPMENT AB | | PATENT DEPARTMENT SWEDEN | S-447 83 VARGARDA | | SWEDEN | 11446 | 705 | NEC CORPORATION | MINATO-KU | 7-1, SHIBA 5-CHOME | TOKYO | | JAPAN | ==Table Purpose== 11446 | 710 | F. HOFFMANN-LA ROCHE AG | | 124 GRENZACHERSTRASSE, | BASEL, CH-4070 | | SWITZERLAND |==Current Problems==