|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (category = 'Can') ORDER BY assigned_to DESC, date, patent, type|
Total of 3 patents found where: Category is 'Can';
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|
|R||1,593||December 22, 1863||Improvement in Sealing Fruit Can
Metal can with rubber gasket (see 11,332)
|GRIFFEN, John F.
|U||10,396||January 3, 1854||Improvement in Sealing Preserve Cans
Pump to pull a vacuum on a can
|NICHOLSON, Henry C.
|U||11,332||July 18, 1854||Improvement in Hermetical Sealing
Metal can with rubber gasket (see reissue 1,593)
Total of 0.01 seconds