Baselight
Sign In

SEC EDGAR Filings

Filing metadata, XBRL financial facts, Form 13F holdings, and Forms 3/4/5 insider transactions

@sec.filings

Loading...
Loading...

About this Dataset

SEC EDGAR Filings

Structured data from the U.S. SEC EDGAR system. This dataset brings together:

  • Filing metadata (one row per submission)
  • XBRL financial facts extracted from 10-K/10-Q and related filings
  • Form 13F institutional holdings (manager submissions, cover/signature pages, summary stats, other managers, and the detailed information table)
  • Insider transactions (Forms 3/4/5) with submissions, reporting owners, non-derivative & derivative transactions/holdings, footnotes, and signatures

All timestamps are UTC. Use accession_number as the stable join key across tables; cik identifies the registrant/issuer (tickers may be missing for funds/trusts or older filings). Amendments are indicated by /A in the form (e.g., 10-K/A, 13F-HR/A, 4/A).

What’s inside

Filings

  • metadata — one row per filing with core submission fields (CIK, company, form, filing/report periods, acceptance time, file/film numbers, XBRL flags).

XBRL

  • financial_facts — one row per XBRL fact tied to a filing, including taxonomy, concept, human-readable label, unit, value, fiscal period, and optional XBRL frame (e.g., CY2011, CY2011Q3).

Form 13F (institutional holdings)

  • holdings_submission — filing header (type, dates, filer CIK/period).
  • holdings_coverpage — cover-page fields (report calendar/quarter, amendment/confidential treatment, manager address, report type, file numbers).
  • holdings_signature — signatory block (name, title, phone, location, signature date).
  • holdings_summarypage — aggregates (other managers count, table entries, total market value, confidentiality flag).
  • holdings_othermanager / holdings_othermanager2 — managers reporting for / included in the filing.
  • holdings_infotable — detailed security-level positions (issuer, class, CUSIP/FIGI, value, share/principal amounts, discretion, voting authority).
    Note: as of 2023-01-03, value is reported in dollars (previously in thousands).

Insider transactions (Forms 3/4/5)

  • insider_transactions_submission — filing header, issuer identifiers, and flags (e.g., 10b5-1).
  • insider_transactions_reportingowner — reporting owner identities and relationships to the issuer.
  • insider_transactions_nonderiv_trans / insider_transactions_nonderiv_holding — non-derivative (Table I) transactions and holdings.
  • insider_transactions_deriv_trans / insider_transactions_deriv_holding — derivative (Table II) transactions and holdings.
  • insider_transactions_footnotes — explanatory text referenced across tables.
  • insider_transactions_owner_signature — electronic signatures for attestation.

Tables

Financial Facts

@sec.filings.financial_facts
  • 570.38 MB
  • 118,079,122 rows
  • 15 columns
Loading... 
CREATE TABLE financial_facts (
  "accession_number" VARCHAR,
  "cik" VARCHAR,
  "company" VARCHAR,
  "taxonomy" VARCHAR,
  "concept" VARCHAR,
  "label" VARCHAR,
  "unit" VARCHAR,
  "value" VARCHAR,
  "period_start" VARCHAR,
  "period_end" VARCHAR,
  "fiscal_year" VARCHAR,
  "fiscal_period" VARCHAR,
  "form" VARCHAR,
  "filed" VARCHAR,
  "frame" VARCHAR
);

Holdings: Cover Page

@sec.filings.holdings_coverpage
  • 7.15 MB
  • 364,278 rows
  • 21 columns
Loading... 
CREATE TABLE holdings_coverpage (
  "accession_number" VARCHAR,
  "report_calendar_or_quarter" VARCHAR,
  "is_amendment" VARCHAR,
  "amendment_no" VARCHAR,
  "amendment_type" VARCHAR,
  "conf_denied_expired" VARCHAR,
  "date_denied_expired" VARCHAR,
  "date_reported" VARCHAR,
  "reason_for_non_confidentiality" VARCHAR,
  "filing_manager_name" VARCHAR,
  "filing_manager_street1" VARCHAR,
  "filing_manager_street2" VARCHAR,
  "filing_manager_city" VARCHAR,
  "filing_manager_state_or_country" VARCHAR,
  "filing_manager_zipcode" VARCHAR,
  "report_type" VARCHAR,
  "form13f_file_number" VARCHAR,
  "crd_number" VARCHAR,
  "sec_file_number" VARCHAR,
  "provide_info_for_instruction5" VARCHAR,
  "additional_information" VARCHAR
);

Holdings: Detailed Holdings By Security

@sec.filings.holdings_infotable
  • 1.89 GB
  • 109,619,009 rows
  • 15 columns
Loading... 
CREATE TABLE holdings_infotable (
  "accession_number" VARCHAR,
  "infotable_sk" VARCHAR,
  "name_of_issuer" VARCHAR,
  "title_of_class" VARCHAR,
  "cusip" VARCHAR,
  "figi" VARCHAR,
  "value_usd_thousands" VARCHAR,
  "shares" VARCHAR,
  "shares_type" VARCHAR,
  "put_call" VARCHAR,
  "investment_discretion" VARCHAR,
  "other_manager_id" VARCHAR,
  "voting_auth_sole" VARCHAR,
  "voting_auth_shared" VARCHAR,
  "voting_auth_none" VARCHAR
);

Holdings: Other Managers Reporting For This Manager

@sec.filings.holdings_othermanager
  • 1.66 MB
  • 188,343 rows
  • 7 columns
Loading... 
CREATE TABLE holdings_othermanager (
  "accession_number" VARCHAR,
  "other_manager_id" VARCHAR,
  "other_manager_cik" VARCHAR,
  "form13f_file_number" VARCHAR,
  "crd_number" VARCHAR,
  "sec_file_number" VARCHAR,
  "other_manager_name" VARCHAR
);

Holdings: Other Managers Included In The Report

@sec.filings.holdings_othermanager2
  • 1.18 MB
  • 147,285 rows
  • 7 columns
Loading... 
CREATE TABLE holdings_othermanager2 (
  "accession_number" VARCHAR,
  "other_manager_id" VARCHAR,
  "other_manager_cik" VARCHAR,
  "form13f_file_number" VARCHAR,
  "crd_number" VARCHAR,
  "sec_file_number" VARCHAR,
  "other_manager_name" VARCHAR
);

Holdings: Signatory Information & Attestation

@sec.filings.holdings_signature
  • 6.45 MB
  • 364,278 rows
  • 8 columns
Loading... 
CREATE TABLE holdings_signature (
  "accession_number" VARCHAR,
  "name" VARCHAR,
  "title" VARCHAR,
  "phone" VARCHAR,
  "signature" VARCHAR,
  "city" VARCHAR,
  "state_or_country" VARCHAR,
  "signature_date" VARCHAR
);

Holdings: Filing Submissions

@sec.filings.holdings_submission
  • 2.6 MB
  • 364,278 rows
  • 5 columns
Loading... 
CREATE TABLE holdings_submission (
  "accession_number" VARCHAR,
  "filing_date" VARCHAR,
  "submission_type" VARCHAR,
  "cik" VARCHAR,
  "period_of_report" VARCHAR
);

Holdings: Summary Stats

@sec.filings.holdings_summarypage
  • 2.95 MB
  • 288,053 rows
  • 5 columns
Loading... 
CREATE TABLE holdings_summarypage (
  "accession_number" VARCHAR,
  "other_included_managers_count" VARCHAR,
  "table_entry_total" VARCHAR,
  "table_value_total" VARCHAR,
  "is_confidential_omitted" VARCHAR
);

Insider Transactions: Derivative Security Holdings

@sec.filings.insider_transactions_deriv_holding
  • 22.68 MB
  • 1,701,154 rows
  • 26 columns
Loading... 
CREATE TABLE insider_transactions_deriv_holding (
  "accession_number" VARCHAR,
  "deriv_holding_sk" VARCHAR,
  "security_title" VARCHAR,
  "security_title_fn" VARCHAR,
  "conversion_or_exercise_price" VARCHAR,
  "conversion_or_exercise_price_fn" VARCHAR,
  "transaction_form_type" VARCHAR,
  "transaction_form_type_fn" VARCHAR,
  "exercise_date" VARCHAR,
  "exercise_date_fn" VARCHAR,
  "expiration_date" VARCHAR,
  "expiration_date_fn" VARCHAR,
  "underlying_security_title" VARCHAR,
  "underlying_security_title_fn" VARCHAR,
  "underlying_security_shares" VARCHAR,
  "underlying_security_shares_fn" VARCHAR,
  "underlying_security_value" VARCHAR,
  "underlying_security_value_fn" VARCHAR,
  "shares_owned_following_transaction" VARCHAR,
  "shares_owned_following_transaction_fn" VARCHAR,
  "value_owned_following_transaction" VARCHAR,
  "value_owned_following_transaction_fn" VARCHAR,
  "direct_indirect_ownership" VARCHAR,
  "direct_indirect_ownership_fn" VARCHAR,
  "nature_of_ownership" VARCHAR,
  "nature_of_ownership_fn" VARCHAR
);

Insider Transactions: Derivative Security Transactions

@sec.filings.insider_transactions_deriv_trans
  • 56.06 MB
  • 2,630,559 rows
  • 42 columns
Loading... 
CREATE TABLE insider_transactions_deriv_trans (
  "accession_number" VARCHAR,
  "deriv_trans_sk" VARCHAR,
  "security_title" VARCHAR,
  "security_title_fn" VARCHAR,
  "conversion_or_exercise_price" VARCHAR,
  "conversion_or_exercise_price_fn" VARCHAR,
  "transaction_date" VARCHAR,
  "transaction_date_fn" VARCHAR,
  "deemed_execution_date" VARCHAR,
  "deemed_execution_date_fn" VARCHAR,
  "transaction_form_type" VARCHAR,
  "transaction_code" VARCHAR,
  "equity_swap_involved" VARCHAR,
  "equity_swap_trans_cd_fn" VARCHAR,
  "transaction_timeliness" VARCHAR,
  "transaction_timeliness_fn" VARCHAR,
  "transaction_shares" VARCHAR,
  "transaction_shares_fn" VARCHAR,
  "transaction_total_value" VARCHAR,
  "transaction_total_value_fn" VARCHAR,
  "transaction_price_per_share" VARCHAR,
  "transaction_price_per_share_fn" VARCHAR,
  "transaction_acquired_disposed_code" VARCHAR,
  "transaction_acquired_disposed_code_fn" VARCHAR,
  "exercise_date" VARCHAR,
  "exercise_date_fn" VARCHAR,
  "expiration_date" VARCHAR,
  "expiration_date_fn" VARCHAR,
  "underlying_security_title" VARCHAR,
  "underlying_security_title_fn" VARCHAR,
  "underlying_security_shares" VARCHAR,
  "underlying_security_shares_fn" VARCHAR,
  "underlying_security_value" VARCHAR,
  "underlying_security_value_fn" VARCHAR,
  "shares_owned_following_transaction" VARCHAR,
  "shares_owned_following_transaction_fn" VARCHAR,
  "value_owned_following_transaction" VARCHAR,
  "value_owned_following_transaction_fn" VARCHAR,
  "direct_indirect_ownership" VARCHAR,
  "direct_indirect_ownership_fn" VARCHAR,
  "nature_of_ownership" VARCHAR,
  "nature_of_ownership_fn" VARCHAR
);

Insider Transactions: Footnotes

@sec.filings.insider_transactions_footnotes
  • 232.72 MB
  • 8,928,080 rows
  • 3 columns
Loading... 
CREATE TABLE insider_transactions_footnotes (
  "accession_number" VARCHAR,
  "footnote_id" VARCHAR,
  "footnote_text" VARCHAR
);

Insider Transactions: Non-Derivative Security Holdings

@sec.filings.insider_transactions_nonderiv_holding
  • 25.81 MB
  • 2,299,436 rows
  • 14 columns
Loading... 
CREATE TABLE insider_transactions_nonderiv_holding (
  "accession_number" VARCHAR,
  "nonderiv_holding_sk" VARCHAR,
  "security_title" VARCHAR,
  "security_title_fn" VARCHAR,
  "transaction_form_type" VARCHAR,
  "transaction_form_type_fn" VARCHAR,
  "shares_owned_following_transaction" VARCHAR,
  "shares_owned_following_transaction_fn" VARCHAR,
  "value_owned_following_transaction" VARCHAR,
  "value_owned_following_transaction_fn" VARCHAR,
  "direct_indirect_ownership" VARCHAR,
  "direct_indirect_ownership_fn" VARCHAR,
  "nature_of_ownership" VARCHAR,
  "nature_of_ownership_fn" VARCHAR
);

Insider Transactions: Non-Derivative Security Transactions

@sec.filings.insider_transactions_nonderiv_trans
  • 106.68 MB
  • 6,996,970 rows
  • 28 columns
Loading... 
CREATE TABLE insider_transactions_nonderiv_trans (
  "accession_number" VARCHAR,
  "nonderiv_trans_sk" VARCHAR,
  "security_title" VARCHAR,
  "security_title_fn" VARCHAR,
  "transaction_date" VARCHAR,
  "transaction_date_fn" VARCHAR,
  "deemed_execution_date" VARCHAR,
  "deemed_execution_date_fn" VARCHAR,
  "transaction_form_type" VARCHAR,
  "transaction_code" VARCHAR,
  "equity_swap_involved" VARCHAR,
  "equity_swap_trans_cd_fn" VARCHAR,
  "transaction_timeliness" VARCHAR,
  "transaction_timeliness_fn" VARCHAR,
  "transaction_shares" VARCHAR,
  "transaction_shares_fn" VARCHAR,
  "transaction_price_per_share" VARCHAR,
  "transaction_price_per_share_fn" VARCHAR,
  "transaction_acquired_disposed_code" VARCHAR,
  "transaction_acquired_disposed_code_fn" VARCHAR,
  "shares_owned_following_transaction" VARCHAR,
  "shares_owned_following_transaction_fn" VARCHAR,
  "value_owned_following_transaction" VARCHAR,
  "value_owned_following_transaction_fn" VARCHAR,
  "direct_indirect_ownership" VARCHAR,
  "direct_indirect_ownership_fn" VARCHAR,
  "nature_of_ownership" VARCHAR,
  "nature_of_ownership_fn" VARCHAR
);

Insider Transactions: Electronic Signatures

@sec.filings.insider_transactions_owner_signature
  • 56.14 MB
  • 4,542,729 rows
  • 3 columns
Loading... 
CREATE TABLE insider_transactions_owner_signature (
  "accession_number" VARCHAR,
  "owner_signature_name" VARCHAR,
  "signature_date" VARCHAR
);

Insider Transactions: Reporting Owners & Relationships

@sec.filings.insider_transactions_reportingowner
  • 117.59 MB
  • 4,621,921 rows
  • 13 columns
Loading... 
CREATE TABLE insider_transactions_reportingowner (
  "accession_number" VARCHAR,
  "reporting_owner_cik" VARCHAR,
  "reporting_owner_name" VARCHAR,
  "reporting_owner_relationship" VARCHAR,
  "officer_title" VARCHAR,
  "other_text" VARCHAR,
  "reporting_owner_street1" VARCHAR,
  "reporting_owner_street2" VARCHAR,
  "reporting_owner_city" VARCHAR,
  "reporting_owner_state" VARCHAR,
  "reporting_owner_zipcode" VARCHAR,
  "reporting_owner_state_desc" VARCHAR,
  "file_number" VARCHAR
);

Insider Transactions: Filing Submissions

@sec.filings.insider_transactions_submission
  • 56.49 MB
  • 4,261,170 rows
  • 14 columns
Loading... 
CREATE TABLE insider_transactions_submission (
  "accession_number" VARCHAR,
  "filing_date" VARCHAR,
  "period_of_report" VARCHAR,
  "date_of_original_submission" VARCHAR,
  "no_securities_owned" VARCHAR,
  "not_subject_sec16" VARCHAR,
  "form3_holdings_reported" VARCHAR,
  "form4_transactions_reported" VARCHAR,
  "document_type" VARCHAR,
  "issuer_cik" VARCHAR,
  "issuer_name" VARCHAR,
  "issuer_trading_symbol" VARCHAR,
  "remarks" VARCHAR,
  "aff_10b5_one" VARCHAR
);

Filings Metadata

@sec.filings.metadata
  • 357.15 MB
  • 13,920,736 rows
  • 16 columns
Loading... 
CREATE TABLE metadata (
  "accession_number" VARCHAR,
  "cik" VARCHAR,
  "company" VARCHAR,
  "ticker" VARCHAR,
  "form" VARCHAR,
  "filing_date" VARCHAR,
  "report_date" VARCHAR,
  "acceptance_datetime" VARCHAR,
  "primary_document" VARCHAR,
  "file_number" VARCHAR,
  "film_number" VARCHAR,
  "act" VARCHAR,
  "items" VARCHAR,
  "size" VARCHAR,
  "is_xbrl" VARCHAR,
  "is_inline_xbrl" VARCHAR
);

Share link

Anyone who has the link will be able to view this.