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:

793.35 GiB

Data Last Updated:

Dec. 15, 2025, 5:41 p.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.98 GiB

Data Last Updated:

Dec. 15, 2025, 3:55 a.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• isin
• 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:

61.04 GiB

Data Last Updated:

Dec. 17, 2025, 9:56 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.43 GiB

Data Last Updated:

Dec. 15, 2025, 5:54 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Compensation, ESG: Environmental, Social, Governance

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.82 GiB

Data Last Updated:

Dec. 15, 2025, 4:50 a.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:

Dec. 15, 2025, 5:41 a.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-12-13

Update Frequency:

Quarterly

Total Size:

86.56 GiB

Data Last Updated:

Dec. 18, 2025, 4: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-12-23

Update Frequency:

Daily

Total Size:

635.1 MiB

Data Last Updated:

Dec. 24, 2025, 12:03 p.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:

Dec. 4, 2025, 10:11 a.m.

Usage:

---

Content Summary

Identifiers:

• 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:

119.64 GiB

Data Last Updated:

Dec. 24, 2025, 4:04 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:

94.32 GiB

Data Last Updated:

Dec. 24, 2025, 5:28 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-11-28

Update Frequency:

Quarterly

Total Size:

1.94 GiB

Data Last Updated:

Dec. 5, 2025, 3:56 a.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-10-31

Update Frequency:

Quarterly

Total Size:

43.08 GiB

Data Last Updated:

Dec. 5, 2025, 4:52 a.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.43 GiB

Data Last Updated:

Dec. 24, 2025, 1:15 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.84 GiB

Data Last Updated:

Dec. 5, 2025, 11:08 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:

Dec. 5, 2025, 5:04 a.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:

96.32 GiB

Data Last Updated:

Dec. 16, 2025, 8:47 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-11-18

Update Frequency:

Monthly

Total Size:

1.01 GiB

Data Last Updated:

Dec. 16, 2025, 8:57 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:

5.01 GiB

Data Last Updated:

Dec. 16, 2025, 9: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 Environmental

Product Code/Schema:

trucost_environ

Data Dictionary

---

Data Specifications

Date Range:

2002-01-26 - 2025-11-28

Update Frequency:

Monthly

Total Size:

40.34 GiB

Data Last Updated:

Dec. 16, 2025, 9:42 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-11-28

Update Frequency:

Monthly

Total Size:

21.5 MiB

Data Last Updated:

Dec. 16, 2025, 9:48 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:

930.6 MiB

Data Last Updated:

Dec. 16, 2025, 9:58 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:

Dec. 16, 2025, 10:08 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-11-28

Update Frequency:

Monthly

Total Size:

294.3 MiB

Data Last Updated:

Dec. 16, 2025, 10:14 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-11-28

Update Frequency:

Monthly

Total Size:

4.13 GiB

Data Last Updated:

Dec. 16, 2025, 10:21 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:

Compensation, ESG: Environmental, Social, Governance

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:

1978-01-31 - 2025-11-17

Update Frequency:

N/A

Total Size:

8.2 MiB

Data Last Updated:

Nov. 18, 2025, 3:12 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