Elecnor Group Database
Nov 2023
In November 2023, the Spanish leading corporation in the field of services and project development, construction and operation Elecnor Group (https://www.elecnor.com/) suffered a data breach exposed over 1.8 million clients and records containing , email addresses, names, phone numbers, physical addresses,policies and tariffs.This was breached by @Ddarknotevil
Leaked Information:
Email
Phone
Full Name
Address
User Name
Gender
We have loaded this breach into our database.
File List:
File Content Sample:
INSERT INTO `ele_operaciones` (`id`, `anyo`, `tipooperacion`, `operacion`, `operacion_cp`, `op_cambio`, `cambio_operacion_id`, `contrata`, `zona_id`, `zona`, `sociedad`, `lote`, `lote_corto`, `claseinstalacion_id`, `lote_estado_id`, `tipo_elemento`, `tipo_seleccion`, `tarifa`, `tipotarifa_id`, `elemento_estado_id`, `elemento`, `poliza`, `operacion_estado_id`, `puntosuministro_estado_id`, `provincia_id`, `municipio_id`, `codigo_postal`, `via`, `calle`, `numero`, `anexo`, `escalera`, `piso`, `puerta`, `gps_latitud`, `gps_longitud`, `sr`, `fecha_sr`, `fecha_sr_1visita`, `fecha_sr_visita_efectiva`, `tipovisita_id`, `tipoinstalacion_id`, `nombre_cliente`, `apellido1_cliente`, `apellido2_cliente`, `telefono`, `telefono_nuevo`, `nombre_contacto`, `apellido1_contacto`, `apellido2_contacto`, `direccion_contacto`, `telefono_contacto`, `aviso`, `fecha_ultima_inspeccion`, `fecha_min_ejecucion`, `fecha_max_ejecucion`, `fecha_min_concertacion`, `fecha_max_concertacion`, `fecha_visita_elemento`, `fecha_ip`, `fecha_ip_complementaria`, `fecha_exclusion_lote`, `team_contrata`, `contrata_id`, `archivo`, `archivo_copit`, `tipooperacion_id`, `created_at`, `updated_at`, `updated_user_at`, `updated_user_id`, `user_id`, `fecha_visita`, `franja_id`, `resultado_id`, `fecha_resolucion`, `cambio_contador`, `cambio_franja_id`, `cambio_user_id`, `fecha_descarga`, `orden_ruta`, `region`, `region_h`, `fecha_visita_prev`, `agenda_visita_id`, `agenda_2visita_id`, `baja_administrativa`, `baja_upload`) VALUES
(101478722, '2023', NULL, '15066353', '15066353', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-C2', '320-C2', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010132699621AW', '', 1, NULL, 1, 10, '08290', '', 'PG CORDELLES', '11', '', '', '3', '4', NULL, NULL, '', NULL, NULL, NULL, 0, 3, 'ANTONIO GIBERT GORCHS', '', '', '689326290', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-15', '2023-12-15', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:01:09', NULL, NULL, 25, '2023-05-19 09:00:00', 5, NULL, NULL, 0, NULL, NULL, NULL, 108, '42', NULL, NULL, NULL, NULL, 0, NULL),
(101478723, '2023', NULL, '15066128', '15066128', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '318-A2', '318-A2', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0230010000490290AS', '', 1, NULL, 1, 6, '08028', '', 'ARIZALA', '5', '', '', 'BJ', 'LOCAL', NULL, NULL, '', NULL, NULL, NULL, 0, 3, 'AYAR ALINTER., SAL', '', '', '999999999', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', NULL, '2023-05-02 15:01:09', '2023-07-18 11:35:39', NULL, NULL, 25, '2023-08-02 17:00:00', 8, NULL, NULL, 0, NULL, NULL, NULL, 617, '42', NULL, NULL, NULL, NULL, 0, NULL),
(101478724, '2023', NULL, '15066339', '15066339', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-D4', '320-D4', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010145260023HN', '', 1, NULL, 1, 295, '08800', '', 'PL SOLER CARBONELL', '23', '', '', '2', '1', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'ISABEL CABEZAS MUÑOZ', '', '', '938152728', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:23:07', NULL, NULL, 240, '2023-05-19 12:00:00', 9, NULL, NULL, 0, NULL, NULL, NULL, 406, 'osanchezp', NULL, NULL, NULL, NULL, 0, NULL),
(101478725, '2023', NULL, '15066844', '15066844', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '318-A2', '318-A2', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010014216812RZ', '', 1, NULL, 1, 6, '08028', '', 'RIERA BLANCA', '101', '', '', '5', '3', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'ROGELIA MEDINA FLORIAN', '', '', '636163558', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', NULL, '2023-05-02 15:01:09', '2023-07-18 11:35:37', NULL, NULL, 25, '2023-08-04 11:00:00', 10, NULL, NULL, 0, NULL, NULL, NULL, 310, '42', NULL, NULL, NULL, NULL, 0, NULL),
(101478726, '2023', NULL, '15066475', '15066475', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-D4', '320-D4', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010144261093XH', '', 1, NULL, 1, 295, '08800', '', 'JOSEP COROLEU', '105', '', '', '3', '1', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'ISIDRO ARNAEZ GIL', '', '', '938150647', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:23:06', NULL, NULL, 159, '2023-05-19 09:00:00', 5, NULL, NULL, 0, NULL, NULL, NULL, 113, '60', NULL, NULL, NULL, NULL, 0, NULL),
(101478727, '2023', NULL, '15066327', '15066327', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-D4', '320-D4', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010144554660DJ', '', 1, NULL, 1, 295, '08800', '', 'AV FRANCESC MACIA', '64', '', '', '5', '2', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'VICTOR BOSQUET TORRABADELL', '', '', '938933540', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:23:06', NULL, NULL, 202, '2023-05-19 11:00:00', 10, NULL, NULL, 0, NULL, NULL, NULL, 313, '66', NULL, NULL, NULL, NULL, 0, NULL),
(101478722, '2023', NULL, '15066353', '15066353', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-C2', '320-C2', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010132699621AW', '', 1, NULL, 1, 10, '08290', '', 'PG CORDELLES', '11', '', '', '3', '4', NULL, NULL, '', NULL, NULL, NULL, 0, 3, 'ANTONIO GIBERT GORCHS', '', '', '689326290', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-15', '2023-12-15', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:01:09', NULL, NULL, 25, '2023-05-19 09:00:00', 5, NULL, NULL, 0, NULL, NULL, NULL, 108, '42', NULL, NULL, NULL, NULL, 0, NULL),
(101478723, '2023', NULL, '15066128', '15066128', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '318-A2', '318-A2', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0230010000490290AS', '', 1, NULL, 1, 6, '08028', '', 'ARIZALA', '5', '', '', 'BJ', 'LOCAL', NULL, NULL, '', NULL, NULL, NULL, 0, 3, 'AYAR ALINTER., SAL', '', '', '999999999', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', NULL, '2023-05-02 15:01:09', '2023-07-18 11:35:39', NULL, NULL, 25, '2023-08-02 17:00:00', 8, NULL, NULL, 0, NULL, NULL, NULL, 617, '42', NULL, NULL, NULL, NULL, 0, NULL),
(101478724, '2023', NULL, '15066339', '15066339', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-D4', '320-D4', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010145260023HN', '', 1, NULL, 1, 295, '08800', '', 'PL SOLER CARBONELL', '23', '', '', '2', '1', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'ISABEL CABEZAS MUÑOZ', '', '', '938152728', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:23:07', NULL, NULL, 240, '2023-05-19 12:00:00', 9, NULL, NULL, 0, NULL, NULL, NULL, 406, 'osanchezp', NULL, NULL, NULL, NULL, 0, NULL),
(101478725, '2023', NULL, '15066844', '15066844', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '318-A2', '318-A2', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010014216812RZ', '', 1, NULL, 1, 6, '08028', '', 'RIERA BLANCA', '101', '', '', '5', '3', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'ROGELIA MEDINA FLORIAN', '', '', '636163558', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', '9f139513-db5c-4d85-9d91-d497e89311b1.xlsx', NULL, '2023-05-02 15:01:09', '2023-07-18 11:35:37', NULL, NULL, 25, '2023-08-04 11:00:00', 10, NULL, NULL, 0, NULL, NULL, NULL, 310, '42', NULL, NULL, NULL, NULL, 0, NULL),
(101478726, '2023', NULL, '15066475', '15066475', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-D4', '320-D4', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010144261093XH', '', 1, NULL, 1, 295, '08800', '', 'JOSEP COROLEU', '105', '', '', '3', '1', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'ISIDRO ARNAEZ GIL', '', '', '938150647', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:23:06', NULL, NULL, 159, '2023-05-19 09:00:00', 5, NULL, NULL, 0, NULL, NULL, NULL, 113, '60', NULL, NULL, NULL, NULL, 0, NULL),
(101478727, '2023', NULL, '15066327', '15066327', 0, NULL, '', 1, 'CATALUNYA', 'NEDGIA CATALUNYA, S.A.', '320-D4', '320-D4', 1, 1, 'CUPS', 'VENCIMIENTO', 'TARIFA 3.1 PEAJE ATR GAS NATURAL-DEFECTO', 1, 6, 'ES0217010144554660DJ', '', 1, NULL, 1, 295, '08800', '', 'AV FRANCESC MACIA', '64', '', '', '5', '2', NULL, NULL, '', NULL, NULL, NULL, 0, 2, 'VICTOR BOSQUET TORRABADELL', '', '', '938933540', NULL, '', '', '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2023-05-01', '2023-12-01', NULL, 'ELECNOR CATALUNYA', 1, 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', 'b323e913-0a65-4542-9417-57d4ba466fcc.xlsx', NULL, '2023-05-02 15:01:09', '2023-05-02 15:23:06', NULL, NULL, 202, '2023-05-19 11:00:00', 10, NULL, NULL, 0, NULL, NULL, NULL, 313, '66', NULL, NULL, NULL, NULL, 0, NULL),