SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Dusseldorf,, Germany') ORDER BY date ASC, patent, type |
Total of 1 patents found where: Residence is 'Dusseldorf,, Germany';
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 |
1899 | ||||||
U | 628,343 | July 4, 1899 | Fixing of Insulators for Carrying Electric Line Wires Metal pin with a threaded end for mounting an insulator and below that angular grooves to aid mounting and mortaring in brick, concrete or stone (see gb1899-0002396) |
MENZEL, Werner |
Pin |
Total of 0.00 seconds