File definitions
Release information
| File type | Content | Public scope |
|---|---|---|
| Database Overview | Dataset, geography, impact assessment method, impact category and flow catalogs for one version | Catalogs, metadata, reference product quantities and aggregate counts; anonymously accessible |
| ID Correspondence | Dataset ID correspondence and metadata comparison across versions of the same database and model | Retained IDs and differences between the two ID sets; anonymously accessible. No inferred ID changes, splits, merges or substitutions. |
| Change Annex Metadata | Metadata change annex using the same inputs as ID Correspondence | Catalog counts, qualitative changes, dataset ID differences, flow catalog changes and LCIA catalog changes; anonymously accessible |
| Common rule | Definition |
|---|---|
| Unique dataset identification | Database identifier, version, system model and Dataset ID; Activity UUID alone does not identify a dataset |
| Method ID | Composite key of impact assessment method UUID, impact category UUID and category indicator UUID; distinct from Method UUID alone |
| Version suffix | In actual column names, {old} and {new} are replaced by the corresponding versions. AL retains its actual version 1.0. |
| Missing values | Unavailable values remain empty cells; they do not mean zero, false or not applicable. See Known gaps. |
| Comparison boundary | A shared ID does not imply unchanged content. An old-only or new-only ID does not by itself mean business retirement or a new product. |
| Content boundary | Excludes unit process direct exchange amounts, supplier process links, cumulative LCI/LCIA result values, and coefficients of the technosphere matrix A, intervention matrix B or characterization matrix C |
| Special sources | CESI 1.2.0 is a frozen result catalog not yet listed on the data platform. AL 1.0 is a frozen historical baseline. HiQLCD 1.4.1 reuses descriptive metadata from 1.4.0. |
Database Overview
The following is the r2 structure (20261107T020200Z). Only supplied fields are listed; entirely empty columns are omitted. A model worksheet appears only when that model is available in the version.
| Sheet | Scope |
|---|---|
| Read me | Release fields, worksheet catalog and column definitions |
| Cut-off AO | CUT_OFF dataset catalog |
| Consequential AO | CONSEQUENTIAL dataset catalog |
| EN15804 AO | EN_15804 dataset catalog |
| Industries | 41 sector classifications and CUT_OFF dataset counts |
| Geographies | Geographies and recorded parents |
| LCIA Methods | Impact assessment method catalog |
| Impact Categories | Impact category and category indicator catalog |
| Intermediate Exchanges | Reference product flow catalog, excluding process-flow quantity relationships |
| Elementary Exchanges | Elementary flow catalog, excluding unit process direct exchange amounts |
| Known gaps | Recorded source gaps |
Read me
Every file type includes Read me. It contains three blocks: two-column release fields, a Sheet / Content / Rows worksheet catalog, and Sheet / Column / Definition / Unit column definitions.
| Release field | Definition |
|---|---|
| Database | Database identifier |
| Version | Database version |
| System models | System models actually included in the file |
| Release date | Official release date, retaining month precision. Empty when unavailable; not replaced by the attachment revision time. |
| File revision | Attachment revision |
| Generated from | Sources of published catalogs, frozen catalogs, reused metadata and cross-version comparisons |
Known gaps
| Column | Definition |
|---|---|
| Sheet | Worksheet name |
| Column | Column name |
| Affected rows | Records affected by the gap |
| Source rows | Corresponding source record count |
| Issue | Recorded source gaps |
Cut-off AO / Consequential AO / EN15804 AO
The three models use the same column order. CAS Number means Chemical Abstracts Service registry number in all tables below.
| Column | Definition |
|---|---|
| Dataset ID | Dataset ID in the database, version and model |
| Activity UUID | Activity identifier; one activity may have multiple datasets |
| Activity Name | Dataset name in its actual source language |
| Geography | Geographic code |
| Time Period | Original reference period start and end dates; missing dates are not estimated |
| Special Activity Type | Recorded activity type enum and label |
| Industry Classification | Actual HIQ sector classification IDs and names, separated by semicolons for multiple values; not ISIC |
| Product UUID | Reference product flow ID |
| Reference Product Name | Reference product name |
| Unit | Reference product unit |
| Reference Product Amount | Reference product quantity, preserving its original value rather than normalizing it to 1 |
| CAS Number | Recorded reference product CAS number |
Industries
| Column | Definition |
|---|---|
| ID | Sector classification identifier |
| Name | Sector classification name |
| Dataset Count | Dataset IDs deduplicated in this version's Cut-off AO; a dataset is counted under each sector tag. Sector counts must not be summed as a database total. |
Geographies
| Column | Definition |
|---|---|
| ID | Geography identifier |
| Name | Geographic name |
| Shortname | Geographic code or short name |
| Latitude | Recorded latitude |
| Longitude | Recorded longitude |
| Parent Geography | Recorded parent geographic code; represents only the recorded parent-child relation |
LCIA Methods
| Column | Definition |
|---|---|
| Method Name | Impact assessment method name |
| Method UUID | Impact assessment method UUID from the original Method ID; missing components remain empty |
Impact Categories
| Column | Definition |
|---|---|
| Method | Impact assessment method name |
| Category | Impact category name |
| Indicator | Category indicator name |
| Unit | Category indicator unit |
| Method ID | Composite key preserved as the original string; incomplete components are not filled with invented UUIDs |
Intermediate Exchanges
| Column | Definition |
|---|---|
| ID | Intermediate flow ID corresponding to a public reference product |
| Name | Flow name |
| Unit Name | Reference unit name |
| CAS Number | Recorded CAS number |
Elementary Exchanges
| Column | Definition |
|---|---|
| ID | Elementary flow ID |
| Name | Elementary flow name |
| Compartment | Recorded environmental compartment |
| Subcompartment | Recorded environmental subcompartment; remains missing if it cannot be resolved |
| Unit Name | Elementary flow reference unit name |
| CAS Number | Recorded CAS number |
| Formula | Recorded chemical formula |
ID Correspondence
Read me and Known gaps use the Database Overview definitions. Cut-off / Consequential / EN15804 are provided for the available models. Each model has 10 old-version columns, 10 new-version columns, seven field differences, Match Basis and Status, in that order. {old}/{new} are replaced by actual versions.
| Column (actual order) | Definition |
|---|---|
| Dataset ID - {old} | Dataset identifier within the model |
| Activity UUID - {old} | Activity identifier |
| Activity Name - {old} | Activity name |
| Geography - {old} | Geographic code |
| Time Period - Start Date - {old} | Data reference period start date |
| Time Period - End Date - {old} | Data reference period end date |
| Special Activity Type - {old} | Activity type |
| Product UUID - {old} | Reference product flow identifier |
| Reference Product Name - {old} | Reference product name |
| Unit - {old} | Reference unit |
| Dataset ID - {new} | Dataset identifier within the model |
| Activity UUID - {new} | Activity identifier |
| Activity Name - {new} | Activity name |
| Geography - {new} | Geographic code |
| Time Period - Start Date - {new} | Data reference period start date |
| Time Period - End Date - {new} | Data reference period end date |
| Special Activity Type - {new} | Activity type |
| Product UUID - {new} | Reference product flow identifier |
| Reference Product Name - {new} | Reference product name |
| Unit - {new} | Reference unit |
| Activity Name different | Whether the activity name changed |
| Geography different | Whether the geographic code changed |
| Time Period - Start Date different | Whether the reference period start date changed |
| Time Period - End Date different | Whether the reference period end date changed |
| Special Activity Type different | Whether the activity type changed |
| Reference Product Name different | Whether the reference product name changed |
| Unit different | Whether the reference unit changed |
| Match Basis | Match basis |
| Status | Catalog ID or metadata change status |
| Status | Definition |
|---|---|
| matched_id | The old and new dataset IDs match; content is not necessarily identical |
| old_id_only | Present only in the old ID set; not automatically business retirement |
| new_id_only | Present only in the new ID set; not automatically a new product |
| model_added | System model added in the new version; not counted as new products in an existing model |
A difference field is empty, not false, when either value is unknown. A display-language difference is not evidence of a name change. Business-confirmed splits, merges, substitutions, replacement quantities and conversion factors are not provided.
Change Annex Metadata
| Sheet | Scope |
|---|---|
| Read me | Release fields, worksheet catalog and column definitions, as in Database Overview |
| Summary | Catalog counts for the same input sets |
| Qualitative Changes | Metadata field changes in matched datasets |
| Dataset Changes | Dataset ID correspondence and differences between the two ID sets |
| Flow Changes | Flow catalog changes, excluding changes to unit process direct exchanges |
| LCIA Changes | Impact assessment catalog changes, not a comparison of characterization factor or result values |
| Known gaps | Source gaps, as in Database Overview |
Summary
| Column | Definition |
|---|---|
| System Model | System model |
| Metric | Metric: counts of dataset IDs, reference products, geographies, flow catalog entries or method catalog entries |
| Old Value | Old-side count |
| New Value | New-side count |
| Difference | New-side count minus old-side count |
Qualitative Changes
| Column | Definition |
|---|---|
| System Model | System model |
| Dataset ID - {old} | Old-version dataset ID |
| Dataset ID - {new} | New-version dataset ID |
| Field | Changed metadata field |
| Old Value | Old-side field value |
| New Value | New-side field value |
| Match Basis | Match basis; identical IDs use stable_dataset_id |
| Status | Change status of the corresponding record |
Dataset Changes
| Column | Definition |
|---|---|
| System Model | System model |
| Dataset ID - {old} | Old-version dataset ID |
| Dataset ID - {new} | New-version dataset ID |
| Activity Name - {old} | Old-version dataset name |
| Activity Name - {new} | New-version dataset name |
| Geography - {old} | Old-version geographic code |
| Geography - {new} | New-version geographic code |
| Status | ID match or one-sided presence; not automatically business removal or addition |
Flow Changes
| Column | Definition |
|---|---|
| System Model | System model |
| Flow ID | Flow ID |
| Flow Type | Elementary flow or intermediate flow corresponding to a public reference product |
| Field | Changed flow catalog field, such as ID, name, unit, CAS number or compartment |
| New Value | New-side catalog field value |
| Status | Catalog record change status, excluding changes to unit process direct exchanges |
LCIA Changes
| Column | Definition |
|---|---|
| System Model | System model |
| Method ID | Complete composite key of impact assessment method, impact category and category indicator |
| Method - {old} | Old-side impact assessment method name |
| Method - {new} | New-side impact assessment method name |
| Category - {old} | Old-side impact category name |
| Category - {new} | New-side impact category name |
| Indicator - {old} | Old-side category indicator name |
| Indicator - {new} | New-side category indicator name |
| Unit - {old} | Old-side category indicator unit |
| Unit - {new} | New-side category indicator unit |
| Status | Catalog record change status; does not represent numerical changes in characterization factors or LCIA results |