About this Dataset

Insurance Producers Licensed In Iowa

The Iowa Insurance Division is responsible for issuing licenses or authority for many types of regulated individuals dealing with insurance related products. Individuals interested in becoming either a resident or non-resident insurance producer licensed in the state of Iowa need to apply through the National Insurance Producer Registry (NIPR) online system. Those wishing to become a resident insurance producer licensed in the state of Iowa must successfully pass the appropriate Iowa producer licensing exam for that specific line of authority.

To add additional lines of authority, a resident or non-resident insurance producer licensed in the state of Iowa need to apply through the NIPR online system. Resident insurance producers wishing to add a line of authority must successfully pass the appropriate Iowa producer licensing exam for that specific line of authority.

This dataset provides a listing of resident and non-resident insurance producers licensed to sell to Iowans.
Organization: State of Iowa
Last updated: 2023-01-20T00:05:33.827783
Tags: accident-and-health, casualty, credit, crop, insurance, licensed, life, personal-lines, producers, property, reciprocal-authority, surety, variable-annuity, variable-life

Tables

Table 1

@usgov.state_of_iowa_insurance_producers_licensed_in_iowa.table_1

16.71 MB
212,910 rows
26 columns

CREATE TABLE table_1 (
  "national_producer_number" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "mailing_address_1" VARCHAR,
  "mailing_address_2" VARCHAR,
  "mailing_address_3" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_zip" DOUBLE,
  "active_date" TIMESTAMP,
  "date_expire" TIMESTAMP,
  "business_phone" BIGINT,
  "business_email" VARCHAR,
  "physical_location" VARCHAR,
  "iowa_resident" VARCHAR,
  "crop" VARCHAR,
  "surety" VARCHAR,
  "accident_and_health" VARCHAR,
  "life" VARCHAR,
  "variable_life_variable_annuity" VARCHAR  -- Variable Life, Variable Annuity,
  "personal_lines" VARCHAR,
  "credit" VARCHAR,
  "excess_and_surplus_lines" VARCHAR,
  "property" VARCHAR,
  "casualty" VARCHAR,
  "reciprocal_authority" VARCHAR
);