|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 = '248') AND (category.subclass = '230.1') ORDER BY date ASC, patent, type|
Total of 3 patents found where: Class is '248'; Subclass is '230.1';
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||871,490||November 19, 1907||Insulator Pin Mounting
Mounting for hollow steel pin on a steel tower
|DUNCAN, John D. E.
|U||1,175,849||March 14, 1916||Insulator Base
miscellaneous circular holder with metal support
|WARREN, Frederic A.
|U||2,222,810||November 26, 1940||Clamp for Connecting an Insulator to a Post
Electric fence with bracket to attach an easily adjustable insulator to a T-post
|DAILY, Floyd H.
Total of 0.00 seconds