|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Glens Falls, NY') ORDER BY date ASC, patent, type|
Total of 2 patents found where: Residence is 'Glens Falls, NY';
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|
|U||758,179||April 26, 1904||Supporting Pin for Line Insulators
Steel pin with porcelain base and metal cap
|HILLIARD, JR., John D.
|U||1,015,229||January 16, 1912||Insulator
Suspension using multiple parts cemented together on tubular core. The patent is similar to the commonly referred ""Micarta Core"" insulators, but experts believe the patent was not used for those insulators. The glass insulators may have been made by Hemingray.
|HILLIARD, John D.
PARSONS, Charles E.
|Suspension||J. E. Way|
Total of 0.00 seconds