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:

794.76 GiB

Data Last Updated:

Jan. 15, 2026, 4:54 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:

27.21 GiB

Data Last Updated:

Jan. 15, 2026, 3:54 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.31 GiB

Data Last Updated:

Jan. 15, 2026, 11:25 a.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.53 GiB

Data Last Updated:

Jan. 15, 2026, 5:55 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.84 GiB

Data Last Updated:

Jan. 15, 2026, 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:

Jan. 15, 2026, 5:39 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 - 2026-01-10

Update Frequency:

Monthly

Total Size:

86.81 GiB

Data Last Updated:

Jan. 15, 2026, 1:40 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 - 2026-01-27

Update Frequency:

Daily

Total Size:

635.9 MiB

Data Last Updated:

Jan. 27, 2026, 11:25 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:

Jan. 4, 2026, 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:

120.37 GiB

Data Last Updated:

Jan. 27, 2026, 2: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.51 GiB

Data Last Updated:

Jan. 27, 2026, 5:06 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 - 2026-01-02

Update Frequency:

Quarterly

Total Size:

1.94 GiB

Data Last Updated:

Jan. 5, 2026, 4:04 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-12-31

Update Frequency:

Quarterly

Total Size:

43.15 GiB

Data Last Updated:

Jan. 5, 2026, 5:02 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:

Jan. 27, 2026, 1:11 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.90 GiB

Data Last Updated:

Jan. 5, 2026, 9:50 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 - 2026-01-01

Update Frequency:

Quarterly

Total Size:

1.94 GiB

Data Last Updated:

Jan. 5, 2026, 5:30 a.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements

Data Product Details

---

Title:

Panjiva Supply Chain Intelligence

Description:

Panjiva uses artificial intelligence and advanced data engineering to turn global trade data into information that helps everyone - consumers, governments, and businesses of all sizes. Panjiva data contains transaction-level details of goods traded across borders, with information like buyers and sellers, product descriptions, and values of shipment transactions. It is an immense dataset, with over 1 billion records supplying transaction details for approximately 40%* of global merchandise traded by dollar value, including key economies like the United States, India, Mexico, and others.

Product Code/Schema:

panjiva

Data Dictionary

---

Data Specifications

Date Range:

2001-01-31 - 2025-11-15

Update Frequency:

N/A

Total Size:

4.55 TiB

Data Last Updated:

Dec. 28, 2025, 12:56 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Economics

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

Data Last Updated:

Jan. 5, 2026, 7:04 a.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:

Jan. 5, 2026, 7:15 a.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.05 GiB

Data Last Updated:

Jan. 5, 2026, 7:27 a.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-30

Update Frequency:

Monthly

Total Size:

40.34 GiB

Data Last Updated:

Jan. 5, 2026, 8:03 a.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-30

Update Frequency:

Monthly

Total Size:

21.7 MiB

Data Last Updated:

Jan. 5, 2026, 8:09 a.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:

Jan. 5, 2026, 8:19 a.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:

Jan. 5, 2026, 8:29 a.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-30

Update Frequency:

Monthly

Total Size:

297.9 MiB

Data Last Updated:

Jan. 5, 2026, 8:35 a.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-30

Update Frequency:

Monthly

Total Size:

4.13 GiB

Data Last Updated:

Jan. 5, 2026, 8:43 a.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