NETWORK_RATING

NETWORK_RATING defines a list of the equipment ratings that may be used as inputs to market constraints. If the rating is flagged as dynamic then in real-time the rating will be dynamically determined and the static value will be used as a fallback value should the dynamic value fail. Note: In some rare cases equipment has ratings provided from more than one TNSP. This is identified by a different SPD Id. The value used in the NEM is normally the more restrictive of the two values.

Column Schema

SPD_ID

ID defining this data source for use in constraints

SQL Type: VARCHAR(21) Polars Type: str

This column is mandatory, and a primary key.

Examples:

• NRAT15_ARKS965
• NRAT15_CNCW6
• NRAT15_CWCN6
• NRAT15_CWKV3W
• NRAT15_DTKV18
• NRAT15_ERNC93
• NRAT15_JNWO060
• NRAT15_KCSS13
• NRAT15_KVCW3W
• NRAT15_KVDT18

VALIDFROM

The date that this record is applies from (inclusive)

SQL Type: DATE Polars Type: pl.Datetime()

This column is mandatory, and a primary key.

Example: 2007/07/09 12:00:00

EQUIPMENTID

A unique identifier for this equipment at this substation, and based on its type

SQL Type: VARCHAR(30) Polars Type: str

This column is not mandatory.

Examples:

• 01
• 0X1
• 996
• 110KV_710
• 110KV_731
• 110KV_732
• 110KV_745/1
• 110KV_746/1
• 110KV_757
• 110KV_758

EQUIPMENTTYPE

The type of equipment. Valid values are: LINE = Line TRANS = Transformer CB = Circuit breaker ISOL = Isolator CAP = Capacitor REAC = Reactor UNIT = Unit

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

This column is not mandatory.

Examples:

• LINE
• TRANS

ISDYNAMIC

One of: 1 = Normally uses dynamic ratings 0 = No dynamic ratings, static ratings are used

SQL Type: NUMBER(1,0) Polars Type: pl.Int8

This column is not mandatory.

Examples: 0, 1

LASTCHANGED

The time that this record was last changed

For more information, see the dedicated documentation page.

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2007/07/09 12:00:00

RATINGLEVEL

The rating level of the value used, one of: NORM = Continuous rating value. Applied under pre-contingent conditions. EMER = Continuous rating value. Applied under pre-contingent conditions LDSH = Load Shedding

SQL Type: VARCHAR(10) Polars Type: str

This column is not mandatory.

Examples:

• EMER
• LDSH
• NORM

REGIONID

The region that this rating is for

For more information, see the dedicated documentation page.

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

• QLD1

• VIC1

• TAS1

• NSW1

• SA1

• SNOWY1

This column is not mandatory.

SUBSTATIONID

The substation the equipment is located at

SQL Type: VARCHAR(30) Polars Type: str

This column is not mandatory.

Examples:

• ANG_CK
• ARMIDALE
• ART
• ATS
• AVON
• BALRANLD
• BAN
• BANNABY
• BATS
• BAYSWATR

VALIDTO

The date that this record applies until (exclusive)

SQL Type: DATE Polars Type: pl.Datetime()

This column is not mandatory.

Example: 2013/05/24 15:55:00

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

# e.g. "2029/03/15 00:05:00"
dt_s_fmt = "%Y/%m/%d %H:%M:%S"

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",
    )
    .with_columns(
        pl.col("VALIDFROM", "LASTCHANGED", "VALIDTO").str.strptime(
            pl.Datetime, dt_s_fmt
        ),
    )
    .cast(
        {
            "SPD_ID": str,
            "EQUIPMENTID": str,
            "EQUIPMENTTYPE": pl.Categorical,
            "ISDYNAMIC": int,  # or pl.Int8
            "RATINGLEVEL": str,
            "REGIONID": pl.Enum(["QLD1", "VIC1", "TAS1", "NSW1", "SA1", "SNOWY1"]),
            "SUBSTATIONID": str,
        }
    )
    # Deduplicate
    # We want one row per ['SPD_ID', 'VALIDFROM']
    # Tie-breaker: greatest value of ['LASTCHANGED']
    .sort(["LASTCHANGED"], descending=False)
    .unique(subset=["SPD_ID", "VALIDFROM"], keep="last")
)

Nemosis

This table is not yet available in Nemosis.

Example File

From PUBLIC_ARCHIVE_NETWORK_RATING_FILE01_202609010000.zip

Table without MetadataTable with MetadataRaw Text without Metadata

SPD_ID	VALIDFROM	VALIDTO	REGIONID	SUBSTATIONID	EQUIPMENTTYPE	EQUIPMENTID	RATINGLEVEL	ISDYNAMIC	LASTCHANGED
TRAT15_TRHA1	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	TREVALYN	LINE	HA_TR1	LDSH	1	2013/05/14 14:15:00
TRAT15_TRHA2	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	TREVALYN	LINE	HA_TR2	LDSH	1	2013/05/14 14:15:00
TRATCN_TRHA1	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	TREVALYN	LINE	HA_TR1	NORM	1	2013/05/14 14:15:00
TRATCN_TRHA2	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	TREVALYN	LINE	HA_TR2	NORM	1	2013/05/14 14:15:00
TRAT15_HANW1	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	HADSPEN	LINE	HA_NW1	LDSH	1	2013/05/14 14:15:00
TRAT15_HANW2	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	HADSPEN	LINE	HA_NW2	LDSH	1	2013/05/14 14:15:00
TRATCN_HANW1	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	HADSPEN	LINE	HA_NW1	NORM	1	2013/05/14 14:15:00
TRATCN_HANW2	2013/05/14 14:15:00	9999/12/31 00:00:00	TAS1	HADSPEN	LINE	HA_NW2	NORM	1	2013/05/14 14:15:00
TRAT15_NWHA1	2013/05/14 14:20:00	9999/12/31 00:00:00	TAS1	NORWOOD	LINE	HA_NW1	LDSH	1	2013/05/14 14:20:00
TRAT15_NWHA2	2013/05/14 14:20:00	9999/12/31 00:00:00	TAS1	NORWOOD	LINE	HA_NW2	LDSH	1	2013/05/14 14:20:00
TRATCN_NWHA2	2013/05/14 14:20:00	9999/12/31 00:00:00	TAS1	NORWOOD	LINE	HA_NW2	NORM	1	2013/05/14 14:20:00
...

C

SETP.WORLD

DVD_NETWORK_RATING

AEMO

PUBLIC

2026/10/09

15:57:07

001791525427234

MONTHLY_ARCHIVE

001791525427234

I

NETWORK

RATING

1

SPD_ID

VALIDFROM

VALIDTO

REGIONID

SUBSTATIONID

EQUIPMENTTYPE

EQUIPMENTID

RATINGLEVEL

ISDYNAMIC

LASTCHANGED

D

NETWORK

RATING

1

TRAT15_TRHA1

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

TREVALYN

LINE

HA_TR1

LDSH

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRAT15_TRHA2

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

TREVALYN

LINE

HA_TR2

LDSH

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRATCN_TRHA1

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

TREVALYN

LINE

HA_TR1

NORM

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRATCN_TRHA2

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

TREVALYN

LINE

HA_TR2

NORM

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRAT15_HANW1

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

HADSPEN

LINE

HA_NW1

LDSH

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRAT15_HANW2

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

HADSPEN

LINE

HA_NW2

LDSH

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRATCN_HANW1

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

HADSPEN

LINE

HA_NW1

NORM

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRATCN_HANW2

2013/05/14 14:15:00

9999/12/31 00:00:00

TAS1

HADSPEN

LINE

HA_NW2

NORM

1

2013/05/14 14:15:00

D

NETWORK

RATING

1

TRAT15_NWHA1

2013/05/14 14:20:00

9999/12/31 00:00:00

TAS1

NORWOOD

LINE

HA_NW1

LDSH

1

2013/05/14 14:20:00

D

NETWORK

RATING

1

TRAT15_NWHA2

2013/05/14 14:20:00

9999/12/31 00:00:00

TAS1

NORWOOD

LINE

HA_NW2

LDSH

1

2013/05/14 14:20:00

D

NETWORK

RATING

1

TRATCN_NWHA2

2013/05/14 14:20:00

9999/12/31 00:00:00

TAS1

NORWOOD

LINE

HA_NW2

NORM

1

2013/05/14 14:20:00

...

C

END OF REPORT

1003

SPD_ID,VALIDFROM,VALIDTO,REGIONID,SUBSTATIONID,EQUIPMENTTYPE,EQUIPMENTID,RATINGLEVEL,ISDYNAMIC,LASTCHANGED
TRAT15_TRHA1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR1,LDSH,1,"2013/05/14 14:15:00"
TRAT15_TRHA2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR2,LDSH,1,"2013/05/14 14:15:00"
TRATCN_TRHA1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR1,NORM,1,"2013/05/14 14:15:00"
TRATCN_TRHA2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR2,NORM,1,"2013/05/14 14:15:00"
TRAT15_HANW1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW1,LDSH,1,"2013/05/14 14:15:00"
TRAT15_HANW2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW2,LDSH,1,"2013/05/14 14:15:00"
TRATCN_HANW1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW1,NORM,1,"2013/05/14 14:15:00"
TRATCN_HANW2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW2,NORM,1,"2013/05/14 14:15:00"
TRAT15_NWHA1,"2013/05/14 14:20:00","9999/12/31 00:00:00",TAS1,NORWOOD,LINE,HA_NW1,LDSH,1,"2013/05/14 14:20:00"
TRAT15_NWHA2,"2013/05/14 14:20:00","9999/12/31 00:00:00",TAS1,NORWOOD,LINE,HA_NW2,LDSH,1,"2013/05/14 14:20:00"
TRATCN_NWHA2,"2013/05/14 14:20:00","9999/12/31 00:00:00",TAS1,NORWOOD,LINE,HA_NW2,NORM,1,"2013/05/14 14:20:00"
...

Raw Text with Metadata

C,SETP.WORLD,DVD_NETWORK_RATING,AEMO,PUBLIC,2026/10/09,15:57:07,001791525427234,MONTHLY_ARCHIVE,001791525427234
I,NETWORK,RATING,1,SPD_ID,VALIDFROM,VALIDTO,REGIONID,SUBSTATIONID,EQUIPMENTTYPE,EQUIPMENTID,RATINGLEVEL,ISDYNAMIC,LASTCHANGED
D,NETWORK,RATING,1,TRAT15_TRHA1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR1,LDSH,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRAT15_TRHA2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR2,LDSH,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRATCN_TRHA1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR1,NORM,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRATCN_TRHA2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,TREVALYN,LINE,HA_TR2,NORM,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRAT15_HANW1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW1,LDSH,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRAT15_HANW2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW2,LDSH,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRATCN_HANW1,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW1,NORM,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRATCN_HANW2,"2013/05/14 14:15:00","9999/12/31 00:00:00",TAS1,HADSPEN,LINE,HA_NW2,NORM,1,"2013/05/14 14:15:00"
D,NETWORK,RATING,1,TRAT15_NWHA1,"2013/05/14 14:20:00","9999/12/31 00:00:00",TAS1,NORWOOD,LINE,HA_NW1,LDSH,1,"2013/05/14 14:20:00"
D,NETWORK,RATING,1,TRAT15_NWHA2,"2013/05/14 14:20:00","9999/12/31 00:00:00",TAS1,NORWOOD,LINE,HA_NW2,LDSH,1,"2013/05/14 14:20:00"
D,NETWORK,RATING,1,TRATCN_NWHA2,"2013/05/14 14:20:00","9999/12/31 00:00:00",TAS1,NORWOOD,LINE,HA_NW2,NORM,1,"2013/05/14 14:20:00"
...
C,"END OF REPORT",1003

Availability

Visibility: Public

This table is in the public monthly MMSDM archive.

I have collated the list of all those files into one place, in this CSV metadata file. (Columns year, month, url, compressed_size in bytes).

The earliest available data is month 8 of 2024. The most recent available data is month 9 of 2026.

Every month in between has a file. (No gaps.)

Data Size

Each year of data is approximately 645 KB when zipped, 6 MB as unzipped CSV.

Deduplication and PDR Loader Configuration

The primary keys are:

• SPD_ID

• VALIDFROM

The transaction type is "INSERT-UPDATE", which means that you will likely see duplicate data with different values.

You should deduplicate by sorting based on LASTCHANGED, within each group of primary keys.

PDR Loader configuration is:

Report Name	Report Subtype	Version
NETWORK	RATING	1

This means that the CSV files start with metadata columns:

I,NETWORK,RATING,1,...
D,NETWORK,RATING,1,...

ROW_FILTER_TYPE is LASTCHANGED

Indexes

• LASTCHANGED

Links

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

Download a JSON Schema specification for this table.

Official AEMO schema documentation

Other Information

Package: NETWORK

Copy as Markdown