Returns Number Of Companies Reporting For A Data Item Annually

The following sample SQL query counts the number of companies that report to a particular dataitem from 1989 to 2019 annually (PeriodTypeId=1)

Enhancement Date: 5/29/2020

  • SourceMarket Intelligence
  • Data Packages Required
    Finl Latest DetailFinl Latest MarketFinl Latest RatioFinl Latest StatementFinl Latest Supplemental
  • Associated Datasets
    S&P Capital IQ Financials

Query Types

  • MSSQL
  • PostGreSQL
  • Snowflake