Current Status
| New incorporations expected | weekly | Current status | green |
|---|---|---|---|
| Company updates expected | monthly | Current status | green |
Summary
| Data last updated | November 18 2024 |
|---|---|
| Region | Americas > North America |
| Name | World > Americas > North America |
| ISO Jurisdiction Code | us_ca |
| Sources |
Attributes
- Insights
- Core Attributes
- Extended Attributes
| # Companies | 8,490,630 | Number of registered companies per jurisdiction |
|---|---|---|
| # Officers | 27,626,260 | Number of officers per jurisdiction |
| Registered Address Count | 8,179,289 | Number of registered address per jurisdiction |
| Registered Address Fill Rate | 96.33% | Number of registered address per jurisdiction as a percentage of total companies |
| Name | 100.00% | Full Legal Name |
|---|---|---|
| Company Number | 100.00% | Officer company registration number |
| Company Type | 100.00% | Type of entity (as described by the company register) |
| Status | 100.00% | Current status (as described by the company register) |
| Alternative Names | 0.40% | Alternative name (such as trading name, abbreviation, or legal name in another language) |
| Incorporation Date | 100.00% | Date the company was officially registered |
| Industry Codes | 0.00% | Industrial classifications, including code scheme and code number, for example NACE or NAICS codes. |
| Company known to be a branch | 10.51% | A flag that specifically identifies foreign branches (local registration of a company incorporated in a different jurisdiction) or not |
| Accounts Statement | 0.00% | |
|---|---|---|
| Acquisition Relationship | 0.00% | |
| Address Delegate | 0.24% | |
| Agents (Total) | 9,304,903 | |
| Alternate Registration | 0.00% | |
| Alternative Name | 0.40% | |
| Approved Government Supplier | 0.31% | |
| Branch Relationship | 12.12% | |
| Control Statement | 0.00% | |
| Current Status | 100.00% | |
| Filing Delegate | 0.00% | |
| Financial Payment | 0.00% | |
| Financial Transaction | 0.00% | |
| Gazette Notice | 0.00% | |
| Home Company | 9.31% | |
| Identifier Delegate Inactive | 0.15% | |
| Is NonProfit | 7.32% | |
| Is Ultimate Controlling Company | 0.06% | |
| Licence | 0.05% | |
| Merger | 0.00% | |
| Number Of Employees | 0.00% | |
| Official Journal Notice | 0.00% | |
| Official Register Entry | 0.01% | |
| Previous Names | 0.40% | |
| Public Statement | 0.00% | |
| Register Entry | 0.01% | |
| Share Parcel | 0.00% | |
| Subsequent Registration | 0.00% | |
| Subsidiary Relationship | 0.11% | |
| Supplier Relationship | 0.00% | |
| Tax Number | 0.00% | |
| Telephone Number | 0.12% | |
| Total Shares | 0.00% | |
| Trademark Registration | 1.59% | |
| UK Gazette Notice | 0.00% | |
| UK Health Safety Notice | 0.00% | |
| Ultimate Beneficial Owners | 0.00% | |
| Ultimate Controlling Company | 0.12% | |
| Website | 0.14% |
[Issue Resolved] California Update:
For the past year, the California Secretary of State has been providing erroneous data updates for existing companies (note this does not affect new incorporations). We have been in constant communication with the Secretary of State and while they have assured us multiple times that they are working to fix it, they have not yet been able to. As it stands, we cannot ingest this data without wittingly accepting corrupt data. Note this problem will affect every organisation that gets data from the California Secretary of State, not just OpenCorporates.
Below we outline the problems we have identified with the file:
1. Delimiter/value mixup. “|” is used as the delimiter to separate different columns in the CSV file, but it can also appear in values (e.g. a company having the name WLC | THE WILLIAMS LAW CORPORATION). When processing the file, “|” is recognised as a column separator so a single value gets split into two columns.
2. Missing column. The filings.csv file should contain 20 columns but many rows are missing the second-to-last column (LLC_MANAGEMENT_STRUCTURE). Combined with the first problem, this can make it unclear whether a record has an issue, as the record can lose a “|” delimiter from the missing column, but gain one where it is included in a value.
3. Missing pipe separator. Sometimes there is no “|” appearing as a separator between one column and the next, so we would see both values as belonging to one column.
4. Missing quotes. The first value in a record might start with ” but not end with “, so it looks as though the entire row belongs to the first column until it sees another ” later on another line.
5. Linebreaks. Some records in the file have just a few columns, seemingly caused by a random linebreak in the previous record, so some of its values end up on the next line.
OpenCorporates temporary solution for the issues outlined above:
We have decided to preprocess the data file by stripping out the most problematic rows and fixing those that we can, leaving us with only those records that we have confidence in. This accounts for approximately 80% of all records in the files that we have received.
This preprocessing of CSV files will give us new CSV files which will have transformed rows in case of the following problems that we face in the CSV file due to “|”.
We are continuing to press the California register to fix the underlying problems and have offered our help in doing so. In the meantime, we will work internally to improve the fixes. OpenCorporates customers can contact their Customer Success Manager or [email protected] for more details on how we are fixing issues in the file.
We updated 6.6m companies which is just over 80% of the 8.2m available from the registry. This 6.6m included 430k companies that we added to our data for the first time, which also helped to significantly fill the gaps of missing companies. However, there could still be up to 300k companies missing from our dataset (we have 7.9m vs the registry’s 8.2m) which are contained in the 20% of data we were not able to process.
Date Published: 08/01/2024