Yet more Open Data for Smart Grid players

Published 20 Juin 2016

While the legal provisions of the energy transition law relating to the making available of data by the managers of electricity and gas distribution networks have not yet been put into effect, electricity players, administrations and local governments are multiplying initiatives around Open Data. Many data relating to the production and consumption of energy are already available..

think-smartgrids-open-data-energieHackathon Compteur Connect Awards – Photo Credit: Ministère de l’Ecologie in CC

The releasing of these data is likely to have many benefits of the environment and economic and social development. With these data, companies will be able to develop and offer services and innovative products, and at all relevant levels: individuals, businesses, neighborhoods, cities.

The assessment which was made in April 2015 by the eco-industry energy efficiency sector agreement was not made in vain. In the space of a year, world of data relating to the energy sector has been profoundly transformed.

For several years, the Electric Energy Observatory (Observatoire de l’énergie électrique), RTE and Enedis (ex ERDF) publish a series of datasets on:

  • Electricity consumption
  • Electricity production per sector
  • Border trade
  • CO2 emissions per kWh of electricity produced in France
  • Inter-regional flows

With Open Data it is no longer about publishing data but about promoting their reuse, e.g. thanks to licences, and platforms which make it possible to download the data in various open and interoperable formats, and to view them. It is also about making the data “accessible” thanks to API (programming interfaces) to allow players to seize them and design a new generation of services.  


Gradual releasing by Enedis

In April 2015, Enedis published online a much anticipated first data set: the electricity sector overview (production / consumption / injection on Enedis network).

At the Climate Change Challenge (C3), held in November 2015, as part of the COP21 Summit, Enedis put a series of data sets relating to consumption, installed capacity and production facilities connected to the grid, at the disposal of the participants in the summit, and beyond, to all users of

Today 16 data sets are available for download and via API on Enedis Open Data platform.

In this way, Enedis (…) wants to allow everyone to have the data and information he/she needs for their online activities, actions and commitments in the service of the energy transition. Interested publics are many: players in the electricity market, customers and producers, local authorities, innovation stakeholders, citizens.

The Enedis platform allows users to track the usage that is made of the datasets. With 23,771 downloads, Bilan Electrique au pas Journalier (Daily Electric Report) is the most popular dataset, followed by the production installations connected to the Enedis network per region (1,965 downloads), and the bilan électrique au pas demi-heure (Half-hourly Electric Report) with 1,703 downloads, and the Electric Report – installed capacity with 1,681 downloads.


… while at RTE

For many years RTE has published on its website data pertaining to regional and national electricity consumption, electricity generation by sector, border trade, CO2 emissions per kWh of electricity produced in France, and consumption, production and interregional flows.

RTE’s open data approach of RTE, which also began at the Climate Change Challenge (C3) let, in 2016, to the opening of an Open Data platform. The 21 datasets that the platform contains cover a wide range of data with variable geographic spread: consumption, production per industry, power exchanges in Europe, regional power balances, … The source of electricity consumed is also detailed as well as destination countries for exports.

It is also possible to track the most requested data sets: annual production by sector (570 downloads), final annual consumption of electricity per region (563 downloads), annual wind turbine and solar production (468).


Many resources available on, France’s national open data platform hosts data from a large number of players. Aside from the 17 RTE data sets and 13 datasets proposed by Enedis, the platform gives access to 28 datasets compiled by the statistical service of the Ministry of Ecology, Sustainable Development and Energy as part of the Pegasus base (Oil, gas, electricity and other energy statistics), and at the basis of ADEME’s energy performance diagnostics, or the consumption and production of energy in the food industries and farms (Ministry of Agriculture, Food and Forestry).

A number of local or regional actors (such as Morbihan Energies or the Bretagne Environnement GIP) and decentralised services of the French State (Loiret, Haute-Savoie) depend on to publish the data which they hold. 86 datasets relating to wind power and 28 datasets relating to recharging points are already available.

The Compteur Connect hackathon, organised by the Ministry or Ecology, in assocition with Think Smartgrids, has made it possible to highlight a number of datasets that are available on, such as:

  • Energy labels on Municipal Buildings (City of Paris)
  • Energy consumption of built buildings
  • Water works and wastewater management (Greater Lorient)
  • Photovoltaic production on communal buildings (St Malo Commune)
  • Sustainable Housing vouchers (Saône-et-Loire department)
  • Heatloss from buildings (Greater Paris Seine Ouest)
  • Windpower census per region
  • Wood powered boilers and the heat network
  • Geothermic installations
  • Biogas plants (Pays de la Loire)

Energy-related data sets are now popping up on the open data portals of regions, cities and metropoles. The PACA Region, which is already ahead of the game with its Energ’Air database (maintained by AirPaca and the Regional Observatory for Energy, Climate and Air) now provides access via its portal, to production and the annual energy consumption rates per commune, community of communes (communauté de communes) and per department.

The data offers available at the levels of cities and regions are still fledgling. This situation should change with the forthcoming publication of the implementing decree of Article 179 of the Energy Transition Law(TecV). This bill. This bill requires that electricity and gas DSOs provide communities with the “economic data that are necessary for the development of regulations defining the support systems for the production of certain forms of energy and energy savings.” In addition, it also foresees that these data are published as open data. The decree, which is being prepared, will specify the terms of this provision (nature and quality of the data) and ensure the protection of individual privacy, making it impossible to identify them.


ITEMS International pour Think Smartgrids

Datasets available on the Enedi Open Data platform:

  • Daily consumption per client category
  • Electricity Report – Installed capacity of production sites connected to the Enedis network, per region and sector (photovoltaic and wind power)
  • Flexibilities participating in the MA or the NEBEF per region (these flexibilities correspond to the production capacities or production peak shaving participating in the Adjustment Mechanism, and the peak shaving capacities that are valued on energy markets (NEBEF)
  • Flexibilities that are part of the MA or NEBEF within Enedis’ remit
  • Half hour Electric Report (volumes of energy injected, extracted, produced or consumed by Enedis over a given period in half-hour tranches)
  • Daily Electric Report  (volumes of energy injected, extracted, produced or consumed by Enedis over a given period in dailty tranches)
  • Production installations connected to the Enedis network per power tranche
  • Production installations connected to the Enedis network per region
  • Distribution of the queue for pending requests for connection to the distribution network managed by Enedis, in number and power
  • Quality of the supply (average annual duration of power cuts for clients with low-tension connections)
  • Distribution of the producer waiting list per power tranche (volume of demand for production connections to the distribution network managed by Enedis, in relation to the sector in number and power)
  • Archive of production installations connected to the Enedis network
  • Profile coefficients (values of 10 national profiles built by Enedis with a view to establishing energy regulatory reports)
  • Coefficients of technical losses (iron and joule) and non technical (metering dysfunctions, fraud…)

Jeux de données disponibles sur la plateforme Open Data de RTE

  • Monthly charge factors and monthly rates of wind and solar cover  (January 2012 – April 2016)
  • Daily trade extremes ( January 2012 – April 2016) (daily minimum and maximum values in the power balance of trade flows across borders contextualized by the average daily temperature)
  • Monthly Balance output = gross consumption (January 2007 – April 2016)
  • History of the realisation of the monthly balance production / consumption (GWh) depending on the gross consumption, the balance of physical exchanges with foreign countries, extraction due to pumping
  • Daily peak of maximum power consumption (GW)
  • Daily archive of maximum power (GW) needed to cover the peaks of the French gross consumption
  • “Baseline” scenario of the 2015 forecast balance (Modeling of average power requirements (MW) per hour per sector / usage to 2019-2020
  • Load curve of gross electricity consumption: Average power (MW) consumed per 30 minutes perimeter in mainland France. (January 2008 – March 2016)
  • Load curve of electricity generation by sector. Average power (MW) generated per 30 minutes perimeter of mainland France and aggregated by major production sector. (January 2013 – March 2016)
  • Imports and commercial exports on hourly basis, since 2005, between France and each of the countries with which it has interconnections: Britain, Switzerland, Italy, Spain, CWE zone (Germany, Austria, Belgium, Luxembourg, Netherlands)
  • Annual electricity volumes exchanged between balance operators (2011-2015)
  • Annual park production by sector (2007-2015)
  • Annual electricity generation (TWh) per sector and per territory (2013-2015)
  • Annual gross electricity consumption (2001 to 2015) with and without correction for weather effects
  • Final regional annual consumption of electricity (2006 – 2014)
  • Final annual electricity consumption (excluding losses) (GWh). adjusted for weather effects, by administrative region
  • Annual evolution of circuit lengths of the electricity transmission network (2011-2015))
  • Annual lengths of circuits and pylon lines of the electricity transmission network (2011-2015)
  • Annual wind and solar power production (MW) by administrative region and at the national level (2001 to 2015)
  • Annual peak gross electricity consumption (2001 to 2015)
  • Monthly electricity trading volume: focus on EPEX SPOT (2014 to 2015)
  • Monthly volumes of electricity (MWh) traded between balance operators on the EPEX SPOT exchange in France yesterday the day before for next day delivery (J-1)
  • Annual electricity volumes enabled on the adjustment mechanism (2004-2015)
  • Daily peak shaving on the adjustment mechanism. Daily archive of daily consumption shaving capacities (MW) on the adjustment mechanism. (2013 to 2015)

Oil, electricity, gas and energy statistics (Pegasus) on

  • Import and export prices
  • Energy imports and exports from France in EUR million
  • Imports, production, consumption by energy, Mtoe
  • Imports, production, consumption of coke and pellets in France (thousands of tonnes)
  • Imports, production, consumption of solid mineral fuels in France (thousands of tonnes)
  • Imports, production, coal consumption in France (thousands of tonnes)
  • Imports, production, crude oil consumption in France (thousands of tonnes)
  • Consumption of refined petroleum products in France (thousands of tonnes)
  • Imports, production, natural gas consumption in France (GWh PCS)
  • Imports, production, electricity consumption in France (in GWh)
  • Natural gas prices for a company according to the Eurostat survey, in euros excluding VAT (2007-2014)
  • Electricity price for a company according to the Eurostat survey, in euros excluding VAT (2007-2014)
  • Coal prices for the industry, in euros excluding VAT (2000-2013)
  • heavy fuel oil, price for a company in euros excluding VAT (1983-2014)
  • Natural gas price for a company in euros excluding VAT (1983-2014)
  • Electricity prices for industrial, green tariff A5 EJP option, in euros excluding VAT (1984-2014)
  • Electricity prices for industrial, green rate A5 option basis, in euros excluding VAT (1983-2014)
  • Electricity prices for industrial, yellow costs in euros excluding VAT (1984-2014)
  • Electricity prices for a professional, blue tariff option peak hours in euros excluding VAT (1983-2014)
  • Electricity prices for a household survey according to Eurostat, in Euros (2008-2014)
  • Wood, prices for a household in euros (2003-2014)
  • District heating (steam), prices for a household in euros (1986-2014)
  • Petroleum products, household prices in euros (1983-2014)
  • Natural gas household prices in Euros (1983-2014)
  • Household electricity prices, blue tariff option peak hours in Euros (1983-2014)
  • Household Natural gas prices survey according to Eurostat, in Euros (2008-2014)
  • Household Electricity prices, blue base option price, in euros (1983-2014)