| SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Crawfordsville, IN') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Residence is 'Crawfordsville, IN';
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 |
| 1888 | ||||||
| U | 384,384 | June 12, 1888 | Metallic Crest Tile Lightning Rod Lightning rod in the form of metal crest tile and attached to end eaves of the house with conductors to ground |
NELSON, Clark B. |
Lightning Rod Crest | 1/2 to James H. Watson |
| 1891 | ||||||
| U |
464,036 | December 1, 1891 | Roof Cresting Ornamental glass coping or cresting for roofs |
NELSON, Clark B. |
Roof Crest | |
Total of 0.00 seconds