Consumption per Municipality and DE35 industry codes

Monthly consumption divided on the 98 Danish municipalities and the 35 Danish Energy categories known as DE35 Industry Codes.


Month

Description

Year and month

Comment
Name

Month

Type

date

Unit

Months

Size

7

Example

2017-01

Property constraint
Validation rules

Municipality number

Description

Each of the 98 Danish municipalities has a unique number, ranging from 101 Copenhagen to 860 Hj\u00f8rring.

Comment

A list with the unique numbers can be found here: https://skat.dk/skat.aspx?oid=2276646

Name

MunicipalityNo

Type

string

Unit

Coded

Size

3

Example

101

Property constraint
Validation rules

Industry code, DE35

Description

The Industry Code DE35 is owned and maintained by Danish Energy, a non-commercial lobby organization for Danish energy companies. The code is used by Danish energy companies, but other business codes can be used as well, i.e. Industry Code DE61. Data published here will follow the Industry Code DE35. Otherwise the field will be set as \u201cUkendt\u201d according to rules listed below. The field is updated every month on the 10th, 20th and 28th day at 6:30am.
The rules are: A) If less than 3 digits or more than 4 digits, it is set as \u201cUkendt\u201d. B) If 4 digits, the code it is based on the Industry Code DE61, where the first three digits are like the Industry Code DE35. C) If the 3 digits do not match a DE35 code, it is set as “Ukendt”. After the dataset has been appointed a DE35 Industry Code according to the rules listed above it undergoes an Anonymization Process: A) If the number of Measurement Points in a mu-nicipality and industry is under 10, the DE35 In-dustry Code will be changed to \u201cUkendt\u201d. B) If the number of Measurement Points is under 10 in a municipality where the DE35 Industry Code is \u201cUkendt\u201d the Municipality Number will be changed to \u201cUkendt\u201d as well. DE35 Industry Codes: The description of the Industry Codes is listed in the dataset “DE35 Industry Codes”.

Comment
Name

Industrycode_DE35

Type

string

Unit

Coded

Size

3

Example

131

Property constraint
Validation rules

MeasurementPoints

Description

Grid operators collect readings from measurement points for all 3.3 million electricity consumers in Denmark. The readings are send to Energinets DataHub. This field shows the number of measurements points within a municipality and for each DE35 Industry Code.

Comment
Name

MeasurementPoints

Type

integer

Unit

Number

Size

6

Example
Property constraint
Validation rules

Total consumption

Description

Total electricity consumption in kWh

Comment
Name

TotalCon

Type

integer

Unit

kWh

Size

9

Example

543,45

Format

([0-9]*[,])[0-9][0-9]

Property constraint
Validation rules

=0