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.
Business Entity Cross Reference Service (BECRS)
Returns CIQ Identifiers For Entities With An LEI In BECRS
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 Competitors for IBM With AI as Topic Tag
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 Relationships
Returns In Between Records When Subsidiarycompany Is The Ultimateparentcompany
Company Relationships
Returns Availability Of Data From All Countries Or Regions
Company Relationships
Returns All The Details From Platform
Company Relationships
Returns Parent And Ultimate Parent Company
OTC Derivatives Data
Returns Inflation Forward Curve Data
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 Inflation LPI Swap Data
OTC Derivatives Data
Returns CapletFloorlet Relative Strike with SABR parameters
OTC Derivatives Data
Returns XCCY Swap Curve data
OTC Derivatives Data
Returns Yield Curve data
OTC Derivatives Data
Returns CapletFloorlet Absolute Strike
OTC Derivatives Data
Returns Inflation Seasonality Data
OTC Derivatives Data
Returns Inflation Swap Curve Data
OTC Derivatives Data
Returns Swaption Relative Strike with SABR parameters
OTC Derivatives Data
Returns Basis Swap Curve data
OTC Derivatives Data
Returns Discount Curve Data
OTC Derivatives Data
Returns Swaption Absolute Strike
OTC Derivatives Data
Returns Swaption Relative Strike
OTC Derivatives Data
Returns Swaption Absolute Strike with SABR parameters
OTC Derivatives Data
Returns XCCY Basis Swap Curve data
OTC Derivatives Data
Returns CapFloor Absolute Strike
OTC Derivatives Data
Returns CapletFloorlet Relative Strike
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 Revenue And Cost Segmentation By Industry
Business Relationships Analytics
Returns Geographical Distribution Of S&P500 Companies Sorted By Value
Business Relationships Analytics
Returns Sector And Industry Trends
Business Relationships Analytics
Returns The Supplier Concentration Risk
Business Relationships Analytics
Returns High MarketCap Companies With Very Less Suppliers With High Relationships Value
Business Relationships Analytics
Returns The Most Valuable Customer Supplier Relationships
Trucost Paris Alignment
Returns Carbon Budget Summary for BYD Company Limited
Trucost Paris Alignment
Returns Emissions Data 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 TradingItem Data For Specific Factors Of Factors Connections
Company Connections: Detailed Estimates
Returns All Records From Factors Connections
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 Latest Instrument Details And Market Liquidity Scores
Municipal Bond Pricing
Returns Comprehensive Price Data For ISINs
Visible Alpha Estimates
Quarterly Earnings Trend For A Specific Company
Visible Alpha Estimates
Measuring Financial Health Via Debt To Equity Ratio
Visible Alpha Estimates
Use VaCompanyId To Find Company Specific Line Items
Visible Alpha Estimates
Earnings Surprise For Every KPI For Every Company Within A Business Group
Visible Alpha Estimates
Returns SD Balance Sheet Template
Base Data
Returns ISIN, CUSIP, BRD and Markit Ticker History For Input List Of Companies
Base Data, Visible Alpha Estimates
Converting Visible Alpha Estimates Using SP Foreign Exchange Rates On A Specific Date
S&P Capital IQ Estimates, Visible Alpha Estimates
Blending Visible Alpha Estimates With CIQ Estimates For Industry Leaders In Pharmaceuticals
Visible Alpha Estimates
Analyze Consensus Time Series
Market Data, Visible Alpha Estimates
Connecting Visible Alpha Estimates To CIQ Market Data To Get Daily Pricing And Market Capitalization
Visible Alpha Estimates
Latest Revenue Growth Rate Calculation
Visible Alpha Estimates
Revision History Of Estimates For A KPI
Visible Alpha Estimates
Discover Company Specific Parameters
Visible Alpha Estimates
Identify Business Groups For A Company
Visible Alpha Estimates
Explore Industry And Business Groups For Companies
Visible Alpha Estimates
Access Latest Ticker Data
Visible Alpha Estimates
Discover KPIs For A Business Group
Visible Alpha Estimates
Retrieve Latest Reported Revenue
Visible Alpha Estimates
Identify Companies With Consensus Data
Visible Alpha Estimates
Access Core Financial Templates
Base Data, Visible Alpha Estimates
Linking The Visible Alpha Esimates Vacompanyid To The SP Capital IQ CompanyID
Visible Alpha Estimates
Identify Companies With Financial Data
Visible Alpha Estimates
Recreate Insights Application Views
Visible Alpha Estimates
Retrieve Quarterly Actuals For A Company
Visible Alpha Estimates
Identify Business Group And Industry For Tickers
Visible Alpha Estimates
Track IPhone Sales Over Time
Visible Alpha Estimates
Find Latest Estimated Revenue
Visible Alpha Estimates
Rank Key Performance Indicators
Visible Alpha Estimates
Explore Standard Financial Templates
Visible Alpha Estimates
Identify All Companies In A Business Group
Credit Analytics
Retrieves Sovereign 1-100 Score In The Riskgauge 3.0 Model Using Different Restatementtypeids.
RatingsXpress®: Structured Finance Performance
Returns Liabilities Summary And Credit Enhancement Data
RatingsXpress®: Structured Finance Performance
Returns Trustee Reported Tests With Performance Data
Visible Alpha Estimates
Locate Business Model Templates
Visible Alpha Estimates
Track Revenue Estimate Changes
Visible Alpha Estimates
Access Latest Consensus For Various Periods
Visible Alpha Estimates
Calculate EPS Surprise
Visible Alpha Estimates
Find Companies In A Business Group
Visible Alpha Estimates
Calculate Revenue Weight By Segment
Credit Analytics
Retrieves Sovereign 1 Year PD In The Riskgauge 3.0 Model
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
RatingsXpress®: Structured Finance Performance
Returns CLO Profile And Deal/Collateral Performance Data
S&P Capital IQ Financials
Retrieves Annual Financial Data for Specified Companies While Handling Conflicts Across Multiple FiscalChainSeriesIDs
Credit Analytics
Retrieves Different Absolute Contribution Ratios Under RiskGauge 3.0 Model
Credit Analytics
Retrieves RiskGauge 3.0 Country Benchmark Using Pdtype As IQ_RG3_SOV_1YR_PD
RatingsXpress®: Structured Finance Performance
Returns S&P Generated Metrics For Summary Issuance By Specific Instrument Symbols
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 Equity Ratios Analysis
Bond to Equity Factors
Returns Bond To Equity Ratios Records For Specific Date And UniverseID
S&P Capital IQ Estimates
Returns the Current Year Revenue Estimate For a Company
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 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 Pivot Module
Visible Alpha Estimates
Returns CRM Visible Alpha Estimates Industry Metrics Module
S&P Capital IQ Estimates
Returns 10 Year Average TEV/EBITDA Estimates For Reported Forward One Period For A Company
S&P Capital IQ Financials
Returns Financial Reporting Data By Company and Financial Statement Type
S&P Capital IQ Financials
Returns Financial Data for a Specific dataItem Across Multiple Companies in an Industry
SNL Insurance Regulatory Data
Returns Comprehensive Overview Of Direct Written Premiums By Line Of Business Across The US In 2024
Ownership
Returns Ownership Summary For Selected Tickers Over Last Five Periods With Categorized Owner Types
Ownership
Returns Ownership Detailed For Selected Ticker With Categorized Owner Types
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
SNL Insurance Regulatory Data
Returns Direct Written Premiums By Line Of Business For A Particular Company Across The US In 2024
Physical Risk
Returns Company Level Physical Risk Data For A Given Forecast Year And Scenario
S&P Capital IQ Financials
As Reported Transparency
SNL RateWatch Depository Rates
Standard Interest Rates
SNL RateWatch Depository Rates
Rates During A Specific Timeframe
SNL RateWatch Depository Rates
Competitive Interest Rates
SNL RateWatch Depository Rates
Branches And Location
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
Bank Product Rates
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 Index Bid Ask Volatility And Forward Curve Data
OTC Derivatives Data
Returns Equity VolSwap Volatility And Discount Factor Data
OTC Derivatives Data
Returns Equity VarSwap 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
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
Headcount Analytics
Returns Monthly Headcount Changes For A Company
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
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
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
Market Data
Returns Carryforward Market Pricing Data For The Specified Date Range
OTC Derivatives Data
Returns Equity Stock ETF 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
OTC Derivatives Data
Returns Equity Index Volatility Forward Curve And Dividend Yield Data
S&P Capital IQ Financials
Returns Latest 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
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