{"id_spatial": 21, "title": "Stromverbrauch der Industrie je WZ", "oep_metadata": {"name": "id_spatial=21", "title": ["Stromverbrauch der Industrie je Wirtschaftszweig (WZ2008)", "Industrial electricity consumption per economic sector (WZ2008)"], "review": null, "context": {"contact": "https://www.ffe.de/die-ffe/die-personen/mitarbeiter-ffe/25", "grantNo": "03ET4040B", "homepage": "https://www.ffe.de/themen-und-methoden/erzeugung-und-markt/735", "sourceCode": null, "documentation": "https://www.ffe.de/themen-und-methoden/erzeugung-und-markt/735", "fundingAgency": "Bundesministerium f\u00fcr Wirtschaft und Energie", "publisherLogo": "https://www.ffe.de/templates/ffe_v3/img/ffe_logo_2019.png", "fundingAgencyLogo": "http://opendata.ffe.de/wp-content/uploads/2019/09/titel_foerderlogo_bmwi.jpg"}, "sources": null, "spatial": {"extent": "germany", "location": "germany", "resolution": "country"}, "_comment": {"null": "If not applicable use (null)", "dates": "Dates and time must follow the ISO8601 including time zone (YYYY-MM-DD or YYYY-MM-DDThh:mm:ss\u00b1hh)", "units": "Use a space between numbers and units (100 m)", "review": "Following the OEP Data Review (https://github.com/OpenEnergyPlatform/data-preprocessing/wiki)", "licenses": "License name must follow the SPDX License List (https://spdx.org/licenses/)", "metadata": "Metadata documentation and explanation (https://github.com/OpenEnergyPlatform/organisation/wiki/metadata)", "languages": "Languages must follow the IETF (BCP47) format (en-GB, en-US, de-DE)"}, "keywords": ["industrial", "statistics", "energy consumption", "energy use"], "language": ["en-GB", "en-US", "de-DE"], "licenses": [{"name": "dl-de-by-2.0", "path": "https://www.govdata.de/dl-de/by-2-0", "title": "Data licence Germany \u2013 attribution \u2013 version 2.0", "attribution": "\u00a9 Statistisches Bundesamt (Destatis), 2008-2017", "instruction": "(2) The user must ensure that the source note contains the following information: \r\n- the name of the provider, \r\n- the annotation \"Data licence Germany \u2013 attribution \u2013 Version 2.0\" or \"dl-de/by-2-0\" referring to the licence text available at www.govdata.de/dl-de/by-2-0 \r\n- a reference to the dataset (URI)."}], "temporal": {"timeseries": {"end": "2017-12-31", "start": "2008-12-31", "resolution": "1 year"}, "referenceDate": ["2008-12-31", "2009-12-31", "2010-12-31", "2011-12-31", "2012-12-31", "2013-12-31", "2014-12-31", "2015-12-31", "2016-12-31", "2017-12-31"]}, "resources": [{"name": "demandregio.demandregio_spatial", "path": "http://opendata.ffe.de:4000/demandregio_spatial?id_spatial=eq.21", "format": "PostgreSQL", "schema": {"fields": [{"name": "id", "type": "serial", "unit": null, "description": "Unique identifier"}, {"name": "id_spatial", "type": "integer", "unit": null, "description": "Dataset identifier"}, {"name": "id_region_type", "type": "integer", "unit": null, "description": "Region type identifier"}, {"name": "id_region", "type": "integer", "unit": null, "description": "Region identifer"}, {"name": "year", "type": "integer", "unit": null, "description": "Reference year"}, {"name": "internal_id", "type": "integer[]", "unit": null, "description": "internal_id[1] = WZ2008 (05..33) http://opendata.ffe.de:4000/wz2008_beschreibung"}, {"name": "value", "type": "double precision", "unit": "MWh", "description": "energy consumption"}], "primaryKey": ["id"], "foreignKeys": [{"fields": ["id_spatial"], "reference": {"fields": ["id_spatial"], "resource": "demandregio.demandregio_spatial"}}, {"fields": ["id_region_type"], "reference": {"fields": ["id_region_type"], "resource": "geodaten.g_region_beschreibung"}}, {"fields": ["id_region_type", "id_region"], "reference": {"fields": ["id_region_type", "id_region"], "resource": "geodaten.g_region"}}]}, "dialect": null, "profile": "tabular-data-resource", "encoding": "UTF-8"}], "description": ["Erhebung \u00fcber die Energieverwendung der Betriebe des Verarb. Gewerbes sowie des Bergbaus und der Gewinnung von Steinen und Erden; Tabelle 2: Energieverbrauch nach Energietr\u00e4gern: Stromverbrauch je Wirtschaftszweig (WZ2008)", "Survey on the use of energy in manufacturing, mining and quarrying; Table 2: Energy consumption by energy source: electricity consumption per economic sector (WZ2008)"], "contributors": null, "metaMetadata": {"metadataLicense": {"name": "CC0-1.0", "path": "https://creativecommons.org/publicdomain/zero/1.0/", "title": "Creative Commons Zero v1.0 Universal"}, "metadataVersion": "OEP-1.4.0"}, "publicationDate": "2019-11-04"}, "ffe_metadata": {"id_region_type": [3]}, "data": [{"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [5], "value": 7535962.777777778}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [6], "value": 519217.2222222222}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [8], "value": 2395493.611111111}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [9], "value": 6820.2777777778}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [10], "value": 15283822.5}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [11], "value": 2459058.611111111}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [12], "value": 272224.1666666667}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [13], "value": 2309678.3333333335}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [14], "value": 219412.5}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [15], "value": 139001.6666666667}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [16], "value": 4677852.222222222}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [17], "value": 21393849.72222222}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [18], "value": 2822296.388888889}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [19], "value": 7146321.944444444}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [20], "value": 49587572.222222224}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [21], "value": 2140312.7777777775}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [22], "value": 14164898.888888888}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [23], "value": 12802840.277777778}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [24], "value": 45656441.38888889}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [25], "value": 12765758.333333332}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [26], "value": 6278119.444444444}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [27], "value": 5637659.444444444}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [28], "value": 11865330.0}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [29], "value": 17131701.666666668}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [30], "value": 1399602.2222222222}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [31], "value": 1396048.3333333333}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [32], "value": 1310051.6666666667}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [33], "value": 878010.0}, {"id_spatial": 21, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [-1], "value": 250195358.8888889}]}