data.iowa.gov

Close
Author
Iowa Insurance Division (Commerce)
Description
This dataset provides a listing of resident and non-resident insurance producers licensed to sell to Iowans.
Category
Regulation
Tags
insurance, producers, licensed, life, variable life, variable annuity, accident and health, crop, casualty, property, personal lines, credit, surety, reciprocal authority
Rating
Current value: 0 out of 5
Data Provided By
Iowa Insurance Division
License
1.0 Universal (Public Domain Dedication)
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

National Producer Number
npn
Last Name
last_name
First Name
first_name
Mailing Address 1
address_line_1
Mailing Address 2
address_line_2
Mailing Address 3
address_line_3
Mailing City
city
Mailing State
state
Mailing Zip
zip
Active Date
firstactivedate
Date Expire
expirydate
Business Phone
business_phone
Business Email
email
Physical Location
physical_location
Iowa Resident
iowaresident
Crop
loa_has_crop
Surety
loa_has_surety
Accident and Health
loa_has_ah
Life
loa_has_life
Variable Life, Variable Annuity
loa_has_variable
Personal Lines
loa_has_personal_lines
Credit
loa_has_credit
Excess and Surplus Lines
loa_has_excess
Property
loa_has_property
Casualty
loa_has_casualty
Reciprocal Authority
loa_has_reciprocal
US Counties
:@computed_region_e7ym_nrbf
Iowa Watersheds (HUC 10)
:@computed_region_i9mz_6gmt
Iowa Watershed Sub-Basins (HUC 08)
:@computed_region_wnea_7qqw
Iowa ZIP Code Tabulation Areas
:@computed_region_3r5t_5243

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.