NEW AGENT LICENSES-LINES FILE SPECIFICATIONS

Print this page

Data files are in the Excel (.xls) format. Files have been designed so they can be easily subset and sorted in a spreadsheet or database program compatible with the Excel extension based on criteria from each field below. Files include column headings. Data provided will be for agents or agencies with licenses having the status of "issued" and generally will be effective as of the end of the last business day prior to the date of download.

Agent First Name
Agent Middle Name
Agent Last Name
Agent Name Suffix
Mailing Address Line 1
Mailing Address Line 2
City
State
Zip
Zip+4
Country
National Producer Number
Resident/Non-resident (R/N)
Effective Date - Life (MM/DD/YYYY)
Effective Date - Accident & Health (MM/DD/YYYY)
Effective Date - Variable Contracts (MM/DD/YYYY)
Effective Date - Property (MM/DD/YYYY)
Effective Date - Casualty (MM/DD/YYYY)
Effective Date - Personal (MM/DD/YYYY)
Effective Date - Crop (MM/DD/YYYY)
Effective Date - Title (MM/DD/YYYY)
Effective Date - Travel (MM/DD/YYYY)
Effective Date - Bail Bonds (MM/DD/YYYY)
Bad Address Warning (X/blank)
Email Address (if provided for release)