{"id_spatial": 22, "title": "Stromerzeugungsanlagen in der Industrie", "oep_metadata": {"name": "id_spatial=22", "title": ["Industrielle Stromerzeugung", "Industrial power generation"], "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", "electricity production"], "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), 2006-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": "2006-12-31", "resolution": "1 year"}, "referenceDate": ["2006-12-31", "2007-12-31", "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.22", "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,08,10,13,16,17,19,20,23,24) e.g. 200: B or 300: C (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": ["Fachserie 4 / Reihe 6.4: Stromerzeugungsanlagen der Betriebe im Bergbau und im Verarbeitenden Gewerbe", "Fachserie 4 / Reihe 6.4: Power generation plants of mining and industry"], "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-05"}, "ffe_metadata": {"id_region_type": [3]}, "data": [{"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [200], "value": 12914.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [5], "value": 12620.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [8], "value": 94.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [300], "value": 38183.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [10], "value": 2201.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [13], "value": 95.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [16], "value": 1397.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [17], "value": 6404.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [19], "value": 5761.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [20], "value": 12927.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [23], "value": 198.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2006, "internal_id": [24], "value": 6993.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [200], "value": 14538.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [5], "value": 14201.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [8], "value": 91.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [300], "value": 38705.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [10], "value": 2096.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [13], "value": 83.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [16], "value": 1284.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [17], "value": 6711.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [19], "value": 5770.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [20], "value": 13056.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [23], "value": 183.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2007, "internal_id": [24], "value": 7247.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [200], "value": 11441.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [5], "value": 10851.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [8], "value": 452.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [300], "value": 37956.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [10], "value": 1976.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [13], "value": 53.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [16], "value": 1279.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [17], "value": 6974.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [19], "value": 6300.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [20], "value": 12689.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [23], "value": 179.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2008, "internal_id": [24], "value": 7059.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [200], "value": 7730.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [5], "value": 7248.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [8], "value": 342.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [300], "value": 38232.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [10], "value": 2216.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [13], "value": 46.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [16], "value": 1553.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [17], "value": 6156.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [19], "value": 7743.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [20], "value": 14198.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [23], "value": 176.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2009, "internal_id": [24], "value": 4808.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [200], "value": 9544.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [5], "value": 9072.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [8], "value": 323.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [300], "value": 43428.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [10], "value": 2250.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [13], "value": 29.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [16], "value": 1614.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [17], "value": 6756.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [19], "value": 7357.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [20], "value": 16584.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [23], "value": 192.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2010, "internal_id": [24], "value": 7191.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [200], "value": 8227.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [5], "value": 7967.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [8], "value": 71.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [300], "value": 42388.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [10], "value": 2443.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [13], "value": 29.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [16], "value": 1655.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [17], "value": 6505.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [19], "value": 6833.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [20], "value": 16246.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [23], "value": 219.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2011, "internal_id": [24], "value": 6884.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [200], "value": 1825.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [5], "value": 1579.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [8], "value": 68.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [300], "value": 42272.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [10], "value": 2637.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [13], "value": 26.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [16], "value": 1939.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [17], "value": 6445.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [19], "value": 6858.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [20], "value": 15747.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [23], "value": 255.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2012, "internal_id": [24], "value": 6811.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [200], "value": 1595.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [5], "value": 1368.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [8], "value": 78.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [300], "value": 43297.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [10], "value": 2644.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [13], "value": 25.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [16], "value": 2117.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [17], "value": 6608.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [19], "value": 6715.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [20], "value": 15685.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [23], "value": 274.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2013, "internal_id": [24], "value": 7416.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [200], "value": 1319.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [5], "value": 1086.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [8], "value": 87.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [300], "value": 44127.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [10], "value": 2764.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [13], "value": null}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [16], "value": 2136.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [17], "value": 6958.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [19], "value": 6225.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [20], "value": 15632.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [23], "value": 296.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2014, "internal_id": [24], "value": 7511.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [200], "value": 1234.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [5], "value": 986.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [8], "value": 105.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [300], "value": 48981.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [10], "value": 2951.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [13], "value": 111.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [16], "value": 2056.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [17], "value": 7278.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [19], "value": 6518.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [20], "value": 15646.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [23], "value": 294.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2015, "internal_id": [24], "value": 11010.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [200], "value": 2163.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [5], "value": 1906.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [8], "value": 107.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [300], "value": 52698.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [10], "value": 3192.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [13], "value": 33.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [16], "value": 2105.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [17], "value": 7241.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [19], "value": 5773.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [20], "value": 16682.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [23], "value": 332.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2016, "internal_id": [24], "value": 11101.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [200], "value": 2081.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [5], "value": 1820.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [8], "value": 109.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [300], "value": 54700.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [10], "value": 3628.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [13], "value": 31.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [16], "value": 2080.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [17], "value": 7340.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [19], "value": 5553.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [20], "value": 17062.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [23], "value": 337.0}, {"id_spatial": 22, "id_region_type": 3, "id_region": 276, "year": 2017, "internal_id": [24], "value": 11451.0}]}