Insurance Producers Licensed in Iowa - Accident and Health
mydata.iowa.gov | Last Updated 30 Aug 2023This filtered view provides a listing of resident and non-resident insurance producers licensed to sell to accident and health insurance to Iowans.
This dataset has the following 26 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| National Producer Number | npn | number | 20686365 7961247 19155121 11022478 18815759 view top 100 | |
| Last Name | last_name | text | SMITH JOHNSON WILLIAMS BROWN JONES view top 100 | |
| First Name | first_name | text | MICHAEL JOHN DAVID JAMES ROBERT view top 100 | |
| Mailing Address 1 | address_line_1 | text | 13620 RANCH ROAD 620 N STE A250 1550 SAWGRASS CORPORATE PKWY 120 W 12TH ST STE 1700 546 BALLOUGH RD 3450 BUSCHWOOD PARK DR STE 200 view top 100 | |
| Mailing Address 2 | address_line_2 | text | SUITE 1700 SUITE 500 1100 EMPLOYERS BLVD SUITE 200 SUITE 201 view top 100 | |
| Mailing Address 3 | address_line_3 | text | IOWA IA WEST DES MOINES SUITE 100 STE 300 view top 100 | |
| Mailing City | city | text | TAMPA OMAHA KANSAS CITY AUSTIN CHARLOTTE view top 100 | |
| Mailing State | state | text | FL IA TX IL MO view top 100 | |
| Mailing Zip | zip | text | 78717 64105 50266 33323 33618 view top 100 | |
| Active Date | firstactivedate | calendar_date | Date Iowa License was first active. | 2021-09-01T00:00:00.000 2022-11-01T00:00:00.000 2023-11-01T00:00:00.000 2023-04-01T00:00:00.000 2023-01-01T00:00:00.000 view top 100 |
| Date Expire | expirydate | calendar_date | Date Iowa License will expire. | 2024-08-31T00:00:00.000 2025-10-31T00:00:00.000 2025-09-30T00:00:00.000 2026-10-31T00:00:00.000 2025-12-31T00:00:00.000 view top 100 |
| Business Phone | business_phone | text | 8005475514 8554483386 9136249206 8003287305 8009859449 view top 100 | |
| Business Email | text | licensing@gohealth.com licensing@tzinsurance.com CONTRACTING@MEDICAREINSURANCE.COM agentinfo@healthplanone.com licensing@ehealthinsurance.com view top 100 | ||
| Physical Location | physical_location | point | Physical Location of licensed insurance producer based on street address contained within mailing address if available. | {"coordinates":[-97.778340169,30.475178348],"type":"Point"} {"coordinates":[-94.585222022,39.100464987],"type":"Point"} {"coordinates":[-80.339303008,26.140502],"type":"Point"} {"coordinates":[-82.497348032,28.035301998],"type":"Point"} {"coordinates":[-81.02256801,29.222984989],"type":"Point"} view top 100 |
| Iowa Resident | iowaresident | text | Column indicates whether the producer resides in Iowa. | N Y view top 100 |
| Crop | loa_has_crop | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Surety | loa_has_surety | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Accident and Health | loa_has_ah | text | Yes indicates the provider offers this insurance product. | Yes view top 100 |
| Life | loa_has_life | text | Yes indicates the provider offers this insurance product. | Yes No view top 100 |
| Variable Life, Variable Annuity | loa_has_variable | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Personal Lines | loa_has_personal_lines | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Credit | loa_has_credit | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Excess and Surplus Lines | loa_has_excess | text | Yes indicates the provider offers this insurance product. | No view top 100 |
| Property | loa_has_property | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Casualty | loa_has_casualty | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |
| Reciprocal Authority | loa_has_reciprocal | text | Yes indicates the provider offers this insurance product. | No Yes view top 100 |