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 = 'HILLIARD') AND (first_name = 'John D.') ORDER BY date ASC, patent, type |
Total of 3 patents found where: Last Name is 'HILLIARD'; First Name is 'John D.';
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 |
1909 | ||||||
U | 914,837 | March 9, 1909 | Line Support Tie wires wrapped around the neck of the insulator and clamped to the conductor on each end. |
HILLIARD, John D. |
Tie Wire | |
1912 | ||||||
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 |
1913 | ||||||
U | 1,069,782 | August 12, 1913 | Electric Insulator Multipart cable clamp using metal crown cap |
HILLIARD, John D. |
Multipart |
Total of 0.00 seconds