|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 = 'BOURDIL') AND (first_name = 'Francois Fernand') ORDER BY date ASC, patent, type|
Total of 1 patents found where: Last Name is 'BOURDIL'; First Name is 'Francois Fernand';
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||930,141||August 3, 1909||Automatic Safety Device
A rotating metal member that catches a broken wire and shorts out the line effectively turning off the power before the line drops to the ground where it could have harmed someone coming in contact with the broken wire.
|BOURDIL, Francois Fernand
Total of 0.00 seconds