About this Dataset

Active Iowa Business Entities

This dataset provides a list of active business entities, both domestic business organizations (organized under and subject to the laws of Iowa), and foreign business organizations (organized under a law other than Iowa) who are authorized to transact business in the State of Iowa at time of update. The dataset includes the business' legal name, type, effective date, name and address of registered agent, and address of principal office.

Sole proprietorships, partnerships and other select business structures are not required to register with the Iowa Secretary of State and would not be available in this dataset.
Organization: State of Iowa
Last updated: 2023-01-19T23:56:15.610826
Tags: banks, cooperative, corporations, general-partnerships, limited-liability-company, limited-liability-partnership, non-profit, profit, savings-loans, trademarks

Tables

Table 1

@usgov.state_of_iowa_active_iowa_business_entities.table_1

30.15 MB
336,511 rows
19 columns

CREATE TABLE table_1 (
  "corp_number" BIGINT,
  "legal_name" VARCHAR,
  "corporation_type" VARCHAR,
  "effective_date" TIMESTAMP,
  "registered_agent" VARCHAR,
  "ra_address_1" VARCHAR,
  "ra_address_2" VARCHAR,
  "ra_city" VARCHAR,
  "ra_state" VARCHAR,
  "ra_zip" DOUBLE,
  "home_office" VARCHAR,
  "ho_address_1" VARCHAR,
  "ho_address_2" VARCHAR,
  "ho_city" VARCHAR,
  "ho_state" VARCHAR,
  "ho_zip" DOUBLE,
  "ho_country" VARCHAR,
  "ra_location" VARCHAR,
  "ho_location" VARCHAR
);