Difference between revisions of "PTO Assignee Table"
Jump to navigation
Jump to search
(Created page with "Back to Patent Data Specifications. Table "public.ptoassignee" Column | Type | Modifiers ----------+------------------------+----------...") |
|||
| Line 1: | Line 1: | ||
Back to [[Patent Data Specifications]]. | Back to [[Patent Data Specifications]]. | ||
| + | ==Table Structure== | ||
Table "public.ptoassignee" | Table "public.ptoassignee" | ||
Column | Type | Modifiers | Column | Type | Modifiers | ||
| Line 14: | Line 15: | ||
postcode | character varying(80) | | 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. | ||
| + | |||
| + | ==Table Purpose== | ||
| + | ==Current Problems== | ||
Revision as of 13:22, 22 July 2016
Back to Patent Data Specifications.
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.
