About this Dataset

Staff Adjusters Licensed In Iowa

A staff adjuster is a person who may be licensed pursuant to Iowa code chapter 522C and who is directly employed by an insurer or self-insurer to investigate, negotiate, or settle property, casualty, or workers’ compensation claims.

This dataset contains a listing of licensed resident and non-resident independent adjusters.
Organization: State of Iowa
Last updated: 2025-07-05T17:10:03.937711
Tags: insurance

Tables

Table 1

@usgov.state_of_iowa_staff_adjusters_licensed_in_iowa.table_1

30.91 kB
197 rows
17 columns

CREATE TABLE table_1 (
  "national_producer_number" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "mailing_address1" VARCHAR,
  "mailing_address2" VARCHAR,
  "mailing_address3" VARCHAR,
  "street_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" BIGINT,
  "date_iowa_license_first_active" TIMESTAMP,
  "iowa_license_expiration_date" TIMESTAMP,
  "business_phone" DOUBLE,
  "business_email" VARCHAR,
  "county_of_residence" VARCHAR,
  "area_of_expertise" VARCHAR,
  "physical_location" VARCHAR
);