Query Library
Search a comprehensive library of pre-built queries designed to help you quickly maximize the value of our data offerings. For each query, the library provides a brief description along with the data packages necessary to execute the query.
Company Intelligence, Industry Sector Cross Reference Service (ISCRS)
Returns Peer Companies with Topic Tag Name of AI
Company Intelligence, Industry Sector Cross Reference Service (ISCRS)
Returns Companies With Artificial Intelligence Topic Tag
Company Intelligence, Industry Sector Cross Reference Service (ISCRS)
Returns Topic Tags For IBM
Company Intelligence, Industry Sector Cross Reference Service (ISCRS)
Returns Competitors for IBM With AI as Topic Tag
Company Relationships
Returns All The Details From Platform
Company Relationships
Returns In Between Records When Subsidiarycompany Is The Ultimateparentcompany
Company Relationships
Returns Parent And Ultimate Parent Company
Company Relationships
Returns Availability Of Data From All Countries Or Regions
OTC Derivatives Data
Returns CapletFloorlet Relative Strike with SABR parameters
OTC Derivatives Data
Returns Swaption Absolute Strike with SABR parameters
OTC Derivatives Data
Returns CapletFloorlet Absolute Strike with SABR parameters
OTC Derivatives Data
Returns Yield Curve MKT data
OTC Derivatives Data
Returns Inflation LPI Data
OTC Derivatives Data
Returns CapFloor Absolute Strike
OTC Derivatives Data
Returns Inflation LPI Swap Data
OTC Derivatives Data
Returns Basis Swap Curve data
OTC Derivatives Data
Returns Discount Curve Data
OTC Derivatives Data
Returns CapletFloorlet Relative Strike
OTC Derivatives Data
Returns Yield Curve data
OTC Derivatives Data
Returns Inflation Seasonality Data
OTC Derivatives Data
Returns Inflation Swap Curve Data
OTC Derivatives Data
Returns Swaption Relative Strike
OTC Derivatives Data
Returns Inflation Forward Curve Data
OTC Derivatives Data
Returns XCCY Basis Swap Curve data
OTC Derivatives Data
Returns CapletFloorlet Absolute Strike
OTC Derivatives Data
Returns Swaption Absolute Strike
OTC Derivatives Data
Returns Swaption Relative Strike with SABR parameters
OTC Derivatives Data
Returns XCCY Swap Curve data
Visible Alpha Estimates
Link Security Identifiers To Visible Alpha Estimates
Panjiva Supply Chain Intelligence
Returns New Customers And HSCodes Imported By A Company
Business Relationships Analytics
Returns The Supplier Concentration Risk
Business Relationships Analytics
Returns Geographical Distribution Of S&P500 Companies Sorted By Value
Business Relationships Analytics
Returns The Most Valuable Customer Supplier Relationships
Business Relationships Analytics
Returns Revenue And Cost Segmentation By Industry
Business Relationships Analytics
Returns High MarketCap Companies With Very Less Suppliers With High Relationships Value
Business Relationships Analytics
Returns Sector And Industry Trends
Trucost Paris Alignment
Returns Emissions Data for BYD Company Limited
Trucost Paris Alignment
Returns Carbon Budget Summary for BYD Company Limited
CDS Pricing
Returns Credit Index Options Pricing Data
Global Events
Returns Past And Future Earnings Events For Companies
Company Connections: Detailed Estimates
Returns All Records From Factors Connections
Company Connections: Detailed Estimates
Returns TradingItem Data For Specific Factors Of Factors Connections
Municipal Bond Pricing
Returns Latest Instrument Details And Market Liquidity Scores
Municipal Bond Pricing
Returns Time-Series Analysis Of Instrument Liquidity Scores
Municipal Bond Pricing
Returns All Bonds With Issuer Information And Count
Municipal Bond Pricing
Returns Latest Market Metrics And Instrument Analysis For ISINs
Municipal Bond Pricing
Returns Comprehensive Price Data For ISINs
Base Data, Visible Alpha Estimates
Converting Visible Alpha Estimates Using SP Foreign Exchange Rates On A Specific Date
Visible Alpha Estimates
Analyze Consensus Time Series
Visible Alpha Estimates
Measuring Financial Health Via Debt To Equity Ratio
Visible Alpha Estimates
Quarterly Earnings Trend For A Specific Company
Base Data
Returns ISIN, CUSIP, BRD and Markit Ticker History For Input List Of Companies
Market Data, Visible Alpha Estimates
Connecting Visible Alpha Estimates To CIQ Market Data To Get Daily Pricing And Market Capitalization
Visible Alpha Estimates
Returns SD Balance Sheet Template
S&P Capital IQ Estimates, Visible Alpha Estimates
Blending Visible Alpha Estimates With CIQ Estimates For Industry Leaders In Pharmaceuticals
Visible Alpha Estimates
Earnings Surprise For Every KPI For Every Company Within A Business Group
Visible Alpha Estimates
Use VaCompanyId To Find Company Specific Line Items
Visible Alpha Estimates
Revision History Of Estimates For A KPI
Visible Alpha Estimates
Discover Company Specific Parameters
Visible Alpha Estimates
Retrieve Latest Reported Revenue
Visible Alpha Estimates
Identify Business Groups For A Company
Visible Alpha Estimates
Identify Companies With Financial Data
Visible Alpha Estimates
Recreate Insights Application Views
Visible Alpha Estimates
Access Latest Ticker Data
Visible Alpha Estimates
Access Core Financial Templates
Visible Alpha Estimates
Identify Companies With Consensus Data
Visible Alpha Estimates
Explore Industry And Business Groups For Companies
Visible Alpha Estimates
Retrieve Quarterly Actuals For A Company
Visible Alpha Estimates
Discover KPIs For A Business Group
Base Data, Visible Alpha Estimates
Linking The Visible Alpha Esimates Vacompanyid To The SP Capital IQ CompanyID
Visible Alpha Estimates
Latest Revenue Growth Rate Calculation
Visible Alpha Estimates
Track Revenue Estimate Changes
Visible Alpha Estimates
Calculate EPS Surprise
Visible Alpha Estimates
Explore Standard Financial Templates
Credit Analytics
Retrieves Sovereign 1-100 Score In The Riskgauge 3.0 Model Using Different Restatementtypeids.
RatingsXpress®: Structured Finance Performance
Returns S&P Generated Metrics For Summary Issuance By Specific Instrument Symbols
RatingsXpress®: Structured Finance Performance
Returns Trustee Reported Tests With Performance Data
S&P Capital IQ Financials
Retrieves Annual Financial Data for Specified Companies While Handling Conflicts Across Multiple FiscalChainSeriesIDs
Visible Alpha Estimates
Access Latest Consensus For Various Periods
Visible Alpha Estimates
Find Latest Estimated Revenue
Visible Alpha Estimates
Rank Key Performance Indicators
Visible Alpha Estimates
Calculate Revenue Weight By Segment
RatingsXpress®: S&P Credit Ratings
Returns CLO Profile And Monitoring Metrics Data For Specific Instrument Symbol
RatingsXpress®: Structured Finance Performance
Returns CLO Performance Distribution Metrics Data
Visible Alpha Estimates
Locate Business Model Templates
Visible Alpha Estimates
Identify All Companies In A Business Group
Credit Analytics
Retrieves Different Absolute Contribution Ratios Under RiskGauge 3.0 Model
RatingsXpress®: Structured Finance Performance
Returns Liabilities Summary And Credit Enhancement Data
RatingsXpress®: Structured Finance Performance
Returns CLO Profile And Deal/Collateral Performance Data
Visible Alpha Estimates
Identify Business Group And Industry For Tickers
Credit Analytics
Retrieves RiskGauge 3.0 Country Benchmark Using Pdtype As IQ_RG3_SOV_1YR_PD
Visible Alpha Estimates
Track IPhone Sales Over Time
Visible Alpha Estimates
Find Companies In A Business Group
Credit Analytics
Retrieves Sovereign 1 Year PD In The Riskgauge 3.0 Model
Credit Analytics
Retrieves Sovereign 1-100 score In The Riskgauge 3.0 Model
Commodities Energy Pricing
Returns Spark Spreads At Various Heat Rates And Implied Heat Rate For Gas Spark On A Specific Date
Bond to Equity Factors
Returns Bond To Equity Ratios Records For Specific Date And UniverseID
Bond to Equity Factors
Returns Bond Equity Ratios Analysis
S&P Capital IQ Estimates
Returns a Series of Current EPS Values For the 2024 Fiscal Year
Bond to Equity Factors
Returns Bond To Equity Factors For Specific Trading ItemID
S&P Capital IQ Estimates
Returns the Current Year Revenue Estimate For a Company
S&P Capital IQ Estimates
Returns all NTM mean EPS data as it existed at a particular point in time
S&P Capital IQ Estimates
Identifying Consensus Estimates Excluding Stock-Based Compensation and or Amortization of Intangibles Using Footnote
SNL Insurance Regulatory Data
Returns Solvency II Datapoints For Input European Countries
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Module
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Pivot Module
S&P Capital IQ Financials
Returns Financial Data for a Specific dataItem Across Multiple Companies in an Industry
S&P Capital IQ Financials
Returns Financial Reporting Data By Company and Financial Statement Type
S&P Capital IQ Estimates
Returns 10 Year Average TEV/EBITDA Estimates For Reported Forward One Period For A Company
Ownership
Returns Ownership Detailed For Selected Ticker With Categorized Owner Types
SNL Insurance Regulatory Data
Returns Direct Written Premiums By Line Of Business For A Particular Company Across The US In 2024
SNL Insurance Regulatory Data
Returns Comprehensive Overview Of Direct Written Premiums By Line Of Business Across The US In 2024
Physical Risk
Returns Physical Risk Company Headquarters And Asset Exposure Score Data Compared To County, State, And Subnational Exposures For A Given Forecast Year And Scenario
Physical Risk
Returns Company Level Physical Risk Data For A Given Forecast Year And Scenario
Ownership
Returns Ownership Summary For Selected Tickers Over Last Five Periods With Categorized Owner Types
S&P Capital IQ Financials
As Reported Transparency
SNL RateWatch Depository Rates
Standard Interest Rates
SNL RateWatch Depository Rates
Competitive Interest Rates
SNL RateWatch Depository Rates
Bank Product Rates
SNL RateWatch Depository Rates
Rates During A Specific Timeframe
SNL RateWatch Depository Rates
Parent Operating Bank
SNL RateWatch Depository Rates
NY Branches
SNL RateWatch Depository Rates
Average Bank Product Rate
SNL RateWatch Depository Rates
Branches And Location
Panjiva Supply Chain Intelligence
Leverages Snowflake Dynamic Scripting To Provide Import Statistics For Specified Companies,Ensuring Consistent Column Handling, Efficient Aggregation And Filtering By Region, Date, And Company,For All Panjiva Import Tables
S&P Capital IQ Estimates
Returns Estimate EPS Consensus Mean And P/E Ratio
OTC Derivatives Data
Returns Equity VarSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity Index Bid Ask Volatility And Forward Curve Data
OTC Derivatives Data
Returns Equity VolSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity Stock ETF Bid Ask Volatility And Forward Curve Data
Headcount Analytics
Headcount By Top 10 Next Employers
Headcount Analytics
Role And Department Tenure For A Company
Headcount Analytics
Top And Bottom 10 Companies In A Metro Area Based On 12 Months Growth Rate
Headcount Analytics
Returns Monthly Headcount Changes For A Company
Headcount Analytics
Monthly Headcount Data With Transactions Rounds Of Funding Information For A Company
Headcount Analytics
Headcount By Top 10 Previous Employers
Headcount Analytics
Returns Top And Bottom Metro Growth Areas For An Industry
Base Data
Returns 365 Days Average Fxrate Historical Data
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date For MI Keys
CDS Pricing
Return Credit Default Swaps Pricing Data For Single Names
CDS Pricing
Returns Credit Default Swap Pricing Data For Credit Tranches
CDS Pricing
Returns Credit Default Swaps Data For Credit Indices
S&P Capital IQ Financials
Returns Unconsolidated Financial EVIC Data Available As Per The LTM Holding Dates
Index Data
Returns Levels Of Index Hierarchy Using Index Key For A BMI Index
Private Company Financials
Returns Private Company Financials EVIC Data As Per The Observation Date
Market Data
Returns Carryforward Market Pricing Data For The Specified Date Range
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Bond Ratings With Filtered Out Muni Ratings
RatingsXpress®: S&P Credit Ratings
Returns Financials Metrics And Issuer Ratings With Filtered Out Muni Ratings
OTC Derivatives Data
Returns Equity Stock ETF Volatility Forward Curve And Dividend Yield Data
OTC Derivatives Data
Returns Equity Index Volatility Forward Curve And Dividend Yield Data
Trucost ESG Financial and Market Data
Returns Point In Time EVIC Data Available As Per The Observation Date
S&P Capital IQ Financials
Returns Point In Time EVIC Data Available As Per The Observation Date
S&P Capital IQ Financials
Returns Latest EVIC Data Available As Per The Observation Date
Key Developments
Query Maps Keydevs Events With CIQEstimates And CIQFinancials
Trucost Environmental
Returns Top 10 Private Companies In United Kingdom With Highest Scope 3 Downstream Emissions In 2019
Trucost Environmental
Returns Air Pollutants Direct Cost For Chinese Private Companies Involved In Bituminous Coal And Lignite Surface Mining
Trucost Environmental, Trucost Environmental: Private Companies
Returns Latest Available Data For Greenhouse Gas(GHG) Scope Of An InstitutionId
Trucost Environmental
Returns Private Companies With Over 75 Percent Revenue In Crude Petroleum And Natural Gas Extraction Sector
Trucost Environmental
Returns The Latest Data On Absolute Carbon Emissions For Greenhouse Gas(GHG) Scope 1 By InstitutionIDs
Trucost Environmental
Returns Intensity Metrics For Jaguar Land Rover Automotive Plc
CreditPro®
Returns The Instrument Level Details
Machine Readable Transcripts
Returns Fiscal Years And Fiscal Quarters For All Latest Transcripts
Market Data, S&P Capital IQ Estimates, S&P Capital IQ Financials
Returns Financial Multiples And Forward Estimates Data
Base Data
Returns Year On Year Average Exchange Rate For All Countries
S&P Capital IQ Estimates
Returns TEV/NTM EBITDA Values For Time Series
Market Data, S&P Capital IQ Financials
Returns TEV And EBITDA Ratios For Selected Companies As Of An Observation Date
Compustat® Financials
Returns Consolidated Financial Data For Company As Of Observation Date
S&P Capital IQ Financials
Returns Premium Financials, Market Capitalization, And Market Prices For The Trading Items Pivot
S&P Capital IQ Estimates
Returns Time Series Forward Estimate EBITDA For A Ticker
Business Entity Cross Reference Service (BECRS)
Returns Risk Score Analysis Data For DUNS And GICS Identifiers
Physical Risk: Country, Subnational & Municipal
Returns Physical Risk GDP Exposed Metric For All US Geographies
Market Data
Returns Analysis Of Unadjusted Outstanding Shares For Stock Splits
Index Data
Returns S&P500, R2000 And FALLWORLD Index Constituents And Market Data By Sector As Of A Specified Date
Key Developments
Returns Key Developments In Venture Vapital (VC) And Private Equity (PE) Firms
S&P Capital IQ Financials
Returns Latest LTM Total Revenue Value Along With Annual Values
Base Data, Market Data, S&P Capital IQ Financials
Returns Currency Adjusted Financial Metrics For Trading Item ID
Company Connections: Detailed Estimates
Returns Company Connections For Compustat Gvkey And Iid
S&P Capital IQ Estimates
Returns Forward Estimates With Currency Conversion
S&P Capital IQ Estimates
Returns Estimates For Reported Forward Five Periods
SNL Insurance Regulatory Data
Returns Paid Loss Ratios By Accident Year Loss Triangle