PermID

Overview

PermIDs are unique and persistent machine-readable identifiers for active and inactive securities across global asset classes. LSEG (formerly Refinitiv) manages PermIDs as a way to standardize mapping across various data sources. PermIDs cover organizations, instruments, and quotes.

  • Coverage: >12K companies

  • Asset classes: ordinary shares, depository receipts

Key Attributes

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

The PERMID_SECURITY_INDEX table provides details on each security with a PermID, including the security's name, its primary ticker, asset class, primary exchange, and security status (e.g. Active, Inactive), as well as related global tickers. PermID data can be merged to 13-Fs in the SEC_HOLDING_FILING_ATTRIBUTES table.

Refinitiv PermIDs are also included in the COMPANY_INDEX table which aggregates commonly used Company identifiers (CIKs, EINs, LEIs) into a single COMPANY_ID, the COMPANY_CHARACTERISTICS table, and the COMPANY_SECURITY_RELATIONSHIPS table which maps openFIGI and PermID securities to the Company.

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details

Cybersyn Products

Tables above are available in the following Cybersyn data products:

  • SEC Filings

  • LLM Training Essentials

  • Consumer Spending Foundation

Examples & Sample Queries

Aggregate company identifiers and metadata about companies

Search for commonly-used corporate identifiers such as CIK and EIN as well as stock-specific identifiers like ticker symbol and OpenFIGI ID.

SELECT
    idx.company_id,
    idx.company_name,
    idx.cik,
    idx.ein,
    idx.lei,
    openfigi.openfigi_share_class_id,
    openfigi.primary_ticker,
    idx.permid_company_id
FROM cybersyn.company_index AS idx
JOIN cybersyn.company_characteristics AS char
    ON (idx.company_id = char.company_id)
JOIN cybersyn.company_security_relationships AS rship
    ON (idx.company_id = rship.company_id)
JOIN cybersyn.openfigi_security_index AS openfigi
    ON ARRAY_CONTAINS(rship.security_id::VARIANT, openfigi.openfigi_share_class_id)
WHERE char.relationship_type = 'sic_description'
  AND char.value = 'Air transportation, scheduled';

Disclaimers

The data in this product is sourced from PermID.org, see license.

Cybersyn is not endorsed by or affiliated with any of these providers. Contact support@cybersyn.com for questions.

Last updated

Copyright © 2024 Cybersyn