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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 | |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| Validation rules |
MP Physical Status
| Description | Connection status code |
|---|---|
| Comment | |
| Name | MP_PhysicalStatus |
| Type | string |
| Unit | text |
| Size | 10 |
| Example | E22 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| 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 |
| Property constraint | |
| Validation rules |