Loading...

Consumption per Grid Area Data

Total number of rows: 2,162,071


2019-08-31 21:00Z 2019-08-31 23:00 992 -470,467.200 None None
2019-08-31 21:00Z 2019-08-31 23:00 991 -335,482.300 None None
2019-08-31 21:00Z 2019-08-31 23:00 990 -21,290.000 None None
2019-08-31 21:00Z 2019-08-31 23:00 962 2,412.000 None None
2019-08-31 21:00Z 2019-08-31 23:00 960 90.200 None None
2019-08-31 21:00Z 2019-08-31 23:00 953 1,056.000 None None
2019-08-31 21:00Z 2019-08-31 23:00 952 29,812.200 None None
2019-08-31 21:00Z 2019-08-31 23:00 951 3,900.000 None None
2019-08-31 21:00Z 2019-08-31 23:00 950 52.700 None None
2019-08-31 21:00Z 2019-08-31 23:00 911 10,794.241 None 7,312.530
2019-08-31 21:00Z 2019-08-31 23:00 860 7,821.976 None 7,109.963
2019-08-31 21:00Z 2019-08-31 23:00 856 None 1,766.194 1,150.973
2019-08-31 21:00Z 2019-08-31 23:00 854 422.970 5,096.071 3,231.589
2019-08-31 21:00Z 2019-08-31 23:00 853 None 2,408.401 2,435.999
2019-08-31 21:00Z 2019-08-31 23:00 791 43,415.524 278,415.678 455,467.685
2019-08-31 21:00Z 2019-08-31 23:00 757 767.570 5,248.000 5,179.720
2019-08-31 21:00Z 2019-08-31 23:00 755 5,172.310 0.000 4,663.330
2019-08-31 21:00Z 2019-08-31 23:00 740 None 154,855.482 172,667.623
2019-08-31 21:00Z 2019-08-31 23:00 592 390.213 81.524 632.150
2019-08-31 21:00Z 2019-08-31 23:00 591 420.490 12.170 176.790
2019-08-31 21:00Z 2019-08-31 23:00 590 270.682 20.938 107.681
2019-08-31 21:00Z 2019-08-31 23:00 589 535.840 15.520 308.260
2019-08-31 21:00Z 2019-08-31 23:00 588 593.088 32.898 202.072
2019-08-31 21:00Z 2019-08-31 23:00 587 718.319 38.808 152.068
2019-08-31 21:00Z 2019-08-31 23:00 584 1,340.904 33.316 3,334.470
2019-08-31 21:00Z 2019-08-31 23:00 554 17,960.822 6,599.384 25,959.794
2019-08-31 21:00Z 2019-08-31 23:00 553 2,711.270 444.459 10,498.971
2019-08-31 21:00Z 2019-08-31 23:00 552 2,299.988 3,202.025 2,494.168
2019-08-31 21:00Z 2019-08-31 23:00 543 28,869.325 9,216.372 59,983.892
2019-08-31 21:00Z 2019-08-31 23:00 533 8,204.965 3,005.880 7,066.943
2019-08-31 21:00Z 2019-08-31 23:00 532 None 4,155.180 2,024.120
2019-08-31 21:00Z 2019-08-31 23:00 531 6,044.590 28.735 5,536.692
2019-08-31 21:00Z 2019-08-31 23:00 512 1,386.252 None 511.103
2019-08-31 21:00Z 2019-08-31 23:00 398 875.010 None 1,779.067
2019-08-31 21:00Z 2019-08-31 23:00 396 862.570 45.470 683.940
2019-08-31 21:00Z 2019-08-31 23:00 385 856.870 6.180 4,866.950
2019-08-31 21:00Z 2019-08-31 23:00 384 768.720 None 641.880
2019-08-31 21:00Z 2019-08-31 23:00 381 541.500 49.159 567.230
2019-08-31 21:00Z 2019-08-31 23:00 371 990.540 None 261.540
2019-08-31 21:00Z 2019-08-31 23:00 370 635.414 59.596 193.200
2019-08-31 21:00Z 2019-08-31 23:00 357 1,885.620 None 2,852.880
2019-08-31 21:00Z 2019-08-31 23:00 351 6,580.518 10.720 17,975.070
2019-08-31 21:00Z 2019-08-31 23:00 348 14,844.732 8,201.750 52,190.435
2019-08-31 21:00Z 2019-08-31 23:00 347 15,194.453 77.080 22,697.092
2019-08-31 21:00Z 2019-08-31 23:00 344 138,607.842 2,035.924 167,864.581
2019-08-31 21:00Z 2019-08-31 23:00 342 None 3,422.450 2,028.940
2019-08-31 21:00Z 2019-08-31 23:00 341 1,593.470 38.410 4,458.120
2019-08-31 21:00Z 2019-08-31 23:00 331 11,414.996 820.400 10,772.630
2019-08-31 21:00Z 2019-08-31 23:00 312 1,607.322 None None
2019-08-31 21:00Z 2019-08-31 23:00 245 2,373.318 20,447.247 40,008.229

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’clock 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 “T” and the “Z” 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 Contstraint
Type timestamptz
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’clock 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 “T” 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 Contstraint
Type timestamp
Size 17
Format Regex
Validation Rules Always full hours, i.e. minutes are 00

Grid area

Name Grid area
Description

Grid area number according Danish Energy Association

Comment
Example 031
Unit text
Field GridCompany
Property Contstraint
Type text
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’clock 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 300,00
Unit kWh
Field ResidualConsumption
Property Contstraint
Type float
Size 9.3
Format Regex ([0-9]*[,])[0-9]
Validation Rules >=0

Flex Settled Consumption

Name Flex Settled Consumption
Description

Flex Settled Consumption

Comment

-

Example 100,101
Unit kWh
Field FlexSettledConsumption
Property Contstraint
Type float
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 Contstraint
Type float
Size 9.3
Format Regex
Validation Rules >=0