S&P Global Market Intelligence

Data Product Details

---

Title:

Capital IQ Capital Structure

Product Code/Schema:

ciq_capstrct

Data Dictionary

---

Data Specifications

Date Range:

1640-01-01 - 9998-12-31

Update Frequency:

Monthly

Total Size:

787.59 GiB

Data Last Updated:

Nov. 5, 2025, 1:13 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Financial Statements

Data Product Details

---

Title:

Capital IQ Helper

Product Code/Schema:

ciq_common

Data Dictionary

---

Data Specifications

Date Range:

1900-01-01 - 2115-01-21

Update Frequency:

Monthly

Total Size:

26.69 GiB

Data Last Updated:

Nov. 4, 2025, 11:08 a.m.

Usage:

---

Content Summary

Identifiers:

• ticker

Regions:

No associated region tags.

Concepts:

No associated concept tags.

Data Product Details

---

Title:

Capital IQ Key Developments

Product Code/Schema:

ciq_keydev

View Sample Data
WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1912-06-29 - 2047-05-19

Update Frequency:

Monthly

Total Size:

60.03 GiB

Data Last Updated:

Oct. 2, 2025, 12:25 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

News

Data Product Details

---

Title:

Capital IQ People Intelligence

Product Code/Schema:

ciq_pplintel

Data Dictionary

---

Data Specifications

Date Range:

1753-01-01 - 3022-03-31

Update Frequency:

Monthly

Total Size:

26.26 GiB

Data Last Updated:

Nov. 4, 2025, 12:58 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

ESG: Environmental, Social, Governance, Compensation

Data Product Details

---

Title:

Capital IQ Ratings

Product Code/Schema:

ciq_ratings

Data Dictionary

---

Data Specifications

Date Range:

1922-01-01 - 9999-09-09

Update Frequency:

Monthly

Total Size:

13.81 GiB

Data Last Updated:

Nov. 4, 2025, 12:03 p.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• ticker

Regions:

Global

Concepts:

Bonds and Fixed Income

Data Product Details

---

Title:

Capital IQ Transactions

Product Code/Schema:

ciq_transactions

Data Dictionary

---

Data Specifications

Date Range:

1753-01-01 - 2201-05-23

Update Frequency:

Quarterly

Total Size:

17.73 GiB

Data Last Updated:

Nov. 4, 2025, 12:51 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Mergers & Acquisitions

Data Product Details

---

Title:

Capital IQ Transcripts

Product Code/Schema:

ciq_transcripts

View Sample Data
WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

2002-02-14 - 2025-11-02

Update Frequency:

Quarterly

Total Size:

85.70 GiB

Data Last Updated:

Nov. 4, 2025, 5:24 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

News

Data Product Details

---

Title:

Compustat Bank - daily updates

Product Code/Schema:

comp_bank_daily

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1950-01-01 - 2025-11-06

Update Frequency:

Daily

Total Size:

633.7 MiB

Data Last Updated:

Nov. 7, 2025, 11:33 a.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Banks, Financial Statements

Data Product Details

---

Title:

S&P Compustat Executive Compensation

Product Code/Schema:

comp_execucomp

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1899-12-26 - 2406-10-01

Update Frequency:

Monthly

Total Size:

1.40 GiB

Data Last Updated:

Nov. 4, 2025, 10:12 a.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• ticker

Regions:

North America

Concepts:

Compensation

Data Product Details

---

Title:

S&P Filing Dates

Product Code/Schema:

comp_filings

Data Dictionary

---

Data Specifications

Date Range:

1935-03-02 - 2046-09-13

Update Frequency:

Legacy Data - No Longer Updated

Total Size:

4.42 GiB

Data Last Updated:

Aug. 24, 2016, 2:39 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

Compustat Global - daily updates

Product Code/Schema:

comp_global_daily

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1900-01-01 - 2900-01-01

Update Frequency:

Daily

Total Size:

118.55 GiB

Data Last Updated:

Nov. 7, 2025, 2:42 p.m.

Usage:

---

Content Summary

Identifiers:

• isin
• sedol
• sic
• ticker

Regions:

Global

Concepts:

Financial Statements, Stock Prices

Data Product Details

---

Title:

Compustat North America - daily updates (current + historical data)

Product Code/Schema:

comp_na_daily_all

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1900-01-01 - 2900-01-01

Update Frequency:

Daily

Total Size:

93.97 GiB

Data Last Updated:

Nov. 7, 2025, 5:29 a.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements, Stock Prices

Data Product Details

---

Title:

S&P Compustat Preliminary History (Charter Oaks)

Product Code/Schema:

comp_ph

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1900-01-01 - 2025-10-03

Update Frequency:

Quarterly

Total Size:

1.93 GiB

Data Last Updated:

Nov. 6, 2025, 6:07 p.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

S&P Compustat Point in Time (Charter Oaks)

Product Code/Schema:

comp_pit

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1980-02-29 - 2025-09-30

Update Frequency:

Quarterly

Total Size:

43.05 GiB

Data Last Updated:

Oct. 6, 2025, 4:54 p.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

S&P Ratings - legacy

Product Code/Schema:

comp_ratings

Data Dictionary

---

Data Specifications

Date Range:

1923-05-18 - 9007-06-20

Update Frequency:

Legacy Data - No Longer Updated

Total Size:

1.19 GiB

Data Last Updated:

None

Usage:

---

Content Summary

Identifiers:

• cik
• ticker

Regions:

No associated region tags.

Concepts:

No associated concept tags.

Data Product Details

---

Title:

Compustat Historical Segments - daily updates

Product Code/Schema:

comp_segments_hist_daily

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1976-06-30 - 2029-12-26

Update Frequency:

Daily

Total Size:

1.42 GiB

Data Last Updated:

Nov. 7, 2025, 1:12 p.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements, Segments / Industry Data

Data Product Details

---

Title:

Compustat Snapshot

Product Code/Schema:

comp_snapshot

View Sample Data
Data Dictionary

---

Data Specifications

Date Range:

1900-01-01 - 9999-12-31

Update Frequency:

Monthly

Total Size:

68.70 GiB

Data Last Updated:

Nov. 5, 2025, 9:19 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

S&P Compustat Unrestated Quarterly (Charter Oaks)

Product Code/Schema:

comp_urq

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1982-03-31 - 2025-09-30

Update Frequency:

Quarterly

Total Size:

1.93 GiB

Data Last Updated:

Oct. 6, 2025, 3:42 p.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

S&P ESG

Product Code/Schema:

sp_esg

Data Dictionary

---

Data Specifications

Date Range:

2013-03-04 - 2026-08-15

Update Frequency:

Monthly

Total Size:

94.33 GiB

Data Last Updated:

Nov. 6, 2025, 4:59 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Analytics: Carbon Earnings at Risk

Product Code/Schema:

trucost_carbon

Data Dictionary

---

Data Specifications

Date Range:

2004-06-30 - 2025-09-24

Update Frequency:

Monthly

Total Size:

972.3 MiB

Data Last Updated:

Nov. 6, 2025, 5:09 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Common Tables

Product Code/Schema:

trucost_common

Data Dictionary

---

Data Specifications

Date Range:

Unspecified

Update Frequency:

Monthly

Total Size:

4.87 GiB

Data Last Updated:

Nov. 6, 2025, 5:22 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Environmental

Product Code/Schema:

trucost_environ

Data Dictionary

---

Data Specifications

Date Range:

2002-01-26 - 2025-07-31

Update Frequency:

Monthly

Total Size:

34.72 GiB

Data Last Updated:

Nov. 6, 2025, 6:01 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Environmental: Fossil Fuels

Product Code/Schema:

trucost_fossilfuel

Data Dictionary

---

Data Specifications

Date Range:

2002-01-26 - 2025-07-31

Update Frequency:

Monthly

Total Size:

20.9 MiB

Data Last Updated:

Nov. 6, 2025, 6:06 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Analytics: Paris Alignment

Product Code/Schema:

trucost_paris

Data Dictionary

---

Data Specifications

Date Range:

2019-01-14 - 2025-10-23

Update Frequency:

Monthly

Total Size:

647.5 MiB

Data Last Updated:

Nov. 6, 2025, 6:16 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Analytics: Physical Risk

Product Code/Schema:

trucost_risk

Data Dictionary

---

Data Specifications

Date Range:

2019-08-01 - 2025-05-23

Update Frequency:

Monthly

Total Size:

1.74 GiB

Data Last Updated:

Nov. 6, 2025, 6:27 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Environmental: Fossil Fuels Sector

Product Code/Schema:

trucost_sector_ff

Data Dictionary

---

Data Specifications

Date Range:

2002-01-26 - 2025-01-04

Update Frequency:

Monthly

Total Size:

281.8 MiB

Data Last Updated:

Nov. 6, 2025, 6:33 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Trucost Environmental: Revenue Sector

Product Code/Schema:

trucost_sector_revenue

Data Dictionary

---

Data Specifications

Date Range:

2002-01-26 - 2025-01-31

Update Frequency:

Monthly

Total Size:

4.08 GiB

Data Last Updated:

Nov. 6, 2025, 6:43 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

ESG: Environmental, Social, Governance

Data Product Details

---

Title:

Capital IQ Sample Capital Structure

Product Code/Schema:

ciqsamp_capstrct

Data Dictionary

---

Data Specifications

Date Range:

1986-12-31 - 2111-03-16

Update Frequency:

N/A

Total Size:

18.0 MiB

Data Last Updated:

Oct. 13, 2025, 12:01 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Financial Statements

Data Product Details

---

Title:

Capital IQ Sample Helper

Product Code/Schema:

ciqsamp_common

Data Dictionary

---

Data Specifications

Date Range:

1900-01-01 - 2025-09-26

Update Frequency:

N/A

Total Size:

127.0 MiB

Data Last Updated:

Oct. 13, 2025, 12:01 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

No associated region tags.

Concepts:

No associated concept tags.

Data Product Details

---

Title:

Capital IQ Sample Key Developments

Product Code/Schema:

ciqsamp_keydev

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

1970-11-20 - 2011-12-19

Update Frequency:

N/A

Total Size:

95.2 MiB

Data Last Updated:

Jan. 8, 2024, 4:32 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

News

Data Product Details

---

Title:

Capital IQ Sample People Intelligence

Product Code/Schema:

ciqsamp_pplintel

Data Dictionary

---

Data Specifications

Date Range:

1968-01-02 - 2099-01-01

Update Frequency:

N/A

Total Size:

105.8 MiB

Data Last Updated:

Oct. 13, 2025, 12:02 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

ESG: Environmental, Social, Governance, Compensation

Data Product Details

---

Title:

Capital IQ Sample Ratings

Product Code/Schema:

ciqsamp_ratings

Data Dictionary

---

Data Specifications

Date Range:

1954-12-08 - 3017-11-24

Update Frequency:

N/A

Total Size:

176.1 MiB

Data Last Updated:

Oct. 13, 2025, 12:03 p.m.

Usage:

---

Content Summary

Identifiers:

• cusip_6
• ticker

Regions:

Global

Concepts:

Bonds and Fixed Income

Data Product Details

---

Title:

CIQ Transactions Sample

Product Code/Schema:

ciqsamp_transactions

Data Dictionary

---

Data Specifications

Date Range:

1965-05-31 - 2025-05-23

Update Frequency:

N/A

Total Size:

8.2 MiB

Data Last Updated:

Oct. 13, 2025, 12:05 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Mergers & Acquisitions

Data Product Details

---

Title:

Capital IQ Sample Transcripts

Product Code/Schema:

ciqsamp_transcripts

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

2004-01-01 - 2019-09-23

Update Frequency:

N/A

Total Size:

656 KiB

Data Last Updated:

Oct. 5, 2023, 1:44 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

News

Data Product Details

---

Title:

S&P Compustat North America Sample

Product Code/Schema:

compsamp_all

Data Dictionary

---

Data Specifications

Date Range:

1950-09-30 - 2021-03-31

Update Frequency:

N/A

Total Size:

35.4 MiB

Data Last Updated:

April 20, 2021, 12:09 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

Compustat Snapshot - Sample

Product Code/Schema:

compsamp_snapshot

Data Dictionary

---

Data Specifications

Date Range:

1968-01-01 - 9999-12-31

Update Frequency:

N/A

Total Size:

2.65 GiB

Data Last Updated:

None

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

Trucost Sample

Product Code/Schema:

trucost_samp

Data Dictionary

---

Data Specifications

Date Range:

2018-12-31 - 2021-03-25

Update Frequency:

N/A

Total Size:

2.4 MiB

Data Last Updated:

Nov. 20, 2023, noon

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

ESG: Environmental, Social, Governance