CO2EII_AVAILABLE_GENERATORS

This table contains contain CO2 emissions intensity information, and simple fuel type per generator (DUID), as well as region information.

Warning

This table is missing from AEMO's documentation. The information here is my best guess from looking at the data.

Column Schema

DUID

NEM Dispatchable Unit Identifier

Warning

This column may contain funny characters such as / (slash) or # (hash). This may break hive-style partitioning.

For more information, see the dedicated documentation page.

SQL Type: VARCHAR2(20) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Examples:

• W/HOE#2
• ER03
• ER04
• HUMEV

GENSETID

Physical unit identifier

SQL Type: VARCHAR2(20) Polars Type: pl.Categorical

This column is mandatory, and a primary key.

Examples:

• APPIN
• AVLSF1
• BANGOWF1
• BANGOWF2

REGIONID

Region identifier that unit is in

For more information, see the dedicated documentation page.

The SQL type is VARCHAR2(4). This is actually a factor/enum, with values:

• QLD1

• VIC1

• TAS1

• NSW1

• SA1

• SNOWY1

This column is mandatory, and a primary key.

STATIONNAME

SQL Type: VARCHAR2(80) Polars Type: str

This column is mandatory, and a primary key.

Examples:

• Beryl Solar Farm
• Bayswater Power Station
• Hume (NSW) Hydro Power Station

CO2E_DATA_SOURCE

Data source for CO2E_ENERGY_SOURCE.

SQL Type: VARCHAR(30) Polars Type: str

This column is mandatory (but not a primary key).

Examples:

• ISP 2020
• ISP2022
• Estimate - Other
• NGA 2024

CO2E_EMISSIONS_FACTOR

SQL Type: NUMBER(1,8) Polars Type: pl.Float64

This column is mandatory (but not a primary key).

CO2E_ENERGY_SOURCE

The asset's fuel type

Warning

Since this table isn't documented, these values may change. New choices may be added. So be careful when using this data.

SQL Type: VARCHAR(40) Polars Type: pl.Categorical

This column is mandatory (but not a primary key).

Examples:

• Bagasse
• Battery Storage
• Biomass and industrial materials
• Black coal
• Coal mine waste gas
• Diesel oil
• Ethane
• Kerosene - non aviation
• Hydro
• Landfill biogas methane

Code Examples

Polars

Casting is enums, categoricals etc is not essential, but may speed up parsing. Swapping int for pl.UInt16, pl.Int32 would also speed up parsing. However some of the datatypes are inferred, so they may be wrong.

This code deduplicates for you. Deduplication is normally only required across multiple months.

This code assumes that all columns are present, which may not be true for older files.

import polars as pl
import polars.selectors as cs

csv_paths = ["SOMEFILE.CSV", "OTHERFILE.CSV"]

lf = (
    pl.concat(
        [
            pl.scan_csv(
                csv_path,  # must be unzipped beforehand
                skip_rows=1,  # skip the header
                infer_schema=False,  # much faster
            )
            .filter(cs.by_index(0) == "D")  # drop the footer
            .select(~cs.by_index(range(4)))  # drop metadata columns
            for csv_path in csv_paths
        ],
        how="diagonal_relaxed",
    ).cast(
        {
            "DUID": pl.Categorical,
            "GENSETID": pl.Categorical,
            "REGIONID": pl.Enum(["QLD1", "VIC1", "TAS1", "NSW1", "SA1", "SNOWY1"]),
            "STATIONNAME": str,
            "CO2E_DATA_SOURCE": str,
            "CO2E_EMISSIONS_FACTOR": pl.Float64,
            "CO2E_ENERGY_SOURCE": pl.Categorical,
        }
    )
    # Deduplicate
    # We want one row per ['STATIONNAME', 'DUID', 'GENSETID', 'REGIONID']
    .unique(subset=["STATIONNAME", "DUID", "GENSETID", "REGIONID"], keep="any")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From CO2EII_AVAILABLE_GENERATORS.CSV

Table without MetadataTable with MetadataRaw Text without Metadata

STATIONNAME	DUID	GENSETID	REGIONID	CO2E_EMISSIONS_FACTOR	CO2E_ENERGY_SOURCE	CO2E_DATA_SOURCE
Appin Power Plant	APPIN	APPIN	NSW1	0.56318004	Coal seam methane	NGA 2024
Avonlie Solar Farm	AVLSF1	AVLSF1	NSW1	0.00000000	Solar	ISP2024
Bango 973 Wind Farm	BANGOWF1	BANGOWF1	NSW1	0.00000000	Wind	ISP2024
Bango 999 Wind Farm	BANGOWF2	BANGOWF2	NSW1	0.00000000	Wind	ISP2024
Burrendong Hydro Power Station	BDONGHYD	BDONGHYD	NSW1	0.00000000	Hydro	ISP2024
Beryl Solar Farm	BERYLSF1	BERYLSF1	NSW1	0.00000000	Solar	ISP2024
Broken Hill Battery Energy Storage System	BHB1	BHB1	NSW1	0.00000000	Battery Storage	ISP2024
Blowering Power Station	BLOWERNG	BLOWERNG	NSW1	0.00000000	Hydro	ISP2024
Boco Rock Wind Farm	BOCORWF1	BOCORWF1	NSW1	0.00000000	Wind	ISP2024
Bodangora Wind Farm	BODWF1	BODWF1	NSW1	0.00000000	Wind	ISP2024
Bomen Solar Farm	BOMENSF1	BOMENSF1	NSW1	0.00000000	Solar	ISP2024
...

C	SETP.WORLD	CO2EII_AVAILABLE_GENERATORS_WEB	AEMO	PUBLIC	2026/10/28	13:50:06	0000000545333005		0000000545332986
I	CO2EII	PUBLISHING	1	STATIONNAME	DUID	GENSETID	REGIONID	CO2E_EMISSIONS_FACTOR	CO2E_ENERGY_SOURCE	CO2E_DATA_SOURCE
D	CO2EII	PUBLISHING	1	Appin Power Plant	APPIN	APPIN	NSW1	0.56318004	Coal seam methane	NGA 2024
D	CO2EII	PUBLISHING	1	Avonlie Solar Farm	AVLSF1	AVLSF1	NSW1	0.00000000	Solar	ISP2024
D	CO2EII	PUBLISHING	1	Bango 973 Wind Farm	BANGOWF1	BANGOWF1	NSW1	0.00000000	Wind	ISP2024
D	CO2EII	PUBLISHING	1	Bango 999 Wind Farm	BANGOWF2	BANGOWF2	NSW1	0.00000000	Wind	ISP2024
D	CO2EII	PUBLISHING	1	Burrendong Hydro Power Station	BDONGHYD	BDONGHYD	NSW1	0.00000000	Hydro	ISP2024
D	CO2EII	PUBLISHING	1	Beryl Solar Farm	BERYLSF1	BERYLSF1	NSW1	0.00000000	Solar	ISP2024
D	CO2EII	PUBLISHING	1	Broken Hill Battery Energy Storage System	BHB1	BHB1	NSW1	0.00000000	Battery Storage	ISP2024
D	CO2EII	PUBLISHING	1	Blowering Power Station	BLOWERNG	BLOWERNG	NSW1	0.00000000	Hydro	ISP2024
D	CO2EII	PUBLISHING	1	Boco Rock Wind Farm	BOCORWF1	BOCORWF1	NSW1	0.00000000	Wind	ISP2024
D	CO2EII	PUBLISHING	1	Bodangora Wind Farm	BODWF1	BODWF1	NSW1	0.00000000	Wind	ISP2024
D	CO2EII	PUBLISHING	1	Bomen Solar Farm	BOMENSF1	BOMENSF1	NSW1	0.00000000	Solar	ISP2024
...
C	END OF REPORT	633

STATIONNAME,DUID,GENSETID,REGIONID,CO2E_EMISSIONS_FACTOR,CO2E_ENERGY_SOURCE,CO2E_DATA_SOURCE
"Appin Power Plant",APPIN,APPIN,NSW1,0.56318004,"Coal seam methane","NGA 2024"
"Avonlie Solar Farm",AVLSF1,AVLSF1,NSW1,0.00000000,Solar,ISP2024
"Bango 973 Wind Farm",BANGOWF1,BANGOWF1,NSW1,0.00000000,Wind,ISP2024
"Bango 999 Wind Farm",BANGOWF2,BANGOWF2,NSW1,0.00000000,Wind,ISP2024
"Burrendong Hydro Power Station",BDONGHYD,BDONGHYD,NSW1,0.00000000,Hydro,ISP2024
"Beryl Solar Farm",BERYLSF1,BERYLSF1,NSW1,0.00000000,Solar,ISP2024
"Broken Hill Battery Energy Storage System",BHB1,BHB1,NSW1,0.00000000,"Battery Storage",ISP2024
"Blowering Power Station",BLOWERNG,BLOWERNG,NSW1,0.00000000,Hydro,ISP2024
"Boco Rock Wind Farm",BOCORWF1,BOCORWF1,NSW1,0.00000000,Wind,ISP2024
"Bodangora Wind Farm",BODWF1,BODWF1,NSW1,0.00000000,Wind,ISP2024
"Bomen Solar Farm",BOMENSF1,BOMENSF1,NSW1,0.00000000,Solar,ISP2024
...

Raw Text with Metadata

C,SETP.WORLD,CO2EII_AVAILABLE_GENERATORS_WEB,AEMO,PUBLIC,2026/10/28,13:50:06,0000000545333005,,0000000545332986
I,CO2EII,PUBLISHING,1,STATIONNAME,DUID,GENSETID,REGIONID,CO2E_EMISSIONS_FACTOR,CO2E_ENERGY_SOURCE,CO2E_DATA_SOURCE
D,CO2EII,PUBLISHING,1,"Appin Power Plant",APPIN,APPIN,NSW1,0.56318004,"Coal seam methane","NGA 2024"
D,CO2EII,PUBLISHING,1,"Avonlie Solar Farm",AVLSF1,AVLSF1,NSW1,0.00000000,Solar,ISP2024
D,CO2EII,PUBLISHING,1,"Bango 973 Wind Farm",BANGOWF1,BANGOWF1,NSW1,0.00000000,Wind,ISP2024
D,CO2EII,PUBLISHING,1,"Bango 999 Wind Farm",BANGOWF2,BANGOWF2,NSW1,0.00000000,Wind,ISP2024
D,CO2EII,PUBLISHING,1,"Burrendong Hydro Power Station",BDONGHYD,BDONGHYD,NSW1,0.00000000,Hydro,ISP2024
D,CO2EII,PUBLISHING,1,"Beryl Solar Farm",BERYLSF1,BERYLSF1,NSW1,0.00000000,Solar,ISP2024
D,CO2EII,PUBLISHING,1,"Broken Hill Battery Energy Storage System",BHB1,BHB1,NSW1,0.00000000,"Battery Storage",ISP2024
D,CO2EII,PUBLISHING,1,"Blowering Power Station",BLOWERNG,BLOWERNG,NSW1,0.00000000,Hydro,ISP2024
D,CO2EII,PUBLISHING,1,"Boco Rock Wind Farm",BOCORWF1,BOCORWF1,NSW1,0.00000000,Wind,ISP2024
D,CO2EII,PUBLISHING,1,"Bodangora Wind Farm",BODWF1,BODWF1,NSW1,0.00000000,Wind,ISP2024
D,CO2EII,PUBLISHING,1,"Bomen Solar Farm",BOMENSF1,BOMENSF1,NSW1,0.00000000,Solar,ISP2024
...
C,"END OF REPORT",633

Availability

This table is not in the public monthly MMSDM archive. It is publicly available in an unusual location.

Deduplication and PDR Loader Configuration

The primary keys are:

• STATIONNAME

• DUID

• GENSETID

• REGIONID

PDR Loader configuration is:

Report Name	Report Subtype	Version
CO2EII	PUBLISHING	1

This means that the CSV files start with metadata columns:

I,CO2EII,PUBLISHING,1,...
D,CO2EII,PUBLISHING,1,...

Links

This page as JSON (schema documented here, but may change)

Download a JSON Schema specification for this table.

Other Information

This table is not part of a package.

Copy as Markdown