SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Seattle, WA') ORDER BY date ASC, patent, type |
Total of 8 patents found where: Residence is 'Seattle, WA';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
T / S | Patent | Date | Description | Patentee | Category | Assigned To |
1906 | ||||||
U | 810,618 | January 23, 1906 | Insulator Clamp Clamp for crown of multipart insulator |
CLARK, Walter G. |
Clamp | |
1907 | ||||||
U | 843,258 | February 5, 1907 | Insulator Clamp Clamp type metal cable holder |
CLARK, Walter G. |
Clamp Type | The Clark Electric & Mfg. Co. |
U | 843,259 | February 5, 1907 | Insulator Clamp type metal cable holder |
CLARK, Walter G. |
Clamp Type | The Clark Electric & Mfg. Co. |
U | 851,222 | April 23, 1907 | Insulator Clamp Clamping device to hold conductor cable in crown groove (used on M-3740) |
CLARK, Walter G. |
Insulator | The Clark Electric & Mfg. Co. |
U | 874,445 | December 24, 1907 | Insulator Cleat - self-tying |
SHEARS, Albert L. |
Cleat | |
1910 | ||||||
U | 964,737 | July 19, 1910 | Insulated Distributor for Electric Service Wires Wireholder for multiple drop wires suspended under the crossarm |
ASHLEY, John B. |
Wireholder | |
U | 973,409 | October 18, 1910 | Insulated Hanger Tree hanger comprised of cylinder with center groove |
CRABBE, Edward |
Tree | |
1929 | ||||||
U | 1,712,860 | May 14, 1929 | Transposition Pin Pin (metal) through crossarm for transposition |
WEIMAR, Robert |
Pin |
Total of 0.00 seconds