Connecticut Business Registry - Business Master by US Government | Finance and Economics

About this Dataset

Connecticut Business Registry - Business Master

This is the master business table (account object) from the Connecticut Business Registry, maintained by the Secretary of the State, Business Services Division.
Organization: State of Connecticut
Last updated: 2021-08-13T17:47:33.784015
Tags: business, business-registration, economic-development, registry

Tables

Table 1

@usgov.state_of_connecticut_connecticut_business_registry_bus_de67a975.table_1

115 MB
1212496 rows
59 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "name" VARCHAR,
  "business_type" VARCHAR,
  "status" VARCHAR,
  "sub_status" VARCHAR,
  "accountnumber" DOUBLE,
  "annual_report_due_date" TIMESTAMP,
  "began_transacting_in_ct" TIMESTAMP,
  "business_street" VARCHAR,
  "business_unit" VARCHAR,
  "business_city" VARCHAR,
  "business_country" VARCHAR,
  "business_zip" VARCHAR,
  "business_state" VARCHAR,
  "business_email_address" VARCHAR,
  "business_name_in_state_country" VARCHAR,
  "citizenship" VARCHAR,
  "country_formation" VARCHAR,
  "date_registration" VARCHAR,
  "formation_place" VARCHAR,
  "state_or_territory_formation" VARCHAR,
  "date_of_organization_meeting" TIMESTAMP,
  "dissolution_date" VARCHAR,
  "mail_jurisdiction_international_address" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_international_address" VARCHAR,
  "mailing_jurisdiction_address" VARCHAR,
  "mailing_jurisdiction_businessstreet" VARCHAR,
  "mailing_jurisdiction_businessunit" VARCHAR,
  "mailing_jurisdiction_businesscity" VARCHAR,
  "mailing_jurisdiction_businessstate" VARCHAR,
  "mailing_jurisdiction_businesszipcode" VARCHAR,
  "mailing_jurisdiction_country" VARCHAR,
  "woman_owned_organization" BOOLEAN,
  "veteran_owned_organization" BOOLEAN,
  "minority_owned_organization" BOOLEAN,
  "org_owned_by_person_s_with_disabilities" BOOLEAN,
  "organization_is_lgbtqi_owned" BOOLEAN,
  "category_survey_email_address" VARCHAR,
  "naics_code" VARCHAR,
  "naics_sub_code" DOUBLE,
  "office_jurisdiction_address" VARCHAR,
  "office_jurisdiction_businessstreet" VARCHAR,
  "office_jurisdiction_businessunit" VARCHAR,
  "office_jurisdiction_businesscity" VARCHAR,
  "office_jurisdiction_businessstate" VARCHAR,
  "office_jurisdiction_businesszipcode" VARCHAR,
  "office_in_jurisdiction_country" VARCHAR,
  "reason_for_administrative_dissolution" VARCHAR,
  "record_address" VARCHAR,
  "records_address_street" VARCHAR,
  "records_address_unit" VARCHAR,
  "records_address_city" VARCHAR,
  "records_address_state" VARCHAR,
  "records_address_zip_code" VARCHAR,
  "records_address_country" VARCHAR,
  "total_authorized_shares" DOUBLE,
  "create_dt" TIMESTAMP,
  "geo_location" VARCHAR
);