SEC Data Set on Google

Tuesday, July 21, 2020 at 10:22AM
Charlie in Digital Financial Reporting

The SEC Public Dataset is now avaiable via Google BigQuery.

But, there is a problem. How do you think Google is going to magically be able to overcome issues related to different companies using different reporting styles, companies use different concepts to report the same information, errors in the reporting information that I point out via my quality checks. XBRLogic points out similar errors.

Garbage in, garbage out.

Here is a basic query. Here is an introduction to BigQuery. Here is a video introduction.

Here is other information about Google BigQuery: 

• Documentation
• SEC Public Data Set Tables
  • calculation
  • dimension
  • quick_summary
  • presentation
  • submission
  • rendering
  • measure_tag
  • txt
  • numbers
  • sic_codes
• Sample Queries

 

Article originally appeared on XBRL-based structured digital financial reporting (http://xbrl.squarespace.com/).