Data Dictionary

Column Type Label Description
DISTRICT_SHORT_CODE text DISTRICT_SHORT_CODE
REPORTING_YEAR numeric REPORTING_YEAR
DISTRICT_CODE numeric DISTRICT_CODE
REFERENCE_NUMBER text REFERENCE_NUMBER
LV_INCIDENT_TIME timestamp LV_INCIDENT_TIME
NRN_NORTH text NRN_NORTH
PRIMARY_NRN numeric PRIMARY_NRN
CATEGORY_CODE numeric CATEGORY_CODE
CATEGORY_DESCRIPTION text CATEGORY_DESCRIPTION
EQUIPMENT_CODE text EQUIPMENT_CODE
EQUIPMENT_DESCRIPTION text EQUIPMENT_DESCRIPTION
COMPONENT_CODE text COMPONENT_CODE
COMPONENT_DESCRIPTION text COMPONENT_DESCRIPTION
CAUSE_CODE text CAUSE_CODE
CAUSE_DESCRIPTION text CAUSE_DESCRIPTION
DAMAGE numeric DAMAGE
EXCEPTIONAL_EVENT numeric EXCEPTIONAL_EVENT
LV_CUST_AFF numeric LV_CUST_AFF
LV_CUST_MINS_LOST numeric LV_CUST_MINS_LOST
AVG_TIME_OFF_MINS numeric AVG_TIME_OFF_MINS

Additional Information

Field Value
Data last updated April 14, 2026
Metadata last updated April 14, 2026
Created unknown
Format CSV
License Creative Commons Attribution 4.0
Type Data
Geospatial data No
Schema fields { "fields": [ { "description": "4-letter short code identifying the district", "example": "SWIN", "name": "DISTRICT_SHORT_CODE", "title": "District Short Code", "type": "string" }, { "description": "The reporting year for the incident", "example": "2025", "name": "REPORTING_YEAR", "title": "Reporting Year", "type": "integer" }, { "description": "Numeric code identifying the district", "example": "55", "name": "DISTRICT_CODE", "title": "District Code", "type": "string" }, { "description": "Unique reference number for the incident", "example": "0000247", "name": "REFERENCE_NUMBER", "title": "Reference Number", "type": "string" }, { "description": "Date and time the incident was reported, formatted as dd/MM/yyyy HH:mm", "example": "30/07/2025 04:12", "name": "LV_INCIDENT_TIME", "title": "LV Incident Time", "type": "timestamp" }, { "description": "NRN for SHEPD, formatted as PRIMARY_HV_TX_LV separated by underscores with 3-digit primary NRN", "example": "311_002_170_01", "name": "NRN_NORTH", "title": "NRN North", "type": "string" }, { "description": "The primary NRN", "example": "311", "name": "PRIMARY_NRN", "title": "Primary NRN", "type": "integer" }, { "description": "Category code for the incident", "example": "2", "name": "CATEGORY_CODE", "title": "Category Code", "type": "integer" }, { "description": "Description of the category code", "example": "Cables", "name": "CATEGORY_DESCRIPTION", "title": "Category Description", "type": "string" }, { "description": "Code identifying the type of equipment involved in the incident", "example": "42", "name": "EQUIPMENT_CODE", "title": "Equipment Code", "type": "string" }, { "description": "Description of the equipment", "example": "Consac", "name": "EQUIPMENT_DESCRIPTION", "title": "Equipment Description", "type": "string" }, { "description": "Code identifying the component involved in the incident", "example": "X", "name": "COMPONENT_CODE", "title": "Component Code", "type": "string" }, { "description": "Description of the component", "example": "No component identified", "name": "COMPONENT_DESCRIPTION", "title": "Component Description", "type": "string" }, { "description": "Code identifying the cause of the incident", "example": "A1", "name": "CAUSE_CODE", "title": "Cause Code", "type": "string" }, { "description": "Description of the cause", "example": "Cause Unknown", "name": "CAUSE_DESCRIPTION", "title": "Cause Description", "type": "string" }, { "description": "Flag indicating whether damage occurred (1=damage, 0=no damage)", "example": "0", "name": "DAMAGE", "title": "Damage", "type": "string" }, { "description": "Flag indicating whether the incident was part of an exceptional event", "example": "null", "name": "EXCEPTIONAL_EVENT", "title": "Exceptional Event", "type": "string" }, { "description": "Number of customers affected by the incident", "example": "38", "name": "LV_CUST_AFF", "title": "LV Customers Affected", "type": "integer" }, { "description": "Total customer minutes lost due to the incident, rounded to the nearest whole number", "example": "1817", "name": "LV_CUST_MINS_LOST", "title": "LV Customer Minutes Lost", "type": "integer" }, { "description": "Average time off supply in minutes. Calculated by dividing total minutes lost by number of customers affected, rounded to nearest minute", "example": "5", "name": "AVG_TIME_OFF_MINS", "title": "Average Time Off Supply (Minutes)", "type": "integer" } ] }
Datastore last updated 2026-04-14T18:33:39.066007
Created2 months ago
Media typetext/csv
Size7,840,220
Datastore activeTrue
Has viewsTrue
Hashd5e2d276aa009b8a9164d0408c433fdd
Id5cbadbb2-e626-44c4-9593-171d3990c91d
Is geospatialFalse
Last datastore modified1 month ago
Package idd4bef750-1c3c-494c-b754-558c6f99d8c1
Position1
PreviewTrue
Preview rows42,547
Resource typeregular
Schema{'fields': [{'description': '4-letter short code identifying the district', 'example': 'SWIN', 'name': 'DISTRICT_SHORT_CODE', 'title': 'District Short Code', 'type': 'string'}, {'description': 'The reporting year for the incident', 'example': '2025', 'name': 'REPORTING_YEAR', 'title': 'Reporting Year', 'type': 'integer'}, {'description': 'Numeric code identifying the district', 'example': '55', 'name': 'DISTRICT_CODE', 'title': 'District Code', 'type': 'string'}, {'description': 'Unique reference number for the incident', 'example': '0000247', 'name': 'REFERENCE_NUMBER', 'title': 'Reference Number', 'type': 'string'}, {'description': 'Date and time the incident was reported, formatted as dd/MM/yyyy HH:mm', 'example': '30/07/2025 04:12', 'name': 'LV_INCIDENT_TIME', 'title': 'LV Incident Time', 'type': 'timestamp'}, {'description': 'NRN for SHEPD, formatted as PRIMARY_HV_TX_LV separated by underscores with 3-digit primary NRN', 'example': '311_002_170_01', 'name': 'NRN_NORTH', 'title': 'NRN North', 'type': 'string'}, {'description': 'The primary NRN', 'example': '311', 'name': 'PRIMARY_NRN', 'title': 'Primary NRN', 'type': 'integer'}, {'description': 'Category code for the incident', 'example': '2', 'name': 'CATEGORY_CODE', 'title': 'Category Code', 'type': 'integer'}, {'description': 'Description of the category code', 'example': 'Cables', 'name': 'CATEGORY_DESCRIPTION', 'title': 'Category Description', 'type': 'string'}, {'description': 'Code identifying the type of equipment involved in the incident', 'example': '42', 'name': 'EQUIPMENT_CODE', 'title': 'Equipment Code', 'type': 'string'}, {'description': 'Description of the equipment', 'example': 'Consac', 'name': 'EQUIPMENT_DESCRIPTION', 'title': 'Equipment Description', 'type': 'string'}, {'description': 'Code identifying the component involved in the incident', 'example': 'X', 'name': 'COMPONENT_CODE', 'title': 'Component Code', 'type': 'string'}, {'description': 'Description of the component', 'example': 'No component identified', 'name': 'COMPONENT_DESCRIPTION', 'title': 'Component Description', 'type': 'string'}, {'description': 'Code identifying the cause of the incident', 'example': 'A1', 'name': 'CAUSE_CODE', 'title': 'Cause Code', 'type': 'string'}, {'description': 'Description of the cause', 'example': 'Cause Unknown', 'name': 'CAUSE_DESCRIPTION', 'title': 'Cause Description', 'type': 'string'}, {'description': 'Flag indicating whether damage occurred (1=damage, 0=no damage)', 'example': '0', 'name': 'DAMAGE', 'title': 'Damage', 'type': 'string'}, {'description': 'Flag indicating whether the incident was part of an exceptional event', 'example': 'null', 'name': 'EXCEPTIONAL_EVENT', 'title': 'Exceptional Event', 'type': 'string'}, {'description': 'Number of customers affected by the incident', 'example': '38', 'name': 'LV_CUST_AFF', 'title': 'LV Customers Affected', 'type': 'integer'}, {'description': 'Total customer minutes lost due to the incident, rounded to the nearest whole number', 'example': '1817', 'name': 'LV_CUST_MINS_LOST', 'title': 'LV Customer Minutes Lost', 'type': 'integer'}, {'description': 'Average time off supply in minutes. Calculated by dividing total minutes lost by number of customers affected, rounded to nearest minute', 'example': '5', 'name': 'AVG_TIME_OFF_MINS', 'title': 'Average Time Off Supply (Minutes)', 'type': 'integer'}]}
Stateactive
Total record count42,547
Url typeupload