|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (last_name = 'DEWING') AND (first_name = 'James') ORDER BY patent DESC, type|
Total of 1 patents found where: Last Name is 'DEWING'; First Name is 'James';
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|
|U||373,393||November 15, 1887||Tool for Cutting Seats for Insulator Attachments for Musical Instruments
Tool for cutting circular slot in piano legs in order to insert the piano insulator.
BENNETT, Delbert F.
Total of 0.00 seconds