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!
|