New LLCs in New York, Colorado, Oregon and Connecticut every morning, with curl and jq

In recent times, an increasing number of Limited Liability Companies (LLCs) have been registered in four states: New York, Colorado, Oregon, and Connecticut. These LLCs are often without reviews, websites, or key personnel like accountants, insurers, banks, or agencies. This makes new filings a valuable source, as they help identify newly formed entities. Several states provide their business registers as open data, allowing for easy access and analysis.

To gather this information, a script was created using curl and jq to pull the last week's filings from these four states. The script then filters the data by industry and sets up a daily monitor on entities already worked with. The API used for this purpose is paid per record, but free open-data queries are available as well.

The raw data from each state is organized into a consistent format, with each entity row containing information such as the state, registration ID, name, entity type, status, formation date, address, NAICS code, and a link to the state's page for the entity. The script filters the data to focus on LLCs only and allows for additional filtering based on specific industries or criteria.

For customers or suppliers already known, a monitor mode can be used to check for any changes in the entities' status or other details. This daily watch returns rows only when there is a change, providing up-to-date information on the entities' status.

It's important to note that while four states (NY, CO, OR, and CT) publish their business registers as open data, most states do not. The status data varies per state, with only Colorado and Connecticut listing all available statuses. Additionally, the New York and Oregon datasets only list active entities, and a dissolved NY company may appear as "inactive" rather than "never existed." Lastly, the freshness of the data varies among the states, with New York and Oregon updating their datasets at different intervals.