• Metadata

Datahub Measuring Point Statistics

This extract is a raw extract that can statistics in various ways. The best way of using it is to extract the data and use it in fx a pivot in Excel. Fx by summing the Number of MP for all rows where the Metering Point Type is E17 and Electrical Heating Marking is 1. This way it will tell how many consumers are having electrical heating. Or summing the Number of MP for all rows where Metering Point Type is E18 and Net settlement group is 3. This way it show how many production metering points there is in the commercial market that are not getting subsidiaries.

Dataset is updated every night with current status and stamped with current month.


Month

Description

Year and month

Comment
Name

Month

Type

date

Unit

Months

Size

7

Example

2017-01

Validation rules

Price area

Description

Same as bidding zone. Denmark is divided in two price areas, or bidding zones, divided by the Great Belt. DK1 is west of the Great Belt and DK2 is east of the Great Belt.

Comment

If price area is “DK”, the data covers all Denmark.

Name

PriceArea

Type

string

Unit
Size

3

Example

DK1

Format

DK1 | DK2

Validation rules DK1 or DK2

Grid company

Description

Grid company number according to Danish Energy. Dan-ish Energy is a non-commercial lobby organization for Danish energy companies. Read more about Danish Ener-gy here: https://www.danskenergi.dk/about-danish-energy

Comment
Name

GridCompany

Type

string

Unit

text

Size

3

Example

031

Format
Validation rules between 000 and 999

Grid Company Name

Description

Grid company name according to Danish Energy. Danish Energy is a non-commercial lobby organization for Danish energy companies. Read more about Danish Energy here: https://www.danskenergi.dk/about-danish-energy

Comment
Name

GridCompanyName

Type

string

Unit

text

Size

40

Example

Cerius A/S

Validation rules

Settlement Method

Description

Settlement method is how the whole sales market settles the metering points. The code E01 is only applicable for periods until December 2020

Comment
Name

SettlementMethod

Type

string

Unit

text

Size

4

Example

E01

Validation rules

Settlement Method Description

Description

Settlement method description is the enumerated description of settlement method. Profiled settlement is only applicable for periods until December 2020

Comment
Name

SettlementMethodDesc

Type

string

Unit

text

Size

30

Example

Profiled settled

Validation rules

MP Physical Status

Description

Connection status code

Comment
Name

MP_PhysicalStatus

Type

string

Unit

text

Size

10

Example

E22

Validation rules

MP Physical Status Description

Description

The connection status described the physical connection status. Status new is used until the metering point has been connected the very first time. Hereafter it will either have the status connected or disconnected

Comment
Name

MP_PhysicalStatusDescription

Type

string

Unit

text

Size

12

Example

Connected

Validation rules

MP Type

Description

The metering point code defines the type of metering point and how it is used in the market. For the full list please refer to the DataHub documentation and the guides for the retail market regulation.

Comment
Name

MP_Type

Type

string

Unit

text

Size

3

Example

E17

Validation rules

MP Type Description

Description

Metering Point description is the enumerated description of the metering point. For further description please refer to the DataHub documentation and the guides for the retail market regulation.

Comment
Name

MP_TypeDescription

Type

string

Unit

text

Size

30

Example

Consumption

Validation rules

Meter Reading Occurrence

Description

Meter Reading Occurrence defines the frequency for the reading interval. As of January 2021 only PT15M and PT1H are used. Further information about this is found in the DataHub documentation.

Comment
Name

MeterReadingOccurrence

Type

string

Unit

text

Size

10

Example

P1M

Validation rules

Meter Reading Occurrence Description

Description

Meter Reading Occurrence description is the enumerated description of the Meter Reading Occurrence. For further description and explaination please refer to the DataHub documentation and the guides for the retail market.

Comment
Name

MeterReadingOccurrenceDescription

Type

string

Unit

text

Size

10

Example

Hourly

Validation rules

MP Subtype Description

Description

The MP Subtype Description defines how the metered data is created. If the sub type is Physical the metered data is coming unaltered from the meter. If the sub type is Calculated the meter data is calculated by the DataHub based on other metered data. If the sub type is Virtual the metered data is based on calculations done by the grid operator. Calculated and Virtual are typically used for taxwise net settled metering points.

Comment
Name

MP_SubtypeDesc

Type

string

Unit

text

Size

10

Example

Virtual

Validation rules

Net Settlement Group

Description

Net settlement groups are defining different taxwise settlement methods. Fx is group 6 the yearly net settled tax calculation and 3 is øjebliksafregning. For further information about net settlement rules and øjebliksafregning please refer to the Danish Energy Agency web site www.ens.dk.

Comment
Name

NetSettlementGroup

Type

string

Unit

text

Size

2

Example

4

Validation rules

Electric Heating Marking

Description

Has the meetering point electric heating

Comment

1= yes, 0 = no

Name

ElectricHeatingMarking

Type

string

Unit

text

Size

1

Example

1

Validation rules

Disconnection Type Description

Description

Disconnection Type Description describes how the metering point can be disconnected. Please be aware that a remote disconnection does not mean that it also can be remote re-connected.

Comment
Name

DisconnectionTypeDesc

Type

string

Unit

text

Size

30

Example

Manual disconnection

Validation rules

Number of MP

Description

The number of metering point is a sum of the metering points that are within all the other parameters listed above.

Comment

There are often more than a single metering point per installation. Hence there are more metering points than buildings.

Name

Number_MP

Type

integer

Unit

Number

Size

9

Example

34

Validation rules