Name: Public Adjusters Licensed In Iowa
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Public Adjusters Licensed In Iowa

A public adjuster is a professional claims handler claims adjuster who advocates for the policyholder in appraising and negotiating a claimant's insurance claim. This dataset contains a listing of licensed resident and non-resident public adjusters.
Organization: State of Iowa
Last updated: 2023-01-20T00:11:52.477988
Tags: insurance, public-adjusters

Tables

Table 1

@usgov.state_of_iowa_public_adjusters_licensed_in_iowa.table_1

41.15 kB
308 rows
15 columns

CREATE TABLE table_1 (
  "national_producer_number" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "mailing_address1" VARCHAR,
  "mailing_address2" VARCHAR,
  "mailing_address3" 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,
  "continuing_education_compliance" VARCHAR,
  "physical_location" VARCHAR
);