SEC EDGAR Filing Search Sandbox

Search across all 18 million EDGAR filings from 1993 to the present, and over 100 million filing exhibits from more than 800,000 EDGAR filers. Explore the SEC filing search capabilities of the Query API with various search queries, such as finding the latest 10-K filings, finding filings by company ticker, or searching historical filings by date range. Click on the example queries listed in the sidebar to view and test different search expressions.

All searches can be executed by clicking the "Search Filings" button, with the Query API returning up-to-date filing metadata that matches the search criteria. The search queries can also be edited and customized in the search query editor below.

Search Query Editor

List all 10-K and 10-K/A filings that include exhibit 21 (list of subsidiaries). Exhibit 21 file information lives in the documentFormatFiles array of a filing and comes with a wide range of different description property versions, such as List of Subsidiaries, EXHIBIT 21, EX-21.1 or EX-21.01. The description property is in same cases even empty. In order to find all filings, we instead use the type property. While this property is filed in different variations as well, we at least don't encounter empty versions of it and always find the exhibit number to be included. Using the search expression type:*21* covers all variations, for example EX-21, 21 and EX.21.01.

Request

Search Parameters in JSON (editable)

1{
2    "query": "formType:\"10-K\" AND documentFormatFiles.type:*21*",
3    "from": "0",
4    "size": "20",
5    "sort": [{ "filedAt": { "order": "desc" } }]
6}

{
    "query": "formType:\"10-K\" AND documentFormatFiles.type:*21*",
    "from": "0",
    "size": "20",
    "sort": [{ "filedAt": { "order": "desc" } }]
}