Difference between revisions of "PTO Assignment"
Jump to navigation
Jump to search
Line 56: | Line 56: | ||
==Table Variables== | ==Table Variables== | ||
− | |||
− |
Revision as of 12:14, 29 July 2016
Back to Patent Data Specifications.
Table Structure
Table "public.ptoassignment" Column | Type | Modifiers ------------------------+------------------------+----------- reel_no | integer | frame_no | integer | last_update_date | date | purge_indicator | character varying(2) | recorded_date | date | correspondent_name | character varying(500) | correspondent_address_1 | character varying(500) | correspondent_address_2 | character varying(500) | correspondent_address_3 | character varying(500) | correspondent_address_4 | character varying(500) | conveyance_text | character varying(500) |
Example of table entries:
reel_no | frame_no | last_update_date | purge_indicator | recorded_date | correspondent_name --------+----------+------------------+-----------------+---------------+-------------------------------------- 1280 | 340 | 1999-07-29 | N | 1994-12-30 | THOMAS J. ENGELLENNER 3625 | 888 | 2010-09-24 | N | 1979-03-05 | NORTHERN TELECOM LIMITED 3634 | 874 | 1999-08-17 | N | 1979-03-02 | MORRISON & FOERSTER LLP 3634 | 875 | 1999-08-17 | N | 1979-03-02 | THOMAS KAYDEN HORSTEMEYER ET AL. 3692 | 537 | 2002-04-06 | N | 1979-09-26 | EHD, INC. 3696 | 452 | 2010-09-24 | N | 1979-10-11 | PFIZER INC. 3729 | 735 | 1999-07-29 | N | 1980-01-28 | FLEHR, HOHBACH, TEST, ALBRITTON ETAL 3737 | 606 | 2008-09-24 | N | 1980-02-13 | SAMSON HELFGOTT 3741 | 900 | 2010-09-24 | N | 1990-03-24 | BROWDY & NEIMARK 3765 | 757 | 1999-07-29 | N | 1980-05-14 | WAQTSON COLE STEVENS DAVIS, P.L.L.C. 3788 | 668 | 2010-09-24 | N | 1980-08-15 | CHRISTIE, PARKER & HALE 3788 | 670 | 2010-09-24 | N | 1980-08-15 | ROBERT M. SPERRY 3788 | 673 | 2008-09-24 | N | 1980-08-05 | SPENCER & KAYE 3788 | 675 | 1999-07-29 | N | 1980-08-05 | HENRY W. KOSTER 3788 | 676 | 2010-09-24 | N | 1980-08-05 | DRESSLER, GOLDSMITH, SHORE
reel_no | frame_no | correspondent_address_1 | correspondent_address_2 | correspondent_address_3 | correspondent_address_4 | conveyance_text --------+----------+-------------------------------+---------------------------------+--------------------------------+-------------------------+--------------------------------------------------------------- 1280 | 340 | LAHIVE & COCKFIELD | 60 STATE STREET | SUITE 510 | BOSTON, MA 02109 | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). 3625 | 888 | PATENT DEPT 265 | P.O. BOX 3511 STATION C | OTTAWA ONTARIO CANADA K1Y 4H7 | | CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). 3634 | 874 | GARY E. CANN | 345 CALIFORNIA STREET | SAN FRANCISCO, CA 94104-2675 | | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). 3634 | 875 | DANIEL A. MCCLURE | 100 GALLERIA PARKWAY, STE. 1500 | ATLANTA, GA 30339 | | ASSIGNMENT OF ASSIGNOR'S INTEREST (SEE DOCUMENT FOR DETAILS). 3692 | 537 | 500 GOULD DRIVE | COOKEVILLE, TN 38501 | | | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). 3696 | 452 | PATENT DEPARTMENT, 20TH FLOOR | 235 EAST 42ND STREET | NEW YORK, NEW YORK 10017-5755 | | MERGER (SEE DOCUMENT FOR DETAILS). 3729 | 735 | FOUR EMBARCADERO CENTER | SUITE 3400 | SAN FRANCISCO, CA 94111-4187 | | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). 3737 | 606 | POB 5012, FDR STATION | NEW YORK, NY 10022 | | | ASSIGNMENT OF ASSIGNORS INTEREST. 3741 | 900 | 419 7TH ST., N.W. | WASHINGTON, DC 20004 | | | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). 3765 | 757 | SUITE 1000 / CWV 17168 | 1400 K STREET , N.W. | WASHINGTON, D.C. 20005 | | ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). 3788 | 668 | 201 SOUTH LAKE AVE. | PASADENA, CA 91101 | | | ASSIGNMENT OF ASSIGNORS INTEREST. 3788 | 670 | ROCKETDYNE DIV. | 6633 CANOGA AVE. | CANOGA PARK, CA 91304 | | ASSIGNMENT OF ASSIGNORS INTEREST. 3788 | 673 | 1111 19TH, STREET N.W. | WASHINGTON, D.C. 20036 | | | ASSIGNMENT OF ASSIGNORS INTEREST. 3788 | 675 | C/O CURTIS, MORRIS & SAFFORD | 530 FIFTH AVE. | NEW YORK, N. Y. 10036 | | ASSIGNMENT OF ASSIGNORS INTEREST. 3788 | 676 | SUTKER & MILNAMOW, LTD. | 1800 PRUDENTIAL PLAZA | CHICAGO, IL 60601 | | ASSIGNMENT OF ASSIGNORS INTEREST.