About this Dataset

Connecticut Business Registry - Principals

This dataset is the principals object from the Connecticut Business Registry. The dataset provides principal information for all principals reported to the Connecticut Secretary of the State, Business Services Division. A principal is an officer or director of a corporation, a member or manager of an LLC or a partner in a limited liability partnership.

This data may be linked to the master data set using the unique identifier in the first column.
Organization: State of Connecticut
Last updated: 2021-08-13T17:47:19.093518
Tags: business, business-registration, principal, principals

Tables

Table 1

@usgov.state_of_connecticut_connecticut_business_registry_principals.table_1

173.99 MB
1664633 rows
26 columns


CREATE TABLE table_1 (
  "unique_key" VARCHAR,
  "principal_name" VARCHAR,
  "first_name" VARCHAR,
  "middle_name" VARCHAR,
  "last_name" VARCHAR,
  "suffix" VARCHAR,
  "designation" 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,
  "residence_address" 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,
  "residence_international_address" VARCHAR,
  "type" VARCHAR,
  "create_dt" TIMESTAMP
);