This is the master business table (account object) from the Connecticut Business Registry, maintained by the Secretary of the State, Business Services Division.
This dataset has the following 59 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Id | id | text | System generated unique identifier. This is the unique key to associate the subsidiary data sets. | 001t000000Wn2SUAAZ 0018y00000992akAAA 001t000000WnokNAAR 001t000000Wo65JAAR 001t000000WnroNAAR view top 100 |
| Name | name | text | Business Name | New business QUALITY BUILDERS WARRANTY CORPORATION KBA Inc. Stright Planes, Limited Partnership Algonquin Capital Partners LLC view top 100 |
| Business_Type | business_type | text | Business Type | LLC Stock Non-Stock Limited Partnership Religious view top 100 |
| Status | status | text | Business Status | Active Forfeited Dissolved Withdrawn Revoked view top 100 |
| Sub_status | sub_status | text | Business sub-status | Annual report past due Admin Dissolution Initiated Annual report due First report past due Ready for dissolution view top 100 |
| AccountNumber | accountnumber | text | Business ID number (Authoritative Legal Entity Identifier) Unique | 0000000 0539797 0886829 0050123 1362679 view top 100 |
| Annual_Report_Due_Date | annual_report_due_date | calendar_date | Annual Report Due Date | 2025-03-31T00:00:00.000 2024-03-31T00:00:00.000 2023-03-31T00:00:00.000 2022-03-31T00:00:00.000 2020-03-31T00:00:00.000 view top 100 |
| Began_Transacting_in_CT | began_transacting_in_ct | calendar_date | Date business began transacting business in CT, if a foreign registered entity | 1900-01-01T00:00:00.000 2023-01-01T00:00:00.000 2022-01-01T00:00:00.000 2021-01-01T00:00:00.000 2019-01-01T00:00:00.000 view top 100 |
| Business_Street | billingstreet | text | Business Street | No information provided NONE 2389 Main St. STE 100 591 WEST PUTNAM AVENUE 2389 MAIN ST. STE 100 view top 100 |
| Business_Unit | billing_unit | text | Business Unit | 2 1 3 STE 100 A view top 100 |
| Business_City | billingcity | text | Business City | STAMFORD HARTFORD BRIDGEPORT NEW HAVEN DANBURY view top 100 |
| Business_Country | billingcountry | text | Business Country | United States UNITED STATES USA US Canada view top 100 |
| Business_ZIP | billingpostalcode | text | Business Zip Code | 06902 06810 06830 06880 06033 view top 100 |
| Business_State | billingstate | text | Business State | CT NY MA FL CA view top 100 |
| Business_Email_Address | business_email_address | text | Business Email Address | Compliancemail@cscinfo.com efile1234@incfile.com CLS-CTARMSevidence@wolterskluwer.com cls-ctarmsevidence@wolterskluwer.com EFILE1234@INCFILE.COM view top 100 |
| Business_Name_in_state_country | business_name_in_state_country | text | Name of the business in the jurisdiction of formation, if foreign registered entity | UNITED STATES NEW YORK PARAFI PRIVATE OPPORTUNITIES LLC UNILOCK NEW YORK, INC. DELAWARE view top 100 |
| Citizenship | citizenship | text | Formation jurisdiction | Domestic Foreign view top 100 |
| Country_Formation | country_formation | text | Country of Formation | United States USA UNITED STATES Canada US view top 100 |
| Date_Registration | date_registration | calendar_date | For domestic businesses, this is the date the business was formed. For foreign businesses, this is the date they registered in Connecticut. | 0001-01-01T00:00:00.000 2021-06-21T00:00:00.000 2021-06-22T00:00:00.000 2013-02-13T00:00:00.000 1976-06-30T00:00:00.000 view top 100 |
| Formation_Place | formation_place | text | Formation Place | CT Connecticut DE NY MA view top 100 |
| State_or_Territory_Formation | state_or_territory_formation | text | Formation State Or Territory | Connecticut DE NY MA DELAWARE view top 100 |
| Date_of_Organization_Meeting | date_of_organization_meeting | calendar_date | Date of Organization Meeting | 1981-07-01T00:00:00.000 1980-07-01T00:00:00.000 1985-07-01T00:00:00.000 1990-01-02T00:00:00.000 1987-10-01T00:00:00.000 view top 100 |
| Dissolution_date | dissolution_date | calendar_date | If the entity is dissolved, the date it dissolved. This is also the withdrawal date if a foreign registered entity | 2015-12-31T00:00:00.000 2014-12-31T00:00:00.000 2016-12-31T00:00:00.000 2013-12-31T00:00:00.000 2018-12-31T00:00:00.000 view top 100 |
| Mail_Jurisdiction_International_address | mail_jurisdiction | text | Mail Jurisdiction International Address | 101/102 Mahalaxmi Arcade Opposite Mahalaxmi Temple Anand Mahal Road, Adajan, Surat 395009 GUJARAT 10, ANUOLUWAPO CLOSE, OFF AGBAOKU STREET, OPEBI, IKEJA, LAGOS STATE, 10 old school walk slip end luton bedfordshire lu1 4dy 158 CCA Phase 6 DHA Lahore 1 ROCHOR CANAL ROAD #01-09B SIM LIM SQUARE (188504) view top 100 |
| Mailing_Address | mailing_address | text | Mailing Address | , , , , , No information provided , , , , , , , , ,00000 , 2389 Main St. STE 100 , ,Glastonbury ,CT ,United States ,06033 591 WEST PUTNAM AVENUE , ,GREENWICH ,CT ,United States ,06830 view top 100 |
| Mailing_International_Address | mailing_international_address | text | Mailing International Address | 2851 John Street, Suite One, Markham, Ontario L3R 5R7 300-10220 103 AVENUE NW, EDMONTON, AB T5J 0K4 7077 PARC AVE., SUITE 600, MONTREAL, QC H3N 1X7 111 Gordon Baker Road, Suite 801 Toronto, Ontario M2H 3R1 1 Antares Dr., Ste 400 Ottawa, ON K2E 8C4 view top 100 |
| Mailing_Jurisdiction_Address | mailing_jurisdiction_address | text | Mailing Jurisdiction Address | 251 LITTLE FALLS DRIVE, WILMINGTON, DE, 19808, United States 251 Little Falls Dr, Wilmington, DE, 19808-1674, United States 251 LITTLE FALLS DRIVE, WILMINGTON, DE, 19808, 1209 ORANGE STREET, WILMINGTON, DE, 19801, United States 1209 N Orange St, Wilmington, DE, 19801-1120, United States view top 100 |
| Mailing_Jurisdiction_BusinessStreet | mailing_jurisdiction_2 | text | Mailing Jurisdiction Street | 251 LITTLE FALLS DRIVE 251 Little Falls Dr 1209 ORANGE STREET 251 LITTLE FALLS DR 1209 N Orange St view top 100 |
| Mailing_Jurisdiction_BusinessUnit | mailing_jurisdiction_3 | text | Mailing Jurisdiction Unit | Suite 201 Suite 100 STE 21-2 201 Suite 300 view top 100 |
| Mailing_Jurisdiction_BusinessCity | mailing_jurisdiction | text | Mailing Jurisdiction City | WILMINGTON Wilmington DOVER Dover NEW YORK view top 100 |
| Mailing_Jurisdiction_BusinessState | mailing_jurisdiction_1 | text | Mailing Jurisdiction State | DE NY MA FL NJ view top 100 |
| Mailing_Jurisdiction_BusinessZipCode | mailing_jurisdiction_4 | text | Mailing Jurisdiction Zip Code | 19808 19801 19904 19808-1674 19901 view top 100 |
| Mailing_Jurisdiction_Country | mailing_jurisdiction_country | text | Mailing Jurisdiction_Country | United States United Kingdom Canada China India view top 100 |
| Woman_Owned_Organization | woman_owned_organization | checkbox | Survey result for woman-owned | false true view top 100 |
| Veteran_Owned_Organization | veteran_owned_organization | checkbox | Survey result for veteran-owned | false true view top 100 |
| Minority_Owned_Organization | minority_owned_organization | checkbox | Survey result for minority-owned | false true view top 100 |
| Org_Owned_by_Person_s_with_disabilities | org_owned_by_person_s_with | checkbox | Survey result for owned by person with a disability | false true view top 100 |
| Organization_is_LGBTQI_Owned | organization_is_lgbtqi_owned | checkbox | Survey result for LGBTQI-owned | false true view top 100 |
| Category_Survey_Email_Address | category_survey_email_address | text | Email address provided on business survey | efile1235@incfile.com eastern@registeredagentsinc.com fulfillment@zenbusiness.com fulfillment+formations@zenbusiness.com annualreports@cscglobal.com view top 100 |
| NAICS_Code | naics_code | text | NAICS Code | Lessors of Residential Buildings and Dwellings (531110) Other Activities Related to Real Estate (531390) Lessors of Nonresidential Buildings (except Miniwarehouses) (531120) Residential Remodelers (236118) Lessors of Other Real Estate Property (531190) view top 100 |
| NAICS_Sub_Code | naics_sub_code | text | NAICS Subcode | 531110 531390 531120 531311 531190 view top 100 |
| Office_Jurisdiction_Address | office_jurisdiction_address | text | Office Jurisdiction Address | 251 LITTLE FALLS DRIVE, WILMINGTON, DE, 19808, United States 251 Little Falls Dr, Wilmington, DE, 19808-1674, United States 1209 ORANGE STREET, WILMINGTON, DE, 19801, United States NONE 251 LITTLE FALLS DR, WILMINGTON, DE, 19808, United States view top 100 |
| Office_Jurisdiction_BusinessStreet | office_jurisdiction_2 | text | Office Jurisdiction Street | 251 LITTLE FALLS DRIVE 1209 ORANGE STREET 251 Little Falls Dr NONE 251 LITTLE FALLS DR view top 100 |
| Office_Jurisdiction_BusinessUnit | office_jurisdiction_3 | text | Office Jurisdiction Unit | Suite 201 Suite 100 STE 21-2 201 Suite 200 view top 100 |
| Office_Jurisdiction_BusinessCity | office_jurisdiction | text | Office Jurisdiction City | WILMINGTON Wilmington DOVER GREENWICH NEW YORK view top 100 |
| Office_Jurisdiction_BusinessState | office_jurisdiction_1 | text | Office Jurisdiction State | DE CT NY MA NJ view top 100 |
| Office_Jurisdiction_BusinessZipCode | office_jurisdiction_4 | text | Office Jurisdiction Zip Code | 19808 19801 19904 06830 19901 view top 100 |
| Office_in_Jurisdiction_Country | office_in_jurisdiction_country | text | Office Jurisdiction Country | United States Canada Cayman Islands United Kingdom Germany view top 100 |
| Reason_for_Administrative_Dissolution | reason_for_administrative | text | If the entity was administratively dissolved/forfeited, the reason for administrative dissolution | Failure to file Annual Report Failure to file First Report Failure to appoint or maintain an agent for service Failure to File First Report Failure to file Annual Reports view top 100 |
| Record_Address | record_address | text | Records Address | 31 WEST 34TH STREET, SUITE 1012, NEW YORK, NY, 10001, USA 150 AIRPORT ROAD, STE 960, LAKEWOOD, NJ, 08701, UNITED STATES 330 E. CROWN POINT ROAD, WINTER GARDEN, FL, 34787, UNITED STATES C/O GENERATIVE INVESTMENT PARTNERS FUND GP LLC, 80 FIELD POINT ROAD, GREENWICH, CT, 06830, USA 208 HARBOR DRIVE, SUITE 204, STAMFORD, CT, 06902, USA view top 100 |
| Records_Address_Street | records_address_street | text | Records Address Street | 591 WEST PUTNAM AVENUE 31 WEST 34TH STREET 80 SAINT MARKS AVENUE, APT. 3A 150 AIRPORT ROAD, STE 960 TWO GREENWICH PLAZA, FIRST FLOOR view top 100 |
| Records_Address_Unit | records_address_unit | text | Records Address Unit | SUITE 1012 SUITE 300 BUILDING 1S, 2ND FLOOR 537 STEAMBOAT RD 2ND FLR C/O AQR CAPITAL MANAGEMENT II, LLC, TWO GREENWICH PLAZA view top 100 |
| Records_Address_City | records_address_city | text | Records Address City | GREENWICH STAMFORD NEW YORK NEW CANAAN BROOKLYN view top 100 |
| Records_Address_State | records_address_state | text | Records Address State | CT NY TX CA FL view top 100 |
| Records_Address_Zip_Code | records_address_zip_code | text | Records Address Zip Code | 06830 06901 06902 06840 06831 view top 100 |
| Records_Address_Country | records_address_country | text | Records Address Country | UNITED STATES USA US United States CANADA view top 100 |
| Total_Authorized_Shares | total_authorized_shares | number | Total Authorized Shares | 5000 0 1000 20000 100 view top 100 |
| CREATE_DT | create_dt | text | Date this data set was last refreshed | 2024-09-07 00:12:01.2800000 2024-09-07 00:15:54.1866667 2024-09-07 00:13:38.3233333 2024-09-07 00:24:05.1500000 2024-09-07 00:23:55.9333333 view top 100 |
| Geo_Location | geo_location | point | {"coordinates":[-73.647199,41.017568],"type":"Point"} {"coordinates":[-75.54744,39.74842],"type":"Point"} {"coordinates":[-75.547515,39.748389],"type":"Point"} {"coordinates":[-72.67728,41.76732],"type":"Point"} {"coordinates":[-73.64718,41.01759],"type":"Point"} view top 100 |