Company Subsidiaries Database API

The Subsidiary API provides access to a database of all current and historical subsidiaries belonging to publicly listed companies on US stock exchanges, from 2003 to present. The dataset, compiled from Exhibit 21 attached to SEC filings such as 10-K, 10-Q, S-1, or 20-F, is cleaned and converted to a JSON format, and provides the subsidiary names and jurisdictions along with associated metadata of the parent company.

Tesla's Subsidiaries - API Response Example


          1
          {
        

          2
            "subsidiaries": [
        

          3
              {
        

          4
                "name": "Alabama Service LLC",
        

          5
                "jurisdiction": "Delaware"
        

          6
              }
        

          7
              {
        

          8
                "name": "Alset Warehouse GmbH",
        

          9
                "jurisdiction": "Germany"
        

          10
              },
        

          11
              {
        

          12
                "name": "BT Connolly Storage, LLC",
        

          13
                "jurisdiction": "Texas"
        

          14
              },
        

          15
              // ... more subsidiaries
        

          16
            ],
        

          17
            "ticker": "TSLA",
        

          18
            "cik": "1318605",
        

          19
            "companyName": "Tesla, Inc.",
        

          20
            "accessionNo": "0000950170-23-001409",
        

          21
            "filedAt": "2023-01-30T21:29:15-05:00",
        

          22
          }

Searching the Subsidiary Database

The Subsidiary API serves data in JSON format, incorporating subsidiary names and jurisdictions along with associated metadata. This metadata includes the date/time of the parent company's subsidiary disclosure, the accession number of the primary filing that the Exhibit 21 subsidiary list is attached to, as well as the CIK, ticker, and company name of the parent company.

The subsidiary database is searchable by various criteria, such as ticker, CIK, or the name of the parent company, subsidiary name, subsidiary jurisdiction, or a specific date range. Newly disclosed subsidiaries are added to the database in real-time as soon as new EDGAR filings with Exhibit 21 are published.

The subsidiary database maintains all historically reported subsidiaries of their parent companies, dating back to 2003. For instance, querying the database using ticker "MSFT" would return all subsidiaries Microsoft reported since 2003. This provision allows you to conduct a thorough analysis of historical subsidiary data changes.

Converting Exhibit 21 Files to JSON

The Subsidiary API also enables the extraction of subsidiary information from a specific Exhibit 21 file and provides the data in JSON format. To do this, simply send a POST request with the filing's accession number, for example, accessionNo:"0000950170-23-001409". The API will then return a JSON-formatted list of the subsidiaries disclosed in the exhibit. The accession number can be obtained from the URL of the exhibit or the corresponding EDGAR filing.

Data Quantity & Accuracy

Approximately 7,000 new lists of subsidiaries are reported every year, and the entire dataset encompasses over 100,000 lists of subsidiaries, dating back to 2003. While we utilize state-of-the-art machine learning algorithms to extract and standardize the data, inaccuracies may occur due to the non-standardized nature of the Exhibit 21 files. However, the error rate is minimal, affecting less than 0.1% (or 1 in 900) of the extracted lists of subsidiaries.

Dataset size:

100,000+ lists of subsidiaries; all subsidiaries reported in Exhibit 21 since 2003.

Data update frequency:

Newly disclosed subsidiaries are added to the database in real-time as soon as new EDGAR filings with Exhibit 21 are published.

Survivorship bias free:

Yes. The database includes subsidiary information from all companies since 2003, including those that have gone out of business, merged, been acquired, went private, or delisted and stopped filing with the SEC for any other reason.

API Endpoint

To search and retrieve current and historical subsidiaries of publicly listed companies, send an HTTP POST request with the search query as a JSON payload to the following API endpoint:

https://api.sec-api.io/subsidiaries

Supported HTTP methods: POST

Request and response content type: JSON

Authentication

To authenticate your API requests, use the API key available in your user profile. You can utilize your API key in one of two ways. Choose the method that best fits your implementation:

Authorization Header: Include your API key as an Authorization header in your POST requests. For instance, before sending a POST request to https://api.sec-api.io/subsidiaries, ensure the header is set as follows: Authorization: YOUR_API_KEY.
Query Parameter: Alternatively, append your API key directly to the URL as a query parameter. For example, when making POST requests, use the URL https://api.sec-api.io/subsidiaries?token=YOUR_API_KEY instead of the base endpoint.

Request Parameters

The Subsidiary API is designed to provide structured data in response to POST requests made with a JSON payload. This section describes the structure of the requests to the Subsidiary API and the specific parameters you should include in your request.

The JSON payload you send in your POST request contains your search query, which should include the following parameters:

Request parameters:

query (string) - Your search query. Boolean operators (AND, OR, NOT), range queries, wildcards (*) and nested conditions are fully supported. The query is written in Lucene syntax. More information on Lucene is available here. Example queries:
"ticker:MSFT" returns a list of all subsidiaries of Microsoft disclosed since 2003.
"subsidiaries.jurisdiction:China OR subsidiaries.jurisdiction:PRC" lists all subsidiaries of Chinese companies disclosed since 2003.
"cik:(37996 1318605)" returns all subsidiaries of Ford (CIK 37996) and Tesla (CIK 1318605).
from (integer) - The start position of your search in the result universe. from is similar to an index of an array. Increase from in order to paginate through the results. For example, set from to 50 to get the next 50 matches. Default: 0.
size (integer) - The number of lists of subsidiaries to be returned in one response. Default: 50. Max: 50.
sort (array) - An array of sort definitions. Each array item defines the sort order of the result.
Default:[{ "filedAt": { "order": "desc" } }]

Request Examples

Below are examples of JSON payloads demonstrating the structure of your POST request:

Find all subsidiaries of Tesla (ticker: TSLA) reported in Exhibit 21 since 2003.