SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Oakland, CA') ORDER BY date ASC, patent, type |
Total of 6 patents found where: Residence is 'Oakland, CA';
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 | 816,981 | April 3, 1906 | Cross Arm for Electric or Signal Wires Pin mounted under the crossarm and curving upward to hold the insulator |
ILIOHAN, Anthony H. |
Pin | |
1916 | ||||||
U | 1,173,994 | February 29, 1916 | High Tension Insulator Suspension with ribbed tubes and interlocking links |
BARFOED, Svend |
Suspension | 2/5 to Otis Gibson |
1919 | ||||||
U | 1,306,670 | June 10, 1919 | Insulating Support Suspension cap and pin to improve strength of connection |
LANYON, Samuel H. |
Suspension | |
U | 1,324,559 | December 9, 1919 | Insulating Support Suspension cap and pin to improve strength of connection |
LANYON, Samuel H. |
Suspension | |
1926 | ||||||
U | 1,592,042 | July 13, 1926 | Insulator Knob |
NEWMAN, Maurice H. GILARDIN, William A. |
Knob | |
1929 | ||||||
U | 1,738,188 | December 3, 1929 | Insulating Support Suspension cap, pin and connector |
LANYON, Samuel Herbert |
Suspension | Lapp Insulator Co. |
Total of 0.00 seconds