SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN category ON category.patent = patent.patent AND category.type = patent.type WHERE (category.class = '200') AND (category.subclass = '79') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Class is '200'; Subclass is '79';
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 |
1908 | ||||||
U | 889,803 | June 2, 1908 | Support for Electrical Conductors Impractical arrangement using a secondary insulator to support broken conductor above to prevent the line from dropping to the ground. It uses M-3890 insulators. |
PAINE, Francis B. H. |
Miscellaneous | Niagara, Lockport and Ontario Power Co. |
1909 | ||||||
U | 930,141 | August 3, 1909 | Automatic Safety Device A rotating metal member that catches a broken wire and shorts out the line effectively turning off the power before the line drops to the ground where it could have harmed someone coming in contact with the broken wire. |
BOURDIL, Francois Fernand |
Miscellaneous |
Total of 0.00 seconds