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 = '403') AND (category.subclass = '363') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Class is '403'; Subclass is '363';
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 |
1873 | ||||||
U | 143,862 | October 21, 1873 | Improvement in Lightning Rods Lightning rod with twisted flanges that is split on the ends where it fits snugly with the split in the adjoining rod with said joint secured with metal pins |
WHITE, Joseph J. |
Lightning Rod | |
1883 | ||||||
U | 278,028 | May 22, 1883 | Lightning Rod Method of connecting flanged or ribbed lightning rods |
LOBDELL, Augustus C. |
Lightning Rod Coupling |
Total of 0.00 seconds