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 = 'COURTENAY') AND (first_name = 'William') ORDER BY category DESC, date, patent, type |
Total of 3 patents found where: Last Name is 'COURTENAY'; First Name is 'William';
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 |
Third Rail | ||||||
U | 664,470 | December 25, 1900 | Construction for Third Rail Electric Railways Third rail insulator, support, and fastening device. Insulator was made by the Reconstructed Granite Co. as shown in their advertisement in EWE dated April 15, 1905. |
COURTENAY, William |
Third Rail | |
U | 802,498 | October 24, 1905 | Retaining Clip for Third Rail Insulators Retaining clip for third rail insulators to secure the rail. |
COURTENAY, William |
Third Rail | |
Hook | ||||||
U | 269,933 | January 2, 1883 | Insulator for the Suspension of Electrical Wire Conductors Hook insulator of ""gelatinized or vulcanized fiber"" |
HIGGS, Paget COURTENAY, William |
Hook |
Total of 0.01 seconds