PTO Assignee Table

From edegan.com
Revision as of 17:46, 2 September 2016 by Carlin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Back to PTO Tables.

Table Structure

          Table "public.ptoassignee"
 Column   |          Type          | Modifiers 
----------+------------------------+-----------
reel_no   | integer                | 
frame_no  | integer                | 
name      | 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(80)  | 

Example of table entries:

reelno | 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

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.