98% of [Table]s in SEC XBRL Financial Filings Have 4 or Less [Axis]
I did an analysis of [Table]s and the use of [Axis] on those [Table]s for the 7,160 SEC XBRL financial filings (All 10-K filings) which I have been looking at. Here are some stats (You can get the raw data here in Excel):
- 12% of [Table]s are filer extensions! Of the 156,494 explicit [Table]s used in the set of 7,160 SEC XBRL financial filings, 17,531 or 12% were filer extension. Of the total, 75,785 was the table "us-gaap:StatementTable", 49% of all explicit [Table]s used.
- Maximum number of [Axis] is 24: Another surprise was one reporting entity had a whopping 24 [Axis] on a [Table]. What was even more surprising is that the [Table] related to their significant accounting policies which I would have never expected. You can see the [Table] with 24 [Axis] here. (Shown in XBRL Cloud Viewer)
- 95% of [Table]s have 5 or less [Axis]: Of all the [Table]s in the 7,160 SEC XBRL financial filings, 95% of them have 5 or less [Axis]. This does NOT include the [Table]s with ZERO [Axis].
- [Table] with no [Axis] appears 6,112 times: There are 6,112 [Table]s represented which have no [Axis] at all which makes zero sense. For example, see this balance sheet which has a [Table], but no [Axis] (Shown in XBRL Cloud Viewer)
- 98% of [Table]s have 4 or less [Axis]: If I include the 6,112 filings which have [Table]s with no [Axis], then 98% of all SEC XBRL financial filings have 4 or fewer [Axis].
This is a chart of [Axis] usage (number of [Axis] on the horizontal and number of [Table]s on the vertical; so for example 100000 tables make use of 1 axis, 28000 make use of 2 axis):
Reader Comments