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 = 'LINKE') AND (first_name = 'Charles') ORDER BY date ASC, patent, type |
Total of 1 patents found where: Last Name is 'LINKE'; First Name is 'Charles';
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 | 967,649 | August 16, 1910 | Means of Visibly Indicating Faulty Insulators Colored flammable cap that fits over the top of an insulator that will burn away during an arc indicating that the insulator may be damaged |
LINKE, Charles |
Miscellaneous |
Total of 0.00 seconds