SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Trinidad, CO') ORDER BY date ASC, patent, type |
Total of 2 patents found where: Residence is 'Trinidad, CO';
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 |
1905 | ||||||
U | 799,726 | September 19, 1905 | Insulator Insulator, split and threaded to screw into hole in crossarm to hold wire |
FOREMAN, Ernest Jay |
Insulator | |
1908 | ||||||
U | 884,142 | April 7, 1908 | Insulator Cylindrical insulator with spiraling ribs to screw insulator into crossarm, center groove to hold line wire, external grooves to carry water away and drip points or serrations to allow water to drip down |
FOREMAN, Ernest Jay |
Crossarm |
Total of 0.00 seconds