SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (last_name = 'OLIVIER') AND (first_name = 'Leon J.') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Last Name is 'OLIVIER'; First Name is 'Leon J.';
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 |
1942 | ||||||
U | 2,302,883 | November 24, 1942 | Method of Stringing and Sagging Wires and Apparatus for Use Therein Bracket for wireholders or rack spools that allow the spool insulator to swivel out away from the bracket for easily working on the line wire and insulator (see 2,519,694) |
OLIVIER, Leon J. |
Bracket | |
1950 | ||||||
U | 2,519,694 | August 22, 1950 | Insulator Supporting Bracket Bracket for wireholders or rack spools that allow the spool insulator to swivel out away from the bracket for easily working on the line wire and insulator (see 2,302,883) |
OLIVIER, Leon J. |
Bracket |
Total of 0.00 seconds