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:

803.42 GiB

Data Last Updated:

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

30.44 GiB

Data Last Updated:

April 15, 2026, 5:51 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:

62.95 GiB

Data Last Updated:

April 15, 2026, 2:09 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:

27.12 GiB

Data Last Updated:

April 15, 2026, 8:14 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.97 GiB

Data Last Updated:

April 15, 2026, 6:49 a.m.

Usage:

---

Content Summary

Identifiers:

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

20.45 GiB

Data Last Updated:

April 21, 2026, 11:50 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-04-12

Update Frequency:

Monthly

Total Size:

88.22 GiB

Data Last Updated:

April 15, 2026, 4:32 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-04-24

Update Frequency:

Daily

Total Size:

641.0 MiB

Data Last Updated:

April 24, 2026, 12:23 p.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Banks, 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:

122.15 GiB

Data Last Updated:

April 24, 2026, 1:28 p.m.

Usage:

---

Content Summary

Identifiers:

• isin
• sedol
• sic
• ticker

Regions:

Global

Concepts:

Financial Statements, Stock Prices

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

Data Last Updated:

April 24, 2026, 2:08 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 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:

95.27 GiB

Data Last Updated:

April 25, 2026, 4:42 a.m.

Usage:

---

Content Summary

Identifiers:

• cik
• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements, Stock Prices

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:

69.25 GiB

Data Last Updated:

April 5, 2026, 7:32 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

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

WRDS Overview
Data Dictionary

---

Data Specifications

Date Range:

2000-05-08 - 9780-09-07

Update Frequency:

N/A

Total Size:

8.45 TiB

Data Last Updated:

April 21, 2026, 4:55 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Economics

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

Data Last Updated:

April 7, 2026, 4:25 p.m.

Usage:

---

Content Summary

Identifiers:

• ticker

Regions:

North America

Concepts:

Compensation

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 - 2026-02-28

Update Frequency:

Quarterly

Total Size:

43.22 GiB

Data Last Updated:

April 5, 2026, 5:48 a.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• sic
• ticker

Regions:

North America

Concepts:

Financial Statements

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-03-27

Update Frequency:

Quarterly

Total Size:

1.95 GiB

Data Last Updated:

April 5, 2026, 4:55 a.m.

Usage:

---

Content Summary

Identifiers:

• cusip_full
• sic
• ticker

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-03-01

Update Frequency:

Quarterly

Total Size:

1.95 GiB

Data Last Updated:

April 5, 2026, 5:59 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:

100.64 GiB

Data Last Updated:

April 6, 2026, 7:55 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:

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:

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:

Trucost Analytics: Carbon Earnings at Risk

Product Code/Schema:

trucost_carbon

Data Dictionary

---

Data Specifications

Date Range:

2004-06-30 - 2026-03-19

Update Frequency:

Monthly

Total Size:

1.08 GiB

Data Last Updated:

April 6, 2026, 8: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: 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:

April 6, 2026, 9:07 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 - 2026-02-27

Update Frequency:

Monthly

Total Size:

1.74 GiB

Data Last Updated:

April 6, 2026, 9:17 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.18 GiB

Data Last Updated:

April 6, 2026, 8:17 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 - 2026-01-31

Update Frequency:

Monthly

Total Size:

40.33 GiB

Data Last Updated:

April 6, 2026, 8:52 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 - 2026-01-31

Update Frequency:

Monthly

Total Size:

23.7 MiB

Data Last Updated:

April 6, 2026, 8:57 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 - 2026-01-31

Update Frequency:

Monthly

Total Size:

331.4 MiB

Data Last Updated:

April 6, 2026, 9:23 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 - 2026-01-31

Update Frequency:

Monthly

Total Size:

4.14 GiB

Data Last Updated:

April 6, 2026, 9:31 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:

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:

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.1 MiB

Data Last Updated:

April 7, 2026, 1:50 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Mergers & Acquisitions

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:

Computext Sample

Product Code/Schema:

compsamp_computext

Data Dictionary

---

Data Specifications

Date Range:

1969-12-31 - 2026-01-28

Update Frequency:

N/A

Total Size:

2.32 GiB

Data Last Updated:

March 17, 2026, 9:40 a.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Financial Statements, Textual Analysis

Data Product Details

---

Title:

Panjiva Sample

Description:

Panjiva Supply Chain Intelligance Sample Data. This contains a sample of data from the US and Bolivia Import and Export tables.

Product Code/Schema:

panjiva_samp

Data Dictionary

---

Data Specifications

Date Range:

2007-01-02 - 2026-03-21

Update Frequency:

N/A

Total Size:

2.03 GiB

Data Last Updated:

April 8, 2026, 2:48 p.m.

Usage:

---

Content Summary

Identifiers:

No identifiers specified for this product.

Regions:

Global

Concepts:

Economics

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:

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