« Missing Reasoning Engine will Eventually Reveal True Value of XBRL | Main | Guest Post on The Insight Forum »

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):

This is interesting information. What do you think?

Posted on Tuesday, June 18, 2013 at 09:48AM by Registered CommenterCharlie | 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):
All HTML will be escaped. Hyperlinks will be created for URLs automatically.