SEC XBRL Financial Filing Information Repository Prototype (SQL Based)

This is a prototype of pieces of what a web service might look like for retrieving information from SEC XBRL 10-K and 10-Q filings. Information in this database is a mashup of information from: (1) the SEC EDGAR system, (2) XBRL Cloud, (3) StockSmart, and (4) additional metadata added to these three other systems. This prototype uses a set of 291 SEC XBRL 10-K financial filings (i.e. NOT the complete set of SEC filing entities and not the complete set of submissions). One submission exsists for each filer currently. SEC XBRL filing information is processed, some of the information is put into a database, metadata is collected and organized, etc. Other information is collected from the other sources. The underlying database is MS SQL Server. Users of the web service would perform fairly basic post-processing to use the information, no XBRL is required. Most likely, a local database might be used to store information which is used. Workflow processing keeps the web service and the local database syncronized as needed. A prototype local front-end was created using Microsoft Access. If you would like additional information about this web service, wish to make use of this web service, contribute metadata from this web service, embed this web service within your software application, please contact CharlesHoffman @ olywa.net.
For more information please see the Digital Financial Reporting wiki which explains the semantics used by the logical model of this web service. Or, follow my blog.
# Item Description XML Examples (Computer readable) HTML Examples (Human readable)
1. Entity Provide a CIK, get entity information for entity with that CIK 0000034088 (Exxon) (XML) | 0001141391 (Master Card) (XML) | 0000796343 (Adobe) (XML) | 0000012927 (Boeing) (XML) | 0000034088 (Exxon) (HTML) | 0001141391 (Master Card) (HTML) | 0000796343 (Adobe) (HTML) | 0000012927 (Boeing) (HTML) |
2. Entity Get list of all entities List of all entities (XML) | List of all entities (HTML)
3. Entities Provide an industry/sector, get list of all entities with are in that industry/sector Business Services | Transportation Equipment | Eating/Drinking Establishments | Food/Kindred Products | Industrial/Commercial Machinery/Computer Equipment None
4. Entities Provide a subindustry ID, get a list of all entities which are in that subindustry 72 (Software & Services) | 36 (Biomedics) | 38 (Medical Products) | 21 (Auto Parts) None
5. Entities List of entities in a group (such as DOW30, NORTHWEST STOCKS, or some other specific list) DOW30 (XML) | CHARLIE24 (XML) | DOW30 (HTML) | Charlie24 (HTML) |
6. Industry List of industry sectors List of industry sectors (XML) List of industry sectors (HTML)
7. Industry List of SIC (standard industry classification) List of SIC codes (XML) | List of SIC codes (HTML)
8. Industry List of subindustries List of subindustry codes (XML) | List of subindustry codes (HTML)
9. Disclosure objects List of disclosure object names used to categorize submission components List of disclosure objects (XML) List of disclosure objects (HTML)
10. Submission Submission information for one CIK Submissions for CIK 0000884624 (XML) | Submissions for CIK 0000810136 (XML) None
11. Submissions Submission information for all submissions Get all submissions (all CIKs, all submissions) (XML) None
12. Submission Specify submission and disclosure object name, return information for that component For accession number "0001193125-12-074109", component "document information" (XML) | For accession number "0001193125-12-072292", component "balance sheet" (XML) | For accession number "0001266432-12-000010", component "income statement" (XML) None
13. Submission Specify a submission, get all the components for that submission Get model structure for accession number: 0001193125-12-074109 (XML) | Get model structure for accession number: 0001193125-12-089437 (XML) | Get model structure for accession number: 0001193125-12-080318 (XML) | Get model structure for accession number: 0001193125-12-074109 (HTML) | Get model structure for accession number: 0001193125-12-089437 (HTML) | Get model structure for accession number: 0001193125-12-080318 (HTML) |
14. Submission Specify submission and network of component of that submission, return the model structure of that submission component In submission 0001193125-12-074109, get network http://www.3dsystems.com/role/StatementConsolidatedBalanceSheetsParenthetical (XML) | In submission 0001193125-12-089395, get network http://www.aligntech.com/taxonomy/role/DisclosureSegmentInformation (XML) | In submission 0001193125-12-067710, get network http://ancestry.com/role/CashAndCashEquivalents (XML) None
15. Submission Specify submission accession number, return key information for that submission 0001193125-12-074109 (XML) | 0001193125-12-088589 (XML) | 0001193125-12-056253 (XML) | 0001526508-12-000005 (XML) |*|

All Submissions (XML)

0001193125-12-074109 (HTML) | 0001193125-12-088589 (HTML) | 0001193125-12-056253 (HTML) | 0001526508-12-000005 (HTML) |*|

All Submissions (HTML)

16. Submission Specify industry/sector, return key information that industry/sector None Chemicals/Allied Products (HTML) | Business Services (HTML) | Transportation Equipment (HTML) | Eating/Drinking Establishments (HTML) | Food/Kindred Products (HTML) |*|

All Submissions (HTML)

17. Submission Specify a submission accession number, return the networks within that submission 0001193125-12-074109 (XML) | 0001193125-12-088589 (XML) | 0001193125-12-056253 (XML) | 0001526508-12-000005 (XML) | 0001193125-12-074109 (HTML) | 0001193125-12-088589 (HTML) | 0001193125-12-056253 (HTML) | 0001526508-12-000005 (HTML) |
18. Component Specify a component, return the network which contains that component for each SEC filer Balance Sheet (XML) | Document Information (XML) | Line of credit facility (XML) | Leases Of Lessee Disclosure (XML) | Cash flow statement (XML) | Balance Sheet (HTML) | Document Information (HTML) | Line of credit facility (HTML) | Leases Of Lessee Disclosure (HTML) | Cash flow statement (HTML) |
19. Compare Compare model structure of two submissions None Compare across TWO submissions (HTML)
20. Compare Compare model structure across multiple submissions (limited set of disclosure objects) None Compare across MULTIPLE submissions (HTML)
21. Compare Compare model structure across multiple submissions (all available disclosure objects) None Compare across MULTIPLE submissions (version 2) (HTML) | Balance sheet (HTML) | Document Information (HTML) |
22. Compare Compare model structure across multiple submissions, filter by industry None Compare across Industries (HTML)
23. Compare Compare network identifier and label across submissions for a disclosure object None List of networks across filings (Balance sheet) (HTML) | List of networks across filings (line of credit facility) (HTML) | List of networks across filings (income statement) (HTML) |
24. Dashboard Dashboard of automated verification results of core financial report semantics None Verification results for all generators, all auditors (HTML) | Verification results for all generators, and where PWC is the auditor (HTML) | Verification results were the generator is WebFilings (HTML) |
25. Metadata Major categories used to organize topics Major categories of disclosure topics (RDF/OWL) | Major categories of disclosure topics (HTML) |
26. Metadata Topics used to organize disclosure objects Topics of disclosure objects (RDF/OWL) | Topics of disclosure objects (HTML) |
27. Metadata Index of financial disclosure objects Index of financial disclosure objects (RDF/OWL) | Index of financial disclosure objects (HTML) |
28. Templates Index of disclosure templates Index of disclosure templates (RDF/OWL) | Index of disclosure templates which can be used to create submissions (HTML) |
xx. Submissions Get last submission for all filing entities Coming soon! Coming soon!
xx. Submission Get last 10-K submission for all filing entities Coming soon! Coming soon!
xx. Component Fact table for a specifc component of a submission Coming soon! Coming soon!
xx. Component Rendering for a specific component of a submission Coming soon! Coming soon!
xx. Compare Compare last five years of 10-Ks for a filing Coming soon! Coming soon!

Creative Commons License
This work is licensed under a Creative Commons License.