About this Dataset

Public Adjuster Business Entities Licensed In Iowa

A public adjuster business entity is a corporation, association, partnership, limited liability company, limited liability partnership or any other legal entity that is licensed pursuant to Iowa code chapter 522C and for compensation or other thing of value, does any of the following:

-Acts for or aids an insured in negotiating or affecting the settlement of a first-party claim for loss or damage to real or personal property of an insured.
-Advertises for employment as a public adjuster of first-party insurance claims or otherwise solicits business or represents to the public that the person is a public adjuster of first-party insurance claims for loss or damage to real or personal property of an insured.
-Directly or indirectly solicits business investigating or adjusting losses, or advising an insured about first-party claims for loss or damage to real or personal property of the insured.

This dataset contains a listing of licensed resident and non-resident public adjuster business entities.
Organization: State of Iowa
Last updated: 2025-07-05T17:09:20.050335
Tags: public-adjusters

Tables

Table 1

@usgov.state_of_iowa_public_adjuster_business_entities_licens_6c77aed2.table_1

12.9 kB
3 rows
16 columns


CREATE TABLE table_1 (
  "national_producer_number" BIGINT,
  "entity_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" BIGINT,
  "business_email" VARCHAR,
  "county_of_residence" VARCHAR,
  "area_of_expertise" VARCHAR,
  "physical_location" VARCHAR
);