Table: finance_us_sec_filer - Query Finance US SEC Filers using SQL

US SEC Filers are entities that are required to file statements, reports, and other forms with the U.S. Securities and Exchange Commission (SEC). These filings provide a comprehensive overview of a company's performance, financial health, and operations. The data from these filings is public and can be used for various analytical purposes.

Table Usage Guide

The finance_us_sec_filer table provides insights into US SEC Filers within the Finance service. As a financial analyst or data scientist, explore filer-specific details through this table, including their CIK, name, address, and associated metadata. Utilize it to uncover information about filers, such as their location, to aid in your financial analysis and decision-making processes.

Important Notes

You must specify the symbol in the where clause to query this table.

Examples

Get filer details for Apple

Explore comprehensive information about a specific company listed on the U.S. Securities and Exchange Commission (SEC) by its stock symbol. This is particularly useful for financial analysis or investment decision-making.

select
  *
from
  finance_us_sec_filer
where
  symbol = 'AAPL';

select
  *
from
  finance_us_sec_filer
where
  symbol = 'AAPL';

Schema for finance_us_sec_filer

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
cik	text		CIK (Central Index Key) of the filer.
name	text		Name of the filer.
sic	text		SIC (Standard Industrial Classification) of the filer.
sic_description	text		Description of the SIC (Standard Industrial Classification) of the filer.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
symbol	text	=	Symbol for the filer.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- finance

You can pass the configuration to the command with the --config argument:

steampipe_export_finance --config '<your_config>' finance_us_sec_filer