• Metadata

Consumption per DK36/DK19 Industry Code per hour

Electricity Consumption per DK36/DK19 Industry Code and Day, based on the CVR register.

Consumption for industry codes includes customers with a CVR number only. To ensure sufficiant anonymization, some of the DK36 groups were combined to larger groups.

More information on the Industry Codes can be found on Danmarks Statistics homepage: https://www.dst.dk/da/Statistik/dokumentation/nomenklaturer/dansk-branchekode-db07


Hour UTC

Description

A date and time (interval), shown in UTC time zone, where the values are valid. 00:00 o’clock 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 “T” and the “Z” 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.

Name

HourUTC

Type

datetime

Unit
Size

17

Example

2017-07-14T08:00Z

Validation rules Always full hours, i.e. minutes are 00

Hour DK

Description

A date and time (interval), shown in Danish time zone, where the values are valid. 00:00 o’clock 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 “T” 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.

Name

HourDK

Type

datetime

Unit
Size

17

Example

2017-07-14T08:00

Validation rules Always full hours, i.e. minutes are 00

DK36 Industry Code

Description

xx

Comment

xx

Name

DK36Code

Type

string

Unit

text

Size

10

Example

BA

Validation rules

DK36 Code Title

Description

DK 36 title

Comment

DK 36 title

Name

DK36Title

Type

string

Unit

text

Size

100

Example

Transport

Validation rules

DK19 Industry Code

Description

DK19 Industry Code

Comment

DK19 Industry Code

Name

DK19Code

Type

string

Unit

text

Size

2

Example

A

Validation rules

DK19 Code Title

Description

DK19 Code Title

Comment

DK19 Code Title

Name

DK19Title

Type

string

Unit

text

Size

100

Example

A

Validation rules

Consumption MWh

Description

The consumption measured in MWh

Comment

None

Name

Consumption_MWh

Type

number

Unit

kWh

Size

11.1

Example

23456

Validation rules >=0