Connecticut Business Registry - Business Filing History
This is the business filing table from the Connecticut Business Registry, maintained by the Secretary of the State, Business Services Division. It contains all of the business filings filed on the registry.
This data may be linked to the Connecticut Business Registry - Business Master data using the unique key value in the first column.
On the first day of the month the entire dataset will be replace and the "Create Date" column will reflect this, e.g. "2021 Sep 1", "2021 Oct 1". The dataset will be updated daily, the "Create Date" will reflect when the new record was created.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on
this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \
-H "Content-Type: application/json" \
-d@-<<EOF
{"sql": "
SELECT *
FROM \"ct-gov/connecticut-business-registry-business-filing-ah3s-bes7\".\"connecticut_business_registry_business_filing\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.