|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (category = 'Rosette') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Category is 'Rosette';
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||481,624||August 30, 1892||Ceiling Rosette Cut-Out
Ceiling rosette Patent was owned by Pass & Seymour.
SEYMOUR, Albert P.
Total of 0.00 seconds