About this Dataset

Connecticut Business Registry - Agents

This dataset is the agent object from the Connecticut Business Registry. The dataset provides agent information for all statutory agents reported to the Connecticut Secretary of the State, Business Services Division.

Link this data set to the Connecticut Business Registry - Business Master using the unique key value in the first column.
Organization: State of Connecticut
Last updated: 2021-08-13T17:48:09.029113
Tags: agents, business, business-registration

Tables

Table 1

@usgov.state_of_connecticut_connecticut_business_registry_agents.table_1

158.96 MB
1,211,891 rows
36 columns

CREATE TABLE table_1 (
  "unique_key" VARCHAR,
  "business_id" VARCHAR,
  "agent_account_alei" VARCHAR,
  "agent_type" VARCHAR,
  "agent_name" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_middle_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "agent_suffix" VARCHAR,
  "agent_phone" VARCHAR,
  "agent_email" VARCHAR,
  "business_address" VARCHAR,
  "business_street_address_1" VARCHAR,
  "business_street_address_2" VARCHAR,
  "business_street_address_3" VARCHAR,
  "business_city" VARCHAR,
  "business_state" VARCHAR,
  "business_zip_code" VARCHAR,
  "business_country" VARCHAR,
  "business_international_address" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_street_address_1" VARCHAR,
  "mailing_street_address_2" VARCHAR,
  "mailing_street_address_3" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_zip_code" VARCHAR,
  "mailing_state" VARCHAR,
  "mailing_country" VARCHAR,
  "residence_street_address_1" VARCHAR,
  "residence_street_address_2" VARCHAR,
  "residence_street_address_3" VARCHAR,
  "residence_city" VARCHAR,
  "residence_state" VARCHAR,
  "residence_zip_code" VARCHAR,
  "residence_country" VARCHAR,
  "create_dt" TIMESTAMP
);