{"datasetId":69,"datasetName":"DatahubPricelist","title":"DataHub Price List (subscriptions, tariffs, and fees)","description":"This dataset shows prices for the electrical power retail market in Denmark per supplier per charge type (subscriptions, tariffs, and fees). ","organizationName":"tso-electricity","updateFrequency":"P1D","comment":"The columns Price 1-24 covers the hours within a day. Price1 indicates the first hour of the day (00.00-01.00) local Danish time. If the price is a flat rate price, only price 1 is used.\nOn both DST transition days, the DST-affected hour is assigned the same price as the preceding hour.\n\n**Filtering on the column ChargeOwner:**\nAn alphabetical list of Grid Company Names can be found in the dataset [Change of Electricity Suppliers Per Grid Area](https://www.energidataservice.dk/tso-electricity/PowerSupplierChangePerGridarea) by selecting data for one month and order by the column Grid Company Names.\n\n**Filtering on Start Date & End Date:**\n**Start Date** and **End Date** filter the **ValidFrom** column. To view the current tariff for today, select the date for tomorrow in the End Date field, and sort ValidFrom descending before submitting. The current tariff will now appear at the top.\n\nUse the dynamic timestamp “end=now%2BP1D” in the API string for same functionality. Note that: %2B must be used instead of +\n\n**Single quotes in strings:**\nIn order to filter values containing single quotes, replace the single quote (') with two quotes ('').\n\n#### Looking for current tariffs? - 3 possible ways to reduce the number of rows:\n**Using dynamic timestamps**, set the Start Date some time back (e.g., 6 months) and End Date as \"now%2BP1D\". \\\nExample – also filtering ChargeType: \\\n...?start=StartOfMonth-P6M&end=now%2BP1D&filter={\"ChargeType\":[\"D03\"]} \\\nNote: Filter locally to extract only the currently valid tariffs.\n\n**Combine multiple GLN Numbers and ChargeTypeCodes** to further reduce the dataset size: \\\n...?start=StartOfMonth-P6M&end=now%2BP1D&filter={\"GLN_Number\":[\"…\",\"…\"],\"ChargeTypeCode\":[\"...\",\"...\"]}\n\n**One request per combination of GLN Number and ChargeTypeCode** - use limit=1 together with end=now%2BP1D, and sort ValidFrom descending to retrieve only the latest tariff: \\\n...?end=now%2BP1D&filter={\"GLN_Number\":[\"…\"],\"ChargeTypeCode\":[\"...\"]}&sort=ValidFrom%20DESC&limit=1\n\nThe dataset is updated daily in the morning (usually before 9 am local Danish time), and one request per combination of GLN Number and ChargeTypeCode per day is within the allowed API usage limits.","caution":"The dataset has changed as part of the [transition to DataHub 3.0](https://www.energidataservice.dk/news#154).\\\nThe URL/endpoint will remain unchanged. Contents of the ChargeOwner column may change.  **Implemented on September 21.**","filterColumn":"ValidFrom","author":"Energinet","resolution":"N/A","columns":[{"datasetId":69,"dbColumn":"ChargeOwner","dataType":"string","sortOrder":0,"displayName":"ChargeOwner","unit":"","description":"Charge owner is the company who claims the charge.","comment":"","example":"Energi Fyn Net A/S - 554","columnSize":60.0},{"datasetId":69,"dbColumn":"GLN_Number","dataType":"string","sortOrder":1,"primaryKeyIndex":1,"displayName":"GLN Number","unit":"","description":"Global Location Number (GLN) is the identification key to identify physical locations or legal entities. ","comment":"","example":"5790000705689","columnSize":16.0},{"datasetId":69,"dbColumn":"ChargeType","dataType":"string","sortOrder":2,"primaryKeyIndex":2,"displayName":"ChargeType","unit":"","description":"The type of charge: D01=Subscription, D02=Fee, D03=Tariff.\nSee more in the document \"EDI transaktioner for det danske elmarked RSM guide ver 575\" on [Dokumentation og regler for DataHub](https://energinet.dk/data-om-energi/datahub/dokumentation-og-regler-1/) (Danish).","comment":"-","example":"D03","columnSize":3.0},{"datasetId":69,"dbColumn":"ChargeTypeCode","dataType":"string","sortOrder":3,"primaryKeyIndex":3,"displayName":"ChargeTypeCode","unit":"","description":"ID of the actor. ","comment":"","example":"42106","columnSize":20.0},{"datasetId":69,"dbColumn":"Note","dataType":"string","sortOrder":4,"displayName":"Note","unit":"","description":"Descriptive note.","comment":"-","example":"Reduceret PSO-tarif 100 GWh","columnSize":99.0},{"datasetId":69,"dbColumn":"Description","dataType":"string","sortOrder":5,"displayName":"Description","unit":"","description":"Detailed description.","comment":"-","example":"Reduceret elafgift for elvarmekunder","columnSize":200.0},{"datasetId":69,"dbColumn":"ValidFrom","dataType":"date","sortOrder":6,"primaryKeyIndex":3,"displayName":"ValidFrom","unit":"","description":"Date from which the prices in the columns Price 1-24 are valid. Local Danish time.","comment":"","example":"2017-12-24","columnSize":10.0},{"datasetId":69,"dbColumn":"ValidTo","dataType":"date","sortOrder":7,"displayName":"ValidTo","unit":"","description":"Date to which the prices in the columns Price 1-24 are valid. Local Danish time.","comment":"","example":"2026-09-30","columnSize":10.0},{"datasetId":69,"dbColumn":"VATClass","dataType":"string","sortOrder":8,"displayName":"VATClass","unit":"","description":"VAT Class - either VAT or no VAT.\n\nThe values may be erroneous as the field is only indicative.","comment":"-","example":"D01","columnSize":3.0},{"datasetId":69,"dbColumn":"Price1","dataType":"number","sortOrder":9,"displayName":"Price1","unit":"DKK per kWh","description":"Price in the first hour of the day (00.00-01.00) local Danish time.","comment":"Flat rate means same price in all hours.","example":"0,878000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price2","dataType":"number","sortOrder":10,"displayName":"Price2","unit":"DKK per kWh","description":"Price 2","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price3","dataType":"number","sortOrder":11,"displayName":"Price3","unit":"DKK per kWh","description":"Price 3","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price4","dataType":"number","sortOrder":12,"displayName":"Price4","unit":"DKK per kWh","description":"Price 4","comment":"If the price is empty (null), the price in hour 1 apply","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price5","dataType":"number","sortOrder":13,"displayName":"Price5","unit":"DKK per kWh","description":"Price 5","comment":"If the price is empty (null), the price in hour 1 apply","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price6","dataType":"number","sortOrder":14,"displayName":"Price6","unit":"DKK per kWh","description":"Price 6","comment":"If the price is empty (null), the price in hour 1 apply","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price7","dataType":"number","sortOrder":15,"displayName":"Price7","unit":"DKK per kWh","description":"Price 7","comment":"If the price is empty (null), the price in hour 1 apply","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price8","dataType":"number","sortOrder":16,"displayName":"Price8","unit":"DKK per kWh","description":"Price 8","comment":"If the price is empty (null), the price in hour 1 apply","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price9","dataType":"number","sortOrder":17,"displayName":"Price9","unit":"DKK per kWh","description":"Price 9","comment":"If the price is empty (null), the price in hour 1 apply","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price10","dataType":"number","sortOrder":18,"displayName":"Price10","unit":"DKK per kWh","description":"Price 10","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price11","dataType":"number","sortOrder":19,"displayName":"Price11","unit":"DKK per kWh","description":"Price 11","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price12","dataType":"number","sortOrder":20,"displayName":"Price12","unit":"DKK per kWh","description":"Price 12","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price13","dataType":"number","sortOrder":21,"displayName":"Price13","unit":"DKK per kWh","description":"Price 13","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price14","dataType":"number","sortOrder":22,"displayName":"Price14","unit":"DKK per kWh","description":"Price 14","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price15","dataType":"number","sortOrder":23,"displayName":"Price15","unit":"DKK per kWh","description":"Price 15","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price16","dataType":"number","sortOrder":24,"displayName":"Price16","unit":"DKK per kWh","description":"Price 16","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price17","dataType":"number","sortOrder":25,"displayName":"Price17","unit":"DKK per kWh","description":"Price 17","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price18","dataType":"number","sortOrder":26,"displayName":"Price18","unit":"DKK per kWh","description":"Price18","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price19","dataType":"number","sortOrder":27,"displayName":"Price19","unit":"DKK per kWh","description":"Price 19","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price20","dataType":"number","sortOrder":28,"displayName":"Price20","unit":"DKK per kWh","description":"Price 20","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price21","dataType":"number","sortOrder":29,"displayName":"Price21","unit":"DKK per kWh","description":"Price 21","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price22","dataType":"number","sortOrder":30,"displayName":"Price22","unit":"DKK per kWh","description":"Price 22","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price23","dataType":"number","sortOrder":31,"displayName":"Price23","unit":"DKK per kWh","description":"Price 23","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"Price24","dataType":"number","sortOrder":32,"displayName":"Price24","unit":"DKK per kWh","description":"Price 24","comment":"If the price is empty (null), the price in hour 1 apply.","example":"234,550000","columnSize":12.6},{"datasetId":69,"dbColumn":"TransparentInvoicing","dataType":"integer","sortOrder":33,"displayName":"Transparent Invoicing","unit":"","description":"Indicates if the electricity retailer has to show the price element on the invoice.","comment":"","example":"0","columnSize":1.0,"validationRules":"0 or 1"},{"datasetId":69,"dbColumn":"TaxIndicator","dataType":"integer","sortOrder":34,"displayName":"Tax Indicator","unit":"","description":"Indicates if a tariff is a charge or not. ","comment":"","example":"0","columnSize":1.0,"validationRules":"0 or 1"},{"datasetId":69,"dbColumn":"ResolutionDuration","dataType":"string","sortOrder":35,"displayName":"Resolution Duration","unit":"","description":"Resolution of the values","comment":"","example":"PT1H","columnSize":10.0}],"tags":["Active","Daily (P1D)","Hour"],"dataFrom":"2014-01-01T00:00:00","lastDataUpdate":"2026-10-25T05:46:27","lastMetadataUpdate":"2026-09-25T10:43:42","published":"2020-01-01T00:00:00","active":true,"buildReport":false,"filterColumnIsDate":true}