« Understanding that XBRL-based Digital Financial Reports are made up of Distinct Identifiable Pieces | Main | Zeroing in on the Holy Grail of Global Standard Financial Reporting »

SECXBRL.info Sample Queries

Here are a bunch of sample queries which work on SECXBRL.info.  These will work until May 31, 2015.  Queries are for noncommercial use.  Results are returned in HTML, but if you want results returned in XML, simply change format=html to format=xml.  You can change query parameters. Here is API documentation:

(NOTE that SECXBRL.info change the beginning of the URL to http://secxbrl.28.io/v1/ and the public token to c3049752-4d35-43da-82a2-f89f1b06f7a4  The queries need to be adjusted for those two changes.

  1. Get facts from the a specific network from a specific report: execute.
  2. Get facts from a specific component by specifying the disclosure name from a specific report: execute.
  3. Get fact from a specific CIK, a specific fiscal period, a specific fiscal year: execute.
  4. Get facts whose concept is revenues from all the entities which make up the DOW 30 for fiscal year 2014 and break those results out by geographic area: execute.
  5. Get facts whose concept is assets from a single entity with a specific CIK number for fiscal year 2012 and break that information down by business segment: execute.
  6. Get facts whose concept is assets from every entity in the DOW 30 for fiscal year 2014 and break that information out by business segment: execute.
  7. Get facts whose concept is goodwill from every entity in the FORTUNE 100 for all fiscal years available and break out that information by business segment: execute.
  8. Get facts whose concept is PropertyPlantAndEquipmentNet from every entity in the FORTUNE 100 for fiscal year 2014 and break the information out by property, plant and equipment type: execute.
  9. Get facts whose conept is assets for an entity with a specific CIK for Q1, Q2, and Q3 of fiscal year 2014 and break the information out by legal entity and business segment: execute.
  10. Get facts whose concept is assets for an entity with a specific CIK for all fiscal years and break the information out by reporting scenario: execute.
  11. Get facts whose concept is assets for the entities which make up the S&P 500 for all fiscal years and break them out by reporting scenario: execute.
  12. Get facts whose concept is us-gaap:ProvedUndevelopedReserveVolume from the entities which make up the S&P 500 for all fiscal years available and break that information out by type of reserve: execute.
  13. Get facts whose concept is us-gaap:Goodwill for the entity with the CIK 66740 for fiscal year 2012 and break that information out by business segment: execute.
  14. Get facts whose concept maps to the fundamental accounting concept fac:ResearchAndDevelopment for all the entities which make up the DOW 30 for fiscal year 2014: execute. (By looking at the XML format you can see the actual US GAAP XBRL Taxonomy concept which was used by each entity.)
  15. Get a specific fact but explicitly specify the legal entity dimension: execute.
  16. Get a specific fact but explicitly specify that all legal entities be returned: execute.
  17. Get facts whose concept is assets for a specific CIK for Q1, Q2, Q3, and FY 2014 and break the information out by business segment: execute.
  18. Get facts whose concept is assets for a specific CIK for Q1 fiscal year 2014 and break out by business sgement: execute.
  19. Get year-to-date Q1 2014 revenues for the S&P 500 broken out by business segment: execute.
  20. Get facts for text block nature of operations for the DOW 30 for 2014 trying numerous different concepts: execute.
  21. Get facts whose concept is assets for S&P 500 for 2014 and breakdown assets by business segment if the entity reports business segments: execute.
  22. Get facts using the ticker symbol: execute.
  23. Get facts for two concepts: execute.
  24. Get facts for revenues using mapping: execute. (this XML file lets you see what concept was used to report revenues)
  25. Get all the fundamental accounting concepts for Coca Cola: execute.
  26. Get all the funcamental accounting concepts for Coca Cola for two periods: execute.
  27. Get all the fundamental accounting concepts for the DOW 30 for 2014: execute.

 You can learn more about queries here by experimenting with the DOW 30.

Posted on Tuesday, April 28, 2015 at 10:26AM by Registered CommenterCharlie in | CommentsPost a Comment

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
All HTML will be escaped. Hyperlinks will be created for URLs automatically.