Hour UTC

Name

Hour UTC

Description

A date and time (interval), shown in UTC time zone, where the values are valid. 00:00 o\u2019clock is the first hour of a given day interval 00:00 - 00:59 and 01:00 covers the second hour (interval) of the day and so forth. Please note: The naming is based on the length of the interval of the finest grain of the resolution.

Comment

Please note that the format shown in the example applies to data download as JSON, XML or fetched through the API and is in accordance with the ISO 8601 standard.
The format is slightly different when it is shown on screen or downloaded manually as CSV or XLSX. This is mainly due to readability and consideration for Excel users.

In preview (in the GUI) all timestamps are shown as (display convention)
YYYY-MM-DD hh:mmZ
e.g. 2017-07-14 08:00Z.
The Z will remind viewers that this is UTC.

In download (CSV and XLSX) the date time are exported as
YYYY-MM-DD hh:mm
e.g. 2017-07-14 08:00.
That is without the \u201cT\u201d and the \u201cZ\u201d and the seconds. Excel will recognize it as date-time. The user must remember the convention about time zones.

In download (JSON and XML) the full format is used
YYYY-MM-DDThh:mmZ
e.g. 2017-07-14T08:00Z.

Example

2017-07-14T08:00Z

Unit

Field

HourUTC

Property Constraint

Type

datetime

Size

17

Format Regex

Validation Rules

Always full hours, i.e. minutes are 00

Hour DK

Name

Hour DK

Description

A date and time (interval), shown in Danish time zone, where the values are valid. 00:00 o\u2019clock is the first hour of a given day, interval 00:00 - 00:59, and 01:00 covers the second hour period (interval) of the day and so forth.

Comment

On one normal day there will be 24 intervals.

When daylight saving times shifts there will be either 23 or 25 intervals.

Please note that the format shown in the example applies to data download as JSON, XML or fetched through the API and is in accordance with the ISO 8601 standard.
The format is slightly different when it is shown on screen or downloaded manually as CSV or XLSX. This is mainly due to readability and consideration for Excel users.

In preview (in the GUI) all timestamps are shown as (display convention)
YYYY-MM-DD hh:mm
e.g. 2017-07-14 08:00.
Please note that is no time zone indicator, showning that this is local (Danish) time.

In download (CSV and XLSX) the date time are exported as
YYYY-MM-DD hh:mm
e.g. 2017-07-14 08:00.
That is without the \u201cT\u201d and the seconds. Excel will recognize it as date-time. The user must remember that this is local (Danish) time.

In download (JSON and XML) the format used is
YYYY-MM-DDThh:mm
e.g. 2017-07-14T08:00.

Example

2017-07-14T08:00

Unit

Field

HourDK

Property Constraint

Type

datetime

Size

17

Format Regex

Validation Rules

Always full hours, i.e. minutes are 00

Price area

Name

Price area

Description

DK1 is Jutland and Fyen and DK2 is Zealand and islands

Comment

DK1 and DK2 are the standard abbreviation for the two Danish price areas

Example

DK1

Unit

Field

PriceArea

Property Constraint

Type

string

Size

3

Format Regex

Validation Rules

DK1 or DK2

Total load

Name

Total load

Description

Sum of the consumption incl. transmission loss

Comment

Example

184.3

Unit

MWh per hour

Field

TotalLoad

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Biomass

Name

Biomass

Description

Sum of production from power plants with Biomass as main fuel

Comment

Example

184.3

Unit

MWh per hour

Field

Biomass

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Fossil gas

Name

Fossil gas

Description

Sum of production from power plants with fossil gas as main fuel

Comment

Example

184.3

Unit

MWh per hour

Field

FossilGas

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Fossil hard coal

Name

Fossil hard coal

Description

Sum of production from power plants with Fossil Hard Coal as main fuel

Comment

Example

184.3

Unit

MWh per hour

Field

FossilHardCoal

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Fossil oil

Name

Fossil oil

Description

Sum of production from power plants with fossil oil as main fuel

Comment

Example

184.3

Unit

MWh per hour

Field

FossilOil

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Hydro power

Name

Hydro power

Description

Sum of production from hydro power plants

Comment

Example

184.3

Unit

MWh per hour

Field

HydroPower

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Other renewable

Name

Other renewable

Description

Sum of production from power plant with other fuels as main fuel

Comment

Example

184.3

Unit

MWh per hour

Field

OtherRenewable

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Solar power

Name

Solar power

Description

Electricity production from Solar power

Comment

-

Example

184.3

Unit

MWh per hour

Field

SolarPower

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Waste

Name

Waste

Description

Sum of production from power plant with waste as main fuel

Comment

Example

184.3

Unit

MWh per hour

Field

Waste

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Onshore wind power

Name

Onshore wind power

Description

Electricity production from onshore wind power

Comment

Example

184.3

Unit

MWh per hour

Field

OnshoreWindPower

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Offshore wind power

Name

Offshore wind power

Description

Electricity production from offshore wind power

Comment

Example

184.3

Unit

MWh per hour

Field

OffshoreWindPower

Property Constraint

Type

number

Size

9.1

Format Regex

Validation Rules

>=0

Exchange continent

Name

Exchange continent

Description

Exchange of electricity towards continental Europe

Comment

A positive exchange is import of electricity, while a negative is export.

Both DK1 and DK2 are only connected to Germany until 2019, where DK1 also will be connected the the Netherlands through the COBRA connection.

Example

15

Unit

MWh per hour

Field

ExchangeContinent

Property Constraint

Type

integer

Size

9

Format Regex

Validation Rules

Exchange Great Belt

Name

Exchange Great Belt

Description

Exchange of electricity over the Great Belt connection between DK1 and DK2

Comment

A positive exchange is import of electricity, while a negative is export.

Example

15.1

Unit

MWh per hour

Field

ExchangeGreatBelt

Property Constraint

Type

integer

Size

9

Format Regex

Validation Rules

Exchange Nordic countries

Name

Exchange Nordic countries

Description

Exchange of electricity towards Norway and Sweden.

Comment

A positive exchange is import of electricity, while a negative is export.

DK1 are connected to both Norway and Sweden, DK2 only to Sweden

Example

15

Unit

MWh per hour

Field

ExchangeNordicCountries

Property Constraint

Type

integer

Size

9

Format Regex

Validation Rules

Energinet has a lot of energy data and through Energi Data Service, we want to make these data available. The portal will be expanded regularly. We hope you will join us on the journey, and will contribute with advice and feedback.