[konata_izumi_shell]

Hello DarkForums community,

I successfully breached the Gobierno Autonomo Departamental de Santa Cruz - TAJIBO of Bolivia, extracting a total of 28157 records from their institutional platform.

WHAT IS GOBIERNO AUTONOMO DEPARTAMENTAL DE SANTA CRUZ - TAJIBO?

It is an institutional platform used for the management, formulation, monitoring, execution and evaluation of the Annual Operating Plan (POA) of the Santa Cruz Governorate.
The system manages information related to the different units and officials involved in institutional planning, including responsables, administrative staff and analysts associated with organizational units.

LEAK DETAILS:

Type: Responsables - Records: 4195
Type: Administrative - Records: 4184
Type: Analysts - Records: 19778
TOTAL: 28157

INFORMATION INCLUDED:

The records include:
- Full names of officials
- Job positions held
- ID numbers (Cedula de Identidad)
- Phone numbers
- Organizational units
- Employment periods (start/end dates)
- Internal system identifiers

HEADERS:
num_sec, tipo, nsec_organigrama, fecha_inicio, fecha_fin, nsec_usuario, ci, nombre, cargo, telefono, estado, session_db, observacion, nombre_uo

Example:

administrativo.sql:

INSERT INTO empleados VALUES (47, 'administrativo', 101, NULL, NULL, 89, '7810283', 'Suleide Justiniano Rojas', 'Profesional Experto - Planificacion', '70294580', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (2416, 'administrativo', 10323, '2024-07-11 00:00:00', '2024-11-11 00:00:00', 6, 'x', 'Rudy Montenegro Saucedo', 'Profesional Experto del Servicio Departamental de Coordinación Territorial (SER-DCT)', 'x', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (144, 'administrativo', 104, NULL, NULL, 441, NULL, 'Carmiña Landivar Ribera', 'Profesional 1', '3636101', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (133, 'administrativo', 105, NULL, NULL, 323, '5407275', 'Ana Graciela Barbosa Montero', 'Tecnico 2', '69220175', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (120, 'administrativo', 106, NULL, NULL, 79, '8146997', 'Lic. Marco A. Orjeda Justiniano', 'Profesional IV', '79005930', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (127, 'administrativo', 107, '2022-08-08 00:00:00', NULL, 317, '2960103', 'Dianne Evelyn Anglarill Gutiérrez', 'Responsable 1', '3636123', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (113, 'administrativo', 108, '2022-08-08 00:00:00', NULL, 12, '4730919', 'Carla Patricia Rengel Estrella', 'Profesional 1', '6649', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (2417, 'administrativo', 10810, NULL, NULL, 6, 'x', 'Lic. Betzabeth Andres Santiesteban', 'Profesional - 1 - Dirección de Gestión Territorial Indígena', 'x', 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (90, 'administrativo', 109, '2023-01-01 00:00:00', NULL, 13, '4508195', 'LIC. MARIBEL VALLEJOS JALDIN', 'PROFESIONAL EXPERTO', NULL, 'AC', '0', 'S/N', NULL);
INSERT INTO empleados VALUES (2418, 'administrativo', 10916, NULL, NULL, 6, 'x', 'NORMA MEDINACELI MENDOZA', 'ADMINISTRADORA SEDEPOS', 'x', 'AC', '0', 'S/N', NULL);

responsable.sql:

INSERT INTO empleados VALUES (47, 'responsable', 101, '2022-02-04 00:00:00', NULL, 89, NULL, 'Abg. Luis Andres Nuñez', 'Oficial Mayor Asamblea Legislativa Departamental', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (2392, 'responsable', 10323, '2024-07-11 00:00:00', '2024-11-11 00:00:00', 6, 'x', 'Maria Del Carmen Morales Vda De Prado', 'Directora del Servicio Departamental de Coordinación Territorial (SER-DCT)', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (148, 'responsable', 104, NULL, NULL, 441, '0000000000', 'Pablo Enrique Galvan Ribera', 'Profesional Experto - Dirección de Despacho', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (134, 'responsable', 105, NULL, NULL, 323, '0000', 'Noelia Gutierrez Menacho', 'Directora de Protocolo', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (119, 'responsable', 106, '2022-10-08 00:00:00', NULL, 2, '3235448', 'Arq. Mario Aguilera Cirbian', 'Vicegobernador', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (127, 'responsable', 107, '2022-08-08 00:00:00', NULL, 6, '1504483', 'Maria del Carmen Ribera de Matkovic', 'Directora', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (114, 'responsable', 108, '2022-08-08 00:00:00', NULL, 6, 'xx', 'Cesar Ernesto Suarez Alberti', 'Director General', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (2393, 'responsable', 10810, NULL, NULL, 6, 'x', 'Sr. Rony Yachimba Segundo', 'Director de Gestión Territorial Indígena', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (92, 'responsable', 109, '2023-01-01 00:00:00', NULL, 13, '5345222', 'LIC. GERMAN DAZA GARCIA', 'AUDITOR GENERAL', NULL, NULL, '0', 'S/N', NULL);
INSERT INTO empleados VALUES (2394, 'responsable', 10916, NULL, NULL, 6, 'x', 'NAIR STIVEN SANCHEZ OROZCO', 'DIRECTOR(A) SEDEPOS', NULL, NULL, '0', 'S/N', NULL);

analista.sql:

INSERT INTO empleados VALUES (9, 'analista', 10, '2022-01-01 00:00:00', '2022-01-12 00:00:00', 1, NULL, 'MARIELA GONZALES VARGAS', NULL, '78445002', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (99, 'analista', 100, '2022-01-01 00:00:00', '2022-01-12 00:00:00', 1, NULL, 'LIZ MARGOT SALOMA GOROSTIAGA', NULL, '65068665', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (990, 'analista', 1000, '2023-01-01 00:00:00', NULL, 1, NULL, 'FLAVIA ARIANE ARIAS ROMERO', NULL, '70825005', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (10150, 'analista', 10000, '2024-01-01 00:00:00', NULL, 1, NULL, 'CARMELO ORLANDO LENS EGUEZ', NULL, '75558969', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (10151, 'analista', 10001, '2024-01-01 00:00:00', NULL, 1, NULL, 'CARMELO ORLANDO LENS EGUEZ', NULL, '75558969', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (10152, 'analista', 10002, '2024-01-01 00:00:00', NULL, 1, NULL, 'CARMELO ORLANDO LENS EGUEZ', NULL, '75558969', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (10153, 'analista', 10003, '2024-01-01 00:00:00', NULL, 1, NULL, 'MARIA CAROL DORADO BARRERA', NULL, '78411073', NULL, NULL, NULL, NULL);
INSERT INTO empleados VALUES (10154, 'analista', 10004, '2024-01-01 00:00:00', NULL, 1, NULL, 'MARIA CAROL DORADO BARRERA', NULL, '78411073', NULL, NULL, NULL, NULL);

DOWNLOAD LINKS:

administrativo.sql (4184 records)
https://anonfilesnew.com/s/Wt7ovrbxglU
analista.sql (19778 records)
https://anonfilesnew.com/s/TqKyNOlwVe3
responsable.sql (4195 records)
https://anonfilesnew.com/s/yjk-iJ6qLWT

By: konata_izumi_shell