|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (assigned_to = 'James Brusie') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Assigned To is 'James Brusie';
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||452,523||May 19, 1891||Electric Insulator
Cone of wood with metal shield for trolley wire hanger
||Wood||1/2 to James Brusie|
Total of 0.01 seconds