{"links": [{"rel": "self", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-smart-meter-consumption-substation"}, {"rel": "datasets", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets"}, {"rel": "attachments", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-smart-meter-consumption-substation/attachments"}, {"rel": "reuses", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-smart-meter-consumption-substation/reuses"}, {"rel": "static_exports", "href": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-smart-meter-consumption-substation/static_exports"}], "dataset": {"visibility": "domain", "dataset_id": "ukpn-smart-meter-consumption-substation", "dataset_uid": "da_ycafes", "has_records": true, "features": ["analyze", "timeserie", "geo"], "attachments": [{"id": "data_triage_smart_meter_consumption_data_ukpnxlsx", "title": "Data Triage - Smart Meter Consumption Data UKPN.xlsx", "mimetype": "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "url": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-smart-meter-consumption-substation/attachments/data_triage_smart_meter_consumption_data_ukpnxlsx"}, {"id": "smart_meter_consumption_data_azure_blob_storagepdf", "title": "Smart Meter Consumption Data Azure Blob Storage.pdf", "mimetype": "application/pdf", "url": "https://ukpowernetworks.opendatasoft.com/api/v2/catalog/datasets/ukpn-smart-meter-consumption-substation/attachments/smart_meter_consumption_data_azure_blob_storagepdf"}], "alternative_exports": [], "data_visible": false, "fields": [{"name": "dataset_id", "description": "Unique dataset identifier", "annotations": {"facet": true}, "label": "dataset_id", "type": "text"}, {"name": "dno", "description": "Distribution Network Operator", "annotations": {}, "label": "dno", "type": "text"}, {"name": "dno_alias", "description": "Distribution Network Operator and Licence Area", "annotations": {}, "label": "dno_alias", "type": "text"}, {"name": "secondary_substation_id", "description": "Site reference", "annotations": {}, "label": "secondary_substation_id", "type": "text"}, {"name": "geopoint", "description": "Geo point (Latitude and Longitude) of secondary substation location.", "annotations": {}, "label": "geopoint", "type": "geo_point_2d"}, {"name": "aggregated_device_count_active", "description": "Number of Active Smart Meters", "annotations": {}, "label": "aggregated_device_count_active", "type": "int"}, {"name": "primary_consumption_active_import", "description": "Single Element meter aggregated value (Wh)", "annotations": {}, "label": "primary_consumption_active_import", "type": "int"}, {"name": "secondary_consumption_active_import", "description": "Twin or Dual Tariff meters where we have a secondary measurement - aggregated value (Wh)", "annotations": {}, "label": "secondary_consumption_active_import", "type": "int"}, {"name": "total_consumption_active_import", "description": "Sum of Primary and Secondary Consumption (Wh)", "annotations": {}, "label": "total_consumption_active_import", "type": "int"}, {"name": "aggregated_device_count_reactive", "description": null, "annotations": {}, "label": "aggregated_device_count_reactive", "type": "int"}, {"name": "total_consumption_reactive_import", "description": "Sum of Primary and Secondary Consumption (Wh)", "annotations": {}, "label": "total_consumption_reactive_import", "type": "int"}, {"name": "data_collection_log_timestamp", "description": "Interval read time", "annotations": {"timeserie_precision": "minute", "facet": true}, "label": "data_collection_log_timestamp", "type": "datetime"}, {"name": "insert_time", "description": "Record insertion timestamp", "annotations": {"facetsort": "-count", "timeserie_precision": "hour"}, "label": "insert_time", "type": "datetime"}, {"name": "last_modified_time", "description": "Last update of the record", "annotations": {}, "label": "last_modified_time", "type": "datetime"}], "metas": {"dcat": {"created": null, "issued": null, "creator": null, "contributor": null, "contact_name": null, "contact_email": null, "accrualperiodicity": null, "spatial": null, "temporal": null, "granularity": null, "dataquality": null, "publisher_type": null, "conforms_to": null, "temporal_coverage_start": null, "temporal_coverage_end": null, "accessRights": null, "relation": null}, "inspire": {"theme": null, "type": null, "file_identifier": null, "hierarchy_level": null, "hierarchy_level_name": null, "spatial_resolution": null, "topologic_consistency": null, "contact_individual_name": null, "contact_position": null, "contact_address": null, "contact_email": null, "identification_purpose": null, "extend_description": null, "extend_bounding_box_westbound_longitude": null, "extend_bounding_box_eastbound_longitude": null, "extend_bounding_box_southbound_latitude": null, "extend_bounding_box_northbound_latitude": null}, "default": {"title": "Smart Meter Consumption - Substation", "description": "<p></p><h2>Introduction</h2>\n<p>This dataset presents import aggregated consumption data from Smart Meter customers at the secondary substation level, along with the count of smart meters contributing to the aggregated half-hourly values.\u00a0</p><p>It includes both Active Energy Import and Reactive Energy Import readings.</p><p>The sample comprises 10,000 records drawn from aggregated smart meter data across our three operational regions: Eastern Power Networks (EPN), London Power Networks (LPN), and South Eastern Power Networks (SPN).\n<br>\n<br><b>\nTo access the historical data covering all sites, where there are more than 5 connected smart meters, please see the attached instructions or click <a href=\"https://ukpowernetworks.sharepoint.com/:b:/s/OpenDataPortalLibrary/IQCG3ZxUj3pQQZtW3sBI0imFATDAcU2YQlVkcks9T_VTCl4?e=1bxNZF\" target=\"_blank\"><u>here</u></a>.\n\n\n</b></p>\n\n<h2>Methodological Approach</h2><p>Primary consumption data for Active Energy Import is aggregated based on the number of active devices reporting during each half-hour period. If a device is unreachable during a given interval, its data is excluded from the aggregation to maintain accuracy.</p>\n<h2>Quality Control Statement</h2>\n<p>This dataset is being shared to provide an early preview of the type of data we intend to publish from all smart meters within our regions.\u00a0</p><p>We are conducting monthly validation checks to enhance data quality prior to releasing the full dataset.\u00a0</p><p>Users are advised to exercise caution when interpreting or utilizing this preliminary data.</p>\n\n<h2>Assurance Statement</h2>\n<p>The Smart Metering Team has reviewed the dataset to ensure consistency and accuracy in the presented data.</p>\n<h2>Other</h2>\n<p>Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: <a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\">Open Data Portal Glossary</a></p>\n<p>Download dataset information: <a href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/domain-dataset0/download/?format=json&amp;refine.identifier=ukpn-smart-meter-consumption-substation\" target=\"_blank\">Metadata (JSON)</a></p><p>To view this data please register and login.</p><p></p>", "theme": ["Network Usage"], "keyword": null, "license": "CC BY 4.0", "license_url": "https://creativecommons.org/licenses/by/4.0/", "language": "en", "metadata_languages": ["en"], "timezone": null, "modified": "2026-04-01T09:01:14.098000+00:00", "modified_updates_on_metadata_change": false, "modified_updates_on_data_change": true, "data_processed": "2026-04-01T09:01:14.098000+00:00", "metadata_processed": "2026-04-01T09:01:14.231000+00:00", "geographic_reference": null, "geographic_reference_auto": false, "territory": null, "geometry_types": ["Point"], "bbox": {"type": "Feature", "geometry": {"coordinates": [[[0.26054492220282555, 52.04380998853594], [-0.5216770805418491, 52.04380998853594], [-0.5216770805418491, 51.12489297520369], [0.26054492220282555, 51.12489297520369], [0.26054492220282555, 52.04380998853594]]], "type": "Polygon"}, "properties": {}}, "publisher": "UK Power Networks, Company number 3870728", "references": null, "records_count": 30000, "attributions": null, "source_domain": null, "source_domain_title": null, "source_domain_address": null, "source_dataset": null, "shared_catalog": null, "federated": false, "parent_domain": null, "update_frequency": ["MONTHLY"]}, "dublin-core": {"title": "Smart Meter Consumption - Substation", "alternative": null, "subject": ["Smart Meters", "Secondary Substation", "Low Voltage (LV)"], "description": "<p></p><h2>Introduction</h2>\n<p>This dataset presents import aggregated consumption data from Smart Meter customers at the secondary substation level, along with the count of smart meters contributing to the aggregated half-hourly values.\u00a0</p><p>It includes both Active Energy Import and Reactive Energy Import readings.</p><p>The sample comprises 10,000 records drawn from aggregated smart meter data across our three operational regions: Eastern Power Networks (EPN), London Power Networks (LPN), and South Eastern Power Networks (SPN).\n<br>\n<br><b>\nTo access the historical data covering all sites, where there are more than 5 connected smart meters, please see the attached instructions or click <a href=\"https://ukpowernetworks.sharepoint.com/:b:/s/OpenDataPortalLibrary/IQCG3ZxUj3pQQZtW3sBI0imFATDAcU2YQlVkcks9T_VTCl4?e=1bxNZF\" target=\"_blank\"><u>here</u></a>.\n\n\n</b></p>\n\n<h2>Methodological Approach</h2><p>Primary consumption data for Active Energy Import is aggregated based on the number of active devices reporting during each half-hour period. If a device is unreachable during a given interval, its data is excluded from the aggregation to maintain accuracy.</p>\n<h2>Quality Control Statement</h2>\n<p>This dataset is being shared to provide an early preview of the type of data we intend to publish from all smart meters within our regions.\u00a0</p><p>We are conducting monthly validation checks to enhance data quality prior to releasing the full dataset.\u00a0</p><p>Users are advised to exercise caution when interpreting or utilizing this preliminary data.</p>\n\n<h2>Assurance Statement</h2>\n<p>The Smart Metering Team has reviewed the dataset to ensure consistency and accuracy in the presented data.</p>\n<h2>Other</h2>\n<p>Definitions of key terms related to this dataset can be found in the Open Data Portal Glossary: <a href=\"https://ukpowernetworks.opendatasoft.com/pages/glossary/\" target=\"_blank\">Open Data Portal Glossary</a></p>\n<p>Download dataset information: <a href=\"https://ukpowernetworks.opendatasoft.com/explore/dataset/domain-dataset0/download/?format=json&amp;refine.identifier=ukpn-smart-meter-consumption-substation\" target=\"_blank\">Metadata (JSON)</a></p><p>To view this data please register and login.</p><p></p>", "abstract": null, "tableOfContent": null, "type": ["Dataset"], "language": ["eng"], "coverage": null, "spatial": "EPN = Eastern Power Networks; LPN = London Power Networks; SPN = South Eastern Power Networks", "temporal_start": null, "temporal_end": null, "relation": "https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-smart-meter-installation-volumes/information/?disjunctive.la_district_name; https://ukpowernetworks.opendatasoft.com/explore/dataset/ukpn-smart-meter-consumption-lv-feeder/information/", "source": "https://ukpowernetworks.opendatasoft.com/", "replaces": null, "references": null, "requires": null, "conformsTo": null, "hasFormat": null, "hasPart": null, "hasVersion": null, "isFormatOf": null, "isPartOf": null, "isVersionOf": null, "isReferencedBy": null, "isReplacedBy": null, "isRequiredBy": null, "contributor": null, "creator": "Smart DCC, Company Number 08641679", "publisher": "UK Power Networks, Company number 3870728", "rights": null, "accessRights": ["Open"], "license": "CC BY 4.0", "date_start": null, "date_end": null, "available_start": null, "available_end": null, "created": null, "dateAccepted": null, "dateCopyrighted": null, "dateSubmitted": null, "issued": "2024-03-13T00:00:00+00:00", "modified": "2026-04-01T09:01:14.098000+00:00", "valid_start": null, "valid_end": null, "format": ["text/csv", "application/vnd.ms-excel", "application/json"], "extent": null, "medium": null, "identifier": null, "bibliographicCitation": null, "rightsHolder": null, "accrualMethod": null, "accrualPeriodicity": null, "accrualPolicy": null, "audience": null, "educationLevel": null, "instructionalMethod": null, "mediator": null, "provenance": null}}}}