Smart Meter LV Feeder Data
URL: https://gql.internal.datopian.com/v1/
Explore Smart Meter LV Feeder data:
- Start with the lookup tool to identify your LV Feeder Dataset ID. You can enter your postcode to find the associated Dataset ID.
- Switch to the second tab where you can preview the actual data. You can use filtering functionality to get only a subset of the larger data table. Use your Dataset ID number here.
-
Explore the data relevant to your LV Feeder Dataset. You can also download it to conduct further analysis in your own tool.
-
If the data you are looking for is older than 365 days, you can browse raw data files available in the third tab. All data is stored as flat files and organized by date so that you can find and download specific data files in CSV format.
There are no views created for this resource yet.
Additional Information
| Field | Value |
|---|---|
| Data last updated | December 11, 2025 |
| Metadata last updated | December 11, 2025 |
| Created | unknown |
| Format | Big Data |
| License | Creative Commons Attribution 4.0 |
| Type | Data |
| Geospatial data | No |
| Schema fields | { "fields": [ { "description": "A 12-digit network reference number uniquely identifying the electricity route from the primary substation to each property. The format: 4 digits (Primary Substation) + 3 digits (High Voltage Substation) + 3 digits (Secondary Substation) + 2 digits (Low Voltage Feeder).", "example": "1234 300 123 12", "name": "dataset_id", "title": "Dataset ID", "type": "string" }, { "description": "The full name of the Distribution Network Operator (DNO).", "example": "Scottish and Southern Electricity Networks", "name": "dno_name", "title": "DNO Name", "type": "string" }, { "description": "The shorthand or abbreviated name of the DNO.", "example": "SSEN", "name": "dno_alias", "title": "DNO Alias", "type": "string" }, { "description": "The unique identifier of the secondary substation, extracted from the third section (3 digits) of the dataset_id.", "example": "300", "name": "secondary_substation_id", "title": "Secondary Substation ID", "type": "string" }, { "description": "The given name of the secondary substation, typically referring to a road or landmark nearby.", "example": "High Street Substation", "name": "secondary_substation_name", "title": "Secondary Substation Name", "type": "string" }, { "description": "The unique identifier of the low voltage (LV) feeder, extracted from the last two digits of the dataset_id.", "example": "12", "name": "lv_feeder_id", "title": "LV Feeder ID", "type": "string" }, { "description": "The given name of the LV feeder, typically referring to a nearby road or landmark.", "example": "Oak Road Feeder", "name": "lv_feeder_name", "title": "LV Feeder Name", "type": "string" }, { "description": "The latitude and longitude coordinates of the secondary substation (may be omitted for security reasons).", "example": "51.5074, -0.1278", "name": "substation_geo_location", "title": "Substation Geo Location", "type": "string" }, { "description": "Total number of smart meters from which data was collected for the given row. This number may fluctuate based on available data.", "example": "158", "name": "aggregated_device_count_active", "title": "Aggregated Device Count Active", "type": "integer" }, { "description": "Total watt-hours (Wh) consumed, summed from individual smart meters via the primary measuring element of the electricity meter.", "example": "125600", "name": "primary_consumption_active_import", "title": "Primary Consumption Active Import", "type": "integer" }, { "description": "Total watt-hours (Wh) consumed, summed from individual smart meters via the secondary measuring element (if present).", "example": "123000", "name": "secondary_consumption_active_import", "title": "Secondary Consumption Active Import", "type": "integer" }, { "description": "The total watt-hours (Wh) consumed across all included smart meters.", "example": "248600", "name": "total_consumption_active_import", "title": "Total Consumption Active Import", "type": "integer" }, { "description": "The total reactive energy (Wh) imported, summed from all individual smart meter readings.", "example": "52000", "name": "total_consumption_reactive_import", "title": "Total Consumption Reactive Import", "type": "integer" }, { "description": "The timestamp marking the end of the half-hour period during which consumption was measured, in UTC time format (ISO 8601).", "example": "2024-09-16T15:00:00Z", "name": "data_collection_log_timestamp", "title": "Data Collection Log Timestamp", "type": "datetime" }, { "description": "A unique identifier for the secondary substation, corresponding to the third section (3 digits) of dataset_id.", "example": "300", "name": "secondary_substation_unique_id", "title": "Secondary Substation Unique ID", "type": "string" }, { "description": "A unique identifier for the low voltage feeder, corresponding to the last section (2 digits) of dataset_id.", "example": "12", "name": "lv_feeder_unique_id", "title": "LV Feeder Unique ID", "type": "string" } ] } |
| Datastore last updated | |
| Created | 2 years ago |
| Datastore active | False |
| Has views | False |
| Id | 1cce1fb4-d7f4-4309-b9e3-943bd4d18618 |
| Is geospatial | False |
| Package id | 127bc139-0f47-499b-b6d7-19d66cdaf595 |
| Position | 0 |
| Resource type | regular |
| Schema | {'fields': [{'description': 'A 12-digit network reference number uniquely identifying the electricity route from the primary substation to each property. The format: 4 digits (Primary Substation) + 3 digits (High Voltage Substation) + 3 digits (Secondary Substation) + 2 digits (Low Voltage Feeder).', 'example': '1234 300 123 12', 'name': 'dataset_id', 'title': 'Dataset ID', 'type': 'string'}, {'description': 'The full name of the Distribution Network Operator (DNO).', 'example': 'Scottish and Southern Electricity Networks', 'name': 'dno_name', 'title': 'DNO Name', 'type': 'string'}, {'description': 'The shorthand or abbreviated name of the DNO.', 'example': 'SSEN', 'name': 'dno_alias', 'title': 'DNO Alias', 'type': 'string'}, {'description': 'The unique identifier of the secondary substation, extracted from the third section (3 digits) of the dataset_id.', 'example': '300', 'name': 'secondary_substation_id', 'title': 'Secondary Substation ID', 'type': 'string'}, {'description': 'The given name of the secondary substation, typically referring to a road or landmark nearby.', 'example': 'High Street Substation', 'name': 'secondary_substation_name', 'title': 'Secondary Substation Name', 'type': 'string'}, {'description': 'The unique identifier of the low voltage (LV) feeder, extracted from the last two digits of the dataset_id.', 'example': '12', 'name': 'lv_feeder_id', 'title': 'LV Feeder ID', 'type': 'string'}, {'description': 'The given name of the LV feeder, typically referring to a nearby road or landmark.', 'example': 'Oak Road Feeder', 'name': 'lv_feeder_name', 'title': 'LV Feeder Name', 'type': 'string'}, {'description': 'The latitude and longitude coordinates of the secondary substation (may be omitted for security reasons).', 'example': '51.5074, -0.1278', 'name': 'substation_geo_location', 'title': 'Substation Geo Location', 'type': 'string'}, {'description': 'Total number of smart meters from which data was collected for the given row. This number may fluctuate based on available data.', 'example': '158', 'name': 'aggregated_device_count_active', 'title': 'Aggregated Device Count Active', 'type': 'integer'}, {'description': 'Total watt-hours (Wh) consumed, summed from individual smart meters via the primary measuring element of the electricity meter.', 'example': '125600', 'name': 'primary_consumption_active_import', 'title': 'Primary Consumption Active Import', 'type': 'integer'}, {'description': 'Total watt-hours (Wh) consumed, summed from individual smart meters via the secondary measuring element (if present).', 'example': '123000', 'name': 'secondary_consumption_active_import', 'title': 'Secondary Consumption Active Import', 'type': 'integer'}, {'description': 'The total watt-hours (Wh) consumed across all included smart meters.', 'example': '248600', 'name': 'total_consumption_active_import', 'title': 'Total Consumption Active Import', 'type': 'integer'}, {'description': 'The total reactive energy (Wh) imported, summed from all individual smart meter readings.', 'example': '52000', 'name': 'total_consumption_reactive_import', 'title': 'Total Consumption Reactive Import', 'type': 'integer'}, {'description': 'The timestamp marking the end of the half-hour period during which consumption was measured, in UTC time format (ISO 8601).', 'example': '2024-09-16T15:00:00Z', 'name': 'data_collection_log_timestamp', 'title': 'Data Collection Log Timestamp', 'type': 'datetime'}, {'description': 'A unique identifier for the secondary substation, corresponding to the third section (3 digits) of dataset_id.', 'example': '300', 'name': 'secondary_substation_unique_id', 'title': 'Secondary Substation Unique ID', 'type': 'string'}, {'description': 'A unique identifier for the low voltage feeder, corresponding to the last section (2 digits) of dataset_id.', 'example': '12', 'name': 'lv_feeder_unique_id', 'title': 'LV Feeder Unique ID', 'type': 'string'}]} |
| State | active |