|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 = 'CROSSLEY') AND (first_name = 'Joseph') ORDER BY assigned_to ASC, date, patent, type|
Total of 4 patents found where: Last Name is 'CROSSLEY'; First Name is 'Joseph';
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||473,497||April 26, 1892||Pug Mill
Pug mill for extruding clay
|U||474,496||May 10, 1892||Apparatus for Molding Earthenware, &c.
Press to form lateral indentions or wire grooves around the side of the insulator to such as for standard porcelain knobs
|U||533,212||January 29, 1895||Combined Jigger and Pulldown
Press or jigger gearing and mechanism for forming earthen ware articles such as dishes and pottery
|U||772,132||October 11, 1904||Filter Cloth
Design of filter cloth for filter press that reduces the water content of clay
Total of 0.01 seconds