| SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN category ON category.patent = patent.patent AND category.type = patent.type WHERE (category.class = '174') AND (category.subclass = '142') ORDER BY date ASC, patent, type |
Total of 4 patents found where: Class is '174'; Subclass is '142';
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 |
| 1915 | ||||||
| U | 1,129,520 | February 23, 1915 | Insulating Body for Electrical Apparatus Multipart, theory to shape insulator to conform to electrical fields (typical spelling is FORTESCUE, Charles Le G.) (see 1,259,385) |
RANDALL, Karl C. FARNSWORTH, Sidney W. FORTESCUE, Charles Le Geyt |
Multipart | Westinghouse Electric & Mfg. Co. |
| 1924 | ||||||
| U | 1,491,385 | April 22, 1924 | Insulator Wall or roof bushing to bring conductor into the building |
FACCILOI, Giuseppe |
Miscellaneous | General Electric Co. |
| 1934 | ||||||
| U | 1,977,957 | October 23, 1934 | Bus Bar and Bushing Connection Connector to hold bus bar inside a bushing |
STEVENS, Leland S. |
Bushing | Locke Insulator Corp. |
| U | 1,978,649 | October 30, 1934 | Bus Bar and Bushing Connection Connector to hold bus bar inside a bushing |
ROBERTS, Charles W. |
Bushing | Locke Insulator Corp. |
Total of 0.00 seconds