- JSON
- CSV...
- XLSX - Excel
- XML
- Downloads are limited to the top 100000 rows
Metadata
Data API

Commercial gas amounts Data

Data Explorer Filters

No data filters are assigned to this Data Explorer view yet. You are viewing an unfiltered version of the complete resource data.

Interval

Total number of rows: 2,112


2014-01-12	31,966	-133,408,867	160,206,233	37,184,974	-19,999,836	-46,943,714
2014-01-11	118,514	-106,578,142	147,265,920	27,560,262	-27,105,840	-34,896,636
2014-01-10	111,351	-108,487,074	151,129,170	6,772,639	-9,431,497	-39,334,284
2014-01-09	71,778	-111,522,756	153,469,002	-65,151	-14,459,840	-35,411,940
2014-01-08	7,213	-105,755,234	151,731,878	3,414,074	-23,301,840	-35,040,972
2014-01-07	6,515	-102,722,601	150,932,021	10,002,773	-23,925,840	-32,978,688
2014-01-06	5,290	-118,995,966	159,127,354	44,674,355	-47,261,045	-29,950,008
2014-01-05	3,606	-106,119,547	163,792,000	25,075,570	-53,598,384	-29,343,384
2014-01-04	3,459	-100,662,039	161,164,662	20,613,898	-53,838,384	-27,083,166
2014-01-03	2,568	-106,194,206	158,668,008	7,599,320	-27,156,384	-34,956,348
2014-01-02	1,019	-114,014,826	153,414,413	11,643,561	-15,630,384	-34,252,900
2014-01-01	0	-103,854,568	148,901,891	-2,829,940	-7,828,816	-35,179,392

Access resource data via a web API with powerful query support. Further information in the main CKAN Data API and DataStore documentation.

Endpoints »

The Data API can be accessed via the following actions of the CKAN action API.

Query	`https://api.energidataservice.dk/datastore_search`
Query (via SQL)	`https://api.energidataservice.dk/datastore_search_sql`

Querying »

Query example (first 5 results)

https://api.energidataservice.dk/datastore_search?resource_id=gasflow&limit=5

Query example (via SQL statement)

https://api.energidataservice.dk/datastore_search_sql?sql=SELECT * from "gasflow" LIMIT 5

Example: Javascript »

A simple ajax (JSONP) request to the data API using jQuery.

  var data = {
    resource_id: 'gasflow', // the resource id
    limit: 5 // get 5 results
  };
  $.ajax({
    url: 'https://api.energidataservice.dk/datastore_search',
    data: data,
    dataType: 'jsonp',
    success: function(data) {
      alert('Total results found: ' + data.result.total)
    }
  });

Example: Python »

import urllib2
url = 'https://api.energidataservice.dk/datastore_search?resource_id=gasflow&limit=5'
fileobj = urllib2.urlopen(url)
print fileobj.read()

NOTE: This snippet only works with python 2.

Data Dictionary

Column	Type	Label	Description
GasDay	date
KWhFromBiogas	int4
KWhToDenmark	int4
KWhFromNorthSea	int4
KWhToOrFromStorage	int4
KWhToOrFromGermany	int4
KWhToSweden	int4

Gas Day

Name	Gas Day
Description	Gas Day is a period commencing at 06:00 CET on any day and ending at 06:00 CET on the following day. The Gas Day is reduced to 23 Hours at the transition to summer time and is increased to 25 Hours at the transition to winter time.
Comment
Example	2017-12-24
Unit	Days
Field	GasDay
Property Constraint
Type	date
Size	10
Format Regex
Validation Rules

kWh from Biogas

Name	kWh from Biogas
Description	Total amount of biogas injected into the Danish gas system. The flow comes from biogas plants supplying biomethane to either the distributions network or the transmission network. Commercially this amount is allocated the BNG-Entry point.
Comment	Positive data indicates flow into the Danish gas system.
Example	8.504.020
Unit	kWh
Field	KWhFromBiogas
Property Constraint
Type	int
Size	10
Format Regex	/d{10}
Validation Rules

kWh to Denmark

Name	kWh to Denmark
Description	This amount of gas indicates the total consumption of gas in Denmark both through the distribution network and plants directly connected to the transmission system. Commercially this amount is allocated at the Exit Zone point.
Comment	Negative data indicates flow from the Danish gas system.
Example	200.000
Unit	kWh
Field	KWhToDenmark
Property Constraint
Type	int
Size	10
Format Regex	/d{10}
Validation Rules

kWh from North Sea

Name	kWh from North Sea
Description	The total commercial amount of gas from the North Sea to the Danish gas system. Commercially this amount is allocated at the Nybro Entry/Exit point.
Comment	Positive data indicates amounts going into the Danish gas system.
Example	4.200.000
Unit	kWh
Field	KWhFromNorthSea
Property Constraint
Type	int
Size	10
Format Regex	/d{10}
Validation Rules

kWh to or from Storage

Name	kWh to or from Storage
Description	Total commercial amount injected or withdrawn from the Danish collective storage point. Commercially this amount is allocated at the Collective Storage Point.
Comment	Negative data indicates injection and positive data indicates withdrawal of amounts from the storage point.
Example	1.504.020
Unit	kWh
Field	KWhToOrFromStorage
Property Constraint
Type	int
Size	10
Format Regex	/d{10}
Validation Rules

kWh to or from Germany

Name	kWh to or from Germany
Description	The total commercial amount of gas from or towards Germany. Commercially this amount is allocated at the Ellund Entry/Exit point.
Comment	Positive data indicates amounts going into the Danish gas system. Negative data indicates amounts going from the Danish gas system.
Example	8.504.020
Unit	kWh
Field	KWhToOrFromGermany
Property Constraint
Type	int
Size	10
Format Regex	/d{10}
Validation Rules

kWh to Sweden

Name	kWh to Sweden
Description	The total commercial amount of gas from Denmark to Sweden. Commercially this amount is allocated at the Dragoer Entry/Exit point
Comment	Negative data indicates amounts from the Danish gas system to the Swedish gas system.
Example	200.000
Unit	kWh
Field	KWhToSweden
Property Constraint
Type	int
Size	10
Format Regex	/d{10}
Validation Rules