Loading...

Gas composition and quality for transmission Data

Total number of rows: 61,732


2020-02-24 10:00Z 2020-02-24 11:00 92.99 4.45 1.17 0.11 0.23 0.03 0.03 0.03 0.67 0.29 None 41.9050 37.8433 53.9822 0.7792 0.60 None -22.65 -7.88 0.83 0.62
2020-02-24 09:00Z 2020-02-24 10:00 93.13 4.40 1.11 0.10 0.22 0.03 0.03 0.03 0.67 0.29 None 41.8322 37.7752 53.9473 0.7774 0.60 None -22.64 -8.26 0.91 0.59
2020-02-24 08:00Z 2020-02-24 09:00 93.93 4.03 0.85 0.08 0.16 0.02 0.02 0.02 0.60 0.29 None 41.5081 37.4717 53.8182 0.7691 0.59 None -22.60 -8.72 1.17 0.50
2020-02-24 07:00Z 2020-02-24 08:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5325 36.5579 53.4377 0.7439 0.58 None -22.50 -7.17 1.28 0.31
2020-02-24 06:00Z 2020-02-24 07:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5331 36.5585 53.4371 0.7439 0.58 None -22.25 -11.84 0.92 0.32
2020-02-24 05:00Z 2020-02-24 06:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5339 36.5592 53.4369 0.7439 0.58 None -22.46 -11.62 0.90 0.31
2020-02-24 04:00Z 2020-02-24 05:00 96.40 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5323 36.5576 53.4385 0.7438 0.58 None -22.23 -11.56 0.94 0.32
2020-02-24 03:00Z 2020-02-24 04:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5347 36.5599 53.4380 0.7439 0.58 None -22.23 -11.27 0.94 0.32
2020-02-24 02:00Z 2020-02-24 03:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5345 36.5597 53.4387 0.7439 0.58 None -22.23 -11.04 1.01 0.33
2020-02-24 01:00Z 2020-02-24 02:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.28 None 40.5333 36.5586 53.4393 0.7438 0.58 None -22.22 -10.84 0.96 0.33
2020-02-24 00:00Z 2020-02-24 01:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5359 36.5610 53.4383 0.7440 0.58 None -22.23 -10.45 1.10 0.33
2020-02-23 23:00Z 2020-02-24 00:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.28 None 40.5346 36.5598 53.4391 0.7439 0.58 None -22.24 -10.07 1.18 0.34
2020-02-23 22:00Z 2020-02-23 23:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.28 None 40.5340 36.5592 53.4392 0.7439 0.58 None -22.22 -9.76 1.22 0.32
2020-02-23 21:00Z 2020-02-23 22:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.28 None 40.5345 36.5597 53.4387 0.7439 0.58 None -22.23 -9.47 1.22 0.32
2020-02-23 20:00Z 2020-02-23 21:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.28 None 40.5347 36.5599 53.4389 0.7439 0.58 None -22.21 -9.52 1.23 0.32
2020-02-23 19:00Z 2020-02-23 20:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5338 36.5591 53.4398 0.7438 0.58 None -22.21 -9.31 1.22 0.30
2020-02-23 18:00Z 2020-02-23 19:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5345 36.5597 53.4389 0.7439 0.58 None -22.20 -9.11 1.24 0.29
2020-02-23 17:00Z 2020-02-23 18:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5375 36.5625 53.4403 0.7440 0.58 None -22.18 -9.06 1.24 0.28
2020-02-23 16:00Z 2020-02-23 17:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5326 36.5579 53.4364 0.7439 0.58 None -22.17 -8.79 1.20 0.27
2020-02-23 15:00Z 2020-02-23 16:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5325 36.5579 53.4369 0.7439 0.58 None -22.18 -8.61 1.22 0.27
2020-02-23 14:00Z 2020-02-23 15:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5323 36.5577 53.4380 0.7438 0.58 None -22.15 -8.44 1.24 0.27
2020-02-23 13:00Z 2020-02-23 14:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5346 36.5598 53.4375 0.7439 0.58 None -22.18 -8.58 1.26 0.28
2020-02-23 12:00Z 2020-02-23 13:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5349 36.5601 53.4383 0.7439 0.58 None -22.16 -8.48 1.25 0.28
2020-02-23 11:00Z 2020-02-23 12:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5349 36.5602 53.4389 0.7439 0.58 None -22.17 -8.47 1.28 0.29
2020-02-23 10:00Z 2020-02-23 11:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5356 36.5607 53.4397 0.7439 0.58 None -22.17 -8.50 1.24 0.29
2020-02-23 09:00Z 2020-02-23 10:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5351 36.5603 53.4391 0.7439 0.58 None -22.17 -8.52 1.29 0.29
2020-02-23 08:00Z 2020-02-23 09:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5362 36.5614 53.4385 0.7440 0.58 None -22.16 -8.58 0.94 0.31
2020-02-23 07:00Z 2020-02-23 08:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5346 36.5598 53.4396 0.7439 0.58 None -22.19 -8.57 0.93 0.32
2020-02-23 06:00Z 2020-02-23 07:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5361 36.5612 53.4386 0.7439 0.58 None -22.19 -8.29 1.00 0.31
2020-02-23 05:00Z 2020-02-23 06:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5352 36.5603 53.4392 0.7439 0.58 None -22.19 -8.21 1.00 0.33
2020-02-23 04:00Z 2020-02-23 05:00 96.39 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5347 36.5599 53.4397 0.7439 0.58 None -22.19 -8.26 1.03 0.32
2020-02-23 03:00Z 2020-02-23 04:00 96.37 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5369 36.5620 53.4380 0.7440 0.58 None -22.20 -8.28 1.00 0.30
2020-02-23 02:00Z 2020-02-23 03:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5346 36.5598 53.4392 0.7439 0.58 None -22.20 -8.24 1.02 0.33
2020-02-23 01:00Z 2020-02-23 02:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5355 36.5607 53.4385 0.7439 0.58 None -22.20 -8.27 0.97 0.31
2020-02-23 00:00Z 2020-02-23 01:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5353 36.5605 53.4375 0.7440 0.58 None -22.20 -8.30 1.04 0.32
2020-02-22 23:00Z 2020-02-23 00:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5345 36.5598 53.4377 0.7439 0.58 None -22.20 -8.24 1.02 0.32
2020-02-22 22:00Z 2020-02-22 23:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5339 36.5592 53.4378 0.7439 0.58 None -22.23 -8.45 0.96 0.32
2020-02-22 21:00Z 2020-02-22 22:00 96.38 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5338 36.5591 53.4369 0.7439 0.58 None -22.23 -8.56 0.95 0.32
2020-02-22 20:00Z 2020-02-22 21:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.39 0.27 None 40.5344 36.5597 53.4352 0.7440 0.58 None -22.23 -8.56 0.91 0.30
2020-02-22 19:00Z 2020-02-22 20:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5345 36.5597 53.4359 0.7440 0.58 None -22.23 -8.50 0.90 0.29
2020-02-22 18:00Z 2020-02-22 19:00 96.37 2.85 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5390 36.5640 53.4390 0.7440 0.58 None -22.22 -8.12 0.86 0.28
2020-02-22 17:00Z 2020-02-22 18:00 96.37 2.85 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5403 36.5651 53.4405 0.7441 0.58 None -22.23 -7.70 0.89 0.29
2020-02-22 16:00Z 2020-02-22 17:00 96.37 2.85 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5388 36.5637 53.4407 0.7440 0.58 None -22.21 -7.49 0.86 0.28
2020-02-22 15:00Z 2020-02-22 16:00 96.37 2.85 0.05 0.04 0.01 0.00 0.00 0.02 0.39 0.27 None 40.5380 36.5631 53.4369 0.7441 0.58 None -22.23 -7.03 0.90 0.28
2020-02-22 14:00Z 2020-02-22 15:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5330 36.5584 53.4356 0.7439 0.58 None -22.21 -6.80 0.88 0.28
2020-02-22 13:00Z 2020-02-22 14:00 96.38 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.39 0.27 None 40.5326 36.5580 53.4346 0.7439 0.58 None -22.23 -6.46 0.86 0.27
2020-02-22 12:00Z 2020-02-22 13:00 96.38 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5331 36.5584 53.4354 0.7439 0.58 None -22.22 -6.23 0.86 0.29
2020-02-22 11:00Z 2020-02-22 12:00 96.39 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5326 36.5579 53.4362 0.7439 0.58 None -22.22 -6.30 0.87 0.30
2020-02-22 10:00Z 2020-02-22 11:00 96.38 2.84 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.28 None 40.5334 36.5588 53.4356 0.7439 0.58 None -22.22 -6.16 0.84 0.34
2020-02-22 09:00Z 2020-02-22 10:00 96.38 2.83 0.05 0.04 0.01 0.00 0.00 0.02 0.38 0.27 None 40.5344 36.5597 53.4372 0.7439 0.58 None -22.22 -5.83 0.82 0.33

Data Dictionary

Column Type Label Description
HourUTC timestamptz
HourDK timestamp
Methane float8
Ethane float8
Propane float8
I-Butane float8
N-Butane float8
I-Pentane float8
N-Pentane float8
Hexane_plus float8
CarbonDioxide float8
Nitrogen float8
Oxygen float8
GrossCalorificValue-MJ_per_Nm3 float8
NetCalorificValue-MJ_per_Nm3 float8
WobbeIndex-MJ_per_Nm3 float8
NormalDensity float8
RelativeDensity float8
MethaneNumber float8
WaterDewPoint float8
HydrocarbonDewPoint float8
HydrogenSulphide float8
TotalSulphur 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

Methane

Name Methane
Description

Methane content of the natural gas

Comment
Example 90
Unit mole - %
Field Methane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Ethane

Name Ethane
Description

Ethane content of the natural gas

Comment
Example 5.00
Unit mole - %
Field Ethane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Propane

Name Propane
Description

Propane content of the natural gas

Comment
Example 2.00
Unit mole - %
Field Propane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

I-Butane

Name I-Butane
Description

I-butane/isobutane content of the natural gas

Comment
Example 0.39
Unit mole - %
Field I-Butane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

N-Butane

Name N-Butane
Description

N-butane content of the natural gas

Comment
Example 0.05
Unit mole - %
Field N-Butane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

I-Pentane

Name I-Pentane
Description

I-pentane/isopentane content of the natural gas

Comment
Example 0.2
Unit mole - %
Field I-Pentane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

N-Pentane

Name N-Pentane
Description

N-pentane content of the natural gas

Comment
Example 0.11
Unit mole - %
Field N-Pentane
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Hexane+

Name Hexane+
Description

Hexane and higher hydrocarbons content of the natural gas

Comment
Example 0.04
Unit mole - %
Field Hexane_plus
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Carbon dioxide

Name Carbon dioxide
Description

Carbon dioxide content of the natural gas

Comment
Example 1.0
Unit mole - %
Field CarbonDioxide
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Nitrogen

Name Nitrogen
Description

Nitrogen content of the natural gas

Comment
Example 0.3
Unit mole - %
Field Nitrogen
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Oxygen

Name Oxygen
Description

Oxygen content of the natural gas

Comment
Example 0.1
Unit mole - %
Field Oxygen
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;100]

Gross Calorific Value

Name Gross Calorific Value
Description

A term describing the amount of heat developed by combustion of one cubic metre of gas at constant pressure when the gas and air for the combustion have a temperature of 25\u00b0C, the combustion products being brought to that temperature and the water formed by the combustion being present in liquid state. The reference conditions for normal cubic metres are 0\u00b0C and 1 atm.

Comment
Example 43.8149
Unit MJ/Nm\u00b3
Field GrossCalorificValue-MJ_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [35:55]

Net Calorific Value

Name Net Calorific Value
Description

A term describing the amount of heat generated, when the tem-perature of the combustion air and the natural gas prior to com-bustion is 25\u00b0C, when the combustion products (flue gas) are cooled to 25\u00b0C, and when the water produced during combustion is present in the form of steam. The reference conditions for normal cubic metres are 0\u00b0C and 1 atm.

Comment

-

Example 39.6757
Unit MJ/Nm\u00b3
Field NetCalorificValue-MJ_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [30;50]

Wobbe Index

Name Wobbe Index
Description

The Wobbe index offers information about the heating effect a burner is exposed to during combustion of a fuel. The greater the Wobbe index, the greater the heating effect and thereby the greater the load on the burner. The load on a burner is thus directly proportional to the Wobbe index. Different gases with the same Wobbe index will impose the same load on the burner.

Comment
Example 54.8543
Unit MJ/Nm\u00b3
Field WobbeIndex-MJ_per_Nm3
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [45;60]

Normal Density

Name Normal Density
Description

Normal density is the mass of a normal cubic meter of gas. The reference conditions for normal cubic metres are 0\u00b0C and 1 atm.

Comment
Example 0.8241
Unit kg/Nm\u00b3
Field NormalDensity
Property Constraint
Type number
Size 9.4
Format Regex
Validation Rules [0.5;1]

Relative Density

Name Relative Density
Description

The relative density aka the specific gravity is the density of natural gas divided by the density of air at the same pressure and temperature, and is an expression of the amount of heavier hydrocarbons that are in the natural gas.

Comment
Example 0.63
Unit kg/Nm\u00b3
Field RelativeDensity
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0.5;1]

Methane Number

Name Methane Number
Description

A methane number characterises the gas's knock tendency as a fuel for gas engines. It can be compared to the octane number for petrol.

Comment

Per definition pure methane has a methane number of 100 and pure hydrogen a methane number of 0. A content of higher hydrocarbons than methane reduces the methane number while the CO2 content increases the methane number.

Currently not available

Example 71
Unit Number
Field MethaneNumber
Property Constraint
Type number
Size 3.1
Format Regex
Validation Rules [50;120]

Water dew point

Name Water dew point
Description

Water content of gas described as dew point at the absoluite pressure of 70 bar.

Comment
Example -8
Unit \u00b0C
Field WaterDewPoint
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules

Hydrocarbon dew point

Name Hydrocarbon dew point
Description

The temperature for precipitation of liquid hydro carbons measured at the pressure with the highest hydrocarbon dew point.

Comment

-

Example -8
Unit \u00b0C
Field HydrocarbonDewPoint
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules

Hydrogen sulphide

Name Hydrogen sulphide
Description

Hydrogen Sulphide content of the natural gas

Comment

The Hydrogen Sulphide is measured as mg Sulphur/Nm3

Example 3.0
Unit mg/Nm\u00b3
Field HydrogenSulphide
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;30]

Total sulphur

Name Total sulphur
Description

Total Sulphur content of the un-odorized natural gas.

Comment

Given as mg Sulphur /Nm3

Example 5.0
Unit mg/Nm\u00b3
Field TotalSulphur
Property Constraint
Type number
Size 9.2
Format Regex
Validation Rules [0;50]