Returns Limited Partnerships

This query searches for LP as the last 2 letters in the CONM (Company Name) data item from the company data group. Note: Uncomment the second query to find Limited Partnerships by searching for LP in the DSCI (Security Description) data item from the security data group

Enhancement Date: 7/1/2020

  • SourceMarket Intelligence
  • Data Packages Required
    CoreCore 2
  • Associated Datasets
    Compustat® 財務情報

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake