SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (category = 'Non-electrical') ORDER BY last_name ASC, first_name, date, patent, type |
Total of 2 patents found where: Category is 'Non-electrical';
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 |
GILLILAND, James F. | ||||||
U | 296,330 | April 8, 1884 | Insulator for Line Wires of Mechanical Telephones Non-electrical (!!) insulator to suspend wires of mechanical telephones!!! |
GILLILAND, James F. |
Non-electrical | John Bennet and August Meyer |
SULLIVAN, Eugene C. TAYLOR, William C. | ||||||
U | 1,304,622 | May 27, 1919 | Heating Vessel Production of glass baking dishes from Pyrex glass |
SULLIVAN, Eugene C. TAYLOR, William C. |
Non-electrical | Corning Glass Works |
Total of 0.02 seconds