Loading...

Consumption per Grid Area Data

Total number of rows: 2,538,073


2020-04-30 21:00Z 2020-04-30 23:00 992 1,249,502.500 None None
2020-04-30 21:00Z 2020-04-30 23:00 991 -1,742,527.900 None None
2020-04-30 21:00Z 2020-04-30 23:00 990 25,540.000 None None
2020-04-30 21:00Z 2020-04-30 23:00 962 None 6,299.000 None
2020-04-30 21:00Z 2020-04-30 23:00 960 None 636.000 None
2020-04-30 21:00Z 2020-04-30 23:00 954 None 8,117.000 None
2020-04-30 21:00Z 2020-04-30 23:00 953 None 17,408.000 None
2020-04-30 21:00Z 2020-04-30 23:00 952 None 35,585.700 None
2020-04-30 21:00Z 2020-04-30 23:00 951 None 3,000.000 None
2020-04-30 21:00Z 2020-04-30 23:00 950 None 64.600 None
2020-04-30 21:00Z 2020-04-30 23:00 911 12,693.785 1,184.990 8,062.855
2020-04-30 21:00Z 2020-04-30 23:00 860 8,232.881 2.326 7,549.926
2020-04-30 21:00Z 2020-04-30 23:00 854 None 5,648.039 2,959.041
2020-04-30 21:00Z 2020-04-30 23:00 853 None 2,846.365 2,908.735
2020-04-30 21:00Z 2020-04-30 23:00 791 36,232.895 362,576.763 401,821.834
2020-04-30 21:00Z 2020-04-30 23:00 757 535.390 5,996.100 2,439.200
2020-04-30 21:00Z 2020-04-30 23:00 755 5,486.186 246.452 5,079.982
2020-04-30 21:00Z 2020-04-30 23:00 740 None 197,018.161 173,723.338
2020-04-30 21:00Z 2020-04-30 23:00 584 67.804 2,605.766 4,450.810
2020-04-30 21:00Z 2020-04-30 23:00 543 41,702.230 37,551.185 113,208.756
2020-04-30 21:00Z 2020-04-30 23:00 533 3,355.595 9,266.040 7,098.150
2020-04-30 21:00Z 2020-04-30 23:00 532 None 4,981.380 1,735.940
2020-04-30 21:00Z 2020-04-30 23:00 531 4,075.517 2,702.245 8,034.151
2020-04-30 21:00Z 2020-04-30 23:00 512 None 1,762.649 1,021.674
2020-04-30 21:00Z 2020-04-30 23:00 398 841.430 77.460 3,092.034
2020-04-30 21:00Z 2020-04-30 23:00 396 None 932.690 633.810
2020-04-30 21:00Z 2020-04-30 23:00 385 813.930 33.930 5,072.140
2020-04-30 21:00Z 2020-04-30 23:00 384 787.390 33.870 934.870
2020-04-30 21:00Z 2020-04-30 23:00 381 None 599.780 864.500
2020-04-30 21:00Z 2020-04-30 23:00 371 908.450 38.110 222.210
2020-04-30 21:00Z 2020-04-30 23:00 370 780.129 116.770 161.760
2020-04-30 21:00Z 2020-04-30 23:00 357 296.737 1,813.353 3,598.520
2020-04-30 21:00Z 2020-04-30 23:00 351 None 6,735.920 19,939.680
2020-04-30 21:00Z 2020-04-30 23:00 348 None 26,673.499 61,056.220
2020-04-30 21:00Z 2020-04-30 23:00 347 10,439.877 5,950.052 26,593.408
2020-04-30 21:00Z 2020-04-30 23:00 344 44,093.633 113,928.552 189,375.411
2020-04-30 21:00Z 2020-04-30 23:00 342 None 3,804.645 2,700.550
2020-04-30 21:00Z 2020-04-30 23:00 341 1,654.330 49.930 5,065.740
2020-04-30 21:00Z 2020-04-30 23:00 331 1,245.205 13,281.220 15,045.420
2020-04-30 21:00Z 2020-04-30 23:00 312 None 2,268.829 None
2020-04-30 21:00Z 2020-04-30 23:00 245 None 27,172.993 46,159.915
2020-04-30 21:00Z 2020-04-30 23:00 244 5,178.443 54,443.417 103,729.670
2020-04-30 21:00Z 2020-04-30 23:00 233 3,431.651 48,253.343 39,561.188
2020-04-30 21:00Z 2020-04-30 23:00 154 None 7,685.678 8,073.267
2020-04-30 21:00Z 2020-04-30 23:00 152 4,322.673 9,068.392 22,574.567
2020-04-30 21:00Z 2020-04-30 23:00 151 None 67,845.487 70,667.805
2020-04-30 21:00Z 2020-04-30 23:00 141 1,398.170 51.110 3,615.820
2020-04-30 21:00Z 2020-04-30 23:00 131 35,437.044 153,299.459 244,331.756
2020-04-30 21:00Z 2020-04-30 23:00 085 231.270 1,119.610 179.120
2020-04-30 21:00Z 2020-04-30 23:00 084 15.420 1,412.230 708.900

Data Dictionary

Column Type Label Description
HourUTC timestamptz
HourDK timestamp
GridCompany text
ResidualConsumption float8
FlexSettledConsumption float8
HourlySettledConsumption float8

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

Grid company

Name Grid company
Description

Grid area number according Danish Energy Association

Comment
Example 031
Unit text
Field GridCompany
Property Constraint
Type string
Size 3
Format Regex
Validation Rules >000 and <= 999

Residual Consumption

Name Residual Consumption
Description

The residual consumption is calculated hour by hour and consists of the total consumption of the individual grid areas deducted the consumption of all remote meter reading customers for the individual grid areas.

Comment

The first hour of a day is from 00:00 to 00:59 represented as YYYY-MM-DD 00:00 and the second hour is from 01:00 to 01:59 represented as YYYY-MM-DD 01:00 and so forth.

Example 184.301
Unit kWh
Field ResidualConsumption
Property Constraint
Type number
Size 9.3
Format Regex
Validation Rules >=0

Flex Settled Consumption

Name Flex Settled Consumption
Description

Flex Settled Consumption

Comment
Example 100,101
Unit kWh
Field FlexSettledConsumption
Property Constraint
Type number
Size 9.3
Format Regex
Validation Rules >=0

Hourly Settled Consumption

Name Hourly Settled Consumption
Description

Hourly Settled Consumption

Comment

-

Example 100,502
Unit kWh
Field HourlySettledConsumption
Property Constraint
Type number
Size 9.3
Format Regex
Validation Rules >=0