Sustainable Labs ESG Data

AI-ready ESG (Environmental, Social, Governance), financial, board governance, and TCFD disclosure dataset for Japanese Prime Market-listed companies, delivered via Snowflake Marketplace.

This page is the product documentation for the "Sustainable Labs ESG Data" Snowflake Marketplace listing: dataset scope, table structure, the full ESG metrics data dictionary, and TCFD disclosure structure.

---

1. Overview

Coverage	309 Japanese companies listed on the TSE Prime Market
Fiscal years	FY2018 – FY2026 (9 years; most recent year is still being updated as companies file disclosures)
Data domains	Quantitative ESG metrics, corporate financials, board governance & skills matrix, structured TCFD disclosure text
Company identifier	Ticker (e.g. 7203 JP Equity)
Delivery	Snowflake Secure Share, consumed via Snowflake Marketplace

2. Company Universe

The dataset tracks 309 Prime Market-listed companies covered by Terrast's ESG data collection. Companies are identified by Ticker (security_code, e.g. 7203 JP Equity).

• All 309 companies appear in the TCFD disclosure text table.
• 306 of the 309 have a fully mapped security code in the current quantitative ESG metrics load; 3 tickers are pending code mapping and are temporarily excluded from esg_quant_metrics (they remain available in the TCFD table).

3. Data Sourcing Methodology

• Quantitative ESG & financial metrics are aggregated by Terrast (terrast.biz) from company disclosures — integrated reports, securities reports, and sustainability/ESG reports — as well as standard financial data providers for the financial metrics.
• TCFD disclosure text is extracted verbatim from each company's TCFD-aligned disclosures and structured by pillar and topic for retrieval and citation.
• Board skill matrix is parsed from company corporate governance reports (skill matrix disclosures), one row per director per disclosed skill.
• Most metrics are disclosed (taken directly from a company filing). Where a value could not be directly sourced, calculation_method is set to estimated or calculated and estimated_flag = TRUE — always check these fields before treating a value as company-reported.

4. Table Structure

All tables below are exposed in the MART schema of the shared database.

esg_quant_metrics — long-format ESG/financial fact table

One row per company × fiscal year × metric.

Column	Type	Description
security_code	TEXT	Ticker / company identifier
fiscal_year	NUMBER	Fiscal year the metric was reported for
metric_code	TEXT	Standardized metric identifier — see esg_metric_master
value_numeric	NUMBER	The metric's value
unit	TEXT	Unit of value_numeric (tCO2e, %, persons, JPY, m3, etc.)
scope	TEXT	Scope1 / Scope2 / Scope3 / NA (for GHG metrics)
boundary	TEXT	Reporting boundary: consolidated / non_consolidated / unknown
calculation_method	TEXT	disclosed / estimated / location-based / market-based / calculated
estimated_flag	BOOLEAN	TRUE if the value was estimated rather than directly measured
source_type	TEXT	database_import / annual report / integrated report
source_url	TEXT	URL to the source document, if available
data_version	TEXT	Version date of the data load (YYYY-MM-DD)

esg_metric_master — the 81-metric data dictionary

See the full metrics table in Section 5.

companies — company master

Column	Description
company_id / security_code	Company identifier (Ticker)
company_name_ja / company_name_en	Company name (Japanese / English)
edinet_code	EDINET filing code, where available
industry_code / industry_name	Industry classification
industry_group_code, sub_industry_code, icb_subsector_code, icb_subsector_name	Additional industry classification detail

board_skills — director-level board skill matrix

One row per director per disclosed skill per company.

Column	Description
security_code, company_name_ja, industry_code	Company identifiers
board_member_name	Director name
age	Director age at time of data capture
from_fy / to_fy	First / most recent fiscal year the director held the role
tenure	Years the director has held the role
skill_id / skill_name_ja	Disclosed skill or expertise area (from a 24,000+ term vocabulary)

tcfd_disclosures — structured TCFD disclosure text

One row per company per TCFD topic. See Section 6 for structure.

Column	Description
security_code, company_name_ja	Company identifiers
topic_code, tcfd_pillar, tcfd_topic, topic_name_ja	TCFD topic classification
has_disclosure	TRUE if the company provided non-empty text for this topic
text_raw	Original disclosure text, verbatim — use for citations
text_normalized	Whitespace-normalized version of text_raw, for search

tcfd_topic_master — TCFD pillar/topic reference table

5. ESG Metrics Schema (Data Dictionary)

81 standardized metrics across four categories:

Category	Count	Description
E (Environmental)	41	GHG emissions (Scope 1/2/3 + all 15 Scope 3 categories), energy, water, waste
S (Social)	21	Workforce headcount, diversity, training, turnover, health & safety
G (Governance)	9	Board size, independence, tenure, diversity
FINANCIAL	10	Revenue, EBITDA, net income, market cap, capex, free cash flow, profitability ratios

aggregation_rule tells you how a metric may be combined across companies:

• SUM — an absolute, additive quantity (e.g. total GHG emissions, headcount). Safe to sum across companies or time.
• AVG — a ratio or intensity metric (e.g. a percentage, or a per-employee/per-sales intensity). Never sum these across companies — average them instead. These are flagged is_ratio = TRUE in esg_metric_master.

Full metric list (81 metrics)

Metric Code	Name (EN)	Category	Unit	Aggregation
ELECTRICITY_USED	Electricity Used	E	MWh	SUM
ENERGY_TOTAL	Total Energy Consumption	E	GJ	SUM
GHG_AVOIDED	Avoided Emissions	E	tCO2e	SUM
GHG_INT_ASSET	GHG Intensity per Total Assets	E	tCO2e/JPY	AVG
GHG_INT_EMPLOYEE	GHG Intensity per Employee	E	tCO2e/person	AVG
GHG_INT_SALES	GHG Intensity per Sales	E	tCO2e/JPY	AVG
GHG_SCOPE1	Scope 1 GHG Emissions	E	tCO2e	SUM
GHG_SCOPE2_LOCATION	Scope 2 GHG Emissions	E	tCO2e	SUM
GHG_SCOPE3	Scope 3 GHG Emissions	E	tCO2e	SUM
GHG_SCOPE3_CAT1	Scope 3 Category 1	E	tCO2e	SUM
GHG_SCOPE3_CAT10	Scope 3 Category 10	E	tCO2e	SUM
GHG_SCOPE3_CAT11	Scope 3 Category 11	E	tCO2e	SUM
GHG_SCOPE3_CAT12	Scope 3 Category 12	E	tCO2e	SUM
GHG_SCOPE3_CAT13	Scope 3 Category 13	E	tCO2e	SUM
GHG_SCOPE3_CAT14	Scope 3 Category 14	E	tCO2e	SUM
GHG_SCOPE3_CAT15	Scope 3 Category 15	E	tCO2e	SUM
GHG_SCOPE3_CAT2	Scope 3 Category 2	E	tCO2e	SUM
GHG_SCOPE3_CAT3	Scope 3 Category 3	E	tCO2e	SUM
GHG_SCOPE3_CAT4	Scope 3 Category 4	E	tCO2e	SUM
GHG_SCOPE3_CAT5	Scope 3 Category 5	E	tCO2e	SUM
GHG_SCOPE3_CAT6	Scope 3 Category 6	E	tCO2e	SUM
GHG_SCOPE3_CAT7	Scope 3 Category 7	E	tCO2e	SUM
GHG_SCOPE3_CAT8	Scope 3 Category 8	E	tCO2e	SUM
GHG_SCOPE3_CAT9	Scope 3 Category 9	E	tCO2e	SUM
GHG_SCOPE3_DOWNSTREAM	Scope 3 Downstream Total	E	tCO2e	SUM
GHG_SCOPE3_UPSTREAM	Scope 3 Upstream Total	E	tCO2e	SUM
GHG_TOTAL	Total GHG Emissions (S1+S2)	E	tCO2e	SUM
GHG_TOTAL_SCOPE123	Total GHG Scope 1+2+3	E	tCO2e	SUM
NAT_GAS	Natural Gas Used	E	MWh	SUM
NOX_EMISSIONS	Nitrogen Oxide Emissions	E	tonnes	SUM
OIL_DIESEL	Oil and Diesel Used	E	kL	SUM
PURCHASED_ELECTRICITY	Purchased Electricity	E	MWh	SUM
RENEWABLE_ENERGY	Renewable Energy Use	E	MWh	SUM
SOX_EMISSIONS	Sulphur Oxide Emissions	E	tonnes	SUM
WASTE_GENERATED	Total Waste Generated	E	tonnes	SUM
WASTE_RECYCLED_RATIO	Waste Recycling Ratio	E	%	AVG
WASTE_RECYCLED_VOL	Waste Recycled Volume	E	tonnes	SUM
WATER_DISCHARGED	Water Discharged	E	m3	SUM
WATER_INT_SALES	Water Intensity per Sales	E	m3/JPY	AVG
WATER_RECYCLED	Water Recycled	E	m3	SUM
WATER_WITHDRAWAL	Total Water Withdrawal	E	m3	SUM
AVG_TRAINING_HOURS	Avg Training Hours per Person	S	hours	AVG
AVG_YEARS_SERVICE	Average Years of Service	S	years	AVG
CHILDCARE_LEAVE_MEN	Male Childcare Leave Rate	S	%	AVG
CHILDCARE_LEAVE_WOMEN	Female Childcare Leave Rate	S	%	AVG
EMPLOYEE_SATISFACTION	Employee Satisfaction	S	%	AVG
FEMALE_EMPLOYEE_RATIO	Female Employee Ratio	S	%	AVG
FEMALE_MANAGER_RATIO	Female Manager Ratio	S	%	AVG
FEMALE_NEW_HIRE_RATIO	Female New Hire Ratio	S	%	AVG
HEADCOUNT_FEMALE	Female Employees	S	persons	SUM
HEADCOUNT_NEW_HIRES	Total New Hires	S	persons	SUM
HEADCOUNT_PART_TIME	Part-time / Temporary Employees	S	persons	SUM
HEADCOUNT_PERMANENT	Permanent Employees	S	persons	SUM
HEADCOUNT_TOTAL	Total Employees	S	persons	SUM
HEALTH_CHECK_RATE	Health Check Rate	S	%	AVG
LOST_TIME_RATE	Lost Time Incident Rate	S	per million hrs	AVG
RECORDABLE_INCIDENTS	Recordable Illness/Injury Cases	S	count	SUM
TOTAL_MANAGERS	Total Managers	S	persons	SUM
TOTAL_TRAINING_HOURS	Total Employee Training Hours	S	hours	SUM
TRAINING_SPEND_PER_EMP	Training Spend per Employee	S	JPY	AVG
TURNOVER_RATE	Employee Turnover Rate	S	%	AVG
WOMEN_MANAGERS	Women in Management	S	persons	SUM
BOARD_AVG_AGE	Board Average Age	G	years	AVG
BOARD_AVG_TENURE	Board Average Tenure	G	years	AVG
BOARD_INDEPENDENCE	Board Independence Ratio	G	%	AVG
BOARD_SIZE	Board Size	G	persons	AVG
FEMALE_BOARD_RATIO	Female Board Ratio	G	%	AVG
FOREIGN_BOARD_RATIO	Foreign Directors Ratio	G	%	AVG
INDEPENDENT_DIR_COUNT	Independent Directors Count	G	persons	SUM
OUTSIDE_DIRECTORS	Outside Directors Count	G	persons	SUM
WOMEN_ON_BOARD_COUNT	Women on Board Count	G	persons	SUM
CAPEX	Capital Expenditure	FINANCIAL	百万円	SUM
EBITDA	EBITDA	FINANCIAL	百万円	SUM
FREE_CASH_FLOW	Free Cash Flow	FINANCIAL	百万円	SUM
MARKET_CAP	Market Capitalization	FINANCIAL	百万円	SUM
NET_INCOME	Net Income	FINANCIAL	百万円	SUM
OPERATING_MARGIN	Operating Margin	FINANCIAL	%	AVG
REVENUE	Revenue	FINANCIAL	百万円	SUM
ROA	Return on Assets	FINANCIAL	%	AVG
ROE	Return on Equity	FINANCIAL	%	AVG
TOTAL_ASSETS	Total Assets	FINANCIAL	百万円	SUM

6. TCFD Disclosure Structure

Disclosure text is organized around the four TCFD pillars, broken into 11 topics total:

• Governance — board oversight and management's role in assessing climate-related risks and opportunities
• Strategy — climate-related risks/opportunities and their impact on business, strategy, and financial planning (including scenario analysis)
• Risk Management — processes for identifying, assessing, and managing climate-related risk
• Metrics and Targets — metrics and targets used to assess and manage climate-related risks and opportunities

Each of the 309 companies has one row per topic (11 rows/company). Use has_disclosure to check whether a company published text for a given topic before assuming an absence means "no risk" — it may simply mean no disclosure was found. text_raw is the source of truth for citation; do not paraphrase it as though it were company-authored text without attribution.

7. Access

This dataset is distributed as a Snowflake Secure Share via the Sustainable Labs ESG Data listing on Snowflake Marketplace. Once you've acquired the listing, the shared database appears directly in your account (read-only) — no ETL or file transfer required.

Example query, once the share is mounted (replace <DB> with whatever name you gave the shared database on your account):

-- Scope 1 GHG emissions trend for a specific company
SELECT fiscal_year, value_numeric AS scope1_tco2e
FROM <DB>.MART.FACT_ESG_QUANT_METRIC
WHERE security_code = '7203 JP Equity'
  AND metric_code = 'GHG_SCOPE1'
ORDER BY fiscal_year;

-- Female board ratio across all companies, most recent fiscal year
SELECT c.company_name_en, f.value_numeric AS female_board_ratio_pct
FROM <DB>.MART.FACT_ESG_QUANT_METRIC f
JOIN <DB>.MART.DIM_COMPANY c ON f.security_code = c.security_code
WHERE f.metric_code = 'FEMALE_BOARD_RATIO'
  AND f.fiscal_year = (SELECT MAX(fiscal_year) FROM <DB>.MART.FACT_ESG_QUANT_METRIC)
ORDER BY female_board_ratio_pct DESC;

8. License & Support

Data is provided under the terms of the Snowflake Marketplace listing agreement. For questions about this dataset, licensing, or data sourcing, contact Terrast via terrast.biz.