DataHub Price List (subscriptions, tariffs, and fees)

This dataset shows prices for the electrical power retail market in Denmark per supplier per charge type (subscriptions, tariffs, and fees). 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. **Filtering on the column ChargeOwner:** An 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. **Filtering on Start Date & End Date:** Start Date and End Date filter on the ValidFrom column. To view the current tariff for today, select current date in the End Date field, and sort ValidFrom descending before submitting. The current tariff will now appear first. Use the dynamic timestamp “end=now” in the API string for same functionality. **Single quotes in strings:** In order to filter values containing single quotes, replace the single quote (') with two quotes (''). #### Looking for current tariffs? - 3 possible ways to reduce the number of rows: **Using dynamic timestamps**, set the Start Date some time back (e.g., 6 months) and End Date as "now". \ Example – also filtering ChargeType: \ ...?start=StartOfMonth-P6M&end=now&filter={"ChargeType":["D03"]} \ Note: Filter locally to extract only the currently valid tariffs. **Combine multiple GLN Numbers and ChargeTypeCodes** to further reduce the dataset size: \ ...?start=StartOfMonth-P6M&end=now&filter={"GLN_Number":["…","…"],"ChargeTypeCode":["...","..."]} **One request per combination of GLN Number and ChargeTypeCode** - use limit=1 together with end=now, and sort ValidFrom descending to retrieve only the latest tariff: \ ...?end=now&filter={"GLN_Number":["…"],"ChargeTypeCode":["..."]}&sort=ValidFrom%20DESC&limit=1 The 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.