|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 = '235') ORDER BY date ASC, patent, type|
Total of 2 patents found where: Class is '235';
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|
|R||8,304||June 25, 1878||Improvement in Couplings for Lightning Rods
Coupling for lightning rods where the ends can be screwed together (see 90,578)
|REYBURN, William S.
HUNTER, Edmund A. W.
|Lightning Rod Coupling||1/2 of Hunter's right to Byron P. Moulton|
|U||1,043,321||November 5, 1912||Combined Insulator and Current Distributor
Miscellaneous style with attachment for multiple current distributors (see 1,085,813)
|KNUTZ, Ernest H.
Total of 0.01 seconds