Tagged: concept.id number
Thursday, February 21, 2019 at 8:20 PM #124720
To shorten the code, rather than using concept.local-name, I started to use concept.id to call for fact.values. However, I started to realize that the numbers of concept.id change depending on the CIK and the fiscal year–even though the concept.local-names are exactly the same.
Can you please describe what drives this difference so that I can better construct the code?
Here are some examples of different concept.ids that have the same concept.local-name:
entity.cik period.fiscal-year concept.local-name concept.id
0001109879 2011 IncreaseDecreaseInInventories 9049
0000090168 2011 IncreaseDecreaseInInventories 68486
0000027093 2011 IncreaseDecreaseInInventories 6249201
0000812074 2012 IncreaseDecreaseInInventories 10288733
0000110621 2014 IncreaseDecreaseInInventories 15795815
0001122976 2013 IncreaseDecreaseInInventories 12743567
0001421182 2015 IncreaseDecreaseInInventories 10288733
0000811596 2016 IncreaseDecreaseInInventories 18601247
0001524741 2017 IncreaseDecreaseInInventories 21660607
0000004281 2018 IncreaseDecreaseInInventories 21660607
Saturday, March 2, 2019 at 12:09 PM #126287
Each company submits its own ‘extension taxonomy’ to the SEC – it’s essentially a cut-down version of only the US GAAP elements needed, plus any extension elements the company creates because it cannot find an existing element that adequately covers the fact(s) being reported by the extension elements.
So, while the
concept.local-namevalues in your list above are identical, the
concept.idvalues will differ, because our database assigns
concept.idvalues based on the facts as they appear in the company’s instance, not as they may relate to the US GAAP taxonomy.
If you use
concept.is-base(set as =true in the query or returned as true/false in fields) you can quickly distinguish whether the concept.id is a US GAAP element.
You must be logged in to reply to this topic.
Getting started with the XBRL Google Sheet and add-on 23 hours, 48 minutes ago
Extracting Data From A Particular Financial Statement 1 day, 5 hours ago
entity.ticker does not return any value 3 days, 4 hours ago
Getting started with the XBRL Google Sheet and add-on 3 days, 21 hours ago
entity.ticker does not return any value 1 week ago
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
XBRL API Resources
- The XBRL API
- XBRL Data Community
- XBRL API Documentation (PDF)
- Getting Started with Google API Access
- Sample Queries (Insomina REST client) - requires account provision