Carbon Emissions¶

The Carbon Emissions listing holds four views under the EMMI schema, each documented in its own section below.

Public equity carbon emissions
Public equity projected carbon emissions
Fixed income carbon emissions
Fixed income projected carbon emissions

Public equity carbon emissions¶

EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS holds Scope 1, 2 and 3 emissions for listed companies, one row per company per fiscal year.

Primary key: ISIN, FISCAL_END_DATE.

Columns¶

Column	Type	Unit	Example	Description
`ISIN`	string		IT0003128367	International Securities Identification Number of the listing.
`FISCAL_END_DATE`	date (yyyy-mm-dd)	Date	2024-12-31	Fiscal year end date for the company.
`NAME`	string		Enel SpA	Name of the company.
`COUNTRY`	string		Italy	Country the company is in.
`FACTSET_INDUSTRY`	string		Electric Utilities	FactSet Industry classification of the equity.
`SCOPE1_EMISSIONS`	float / null	tCO2e	20210000	Scope 1 emissions by the entity.
`SCOPE2_EMISSIONS`	float / null	tCO2e	4900000	Scope 2 emissions by the entity.
`SCOPE3_EMISSIONS`	float / null	tCO2e	46260000	Scope 3 emissions by the entity.
`SCOPE1_PCAF`	int between 1 and 5 / null	Score	2	The PCAF score for Scope 1. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only.
`SCOPE2_PCAF`	int between 1 and 5 / null	Score	2	The PCAF score for Scope 2. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only.
`SCOPE3_PCAF`	int between 1 and 5 / null	Score	3	The PCAF score for Scope 3. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only.
`SCOPE1_EMISSION_REPORTING_STATUS`	string		reported	Status of emissions reporting for Scope 1. `reported`, `estimated` or `unavailable`.
`SCOPE2_EMISSION_REPORTING_STATUS`	string		reported	Status of emissions reporting for Scope 2. `reported`, `estimated` or `unavailable`.
`SCOPE3_EMISSION_REPORTING_STATUS`	string		estimated	Status of emissions reporting for Scope 3. `reported`, `estimated` or `unavailable`.
`WACI_S1`	float	tCO2e per million revenue	246.7	Weighted Average Carbon Intensity of Scope 1. Emissions as a factor of company revenue.
`WACI_S12`	float	tCO2e per million revenue	306.5	Weighted Average Carbon Intensity of Scopes 1 + 2. Emissions as a factor of company revenue.
`WACI_S123`	float	tCO2e per million revenue	871.2	Weighted Average Carbon Intensity of Scopes 1 + 2 + 3. Emissions as a factor of company revenue.
`EVIC_CARBON_INTENSITY_S12`	float	tCO2e per million EVIC	123.45	An intensity measure of Scope 1 and 2 emissions, as a factor of EVIC.
`EVIC_CARBON_INTENSITY_S123`	float	tCO2e per million EVIC	123.45	An intensity measure of all emissions, as a factor of EVIC.

Examples¶

Emissions history for Enel since 2020.

SELECT ISIN, FISCAL_END_DATE, NAME, SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS,
       SCOPE1_EMISSION_REPORTING_STATUS
FROM EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS
WHERE ISIN = 'IT0003128367'
ORDER BY FISCAL_END_DATE;

ISIN	FISCAL_END_DATE	NAME	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	SCOPE1_EMISSION_REPORTING_STATUS
IT0003128367	2020-12-31	Enel SpA	45260000	2250000	47700000	reported
IT0003128367	2021-12-31	Enel SpA	51570000	7110000	69150000	reported
IT0003128367	2022-12-31	Enel SpA	53070000	6060000	85268434	reported
IT0003128367	2023-12-31	Enel SpA	34510557	4506161	56533423	reported
IT0003128367	2024-12-31	Enel SpA	20210000	4900000	46260000	reported
IT0003128367	2025-12-31	Enel SpA	19706800	4857722	47641505	estimated

Fiscal year 2024 emissions for a five-stock portfolio.

WITH MY_HOLDINGS AS (
    SELECT * FROM VALUES
        ('IT0003128367', 0.30),
        ('CH0038863350', 0.25),
        ('DE0007236101', 0.20),
        ('NL0010273215', 0.15),
        ('DK0010244508', 0.10)
    AS H (ISIN, WEIGHT)
)
SELECT h.ISIN, h.WEIGHT, e.NAME, e.FACTSET_INDUSTRY,
       e.SCOPE1_EMISSIONS, e.SCOPE2_EMISSIONS, e.SCOPE3_EMISSIONS,
       ROUND(e.WACI_S12, 1) AS WACI_S12
FROM MY_HOLDINGS h
JOIN EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS e ON e.ISIN = h.ISIN
WHERE YEAR(e.FISCAL_END_DATE) = 2024
ORDER BY h.WEIGHT DESC;

ISIN	WEIGHT	NAME	FACTSET_INDUSTRY	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	WACI_S12
IT0003128367	0.30	Enel SpA	Electric Utilities	20210000	4900000	46260000	306.5
CH0038863350	0.25	Nestlé SA	Food: Major Diversified	3080000	260000	71350000	31.6
DE0007236101	0.20	Siemens AG	Industrial Machinery	347000	94000	416758000	5.4
NL0010273215	0.15	ASML Holding NV	Semiconductors	23500	9300	12038800	1.1
DK0010244508	0.10	A.P. Møller-Mærsk A/S	Marine Shipping	33939000	356000	49232000	614.3

Weighted carbon intensity of the portfolio, and how much of it reports Scope 1.

WITH MY_HOLDINGS AS (
    SELECT * FROM VALUES
        ('IT0003128367', 0.30),
        ('CH0038863350', 0.25),
        ('DE0007236101', 0.20),
        ('NL0010273215', 0.15),
        ('DK0010244508', 0.10)
    AS H (ISIN, WEIGHT)
)
SELECT ROUND(SUM(h.WEIGHT * e.WACI_S12), 1)  AS PORTFOLIO_WACI_S12,
       ROUND(SUM(h.WEIGHT * e.WACI_S123), 1) AS PORTFOLIO_WACI_S123,
       SUM(IFF(e.SCOPE1_EMISSION_REPORTING_STATUS = 'reported', h.WEIGHT, 0)) AS WEIGHT_WITH_REPORTED_SCOPE1
FROM MY_HOLDINGS h
JOIN EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS e ON e.ISIN = h.ISIN
WHERE YEAR(e.FISCAL_END_DATE) = 2024;

PORTFOLIO_WACI_S12	PORTFOLIO_WACI_S123	WEIGHT_WITH_REPORTED_SCOPE1
162.5	1670.0	1.00

Public equity projected carbon emissions¶

EMMI.PUBLIC_EQUITY_PROJECTED_CARBON_EMISSIONS holds a company's emissions in future years, one row per company, fiscal year, emissions year and projection type. Two kinds of projection are provided:

Target. The company's own published SBTi target, taken at face value. Emissions move in a straight line from the target's baseline year to its target year and stay there afterwards.
Forecast. Emmi's forecast of the company's Scope 1, 2 and 3 emissions to 2030, from its emissions history. The forecast is a probabilistic model and the median path is provided.

Targets and forecasts are two different projections of the same company. Do not sum or combine them.

Primary key: ISIN, FISCAL_END_DATE, EMISSIONS_YEAR, PROJECTION_TYPE. Several fiscal years can be active at once, so filter on FISCAL_END_DATE to read one trajectory per company.

Columns¶

Column	Type	Unit	Example	Description
`ISIN`	string		IT0003128367	International Securities Identification Number of the listing.
`FISCAL_END_DATE`	date (yyyy-mm-dd)	Date	2024-12-31	Fiscal year end date for the company.
`EMISSIONS_YEAR`	int	Year	2030	The year that these emissions are forecast/targets for.
`PROJECTION_ID`	int		0	Unique identifier for the projection method. 0 for targets, 1 for forecasts.
`PROJECTION_TYPE`	string		Target	Whether the projected emissions were generated using targets or forecasts. `Target` or `Forecast`.
`PROJECTION_METHOD`	string		Stepwise linear glide path	The specific method used to generate the projected emissions. `Stepwise linear glide path` for targets (a straight line between the target's baseline and target years), `Monte Carlo Forecast` for forecasts.
`NAME`	string		Enel SpA	Name of the company.
`SCOPE1_EMISSIONS`	float / null	tCO2e	19795443	Projected Scope 1 emissions of the entity at the emissions year.
`SCOPE2_EMISSIONS`	float / null	tCO2e	977226	Projected Scope 2 emissions of the entity at the emissions year.
`SCOPE3_EMISSIONS`	float / null	tCO2e	20980347	Projected Scope 3 emissions of the entity at the emissions year.
`TEMP_ALIGNMENT`	float / null	°C	1.5	Temperature alignment of the projected emissions trajectory.

Examples¶

Enel's emissions under its own targets at each risk year.

SELECT PROJECTION_TYPE, EMISSIONS_YEAR, SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS,
       ROUND(TEMP_ALIGNMENT, 2) AS TEMP_ALIGNMENT
FROM EMMI.PUBLIC_EQUITY_PROJECTED_CARBON_EMISSIONS
WHERE ISIN = 'IT0003128367'
  AND FISCAL_END_DATE = '2024-12-31'
  AND PROJECTION_TYPE = 'Target'
  AND EMISSIONS_YEAR IN (2025, 2030, 2035, 2040, 2045, 2050)
ORDER BY EMISSIONS_YEAR;

PROJECTION_TYPE	EMISSIONS_YEAR	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	TEMP_ALIGNMENT
Target	2025	29100992.91	1436605.52	30842903.06	1.50
Target	2030	19795442.85	977225.85	20980346.85	1.50
Target	2035	12097215.08	597193.58	11655748.25	1.50
Target	2040	4398987.30	217161.30	2331149.65	1.50
Target	2045	4398987.30	217161.30	2331149.65	1.50
Target	2050	4398987.30	217161.30	2331149.65	1.54

Enel's target against Emmi's forecast at 2030.

SELECT PROJECTION_ID, PROJECTION_TYPE, PROJECTION_METHOD, EMISSIONS_YEAR,
       SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS,
       SCOPE1_EMISSIONS + SCOPE2_EMISSIONS AS SCOPE12_EMISSIONS
FROM EMMI.PUBLIC_EQUITY_PROJECTED_CARBON_EMISSIONS
WHERE ISIN = 'IT0003128367'
  AND FISCAL_END_DATE = '2024-12-31'
  AND EMISSIONS_YEAR = 2030
ORDER BY PROJECTION_ID;

PROJECTION_ID	PROJECTION_TYPE	PROJECTION_METHOD	EMISSIONS_YEAR	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	SCOPE12_EMISSIONS
0	Target	Stepwise linear glide path	2030	19795442.85	977225.85	20980346.85	20772668.70
1	Forecast	Monte Carlo Forecast	2030	3223417.34	2751315.11	23928635.46	5974732.45

Current, target and forecast Scope 1 + 2 at 2030 for a five-stock portfolio.

WITH MY_HOLDINGS AS (
    SELECT * FROM VALUES
        ('IT0003128367', 0.30),
        ('CH0038863350', 0.25),
        ('DE0007236101', 0.20),
        ('NL0010273215', 0.15),
        ('DK0010244508', 0.10)
    AS H (ISIN, WEIGHT)
)
SELECT h.ISIN, e.NAME,
       e.SCOPE1_EMISSIONS + e.SCOPE2_EMISSIONS AS CURRENT_SCOPE12,
       t.SCOPE1_EMISSIONS + t.SCOPE2_EMISSIONS AS TARGET_SCOPE12_2030,
       f.SCOPE1_EMISSIONS + f.SCOPE2_EMISSIONS AS FORECAST_SCOPE12_2030
FROM MY_HOLDINGS h
JOIN EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS e ON e.ISIN = h.ISIN
LEFT JOIN EMMI.PUBLIC_EQUITY_PROJECTED_CARBON_EMISSIONS t
  ON t.ISIN = e.ISIN AND t.FISCAL_END_DATE = e.FISCAL_END_DATE
 AND t.PROJECTION_TYPE = 'Target' AND t.EMISSIONS_YEAR = 2030
LEFT JOIN EMMI.PUBLIC_EQUITY_PROJECTED_CARBON_EMISSIONS f
  ON f.ISIN = e.ISIN AND f.FISCAL_END_DATE = e.FISCAL_END_DATE
 AND f.PROJECTION_TYPE = 'Forecast' AND f.EMISSIONS_YEAR = 2030
WHERE YEAR(e.FISCAL_END_DATE) = 2024
ORDER BY h.WEIGHT DESC;

ISIN	NAME	CURRENT_SCOPE12	TARGET_SCOPE12_2030	FORECAST_SCOPE12_2030
IT0003128367	Enel SpA	25110000	20772668.70	5974732.45
CH0038863350	Nestlé SA	3340000	2563617.00	2714416.96
DE0007236101	Siemens AG	441000	73104.90	228223.81
NL0010273215	ASML Holding NV	32800	111857.25	48068.80
DK0010244508	A.P. Møller-Mærsk A/S	34295000	21594853.33	33130029.36

Fixed income carbon emissions¶

EMMI.FIXED_INCOME_CARBON_EMISSIONS holds the financed Scope 1, 2 and 3 emissions of each bond, with one row per bond per fiscal year. Note that government bonds carry Scope 1 only.

Primary key: ISIN, FISCAL_END_DATE.

Columns¶

Column	Type	Unit	Example	Description
`ISIN`	string		FR0013455821	International Securities Identification Number of the bond.
`FISCAL_END_DATE`	date (yyyy-mm-dd)	Date	2024-12-31	Fiscal year end date for the underlying equity of the bond.
`DEBT_TYPE`	string		Corporate	The type of bond. `Corporate` or `Government`.
`BOND_TYPE`	string		Sovereign	Bond security type. Corporate rows are `Corporate` or `Securitized/Collateralized`. Government rows are `Sovereign`, `Agency`, `Local Authority/Political Division` or `Supranational`.
`NAME`	string		ENGIE SA 1.25% 24-OCT-2041	Name of the bond.
`COUNTRY`	string		France	Country of the underlying equity of the bond.
`FACTSET_INDUSTRY`	string		Electric Utilities	Industry of the underlying equity of the bond. `Sovereign` or `Supranational` for government rows.
`SCOPE1_EMISSIONS`	float / null	tCO2e	135031.36	Scope 1 emissions attributed to the bond. For government rows, the bond's share of the country's national emissions.
`SCOPE2_EMISSIONS`	float / null	tCO2e	4975.83	Scope 2 emissions attributed to the bond. Empty for government rows.
`SCOPE3_EMISSIONS`	float / null	tCO2e	828834.69	Scope 3 emissions attributed to the bond. Empty for government rows.
`SCOPE1_PCAF`	int between 1 and 5 / null	Score	2	The PCAF score for Scope 1. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only.
`SCOPE2_PCAF`	int between 1 and 5 / null	Score	2	The PCAF score for Scope 2. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only. Empty for government rows.
`SCOPE3_PCAF`	int between 1 and 5 / null	Score	2	The PCAF score for Scope 3. PCAF is a method for recognising the quality of estimation. 1 = reported and verified, 2 = reported, 3 = estimated using historical emissions, 4 = estimated with financials only. Empty for government rows.
`SCOPE1_EMISSION_REPORTING_STATUS`	string		reported	Status of emissions reporting for Scope 1. `reported`, `estimated` or `unavailable`.
`SCOPE2_EMISSION_REPORTING_STATUS`	string		reported	Status of emissions reporting for Scope 2. `reported`, `estimated` or `unavailable`. `Not Applicable` for government rows.
`SCOPE3_EMISSION_REPORTING_STATUS`	string		reported	Status of emissions reporting for Scope 3. `reported`, `estimated` or `unavailable`. `Not Applicable` for government rows.
`WACI_S1`	float / null	tCO2e per million revenue	123.45	Weighted Average Carbon Intensity of Scope 1. Emissions as a factor of issuer revenue. Empty for government rows.
`WACI_S12`	float / null	tCO2e per million revenue	123.45	Weighted Average Carbon Intensity of Scopes 1 + 2. Emissions as a factor of issuer revenue. Empty for government rows.
`WACI_S123`	float / null	tCO2e per million revenue	123.45	Weighted Average Carbon Intensity of Scopes 1 + 2 + 3. Emissions as a factor of issuer revenue. Empty for government rows.
`EVIC_CARBON_INTENSITY_S12`	float / null	tCO2e per million EVIC	123.45	An intensity measure of Scope 1 and 2 emissions, as a factor of EVIC. Empty for government rows.
`EVIC_CARBON_INTENSITY_S123`	float / null	tCO2e per million EVIC	123.45	An intensity measure of all emissions, as a factor of EVIC. Empty for government rows.

Examples¶

Financed emissions history for an ENGIE bond since 2020.

SELECT ISIN, FISCAL_END_DATE, DEBT_TYPE, NAME,
       ROUND(SCOPE1_EMISSIONS) AS SCOPE1_EMISSIONS,
       ROUND(SCOPE2_EMISSIONS) AS SCOPE2_EMISSIONS,
       ROUND(SCOPE3_EMISSIONS) AS SCOPE3_EMISSIONS,
       SCOPE1_EMISSION_REPORTING_STATUS
FROM EMMI.FIXED_INCOME_CARBON_EMISSIONS
WHERE ISIN = 'FR0013455821'
  AND FISCAL_END_DATE <= '2025-12-31'
ORDER BY FISCAL_END_DATE;

ISIN	FISCAL_END_DATE	DEBT_TYPE	NAME	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	SCOPE1_EMISSION_REPORTING_STATUS
FR0013455821	2020-12-31	Corporate	ENGIE SA 1.25% 24-OCT-2041	300069	18123	1041993	reported
FR0013455821	2021-12-31	Corporate	ENGIE SA 1.25% 24-OCT-2041	259989	13319	879161	reported
FR0013455821	2022-12-31	Corporate	ENGIE SA 1.25% 24-OCT-2041	226371	5705	1090468	reported
FR0013455821	2023-12-31	Corporate	ENGIE SA 1.25% 24-OCT-2041	155476	5376	846271	reported
FR0013455821	2024-12-31	Corporate	ENGIE SA 1.25% 24-OCT-2041	135031	4976	828835	reported
FR0013455821	2025-12-31	Corporate	ENGIE SA 1.25% 24-OCT-2041	109068	2515	602171	reported

Fiscal year 2024 financed emissions for a six-bond portfolio of corporate and government bonds.

WITH MY_BOND_HOLDINGS AS (
    SELECT * FROM VALUES
        ('FR0013455821', 0.25),
        ('XS3032045398', 0.20),
        ('AU3FN0094520', 0.15),
        ('XS1612943735', 0.10),
        ('DE0001030708', 0.15),
        ('CND000000612', 0.15)
    AS H (ISIN, WEIGHT)
)
SELECT h.ISIN, h.WEIGHT, e.DEBT_TYPE, e.NAME,
       ROUND(e.SCOPE1_EMISSIONS) AS SCOPE1_EMISSIONS,
       ROUND(e.SCOPE2_EMISSIONS) AS SCOPE2_EMISSIONS,
       ROUND(e.SCOPE3_EMISSIONS) AS SCOPE3_EMISSIONS,
       e.SCOPE1_PCAF
FROM MY_BOND_HOLDINGS h
JOIN EMMI.FIXED_INCOME_CARBON_EMISSIONS e ON e.ISIN = h.ISIN
WHERE YEAR(e.FISCAL_END_DATE) = 2024
ORDER BY h.WEIGHT DESC, h.ISIN;

ISIN	WEIGHT	DEBT_TYPE	NAME	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	SCOPE1_PCAF
FR0013455821	0.25	Corporate	ENGIE SA 1.25% 24-OCT-2041	135031	4976	828835	2
XS3032045398	0.20	Corporate	Deutsche Post AG 4.0% 24-MAR-2040	80951	845	338492	2
AU3FN0094520	0.15	Corporate	Ampol Limited FRN 11-DEC-2054	38368	11492	3211097	2
CND000000612	0.15	Government	Government of China 1.64% 15-DEC-2033	9398366			1
DE0001030708	0.15	Government	Germany 0.0% 15-AUG-2030	1382578			1
XS1612943735	0.10	Corporate	AIA Group Limited 4.47% 23-MAY-2047	12	249	54817	2

Portfolio summary by debt type. Intensity is empty for government bonds because they have no revenue.

WITH MY_BOND_HOLDINGS AS (
    SELECT * FROM VALUES
        ('FR0013455821', 0.25),
        ('XS3032045398', 0.20),
        ('AU3FN0094520', 0.15),
        ('XS1612943735', 0.10),
        ('DE0001030708', 0.15),
        ('CND000000612', 0.15)
    AS H (ISIN, WEIGHT)
)
SELECT e.DEBT_TYPE,
       COUNT(*)      AS BONDS,
       SUM(h.WEIGHT) AS WEIGHT,
       SUM(IFF(e.SCOPE1_EMISSION_REPORTING_STATUS = 'reported', h.WEIGHT, 0)) AS WEIGHT_WITH_REPORTED_SCOPE1,
       ROUND(SUM(h.WEIGHT * e.WACI_S12) / SUM(h.WEIGHT), 1) AS WACI_S12
FROM MY_BOND_HOLDINGS h
JOIN EMMI.FIXED_INCOME_CARBON_EMISSIONS e ON e.ISIN = h.ISIN
WHERE YEAR(e.FISCAL_END_DATE) = 2024
GROUP BY e.DEBT_TYPE
ORDER BY e.DEBT_TYPE;

DEBT_TYPE	BONDS	WEIGHT	WEIGHT_WITH_REPORTED_SCOPE1	WACI_S12
Corporate	4	0.70	0.70	134.6
Government	2	0.30	0.30

Fixed income projected carbon emissions¶

EMMI.FIXED_INCOME_PROJECTED_CARBON_EMISSIONS holds the financed emissions of a corporate bond in future years, one row per bond, fiscal year, emissions year and projection type. As in Fixed income carbon emissions, the figures are the bond's share of the issuer's emissions. Two kinds of projection are provided:

Target. The issuer's own published SBTi target, taken at face value. Emissions move in a straight line from the target's baseline year to its target year and stay there afterwards.
Forecast. Emmi's forecast of the issuer's Scope 1, 2 and 3 emissions to 2030, from its emissions history. The forecast is a probabilistic model and the median path is provided.

Targets and forecasts are two different projections of the same issuer. Do not sum or combine them.

Corporate bonds only.

Primary key: ISIN, FISCAL_END_DATE, EMISSIONS_YEAR, PROJECTION_TYPE. Several fiscal years can be active at once, so filter on FISCAL_END_DATE to read one trajectory per bond.

Columns¶

Column	Type	Unit	Example	Description
`ISIN`	string		XS3032045398	International Securities Identification Number of the bond.
`FISCAL_END_DATE`	date (yyyy-mm-dd)	Date	2024-12-31	Fiscal year end date for the underlying equity of the bond.
`EMISSIONS_YEAR`	int	Year	2030	The year that these emissions are forecast/targets for.
`PROJECTION_ID`	int		0	Unique identifier for the projection method. 0 for targets, 1 for forecasts.
`PROJECTION_TYPE`	string		Target	Whether the projected emissions were generated using targets or forecasts. `Target` or `Forecast`.
`PROJECTION_METHOD`	string		Stepwise linear glide path	The specific method used to generate the projected emissions. `Stepwise linear glide path` for targets (a straight line between the target's baseline and target years), `Monte Carlo Forecast` for forecasts.
`DEBT_TYPE`	string		Corporate	Always `Corporate`.
`BOND_TYPE`	string		Corporate	Bond security type. `Corporate` or `Securitized/Collateralized`.
`NAME`	string		Deutsche Post AG 4.0% 24-MAR-2040	Name of the bond.
`SCOPE1_EMISSIONS`	float / null	tCO2e	44745	Projected Scope 1 emissions attributed to the bond at the emissions year.
`SCOPE2_EMISSIONS`	float / null	tCO2e	1226	Projected Scope 2 emissions attributed to the bond at the emissions year.
`SCOPE3_EMISSIONS`	float / null	tCO2e	252522	Projected Scope 3 emissions attributed to the bond at the emissions year.
`TEMP_ALIGNMENT`	float / null	°C	1.57	Temperature alignment of the projected emissions trajectory.

Examples¶

Emissions attributed to a Deutsche Post bond under the issuer's own targets at each risk year.

SELECT PROJECTION_TYPE, EMISSIONS_YEAR,
       ROUND(SCOPE1_EMISSIONS) AS SCOPE1_EMISSIONS,
       ROUND(SCOPE2_EMISSIONS) AS SCOPE2_EMISSIONS,
       ROUND(SCOPE3_EMISSIONS) AS SCOPE3_EMISSIONS,
       ROUND(TEMP_ALIGNMENT, 2) AS TEMP_ALIGNMENT
FROM EMMI.FIXED_INCOME_PROJECTED_CARBON_EMISSIONS
WHERE ISIN = 'XS3032045398'
  AND FISCAL_END_DATE = '2024-12-31'
  AND PROJECTION_TYPE = 'Target'
  AND EMISSIONS_YEAR IN (2025, 2030, 2035, 2040, 2045, 2050)
ORDER BY EMISSIONS_YEAR;

PROJECTION_TYPE	EMISSIONS_YEAR	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	TEMP_ALIGNMENT
Target	2025	62746	1719	299285	1.54
Target	2030	44745	1226	252522	1.57
Target	2035	35487	972	197809	1.55
Target	2040	0	0	0	1.54
Target	2045	0	0	0	1.54
Target	2050	0	0	0	1.54

The issuer's target against Emmi's forecast at 2030 for the same bond.

SELECT PROJECTION_ID, PROJECTION_TYPE, PROJECTION_METHOD, EMISSIONS_YEAR,
       ROUND(SCOPE1_EMISSIONS) AS SCOPE1_EMISSIONS,
       ROUND(SCOPE2_EMISSIONS) AS SCOPE2_EMISSIONS,
       ROUND(SCOPE3_EMISSIONS) AS SCOPE3_EMISSIONS
FROM EMMI.FIXED_INCOME_PROJECTED_CARBON_EMISSIONS
WHERE ISIN = 'XS3032045398'
  AND FISCAL_END_DATE = '2024-12-31'
  AND EMISSIONS_YEAR = 2030
ORDER BY PROJECTION_ID;

PROJECTION_ID	PROJECTION_TYPE	PROJECTION_METHOD	EMISSIONS_YEAR	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS
0	Target	Stepwise linear glide path	2030	44745	1226	252522
1	Forecast	Monte Carlo Forecast	2030	85015		617640

Financed Scope 1 today and at 2030 for a six-bond portfolio. Government bonds and issuers without a target return empty projections.

WITH MY_BOND_HOLDINGS AS (
    SELECT * FROM VALUES
        ('FR0013455821', 0.25),
        ('XS3032045398', 0.20),
        ('AU3FN0094520', 0.15),
        ('XS1612943735', 0.10),
        ('DE0001030708', 0.15),
        ('CND000000612', 0.15)
    AS H (ISIN, WEIGHT)
)
SELECT h.ISIN, e.NAME, e.DEBT_TYPE,
       ROUND(e.SCOPE1_EMISSIONS) AS CURRENT_SCOPE1,
       ROUND(f.SCOPE1_EMISSIONS) AS FORECAST_SCOPE1_2030,
       ROUND(t.SCOPE1_EMISSIONS) AS TARGET_SCOPE1_2030
FROM MY_BOND_HOLDINGS h
JOIN EMMI.FIXED_INCOME_CARBON_EMISSIONS e ON e.ISIN = h.ISIN
LEFT JOIN EMMI.FIXED_INCOME_PROJECTED_CARBON_EMISSIONS f
  ON f.ISIN = e.ISIN AND f.FISCAL_END_DATE = e.FISCAL_END_DATE
 AND f.PROJECTION_TYPE = 'Forecast' AND f.EMISSIONS_YEAR = 2030
LEFT JOIN EMMI.FIXED_INCOME_PROJECTED_CARBON_EMISSIONS t
  ON t.ISIN = e.ISIN AND t.FISCAL_END_DATE = e.FISCAL_END_DATE
 AND t.PROJECTION_TYPE = 'Target' AND t.EMISSIONS_YEAR = 2030
WHERE YEAR(e.FISCAL_END_DATE) = 2024
ORDER BY h.WEIGHT DESC, h.ISIN;

ISIN	NAME	DEBT_TYPE	CURRENT_SCOPE1	FORECAST_SCOPE1_2030	TARGET_SCOPE1_2030
FR0013455821	ENGIE SA 1.25% 24-OCT-2041	Corporate	135031	56007
XS3032045398	Deutsche Post AG 4.0% 24-MAR-2040	Corporate	80951	85015	44745
AU3FN0094520	Ampol Limited FRN 11-DEC-2054	Corporate	38368	52584
CND000000612	Government of China 1.64% 15-DEC-2033	Government	9398366
DE0001030708	Germany 0.0% 15-AUG-2030	Government	1382578
XS1612943735	AIA Group Limited 4.47% 23-MAY-2047	Corporate	12		6

Using the views together¶

Fiscal year 2024 emissions for a portfolio holding both equities and bonds. Equity rows are the company's emissions, bond rows are the emissions attributed to the bond.

WITH MY_HOLDINGS AS (
    SELECT * FROM VALUES
        ('Equity', 'IT0003128367', 0.30),
        ('Equity', 'CH0038863350', 0.20),
        ('Equity', 'DK0010244508', 0.10),
        ('Bond',   'FR0013455821', 0.20),
        ('Bond',   'XS3032045398', 0.10),
        ('Bond',   'CND000000612', 0.10)
    AS H (ASSET_CLASS, ISIN, WEIGHT)
),
EMISSIONS AS (
    SELECT ISIN, FISCAL_END_DATE, NAME, SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS, SCOPE1_PCAF
    FROM EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS
    UNION ALL
    SELECT ISIN, FISCAL_END_DATE, NAME, SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS, SCOPE1_PCAF
    FROM EMMI.FIXED_INCOME_CARBON_EMISSIONS
)
SELECT h.ASSET_CLASS, h.ISIN, h.WEIGHT, e.NAME,
       ROUND(e.SCOPE1_EMISSIONS) AS SCOPE1_EMISSIONS,
       ROUND(e.SCOPE2_EMISSIONS) AS SCOPE2_EMISSIONS,
       ROUND(e.SCOPE3_EMISSIONS) AS SCOPE3_EMISSIONS,
       e.SCOPE1_PCAF
FROM MY_HOLDINGS h
JOIN EMISSIONS e ON e.ISIN = h.ISIN
WHERE YEAR(e.FISCAL_END_DATE) = 2024
ORDER BY h.ASSET_CLASS, h.WEIGHT DESC;

ASSET_CLASS	ISIN	WEIGHT	NAME	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS	SCOPE1_PCAF
Bond	FR0013455821	0.20	ENGIE SA 1.25% 24-OCT-2041	135031	4976	828835	2
Bond	CND000000612	0.10	Government of China 1.64% 15-DEC-2033	9398366			1
Bond	XS3032045398	0.10	Deutsche Post AG 4.0% 24-MAR-2040	80951	845	338492	2
Equity	IT0003128367	0.30	Enel SpA	20210000	4900000	46260000	2
Equity	CH0038863350	0.20	Nestlé SA	3080000	260000	71350000	2
Equity	DK0010244508	0.10	A.P. Møller-Mærsk A/S	33939000	356000	49232000	2

Enel's emissions history followed by Emmi's forecast, as one trajectory from 2020 to 2030.

WITH TRAJECTORY AS (
    SELECT YEAR(FISCAL_END_DATE) AS YEAR, 'History' AS SOURCE,
           SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS
    FROM EMMI.PUBLIC_EQUITY_CARBON_EMISSIONS
    WHERE ISIN = 'IT0003128367'
    UNION ALL
    SELECT EMISSIONS_YEAR, PROJECTION_TYPE,
           SCOPE1_EMISSIONS, SCOPE2_EMISSIONS, SCOPE3_EMISSIONS
    FROM EMMI.PUBLIC_EQUITY_PROJECTED_CARBON_EMISSIONS
    WHERE ISIN = 'IT0003128367'
      AND FISCAL_END_DATE = '2024-12-31'
      AND PROJECTION_TYPE = 'Forecast'
      AND EMISSIONS_YEAR > 2025
)
SELECT YEAR, SOURCE,
       ROUND(SCOPE1_EMISSIONS) AS SCOPE1_EMISSIONS,
       ROUND(SCOPE2_EMISSIONS) AS SCOPE2_EMISSIONS,
       ROUND(SCOPE3_EMISSIONS) AS SCOPE3_EMISSIONS
FROM TRAJECTORY
ORDER BY YEAR;

YEAR	SOURCE	SCOPE1_EMISSIONS	SCOPE2_EMISSIONS	SCOPE3_EMISSIONS
2020	History	45260000	2250000	47700000
2021	History	51570000	7110000	69150000
2022	History	53070000	6060000	85268434
2023	History	34510557	4506161	56533423
2024	History	20210000	4900000	46260000
2025	History	19706800	4857722	47641505
2026	Forecast	11321778	4240766	38129287
2027	Forecast	8461559	3921868	34692242
2028	Forecast	6132656	3482907	30705161
2029	Forecast	4279008	2992923	26439389
2030	Forecast	3223417	2751315	23928635