Home Forums The XBRL API How to get list of Subsidiaries for a company in a filing

Viewing 4 reply threads
  • Author
    Posts
    • #186199
      Ajit Vasudevan
      Participant

      Hello

      I am trying to obtain the list of Subsidiaries for a company from its 10K filing.
      For example, Apples 2019 10K filing is at

      https://www.sec.gov/Archives/edgar/data/320193/000032019319000119/a10-k20199282019.htm

      And from there, you can navigate to the “Subsidiaries of the Registrant” – which is Exhibit 21.1

      https://www.sec.gov/Archives/edgar/data/320193/000032019319000119/a10-kexhibit2112019.htm

      Any help on what the API query would be to get this info would be great!

      Thanks
      Aj

    • #186226
      David Tauriello
      Keymaster

      Hi Ajit – we’re finalizing a /document endpoint with text search capability for XBRL US Members that will allow you to get details like this, which are outside of the XBRL facts for the filing.

      Once its ready, we’ll be holding a web meeting to cover the basics of search – wildcard options, etc. – as well as show some other tools for data access.

    • #186293
      Ajit Vasudevan
      Participant

      Thanks David. Do you have an ETA on when this API would be ready?

    • #186352
      David Tauriello
      Keymaster

      Ajit – it’s in production now – see the document endpoint here for documentation: https://xbrlus.github.io/xbrl-api and note that we’re making some modifications to the query parameters.

    • #196967
      David Tauriello
      Keymaster

      Hi Ajit – you’ll need two queries to return a list that confirms the text string exists and provides a URL to the HTML in EDGAR. As this content is in the unstructured part of the filing and not tagged, there’s no way for our database to show only the specific detail for the search query.

      The first query returns our database’s internal dts.id values for filings that should be searched, and the second query searches for the specified string in the document (excluding XBRL-tagged information) and returns an excerpt and URL for it.

      Here’s a Jupyter notebook as an example – https://mybinder.org/v2/gh/xbrlus/xbrl-api-ipynb/python?filepath=xbrl_us_api_doctext.ipynb – it may take a few minutes for the environment to get spun up, but after that, scroll to the bottom and you should see several examples for dts.id values selected from the initial query against Apple’s SIC code.

      If you enter your credentials and follow the instructions, you should be able to get other results. At a minimum, you can copy out the queries and modify them elsewhere as needed.

      Post back here and let us know how it works out for you.

      Sincerely,
      David

Viewing 4 reply threads
  • You must be logged in to reply to this topic.

Comment

Upcoming XBRL US Events

Center for Data Quality Committee Meeting
Wednesday, June 29, 2022

Domain Steering Committee Meeting
Tuesday, July 19, 2022

Communications & Services Steering Committee Meeting
Tuesday, July 19, 2022

Dive into Debt Securities – Illustrations of the FASB Implementation Guide
Wednesday, July 20, 2022

Public Review: Annual Comprehensive Financial Report Taxonomy
Monday, August 15, 2022