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 = 'LOCKE') AND (first_name = 'Louis P.') ORDER BY date ASC, patent, type |
Total of 4 patents found where: Last Name is 'LOCKE'; First Name is 'Louis P.';
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 |
1910 | ||||||
U | 979,015 | December 20, 1910 | Rail Joint Joint to connect rails to improve signal communication |
LOCKE, Louis P. |
Rail | |
1911 | ||||||
U | 1,003,143 | September 12, 1911 | Electric Signaling Apparatus Improved signaling of railways |
LOCKE, Louis P. |
Signal | |
1952 | ||||||
U | 2,610,390 | September 16, 1952 | Method of Making Electrical Terminals Method of making terminals for manufacture of televisions |
LOCKE, Louis P. |
Television | |
1953 | ||||||
U | 2,646,788 | July 28, 1953 | Rotary Gas Burner Burner for gas stove that rotates to improve heat generation |
LOCKE, Louis P. |
Burner |
Total of 0.00 seconds