CSV documentation

A file that fits your workflow.

The CSV format, delivery details, and fields included in every pack.

Download format

Paid packs are UTF-8 CSV files compressed with gzip, using the .csv.gz extension. Extract the download before importing. The free sample is an uncompressed CSV. The nationwide export has more rows than a spreadsheet holds, so a nationwide order also downloads as a ZIP of the state files: one plain CSV for each state and DC, each of which opens in a spreadsheet.

Contact and location fields

The CSV includes full_name, first_name, last_name, address, city, state, postal_code, business_phone, business_email, and agency_name. An empty value means the record has no value for that field.

Licensing and snapshot fields

Licensing fields include npn, license_number, license_state, license_residency, resident_state, resident_state_basis, license_type, lines_of_authority, license_status, issue_date, expiration_date, years_licensed, is_life_health, and is_property_casualty. The ingested_at field records when the row was built.

license_state is the state that issued license_number, and license_residency says whether that license is Resident or Non-Resident (empty when the record does not say). resident_state is the producer's home state. resident_state_basis is license when a license record states the home state, and address when the home state is taken from the business address, which is left empty if the producer holds a non-resident license in the address state.

Importing

Preserve identifiers, phone numbers, and postal codes as text. Check duplicate behavior and test a small batch first. The CRM import guide covers field mapping, file limits and duplicate rules for HubSpot, Salesforce and Pipedrive.

Adjuster file: who and what kind

Adjuster packs have their own 27 columns. Identity and contact use the same headers as the agent file: npn, full_name, first_name, last_name, address, city, state, postal_code, business_phone and business_email, plus business_name for the employer or firm on the record.

adjuster_type is the primary type: Public adjuster, Company or independent adjuster, Auto damage appraiser or Emergency adjuster. adjuster_types lists every type on the record. is_public_adjuster and is_designated_home_state are 1 or 0. lines_of_authority lists All lines, Property & casualty, Workers' compensation, Auto physical damage, Crop, Personal lines, Commercial lines or Health.

Adjuster file: licenses and contact quality

license_states lists the tracked states where an active adjuster license was on file, and license_state_count counts them. license_numbers pairs each state with its license number (ST:number). license_classes holds the license class as each state words it. issue_date is the earliest issue date and expiration_date the latest expiration among those licenses; years_licensed is measured from issue_date. home_state is the licensing home state, which can be a designated home state.

Multi-value fields are joined with a semicolon and a space. email_shared_count is the number of adjusters in the nationwide file with the same business_email: 1 means the address is that adjuster's alone, a larger number means a shared inbox, and 0 means no email. last_seen is the date of the latest snapshot that included the record.

Check it yourself first

Open the sample before you spend anything.

insurance-agents-free-sample.csv1,000 real records · 25 columns · all 50 states + DCDownload free sample

Same columns as the paid packs. No signup and no email required. Or browse the state packs