Skip to main content

Data Dictionary

Company CharacteristicsView Source Documentation

PUBLIC_DATA.COMPANY_CHARACTERISTICS: Characteristics for nearly 100k companies, including EIN, CIK, LEI, address information, industry descriptions, and more, with start and end date ranges.

Company Characteristics Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_CHARACTERISTICS_PIT: Tracks history of the company_characteristics table with start and end timestamps to indicate row validity periods.

Company Domain RelationshipsView Source Documentation

PUBLIC_DATA.COMPANY_DOMAIN_RELATIONSHIPS: Map between companies and domains and websites that they own. In addition to the COMPANY_ID that Snowflake creates, which can be tied back to CIK, LEI, EIN, and company-level PermID information, the table includes the clean DOMAIN_ID which strips away any subdomain (e.g., www) and protocol (e.g., https) information.

PUBLIC_DATA.COMPANY_INDEX: Compiled list of public and private companies with a unique Snowflake company identifier (company_id) mapped to public identifiers like CIK, EIN, PermID, and LEI. This table serves as the spine for Cybersyn data that involves company-level identifiers.

Company Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_INDEX_PIT: Tracks history of the company_index table with start and end timestamps to indicate row validity periods.

Company RelationshipsView Source Documentation

PUBLIC_DATA.COMPANY_RELATIONSHIPS: Company subsidiary and parent relationships, joinable to Snowflake Public Data company_index table.

Company Relationships Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.COMPANY_RELATIONSHIPS_PIT: Tracks history of the company_relationships table with start and end timestamps to indicate row validity periods.

SEC 13F Attributes (Daily)View Source Documentation

PUBLIC_DATA.SEC_13F_ATTRIBUTES: Quarterly institutional investment manager holdings snapshot, including securities' names, market values, shares, and identifiers, providing insights into investment strategies and market movements, as filed in Form 13-F to the SEC.

SEC 13F Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_13F_INDEX: Quarterly snapshot of institutional investment manager holdings, including filing details, number of holdings, and total holding value for managers with $100M+ in equity assets, provided in Form 13-F to the SEC.

SEC Broker Dealer (BD) IndexView Source Documentation

PUBLIC_DATA.SEC_BROKER_DEALER_INDEX: Index of broker-dealer registration & amendment filings with the SEC.

SEC Broker Dealer (BD) Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_BROKER_DEALER_INDEX_PIT: Tracks history of the sec_broker_dealer_index table with start and end timestamps to indicate row validity periods.

SEC Central Index Key (CIK) IndexView Source Documentation

PUBLIC_DATA.SEC_CIK_INDEX: Map between company identifiers (including Snowflake Public Data COMPANY_ID) and the SEC Central Index Keys (CIKs), along with geographic and industry classification details for SEC filers.

SEC Central Index Key (CIK) Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_CIK_INDEX_PIT: Tracks history of the sec_cik_index table with start and end timestamps to indicate row validity periods.

SEC Corporate Report Metrics Attributes (Daily)View Source Documentation

PUBLIC_DATA.SEC_CORPORATE_REPORT_ATTRIBUTES: Company KPIs published in SEC filings using XBRL format, provided on a daily basis.

SEC Corporate Report Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_CORPORATE_REPORT_INDEX: Index of filings (ADSH) submitted to the SEC by entities (CIK).

SEC Corporate Report Parsed Item Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_CORPORATE_REPORT_ITEM_ATTRIBUTES: 10-Ks and 10-Qs (submitted to the SEC) parsed by document sections (i.e. SEC items) into plaintext, HTML, and hierarchical JSON structure for LLM training.

SEC Corporate Report Text & HTML Document Attributes (Daily)View Source Documentation

PUBLIC_DATA.SEC_CORPORATE_REPORT_TEXT_ATTRIBUTES: Raw text and/or HTML of SEC filings, provided on the document-level.

SEC Fiscal Calendar IndexView Source Documentation

PUBLIC_DATA.SEC_FISCAL_CALENDARS: Company fiscal calendars by quarter, including period start and end dates, identified by unique Central Index Key (CIK) numbers.

SEC Form 144 Securities Information Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_FORM144_SECURITIES_INFO_INDEX: Details on restricted or control securities (e.g., a company's stock) intended to be sold by company insiders or affiliates of a public company, as reported in Form 144 to the SEC.

SEC Form 144 Securities Sold Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_FORM144_SECURITIES_SOLD_INDEX: Sales of restricted or control securities by company insiders or affiliates in the past 3 months, providing a breakdown of Table II: Securities Sold during the past 3 Months on Form 144 per the SEC.

SEC Form 144 Securities To Be Sold Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_FORM144_SECURITIES_TO_BE_SOLD_INDEX: Intended sales of restricted or control securities by company insiders or affiliates, providing a breakdown of Table I: Securities to be Sold on Form 144 per the SEC.

SEC Form 4 Reporting Owner Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_FORM4_REPORTING_OWNERS_INDEX: Insider transactions in public company securities, as disclosed in SEC Form 4 filings. An insider is an officer, director, or beneficial owner holding more than 10% of a company's shares.

SEC Form 4 Securities Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_FORM4_SECURITIES_INDEX: Insider transactions of public company securities, including derivative and non-derivative acquisitions, disposals, and beneficial ownership, reported on Form 4 filings. An insider is an officer, director, or beneficial owner holding more than 10% of a company's shares.

SEC Holding Filing Attributes (Quarterly)View Source Documentation

PUBLIC_DATA.SEC_HOLDING_FILING_ATTRIBUTES: Disclosure of equity holdings by institutional investment managers with over $100 million in assets under management, provided in the Form 13-F on a quarterly basis by the SEC.

SEC Holding Filing Index (Quarterly)View Source Documentation

PUBLIC_DATA.SEC_HOLDING_FILING_INDEX: Report index for Form 13-F, a disclosure of equity holdings by institutional investment managers with over $100 million in assets under management, provided on a quarterly basis by the SEC.

SEC Insider Trader Report Owner Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_INSIDER_TRADING_REPORTING_OWNERS_INDEX: Reporting persons of insider transactions in a public company, as provided on insider trading filings (e.g., Forms 3, 4, 5) to the SEC.

SEC Insider Trader Security Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_INSIDER_TRADING_SECURITIES_INDEX: Insider transactions in public companies, including securities acquired, disposed of, or beneficially owned by officers, directors, and 10%+ shareholders, reported to the SEC in insider trading filings (e.g., Forms 3, 4, 5).

SEC Investment Advisers Attributes (Daily)View Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_ATTRIBUTES: Metadata dictionary for the questions and data points collected within Form ADV filings for investment advisers registered with the SEC or filing as Exempt Reporting Advisers.

SEC Investment Advisers Attributes (Daily) Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_ATTRIBUTES_PIT: Tracks history of the sec_investment_advisers_attributes table with start and end timestamps to indicate row validity periods.

SEC Investment Advisers Filed Notices Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_FILED_NOTICES_INDEX: Index of filed notices or registrations for specific investment advisers.

SEC Investment Advisers Filed Notices Index (Daily) Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_FILED_NOTICES_INDEX_PIT: Tracks history of the sec_investment_advisers_index table with start and end timestamps to indicate row validity periods.

SEC Investment Advisers Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_INDEX: Index of investment advisers who are registered with the SEC or who are filing reports as Exempt Reporting Advisers.

SEC Investment Advisers Index (Daily) Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_INDEX_PIT: Tracks history of the sec_investment_advisers_index table with start and end timestamps to indicate row validity periods.

SEC Investment Advisers Timeseries (Daily)View Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_TIMESERIES: Metadata dictionary for the questions and data points collected within Form ADV filings for investment advisers registered with the SEC or filing as Exempt Reporting Advisers.

SEC Investment Advisers Timeseries (Daily) Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_ADVISERS_TIMESERIES_PIT: Tracks history of the sec_investment_advisers_timeseries table with start and end timestamps to indicate row validity periods.

SEC Investment Company, Series, Class IndexView Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_COMPANY_INDEX: Index of all actively-registered investment company series and classes that have been issued IDS by the SEC.

SEC Investment Company, Series, Class Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_INVESTMENT_COMPANY_INDEX_PIT: Tracks history of the sec_investment_company_index table with start and end timestamps to indicate row validity periods.

SEC Metrics Timeseries (Daily)View Source Documentation

PUBLIC_DATA.SEC_METRICS_TIMESERIES: Quarterly and annual parsed revenue segments of major companies from 10-Qs and 10-Ks.

SEC NPORT Metrics Attributes (Daily)View Source Documentation

PUBLIC_DATA.SEC_NPORT_ATTRIBUTES: Monthly fund-level statistics covered within an NPORT filing to disclose the fund's financial status.

SEC NPORT Filing Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_NPORT_FILING_INDEX: Index of NPORT reports, a regulatory filing that registered investment companies must submit to the SEC, providing detailed information about their portfolio holdings on a monthly basis. NPORTs replaced the semi-annual N-Q filing in 2019.

SEC NPORT Investments Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_NPORT_INVESTMENTS_INDEX: A fund's portfolio-level metrics, including risk, liquidity classifications, and derivative exposures, as reported in Part C of an NPORT filing to the SEC.

SEC NPORT Part-C Investments Index (Daily)View Source Documentation

PUBLIC_DATA.SEC_NPORT_PARTC_INVESTMENTS_INDEX: A fund's portfolio-level metrics, including risk, liquidity classifications, and derivative exposures, as reported in Part C of an NPORT filing to the SEC.

SEC NPORT Metrics Timeseries (Daily)View Source Documentation

PUBLIC_DATA.SEC_NPORT_TIMESERIES: Monthly fund-level statistics covered within an NPORT filing to disclose the fund's financial status.

SEC Report Attributes (Monthly)View Source Documentation

PUBLIC_DATA.SEC_REPORT_ATTRIBUTES: Company KPIs published in SEC filings using XBRL format, provided on a monthly basis.

SEC Report Index (Monthly)View Source Documentation

PUBLIC_DATA.SEC_REPORT_INDEX: Index of filings (ADSH) submitted to the SEC by entities (CIK), provided on a monthly basis.

SEC Report Text Attributes (Monthly)View Source Documentation

PUBLIC_DATA.SEC_REPORT_TEXT_ATTRIBUTES: Provides full text of company filings (10-Ks, 10-Qs, 8-Ks) submitted to the SEC, with unique identifiers for each document.

SEC Registered Security-Based Swap Dealers and ParticipantsView Source Documentation

PUBLIC_DATA.SEC_SWAP_DEALER_INDEX: Index of registered security-based swap dealers and major security-based swap participants.

SEC Registered Security-Based Swap Dealers and Participants Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.SEC_SWAP_DEALER_INDEX_PIT: Tracks history of the sec_swap_dealer_index table with start and end timestamps to indicate row validity periods.

XBRL Taxonomy IndexView Source Documentation

PUBLIC_DATA.XBRL_TAXONOMY_INDEX: XBRL taxonomy table providing a structured overview of key financial concepts and their corresponding XBRL elements used in regulatory filings (e.g., SEC annual and quarterly filings).

XBRL Taxonomy Index Point-in-Time HistoryView Source Documentation

PUBLIC_DATA.XBRL_TAXONOMY_INDEX_PIT: Tracks history of the xbrl_taxonomy_index table with start and end timestamps to indicate row validity periods.