Download Agent Data File Web Information Is Updated Weekly File Description: This tab-delimited ASCII file contains a single record for each active insurance agent licensed by the State of Oregon. The file is over 8.2 MB in size and contains over 30,000 records. A record layout (list of fields) is provided below. For summary level data about insurance agents and agencies, as well as descriptions of license classes, subclasses, and endorsements, please see the DCBS publication, Oregon Insurance Agents and Agencies. This document is in .pdf format. You will need Adobe Acrobat Reader to view it and you can download this free from Adobe. Download procedures: To retrieve the file, click the download button below. A dialogue box will pop up and ask where you want to store the file for your later use. Indicate the path and file name for saving the file on your computer. It may take a few minutes to complete the download.

Please note: The Oregon Department of Consumer and Business Services does not have the staff resources to provide technical support for downloading information. If you have difficulty retrieving the file, please consult your technical staff first.

Record Layout for the Oregon Insurance Agent Download   Field Name Length Type Comments 0 (blank) 1 N/A   1 Agent's Last Name 25 Character   2 Agent's First Name 12 Character   3 Agent's Middle Name 10 Character   4 Business Address 40 Character   5 Address 2 40 Character   6 Address 3 40 Character   7 City 18 Character   8 County 12 Character   9 State 2 Character Standard 2-letter state abbreviations 10 Zip Code 5 Numeric   11 Zip Code Extension 4 Numeric   12 Business Phone Area Code 3 Numeric   13 Business Phone Number 7 Numeric   14 Resident Flag * 1 Character "Y" if Oregon resident; "N" if not 15 License Number 6 Numeric   16 License Expiration Date 8 Date Format as 'ccyy/mm/dd'   License Class Flags:       17 Life 1 Character "X" if licensed for this class 18 Health 1 Character "X" if licensed for this class 19 General Lines (GL) 1 Character "X" if licensed for this class 20 Adjuster, General Lines 1 Character "X" if licensed for this class 21 Adjuster, Health 1 Character "X" if licensed for this class 22 Consultant, General Lines 1 Character "X" if licensed for this class 23 Consultant, Health 1 Character "X" if licensed for this class 24 Consultant, Life 1 Character "X" if licensed for this class 25 Lender's Property 1 Character "X" if licensed for this GL subclass 26 Mortgage 1 Character "X" if licensed for this GL subclass 27 Livestock 1 Character "X" if licensed for this GL subclass 28 Motor Veh. Mech. Breakdown 1 Character "X" if licensed for this GL subclass 29 Motor Veh. Physical Damage 1 Character "X" if licensed for this GL subclass 30 Travel 1 Character "X" if licensed for this Health subclass 31 Baggage 1 Character "X" if licensed for this GL subclass 32 Credit Involuntary Unemployment 1 Character "X" if licensed for this GL subclass 33 Credit 1 Character "X" if licensed for this GL subclass 34 Credit Life 1 Character "X" if licensed for this Life subclass 35 Credit Health 1 Character "X" if licensed for this Health subclass 36 Surplus Lines 1 Character "X" if licensed for this GL endorsement 37 Filler 1 Character "X" if licensed for this GL endorsement 38 Title 1 Character "X" if licensed for this GL subclass 39 Variable Annuity 1 Character "X" if licensed for this Life endorsement 40 Managing General Agent 1 Character "X" if licensed for this endorsement. 41 Intermediary Broker 1 Character "X" if licensed for this endorsement. 42 Intermediary Manager 1 Character "X" if licensed for this endorsement. 43 Life Settlement Broker 1 Character "X" if licensed for this special class. 44 Property 1 Character "X" if licensed for this special class. 45 Casualty 1 Character "X" if licensed for this special class. 46 Personal Lines 1 Character "X" if licensed for this special class. 47 Variable Life 1 Character "X" if licensed for this special class. Main Search page If you have questions or comments about the Insurance Agent Search please write the DCBS Insurance Division This document was last revised 01/08/2002