Loading...

Consumption per Grid Area Data

Total number of rows: 2,403,023


2020-01-31 22:00Z 2020-01-31 23:00 992 -1,096,743.500 None None
2020-01-31 22:00Z 2020-01-31 23:00 991 786,430.000 None None
2020-01-31 22:00Z 2020-01-31 23:00 990 -9,020.000 None None
2020-01-31 22:00Z 2020-01-31 23:00 962 None 1,018.000 None
2020-01-31 22:00Z 2020-01-31 23:00 960 None 156.000 None
2020-01-31 22:00Z 2020-01-31 23:00 954 None 2,105.000 None
2020-01-31 22:00Z 2020-01-31 23:00 953 None 8,036.000 None
2020-01-31 22:00Z 2020-01-31 23:00 952 None 28,352.800 None
2020-01-31 22:00Z 2020-01-31 23:00 951 None 10,400.000 None
2020-01-31 22:00Z 2020-01-31 23:00 950 None 57.650 None
2020-01-31 22:00Z 2020-01-31 23:00 911 14,907.182 98.660 9,581.390
2020-01-31 22:00Z 2020-01-31 23:00 860 8,991.184 None 7,269.780
2020-01-31 22:00Z 2020-01-31 23:00 856 None 1,950.305 1,048.453
2020-01-31 22:00Z 2020-01-31 23:00 854 None 6,553.439 3,008.475
2020-01-31 22:00Z 2020-01-31 23:00 853 None 3,696.554 2,453.172
2020-01-31 22:00Z 2020-01-31 23:00 791 45,287.032 387,563.337 478,022.901
2020-01-31 22:00Z 2020-01-31 23:00 757 474.180 6,944.670 2,321.980
2020-01-31 22:00Z 2020-01-31 23:00 755 6,163.548 264.012 5,381.230
2020-01-31 22:00Z 2020-01-31 23:00 740 None 229,729.501 171,763.641
2020-01-31 22:00Z 2020-01-31 23:00 592 24.924 567.594 493.449
2020-01-31 22:00Z 2020-01-31 23:00 591 20.093 590.027 153.880
2020-01-31 22:00Z 2020-01-31 23:00 590 12.328 380.266 139.337
2020-01-31 22:00Z 2020-01-31 23:00 589 13.381 749.749 406.940
2020-01-31 22:00Z 2020-01-31 23:00 588 45.681 905.698 175.074
2020-01-31 22:00Z 2020-01-31 23:00 587 20.406 834.610 151.620
2020-01-31 22:00Z 2020-01-31 23:00 584 41.118 1,666.582 3,717.230
2020-01-31 22:00Z 2020-01-31 23:00 554 17,960.075 8,805.199 28,371.412
2020-01-31 22:00Z 2020-01-31 23:00 553 291.523 3,126.619 12,073.858
2020-01-31 22:00Z 2020-01-31 23:00 552 471.838 7,154.033 3,074.880
2020-01-31 22:00Z 2020-01-31 23:00 543 30,905.195 18,362.445 101,603.257
2020-01-31 22:00Z 2020-01-31 23:00 533 6,739.358 7,675.690 32,491.451
2020-01-31 22:00Z 2020-01-31 23:00 532 None 6,345.560 1,773.970
2020-01-31 22:00Z 2020-01-31 23:00 531 4,912.158 2,897.939 13,124.833
2020-01-31 22:00Z 2020-01-31 23:00 512 None 2,350.801 1,420.371
2020-01-31 22:00Z 2020-01-31 23:00 398 981.000 78.510 2,204.546
2020-01-31 22:00Z 2020-01-31 23:00 396 None 1,054.970 601.860
2020-01-31 22:00Z 2020-01-31 23:00 385 1,083.070 42.360 14,279.940
2020-01-31 22:00Z 2020-01-31 23:00 384 854.340 55.310 1,031.900
2020-01-31 22:00Z 2020-01-31 23:00 381 None 681.490 681.340
2020-01-31 22:00Z 2020-01-31 23:00 371 1,025.529 59.703 243.530
2020-01-31 22:00Z 2020-01-31 23:00 370 921.749 102.180 191.520
2020-01-31 22:00Z 2020-01-31 23:00 357 275.937 1,917.193 2,484.620
2020-01-31 22:00Z 2020-01-31 23:00 351 None 7,475.140 27,416.810
2020-01-31 22:00Z 2020-01-31 23:00 348 None 32,807.678 65,533.010
2020-01-31 22:00Z 2020-01-31 23:00 347 17,521.214 1,149.780 22,599.698
2020-01-31 22:00Z 2020-01-31 23:00 344 103,734.249 85,116.970 256,457.284
2020-01-31 22:00Z 2020-01-31 23:00 342 None 4,202.167 2,625.310
2020-01-31 22:00Z 2020-01-31 23:00 341 1,826.160 53.390 10,110.450
2020-01-31 22:00Z 2020-01-31 23:00 331 2,688.798 14,766.490 21,607.110
2020-01-31 22:00Z 2020-01-31 23:00 312 None 4,420.607 None

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 area deducted the consumption of all remote meter reading customers.

Comment

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

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