Baselight

Connecticut Business Registry - Business Filing History

State of Connecticut

@usgov.state_of_connecticut_connecticut_business_registry_bus_ad97a339

Table 1
@usgov.state_of_connecticut_connecticut_business_registry_bus_ad97a339.table_1

  • 242 MB
  • 9334607 rows
  • 18 columns
business_id

Business Id

filing_number

Filing Number

filing_date

Filing Date

effective_date

Effective Date

filing_category

Filing Category

filing_type

Filing Type

report_year

Report Year

organizer_name

Organizer Name

organizer_title

Organizer Title

organizer_type

Organizer Type

name_of_incorporator

Name Of Incorporator

volume

Volume

volume_type

Volume Type

pages

Pages

start_page

Start Page

date_forfeited

Date Forfeited

physical_filing

Physical Filing

created_date

Created Date

001t000000hjMXoAAM000581240104/05/2017 12:00:00 AMAnnual ReportAnnual Report20172332B290204/01/2025 12:00:00 AM
001t000000WnX11AAF000657092606/07/2019 12:00:00 AMAnnual ReportAnnual Report2019216A284804/01/2025 12:00:00 AM
001t000000WoSz6AAF000666391910/18/2019 12:00:00 AM10/18/2019 12:00:00 AMBusiness FormationCertificate of Organization47E359904/01/2025 12:00:00 AM
001t000000WnMnwAAF000387712701/29/2009 12:00:00 AMAnnual ReportAnnual Report20091257B293904/01/2025 12:00:00 AM
001t000000WnPGDAA3BF-001299154901/23/2025 12:00:00 AMAnnual ReportAnnual Report04/01/2025 12:00:00 AM
001t000000XfuRTAAZ0000670376Annual ReportAnnual Report1979true04/01/2025 12:00:00 AM
001t000000WmYdhAAF000541106510/13/2015 12:00:00 AMAnnual ReportAnnual Report20122109B295704/01/2025 12:00:00 AM
001t000000WnBngAAFBF-000894248912/22/2022 12:00:00 AMAnnual ReportAnnual Report201704/01/2025 12:00:00 AM
001t000000XgA2CAAV000041031008/13/1987 12:00:00 AMBusiness FormationCertificate of Incorporation10950C1818true04/01/2025 12:00:00 AM
001t000000XgQm2AAF000096546505/23/1989 12:00:00 AMBusiness FormationCertificate of Incorporation11400C2995true04/01/2025 12:00:00 AM

CREATE TABLE table_1 (
  "business_id" VARCHAR,
  "filing_number" VARCHAR,
  "filing_date" VARCHAR,
  "effective_date" VARCHAR,
  "filing_category" VARCHAR,
  "filing_type" VARCHAR,
  "report_year" DOUBLE,
  "organizer_name" VARCHAR,
  "organizer_title" VARCHAR,
  "organizer_type" VARCHAR,
  "name_of_incorporator" VARCHAR,
  "volume" DOUBLE,
  "volume_type" VARCHAR,
  "pages" DOUBLE,
  "start_page" DOUBLE,
  "date_forfeited" VARCHAR,
  "physical_filing" BOOLEAN,
  "created_date" VARCHAR
);

Share link

Anyone who has the link will be able to view this.