|SELECT DISTINCT patent.*, YEAR(date) as year FROM patent LEFT JOIN name ON name.patent = patent.patent AND name.type = patent.type WHERE (residence = 'Evanston, IL') ORDER BY date ASC, patent, type|
Total of 5 patents found where: Residence is 'Evanston, IL';
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||1,094,852||April 28, 1914||Insulator Pin
Pin, metal flanged to fit crossarm and interior bolt for attachment to thimble
|HECHT, Julius L.
GAPEN, Jotham C.
|Pin||1/2 to Electric Service Supplies Co.|
|U||1,179,395||April 18, 1916||Insulating Support for Storage Battery Tanks
Battery support insulator with lead cup underneath
|BECK, Harold M.
|U||1,854,459||April 19, 1932||Insulator
Skirts upturned with drain holes
|DIENNER, John A.
|U||2,267,202||December 23, 1941||Fuse Box Construction
Improved design of fuse holder box made of glass
|HOLMES, Minot K.
MCMAHON, George F.
|Fuse Holder||Schweitzer & Conrad, Inc.|
|U||2,287,895||June 30, 1942||Secondary Rack Construction
Secondary wireholder for rack spools to be mounted on the end of a crossarm
|MACKINNON, Russell H.
||Wireholder||1/2 to Eugene C. Black|
Total of 0.01 seconds